Have you posted an incoming or outgoing payment at the end of the month, but the bank didn't register it until the 1st of the next month? Then the entry shows on the left (posted in Catacloud) in the September bank reconciliation, with nothing to match it against on the right (the bank). In October it's the other way round.
This typically happens when a payment is made after the bank's cut-off time on the last day of the month, or at a weekend. You pay on the same day, but the bank doesn't debit or register the amount until the next business day.
Why doesn't Catacloud match them?
The bank reconciliation only shows entries dated in the month you're viewing – on both the accounting side and the bank side. The September entry isn't shown in October, and vice versa.
Entries you close together must net to zero within the same month.
You can't approve September until the difference is 0. As long as the amount sits in September in the accounts but in October at the bank, September won't balance.
The solution is to park the amount on an interim account over the month-end. This always works – even when the voucher is locked.
How to do it: park the amount on an interim account
You create one advanced voucher with lines in both months. The September line cancels out the amount on the bank account, and the October line posts it again on the same day the bank registered it. The original voucher stays untouched.
Which interim account? Use a separate account for money in transit (e.g. 1555 or an account in the 19xx range). Ask your accountant if you're not sure which one you use.
Example: two outgoing payments of NOK 5,000 are posted to the bank account on 30 September, but were debited by the bank on 1 October.
1. Create the interim voucher
Create an Advanced voucher with two lines:
30.09: Debit the bank account (e.g. 1920) / Credit the interim account – NOK 10,000
01.10: Debit the interim account / Credit the bank account – NOK 10,000
Check that Control is 0.00, and click Save and send to ledger.
The screenshots show the app in Norwegian.
2. Reconcile September
Go to Bank → Bank reconciliation and select September.
On the left, tick the two outgoing payments and the interim line from 30.09. The sum shows 0.00.
Click Close postings.
The difference should now be 0. Once the month has ended, click Approve reconciliation.
3. Reconcile October
Select October. The interim line from 01.10 now shows on the left.
Tick the interim line and the bank lines it relates to on the right. When the sum is 0.00, click Close postings.
Tip: If the amounts were registered by the bank as separate transactions, you can split the October line into one line per bank transaction with the same amount. Catacloud then suggests the pairs itself, and you just click Approve.
The interim account is now back at 0. You can check this in the trial balance.
Is it an incoming payment (e.g. a customer who paid on the last day of the month, but the money arrived the next day)? The procedure is the same, just with debit and credit reversed on both lines.
Can't I just change the date on the voucher?
Payments you have sent from Catacloud can't be edited – the voucher is locked. Use the interim account.
If you posted the voucher manually, you can sometimes change the date instead:
Click the arrow on the entry in the bank reconciliation, then click the voucher number (e.g. Voucher 443). The voucher opens in edit mode.
Change the Voucher date and the date on the transaction lines to the date at the bank.
Click Save and send changes to ledger. You'll now find the entry in October, where Catacloud suggests it as a pair with the bank line.
This also doesn't work if the accounting period is locked, or if the October bank reconciliation has already been approved. If in doubt, use the interim account.
When should you contact us?
Contact us in the chat if this doesn't work. Please include:
client name and bank account
the two months involved
amount and voucher number
the exact error message, e.g. "You cannot lock these transaction lines because they don't match"