Skip to main content

Reconciling Individual Transactions

Written by Denisa Arjoca
Updated over a month ago

Reconciling individual transactions involves selecting transactions from the bank statement and matching them with transactions that have been entered in Cash Manager.

To reconcile the cash manager:

  1. Go to Bank Reconciliation.

  2. Select the bank account to reconcile and click Next (Next Icon).

    Coins ERP+ displays a list of items from the bank statement file that have not been reconciled to ledger items.

  3. Click the link (in the Date column) of the transaction you want to reconcile.

    Coins ERP+ displays a list of unmatched cash manager transactions.

    You can filter the list to show, for example, only transactions with the same value or check number as the statement transaction you selected.

  4. Select the transaction (or transactions) you want to match to the statement transaction.

  5. Select Reconcile Selected Items from the action drop-down and click Apply Action ().

  6. If the amount of the check as shown on your statement differs from the amount shown in cash manager, you can post the difference to a variance account (for example, an account for interest charges or bank errors), in which case cash manager will update the balances and reconcile the statement.

    cash manager displays the Unreconciled frame.

  7. Fill in the name of the account to receive the difference, and a description of the reason for the variance.

Unmatched statement items

If there are items on the statement, such as bank charges, that do not have a corresponding cash manager transaction, you should manually reconcile these:

  1. On the list of statement items, select the item or items that you want to reconcile.

  2. Choose Reconcile Unmatched Items from the action drop-down and click Apply Action ().

    Coins ERP+ displays the Reconcile Unmatched Items screen.

  3. Enter the variance account to post the transaction value to, and a description.

  4. Click Next (Next Icon).

Did this answer your question?