Back to Simulations

Non-Standard Amount Formats

Amounts expressed in every way banks and accounting systems do it: parentheses for negatives, DR/CR suffixes, currency symbols, spaces in numbers, and European comma decimals.

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

Known Problems in This Document

  • Negatives as (1,234.56) — parentheses notation
  • DR/CR suffix: "1234.56 DR" means debit (negative)
  • Currency mixed in: "$1,234.56" and "USD 1,234.56"
  • European format: "1.234,56" (dots as thousands, comma as decimal)
  • Spaces in numbers: "1 234.56"
  • Trailing minus: "1234.56-"
  • One amount is just a dash "—" meaning zero

Actual Parser Errors & Warnings

No errors or warnings

Side-by-Side: Original Document vs Parser Extraction

Original Document Content (weird_amounts_bank.csv)
Parser Extraction Result
1 Date,Amount,Description,Reference
Skipped (header row)
2 03/01/2026,-4162.18,Normal negative — test amount format,AMT-001
2026-03-01 -4162.18 Normal negative — test amount format AMT-001
3 03/02/2026,"(3,500.00)",Parentheses negative — test amount format,AMT-002
2026-03-02 -3500.00 Parentheses negative — test amount format AMT-002
4 03/03/2026,2500.00 DR,DR suffix = debit — test amount format,AMT-003
2026-03-03 -2500.00 DR suffix = debit — test amount format AMT-003
5 03/04/2026,"1,750.50 CR",CR suffix = credit — test amount format,AMT-004
2026-03-04 1750.50 CR suffix = credit — test amount format AMT-004
6 03/05/2026,"$1,234.56",Dollar sign — test amount format,AMT-005
2026-03-05 1234.56 Dollar sign — test amount format AMT-005
7 03/06/2026,USD 999.99,Currency code prefix — test amount format,AMT-006
2026-03-06 999.99 Currency code prefix — test amount format AMT-006
8 03/07/2026,"1.234,56","European format (dot thousands, comma decimal) — test amount format",AMT-007
2026-03-07 1234.56 European format (dot thousands, comma decimal) — … AMT-007
9 03/08/2026,1 500.00,Space as thousands separator — test amount format,AMT-008
2026-03-08 1500.00 Space as thousands separator — test amount format AMT-008
10 03/09/2026,750.00-,Trailing minus — test amount format,AMT-009
2026-03-09 -750.00 Trailing minus — test amount format AMT-009
11 03/10/2026,—,Em-dash meaning zero — test amount format,AMT-010
Row not captured by parser
12 03/11/2026,"(USD 2,345.67)",Parentheses + currency — test amount format,AMT-011
2026-03-11 -2345.67 Parentheses + currency — test amount format AMT-011
13 03/12/2026,"-$3,210.00",Minus + dollar sign — test amount format,AMT-012
2026-03-12 -3210.00 Minus + dollar sign — test amount format AMT-012
14 03/13/2026, 450.00 ,Leading/trailing spaces — test amount format,AMT-013
2026-03-13 450.00 Leading/trailing spaces — test amount format AMT-013
15 03/14/2026,"1,000",No decimal places — test amount format,AMT-014
2026-03-14 1000.00 No decimal places — test amount format AMT-014
16 03/15/2026,0.50,Less than a dollar — test amount format,AMT-015
2026-03-15 0.50 Less than a dollar — test amount format AMT-015
17 03/16/2026,10000,"No comma, no decimal — test amount format",AMT-016
2026-03-16 10000.00 No comma, no decimal — test amount format AMT-016
18 03/17/2026,3500.,Trailing decimal point — test amount format,AMT-017
2026-03-17 3500.00 Trailing decimal point — test amount format AMT-017
19 03/18/2026,.99,No leading zero — test amount format,AMT-018
2026-03-18 0.99 No leading zero — test amount format AMT-018
20 03/19/2026,,BLANK AMOUNT — test amount format,AMT-019
Row not captured by parser
21 03/20/2026,N/A,Not applicable — test amount format,AMT-020
Row not captured by parser
Previous Next