Back to Simulations
Messy ERP GL Export
A typical GL export from an older ERP system — multi-row headers, subtotal rows mixed in, blank rows between sections, merged cells, and department totals that should NOT be treated as transactions.
Hard
GL
23
Total Rows
23
Valid (date+amount)
0
Invalid/Skipped
4
Warnings
A
Grade (100%)
Known Problems in This Document
- First 3 rows are report title/date/blank (not data)
- Headers span row 4-5 (two-line headers)
- Subtotal rows every 10-15 entries ("*** Subtotal ***")
- Grand total row at bottom
- Blank rows between department sections
- Some amounts in Debit/Credit columns instead of single Amount
Actual Parser Errors & Warnings
Warnings:
- Could not parse date: Department: AP
- Could not parse date: Department: AR
- Could not parse date: Department: PAYROLL
- Could not parse date: Department: MAINT
Side-by-Side: Original Document vs Parser Extraction
Original Document Content
(messy_gl_export.xlsx)
Parser Extraction Result
1
ACME Corporation | | | | | | | | |
Row not captured by parser
2
General Ledger Detail Report | | | | | | | | |
Row not captured by parser
3
Period: March 1-31, 2026 | | | | Printed: 2026-03-31 | | | | |
Row not captured by parser
4
| | | | | | | | |
Row not captured by parser
5
Transaction | Transaction | Journal | | Debit | Credit | Vendor | Vendor | Dept | Cashier
Row not captured by parser
6
Date | Description | Entry # | Reference | Amount | Amount | Name | Code | | Code
Row not captured by parser
7
Department: AP | | | | | | | | |
Row not captured by parser
8
| | | | | | | | |
Row not captured by parser
9
2026-03-11 00:00:00 | AP Payment - ACME Corp | JE-5000 | INV-6305 | 1495.9 | | ACME Corp | V001 | AP | JOHN
2026-03-11
1495.90
AP Payment - ACME Corp
INV-6305
10
2026-03-16 00:00:00 | AP Payment - Bolt Industries | JE-5001 | INV-3372 | 3158.58 | | Bolt Industries | V002 | AP | MI…
2026-03-16
3158.58
AP Payment - Bolt Industries
INV-3372
11
2026-03-26 00:00:00 | AP Payment - Bolt Industries | JE-5002 | INV-2989 | 2705.87 | | Bolt Industries | V002 | AP | JO…
2026-03-26
2705.87
AP Payment - Bolt Industries
INV-2989
12
2026-03-24 00:00:00 | AP Payment - Bolt Industries | JE-5003 | INV-9986 | 593.09 | | Bolt Industries | V002 | AP | SAR…
2026-03-24
593.09
AP Payment - Bolt Industries
INV-9986
13
2026-03-08 00:00:00 | AP Payment - Fox Hardware | JE-5004 | INV-5662 | 611.57 | | Fox Hardware | V006 | AP | SARAH
2026-03-08
611.57
AP Payment - Fox Hardware
INV-5662
14
2026-03-19 00:00:00 | AP Payment - Crown Supply | JE-5005 | INV-3924 | 661.17 | | Crown Supply | V003 | AP | LISA
2026-03-19
661.17
AP Payment - Crown Supply
INV-3924
15
2026-03-19 00:00:00 | AP Payment - Eagle Transport | JE-5006 | INV-4183 | 2811.02 | | Eagle Transport | V005 | AP | SA…
2026-03-19
2811.02
AP Payment - Eagle Transport
INV-4183
16
2026-03-01 00:00:00 | AP Payment - Bolt Industries | JE-5007 | INV-6636 | 2294.65 | | Bolt Industries | V002 | AP | MI…
2026-03-01
2294.65
AP Payment - Bolt Industries
INV-6636
17
| *** Subtotal for AP *** | | | | | | | |
Skipped (subtotal/total row)
18
| | | | | | | | |
Row not captured by parser
19
Department: AR | | | | | | | | |
Row not captured by parser
20
| | | | | | | | |
Row not captured by parser
21
2026-03-16 00:00:00 | AP Payment - Crown Supply | JE-5100 | INV-8136 | 1093.47 | | Crown Supply | V003 | AR | LISA
2026-03-16
1093.47
AP Payment - Crown Supply
INV-8136
22
2026-03-09 00:00:00 | AP Payment - Delta Services | JE-5101 | INV-6591 | 3090.19 | | Delta Services | V004 | AR | JOHN
2026-03-09
3090.19
AP Payment - Delta Services
INV-6591
23
2026-03-22 00:00:00 | Cash Receipt - Eagle Transport | JE-5102 | INV-8075 | | 3972.53 | Eagle Transport | V005 | AR | …
Row not captured by parser
24
2026-03-13 00:00:00 | Cash Receipt - ACME Corp | JE-5103 | INV-1040 | | 3168.56 | ACME Corp | V001 | AR | JOHN
Row not captured by parser
25
2026-03-14 00:00:00 | Cash Receipt - Bolt Industries | JE-5104 | INV-7278 | | 4432.62 | Bolt Industries | V002 | AR | …
Row not captured by parser
26
2026-03-22 00:00:00 | AP Payment - Eagle Transport | JE-5105 | INV-8972 | 2551.14 | | Eagle Transport | V005 | AR | LI…
2026-03-22
2551.14
AP Payment - Eagle Transport
INV-8972
27
2026-03-08 00:00:00 | AP Payment - Delta Services | JE-5106 | INV-6007 | 2146.54 | | Delta Services | V004 | AR | LISA
2026-03-08
2146.54
AP Payment - Delta Services
INV-6007
28
2026-03-04 00:00:00 | AP Payment - Crown Supply | JE-5107 | INV-6833 | 2609.64 | | Crown Supply | V003 | AR | MIKE
2026-03-04
2609.64
AP Payment - Crown Supply
INV-6833
29
2026-03-17 00:00:00 | AP Payment - Delta Services | JE-5108 | INV-5567 | 393.67 | | Delta Services | V004 | AR | MIKE
2026-03-17
393.67
AP Payment - Delta Services
INV-5567
30
| *** Subtotal for AR *** | | | | | | | |
Skipped (subtotal/total row)
31
| | | | | | | | |
Row not captured by parser
32
Department: PAYROLL | | | | | | | | |
Row not captured by parser
33
| | | | | | | | |
Row not captured by parser
34
2026-03-26 00:00:00 | Cash Receipt - Delta Services | JE-5200 | INV-8554 | | 2726 | Delta Services | V004 | PAYROLL | …
Row not captured by parser
35
2026-03-21 00:00:00 | AP Payment - Bolt Industries | JE-5201 | INV-6361 | 1075.63 | | Bolt Industries | V002 | PAYROLL…
2026-03-21
1075.63
AP Payment - Bolt Industries
INV-6361
36
2026-03-19 00:00:00 | AP Payment - ACME Corp | JE-5202 | INV-6921 | 3900.41 | | ACME Corp | V001 | PAYROLL | SARAH
2026-03-19
3900.41
AP Payment - ACME Corp
INV-6921
37
2026-03-24 00:00:00 | Cash Receipt - Fox Hardware | JE-5203 | INV-8282 | | 2676.5 | Fox Hardware | V006 | PAYROLL | SA…
Row not captured by parser
38
2026-03-16 00:00:00 | AP Payment - Eagle Transport | JE-5204 | INV-6900 | 3157.04 | | Eagle Transport | V005 | PAYROLL…
2026-03-16
3157.04
AP Payment - Eagle Transport
INV-6900
39
2026-03-05 00:00:00 | Cash Receipt - Bolt Industries | JE-5205 | INV-4499 | | 2239.18 | Bolt Industries | V002 | PAYRO…
Row not captured by parser
40
2026-03-23 00:00:00 | Cash Receipt - Bolt Industries | JE-5206 | INV-3194 | | 1623.72 | Bolt Industries | V002 | PAYRO…
Row not captured by parser
41
2026-03-03 00:00:00 | AP Payment - Bolt Industries | JE-5207 | INV-9410 | 781.04 | | Bolt Industries | V002 | PAYROLL …
2026-03-03
781.04
AP Payment - Bolt Industries
INV-9410
42
2026-03-26 00:00:00 | AP Payment - Crown Supply | JE-5208 | INV-7261 | 2313.99 | | Crown Supply | V003 | PAYROLL | SAR…
2026-03-26
2313.99
AP Payment - Crown Supply
INV-7261
43
2026-03-04 00:00:00 | Cash Receipt - Delta Services | JE-5209 | INV-5751 | | 405.99 | Delta Services | V004 | PAYROLL …
Row not captured by parser
44
| *** Subtotal for PAYROLL *** | | | | | | | |
Skipped (subtotal/total row)
45
| | | | | | | | |
Row not captured by parser
46
Department: MAINT | | | | | | | | |
Row not captured by parser
47
| | | | | | | | |
Row not captured by parser
48
2026-03-24 00:00:00 | Cash Receipt - Fox Hardware | JE-5300 | INV-4382 | | 962.18 | Fox Hardware | V006 | MAINT | SARAH
Row not captured by parser
49
2026-03-11 00:00:00 | Cash Receipt - Bolt Industries | JE-5301 | INV-8079 | | 4918.73 | Bolt Industries | V002 | MAINT…
Row not captured by parser
50
2026-03-10 00:00:00 | AP Payment - Crown Supply | JE-5302 | INV-9495 | 523.24 | | Crown Supply | V003 | MAINT | LISA
2026-03-10
523.24
AP Payment - Crown Supply
INV-9495
51
2026-03-19 00:00:00 | Cash Receipt - ACME Corp | JE-5303 | INV-3130 | | 1862.15 | ACME Corp | V001 | MAINT | SARAH
Row not captured by parser
52
2026-03-19 00:00:00 | AP Payment - Bolt Industries | JE-5304 | INV-2853 | 2391.45 | | Bolt Industries | V002 | MAINT |…
2026-03-19
2391.45
AP Payment - Bolt Industries
INV-2853
53
2026-03-28 00:00:00 | Cash Receipt - Eagle Transport | JE-5305 | INV-7904 | | 4298.23 | Eagle Transport | V005 | MAINT…
Row not captured by parser
54
2026-03-18 00:00:00 | AP Payment - Crown Supply | JE-5306 | INV-3355 | 3263.04 | | Crown Supply | V003 | MAINT | LISA
2026-03-18
3263.04
AP Payment - Crown Supply
INV-3355
55
2026-03-11 00:00:00 | Cash Receipt - Eagle Transport | JE-5307 | INV-1659 | | 955.92 | Eagle Transport | V005 | MAINT …
Row not captured by parser
56
2026-03-14 00:00:00 | AP Payment - Bolt Industries | JE-5308 | INV-5141 | 2651.49 | | Bolt Industries | V002 | MAINT |…
2026-03-14
2651.49
AP Payment - Bolt Industries
INV-5141
57
| *** Subtotal for MAINT *** | | | | | | | |
Skipped (subtotal/total row)
58
| | | | | | | | |
Row not captured by parser
59
| *** GRAND TOTAL *** | | | | | | | |
Skipped (subtotal/total row)
60
| Report generated by ERP System v4.2.1 | | | | | | | |
Row not captured by parser