What's The Purpose of Bank Routing and Account Number in A/R Cash Receipt CSV Import?

What's The Purpose of Bank Routing and Account Number in A/R Cash Receipt CSV Import?

Release Date: 02/23/2021
Version: 7.5 & Up

Q - In the A/R Cash Receipt Detail CSV Import, the following two fields are required:
  • Bank Routing#
  • Bank Account#
See sample screen below:



Are these two fields validated against anything? Neither is referenced in the standard AR Cash Receipt processing - so I was just wondering how exactly they are used.

A -  They are not validated against anything. You can put any value in there and it won’t make a difference. The primary purpose is if you have multiple batches of cash receipt data mixed in one CSV file, they will be used to avoid duplication (like the same check number from two different customers since customer number is optional).


EMK

    • Related Articles

    • Feature - Import A/R Cash Receipt Detail -- Add Ability to Process Multiple Customers for One Check

      Release Date: 2/3/2017 In AR --> Processing ---> Cash Receipts processing --> Interface --> Detail, the current program does not allow processing records that have the same check number but have 2 or more customers. The reason this can happen is ...

    • Feature - AR Cash Receipt to Support CS (Cash) Payment Type

      Release Date: 03/03/2022 Version: 8.5 & Up In the A/R Cash Receipt screen, when entering a batch, the system prompts for a payment type. The possible values were: CK=Cash or Check GC=Gift Certificate CC=Credit Card WR=Wired AC=ACH We have now added ...

    • BB17S4 Bank Book Cash Projection Report

      Cash Projection Report Application Overview Without needing the use of extensive financial analysis software the Cash Projection Application allows for a compact view of future cash needs. The application looks at the current cash requirements ...

    • ARCSHENT Accounts Receivable Cash Receipts Processing

      Cash Receipts Processing Application Overview Cash Receipts Processing is an application that you will use quite often. You will use it whenever you have received payments from any of your customers and want to apply those payments to the customer's ...

    • Feature - Customer CSV Import

      Release date: 9/25/2019 Version: 8.5 and up For the Customer CSV Import, select AR --> Utility --> Customer/eContact import --> customer/econtact Import --> Customer import This new screen program will have three menu options: Pre-Interface, ...