This combined master register is automatically created as you enter transactions in one of the 12 separate monthly registers.ħ. You can use this combined master register to search, filter and get subtotals such as total spent on groceries across all 12 separate registers/months. 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. Monthly household spending and income tracker (Georges Monthly Budget Spreadsheet v10) to help you cut expenses and save money.

Excel monthly budget template for mac