Download$19
Employee Census Checker Skill
Check an employee census for health insurance quotes: missing fields, swapped dates, lost ZIP zeros, tier vs dependents, children 26+. Clean copy. $19.
View Employee Census Checker SkillPayroll Register Reconciliation Skill
Find the double payment, the terminated employee still on payroll and the ACH line that doesn't match, before you approve the run.
What it does
Catch payroll mistakes before you approve the run, not after the money is gone. Point it at this period's payroll register (CSV export from Gusto, ADP, Paychex, QuickBooks Payroll, Rippling or any system) and, if you have them, last period's register, the bank/ACH file and an employee roster. You get an exception list with amounts and a sign-off column. Python standard library only; nothing leaves your computer.
python3 -m payrec current.csv --prior prior.csv --bank ach.csv --roster roster.csv --period-end 2026-10-31 --out review/What you get
The screenshot is real output from the kit’s own commands. Tested from a fresh download of this exact zip: ./run_tests.sh ran 7 tests OK on Python 3.13 and 3.10.
Checks
| Check | Needs | What it flags |
|---|---|---|
| NET_MISMATCH | register | net pay doesn't equal gross minus deductions (it finds which formula your export uses: total deductions, taxes + deductions, or the sum of the tax/deduction columns, ignoring employer-side columns) |
| HOURS_X_RATE | hours, rate, regular pay columns | regular pay isn't hours x rate |
| DUPLICATE_EMPLOYEE, NEGATIVE_NET, NET_ABOVE_GROSS, DEDUCTIONS_ON_ZERO_PAY, MISSING_AMOUNT | register | double rows and impossible amounts |
| SHARED_BANK_ACCOUNT | account column | two employees paid to the same account |
| NEW_IN_PAYROLL, MISSING_FROM_PAYROLL, GROSS_CHANGE, RATE_CHANGE | prior register | new or dropped people, gross changes over 10% and $100 (--pct, --abs), rate changes |
| PAID_AFTER_TERMINATION, PAID_WHILE_INACTIVE, NOT_ON_ROSTER, ACTIVE_NOT_PAID | roster | terminated or unknown people paid, active people not paid |
| BANK_AMOUNT_MISMATCH, NOT_IN_BANK_FILE, BANK_ONLY_PAYMENT | bank/ACH file | register net vs what the bank will pay, payments to IDs not in the register |
Columns are found by common names (Employee ID, Gross Pay, Net Pay, Total Deductions, Federal Income Tax, 401k, ...); comma or semicolon files, $1,234.50, (12.00) and 1.234,50 amounts all work. Override any column with --col field="Your Header".
Outputs: exceptions.csv (severity, check, employee, detail, amount, reviewed_by, resolution) and summary.md (totals vs prior and bank, the exception table). Exit code 1 if there are errors, so it can gate an approval step.
./demo.sh runs a planted October 2026 example (13 exceptions). ./run_tests.sh runs the tests. Claude Code plugin with a skill in skills/payroll-reconciliation/.
Not included (on purpose)
It does not recalculate taxes, check minimum wage, overtime rules or garnishment limits, or give tax or legal advice: those depend on jurisdiction and belong with your payroll provider or accountant. It checks that the numbers add up and that changes are expected.
Honest limits
- One row per employee per register (several rows for the same ID are flagged as duplicates; pre-sum split checks first).
- Matching across files is by employee ID.
Also see the Duplicate Payment & Vendor Audit Skill and the Employee Census Checker. License: LICENSE.txt.
Format and license
Zip, 17 KB, v1.0, 16 files. You may use and modify this kit for your own work and for clients you serve, including paid client work. Not affiliated with or endorsed by any payroll provider.
FAQ
- Which payroll systems?
- Any that exports a register to CSV: Gusto, ADP, Paychex, QuickBooks Payroll, Rippling and others.
- Does it check tax amounts?
- No. It checks that the numbers add up and that changes are expected; tax rules belong with your payroll provider or accountant.
- Is employee data uploaded?
- No, it runs on your computer.
- How do I get the files?
- Right after payment, Stripe’s confirmation page shows your download link.
- Refunds?
- Email hello@youraitools.co within 14 days if it doesn’t work and we can’t fix it.
- Can I pay with crypto?
- Yes. Pay the same price in USDC or USDT on Base, Ethereum, Arbitrum, Optimism, Polygon or Solana from the "Pay with crypto" button, with no account or KYC. We check the payment on-chain and show your download links as soon as it confirms.
Get Payroll Register Reconciliation Skill
Payroll register reconciliation from CSV exports: net-pay math, prior-period changes, paid-after-termination, duplicates, register vs ACH file. $29.
Save with a bundle
- Back-Office Ops Skills Bundle: 4 products for $49 ($86 separately, you save $37).
Pairs well with
Download$19
SaaS Spend Finder Skill
Find software subscriptions in card or bank exports: monthly and annual cost, double charges, price increases, overlapping tools, renewals. Local, $19.
View SaaS Spend Finder SkillDownload$19
Sales Pipeline Hygiene Checker
Pipeline hygiene check for CRM exports: past-due close dates, stale and stuck deals, missing amounts, duplicates, slipped deals. Fix list per owner. $19.
View Sales Pipeline Hygiene Checker