The difference in the bank reconciliation is the gap between the bank balance (fetched from the bank) and the accounting balance (the bank account in the chart of accounts, e.g. 1920). It must be exactly 0 before you approve – below are the most common reasons why it isn't, and what to do.
Difference even though all entries are matched
The bank balance and the accounting balance can differ even if all rows are ticked, because:
A payment is posted in Catacloud on a different date than it was debited by the bank. This typically happens with payments after the bank's cut-off time, across a month-end, or at weekends and on public holidays – the payment is posted on day 1 but debited by the bank on day 2.
Solution: park the amount on an interim account over the month-end – see Posted in one month, registered by the bank the next – how to reconcile across month-end.A posting has been made against the wrong account (not 1920). Check that all bank movements are posted against the bank account in the chart of accounts.
Difference appears in a month that is already reconciled
Have you reconciled and approved a month that balanced to zero, but it suddenly shows a difference – perhaps in several months back in time, and with an amount that keeps changing? This is usually not caused by anything in your accounts.
If the account has a bank integration, Catacloud calculates the bank balance for earlier months backwards from the latest balance the bank has sent. If the bank has sent a new balance before the newest transactions have been fetched, the calculated balance is wrong in every earlier month – by exactly the amount of the missing transactions.
Solution:
Go to Bank → Bank reconciliation and select the account.
Click Fetch from the bank now below the transaction list.
When the fetch is done, reload the page and check the difference again.
Is the difference still there? Go to the month after the one showing the difference, and look for postings in the accounts that have no matching bank transaction. If they add up to the difference, those bank transactions are missing in Catacloud. Check in your online bank that the amounts were actually debited or received, and contact us in the chat with the client name, account number, amount and date, and we’ll look into it. Don’t post anything to bring the difference to zero. That will cause errors once the transactions come in.
If you find no such postings, a voucher may have been posted, corrected or deleted with a date in a month that is already reconciled. Open the general ledger for the bank account (e.g. 1920) and look for vouchers recently posted or changed in that period – see also A voucher isn't showing – has it been deleted or corrected?. If you can't find the cause, contact us in the chat with the client name, account number and which months show a difference.
Matched entries reopen
This can happen if a synchronisation with the bank fetches the transactions again after you matched them. The tick belongs to the local transaction row – if Catacloud replaces the row with a new one (e.g. during re-synchronisation), the tick disappears. Contact us in the chat with the client name, account and period if this happens repeatedly.
See also
When should you contact us?
Does the difference not reach zero after the steps above, or do matched entries keep reopening? Contact us in the chat and provide:
Client name
Account number
Period (month/year) – all months showing a difference
The amount of the difference
The more specific the information, the faster we can help.