Monthly Finance & Budget Tracker
  • Monthly Finance & Budget Tracker


    Manage your personal finances as you would a business, this is something I drill in my Finance 101 sessions. Would you manage a business, in 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. 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 goals 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's a section on 'Bills left to pay' this figure updates daily according to the dates you have inputted, in your 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.

    From the Income left after your expenses you can then decide how much you need to budget for your Essential purchases such as Food, Clothing & Footwear, Household items, we also recommend setting a Treat me budget of what you can afford to reward yourself for all of your hardwork (p.s set this amount wisely). We also recommend budgeting a small amount for Miscellaneous items which occur unexpectedly 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 budget. 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 input at the end of each week or you can total up daily the Amount that you have spent from each budget. 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.


    Please note:

    • Have a watch of the video to get a clearer idea of how to use the tracker
    • 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 date at the end of the formula in the column for the Date of transaction 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
    • You can also rename the Rows in the savings column to reflect where you choose to save or invest your money. Example: Savings account, Help to Buy Isa, Lifetime Isa, Investment account etc.
    • Update your tracker on a regular basis, if your direct debit or standing order dates or payment amount changes don't forget to update your tracker to reflect this.
    • Lastly, build the habit of planning ahead of payday! This avoids you mismanaging your money, before you have taken the time to carefully plan and most importantly execute. Be accountable to yourself so that you will thrive and achieve your goals.


    • File Format

      The Finance tracker is an Excel document, all required formulas have been inputted.

    For Blog Post Updates

    © 2020 Peta-Kay King