Programmatic Generation of Synthetic Tabular Datasets for Automated Testing of Financial Transaction Reconciliation Utilities

Validating financial transaction matching and reconciliation software requires structured tabular test datasets containing diverse edge cases, varying data types, and deliberate discrepancies. Utilizing operational or corporate spreadsheets for this purpose presents severe confidentiality and data privacy risks. This paper presents a lightweight, script-based tool for generating synthetic Excel data developed in Python. By programmatically constructing multi-column tabular records and injecting controlled discrepancies, the utility provides an isolated, reproducible dataset for rigorous validation of automated transaction reconciliation systems.

Authors

Publication Details

Journal
Zenodo (CERN European Organization for Nuclear Research)
Published
2026-11-12
DOI
https://doi.org/10.5281/zenodo.24148552
Primary Topic
Software Testing and Debugging Techniques
Type
preprint
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
preprint

Programmatic Generation of Synthetic Tabular Datasets for Automated Testing of Financial Transaction Reconciliation Utilities

Fathir Afatar
Zenodo (CERN European Organization for Nuclear Research)
Software Testing and Debugging Techniques
preprint

Programmatic Generation of Synthetic Tabular Datasets for Automated Testing of Financial Transaction Reconciliation Utilities

Fathir Afatar
preprint en

Abstract

Validating financial transaction matching and reconciliation software requires structured tabular test datasets containing diverse edge cases, varying data types, and deliberate discrepancies. Utilizing operational or corporate spreadsheets for this purpose presents severe confidentiality and data privacy risks. This paper presents a lightweight, script-based tool for generating synthetic Excel data developed in Python. By programmatically constructing multi-column tabular records and injecting controlled discrepancies, the utility provides an isolated, reproducible dataset for rigorous validation of automated transaction reconciliation systems.

Zenodo (CERN European Organization for Nuclear Research)
Software Testing and Debugging Techniques
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Laika access coming soon