AR Aged Report

Project managers and finance managers use the AR Aged report to manage their outstanding accounts receivable. For each project, the report displays the balance due, the length of time the receivables have been outstanding, and when the last cash receipt was posted. You can include a detail line for each invoice.

Use the AR Aged report to do the following:

  • Decide when a client payment is delinquent. The report displays unpaid balances by age, so you can determine if you need to increase the collection effort for a client.
  • Forecast cash flow. If you monitor your AR Aged report and your AR Ledger report over a period of time, you can see clients' payment patterns.
  • Obtain financing. You can use the report to show potential lenders the receivables owed to your firm.

Records Search

In the Records field for the AR Ledger report that is located on Reporting tab of the Reporting form (where you select the AR Ledger report), use the Project search to search on an invoice number or on unpaid invoices. These searches help you locate projects that have at least one invoice that matches your criteria. However, they do not filter the invoices. The report still includes all of the invoices for each project that you select.

Leading Zeros in Invoice Numbers

If your enterprise uses leading zeros in invoice numbers but you do not want to display the zeros on the report, set the Display Invoice Leading Zeros option to No on the Options tab of the Accounts Payable form (Settings > Cash Management > Accounts Payable).

Contact Name and Phone Number

Contact names and phone numbers only appear on the AR Aged report if the contact is specified in the billing terms. This is true even if you set Client Detail to Display to Contact and Telephone on the Options tab.

Credit Memos

Credit memos are not listed separately on the AR Aged report. Credit memos posted against an invoice are reflected in the invoice balance listed on the report.

AR Comment Review Access

The Accounts Receivable Comment Review Access option on the Accounting tab of the Roles form (Settings > Security > Roles) controls whether or not you can view invoice comments on this report.

Pre-Invoices

If you select the Use Pre-Invoices option on the Options form in Billing Settings (Settings > Billing > Options), you can choose whether or not to include pre-invoices on the AR Aged report using the Include Pre-Invoices check box on the AR Aged report Options tab. The AR Aged report will include unpaid pre-invoices that are not canceled, in addition to regular invoices. The drill-down hyperlinks for pre-invoices are disabled in the report.

Retainer Balances

Retainer balances display on the report and are sorted using the billing client that is entered for a project on the Accounting tab in the Projects hub.

Expanding and Collapsing Report Groups

If you are using Microsoft SQL Server 2008 and if, on the Options tab for this report, you elect to display client address information or AR comments and you also enable the option to collapse and expand a report group, Vantagepoint disables the expand/collapse option for report groups when you generate the report with this set of options. This is necessary because a defect in Microsoft software would cause the report to fail otherwise.