📁 Finance

Payroll Manager Prompt: Pay Run Variance Check and Hold List

Paste this run's and last run's gross pay by employee plus known changes: get a variance table, owner questions, a hold list and notes for each pay change.

4.0
1Reviews
P
November 11, 2026

Prompt

Act as a payroll manager who compares every pay run with the previous one before it goes to the approver. You have seen duplicate timecards, overtime nobody approved, a terminated employee paid again and a raise keyed to the wrong date, and you catch them by explaining every change in gross pay line by line. You do the arithmetic visibly. You never calculate tax withholding or give tax or legal advice; those numbers come from the payroll system.

Inputs:
- Pay period, pay date and frequency: [PayPeriod]
- Gross pay by employee for this run (hours, rate or salary, gross): [CurrentRun]
- Gross pay by employee for the previous run: [PreviousRun]
- Changes you already know about (hires, terminations, raises, bonuses, leave): [KnownChanges]
- Variance threshold that needs an explanation: [Threshold]
- Work locations and pay types (hourly non-exempt, salaried exempt): [WorkforceDetails]
- Approval deadline and approver: [ApprovalDeadline]
- Who answers questions about time and pay changes: [Owners]

Generate:
1. Variance table: one row per employee with previous gross, current gross, difference, and the KnownChanges item that explains it, or UNEXPLAINED. Add a totals row and check that the differences add up to the total difference.
2. Reconciliation line: total explained plus total unexplained equals total difference, with the numbers.
3. Questions for owners: one per unexplained row, addressed to the right person in Owners, asking for the fact you need (for example which workweek the overtime fell in, or whether a timecard was imported twice).
4. Hold list: rows that should not be approved until answered, and the corrected total if a suspected error is confirmed.
5. Pre-approval checklist for this run only: items specific to the hires, terminations and changes in the inputs, plus checking that overtime for non-exempt staff is counted per workweek and that state rules are confirmed.
6. Short plain-language notes for employees whose pay changed for a known reason, saying what changed and from which date. No tax figures.
7. Approver summary in five lines or fewer: total difference, how much is explained, what is on hold, and the decision needed by the deadline.

Rules: use only the numbers in the Inputs and show each calculation. Do not invent rates, hours, tax amounts or policy. Mark anything you cannot verify as a question.

Instructions

Paste gross pay figures from your payroll register, not net pay, and strip Social Security numbers, bank details and home addresses first. List every change you already know about in KnownChanges so the prompt can tell expected from unexpected. Variation: for a semi-monthly run, add the number of workdays in each period to PayPeriod. Tip: keep the approver summary in your run log so the next review starts from it. Cedar Row Bakery and its staff are invented examples. This prompt checks arithmetic and wording; tax withholding, overtime rules and final approval stay with your payroll system, your state's rules and the approver. Not tax or legal advice, and PromptDig is not affiliated with OpenAI, the IRS or the Department of Labor.

Generated Output

This image was generated using the prompt above.

Payroll Manager Prompt: Pay Run Variance Check and Hold List - Result

Examples

Example Input

PayPeriod: October 26 to November 8, 2026, biweekly, pay date November 13
CurrentRun: Tom Alvarez 80 h x 26.00 = 2,080.00; Marco Reyes 80 h x 21.00 = 1,680.00 plus 18 OT h x 31.50 = 567.00, gross 2,247.00; Lena Ortiz 160 h x 25.00 = 4,000.00; Priya Nair 64 h x 22.00 = 1,408.00; Dana Kim 0.00; Sam Okafor salary 2,500.00 plus bonus 250.00 = 2,750.00. Total 12,485.00
PreviousRun: Tom Alvarez 1,920.00; Marco Reyes 1,680.00; Lena Ortiz 2,000.00; Priya Nair 0.00; Dana Kim 1,760.00; Sam Okafor 2,500.00. Total 9,860.00
KnownChanges: Tom raise from 24.00 to 26.00 per hour from October 26; Priya hired October 29; Dana's last day was October 24 and her final pay went out in the previous run; Sam retention bonus 250.00 approved by the owner
Threshold: explain any employee change over 10 percent or over 200.00
WorkforceDetails: Cedar Row Bakery (fictional), one state; Tom, Marco, Lena and Priya hourly non-exempt; Sam salaried exempt
ApprovalDeadline: November 11, 3 PM, approver Maya Chen (owner)
Owners: kitchen lead Jo for hours and overtime; Maya for pay changes and bonuses

Example Output

1. VARIANCE TABLE
Employee | Previous | Current | Difference | Explained by
Tom Alvarez | 1,920.00 | 2,080.00 | +160.00 | Raise 24.00 to 26.00 from Oct 26 (80 h x 2.00 = 160.00)
Marco Reyes | 1,680.00 | 2,247.00 | +567.00 | UNEXPLAINED (18 OT h x 31.50 = 567.00, no approval in KnownChanges)
Lena Ortiz | 2,000.00 | 4,000.00 | +2,000.00 | UNEXPLAINED (160 h vs 80 h last run)
Priya Nair | 0.00 | 1,408.00 | +1,408.00 | New hire Oct 29 (64 h x 22.00)
Dana Kim | 1,760.00 | 0.00 | -1,760.00 | Last day Oct 24, final pay in previous run
Sam Okafor | 2,500.00 | 2,750.00 | +250.00 | Retention bonus approved by Maya
Total | 9,860.00 | 12,485.00 | +2,625.00 |
Check: 160 + 567 + 2,000 + 1,408 - 1,760 + 250 = 2,625.00. Matches.

2. RECONCILIATION
Explained: 160 + 1,408 - 1,760 + 250 = 58.00
Unexplained: 567 + 2,000 = 2,567.00
58.00 + 2,567.00 = 2,625.00

3. QUESTIONS FOR OWNERS
To Jo: Marco has 18 overtime hours. Which workweek were they in, and were they approved? Overtime is counted per workweek, so please confirm the split between the week of Oct 26 and the week of Nov 2.
To Jo: Lena shows 160 hours for a two-week period, double last run. Was her timecard imported twice, or did she work extra shifts?

4. HOLD LIST
Lena Ortiz: hold until Jo confirms hours. If the extra 80 hours are a duplicate, her gross is 2,000.00 and the run total becomes 12,485.00 - 2,000.00 = 10,485.00.
Marco Reyes: confirm the 18 hours were actually worked and split them by workweek before approval. Under the FLSA, overtime that was worked must be paid even if nobody approved it in advance; a missing approval is a policy issue, not a reason to withhold pay.

5. PRE-APPROVAL CHECKLIST
- Priya: Form W-4 on file (with no W-4, federal withholding defaults to single or married filing separately with no adjustments), any state withholding form, and Form I-9 Section 1 done by her first day with Section 2 within three business days of her start.
- Priya: 64 hours from Oct 29 matches her timecards.
- Tom: new rate 26.00 is effective Oct 26, the first day of this period, so all 80 hours are at the new rate.
- Dana: no pay in this run; confirm she is inactive so she is not paid again.
- Sam: bonus is coded as a bonus earning, not salary.
- Marco: overtime counted per workweek; confirm your state's overtime rules.
- Withholding and employer taxes reviewed in the payroll system preview.

6. EMPLOYEE NOTES
Tom: Your hourly rate went from 24.00 to 26.00 starting October 26. This check is the first one at the new rate.
Priya: Welcome. This check covers your hours from October 29, your start date, through November 8.
Sam: This check includes the 250.00 retention bonus Maya approved.

7. APPROVER SUMMARY (Maya, by Nov 11, 3 PM)
Total is up 2,625.00 from last run.
58.00 is explained by Tom's raise, Priya's start, Dana's exit and Sam's bonus.
2,567.00 is on hold pending facts: Lena's doubled hours and the workweek split for Marco's overtime.
If Lena's hours are a duplicate, the corrected total is 10,485.00.
Decision needed: approve once Jo answers both questions.

Share this prompt

Reviews (0)

Please login to leave a review.
Loading reviews...