AR Ledger Options Tab
Use the Options tab to select report options for the AR Ledger 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. |
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). |
Due From Projects | If you select Include or Include Only in Intercompany Subledger Transactions, use this field to select the projects for which you want to include intercompany invoices. |
Only Include Invoices Posted Through | Select this check box to restrict the report to invoices dated in or before the accounting period that you specify in the unlabeled field that displays when you select this option. The report displays all receipts for the invoices, regardless of receipt date. For example, you generate the report for invoices posted as of 09/2020. If you received payments for those invoices in 10/2020 and 11/2020, the report also displays those receipts.
Use this option to get an accurate picture of your accounts receivable for invoices generated before a specific date. |
Exclude If Paid Prior To | Select this check box to exclude invoices that were paid in full in or before a specified accounting period. You select the accounting period in the field that displays below this option when you select it. |
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 Modification Detail | Select this check box to display the invoice number, the year and month, and the number of postings for the accounting period for which the report is generated. |
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 Billed/Received Totals | Select this check box if you want the project totals and final totals sections to include totals of billed, received, and retainage amounts. This option only applies to the project level. If you sort and group the report by phase or task, the report does not display total billed, received, and retainage amounts for those.
Paid Invoices You have three options for retention of paid invoices (invoices with a zero balance) in the ledger:
This decision determines how old the information in a ledger report can be and the accuracy of the final billed and received amounts. For more information, see your finance manager or system administrator. |
||||||||||||||||||||||||||||||
Display Average Collection Period | Select this check box to include the average collection period at the end of the report. The average collection period is the average number of days between when you issue an invoice and when you receive payment in full. This value reflects only the paid invoices included in the report. | ||||||||||||||||||||||||||||||
Display Retainer's Balance | Select this check box to display the entire retainer balance for a project on the report. This option is only available if the Use Retainers field is set to Yes on the Options form in Billing Settings ( ). | ||||||||||||||||||||||||||||||
Column To Display Interest | Select the column where interest amounts are going to be displayed. You specify the headings for the applicable columns on the Accounts Receivable settings form in Billing settings ( | ).
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 report 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 Number Rollup slider box displays the number of characters in your (firm's) project numbers. For example, if you use a 10-digit project number, the slider box displays
123456790. A project number can also include up to two delimiters (such as, 12-345.67890).
To roll up, 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 number rollup, use this option to select how you want to display the project data:
|
Phase Number Rollup Options |
Use this option to summarize report information at the phase level for phases that use a standard numbering system. This option is only available if you use phases. The Phase Number 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 (such as 12345.12). You can roll up the phase number 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 Number Rollup slider (box) to cover the project number completely. To roll up, 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 Number Rollup Options |
Use this option to summarize report 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 number 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 display only tasks, use the Project Number Rollup and Phase Number Rollup sliders to cover the project number and phase number completely. To roll up, 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. |