Allocate a 30-employee payroll journal across departments with ChatGPT agent
- Source date:
- Last verified:
- 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
Prompt Recreated prompt
The source did not publish its exact prompt. This one is our reconstruction from what the source describes.
Not sure how to start? Tell me what you're trying to get done and I'll help you turn it into a clear request. Goal: Enter this pay run's payroll data into my payroll allocation spreadsheet. Quick check first: Is the template set up the same way as last time, or has anything changed? What I need from you: - Your 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. If any of this is unclear, tell me what you have and I'll help fill the gaps. You'll know it worked when: the totals match the payroll journal and every employee is allocated.
Source
https://x.com/jasononfirms/status/1963628292873109898
By Jason Staats (@jasononfirms) · Published Sep 4, 2025 · Added Oct 15, 2026 · Last verified Oct 15, 2026
Related cases
- Split, rename and sort about 200 scanned invoices with Claude CoworkRecreated promptEvidence: Described by poster
After the poster scanned almost 200 invoices, Claude Cowork split them out, renamed them, sorted them into folders and created a summary Excel file.
Claude Cowork · Ops · Source date:
- Categorize 419 ledger transactions into an Excel template with ChatGPT agentRecreated promptEvidence: Screenshots or logs
Given an Excel ledger template and 419 transactions, ChatGPT agent asked for help on ambiguous merchants, then keyed in all ~400 rows and took 4 minutes.
Poster says:Done in 4 minutes
ChatGPT agent · Ops · Source date:
- Turn six months of receipts into a categorized spreadsheet with Claude CoworkRecreated promptEvidence: Shown on video
Pointed at a folder, Claude Cowork organized 6 months of receipts into a categorized spreadsheet with monthly breakdowns.
Claude Cowork · Ops · Source date: