Aged Accounts Receivable Chart

Use the Aged Accounts Receivable chart that displays on the Invoices form in the Projects hub to view your posted accounts receivable information, with aging data, for the current project. The Aged Accounts Receivable chart always reflects data for the currently selected work breakdown structure (WBS) level. For example, if you navigate to the phase level, the chart reflects the AR data for the selected phase.

Contents

If your firm uses multiple currencies, the project's billing currency code displays above the chart, and all currency amounts are in that currency.

Field Description
Billed This field displays the total amount billed. Retainage is included in the amount in Billed.

Calculation: Billed + Tax Billed amount on posted invoices

Paid This field displays the paid amount.

Calculation: Applied Retainer + total of Amount Paid column in the grid + Unapplied Retainer (shown in Receivables Information)

Unpaid This field displays the unpaid balance, the total amount due through today's date. Retainage is excluded from the unpaid amount.

Calculation: Outstanding amount through today on posted invoices (sum of the Amount Due column in the grid)

Retainage If the project has outstanding retainage, the sum of the retainage amount displays. This is the sum of the Retainage column on the grid. It is not included in the amount in Unpaid or in the aging category bars on the graph.

This field is available only if you set Use Retainage to Yes in Settings > Billing > Options.

Aging Categories The horizontal axis of the graph displays the aging categories (for example, 30 days, 60 days, and so on). Each bar represents the outstanding billed amount for that aging category, as of today.