AR Aged Report Options Tab
The Options tab gives you additional control over the data displayed on the AR Aged report.
Detail Options
Field | Description |
---|---|
Billing Client | To display content only for a specific client or a group of clients on the report, enter a client name or select one or more clients on the Client lookup. |
Billing Group | Billing groups are used to combine projects together for the purpose of billing a client. To have the report show content only for specific billing groups, enter the name of a main project for a billing group, or use the Project lookup to select one or more main projects.
If you use multiple companies and you bill a client for a set of projects worked on by multiple companies within your enterprise, the company that owns the main project in the billing group is the company that generates the invoice for the entire billing group. Use the Billing Group List to review a billing group's settings, its main project, and a list of its sub-projects. |
Aging Date |
Select the date as of which you want to age invoice amounts:
For example, if you select Today in this field and set the Aging Based On option to Invoice Date, the age of an invoice amount is the number of days between its invoice date and the current date. |
Aging Based On |
Select the type of date from which you want to age invoice amounts:
|
Exclude Unassigned Receipts | An unassigned receipt is a cash receipt posted to an invoice for which there is no record in Vantagepoint. Select this check box to exclude unassigned receipts from this report. |
Age Unassigned Receipts | An unassigned receipt is a cash receipt posted to an invoice for which there is no record in Vantagepoint. Select this check box if you want Vantagepoint to include unassigned receipts in the calculation of amounts in the aging columns. Vantagepoint reduces the outstanding balance by the amount of the unassigned receipt. The column affected depends on the date of the receipt. |
Age Interest | Select this check box if you want the amounts in the aging columns to include any unpaid interest on past due amounts. |
Only Include |
Select the appropriate checkbox to include details from the following options:
|
Include Invoice Detail | Select this check box to display the invoice number, date, and amount of the invoice for each transaction posted during the period. |
Include Pre-Invoices |
This check box only displays if you select the Use Pre-Invoices option on the Billing Options form ( ). Select this check box to include pre-invoices on the AR Aged report. The report will include unpaid pre-invoices that are not canceled, in addition to regular invoices. Because pre-invoices have no due date, the Aging Date option (Current Date, Period End Date, or Specific Date) is compared to a pre-invoice's invoice date, regardless of whether you select the Invoice Date or Due Date option. Pre-invoices are included on the AR Aged report based on whether or not the date of the pre-invoice is within the time frame that you select. When you sort and group the AR Aged report by invoice, the pre-invoice number displays in the Invoice column of the report. If you use multiple currencies: The Report In field changes automatically to Billing Currency. You can only run the report with the billing currency when pre-invoices are included on the report. |
Include All Invoices with Retainage | Select this check box to include all invoices for projects with retainage amounts and information in the report. |
Intercompany Subledger Transactions |
If your enterprise uses Intercompany Billing with detailed subledgers enabled, use this option to specify whether or not intercompany transactions created by Intercompany Billing are included on the report. Select one of the following:
If you use Intercompany Billing with detailed subledgers enabled, intercompany invoices are created using a default project number that is specified in Intercompany Billing Setup ( , in the desktop application). |
Display Options
Field | Description | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Client Detail to Display |
If you select None, no additional client information is added to the report. If you select an option other than
None, the effect of that option depends on your selections on the Columns & Groups tab.
|
||||||||||||||||||||||||||||||
Display AR Comments |
Select this check box to display comments that were entered for the invoices in Invoice Review or Project Review. In Start Date and End Date, specify the date range for the comments you want to see. To include comments, you must also sort and group the report by Primary Client Number, Project Number, or both. If the invoice has no project associated with it, the comment prints under the client group header. If the invoice has a project, the comment prints under the project group header. The Accounts Receivable comment review access option on the Accounting tab of the Roles form ( ) controls whether or not you can view invoice comments. |
||||||||||||||||||||||||||||||
Last Receipt by Project | Select this check box to display the most recent receipt for each project. | ||||||||||||||||||||||||||||||
Final Average Age | Select this check box if you want the final totals section to display the average of the number of days between the date selected in Aging Based On and the date selected in Aging Date for all receivables included on the report. | ||||||||||||||||||||||||||||||
Final Receipt Date | Select this check box if you want the final totals section to display the most recent date for all receivables included on the report. | ||||||||||||||||||||||||||||||
Retainer's Balance | Select this check box to show retainer amounts. This option is available only if Use Retainers is selected in | ||||||||||||||||||||||||||||||
Display Interest on Drill Down Report | Select the column in the AR Aging Amount Drill Down report to include interest amounts. For example, if you select Interest and you drill down on an outstanding balance in the AR Aged report that includes interest, Vantagepoint displays the interest amount in the Interest column of the AR Aging Amount Drill Down report. |
Time Frame Options
Field | Description |
---|---|
Time Frame |
Use these options to specify the time frame for data included on the report.
|
Starting and Ending | This field displays when date range or period range related option is selected in a time frame related field.
If a date range option is selected, use the Starting and Ending date fields to identify the start and end date range that will be used to generate the report. If a period range option is selected, specify both a starting and ending accounting period in the Starting and Ending fields to generate the report for selected accounting period. |
Reporting Amounts
Field | Description |
---|---|
Report In |
If you use multiple currencies, select the currency in which to display amounts on the report:
|
Rollup Options
Field | Description |
---|---|
Project Number Rollup Options | Use this option to summarize information for projects that use a standard numbering system. For example, if the first five characters of your project number represent a master contract, you can summarize (roll up) information for all projects that have a common master contract number. The
Project Base Rollup slider box displays the number of characters in your project numbers. For example, if you use a 10-digit project number, the slider box displays
1234567890. A project number can also include up to two delimiters (for example, 12-345.67890).
To roll up project numbers, drag a slider to cover the characters that you want rolled up. You can drag a slider from the left side of the slider box, the right side, or both sides. |
Display Data As | If you set a project base rollup, use this field to select how you want
Vantagepoint to display the project data from the following:
|
Phase Base Rollup | Use this option to summarize report information for phases that use a standard numbering system. The
Phase Base Rollup slider box displays the number of characters in your firm’s phase numbers. For example, if you use a 7-digit phase number, the slider box displays
1234567. A phase number can also include one delimiter (for example, 12345.12).
You can roll up the base phase and still display information by task. When you do, a task total is the total of all occurrences of that task across the base project. For example, the total for Task 00001 is the total of all Task 00001s in the base project. To display only phases and tasks, use the Project Base Rollup slider to cover the project number completely. To roll up phase numbers, drag a slider to cover the characters that you want rolled up. You can drag a slider from the left side of the slider box, the right side, or both sides. |
Task Base Rollup | Use this option to summarize information at the task level for tasks that use a standard numbering system. This option is only available if you use tasks. The
Task Base Rollup slider box displays the number of characters in your firm’s task numbers. For example, if you use a 3-digit task number, the slider box displays
123.
This option works in the same way as the project and phase rollup options. For example, if the first two characters of your task number represent a department, you can roll up information for all tasks that have the same department number. To show only tasks, use the Project Base Rollup and Phase Base Rollup sliders to cover the project number and phase number completely. To roll up task numbers, drag a slider to cover the characters that you want rolled up. You can drag a slider from the left side of the slider box, the right side, or both sides. |