This template IS NOT compatible with EXCEL or any other software other than Google Sheets.ĭue to the nature of the digital products, no refunds, returns, exchanges or cancellations are accepted. Public/commercial use of any kind is prohibited. You may NOT profit from ANY PART of this digital resource in any way. You may NOT resell, re-distribute, or share this digital resource. You may NOT use ANY PART of this template to create your own for-sale products. This template is meant for PERSONAL USE ONLY. I am a software developer who loves automating stuff. * If you have any questions feel free to message me. * You can make a copy for each month and reuse it. * All of the automations are done for you, you just need to fill out each section with your information. * You will need a free Google account to use this template, there is no need to purchase any other apps. * This template is NOT compatible with Excel. This same PDF contains step by step instructions and a link to the demo video. What will you receive? You will get a PDF file that contains a link to access the Google Sheets template. * Sheet 3: Pre-filled example that you can delete after you are done playing with it. This second sheet contains all of your monthly information, so you can duplicate that sheet each month and keep everything inside the same file OR you can choose to create a completely new file each month. Bills and Subscriptions (within the same table) Customize labels for the entire template, you can also translate them to a different language (you will have to do the translations yourself). Customize drop-downs shared between Bills and Expenses: Categories, Payment Methods and Custom Tags. ** IMPORTANT: This template is NOT compatible with EXCEL or any other software other than Google Sheets. It's a great way to know exactly what you will be receiving! You can watch a DEMO VIDEO before purchasing TIP: It is MUCH easier to keep savings separate from spending if you are using separate bank accounts for each.I wanted to create a Monthly Budget that included my Income, Savings, Investments, Bills and Expenses all inside the same tab, so this is what I came up with. On the other hand, minimum payments on credit card balance(s) are included as "Credit Card Payments" in the Debt section of the outflows. The transfer of money from your checking account to your credit card account would NOT show up in the cash flow statement in this case. You would monitor your credit card statement and allocate each transaction to specific expense categories. Is a credit card account a spending account? If you are paying the balance off each month, then yes. Note again that this is meant to show how much cushion your spending account has. If you included your Retirement Fund in the cash balance, then it wouldn't make sense to include "Retirement Fund" as an Outflow. Why? Because we are treating transfers to these types of savings as Outflows from cash accounts. Do NOT include the balance in any of the categories listed under "Allocations" in the Outflows section. What is NOT a spending account? Your Retirement Fund, Emergency Fund, College Fund, etc. A checking account, your wallet, and/or savings account might be considered a "spending account" if money leaves your possession from that account (like paying bills from a savings account or paying a cab driver with money from your purse). This represents your goal - youre trying to keep from spending more than this amount. You record your desired budget for each category in the 'Budget' column. The purpose of the beginning/ending cash balance section at the top of this spreadsheet is to show how much cushion you have in your spending account.įor the Beginning Balance, enter the sum of the amounts in your spending accounts on the chosen start date. The purpose of this worksheet is to help you compare your monthly budget with your actual income and expenses. Keep in mind that spreadsheets allow you to make more mistakes than software like Quicken, because spreadsheets use formulas and calculations that you may mess up by accident. If you want to use a free spreadsheet with the ability to enter transactions in account registers like you do in Quicken, you can try the Money Management Template. Quicken was my personal tool of choice when it comes to personal money management (before they switched to a subscription fee). It's mainly for people who don't already use Quicken (you can generate a report like this from Quicken very easily via the Reports menu).Īlthough there are some really cool things that can be done with Excel to make this worksheet more useful, I have intentionally kept this template simple. It includes a fairly comprehensive set of expense categories and was designed to be easy to understand and simple to customize. This worksheet was created to be used as an educational resource for personal finance classes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |