Accounts Receivable
Bank Code Setup
← AR Introduction

Bank Code Setup

Configure the company bank(s) used for check printing, vendor payments, and customer deposits. The main screen defines core banking, G/L mapping, check ranges, and adjustment codes; the Additional Information screen controls print routines, EDI/ACH options, default accounts, and per-user/department access.

Main Fields (Bank Code Setup)

Fields 11 & 12 are used for bank transfer, since system creates a deposit in the Cash Receipts Journal and a Check for the Check Register. See Bank Transfer.

Bank Code
Unique identifier for this bank (numeric or alphanumeric as configured).
1. Bank Name
Display name (e.g., “Bank of America”). Appears on printed checks and reports.
2. G/L Company Code
Company entity for financial posting; shows company description for confirmation.
3. G/L Cash Account
Primary cash account used for disbursements/receipts from this bank.
4. Bank Account Number
Internal reference for the bank account (masking may apply on reports).
5. Bank Type
Used to distinguish check vs. deposit banks when applicable (typical value 1 for checking and deposits.).
6. Manual Checks From / 7. Checks To
Inclusive check number range for manual/handwritten checks (e.g., 81–9999).
8. Last Check # Used
System-maintained after posting; initializes the next suggested check number.
9. Check Format
Specify the format of Check#'s I.e 5N to indicate 5 digit numeric.
10. Adj Code List
Per-bank adjustment codes and their G/L accounts (see Adjustment Codes).
11. Vendor Account No.
Vendor Account for this bank. Used when doing a bank transfer to indicate which Vendor Code used for transfers.
12. Customer Account No.
Customer Account for this bank. Used when doing a bank transfer to indicate which Customer Code used for transfers.
13. Post to G/L (Y/N)
Controls whether transactions from this bank flow to General Ledger during posting.
14. Group Code
Optional grouping/tag used in reports or multi-bank selections.

Additional Information

The additional screen is designed to enter certain parameters that control the printing routines as well as EDI routines if you plan to use possitive pay with the bank. Please consult with ATS for help.

Fields 8, 9 and 10 are used for Credit Card Processing. See Process CC Payments.

1. Print Check Routine
Program/routine name used to render checks (e.g., *ATF626$DESKTOP).
2. Form Routine Name
Form/layout routine; pairs with the print routine to control alignment.
3. Print Blank Page Add Sheet?
Y/N. Prints an additional page for stub/backer, as required by your form.
4. Add Sheet Routine
Routine for the additional sheet (e.g., *ATF626$DESKTOP.ADD).
5–7. EDI/ACH Settings
Outbound/Inbound routine names and outbound user login credentials for electronic payments.
8. Default Vendor
Used for default Vendor when processing Credit Cards. I.e Misc. Expenses (Vendor).
9. Default Expense GL Acct#
Default GL Expense Account for unspecified charges. (I.e Meal & Entertainment).
10. Payment Bank Acct#
Bank Code for paying the Credit Card Charges.
11. External Bank Name
Alias shown to partners/bank portals (e.g., “ACH Account”).
12. Valid Department(s)
Restrict bank usage to specific departments. Leave blank for all departments.
14. Valid User(s)
Whitelist of users authorized to use this bank (display shows code and full name).

If your environment has custom print or EDI routines, confirm names with ATS Support before deployment.

Setup Procedures

Configure a Bank for Check Printing

  1. Create a new Bank Code and enter Bank Name, G/L Company, and G/L Cash Account.
  2. Set Bank Type, check range (Manual From / To), and confirm Check Format.
  3. Optional: define Vendor/Customer defaults and Group Code.
  4. Ensure Post to G/L = Y if this bank should flow to General Ledger.
  5. Open Additional Information and configure Print Check Routine, Form Routine, and Add Sheet options.
  6. Set Valid Departments and Valid Users to control access.
  7. Save, then print a test check to confirm alignment.

Configure a Bank for Deposits / ACH

  1. Complete the core fields as above (Bank Name, G/L Company, G/L Cash Account).
  2. In Additional Information, set External Bank Name (e.g., “ACH Account”).
  3. Populate Outbound/Inbound EDI routines and credentials if using electronic deposits.
  4. Set Valid Departments/Users to restrict who can post deposits.
  5. Post a small test deposit and verify the G/L posting and bank reconciliation.

Adjustment Codes (per Bank)

Use the grid in line 10. Adj Code to maintain bank-specific adjustment codes (e.g., RA Rate Adjustment, WO Write-off/Bad Debt), each mapped to the proper G/L Acct#. The description prints on stubs/reports; the account controls posting.

This codes are used when doing a deposit and the customer has over or under paid an invoice, and you wish to adjust the difference.

  • Keep mappings consistent across banks to simplify reconciliation.
  • Review with accounting before adding write-off or fee codes.

Security & Access

  • Valid Department(s) limits bank visibility/usage to selected departments.
  • Valid User(s) lists individual users permitted to post against this bank.
  • Restrict setup/changes to AR supervisors or administrators.

Best Practices

  • One bank = one cash account. Avoid sharing the same G/L Cash across multiple active banks.
  • Check ranges: Keep manual ranges separate from MICR/laser stock to prevent collisions.
  • Test prints: After changing routines or formats, print one check to confirm alignment.
  • Audit trail: Set Post to G/L to Y whenever transactions must appear in the GL.
  • Access controls: Use Valid Departments/Users to reduce accidental postings to the wrong bank.