I’m glad to hear you like the concept behind the spending money sheet.
We developed it 4 years ago, so I don’t remember all the details off the top of my head.
But looking into it, I have some answers for you.
Your idea to even out your irregular income by allocating a set amount each month makes sense. That amount should flow through to the estimated cash flow.
The sheet won’t work if you manually override the Estimated Cash Flow value. That cell is in Grey. Only the Green cells should be changed. You might get odd results if you change the Estimated cash flow cell in B3. That cell should contain the formula:
You should only change the Estimate for an individual Category in B10 and down.
Regarding the “estimated available spending box” calculation, if you click the little triangle at the top right in the C column, you can open the hidden part of the sheet to see how it works.
That amount is based on the time period you select in A7 and the value in I8. I8 is the result of the Actual total of your Unselected Categories plus the estimated value of your Selected Categories. Those numbers might be negative if you are spending more than your income.
The sheet does include categories that are hidden. Transfers are no included.
If you want the sheet to not include hidden income and expense categories, you would need to make the following changes to the sheet.
In H24, enter “Hide From Reports”
In I24 to K24, fill down the formulas from I23 to K23. This will tell the sheet where the Hide From Reports column is in your Categories sheet.
Add a new column to the right of the last column P.
In Q1, enter this formula to show which transactions are from hidden categories.
Change the formula in E4 from:
Make sure when you copy those formulas, the double quote marks show straight lines in Google Sheets. Sometimes they can turn into open and closed quote marks and then the formulas won’t work.
I tested this and it worked for me. But it’s possible I’m missing something. Let me know if it works for you.