AR-06 Aged Trial Balance

Entering a cut-off date allows you to run the report and capture the correct aging for your accounts receivable without having to log into EPASS with a previous report date.

This does not allow you to run the AR-06 historically—it only changes the date used to determine which aging column an amount goes into.

Select a specific customer to report on, or leave this field blank to include all customers in the report.

These two options are commonly used when you want each store or each salesperson to follow up on their accounts receivable. Branch can be based on the invoice or the customer profile.  Be careful if you run this by branch and a customer purchases from multiple stores, as they will appear on the ATB for each branch but each branch’s report will only show the transactions related to their branch.  Most clients that use this option prefer to select the branch based on the customer.  That is,  if they are a customer of branch 1, then print all activity on the ATB for branch 1, no matter where they bought from.

If you have separate net 30 customers, vendor AR, and builder AR, you may want separate reports to go to different staff to follow up on.  The payment type can also be selected based on the customer or invoice.  See notes above for the branch.  If you wish to run this report by customer, you may want to reach out to our technical support team to update all customers with no default payment type to COD.

Sometimes you want to print a report just for your overdue customers so they can be followed up on. This option in conjunction with the Print Customer Notepad make this a very effective way of staying on top of your overdue accounts.

Use this as a cleanup report or to look at your customers requiring a refund. When you run this for Zero Balance Only, you have a list of customer where their account overall balances out to zero but because of misallocated funds the account will not drop.

The two versions of this report True A/R and Only Deposits need to balance to the two GL reports (G/L Account Status or Trial Balance) for the two control accounts.  It is normal to have to make a JE from one control account to the other as splitting invoices that had deposits on them will cause a variance but, they should still be overall in balance.

Selecting this option gives you a strong collections report when running for overdue account selections.

This will include what you have not delivered on your ATB.  Normally, this is not done as it is misleading but is very helpful to see where the company is once everything gets delivered.

This option controls which column payments from open invoices appear. When checked, the payments will always go into the current column. When unchecked, the payments will appear in the column related to when that payment was taken.

The Future column is not commonly used and so has been made optional on the report.