- Build a payroll expense expectation from headcount and pay rates
- Reconcile quarterly Forms 941 and annual wage reports to the general ledger
- Test accrued payroll, bonuses and compensated absences at period-end
- Design procedures for the existence of employees on the payroll
Where payroll risk sits
Payroll is high volume and usually well controlled, so substantive work leans on analytics and reconciliations. The risks are fictitious employees, unauthorized pay changes, misclassification between cost of sales and overhead, and period-end liabilities: accrued wages, bonuses, paid time off, payroll taxes and benefit withholdings. AU-C 330.18 applies to payroll expense and the related liabilities as significant accounts.
Analytics as the main substantive test
Payroll expense is predictable, which makes it a good candidate for a substantive analytical procedure under AU-C 520. Build the expectation from data you have tested or can corroborate:
- headcount by month and department from HR records,
- average pay rates and the timing of raises,
- overtime patterns, and
- the employer tax and benefit rates.
Disaggregate by department or location and by month. An annual company-wide comparison will hide offsetting changes. Set a threshold for investigation and document the expectation, the comparison and the follow-up, as AU-C 520.08 requires.
Reconciliations to tax filings
Employers report federal income tax withheld and Social Security and Medicare taxes on Form 941, the Employer's Quarterly Federal Tax Return. Annual wages go on Forms W-2 and W-3. Reconcile:
- The four quarterly Forms 941 to gross wages in the general ledger.
- The 941 totals to the W-3 total.
- Taxes per the returns to payroll tax expense and payments.
Differences point to unrecorded payrolls, misposted bonuses or fringe benefits, or noncash compensation not run through payroll. Look also for deposit timing: IRS Publication 15 sets deposit schedules, and late deposits bring penalties that may need accrual. The 941-to-GL reconciliation template lays it out.
Period-end liabilities
- Accrued wages: days worked but unpaid at period-end, times the daily payroll. Agree to the first payroll after year-end.
- Bonuses: agree to the plan, board approval and the measures used. Check whether the obligation existed at year-end even if the amount was set later.
- Compensated absences: ASC 710 requires accrual of vacation and similar absences when the obligation relates to services already rendered, the rights vest or accumulate, payment is probable and the amount can be reasonably estimated. Test the hours or days, the pay rates and the policy for carryover.
- Withholdings and benefits: agree 401(k) deferrals, health premiums and garnishments withheld but not yet remitted to the subsequent remittance.
Existence of employees
Fictitious employees are the classic payroll fraud. Procedures include matching the payroll register to HR files, comparing bank account numbers and addresses across employees and to vendor files, looking for employees with no tax withholding or no benefit elections, and confirming terminated employees stop being paid. The ghost employee testing guide and the payroll anomaly finder cover the data tests.
Common file findings
- Payroll "analytic" that compares this year with last year with no expectation.
- No reconciliation of Forms 941 to the ledger.
- PTO accrual accepted with no test of the hours or the policy.
- Officer compensation not compared with approvals.
Payroll expectation and accrual at Brookfield Home Health, LLC
Expectation for field staff wages:
- Average field headcount: 84 for January-June, 92 for July-December.
- Average hourly rate: $26.00 before a July 1 increase, $27.30 after.
- Average paid hours per employee per month: 150.
January-June: 84 x 150 x $26.00 x 6 = $1,965,600. July-December: 92 x 150 x $27.30 x 6 = $2,260,440. Expected: $1,965,600 + $2,260,440 = $4,226,040. Recorded: $4,318,000. Difference: $91,960, or 2.2 percent. The threshold is $60,000, so the team investigates. Overtime reports show 3,400 overtime hours in December during a flu outbreak, at 1.5 x $27.30 = $40.95 per hour: $139,230 of wages, compared with about $50,000 of overtime normally included in the average hours. The excess of about $89,000 explains the difference.
Accrued wages: the last payroll covered through December 24. Unpaid days December 25-31: 5 working days. December field payroll, including the outbreak overtime: $465,000 / 22 working days = about $21,136 per day. Accrual expected: 5 x $21,136 = about $105,700. The client recorded $105,500. Agreed to the January 7 payroll.
Self-check
Answer each question before you open the answer.
Why reconcile Forms 941 to the general ledger?
Show answer
The returns report wages and taxes filed with the IRS. Differences can reveal unrecorded payrolls, misposted compensation or wages paid outside payroll.
When does ASC 710 require accrual of vacation pay?
Show answer
When the obligation relates to services already rendered, the rights vest or accumulate, payment is probable, and the amount can be reasonably estimated.
Name two data tests for fictitious employees.
Show answer
Comparing bank accounts and addresses across employees and with vendors, and matching the payroll register to HR files for hire dates and approvals. Employees with no withholding or benefits are another flag.
Use it on the file
- GuidePayroll Audit Procedures: Walkthrough, Control Tests and Substantive Tests With a Worked Example
- GuidePayroll Liabilities and Accrued PTO: Year-End Testing Procedures With Calculations
- TemplatePayroll Testing Workpaper
- ToolPayroll Anomaly Finder: Ghost Employee and Duplicate Pay Tests from CSV
- TemplateAudit Program: Payroll
Sources
- AICPA Statements on Auditing Standards (AU-C sections), currently effective
- IRS: About Form 941, Employer’s Quarterly Federal Tax Return
- IRS Publication 15, (Circular E), Employer’s Tax Guide
Standards are paraphrased from the primary sources listed above; read the source before relying on a requirement. This lesson is training material, not professional advice. Report an error