Back to Simulations

Separate Debit/Credit Columns

Instead of one Amount column, this statement has separate Debit and Credit columns — exactly how many bank PDFs and older systems present data. Some rows have both columns filled.

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

Known Problems in This Document

  • Two amount columns: "Withdrawals" (debits) and "Deposits" (credits)
  • Some rows have amount in BOTH columns (adjustments)
  • Empty cells may be blank string, "0", "0.00", or "-"
  • Column widths suggest data was copy-pasted from PDF

Actual Parser Errors & Warnings

No errors or warnings

Side-by-Side: Original Document vs Parser Extraction

Original Document Content (debit_credit_split_bank.csv)
Parser Extraction Result
1 Date,Description,Withdrawals,Deposits,Balance
Skipped (header row)
2 03/01/2026,Payment to ACME Corp,1500.00,0.00,18500.00
2026-03-01 -1500.00 Payment to ACME Corp
3 03/03/2026,Customer deposit,,3500.00,22000.00
2026-03-03 3500.00 Customer deposit
4 03/05/2026,Wire transfer out,2200.00,-,19800.00
2026-03-05 -2200.00 Wire transfer out
5 03/07/2026,Adjustment entry,50.00,50.00,19800.00
2026-03-07 0.00 Adjustment entry
6 03/09/2026,Check #1055,890.00,0,18910.00
2026-03-09 -890.00 Check #1055
7 03/11/2026,Direct deposit,-,4200.00,23110.00
2026-03-11 4200.00 Direct deposit
8 03/13/2026,Service charge,25.00,0,23085.00
2026-03-13 -25.00 Service charge
9 03/15/2026,Interest earned,,12.50,23097.50
2026-03-15 12.50 Interest earned
10 03/17/2026,ATM withdrawal,200.00,-,22897.50
2026-03-17 -200.00 ATM withdrawal
11 03/19/2026,Refund from vendor,-,350.00,23247.50
2026-03-19 350.00 Refund from vendor
12 03/21/2026,Void check (blank amount),0.00,-,23247.50
Row not captured by parser
13 03/23/2026,NSF check,1500.00,0.00,21747.50
2026-03-23 -1500.00 NSF check
14 03/25/2026,NSF check re-deposit,,1500.00,23247.50
2026-03-25 1500.00 NSF check re-deposit
15 03/27/2026,Multiple adjustments,100.00,75.00,23222.50
2026-03-27 -25.00 Multiple adjustments
Previous Next