Overview
The Compensation By Accounting Period report shows Compensation related expenses in a monthly format, for tracking and reconciling payroll activity as posted to the BFS General Ledger nightly. The data includes activity in the Compensation accounts for both current and non-current funds. Use this report to verify that payroll correctly posted in each Accounting Period throughout the year and answer questions such as:
- What were the compensation and benefits expenses for the employees in my entity each month so far this year?
- What were the compensation and benefits expenses for a specific employee by fund and Chartfield 1?
Reports
Report Views
- By Account Category includes Account Category and employee first and last name with actual amounts by month and total.
- By Account Category Expanded includes all of the above plus Employee ID, Account Description, Fund Code, Dept ID, Program Code, CF1 and CF2.
- By Employee includes Employee last and first name, Employee ID and Account - Desc with actual amounts by month and total.
- By Employee Expanded includes all of the above plus Fund Code, Dept ID, Program Code, CF1 and CF2.
You can show subtotals or grand totals, exclude columns, move columns, change the sort order of data within a column, and include these columns that aren’t present in a report.
Drill Down
The Compensation By Accounting Period and General Ledger Detail reports use the same data set. When you click on the link for an amount in the Compensation By Accounting Period report, Cal Answers opens the General Ledger Detail report so you can see the transaction details that sum to the clicked value. Click the Return link in the bottom left corner of the window to return to the Compensation By Accounting Period report. See User Experience Tips for more detailed information about drill down.
Prompts
Dashboard Prompts
- There are 3 required prompts that are identified with an * and are selected by default.
- For best performance, it is recommended that you select additional prompt(s) to limit the results. Filtering on Org and/or Account is recommended.
Compensation by Accounting Period Prompts
In addition to the Dashboard Prompts that apply to all reports in the General Ledger Reporting dashboard, this report allows you to select prompts that are specific to General Ledger Details. For explanations of these prompts, see the General Ledger Reporting Data Dictionary.
User Experience Tips
- To search by Employee ID without adding additional prompts, first click Apply in the dashboard prompts. Once you have received a message stating that your query has returned no results, add the value in question to the Employee ID prompt and click Apply on the lower section of prompts (Page Prompts).
- Results and bookmark links may take slightly longer to load in this report than for the General Ledger Summary and General Ledger Detail tabs, because all months through the selected accounting period need to be loaded.
- This report does not have the 00-Beg column like the By Accounting Period report does because there are no transactions in Period 0 for compensation account codes.
- For date prompts, if you mean to say December 31, 2020, type 12/31/20 or 12/31/2020 but not 31/12/20 nor 31/12/2020.