Accounts Receivable Reports
Use accounts receivable reports to monitor and analyze information related to your AR invoices. The accounts receivable reports are available only if your enterprise uses Billing.
When the Billing Client Changes Over the Life of a Project
The following information applies for the AR Ledger, AR Aged, Invoice Register, and Invoice Transaction Detail reports when a project has had more than one billing client over the life of the project:
- When you sort these AR reports by billing client, the reports sort the invoice and accounts receivable information based on the billing client that an invoice is posted with.
Example: A project has invoices posted to different clients over the life of the project—Client A and Client B. When you sort these reports by billing client, the project is listed under both Client A and Client B in the report, based on the invoice details for each billing client.
- On the Options tab for these AR reports, when you specify a client in the Billing Client field, the report displays invoices posted for that billing client and not the current billing client entered on the Accounting tab of the Projects hub.
Multiple Currencies
If you use multiple currencies, the following applies:
- You set report options on standard reports separately for each company. When you switch companies, the standard report options reset back to the default options. However, saved favorite reports, saved favorite options. and saved favorite selections remain the same, even when you switch companies.
- Some reports are company-specific and only include details for a single company. For example, payroll reports are company-specific because they only allow you to view an employee's payroll information for one company at a time.
- On those reports that are not company-specific, you can see details from multiple companies for the same employee. In this case, it is helpful to have a saved favorite with a top-level sort by company, so that each company's data is presented separately.
- Related Topics:
- 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. - AR Comments Report
The AR Comments report lists comments entered for outstanding invoices in the AR Comments dialog box, which you display from the Invoice Review form. - 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. - AR Statement Report
The AR Statement is designed to be sent to a client as a statement of their unpaid balance. - Invoice Register Report
Use the Invoice Register report to view posted billing invoices and credit memos. - Invoice Transaction Detail Report
The Invoice Transaction Detail report supports the option to post fee billed revenue based on transaction detail. On this report, review the transaction detail used to allocate and post fee billing amounts to revenue accounts and to work breakdown structure (WBS) components (project, phases, and tasks). - Retainer Ledger Report
Use the Retainer Ledger report to review summary or detailed retainer information for your projects. The report can help you identify projects for which retainers have been received and where retainers need to be applied. It can also help you reconcile to the retainer account on your balance sheet.
Parent Topic: Report Descriptions