Reconciliation FAQs

Find answers to common questions about reconciliation.

You might be set up with user or account restrictions.

If you manually unmatched a transaction, it can't be automatically matched again using a rule set. Instead, manually match the transaction.

You can check to see if a transaction has been manually unmatched on the Match transactions page for that transaction. Look for the Unmatched by and Unmatched date fields.

Learn how to add initial open items.

There are two options to remove an initial open item:

  • Reopen the reconciliation and delete an initial open item, or,
  • Create a journal entry to zero out an initial open item.

Use filters to view transactions for reconciliation.

If you're using a bank feed, learn why you might not be seeing bank feed transactions.

The Amount to reconcile field might not show a zero amount due to a number of reasons, such as uncleared checks or deposits, or an incorrect bank statement.

Learn more about what you can do when the amount to reconcile doesn’t equal zero.

Make sure that all transactions are matched and that the Amount to reconcile is zero before you select Reconcile. Filter for any partially matched transactions and then complete the match to complete the reconciliation.

  1. Go to Cash Management > All > Reconciliation > Bank or Credit card.

  2. Select the Account to reconcile, Statement ending date, and Statement ending balance, then select Continue.

  3. On the Bank tab, filter for partially matched transactions.

    1. From the State dropdown list, select Partially matched.

    2. From the Transaction type dropdown list, select All.

    3. Select Apply filters.

  4. Select Match next to each transaction and complete each match.

When all transactions are fully matched and the Amount to reconcile is zero, select Reconcile.

Learn how to unmatch a transaction.

Learn how to clear a pending reconciliation.

If you unmatch a transaction, it cannot be automatically matched using a rule set again. Instead, you need to manually match or ignore the transaction.

If your company is configured to Include zero-amount GL transactions in reconciliations and reconciliation reports, voided unconfirmed checks and standard ACH payments appear as zero-dollar transactions in reconciliations and register reports. Learn how to reconcile voided transactions.