AR Ledger Report

Use the AR Ledger report to review billing history. For each project, phase, or task, the report displays invoices generated and payments received. The report also displays the average collection period for all paid invoices.

In the Records field at the top of the form, you can 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, these searches do not filter the invoices. The report still includes all of the invoices for each project that you select.

Settings for Headings and Invoice Mappings

You specify the headings for the AR Ledger, and map invoice accounts, in Settings > Billing > Accounts Receivable.

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

Credit Memos

Credit memos are listed separately on the AR Ledger report, below the invoice to which they apply. The Mod/Receipt Description column for a credit memo displays the words Credit Memo to help distinguish it from a row that represents an invoice, a receipt, retainage, or retainer.

If the Include Modification Detail check box is selected on the Options tab, then a credit memo’s posting period and posting sequence number display in the Mod/Receipt Description column instead of the words Credit Memo.

Sort and Group by Billing Group

If you group by Billing Group Name or Billing Group Number, Vantagepoint uses the project name and number for projects that do not belong to a billing group.

Multiple Companies

If you use multiple companies, the column headings and account mappings are based on the mappings set up for the company that owns each project.