Back to Simulations

Vendor Batch Payments (GL Side)

GL entries from an AP batch run — 10 vendors paid in one ACH batch. Individual GL lines must match to a single bank withdrawal. This is the classic many-to-one matching challenge.

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

Known Problems in This Document

  • Batch reference format varies: "BATCH-001", "B001", "AP-BATCH-001"
  • 10 vendor payments of different amounts → 1 bank debit
  • Some vendor names differ between GL and bank (abbreviations)
  • Journal entry numbers are internal — bank has no knowledge of them
  • One vendor appears twice in same batch (2 invoices)

Actual Parser Errors & Warnings

No errors or warnings

Side-by-Side: Original Document vs Parser Extraction

Original Document Content (vendor_batch_gl.csv)
Parser Extraction Result
1 Transaction Date,Amount,Description,Reference,Cashier Code,Vendor Name,Vendor Code,Journal Entry,GL Account,Department,…
Skipped (header row)
2 03/15/2026,-1597.18,AP Payment to ACME Corp INV-9804,BATCH-001,JOHN,ACME Corp,V001,JE-7000,2100,AP,BATCH-001
2026-03-15 -1597.18 AP Payment to ACME Corp INV-9804 BATCH-001
3 03/15/2026,-2863.59,AP Payment to Bolt Industries INV-8470,AP-BATCH-001,SARAH,Bolt Industries,V002,JE-7001,2100,AP,AP-B…
2026-03-15 -2863.59 AP Payment to Bolt Industries INV-8470 AP-BATCH-001
4 03/15/2026,-1781.75,AP Payment to Crown Supply INV-7410,B001,JOHN,Crown Supply,V003,JE-7002,2100,AP,B001
2026-03-15 -1781.75 AP Payment to Crown Supply INV-7410 B001
5 03/15/2026,-2836.83,AP Payment to Delta Services INV-4516,BATCH-001,SARAH,Delta Services,V004,JE-7003,2100,AP,BATCH-001
2026-03-15 -2836.83 AP Payment to Delta Services INV-4516 BATCH-001
6 03/15/2026,-897.96,AP Payment to Eagle Transport INV-5061,BATCH-001,JOHN,Eagle Transport,V005,JE-7004,2100,AP,BATCH-001
2026-03-15 -897.96 AP Payment to Eagle Transport INV-5061 BATCH-001
7 03/15/2026,-2886.7,AP Payment to Fox Hardware INV-7522,batch-001,JOHN,Fox Hardware,V006,JE-7005,2100,AP,batch-001
2026-03-15 -2886.70 AP Payment to Fox Hardware INV-7522 batch-001
8 03/15/2026,-1960.85,AP Payment to Globe Telecom INV-5149,BATCH-001,SARAH,Globe Telecom,V007,JE-7006,2100,AP,BATCH-001
2026-03-15 -1960.85 AP Payment to Globe Telecom INV-5149 BATCH-001
9 03/15/2026,-442.65,AP Payment to Harbor Shipping INV-1747,AP/BATCH/001,SARAH,Harbor Shipping,V008,JE-7007,2100,AP,AP/BA…
2026-03-15 -442.65 AP Payment to Harbor Shipping INV-1747 AP/BATCH/001
10 03/15/2026,-391.18,AP Payment to Iris Medical INV-8497,BATCH-001,SARAH,Iris Medical,V009,JE-7008,2100,AP,BATCH-001
2026-03-15 -391.18 AP Payment to Iris Medical INV-8497 BATCH-001
11 03/15/2026,-1551.05,AP Payment to ACME Corp INV-5303,BATCH-001,JOHN,ACME Corp,V001,JE-7009,2100,AP,BATCH-001
2026-03-15 -1551.05 AP Payment to ACME Corp INV-5303 BATCH-001
12 03/18/2026,-1184.41,AP Payment to QuickShip Co,BATCH-002,MIKE,QuickShip Co,V010,JE-7100,2100,AP,BATCH-002
2026-03-18 -1184.41 AP Payment to QuickShip Co BATCH-002
13 03/18/2026,-1549.55,AP Payment to SafeGuard LLC,BATCH-002,MIKE,SafeGuard LLC,V011,JE-7101,2100,AP,BATCH-002
2026-03-18 -1549.55 AP Payment to SafeGuard LLC BATCH-002
14 03/18/2026,-1193.46,AP Payment to TechWorld Inc,BATCH-002,MIKE,TechWorld Inc,V012,JE-7102,2100,AP,BATCH-002
2026-03-18 -1193.46 AP Payment to TechWorld Inc BATCH-002
15 03/18/2026,-723.53,AP Payment to PrintPro,BATCH-002,MIKE,PrintPro,V013,JE-7103,2100,AP,BATCH-002
2026-03-18 -723.53 AP Payment to PrintPro BATCH-002
16 03/18/2026,-1741.28,AP Payment to CleanStar,BATCH-002,MIKE,CleanStar,V014,JE-7104,2100,AP,BATCH-002
2026-03-18 -1741.28 AP Payment to CleanStar BATCH-002
Previous