I've added conditional formatting to help prevent these types of mistakes, but the spreadsheet is definitely not error-proof. What you need to watch out for: If you assign a transaction to a category that is not included in the Budget or Report worksheets, the expense won't show up in your reports and you'll think you have more money than you really do. Video Tutorial (Customizing Budget Categories) Essentially, you just need to make sure that the categories are exactly the same in all worksheets. Luckily, you only need to do this once with maybe a bit of tweaking each year. The most complicated part of using the old version is customizing the budget categories. The new version of the money manager is easier to customize, but many people still prefer the original version because it groups the expenses into separate categories. Update (XLSX version only): Added a new Goals worksheet that you can use for tracking the balance of various savings and expense funds. For example, tags would allow you to filter or search for specific expenses that might cross over multiple categories, such as a #CAR1 or #CAR2 tag for tracking expenses associated with a specific vehicle. A new "Tags" column was added to the Transactions worksheet to let you add your own unique tags as needed. Update (XLSX version only): A separate "Accounts" worksheet was added for editing the list of accounts and summarizing the balances in each account. It includes the transactions and the weekly report all on one worksheet. We've created a Weekly Budget template that is based on the money manager. This may be helpful for creating the following year's budget. Track Your Yearly Spending - Due to frequent requests for a yearly report, I have added a new worksheet that calculates an Income & Expense Report for an entire year grouped by month. Just change the Year and Month to view the report for a different month. actual amounts, and is updated automatically as you enter transactions. Track Your Monthly Spending using the monthly budget report which includes graphs, compares budget vs.
0 kommentar(er)
