Updated on October 9, 2026

How to find the cause of a mismatch between bank and ledger

Use the Conciliación tool to compare transactions and locate balance differences.

The Conciliación (Reconciliation) option in the Banks module compares bank transactions with the records in the ERP or accounting software, to find differences between the bank balance and the general ledger balance.

  1. 1

    Open Conciliación

    In the Bancos (Banks) module, at the top, select Conciliación. This tool compares the transactions in Ubyquo with those in the accounting software.

    Reconciliation tool in the Banks module
  2. 2

    Choose the transaction and month

    Select the bank transaction you want to review and open the month of its date.

  3. 3

    Locate the mismatch

    Check whether there is a mismatch between the bank transactions and the accounting records.

  4. 4

    Look for the cause

    One possible cause: the transaction was first posted in the ERP or accounting software and then added in Ubyquo without synchronizing the journal. This causes differences between the bank and accounting records.

  5. 5

    Delete the duplicates

    If the mismatch is due to duplicate transactions, review the transaction posted in the ERP or accounting software and delete the duplicate journal entries.

  6. Reconcile again

    Run the reconciliation again to check whether the difference has been corrected.

This procedure helps you locate and correct differences between the bank balance and the general ledger balance, especially at accounting closings.