Fund managers and payroll managers may rely on reports when reconciling payroll expenses against the General Ledger. The information shown on a paycheck in UCPath is often the most current and correct reflection of a pay transaction and best aligns with CDW data. We recommend using CDW Labor Ledger Data to get a truer picture of your department's payroll expenses.

The UCLA General Ledger Team strongly recommends using two specific reports available in the Campus Data Warehouse (CDW) for payroll reconciliation: 

• Relating Labor Ledger data to General Ledger Accounting Period - Salary 

• Relating Labor Ledger data to General Ledger Accounting Period - Fringe 

These two CDW reports pull data that better align with UCPath transactions and provide a more accurate and consistent view of both the salary and fringe benefit expenses because they are recorded within the central payroll ledger. In general, these reports provide a more accurate data than the UCPath Distribution of Payroll Expense (DOPE) report*, which may have a delayed or misrepresented payroll data due to system restrictions. 

When investigating discrepancies between your payroll expense reports and actual paychecks, it's best to prioritize the Labor Ledger data in CDW. If a specific transaction still looks questionable after reviewing the CDW reports, create a case with the General Ledger team to review the next best step. 

*NOTE: The DOPE report may still be appropriate for other features, such as the DOPE restatement flags.