Acute Data Systems

How to Create and set up Bank Codes in Sage 100

Summary

Bank Code Maintenance lets you define and manage up to 36 bank accounts in Sage 100 ERP. You can access this feature from the Setup menu in Accounts Payable, Accounts Receivable, and Payroll.

Resolution

Access Bank Code Maintenance from within the Setup menu under each of the following modules:

  • Accounts Payable
  • Accounts Receivable
  • Payroll

Access Bank Code Maintenance from within the Main menu under each of the following modules:

  • Common Information
  • Bank Reconciliation

Resolution

  1. Go to the Setup or Main menu in the relevant module.
  2. Select Bank Code Maintenance.
  3. Type the code in the Bank Code field, or use the lookup button.
  4. Enter the Description (bank name or account description).
  5. Choose the Cash Account Number from the G/L Account List.
    • You can create accounts here if you have the following:
      • Auto Create when all Segments are Valid set to Yes or Prompt in General Ledger Options.
  6. Enter the Bank Account Number (appears on statements and checks).
  7. Enter the Next Check Number (optional; auto-increments with each check).
  8. Select a Form Type for check printing (if available).
  9. Choose a Default Form Code for check printing.
    • If you have none selected, the system uses the first form code on file.
    • Graphical forms override user-specific codes in Report Manager.
  10. Enter the Current Balance (running total of debits and credits).
    • During setup, this won’t match the General Ledger due to outstanding checks and deposits.
  11. Enter the Address, Zip Code, City, State, and Country.
    • City, State, and Country auto-populate if you have a valid Zip Code entered.
  12. Enter the bank’s E-mail Address and click E-mail to open your default email program.
  13. Enter the bank’s URL Address and click Web to open the browser.
  14. Add the bank Contact person’s name.
  15. Enter the Telephone and Fax Number.
  16. Add any Comments if needed.
  17. Click Accept to save.

Important Notes

  • Bank Code “A” is the default. You can’t delete.
  • Bank Code “Z” Use for clearing. Don’t use it if you plan to use the A/P from A/R Clearing feature.
  • In Payroll, select a bank code and click MICR to enter encoded check info. You must have MICR fonts installed.
  • During Accounts Payable System Startup, set up the default bank code first.
  • In Division Maintenance, if you have the Cash Account field filled, check postings use that account. Leave blank to default to the Bank Code’s account.
  • You can’t change the next check number until processing is complete if Bank Reconciliation is active.
Sage 100
Request Support