This spreadsheet was made with three goals in mind:
- That it will be easy to use;
- That you can focus on one daily number while supporting your long term goals;
- That it will be a good starting place for people who have never had a budget plan or they don’t know how to do it.
The sheet is divided into a few different tools.
- Select your pay schedule, add any extra income/tips that you get monthly and select the percentage of that income that you want to save.
- The credit card section allows you to input up to five cards and adds your monthly car payments to your expenses.
- The expenses area is where you’ll add all of your itemized expenses. You can also select when your bill is due during the month- allowing you to see if early on in the month your spendable is different from later on in the month.
Your budget summary at the top is the breakdown of all the information below. YES, we know, pie charts aren’t useful for everything- but that is useful to visually digest information. Look and see where your money is going, see if you spend more than you earn, and finally- see how much money you can spend.
This sheet focuses on giving you ONE number to remember: Daily Spendable. If you want to spend money throughout the day you just have to make sure you DON’T go over that number and you will always have enough to cover any other expenses.
If you don’t work well with a lot of budgets because you have issues imagining the big picture, by giving yourself a daily/weekly/monthly budget you can make sure that on any given day you haven’t spent more than you’re allowed to – and if you do, you can see where you’re borrowing from or where that money is supposed to come from.
There are a few extra features too – a large purchase calculator that lets you figure how long you’d have to save to buy a larger purchase. It includes a monthly tracker that lets you see what you’re spending realistically vs what you’ve budgeted for and finally a daily tracker for further breakdown.
You have every detail about how to use it in the spreadsheet itself. Suggestion: Make a copy of it and keep the original. Rename the original and work on it. Keep the original as it is and use it when you have difficulties. For any questions, mails us at: firstname.lastname@example.org
Link to download the Spreadsheet: From here you will make your own copy in Google Drive but it requires a Gmail account (Recommended!)
Link to download the SpreadSheet: No account or sign-in required. You can download the file as .xlsx but you will lose some formating