Receivables Aging Schedule

The Accounts Receivable Aging Schedule is a report that lists all of the unpaid (open) invoices created in both the Receivables system (miscellaneous invoices) and the Job Cost system (contract billings) as of a cutoff date. This report includes an aging column for current, 30 day, 60 day, 90 day, and 120+ day amount, as well as 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.

AccuBuild uses up to three different account numbers for receivable amounts depending on the set up in the Receivables > Properties and Job Cost > Properties options. 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).  If these amounts do not match, then please refer to the documentation titled Reconciling Receivables.

My AccuBuild Reports

•A/R Aging Schedule - Job Order (arrep01.552):  

•A/R Aging Schedule - Customer Order (arrep01.553):  

•A/R Aging Schedule - Current Totals (arrep01.554):  This version does not include Unbilled Retention.

•A/R Aging Schedule - Job Order - Full Detail (arrep02.552):  

Crystal Reports (through Receivables system)

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

•Job Order – Customer Summary (arrep01b.rpt): Prints the total of all invoices for each customer in job number order.  A partial list may also be generated for selected jobs.

•Job Order – Customer Detail (arrep01c.rpt): Lists each invoice for each customer in job number order.  A partial list may also be generated for selected jobs.

•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.

Adding Collection Notes to an existing MAR Report (Version 10.0.0.5):

•If the Advanced Company Setting titled 'EnableARCollectionNotesTracking' is enabled, then notes can be entered on the Clients Center > Customer Tab regarding the payment status of each invoice.   Our Professional Services team is available for Tailored Report Solutions if you would like to incorporate the A/R Collection Notes into an existing MAR Report.  Please contact AccuBuild Support for more details and a price quote.