How to Make a Spreadsheet That Keeps Track of Expenses

by Rhonda Campbell ; Updated September 11, 2015

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 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.

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.

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.

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.

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.

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.

About the Author

Rhonda Campbell is an entrepreneur, radio host and author. She has more than 17 years of business, human resources and project management experience and decades of book, newspaper, magazine, radio and business writing experience. Her works have appeared in leading periodicals like "Madame Noire," "Halogen TV," "The Network Journal," "Essence," "Your Church Magazine," "The Trenton Times," "Pittsburgh Quarterly" and "New Citizens Press."

Photo Credits

  • http://www.printableinvoicetemplates.net/samples/expense_report-unlined-landscape.png