Skip to main content
Try for free

Reconcile the bank

Match the bank statement to the books.

Updated Nov 5 2026

Who this is for

Accountants and bookkeepers match each month's bank or credit card statement to Cetec, so the cash on the books is the cash in the bank.

Applies to
Accounting

Why it matters: a reconciliation catches missing deposits, checks that never cleared, bank fees nobody recorded, and payments entered twice. Auditors expect one for every month.

  1. Start the reconciliation

    1. Open Accounting > Audit > Account Reconcile. The list is headed Bank/Credit Reconcile.
    2. Click Create. In Create Bank/Credit Reconcile for New Period, type the Statement Date and the Ending Balance from the statement. A negative Ending Balance only warns: Typically the Ending Balance would be entered as a positive value. Check you meant it.
    3. Pick the bank or credit card Account. Without one, Cetec shows Choose an account.
    4. Leave Currency on your default unless the account is in another currency, and click Create. Cetec opens the reconciliation.
  2. Tick the cleared items

    1. On the reconciliation, tick each deposit and each check or payment that appears on the statement. On a credit card account these read Charges and Payments. Click Show All to show unreconciled items from all statement dates and find something old that never cleared.
    2. Watch the figures at the top. Cleared Balance is the beginning balance less checks and payments plus deposits; Difference is the ending balance less the cleared balance.
    3. Leave the account, currency and statement date alone once you've ticked items. Changing any of them and clicking Update clears everything you've ticked; the fields' tooltips say so.
    4. Click Update to save as you go, then reload and check your ticks are still there.
  3. Close the period

    1. When Difference is zero, click Update.
    2. Click Close and confirm Are you sure you want to Close the reconcile?. On the old version, set Status to Closed and click Update.
    3. Click Print, which appears once the reconciliation is closed, to keep the report of reconciled and unreconciled items.

Other ways to do this

Upload the statement file

Your bank gives you a statement file, so you don't tick items by hand.

  1. On the reconciliation, click Upload Statement (Import on the old version).
  2. Pick the statement file. It must be Excel or CSV, up to 2,500 lines.