Real Agent Cases

Allocate a 30-employee payroll journal across departments with ChatGPT agent

Posted
by Jason Staats (@jasononfirms)
Last checked
Method:
How we verify

Evidence: Screenshots or logsThe source shows screenshots, a transcript or the agent's output.

Outcome

ChatGPT agent mapped a payroll CSV into a 30-employee allocation spreadsheet across 6 departments, making 180 entries and summing employer-paid columns in under 4 minutes.

Poster says:180 entries in under 4 minutes

This is the source's own number. We haven't measured it.

Agent

ChatGPT agent

Prompt Recreated prompt

The source didn't share its exact prompt, so we wrote this from what it describes.

Here's a task I'd like your help with. Read it all the way through before you start.

Goal: Enter this pay run's payroll data into my payroll allocation spreadsheet.

Check with me first: Is the template set up the same way as last time, or has anything changed?

What I'll give you:
- My payroll allocation spreadsheet template
- The pay-run payroll journal (for example a CSV with gross pay, employee deductions and employer-paid items)

Rules:
- Map each column from the payroll journal into the right place in the template.
- When a template line combines several journal columns (like employer payroll taxes or employer-paid benefits), add them up and tell me which columns you used.
- If something is missing or unclear, ask me instead of guessing.
- Don't change the template's formulas or layout.
- Stop when the spreadsheet is filled in and hand it back to me to review.

Output: The completed spreadsheet plus a short list of the assumptions you made.

You'll know it worked when: the totals match the payroll journal and every employee is allocated.

Try this in:

ChatGPT Used in sourceGemini Grok

Sends the Recreated prompt shown above. ChatGPT and Grok open with it filled in, and ChatGPT may send it straight away. Gemini opens empty, so we copy the prompt for you to paste. Every button also copies it.

Opens in a new tab. We don't see what you send.

These links are only a shortcut. We're not affiliated with OpenAI, Google or xAI, and your results may not match the source.

Optional stronger version

Our rewrite with extra checks. The poster didn't test it.

Here's a task I'd like your help with. Read it all the way through before you start.

Goal: Enter this pay run into my payroll allocation spreadsheet across departments.

Quick check first: tell me if anything below is missing or unclear.

Inputs (fill in or confirm):
- Allocation template
- Payroll journal CSV (gross, deductions, employer costs)
- Employee-to-department mapping
- Any changes since last run
- Pay period dates

Rules:
- Map each employee to a department; flag anyone not in the mapping.
- Allocate gross pay, deductions and employer costs by the template's rules.
- Don't change formulas in the template.
- Keep a check row comparing totals with the journal.
- Round only where the template rounds and show any rounding difference.
- Keep personal data (salaries) only in the template, never in notes.
- List new starters and leavers separately.

If you get stuck: If an employee is split across departments without a rule, ask me. If a login, CAPTCHA or two-step code appears, stop and ask me to handle it; never guess or store passwords.

Verify before you finish: Confirm totals per column equal the journal totals exactly.

Output: The filled template, check row and exceptions list.

Done when: department totals add up to the journal to the cent.

Source

https://x.com/jasononfirms/status/1963628292873109898

Related cases