Receivables Aged Trial Balance

This report shows the current and past due transaction amounts, retention withholding and retention billing, and overall invoice balance for a customer, either grouped by customer and totaled for all jobs/master IDs assigned to that customer, or grouped by job/master ID and listed individually for the customer of that specific job/master ID. You can also view report totals for all customers. This report can include information from Service Management, Job Cost, and/or Equipment Management. A job/master ID can be a Job Cost job or project invoice, a Service Management maintenance contract, master contract, or service call invoice, or an Equipment Management rental invoice. The detailed version of this report allows you to review individual posted transactions in addition to total amounts. You can use this report to identify customers with outstanding and past-due balances and view the invoices that have not been paid. You can also use the transaction detail to reconcile your Accounts Receivable GL account. You can print this report from its location in the Report Manager, or from Microsoft Dynamics GP by opening the Administration page and locating this report on the Custom Report List.

Summary - Grouped by Customer

Summary - Grouped by Job/Master ID

Detail - Grouped by Customer

Detail - Grouped by Job/Master ID