Sample data. This is the unedited report Payroll Check produced on its bundled sample files, which describe a fictional business, run the same way a subscriber's upload is run (as of 2026-10-14). No AI model and no person touched it. Your own results depend on the exports you upload.
The full download also contains: checks.csv, pay_run_summary.csv, report.html.
Payroll Check
Pay date 2026-10-09 - prepared 2026-10-14
Summary
- Paid 12 employees on 2026-10-09 (13 rows in the register): gross $23,318.00, net $18,569.81.
- Fix before payday: 6 high-priority issues.
- Ben Okafor: Possible double payment
- Erin Walsh: Bank account changed
- Henry Brooks: Net pay up 91.0% from last run
- Ivy Chen: Paid twice in this pay run
- Jack Rivera: Net pay is more than gross pay
- ...and 1 more in the table below.
- Also review 4 medium and 2 low-priority item(s).
- Bank match: 11 of 12 direct deposits found in the bank, 1 not found, 1 possible double payment.
- 1 employee bank account changed since the last run. Confirm each one directly with the employee before payday:
- Erin Walsh: direct deposit account changed from ****3390 to ****9052.
- Compared with last run: 1 new employee, 1 missing, 2 net pay changes over 10%.
Issues to review
6 high, 4 medium, 2 low. High means money may go to the wrong place or not at all; fix these before you approve payroll.
| Severity | Employee | Issue | Detail | What to do |
|---|---|---|---|---|
| HIGH | Ben Okafor | Possible double payment | The bank shows a second debit of $1,563.20 on 2026-10-08 (ACH DEBIT PAYROLL DIRECT DEP). The same amount was already matched on 2026-10-08 (Ben Okafor net pay). | Ask your bank or payroll provider to stop or reverse the extra payment, and let the employee know before they spend it. |
| HIGH | Erin Walsh | Bank account changed | Direct deposit account changed from ****3390 to ****9052. | Confirm the change directly with the employee by phone or in person, not by replying to an email or message (common fraud). |
| HIGH | Henry Brooks | Net pay up 91.0% from last run | Last run $610.00, this run $1,165.00 (+$555.00). | Confirm the reason (hours, raise, bonus, deductions) before approving. |
| HIGH | Ivy Chen | Paid twice in this pay run | Listed 2 times in this register (net pay $980.00, $980.00; $1,960.00 in total). | Remove the extra payment before you approve payroll, unless a second check (for example a bonus) is intended. |
| HIGH | Jack Rivera | Net pay is more than gross pay | Net pay $1,250.00 is $50.00 more than gross pay $1,200.00. | Check deductions and taxes for this employee; net pay can never exceed gross. |
| HIGH | Maya Singh | Payment not found in bank | Direct deposit of $1,330.00 to ****7781 has no matching bank debit between 2026-10-06 and 2026-10-12. | Check with your payroll provider that this payment was sent. Do not pay it again until you confirm it was missed. |
| MEDIUM | (unknown) | Payroll debit not in register | $845.00 on 2026-10-08 (ACH DEBIT PAYROLL DIRECT DEP TO ACCT ****9023) does not match any net pay in this register. | Find out who this payment went to. If it is not one of your employees, contact your bank right away. |
| MEDIUM | Dev Patel | Gross pay does not match hours times rate | 80 hours x $30.00 = $2,400.00, but gross pay is $2,800.00 ($400.00 more). | Check hours and rate. If the difference is a bonus, commission, tips, paid time off or holiday pay, no change is needed. |
| MEDIUM | Grace Kim | Net pay up 14.1% from last run | Last run $1,350.00, this run $1,540.00 (+$190.00). | Confirm the reason (hours, raise, bonus, deductions) before approving. |
| MEDIUM | Leo Grant | Missing from this pay run | Paid $1,290.00 on 2026-09-25 in the previous run but not in this register. | Confirm the employee was terminated, or add them before payday if this is a missed payment. |
| LOW | Grace Kim | Pay rate changed | Rate changed from $21.00 to $24.00. | Confirm the raise or change was approved. |
| LOW | Kim Osei | New employee - confirm new hire | Not in the previous pay run. Net pay $542.00. Direct deposit to ****4410. | Confirm this is a real new hire and that their pay rate and bank account were set up from their own paperwork. |
This pay run
| Employee | ID | Gross | Net | Hours | Rate | Last run net | Change | Account | Bank |
|---|---|---|---|---|---|---|---|---|---|
| Ava Martinez | E001 | $3,000.00 | $2,214.50 | $2,214.50 | 0.0% | ****4821 | matched 2026-10-08 | ||
| Ben Okafor | E002 | $2,000.00 | $1,563.20 | 80 | $25.00 | $1,563.20 | 0.0% | ****1177 | matched 2026-10-08 |
| Carla Nguyen | E003 | $1,958.00 | $1,530.11 | 86 | $22.00 | $1,480.00 | 3.4% | ****6620 | matched 2026-10-08 |
| Dev Patel | E004 | $2,800.00 | $2,105.00 | 80 | $30.00 | $2,105.00 | 0.0% | ****7345 | matched 2026-10-08 |
| Erin Walsh | E005 | $2,900.00 | $2,190.00 | $2,190.00 | 0.0% | ****9052 | matched 2026-10-08 | ||
| Frank Lee | E006 | $1,440.00 | $1,180.00 | 72 | $20.00 | $1,180.00 | 0.0% | check cleared 2026-10-13 | |
| Grace Kim | E007 | $1,920.00 | $1,540.00 | 80 | $24.00 | $1,350.00 | 14.1% | ****2208 | matched 2026-10-08 |
| Henry Brooks | E008 | $1,440.00 | $1,165.00 | 80 | $18.00 | $610.00 | 91.0% | ****5531 | matched 2026-10-08 |
| Ivy Chen | E009 | $1,170.00 | $980.00 | 60 | $19.50 | $980.00 | 0.0% | ****3012 | matched 2026-10-08 |
| Ivy Chen | E009 | $1,170.00 | $980.00 | 60 | $19.50 | $980.00 | 0.0% | ****3012 | matched 2026-10-08 |
| Jack Rivera | E010 | $1,200.00 | $1,250.00 | 40 | $30.00 | $1,150.00 | 8.7% | ****8890 | matched 2026-10-08 |
| Kim Osei | E011 | $640.00 | $542.00 | 32 | $20.00 | ****4410 | matched 2026-10-08 | ||
| Maya Singh | E013 | $1,680.00 | $1,330.00 | 80 | $21.00 | $1,330.00 | 0.0% | ****7781 | NOT FOUND in bank |
Bank match
Statement covers 2026-10-01 to 2026-10-13. We matched each direct deposit to a bank withdrawal of the exact same amount within 3 days of payday, one payment per withdrawal, and also accepted a single withdrawal equal to the total of all direct deposits (how Gusto, ADP and others often pay).
Payroll-related withdrawals around payday:
| Date | Description | Amount | Matched to |
|---|---|---|---|
| 2026-10-08 | ACH DEBIT PAYROLL DIRECT DEP | $542.00 | Kim Osei net pay |
| 2026-10-08 | ACH DEBIT PAYROLL DIRECT DEP | $980.00 | Ivy Chen net pay |
| 2026-10-08 | ACH DEBIT PAYROLL DIRECT DEP | $980.00 | Ivy Chen net pay |
| 2026-10-08 | ACH DEBIT PAYROLL DIRECT DEP | $1,165.00 | Henry Brooks net pay |
| 2026-10-08 | ACH DEBIT PAYROLL DIRECT DEP | $1,250.00 | Jack Rivera net pay |
| 2026-10-08 | ACH DEBIT PAYROLL DIRECT DEP | $1,530.11 | Carla Nguyen net pay |
| 2026-10-08 | ACH DEBIT PAYROLL DIRECT DEP | $1,540.00 | Grace Kim net pay |
| 2026-10-08 | ACH DEBIT PAYROLL DIRECT DEP | $1,563.20 | Ben Okafor net pay |
| 2026-10-08 | ACH DEBIT PAYROLL DIRECT DEP | $1,563.20 | POSSIBLE DOUBLE PAYMENT |
| 2026-10-08 | ACH DEBIT PAYROLL DIRECT DEP | $2,105.00 | Dev Patel net pay |
| 2026-10-08 | ACH DEBIT PAYROLL DIRECT DEP | $2,190.00 | Erin Walsh net pay |
| 2026-10-08 | ACH DEBIT PAYROLL DIRECT DEP | $2,214.50 | Ava Martinez net pay |
| 2026-10-08 | ACH DEBIT PAYROLL DIRECT DEP TO ACCT ****9023 | $845.00 | NOT IN REGISTER |
| 2026-10-08 | EFTPS PAYROLL TAX | $3,410.22 | payroll tax or fee (not net pay) |
What we read
| File | Rows used | Skipped or adjusted | Columns recognized |
|---|---|---|---|
| register/gusto_payroll_journal_2026-10-09.csv | 13 | 4 title or blank line(s) above the header; 1 totals row(s) | bank account, check date, employee, employee deductions, employee id, employee taxes, gross earnings, net pay, overtime hours, payment method, regular hours, regular rate, salary |
| previous/adp_payroll_register_2026-09-25.csv | 12 | none | account number, file no, gross pay, name, net pay, overtime hours, pay date, pay method, rate, regular hours |
| bank/chase_checking_oct_2026.csv | 19 | none | amount, description, posting date, type |
Limits
Overtime is assumed to be paid at 1.5 times the regular rate. Bank matching needs the exact net amount within 3 days of payday; a paper check counts as matched if it cleared within 30 days, and an uncleared check is not flagged. Account numbers are shown as the last 4 digits only. This report only reads your files; it does not change anything in your payroll or bank.