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
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.
-
Start the reconciliation
- Open
Accounting > Audit > Account Reconcile. The list is headed Bank/Credit Reconcile. - Click
Create. In Create Bank/Credit Reconcile for New Period, type theStatement Dateand theEnding Balancefrom the statement. A negativeEnding Balanceonly warns: Typically the Ending Balance would be entered as a positive value. Check you meant it. - Pick the bank or credit card
Account. Without one, Cetec shows Choose an account. - Leave
Currencyon your default unless the account is in another currency, and clickCreate. Cetec opens the reconciliation.
- Open
-
Tick the cleared items
- 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 Allto show unreconciled items from all statement dates and find something old that never cleared. - 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.
- Leave the account, currency and statement date alone once you've ticked items. Changing
any of them and clicking
Updateclears everything you've ticked; the fields' tooltips say so. - Click
Updateto save as you go, then reload and check your ticks are still there.
- 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
-
Close the period
- When Difference is zero, click
Update. - Click
Closeand confirm Are you sure you want to Close the reconcile?. On the old version, setStatusto Closed and clickUpdate. - Click
Print, which appears once the reconciliation is closed, to keep the report of reconciled and unreconciled items.
- When Difference is zero, click
Other ways to do this
Upload the statement file
Your bank gives you a statement file, so you don't tick items by hand.
- On the reconciliation, click
Upload Statement(Importon the old version). - Pick the statement file. It must be Excel or CSV, up to 2,500 lines.