Balances in Bank Register differ

[leongathauc]

The balance at the top of the Bank Register differs to the balance in the body of the Bank Register.  The difference is an amount that is regularly posted.  How do I reconcile these two balances.  The top balance is the incorrect figure as the bottom balances with the bank reconciliaton.

[sholt73 · Accepted solution]

the balance in the top-right is the 'perpetual' balance as they call it. this will be the total of that account for all transactions regardless of date.

so if there are transactions after the date range you're looking at, you'll see a mismatch between the balance in the top-right vs the balance from the last transaction in the bank register.

just as a thought to others seeing this, you can see future-dated transactions in the company data auditor, just set the date from the last transaction and it'll show you all transactions entered after that date.