Skip to main content

Bank balance and booked balance don’t match

Checklist when Payfriend shows a difference between bank and books: reconciliation start, unmatched and pending items, ledger account, opening balance and sync. And when you can use Balance.

Written by Nicki Elgaard

Under Bank, Payfriend shows the bank balance and, when the balance can be fetched from your accounting, also the book balance and a difference. A difference is a signal of unreconciled work or missing data. It does not necessarily mean the bank is "wrong".

Quick diagnosis

  1. Is the reconciliation start set?

  2. Is the right bank account selected (operating, savings, Revolut)?

  3. Are there unmatched or pending items?

  4. Is the bank account linked to the right ledger account?

  5. Is the accounting connected and synced?

  6. Is the difference new (today) or old (from before Payfriend)?

Checklist

  1. Go to Bank, choose the account's card, and note the difference amount in the bar above the list.

  2. Confirm the reconciliation start. If there is no date at Reconciled from, the whole bank history counts as work.

  3. Work through the Unmatched tab under Bank.

  4. Check that all relevant accounts are connected and have a ledger account. If the card says Accounting account looks wrong, Payfriend suggests another account based on the postings in your accounting. Click Fix or Keep. See also Revolut Business.

  5. Run a resync of your accounting if the book balance looks stale.

  6. Compare with the balance in your online bank and in your accounting for the same account and date.

  7. Look for fees, interest, pending payments and manual entries in one place only.

Common causes

Unmatched transactions

Sign: Difference ≈ sum of unmatched.
​Fix: Match receipts and invoices; upload missing receipts.

Pending bank transactions

Sign: Payfriend says there are pending bank transactions and that the difference cannot be balanced while money is in flight.
​Fix: Wait until they have cleared, then reconcile them.

Wrong reconciliation start

Sign: A historical mountain of "unmatched".
​Fix: Set the start date to the last day you agreed in the old system.

Opening balance missing in the accounting

Sign: Payfriend says the account held an amount before the bank feed begins and that it is part of the difference.
​Fix: The balance must be part of the accounting's opening entry. It cannot be reconciled away in Payfriend.

Entry only in accounting or only in bank

Sign: Only one side has the entry.
​Fix: Book what is missing, or match and wait for bank clearing.

Wrong ledger account or several accounts mixed up

Sign: Figures "almost" match another account.
​Fix: Choose the right account by clicking its card under Bank, and check the ledger account on the card.

The bank has not been fetched

Sign: Your online bank is newer than Payfriend, or the card says the balance has not been updated since a date or that the bank needs you to log in again.
​Fix: Click Sync, or renew the bank connection. See Bank connection expired or disconnected.

Can I balance a small difference?

When everything is reconciled and only a small difference is left, a Balance button appears next to the difference. Choose a contra account, optionally write a text, and click Post adjustment. Payfriend remembers the account for next time. The default account and the amount limit live under Settings → Accounting → Account setup.

If the button is not shown, Payfriend states why: there are still unmatched or pending transactions, the bank account has no ledger account, the account is in a foreign currency, the difference is larger than the limit, or a balancing entry with the same difference is already in the draft.

Still not solved?

Send support: the difference amount, the account, a screenshot of Bank, whether the reconciliation start is set, and the latest sync time.

Did not find an answer? Write to us via the chat in the app, or at Contact.

Did this answer your question?