How to Make a Spreadsheet That Keeps Track of Expenses

How to Make a Spreadsheet That Keeps Track of Expenses

Spreadsheets can be used to track and monitor revenues and expenses. You can create budget templates and track all monies spent for small, medium and large sized businesses. You can also use spreadsheets to track personal expenses for items such as checks paid, credit card debt and personal bank loans. By adding formulas to a spreadsheet you can build automatic calculations into the template and easily review and track expenses against established budgets.

Monitor Your Finances

Create Expense Fields Open a blank spreadsheet. Type line item expense category names in Column A. For example, for personal items you could type “Telephone”, “Groceries” and “Clothing”. Type a single item name on a single row down Column A.

Create Tracking Dates Type the name of each month starting with “January” across the top of the spreadsheet beginning with Column B and Row 1 (B1) to track monthly expenses. Type the field header “Total Spent” in cell N1.

Set Limits Type the field header “Annual Budget” in cell O1. Input financial expense limits for each expense category in cell O2 on the spreadsheet. Type a budget or expense limit for each category. Type the field header “Spent vs. Budget” in cell P1.

Build in Formulas Input “=SUM(B2:M2)” in cell N2 to track total monies spent for the first category January through December. Copy and paste the formula down column N for all expense categories.

Type “=O2-N2” in cell P2 to track current spend against the set budget. Copy and paste the formula down column P for all expense categories.

Monitor Monthly Expenses Against the Budget At the start of each month input the amount of money to the cents that you spent for each expense category. Review the formulaic updates in Column P that automatically calculate and show how your expenses are tracking against your annual budget.