Bank reconciliation

Your books say the bank account holds one figure; the bank statement says another. A bank reconciliation explains the difference. Most differences are timing: a cheque you issued that the bank has not yet paid, a deposit made today that the statement shows tomorrow, or a bank fee you have not recorded yet. A reconciliation lists the items that cause the gap and confirms nothing is missing.

Click to enlarge

Close

Accounting, Bank Recon: tick the entries that appear on the bank statement.

How it works in Zeyto

Accounting, Bank Recon lists the movements on your bank accounts. You tick the ones that appear on your statement and press Mark Cleared. What is left uncleared is what the bank has not shown yet. Marking rows only records the statement date and reference against them; it posts nothing and changes no balance. Unreconcile undoes it.

1. Choose the Bank Account (or leave it empty for all bank ledgers). Set From and To to the statement period and keep Status on Uncleared.
2. Compare the list with the statement. Click each row that appears on the statement; its tick box and the Selected tile follow.
3. Enter the Statement Date and, optionally, a Statement Ref and Notes.
4. Press Mark Cleared. The rows become CLEARED and leave the Uncleared list.

The tiles add up only the rows loaded by your filters, the newest 500, so they are not a closing balance. Book Balance is debits minus credits of the rows listed. Cleared is the same sum for CLEARED rows. Unreconciled is the same for OPEN rows. Selected is the sum of what you ticked.

Click to enlarge

Close

Reports, Bank Statement (book): movements and whether they are reconciled.

Good to know

• A receipt, payment or advance that carries a Bank Account is listed with all its ledger lines, so you also see its customer or supplier line. Leave that one alone: only the bank line is a bank movement.
• A voucher whose bank line is ticked cannot be cancelled or amended. Select the line, press Unreconcile, then cancel or amend.
• A cancelled voucher shows its bank line and the reversing line, marked Reversal or Cancelled. They cancel each other out, so tick them together.
• Mark Cleared and Unreconcile need the accounting.amend permission.
• Unreconcile lives in the More menu with Refresh and the Export options.

The Bank Statement (book) report in Reports shows one account's movements with a running book balance and a Reconciled column saying YES or NO. Set Reconciled to Unreconciled only to see what the bank has not shown yet; remember the Book Balance then runs only over the rows shown.