Back to Simulations

Duplicates, Reversals & Corrections

An Excel file with duplicate entries (same txn posted twice), reversal pairs, and corrected entries. This happens constantly with ACH/wire processing errors and batch resubmissions.

Hard BANK
20
Total Rows
20
Valid (date+amount)
0
Invalid/Skipped
0
Warnings
A
Grade (100%)

Known Problems in This Document

  • 3 truly duplicate transactions (exact same date/amount/ref)
  • 2 reversal pairs (charge + credit that cancel out)
  • 1 corrected entry (original + void + corrected amount)
  • Duplicate detection must not false-positive on legitimate same-amount txns

Actual Parser Errors & Warnings

No errors or warnings

Side-by-Side: Original Document vs Parser Extraction

Original Document Content (duplicate_mess_bank.xlsx)
Parser Extraction Result
1 Date | Amount | Description | Reference | Check # | Balance
Skipped (header row)
2 2026-03-01 00:00:00 | -1799 | Normal payment #1 | NRM-1 | | 28201
2026-03-01 -1799.00 Normal payment #1 NRM-1
3 2026-03-03 00:00:00 | -1361 | Normal payment #2 | NRM-2 | | 26840
2026-03-03 -1361.00 Normal payment #2 NRM-2
4 2026-03-05 00:00:00 | -1554 | Normal payment #3 | NRM-3 | | 25286
2026-03-05 -1554.00 Normal payment #3 NRM-3
5 2026-03-06 00:00:00 | -1575 | ACH BATCH PYMT ACME CORP | ACH-7821 | | 23711
2026-03-06 -1575.00 ACH BATCH PYMT ACME CORP ACH-7821
6 2026-03-06 00:00:00 | -1575 | ACH BATCH PYMT ACME CORP | ACH-7821 | | 22136
2026-03-06 -1575.00 ACH BATCH PYMT ACME CORP ACH-7821
7 2026-03-06 00:00:00 | -1575 | ACH BATCH PYMT ACME CORP | ACH-7821 | | 20561
2026-03-06 -1575.00 ACH BATCH PYMT ACME CORP ACH-7821
8 2026-03-07 00:00:00 | -1197 | Normal payment #4 | NRM-4 | | 19364
2026-03-07 -1197.00 Normal payment #4 NRM-4
9 2026-03-08 00:00:00 | -2500 | WIRE TRF TO GLOBEX CORP | WIR-4410 | | 16864
2026-03-08 -2500.00 WIRE TRF TO GLOBEX CORP WIR-4410
10 2026-03-09 00:00:00 | -302 | Normal payment #5 | NRM-5 | | 16562
2026-03-09 -302.00 Normal payment #5 NRM-5
11 2026-03-09 00:00:00 | 2500 | REVERSAL WIRE TRF TO GLOBEX CORP | WIR-4410-REV | | 19062
2026-03-09 2500.00 REVERSAL WIRE TRF TO GLOBEX CORP WIR-4410-REV
12 2026-03-11 00:00:00 | -1359 | Normal payment #6 | NRM-6 | | 17703
2026-03-11 -1359.00 Normal payment #6 NRM-6
13 2026-03-13 00:00:00 | -1860 | Normal payment #7 | NRM-7 | | 15843
2026-03-13 -1860.00 Normal payment #7 NRM-7
14 2026-03-13 00:00:00 | -890 | CHK 5501 VENDOR PYMT | 5501 | 5501 | 14953
2026-03-13 -890.00 CHK 5501 VENDOR PYMT 5501
15 2026-03-15 00:00:00 | -1744 | Normal payment #8 | NRM-8 | | 13209
2026-03-15 -1744.00 Normal payment #8 NRM-8
16 2026-03-15 00:00:00 | 890 | RTN CHK 5501 NSF | 5501-NSF | 5501 | 14099
2026-03-15 890.00 RTN CHK 5501 NSF 5501-NSF
17 2026-03-16 00:00:00 | -3200 | PYMT TO CROWN SUPPLY INV-8812 | PAY-9001 | | 10899
2026-03-16 -3200.00 PYMT TO CROWN SUPPLY INV-8812 PAY-9001
18 2026-03-17 00:00:00 | 3200 | VOID PYMT TO CROWN SUPPLY INV-8812 | PAY-9001-VOID | | 14099
2026-03-17 3200.00 VOID PYMT TO CROWN SUPPLY INV-8812 PAY-9001-VOID
19 2026-03-17 00:00:00 | -3450 | CORRECTED PYMT CROWN SUPPLY INV-8812 | PAY-9002 | | 10649
2026-03-17 -3450.00 CORRECTED PYMT CROWN SUPPLY INV-8812 PAY-9002
20 2026-03-19 00:00:00 | -500 | MONTHLY RENT OFFICE A | RENT-A | | 10149
2026-03-19 -500.00 MONTHLY RENT OFFICE A RENT-A
21 2026-03-19 00:00:00 | -500 | MONTHLY RENT OFFICE B | RENT-B | | 9649
2026-03-19 -500.00 MONTHLY RENT OFFICE B RENT-B
Previous Next