All ideasMore in Work

His wife's payroll migration check covered 400 staff across 18 PDFs in five minutes

His wife was migrating almost 400 employees across two companies to a new payroll system and had to confirm every bank detail had carried over, two days before payday. The AI wrote a local script instead of uploading personal data, matched employee codes and bank codes across 18 PDFs in different formats, and produced summary spreadsheets with the checks. The script can be rerun for the next migration.

How it works

  1. PDFs gathered locally
  2. The AI writes a checking script
  3. Script matches employee codes and bank codes old against new
  4. Summary spreadsheets built with a sheet per sub organisation
  5. Mismatches reviewed by hand

Why it’s worth knowing

The privacy choice is part of the case: the script ran locally because the data was other people's bank details.

Where it’s from

Summarized from a public post on reddit.com. See the original ↗

Upgraded prompt

A ready-to-use prompt for this idea, built from research on what makes AI agents do the job right: who the AI should be, the exact steps, and a check to make sure it was done the way you wanted.

1Who the AI should be
2The prompt, with the steps
3The check when it’s done
Upgraded prompts are coming soon.

Try next

Every idea is a real post from someone who tried it, summarized in our words, with a link to the original. App names are swapped for plain words.