How to track your finances with Excel


Tired of not being able to keep track of your finances? Need an easy way to track your money on your computer? This is the article for you! Learn how to keep track of your money and thus budget your money using an Excel spreadsheet. Never miss a bill again and be fully aware of where all your money is going!

Things You'll Need

  • Computer
  • Blank Excel Spreadsheet
  • Receipts/bills for the last 1-2 months
  • Collect all of your bills/receipts for the last 1-2 months. This will give you an idea of where all of your money is going.

  • Open a blank Excel spreadsheet.

  • In Column A, list each bill that you have. Put one bill per cell and create one column in this fashion. For example, you could have mortgage/rent, utilities, water, phone bill, gas, food, fun money, etc.

  • In Column B, put in approximately how much you pay for each bill every month (put the correct amount next to each bill). At the bottom of the B column, use the "Auto sum" symbol. The total at the bottom will be the amount that you spend each month. Hopefully, it is less than you make!

  • In Column C, enter the current month; In column D, the next month; Column E, the next month, etc.

  • Every month, keep track of all your bills as you pay them. That way, you will know what bills are still coming up due and what you have not paid yet. This will also show you when you are overspending and where you can cut back.

Tips & Warnings

  • An easy way to save money is to add a line in Column A for savings. Treat it like a bill, and always transfer that amount of money into a savings account!
Promoted By Zergnet


You May Also Like

Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!