By Gaspar Desnoyers at February 16 2019 00:00:12
Nothing can be more frustrating when you're working on your monthly budget than to run out of budget categories as you're grinding through numbers. Trying to decide where to put an expense can be very frustrating. When choosing your budgeting worksheets, look for some major main categories of expenses with the flexibility to add more detailed line items underneath. For example, major budgeting categories include: • Charities / Tithing • Savings • Housing • Utilities • Food • Transportation • Clothing • Medical / Health • Personal • Recreation • Debts
Using the Consolidation feature. You can determine whether or not the link will be interactive when creating the consolidation. This method provides the greatest level of detail in the summary worksheet. You can choose between any function, not just the sum function. For example, you could create an average of several divisions in a summary worksheet. Some of the disadvantages of this method are that the worksheets must be identical. Although it is not impossible, it is difficult to use consolidation across workbooks.