![]() ![]() Combined master register of all transactions from all 12 separate monthly registers for an entire calendar year. (In prior v4, there was a max of 20 income budget categories and max of 120 expense budget categories)Ħ. In the Category List and Budget section, you can add up to 50 custom income budget categories and up to 200 custom expense budget categories to track your actual vs budgeted income and expenses. ![]() The budget amount for a particular category can be different for each month of the calendar year.ĥ. Category List and Budget section where you can add/delete your own custom categories, sort them, and add a budget amount for each custom category for each month of a particular calendar year. Splitting a single transaction into more than one income or expense category allows you to better track your actual spending or income.Ĥ. For example, if you went to Walmart and purchased groceries and clothing, when entering that purchase, you can split the total spent into two categories, a portion goes to the groceries category and a portion goes to the clothing category. Split Transactions: When entering transactions into one of the individual monthly registers, you can split the transaction into multiple categories. In the monthly registers, you can sort transactions and easily enter a transaction's category from a drop down selection of custom categories that you created (In prior v4, you could only enter category totals not individual transactions/purchases.ģ. These individual transactions are then automatically totaled in various reports and charts to get income, expense and category totals. Twelve separate registers (one for each month of a particular calendar year) where you can enter individual income and expense transactions such as a specific purchase at a grocery store. Excel Dashboard Summary with monthly income and expense totals / charts for an entire calendar year (including a chart with cumulative running totals) and a monthly budget vs actual chart of any category for an entire calendar year to see income and spending trends.Ģ. Household budgeting tools key features: (watch video below for overview)ġ. Enter your actual income and expenses in each of the monthly worksheets and compare your budget vs actual in charts and reports to make sure that you keep your budget and don't overspend. Easy steps to stay within your budget include: set your 12 month budget for all your income and expense categories. Our budget is based directly off of these templates and we have used them for years in order to control our spending, show us were our money is going, and to give us timely information about the state of our finances.Monthly household spending and income tracker (Georges Monthly Budget Spreadsheet v10) to help you cut expenses and save money. We have two basic templates that you can use to create your own budget. Below the video we also have links to a template that you can use to create your own budget. In the quick tutorial below you will see how we created our budget in Google Sheets and learn how to create your own. To complete our budget, we use Google Sheets. To begin with, we break our expenses down into two basic sections, wants and needs.ĭepending on your situation, you may need to edit your needs and wants, but we break them down into the following categories:īy keeping each of these areas in our budget, we are able to track our spending and determine if we really need something or if we want it. To get more specific with our budget we need to examine our costs each month. Some items, like our mortgage, or fixed, but others change depending on the month. Our expenses, costs, are what change on a month to month basis. If your income is not as predictable, we would recommend that you update your budget often to better track your income and try to find an average monthly income. We know what we are going to earn each month, and we can plan very far in advance because of this. For us, we have two general areas that we use as our starting point, income and expenses. ![]() Once you have your general areas, you can begin to get more specific with each of the areas. When you are looking to start a budget you really want to break down your areas of concern as simply as possible. You will also find links to our budget and downloads if you prefer a different version. Below you will find resources to help you start your own budget along with a tutorial on how we setup our budget. We use Google Sheets to help us keep our budget in order and with us at all times. Our budget is fluid, flexible, and works for us. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |