Parser Simulation Lab

A single CSV where the date column uses 5 different formats — exactly what happens when a bank exports records that span a system migration …

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.

Exported data with NO header row — just raw data lines. This is common with older banking systems, mainframe exports, and some ERP batch reports.

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.

Bank descriptions that wrap to multiple lines (common in PDF-to-CSV conversions), descriptions truncated at 30 or 40 characters, and memo lines mixed in as separate …

Mimics actual Chase Business checking CSV export format. Uses their exact column names and formatting conventions.

Mimics actual Bank of America CSV download. BofA has its own column naming and includes summary rows at top.

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 …

Daily settlement report from 12 POS terminals across 4 locations. Machine IDs, cashier codes, and batch numbers embedded in descriptions. This is the GL side …

International transactions with special characters, BOM markers, and mixed encodings. Common when dealing with foreign vendors or multinational bank accounts.

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

GL entries from an AP batch run — 10 vendors paid in one ACH batch. Individual GL lines must match to a single bank withdrawal. …