Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Reconciliations

Reconcile bank accounts

  1. Select
    Actions
    , then
    Reconcile Bank Accounts
    .
  2. Go to the
    General Information
     tab and select the account to reconcile in the Reconciliations list.
  3. Enter the following information from your bank's statement:
    • Statement beginning/end date
    • Beginning balance
    • Deposits and additions
    • Checks and payments
    • Ending balance
  4. (Optional) Use the
    Bank Statement Import
     tab to import transactions from the bank.
  5. (Optional) Select
    Edit
     and then
    Initial Open items
    . You can use the Initial Open Items screen to enter transactions that won’t affect the bank account balance but are needed for reconciliation purposes only. In other words, the transactions you enter in this window were already accounted for at some point in the account balance, but they are not listed with the other transactions available for clearing in the reconciliation. This feature is typically used to correct or enter outstanding transactions from previous reconciliations that were completed in your previous accounting application.
  6. Use the
    Deposits & Additions tab
    , the
    Checks & Payments tab
    , and the
    Direct Deposit tab
     to clear the transactions from the application that appear in those tabs. Mark the checkbox in the transaction row to clear a single transaction or select
    Edit
     then
    Clear All
     to mark all transactions as cleared. The Total row shows the statement amount, selected amount, checks and other payments amount, cleared total, adjustment total, and unreconciled amount based on the information you entered in the grids.
  7. If you need to have your client make adjustments to their bank account, use the
    Client Adjustment Transmittal tab
     to describe those adjustments. This doesn't affect any balances, but will appear on the
    Bank Account Reconciliation Transmittal
     report you can provide to your client. 
  8. Go to the
    Account Summary
     tab and review the balances and differences in the reconciliation. Select
    Adjustment
     to make an adjusting entry for the unreconciled amount, if necessary. This tab provides an overview of the balances based on the transactions on the bank statement compared to the balances based on the transactions entered or imported for the bank account, displaying any unreconciled amount.
  9. Use the
    Reconciliation Analysis
     tab for suggestions on how to balance the reconciliation. The suggestions are grouped in the following categories: checks and payments, deposits and additions, general ledger balance, and notes.
  10. When the unreconciled amount for the bank account is zero, select
    Finalize
     to finalize the bank reconciliation for this account.
  • Before you can close the reconciliation or move to another screen, you'll need to select
    Finish Later
    ,
    Finalize
    , or
    Cancel
    .
  • If you need to edit a reconciliation that's already been finalized, select it in the Reconciliations list, select
    Edit
    , and then
    Unfinalize Reconciliation
    . This will change the reconciliation status to Pending for the selected reconciliation and any reconciliations completed after the newly unfinalized statement. After you make the necessary corrections, be sure to finalize the statement and all subsequent pending reconciliations.

This article applies to:

  • Product: Accounting CS Client Access
  • Subject: Bank reconciliation

Related content