Reconciling Accrued Payroll using General Ledger Detail

Issue/Symptom/Question

What transactions make up the balance in the Accrued Payroll Account?

Applies To

PENTA for Windows

Finance and Accounting

Payroll

General Ledger

Resolution/Fix/Answer

Using the Workbench Accounting Reporting Center Panel - General Ledger report, the Accrued Payroll Account can be reconciled.

Limit the Panel to the Accrued Payroll Account Number using the Edit feature for Panel Parameters, then click on the General Ledger report.  Make sure the date range is appropriate.

Create a report similar to this:  Payroll GL Detail.xlsx

Trace all Pay period end distribution dates to the next set of PR Gross to Net Entries and the Check Distribution Entries.  The total should net to zero.  The attached report has a color scheme to link the same period entries together.

For example:

Pay Period ending 11/19/17 Distributions (all entries with that description dated 11/13/17 - 11/19/17) will have check distribution of 11/24/17.  Those entries will need to be combined with the Gross to Net Entries associated with 11/19/17 date.  See the red font on attached report and summarize all amounts, which will net to zero.

Any balance remaining as of a date could be made up of the following:

  1. Distributions for the current pay period (bright yellow on bottom of attached)
  2. Distributions from prior pay period where gross to net has occurred but check disbursement has not yet occurred  (light yellow on bottom of attached)