Operations AR - ACH & Card Payments Reporting and Batch Cutoff Times

We will walk through how to create customized downloads that may be helpful in reconciliation. Kodaris offers automation to most ERPs via a bank lockbox EDI file. Kodaris acts like a bank when using the Kodaris AR Automation module; your reconciliation process may differ from the example here.  

Through the Kodaris Employee Portal, you can filter your company’s Accounts Receivable records by various data sets. You can even customize your AR grid to include the data sets you need specifically for reconciliation. Some of the most useful filters that can assist with reconciliation are batch date, credit card types, ACH payments, and transaction types. Once you’ve configured your filters with the necessary fields, you can download a copy as a .csv file, which is compatible with spreadsheet-based programs like Google Sheets, Microsoft Excel, etc.

To begin adjusting your AR grid to view the data needed for reconciliation, you’ll start on the Accounts Receivable tab, and then navigate to the columns icon located on the top right of the grid.

This will bring up a list of all the filter options. To add a field to your AR grid, select the checkbox of your desired field. To remove a field, deselect its checkbox. 

Once the fields you require are selected, the grid will update in real time, and you’ll be able to see the data sets you need for reconciliation.

From here, you can further filter and customize the grid for reconciliation purposes.

First, you’ll want to filter the Transaction Type (Txn Type) by “Web Account Payment” to indicate to the system that you want to pull payments initiated by your customers via the Kodaris platform. 

To do this, click the small, down-pointing arrow next to “Txn Type”, then select “Web Account Payment”.

In the CC Type column (Credit Card Type), you can click the down-pointing arrow next to the title of the column to select the invoices paid by Visa, MasterCard, American Express, and/or Checking. The “Checking” filter is for transactions paid via ACH.

The Batch Date filter is particularly important because it allows you to see what days your customer payments were batched out for processing. The batch-out date can also be a helpful indicator of when your company might receive the funds; however, keep in mind that you’ll receive payment on your bank’s schedule and when they settle your payments. 

To sort invoices by batch dates, click on the down-pointing arrow next to the title of the column, then choose a condition and your desired date(s). 

Once your grid is set up to show all of the fields you need for reconciliation, you can continue to view all the information in the Portal, or you have the option to download the .csv file, which is compatible with spreadsheet-based programs. 

To do this, click on the download icon on the top right-hand side of the grid.