Receivable Aging Schedule

The Receivable Aging Schedule is a report that lists all of the unpaid (open) freight billings and citrus billings as of a cutoff date. This report includes an aging column for current, 30 day, 60 day, 90 day, 120+ day amounts, and one for unbilled retention amounts. The aging column that is selected for each invoice amount is determined by comparing the invoice date with the report cutoff date.

This report should be printed as of the end of each month with the Reconstructed option and reconciled to the corresponding account(s) on the general ledger Trial Balance report.  The cutoff date controls which invoices are included on the report.  For example, if a cutoff date of 04/30/1999 is entered, then any invoice with an invoice date that falls after 04/30/1999 will NOT be included on the report.  The reconstructed option allows AccuBuild to re-build the aging schedule to reflect all unpaid invoices as of the cutoff date even if the money was received after the cutoff date.

The hand tag codes which are assigned to each dispatch entry is used to control the general ledger interface of the invoices and each hand tag code could conceivably use a different account number for accounts receivable.  The aging schedule prints a total balance amount on the last page of the report and this amount should equal the total of the general ledger accounts receivable account(s).  

The Aging Schedule may be printed in three formats:

•Invoice Ref No Order (arrep01a.rpt): Lists each invoice in order of the unique invoice number that is assigned to each billing.

•Customer Order - Summary (arrep01d.rpt): Prints the total of all invoices for each customer. A partial list may also be generated for selected customers.  

•Customer Order – Detail (arrep01e.rpt): Lists each invoice for each customer. A partial list may also be generated for selected customers.