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

Feedback and Knowledge Base