Personal Finance & Budget Tracker
Get your personal finances 2021 ready and manage your personal finances as you would a business; this is something I drill in my Finance 101 sessions. Would you manage a business the way you manage your personal finances? If the answer is no, it's time to get organised! Our finance tracker is here to make your life easier by helping you to keep track of how you spend your money each month. Don't worry we've done all the complicated formulas, so that you don't have to.
Our finance tracker allows you to get a clear picture of your finances each month as well as a yearly overview of how you have managed your money. Allowing you to track your income, expenses, projected income after ALL of your bills are paid, monthly and weekly budget as well as allowing you to input your savings allocations each month, which then gives you can income after savings figure to budget for the month.
One of the great things about our tracker is that there is a section on 'Bills left to pay' this figure updates daily according to the dates you have inputted in the date of transaction column for your direct debits and standing orders (committed expenses), this figure will show you the amount of bills you still have left to pay on the date you've opened your tracker! This will avoid you overspending as it allows you to see your reality.
With the income left after your expenses you can then decide how much you need to budget for your essential purchases such as food, household items, personal care etc. we also 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.
You can then allocate a total budget for each category and break your budget down weekly based on how you want to spend your money. Once you have inputted your allocated amount for each Category decide on an amount you want to commit to saving that month or investing.
To keep you accountable always aim to input at the end of each week or you can total up daily the amounts that you have spent from each category. The variance column will update to show you whether you have nailed your budget, underspent, or overspent. This will then update for the whole month as you update the amounts you've spent vs your budget.
Build the habit of doing this religiously, this will avoid you overspending and if you manage to go overbudget you can always realign your budget for the remainder of the month.
- Some of the cells are locked to protect the formulas being changed in error to unprotect an excel sheet the password is 2021.
- All you need to do is rename the Income titles if you wish, to reflect your Income sources each month for example: Salary, Bonus, Benefits etc.
- Rename the Expenses columns to reflect the bills you commit to each month Example: Rent, Mortgage, Council tax, Childcare, Insurance, Travel etc.
- Change the numbers at the end of the formula in row 12 (The Date of transaction row) for each Expense to reflect the date you pay that particular 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)
- Input the amount of all your fixed expenses for that particular month.