Income and Expense Tracking Worksheet

Income and Expense Tracking Worksheet

Print a blank worksheet or custom-make and edit using Excel® or Google Sheets –
Tracking your income and expenses is one of the first steps in managing your money. I designed this worksheet to use as a printable handout in an basic personal finance course, but it besides functions as an editable spreadsheet. Although I have other finance and budget spreadsheets that do a set more than this one, if you are looking for a identical simple way to keep racetrack of your money, this worksheet can help you get started .

Printable Income and Expense Worksheet

Printable Income and Expense Tracking Worksheet


Printable PDF
License : individual Use ( not for distribution or resale )


This version was created specifically for printing and complemental by hand. This worksheet can be the first base step in your journey to control your personal finances .
step 1 : Track your Income and Expenses .
step 2 : use that information to create a budget .
mistreat 3 : continue tracking to help you stick to your budget .

Using the Income and Expense Worksheet

I tried to make the spreadsheet as easily to use as potential. If you are using it in Excel on a smart telephone, you ‘ll find that it uses a fortune of drop-down lists. You can edit those lists in the Settings worksheet.

This worksheet does n’t calculate a compendious of income and expenses by category for you ( like the Account Register for example ). however, if you are comfortable with Excel you could use a Pivot Table to analyze your income and expenses .

Step 1: Clear the sample data, but don’t clear the formulas in the Balance column.

The sample data is there to give an exemplar of how you can enter beginning balances, transfer money between accounts, and enter some basic expense transactions .
It is not necessary to use the worksheet for ALL your accounts in one record. You could duplicate the worksheet and use one worksheet for each of your accounts if you wanted to .

Step 2: Enter beginning balances for the accounts you want to track.

This is n’t necessary, but it ‘s what you would do if you wanted to keep cut of each account symmetry. There is actually a obscure column that you can unhide that will show your current Account Balance .

Step 3: Edit the Accounts and Categories lists in the Settings worksheet as needed.

These lists control what is shown in the drop-down lists for each column. It is n’t necessary to use the drop-down lists – they are merely for convenience .
If personal finance scares you a bite, it may be easier to start with equitable a few expense categories. When you are ready for something more advanced, you might want to try the Money Management Template .

Step 4: Update the Income and Expense Worksheet daily.

If you are using the worksheet on your earphone, you can edit it on the start. If you are using the print worksheet, you can take it with you in your wallet or purse and edit it whenever you make a leverage .
Another approach path is to make notes on a 3×5 card or make notes on your phone about your spending, and then update your worksheet at home .

Step 5: Create a Pivot Table to Analyze Income and Expenses

The picture downstairs shows an exemplar of the type of report you can create fairly easily using a Pivot Table in Excel. For detail instructions, see the blog article written by guest writer and Microsoft MVP John MacDougall : Using Pivot Tables to Analyze Income and Expenses.

Pivot Table showing Expenses by Category and Month
Tip : If you use a Pivot Table in Excel 2013 or late, I ‘d recommend trying the modern Timeline feature. This makes it easy to select the roll of dates to display in your table. Click inside the pivot table, then go to the Analyze yellow journalism and chink on Insert Timeline .

More Money Management Templates

Related Posts