I’m sharing my monthly budget spreadsheet. See below for a link!
How to use this spreadsheet:
- Download a copy so you have it on your own computer. Copy the blank spreadsheet so you have a blank one for the next month. Fill in the month and year on the tab at the bottom, as well as on the top row.
- Add your take home pay for the month in the light orange box at the top where it says ‘total incoming’.
- The boxes in Row C are labeled according to when I pay them during the month– the first few white boxes are paid early, the middle multi-colored boxes accrue throughout the month, and the last white boxes are paid toward the end of the month. You can change these categories to reflect your own budget needs: change mortgage/HOA to rent. If you have renters insurance or debt payments, add those in.
- The boxes without a zero in them can be filled in with the amounts you pay each month. For me, life insurance is $125. Fill in everything you know.
- The blue non-monthly savings boxes are a way to save up for expenses that only come around once a year or a few times a year. These categories can be changes to reflect your needs– birthdays, club dues, medical check up costs. How much do you expect you’ll need over the course of a year to cover each of those? Fill in that amount. For me, I try to set aside $400 by Christmas time for presents. It costs $90 each time we bring a cat for their annual checkup. As you fill in these boxes, the annual total and the monthly contribution to reach that goal will automatically update. The monthly contribution is what you should save each month to meet that annual goal.
- The boxes that have zeroes in them are linked to the corresponding colors in other boxes: Blue non-monthly savings are linked to those blue boxes, yellow essentials are linked to the yellow boxes below. As you fill in the light yellow, purple, and green boxes at the bottom throughout the month, the total will automatically total it up. The bottom blue boxes for ‘non-monthly expenses’ are for when you spend money in one of your non-monthly categories in that month. This might not happen each month, and it will remain zero. That will subtract from the monthly contribution you would have made to that non-monthly total, and ensure you have enough money to cover those expenses.
- The light orange ‘total outgoing’ at the bottom will automatically update as well, and the darker orange box will show you your potential ‘savings’, or leftover money that you will have at the end of the month. You can use that as a buffer in your account, or devote it to a savings goal, to paying off debt, or to treat yourself.
Any questions? Ask in the comments below and I’ll try to answer them. Good luck, and happy budgeting!