Amount to reconcile field is not zero

The Amount to reconcile field might not show a zero amount due to a number of reasons, such as uncleared cheques or deposits, or an incorrect bank statement. This topic was designed to help you determine the cause and provides a list of possible reasons to investigate.

Reconciliation differences must be resolved before you can select Reconcile and finish the reconciliation process.

Uncleared or unmatched cheques or deposits (or charges and payments)

Make sure that the following is true:

• All transactions that have cleared the bank have been matched and cleared.
• You entered all manual transactions and that the amounts are the same on the statement as what you entered into Intacct.

An item was accidentally matched or cleared

You might have accidentally matched or cleared an item that did not clear the bank yet. Filter to view matched transactions on the reconciliation page.

As a best practice, during reconciliation, only check off items that you’re sure have cleared. Uncheck the item that was inadvertently cleared.

Transactions entered in a previously reconciled period

When your books were open, a transaction might have been entered and erroneously posted to a period that had already been reconciled.

Try one of the following solutions:

• If the transaction is in the correct period, reopen the reconciliation and re-reconcile.
• If the transaction is not in the correct period, edit the transaction to fall in an open period or the correct or current period.

Credit card reconciliation book balance does not match the GL balance or Bank register

Make sure that you do not have any employee expense reports with a credit card payment type. These transactions will not appear for reconciliation.

Instead, record a credit card transaction or journal entry.

Other reasons

1. Did you enter the statement ending balance correctly?

   Select Edit to edit the balance.

2. If this is your first reconciliation, did you correctly enter the appropriate initial open items? And, did you clear the Compensating initial open items entry?
3. Did you enter all miscellaneous charges that appear on your statement? For example, service charges and interest earned in the case of bank reconciliations, or finance charges and other fees in the case of credit card reconciliations.
4. Verify that you selected the cleared checkboxes for all the cheques and deposits (or charges and payments) and adjustments that have cleared the bank in the case of bank reconciliations.

If the balance is still not zero

1. Determine if the difference is divisible by nine.

   If you can divide nine into the difference, resulting in a whole number, you might have made a transposition error. If this is the case, go back and examine each item carefully, comparing it to the amount shown on the bank statement. If you find one, you can correct it by you adjusting the General Ledger.

2. If you still cannot find the difference, make an adjusting entry by selecting More actions > Add interest and charges on the account reconciliation page. Enter a debit or credit with the description of reconciliation adjustment entry.

Key fields on the account reconciliation page

The following are key fields on the reconcile bank account page and reconcile credit card page.

Account reconciliation page field descriptions

Field	Description
Ending bank balance or Ending credit card balance	This is the ending balance from your statement that you entered on the first page of the reconciliation process.
Ending book balance	The account balance is taken directly from the General Ledger. This sum does not include any initial open items, or the compensating entries for those items. If you're reconciling at the top level, the book balance is the sum of the balances for all entities.
Difference	The amount remaining after the Ending book balance is subtracted from the Ending bank balance; should be zero. Difference = Ending Bank Balance - Ending Book Balance
Uncleared balance	The sum of all uncleared items that affect the General Ledger (does not include the initial open items or compensating entry).
Amount to reconcile	The amount remaining that you need to resolve before you can finish the reconciliation. Amount to reconcile = Uncleared balance - Difference This amount must equal zero before you can reconcile.