Expense Tracker: Excel and Google Sheet Spreadsheet Template

 Getting a hold on your spending and expenses is the first step to budgeting. This tracking spreadsheet will allow for the automated reporting of expenses by month and by year for up to 250 expense categories and can handle tens of thousands of individual transactions in the data tab.

$45.00 USD

The template will be immediately available to download after purchase. Note, the Excel version uses dynamic arrays on the last two filter tabs, which will require Office 365 and to be in the Office Insiders program. If you don't mind that, you can ignore the last two filter tabs. The Google Sheet version works for anyone as long as you have a free Gmail account. This template is included in the accounting spreadsheets bundle as well.

My goal with this Accounting tool was to make it really easy to use. The data entry is simple. Just enter:

  • Expense Description
  • Expense Category
  • Amount
  • Date

On cell D3 on the 'monthly expense summary' tab you can define the start month of the reporting period. The template will report expenses by category in a 3 year monthly and annual summary.

There is a simple 'validation' tab to enter a unique list of up to 250 expense categories. That will populate the available options on the 'data' tab when you select the category for each individual expense item.

Budget vs. Actual

There is a row to enter you total monthly expense budget and that will show up in a nice visualization comparing the monthly actual expenses to the defined budget. An annual view is also built with its own chart.

There are two filter tabs that let the user select a single expense category and see all transactions in that category. One of the filters auto-sorts by most recent date and the other sorts by highest expense amount.

The point of this tool is to give yourself accountability and look at what actually happened each month and how a budget was blown or beat.

I would suggest using the Google Sheet version, but the Excel version works just fine as well.