Reports to reconcile Payroll to General Ledger

What reports to use to reconciliation Payroll to General Ledger in Sage 300 CRE.

Reports to reconcile Payroll to General Ledger

Payroll Reports in Reports, Reconciliation

• Burden by Debit Account
• Deductions by Credit Account
• Fringes by Credit Account
• Taxes by Credit Account
• Labor Costs by Account and Job (delete the Job NE "" condition to see all labor costs by account)

Payroll GL Recap

• Tasks, Print GL Recap - Use accounting date as a condition for comparing bank account entries. This report will show totals by account for all entries from Payroll, excluding Voided checks.

General Ledger Reports

• YTD Ledger - Compare Batch totals
• Entries by Account - Compare Batch entries and Account totals
  Note: When reconciling to Payroll, add a condition for Application of Origin EQ "PR". Also use Ranges to filter the Liability or Expense accounts
• Entries By Batch - Compare Batch totals and review entries (use Ranges to filter by Payroll or the batch)

For the batch reports, use Conditions for the Accounting date range and Account to compare totals.

Conditioning By Batch in Payroll Reconciliation Reports

1. Open the Report in Payroll.
2. Open Conditions on the right in Print Selection.
3. Click Add. If the Add Condition window opens, don't complete this step.
4. Index on the left of the Add Condition window.
5. Select "PR - Check" from the Index list.
6. Click OK to change the Index.
7. Select Batch under the condition Field.
8. Select the Operator Equal to. Use Greater or equal to and Less or equal to when conditioning for a range of batches.
9. Enter the Batch Number in Value.
10. Click Ok to add the Condition.
11. Click Ok to close the Condition Selection window.
12. Click Start or Print Preview to generate the report.

Information

When you generate accrual entries, the amounts can be off for expenses by the accrual amount for that month and the following months. For example, you generated accrual entries to Jan 31 and the checks posted to Feb 1. Both Jan and Feb will be off by that amount, one month will be higher and the other month lower.

The document attached below is for reconciling tax activity in Payroll with the activity posted to payroll tax liability accounts in General Ledger.
Attachment: PRtoGL.docx

If you use intercompany accounting in Payroll, see Why are my Payroll intercompany entries out of balance?