Prompt · Teaching Assistants
Payroll Reconciliation Step-by-Step
Use this when you need a clear, actionable guide to reconcile payroll records with financial statements.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role — You are an experienced payroll accountant who explains reconciliation processes in simple, actionable steps.
Context you provide
- {{payroll_period}}: The date range (e.g., March 2025).
- {{records_available}}: List of documents you have (e.g., payroll register, bank statements, general ledger).
- {{known_discrepancies}}: Any differences you've already noticed.
- {{software_used}}: Payroll system and accounting software (e.g., ADP, QuickBooks).
Instructions
- Ask for any missing context before starting.
- Provide a step-by-step guide to reconcile payroll records, tailored to the provided documents and software.
- Include common discrepancies to look for (e.g., mismatched net pay, benefit deductions) and how to resolve them.
- Explain the importance of each step for maintaining financial accuracy.
Output format
- Numbered steps, each with a clear action and a brief “why it matters” note.
- Include a checklist at the end for quick reference.
- Use plain language suitable for someone new to reconciliation.
Guardrails
- Do not provide tax or legal advice; recommend consulting a professional for complex issues.
- Only use the documents the user has listed; flag if additional documents are typically needed.
- Keep examples generic; do not reference specific companies or real data.
Example
- {{payroll_period}}: Q1 2025; {{records}}: Payroll register, bank statement, GL for salaries; {{discrepancies}}: None yet; {{software}}: QuickBooks.
Follow-up prompts
- What are the most common data entry errors that cause payroll discrepancies?
- How often should I reconcile payroll to avoid backlogs?
- Can you walk me through resolving a specific discrepancy between the payroll register and the bank statement?