The goal of the Checking Account reconciliation is to have a discrepancy of $0.00 after selecting all cleared deposits and checks.

  • All entries can be selected or deselected.
  • Transactions past the statement date can be hidden using the checkbox in the top right corner of the window.
  • Interest and Bank Charge accounts must exist.


Start a Reconciliation

  • Click General Ledger on the Navigator
  • Select the appropriate accounting file if more than one exists
  • Double click on the appropriate checking account in the account List. This will display a check register.
  • Click the Reconciliations button
  • Select Current Reconciliation
  • Enter the appropriate data for the following fields:
    • Statement End Date: Per the bank statement
    • Interest: The amount of interest received on the statement
    • Interest Account: The account to apply the interest
    • Interest Date: The date the interest transaction is to be applied
    • Bank charges: Per the bank statement
    • Bank Charges Account: The account to apply the bank charges
    • Bank Charges Date: The date to apply the bank charge
    • Ending Balance: Per the bank statement
  • Click OK to save the data and open the Reconciliation Detail window
  • Select the cleared deposits and checks
  • To edit the Checking Account Section information:
    • Click Edit Statement Information which opens the previous window allowing the interest or bank charges and the ending balance to be changed.
    • Click Complete this Reconciliation:
      • Mark all checked entries as cleared through the bank
      • Create journal entries for the interest and bank changes
      • If non-zero, generate a journal entry for the discrepancy.
    • A popup window asks which account to apply a non-zero discrepancy journal entry.
    • A confirmation window will open and asks if the reconciliation report should be printed.
    • Click Finish Reconciliation Later to save all changes and close the window if the reconciliation cannot be completed during this session.
    • Click Cancel to close the window



View/Edit Prior Reconciliations

  • Open the account as outlined above
  • Click the Reconciliations button
  • Select View/Edit Prior Reconciliations
  • Select a Reconciliation. If it is marked as "In Process," then it has not been completed.
  • Open Last Reconciliation: Change the most recent reconciliation to a "Current" or "Open" status.
    • This changes the green check marks in the Checking Account register to "outlined" check marks instead of "green" check marks.
    • Note: Any Journal Entries previously created will have to be handled manually.
  • Delete Last Reconciliation: All cleared transactions are "un-checked" and the "green" check marks are removed.
  • Print Reconciliation Statement: Opens the Reconciliation Report criteria window with the selected accounting file/transaction set/bank statement reconciliation end date combination.