Aged Accounts Receivable Chart

Use the Aged Accounts Receivable chart to view your posted Accounts Receivable information, with aging data for the current project. This includes the total amount billed, paid and unpaid balances, outstanding retainage, and the length of time that the receivables have been outstanding.

Contents

If your firm uses Vision Multicurrency, the currency code displays and all currency amounts display in the project's billing currency.

Field Description
Billed This field displays the total amount billed on the project, which is the sum of the Billed + Tax Billed amounts that are shown in the Navigator Invoices tab and the Accounts Receivable tab in Vision > Accounting > Project Review. Retainage is included in the Billed amount.

Calculation: Billed = Billed + Tax Billed amount on posted invoices

Paid This field displays the paid amount on the project.

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

Unpaid This field displays the unpaid balance, which is the sum of the total Amount Due on the project through today's date. Retainage is excluded from the unpaid amount.

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

Aging Categories The aging columns display outstanding amounts, as of today, in the following categories:
  • >30: This column contains outstanding billed amounts that are 31 through 45 days old
  • >45: This column contains outstanding billed amounts that are 46 through 60 days old
  • >60: This column contains outstanding billed amounts that are 61 through 90 days old
  • >90: This column contains outstanding billed amounts that are 91 through 120 days old
  • >120: This column contains outstanding billed amounts older than 120 days

Calculation: Aging Categories = Aged billed labor amounts

Retainage If the project has outstanding retainage, the sum of the Retainage amount displays. This is the sum of the Retainage column on the Invoices grid. It is not included in the Unpaid or Aging Categories amounts.
Tooltips

Tooltips display when you hover over or tap various parts of the Navigator interface, including buttons, status and warning indicators, and data on the dashparts and charts. You can also click the buttons to view specific calculation information, and click the More links to access the pertinent Navigator online help.

If you are using a tablet device, the tooltip hover action is not available, but you can tap the buttons and More links to view the calculations and online help.