How do I project year end income and expenses to arrive at ending cash

Hello,
I use Tiller Foundation to track personal income and expenses.
I want to use the budget category method to project year-end income and expenses to end the year with positive cash flow.

At the end of each month, I have adjusted that month’s budget categories to match the actual income and expenses. I would also adjust the future month’s category budgets to arrive at year-end cash flow.

I reviewed other options (mostly profit loss solutions) There must be an easier method.

I honestly find it easier to project in terms of actual planned transactions, rather than at the category level. For me, I’ve found it conceptually easier to enter in all the future planned income and expenses as manual transactions, and then use formulas to calculate the future account balances as far into the future as I want. Editing the manual planned transactions makes it really easy to plan almost any kind of hypothetical spending or saving scenario.

Sadly, even though the concept is simple, the implementation isn’t quite so. I’ve currently got some really hairy formulas to do the future balance calculations, and you have to manually reconcile the planned transactions to the real ones when they arrive. @jfederline described a similar approach here: Add a Projected Balances sheet

This approach would save you from having to manually keep all those future budget categories in sync all the time. You’ll have to decide if this way is any easier, but hope it helps.

FWIW, I’m working on a Google Sheets add-on that would automate this (including automatic reconciliation and future projections of scheduled transactions). I’ll share it here when it’s done.

This is helpful
I will study and review your links.

I found my answer in this webinar.

1 Like