Bank Reconciliations Overview

Use these general steps to perform bank reconciliations. Be sure to refer to the specific documentation for each step, which includes more detailed information.

It is most advantageous to begin performing bank reconciliations in Costpoint after running Costpoint for at least several periods and when you have enough historical data to warrant successful processing.

However, you must complete the preliminary setup earlier, before you process bank reconciliations, so that the historical Costpoint Accounts Payable (A/P), Accounts Receivable (A/R), and Payroll (P/R) transactions have the necessary data when you are ready to start processing the bank reconciliations.

Steps Performed as Part of the General Costpoint Setup (Prior to Beginning A/P, A/R, and P/R Transaction Processing and Creating Bank Transaction History)

  • Enter bank account information on the Manage Banks screen.
  • Enter detailed setup information for a bank on the Manage Company Bank Accounts screen.
  • Establish cash accounts in Costpoint General Ledger.
  • Assign bank abbreviation and cash account information for Cash Receipts transactions.
  • Assign bank abbreviation and cash account information for Accounts Payable transactions.
  • Assign bank abbreviation and cash account information for Payroll transactions.

Specific Bank Reconciliation Steps

  1. Run the Update Cash Accounts screen.
  2. View Cash Accounts from the Manage Company Bank Accounts screen.
  3. Run the Manage Bank Statement Information screen.
  4. Run the Create Bank Transactions History screen.
  5. Clear checks on either the Accept Bank Transactions screen or the Process Bank Transactions Acceptances screen:
    • Accept Bank Transactions: View all General Ledger and manual adjustment transactions, clear or unclear these transactions, and match them to the bank transactions on a single or multiple-row basis.
    • Process Batch Bank Transactions Acceptances: Clear or unclear groups of transactions based on various selection parameters.
  6. View Bank Reconciliation.
  7. Execute the Print Bank Reconciliation Summary Report.
  8. Execute the Print Bank Reconciliation Detail Reports.