Hi @Richard ,
Well, you found the best solution. Take row 60, including the hidden part and drag the formula down for as many new category rows as you want. This will copy the formulas in columns P, Q, S, T and AC.
That should work just fine.
While you are certainly welcome to add all your categories to the Cash Flow Forecast, another option is to include only the categories on this sheet where you expect significant non-standard changes in the future.
All your budgeted income and expenses, your ‘core’ income and expense budget amounts, are already built into the sheet and can be given an overall growth rate.
From the initial How to Use post:
Core Income and Expense Budgets
The Cash Flow Forecast sheet looks at the
Categoriessheet to establish your baseline cashflow from your existing income/expense budget. If you have monthly budget columns for the current year, those budget values will be annualized and used.
Income or expenses in categories that are hidden from reports are not included.
If you do not have budgets for the current year or want to use a different initial range, see the FAQ #1 below for how the initial Income and Expense range is determined and can be overridden.
This sheet doesn’t use any information from the
TransactionsorBalance Historysheets. It only uses the amounts in your budget located in theCategoriessheet.
I don’t think we are going to update the sheet with more rows by default. It adds some extra processing and may not be useful to most users. If I’m wrong about this, we can adjust.
Jon