Skip to main content
Try for free

Bank Reconcile

Match a bank or credit card statement to the ledger: start a reconciliation for the statement period, tick the items that cleared, and close it when the difference is zero.

Updated Nov 9 2026

Bank Reconcile

Allow external media cookies to watch this video.

Before you start

  • Account Reconcile is under Accounting > Audit. The Audit menu is shown only to users with the Accounting Admin role (or Admin). Creating, opening and saving a reconciliation needs the Accounting role.
  • Have the statement's closing date and ending balance to hand.
  • If your company has turned on Account Reconcile - Require Zero Difference to Close, the Close button stays greyed out until Difference is zero.
  1. Start a reconciliation

    1. Go to Accounting > Audit > Account Reconcile. The list is headed Bank/Credit Reconcile. It opens filtered to statements from the start of your fiscal year (the Statement is greater than … chip); click the chip's remove button to see older ones. (Reconcile Ledger, next to it in the menu, is a different report.)
    2. Click Create at the top of the page. The Create Bank/Credit Reconcile for New Period window opens.
    3. Set Statement Date (it defaults to today) and type the statement's Ending Balance. A negative balance is allowed but shows the warning "Typically the Ending Balance would be entered as a positive value…".
    4. Pick the bank or credit card Account: type its account number (searching by a name with hyphens may find nothing). Leave Currency on the default unless the account is held in another currency.
    5. Click Create. Cetec briefly shows "New account Reconcile Created Succesfully" and opens the reconciliation (Bank Account Reconcile n).
  2. Tick the cleared items

    1. Open the reconciliation: in Accounting > Audit > Account Reconcile, click the number in the ID column. The page is headed Bank Account Reconcile n (or Credit Account Reconcile n for an account under Liabilities).
    2. In Deposits and Checks and Payments (Payments and Charges on a credit card account), tick each item that appears on the statement.
    3. Watch the figures at the top: Cleared Balance is the beginning balance less checks and payments plus deposits, and Difference is Ending Balance less Cleared Balance.
    4. Click Update to save your ticks. Cetec shows "Account Reconcile Updated Succesfully".
    5. To list unreconciled items from every statement date, not only those up to this statement's date (useful for finding something that never cleared), click Show All; Hide Transactions returns to the normal view. Click Update first: Show All reloads the lists and drops ticks you haven't saved.
  3. Upload the bank statement

    Instead of ticking every line by hand, you can load the statement file and let Cetec match it.

    1. On the reconciliation, click Upload Statement. The Bank Statement Import window opens.
    2. Choose the file under Upload a New Document. It must be .xls, .xlsx or .csv, with at most 2,500 rows. For a .csv, check the Separator box that appears (default ,).
    3. Click Import File. The file's rows appear in a table, including your column-name row. In each column heading, change Specify Column to Date, Check Number, Description, Amount or Ignore (Date and Amount are required), and untick Use ? on the column-name row.
    4. Click Finish Editing. When it passes, the buttons change to Upload and Return To Editing. Click Upload. Cetec shows "Bank Statements Has Been Uploaded Succesfully" and matches the lines to ledger items (matched statement lines are highlighted green and the ledger items ticked).
    5. Use Re-run Matching to match again without importing, or Remove Imports to take the imported lines off. Remove Imports also unticks the items it matched, although its message says your selections won't be affected.
  4. Close the period

    1. On the reconciliation, check that Difference is zero and click Update.
    2. Click Close and confirm "Are you sure you want to Close the reconcile?".
    3. Click Print (it appears once the reconciliation is closed) to keep a copy of the reconciled and unreconciled items.