Automating Accounts Receivable in QAD

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 process of automated Accounts Receivable. Read this blog to learn how to run the Process Incoming Bank Files program in QAD. Read this blog to learn how to setup banking in QAD which leads to the automation the cash application process.

Step 1

Download bank file from applicable bank

Step 2

Paste data into Excel file created by Logan

Step 3

Review files for errors and/or missing data. Look at the “Data” tab for record count, total amount in, invoice numbers, etc.

Step 4

If there are no errors, save file in an easily accessible location for uploading to QAD. When needed, upload file in Incoming Bank File Excel Integration.

  • Navigate to menu Incoming Bank File Excel Integration in QAD

  • Open this program and note the blank grid

  • Select “Import from Excel”

  • Browse to the folder location for saved file, select, and click “Open”

  • The details should load to the grid, and you can review the payments by clicking on the small white triangle that will display all line item details

  • Click Save in the bottom right hand corner of the menu

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.