Tool for working out how much money you are spending and saving each week/month, so that you can hit your savings goals and set money aside for gambling investing and buying drugs holidays.
The steps for weekly spending tracking start below this chart.
This is mostly just a nice chart showing the variation in your weekly expenses, with a calculation of some informative averages below.
To update the weekly expenditure values used in the averages, click on the cells in the weekly expenses column and add the weeks you want to include from your weekly expenses table.
Step 1: Put your monthly income, savings target and total recurring expenses in the variables table below. You can work out your total recurring expenses by filling in the table at the bottom of this page.
Step 2: after every week, add a new page with the ‘new page’ button and fill in the ‘total spend,’ ‘groceries’ and ‘travel’ fields with what you spent on those things that week. Put the date range of that week as the title, and specify what date the week ended on in the ‘week ending’ field.
Step 3: if you made any big purchases this week (flight tickets, concert tickets, new clothes etc.) that you don’t want to put under weekly expenses, add them to the current month’s big purchases here. Take note of the current month’s sum.
Step 4: update this table (below) by adding the weekly expense page you just created to the ‘Included Weeks’ column for this month, and update the ‘Big Purchases’ column with the new sum of this month’s big purchases that the table above calculated in step 3. This table will then use the total you have spent on weekly expenses, the total you have spent on big purchases, your monthly income, total recurring expenses and savings target to calculate how much you have left to spend for this month and show you whether you are on track to meet your savings goal. At the end of every month, add a new row.
Step 5: Once you’ve looked at how much you have left to spend, think about how much you want to spend this week to stay on track and transfer that amount of money from your current account to your spending account.
The below table is a useful tool for working out what your recurring monthly payments (bills, subscriptions etc.) sum to. Once you have filled this in, put the calculated sum in the ‘Variables’ table at step 1.