Skip to content

Reconcile an account manually

In manual mode you don’t import the bank statement. Instead, you mark check register transactions as cleared until the reconciled balance matches the ending balance on your statement.

The bank account must have Manually Reconcile Account selected in Setup › Accounting › Banking / Cash › Bank Accounts. Accounts set up this way show YES in the Manual Reconcile column of the reconciliation list.

The Manually Reconcile Account checkbox on a bank account, and YES in the Manual Reconcile column

  1. On the Accounting tab, select Account Reconciliation, then Reconcile Bank Accounts.

  2. Double-click the account, or select it and then the edit button.

    The account list with the edit button

  3. Select the Reconcile Statements tab, then select the new button.

    The Reconcile Statements tab and the new button

  4. From your bank statement, enter the Statement Date and Ending Balance, then select Continue.

    Statement Date, Beginning Balance, Ending Balance and Continue

    Every unreconciled check register item shows: checks and payments on the left, deposits and other credits on the right.

    The unreconciled checks and payments, deposits and other credits, and the balance summary

  5. Mark each item that’s on your bank statement as cleared: double-click its Rec column to show C, or select Mark All. The totals at the bottom right update as you go.

    Items marked C in the Rec column and the updated totals

  6. To add a fee or interest line from the statement, select Fees/Interest:

    1. Select the Date.
    2. Select the Fee Reason. Fee reasons are set up under Setup › Accounting › Banking / Cash › Fee Reasons.
    3. If the fee reason has a default location, it’s filled in. If not, select the Location.
    4. Enter the Amount.
    5. Select Save. The fee is added to the bottom of the list. Mark it C to clear it.

    The Bank Fees/Interest window with Date, Fee Reason, Location and Amount

  7. When the Difference is 0.00, select Save. When asked whether to finalize the statement, select Yes.

    The Finalize Statement message with a Difference of 0.00

If you need to add or remove a transaction on a finalized statement:

  1. On the Reconcile Statements tab, clear Hide finalized reconciled statements, then open the statement.

    Finalized statements listed after clearing Hide finalized reconciled statements

    Transactions reconciled on that statement show R in the Rec column.

    Reconciled items marked R

  2. To remove a transaction, double-click its R. The Difference at the bottom right shows the amount you removed.

    An item unmarked and the Difference showing its amount

  3. Mark the right transaction to balance the statement, then select Save.

If you leave the statement out of balance, it shows an amount in Difference and NO under Reconciled. You can come back at any time to balance and finalize it again.

A statement with a Difference and NO under Reconciled