MONTHLY EXPENSE SHEETS FOR EXCEL HOW TO
MONTHLY EXPENSE SHEETS FOR EXCEL DOWNLOAD

Also if you have a negative number (a deficit), it can also be rolled over to the next week where it will reduce what is available in the next week. If you have any money left over at week’s end, it will be rolled over for us in the next week. That is the number you should try and stay below each week! As you start to input these expense, they will be added up and subtracted from your “Weekly Safe-to-Spend” to give you what your current “Safe-to-Spend” number is. Day-to-day expenses are things like coffee, movies, gas and groceries. This is where you type in your day-to-day expenses that were not inside of your recurring expenses. On this sheet, you will see columns for “Date”, “Description” and “Amount”. So in our example from above the Weekly Safe-to-Spend from first spreadsheet was $580.87 and that is what is pre-filled in on the Tracker page.

First notice that your “Weekly Safe-to-Spend” matches the calculation done on the first spreadsheet. Do not change anything on this tab.)Ĭlick on Tracker Week 1. (There is also a sheet for “Calculations”, this is where we store the ratios for calculating the weekly equivalent of income and expenses. At the bottom of the spreadsheet you will see a tab for “Tracker Week 1” and “Tracker Week 2”. Now that you know your Safe-To-Spend, it’s time to track your spending on a week by week basis against this Safe-to-Spend number. If you look to the bottom of the spreadsheet, you will see additional sheets called “Tracker Week 1”, “Tracker Week 2” and “Tracker Week 3”. The next step in budgeting weekly is to keep track of your expenses on a weekly basis. Spend less than this every week and you will be good to go. You can think of it like an adult allowance.

This is the amount that if you spent less than, your finances would be in good health. Now that the spreadsheet has your average weekly income and average weekly expenses, it will give you your weekly “Safe-To-Spend”. The weekly budgeting template will add up all the equivalent weekly expenses and add them to the top of the spreadsheet in the row that says “Average Weekly Expenses”. We have given you a bunch of categories to get you thinking about all the committed expenses you may have. The template will put in the equivalent weekly amount for the expense just like it did for income. In the second section you describe your expense and put in how often it is paid. For example, you might have a yearly pool membership or a quarterly subscription. But sometime committed expenses can be of different durations too. So are any subscriptions you have like Netflix or Gym memberships.Ĭommitted expenses are usually monthly – think your phone bill or subscriptions. So for example, your mortgage is a committed expense. What is a committed expense? A committed expense is an expense that you already know in advance what the amount is and it comes out on a regular basis. In this part you need to put in all your committed expenses. Next add in you r committed expensesįor this next part, having a copy of your bank and credit card statements handy can be quite helpful. Once you put this number into the spreadsheet in the lines “Net paycheck 1” and “Net paycheck 2” with the frequency, the template will automatically calculate the equivalent weekly amount for your income and it shows this number at the top next to “Average Weekly Income”. You can choose “Weekly”, “Every Two Weeks”, “Twice a Month”, “Monthly”, “Every 3 Months”, or “Every 6 Months”. Next choose how often you are paid from the dropdown in the spreadsheet. First input your regular incomeįirst thing to do is to get a copy of your paychecks and fill in the how much you get paid. After putting in your income and expenses, the spreadsheet will calculate their weekly equivalents and let you know what you can safely spend in a week. This is where you will put in all your recurring income and expenses. So to start, open the sheet called “Safe-to-Spend”.

The first step in creating a weekly budget is to understand what you “Safe-to-Spend” number is.

MONTHLY EXPENSE SHEETS FOR EXCEL HOW TO

(It syncs with your bank and credit cards to keep your Safe-to-Spend number up-to-date!)īelow are the instructions on how to use the spreadsheet to calculate a weekly budget for yourself and then use the spreadsheet to track your personal spending.

If you get tired of using a spreadsheet to track of your weekly spending, we suggest giving our weekly budget app a try. It behaves much the same way that our app does but in a spreadsheet instead.

MONTHLY EXPENSE SHEETS FOR EXCEL DOWNLOAD

You can download our weekly budget template as an Excel document (.xlsx) or open it as a Google Sheet to calculate your Safe-to-Spend and then track of your spending on a weekly basis. If you would like to try and do the same thing but with a spreadsheet instead, you are in luck! We created Weekly as an app to help you stay on track with your personal finances using a weekly budget.

Monthly expense sheets for excel