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

    • Detail Cash Receipt CSV Import with Negative Values Causes Error Message

      Release Date: 01/19/2024 Version: 8.5 & Up Q - In the KB article: https://support.netcellent.com/portal/en/kb/articles/feature-support-for-discount-amount-and-reference-in-cash-receipts-detail-interface, I see we can use negative amounts with Detail ...

    • 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 ...

    • 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 ...

    • BB1700 Bank Book Bank File Maintenance

      Bank File Maintenance Application Overview The Bankfile is used to store information on all banks that the company may have an account with. This application allows entry of information into this file and then maintenance of this data. This bank file ...

    • BB17S3 Bank Book Running Cash Balance

      Running Cash Balance Application Overview This report shows the transaction activity of a particular cash account for that month. A Running Balance is calculated on a daily basis on which a transaction occurs. A net balance will be calculated up ...