I was recently asked if Tiller offered a spreadsheet or template that could calculate the net cash flow of a single financial account.
In short, the answer was no, but I figured out a way to build this quickly using a mix of simple formulas and a sheet featured in our Reports Master spreadsheet.
Calculating cash flow of a single account
First, add the “Type” column to your Transactions sheet by following the steps in this help doc. I added mine to the right of the Account column so it ends up in column G.
Next, add the “Account Transactions” sheet from the Reports Master to your spreadsheet by following the steps in this help doc.
Then, assuming that the Type column is in column G in Transactions and your Amount is in column E in Transactions enter these formulas into cells at the top of the Account Transactions sheet.
For Income enter (I entered this into cell F2)
For Expenses enter (I entered this into cell G2)
For the net cash flow, assuming you entered the two above into the same cells I did enter (I entered this into cell H2)
Give it some flare
I also added
You could add a conditional formatting rule to the cell (under the Format menu > conditional formatting) to have it turn red if the amount is a negative number.
Stay on top of categorizing
Keep in mind that this will only show you cash flow based on transactions that have been categorized. If you have uncategorized transactions you’ll see the Type column is blank in the Account Transactions sheet and your cash flow won’t be accurate until you finish categorizing your transactions.
It’s also ignoring transactions that are categorized using Transfer categories since those shouldn’t be factored into your cash flow.
If you want to see the cash flow for your budget in the Tiller Budget you can enter =x10 into any cell on the Budget Dashboard to pull the cash flow (