Contents of the Revenue Reconciliation Inquiry Screen

Use the fields and options to configure the Revenue Reconciliation Inquiry screen.

View Revenue Reconciliation

Field	Description
Fiscal Year	Enter, or click to select, the fiscal year from which to view GL and project revenue amounts.
Period	Enter, or click to select, the period from which to view GL and project revenue amounts.

GL Filters

Use the fields in this group box to customize the result set for general ledger records.

Field	Description
F/S Code	Enter, or click to select, the type of financial statement you want to view. This option controls which accounts are treated as revenue accounts in the comparison. Only accounts mapped to this financial statement with a Revenue flag are included in the GL Total.
Account Level	Enter an account level from which you want to view revenue amounts. This option controls how detailed the account breakdown is. Enter 1 to see top-level account segments. Increase the number for more details. Enter 0 to view full account-level details.
Account	Enter, or click to select, the account from which you want to view revenue amounts.

GL and Project Filters

Tip: When you enter a Project and set Project Level to 2, the Costpoint includes all child projects associated with the selected top‑level project in the totals. This behavior provides a rolled-up view of project data. To view child projects individually, increase the Project Level or leave the Project blank to display all projects.

Field	Description
Project Level	Enter a project level from which you want to view revenue amounts. This option controls how projects are rolled up. Enter 2 to see projects at the second level (e.g., GP30.01 rolls up all child projects beneath it). Enter 0 to view full project details.
Organization Level	Enter an organization level from which you want to view revenue amounts.
Rate Type	Use this drop-down list to filter revenue amounts according to the rate type: The options are: Actual Target This option affects the Project Ledger Total only.
Project	Enter, or click to select, the project from which you want to view revenue amounts.
Organization	Enter, or click to select, the organization from which you want to view revenue amounts.

Additional Options

Use the options in this group box to set time metric filters to the result set.

Field	Description
PTD	Select this option to include revenue amounts from a specified period to the current date.
YTD	Select this option to include revenue amounts from a specified fiscal year to the current date.
ITD	Select this option to include revenue amounts from the project inception to the current date.
GL Total	This field displays the total revenue amount recorded in your General Ledger for the period and filter criteria you selected. The value is retrieved directly from GL transaction posting summary records. It reflects the sum of all values in the GL Period Amount column of the GL table window.
Project Ledger Total	This field displays the total revenue amount recorded in your Project Ledger for the period and filter criteria you selected. The value is retrieved from the project revenue summary, using either Actual or Target billing rates, depending on your Rate Type selection.. It reflects the sum of all values in the PRJ Period Amount column of the Projects table window.
Variance	This field displays the difference between the GL Total and the Project Ledger Total.

GL Table Window

This table window displays GL amounts broken down by project and organization at the level you selected. Each row represents a rolled-up project/org combination.

Field	Description
GL Project	This field displays the ID of the project associated with the general ledger revenue amount.
GL Organization	This field displays the ID of the organization associated with the general ledger revenue amount.
GL Period Amount	This field displays the total general ledger revenue amount for the specified period.

Projects Table Window

This table window displays Project Ledger amounts for the project/org combinations you selected.

Field	Description
PRJ Project	This field displays the ID of the project associated with the project revenue amount.
GL Organization	This field displays the ID of the organization associated with the project revenue amount.
PRJ Period Amount	This field displays the total project revenue amount for the specified period.

Subtask

Subtask	Description
GL Details	Click this link to open the GL Details subtask.