The Estimates vs Actuals (Pay Register Report/Comp Accum) is a production report that can be executed from the cost estimate screen. This report compares a cost estimate with actual pay register and optionally comp accumulator data.
The Estimate Year parameter allows you to specify which year in the estimate to compare to the actual global compensation collected for specified period of time. Use ‘0’ for all years.
By default the report should run in base currency. The report can also be generated in home and host currencies as long as the currency true-up was enabled during the cost estimate data entry and exchange rates were provided prior to pay register entry.
Warning – If actual pay register or comp accumulator data does not have a currency amount that matches the currency for the report, then that actual amount will be included on the report as 0. The report will not error, and will lead to an inaccurate report.
The Begin and End date parameters determine which pay registers will be displayed as actual data. The report will use the pay date of each Approved pay register. If you are checking off ‘Include Comp Accumulator Data’ then these dates will apply to the Payment Date for the Comp Accumulator data. This date range is displayed on the report. Data from Unapproved pay registers is not included.
Include Comp Accumulator Data should be checked if you want the actual values shown on the report to include Comp Accumulator Data.
Specify the Comp Accumulator Start Date (If Different From Above) if you want the Comp Accumulator data included in the actuals to use a different date range than the Pay Register data. This report will use the Payment Date for Comp Accumulator Data.
Specify the Comp Accumulator End Date (If Different From Above) if you want the Comp Accumulator data included in the actuals to use a different date range than the Pay Register data. This report will use the Payment Date for Comp Accumulator Data.
Note: The date range displayed on the report is the Begin and End dates above, the Comp Accumulator start and end dates are not shown.
You can Run in Background if you would like to report to run in the background and access the report after it is complete.
