Skip to content
logo Knowledgebase

What reports can I use to reconcile Payroll to General Ledger?

Created on  | Last modified on 

Summary

Reconciliation reports for Sage 300 CRE Payroll to General Ledger.

Resolution

CAUTION: Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.

Use the following reports to reconcile your Payroll amounts 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. See How can I condition a General Ledger report to show a specific date range? for details.

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, this step isn’t needed.
  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 generated accrual entries are made, the amounts may be off for expenses by the accrual amount for that month and in the following month in certain reports. For example, 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? 

 

Need more help?

Chat now