Personal Finance & Spending Tracker
Get your Finances on track in 2024, our finance tracker allows you to create and keep track of your monthly spending plan as well as a yearly overview of your income, expenses and savings allocation.
Template sheet: this has the same template set out in the monthly sheets. For ease you can use this sheet to rename the income, expenses, savings and budget categories according to your preference. To save time you can also input your monthly bills into the template sheet and copy and paste the information across to the monthly sheets to save you time (note: copy and paste the whole sheet to avoid missing any formulas).
Savings tracker sheet: this sheet allows you to keep track of the savings you set aside monthly. You can rename the savings labels in cells A6-A10 according to your preference. In cells B6-B10 you can input your savings goal for each savings account or pot that you have. The savings amount for each month will automatically update according to the amount you input in the monthly sheet for that category.
Cells O6-O10 will update the total amount you have saved across the year within each category. Cells P6-P10 will update to show you the ‘amount remaining’ in each savings category needed to meet your goal. Cells Q6-Q10 will update to show you the percentage of your goal you have completed. Cell O11 will update to show you the total amount you have saved across all of your saving categories.
Monthly budget sheets: each sheet is broken down into an income, expenses, savings, and monthly budget section.
Income section: input the total income you receive in the month, you can rename the income labels to suit your needs.
Expenses section & Date of transaction: this section is for bills you pay each month. You can rename the labels according to the bills you have and input the amount of the bill in row 14. To change the date in the date of transaction row to reflect the date you pay each bill, click on the date above the bill you would like to change and change the numbers at the end of the formula in row 12 ‘Date of transaction row’ to reflect the date you pay that bill, for accuracy i.e. 20 for the 20th of each month (the number is the ONLY part of the formula you need to change).
One of the useful features of the tracker is the 'Bills left to pay' section this figure updates daily according to the dates you have inputted in the date of transaction column- this figure will show you the amount of bills you have left to pay on the date you've opened your tracker.
Savings section: rename the savings labels according to your needs and input the amount you will save in the adjacent row.
Monthly budget section: rename the budget categories according to your preference, allocate a total budget amount for each category in ‘monthly allocation’ in cells B31-B40 and break your budget down weekly based on how you want to spend your money across the budget column for each week.
The ‘Money spent’ columns are for you to input the amount of money you have spent in each category weekly. The variance column for each week will update to show you whether you have met your budget, underspent, or overspent in that particular week. As you input how much you have spent in each category, you will be able to see how much money you have left in each budget category in column R ‘Budget remaining’.
To view the totals spent across each category refer to cells S31-S41 ‘Total spent’.
To view your total budget, money spent and the variance across those figures refer to cells T41, U41 and V41.
We recommend setting a ‘Treat me’ budget based on an affordable amount that you can use to reward yourself for all of your hard work (set this amount wisely). As well as budgeting a reasonable amount for a Miscellaneous buffer to cover items you may unexpectedly need throughout the month.
Build the habit of updating your spending regularly i.e daily, weekly or fortnightly, this help you to have a clear picture of your spending, in the event you overspend you can always realign your budget for the remainder of the month.
Quarterly totals sheet: rename the income, expenses, savings and budget categories to reflect the titles you create on the monthly sheets. The figures you input in the monthly sheets will automatically update to show you your income, expenses, savings and budget categories figures across each quarter.
Yearly totals sheet: rename the income, expenses, savings and budget categories to reflect the titles you create on the monthly sheets. The figures you input in the monthly sheets will automatically update to show you your income, expenses, savings and budget categories figures across the year.
Charts sheet: this sheet has a chart for each category of the budget tracker that updates to show the figures inputted across the year for income, bills, savings and expense categories, you can amend the format of the charts according to your preference.
- Some of the cells are locked to protect the formulas being changed in error to unprotect an excel sheet the password is 2021.