Automating Accounts Receivable in QAD 3

Posted on: February 21, 2022 | By: David Kwo | QAD Financials

Does your company currently allocate multiple employees to manually apply cash and ensure that invoices match orders, even when the majority of accounts are matched anyways? Logan Consulting can help companies save time and resources by automating this process so that manual cash application is only needed in the case of discrepancies.

To automate payments, Logan creates an Excel file for clients to paste data into. The file is then uploaded to the QAD system, which processes the data and flags discrepancies that need to be manually addressed. This process can be completed in as little as a day, and allows companies to reallocate employees to other responsibilities.

This blog walks step-by-step through the setup of banking in QAD which leads to the automation the cash application process. This blog walks through the Excel file creation and upload. Read this blog to learn about the process of running the Process Incoming Bank Files program in QAD.

Step 1

Create Daybooks.

Step 2

Create Chart of Accounts

Define various accounts as they lend themselves to your unique business process. (AR, PIP)

Step 3

Define Bank Account format for Routing and Account in Bank Account Format Maintain

Step 4

Define Payment Formats (check/ACH/wire) in Payment Format Maintenance

Step 5

Define Own Bank Number in GL Account Modify

Step 6

Create Own Bank Number to Payment Format in Bank Payment Format Link

Step 7

Add Banking to Customers and Supplier

Next Steps

If you are interested in learning more about automating Accounts Receivable in QAD and/or maximizing the use of your QAD system, contact us here to find out how we can help you grow your business. You can also email us at info@loganconsulting.com or call (312) 345-8810.



2020 Nucleus Research Report on ERP Technology

Free Download:

2020 Nucleus Research Report on ERP Technology

Download the guide ›