Transactions vs. Balances

I created a sheet which reconciles “per bank” vs. “per books” to make sure I have everything recorded in Tiller. This also alerts me to any manual transactions I may have double counted or rows I may have accidentally deleted. My expectation was that the formula which sums up account transactions would match downloaded balances, barring some mistake on my part.

However, this morning, I noticed two transactions have hit the transaction sheet and yet my balance for the account is actually yesterday’s balance (although the updated status indicates “today”). I’m guessing this might happen from time to time, but it makes me wonder how frequently this occurs. Has anyone else noticed this?

@mtjfinancial I have seen this happen a few times myself. I can usually get this reconciled by completing another update my spreadsheet again via the Tiller Money Feeds.

1 Like

I’m looking to do something like this but I’m not good with formulas at all, how did you create a sheet which reconciles “per bank” vs. “per books”? thanks!