Budget View miscalculates cashflow (mostly due to things like mortgage credit & debit happening across acounts) How to fix?

Hello all, it seems that no matter what I do I can’t trust the cashflow in/out on my monthly budget. Here’s what I’ve done and the problem I’m experiencing:

  1. Let’s assume I have an income of 2k and a mortgage of 1k*, and no other transactions.
  2. I get paid +2k. Listed in categories tab, my planned income is 2k.
  3. My mortgage is 1k. My planned expense is 1k. My expected total cashflow is -+1k (salary - mortgage)
  4. The mortgage payment appears as a -1k in checking.
  5. In the mortgage account, it appears as +1k.
  6. My expected cashflow is -1k, but because of the +1k to the mortgage account, my cashflow is -0-.

How do I solve this ?

*I wish it was 1k

Can you clarify which template you are using with a link or a screenshot?

I am having the same problem - using the Excel foundation template. Any help much appreciated.

So technically it is correct.

The money from your bank account (-1000) is actually a transfer to your mortgage co (+1000) then the mortgage company actually applies the funds to the correct expense ( - interest, - principal, - escow account) I am not sure if you are seeing these transactions in your mortgage account.

I said technically, because while correct it is annoying and not data I choose to track. instead, I only mark the one item out of my checking as Mortgage. I then create a new category called Mortgage Details (type = Transfer) and categorize all of the other mortgage transactions with that one. Since the category is a transfer, the cash flow reports just ignore them, and the cash flow now looks correct.

I hope that makes sense.

1 Like

thank you for the reply. So the action item is to label certain transactions as Type = Transfer, so that they will not appear on monthly budget by category sheets?

Yes. Most Tiller spreadsheets use a convention where money moved between accounts is categorized with a “Transfer” type (which is typically hidden) so it is not shown as income or expense.

1 Like