Road Map: Bank Reconciliation

Use the Bank Reconciliation (NBC) program to set up a cash account for reconciliation and enter bank statement transactions, select checks and deposits to clear, and print the Bank Reconciliation Register and clear transactions. See Background for more information.

Before you run this program each time

You should run these programs in this sequence at least once:

  1. AP Invoice Entry (NE) to enter vendor invoices and print the AP Invoice Register.

  2. Vendor Payments (NC) to select invoices for payment and print the Cash Requirements report.

  3. Check Print (NCP) to print a batch of checks.

  4. AP Payment Register (NCR) to print the AP Payment Register and update the general ledger.

  5. (Optional) AP Payment Reversal (NVC) to void a check for reconciliation purposes, reverse payments posted to the general ledger, and print the AP Payment Reversal Register.

Before you run this program the first time

You should run these programs:

  • System Options Maintenance (XM) (Accounts Payable Options) to select the option Bank reconciliation system active?

  • System Options Maintenance (XM) (Enterprise Options) to select a date display format for your enterprise, Branch Maintenance (TBM) to select a date display format for your branch, or User Maintenance (UIM) to select a date display format for an individual user.

  • (Optional) Posting Criteria Maintenance (XPC) for interest, bank fees, and currency gain/loss.

  • AP Installation Check Entry (NBN) to enter AP checks when you begin using the bank reconciliation system.

  • General Journal Entry (GIP) to enter any deposits, interest payments, service charges, or miscellaneous entries not recorded by the system (that is, entered during processing by another program).

  • GL Account Maintenance (GMM) to set up GL organization and account codes.

  • Payment Method Batch Maintenance (TAPMB) to add payment method batches for alternate payments (for example, electronic funds transfers) and include them in bank reconciliation.

  • Output Device Maintenance (XDM) to set up the output devices that you plan to use.

  • Date-Output Device Maintenance (ZE) to select your default output device and set whether you can override that device.

After you run this program

You will most likely run these programs:

  • Outstanding Transaction Listing (NBO) to print a list of transactions that have not been reconciled.

  • Bank Transaction Audit Listing (NBCL) to print a list of bank transactions, including printed checks with a void status.