md6.2 KB

Alder Books Reconciliation: Document set README

Document set README for Alder Books Reconciliation. 33 files, 5 of them intentionally invalid, with the reconciliation identities and the exact defect in each broken file named in full.

Data import

Preview, first 50 linesmd

# Alder Books Reconciliation: ledger, trial balance, bank statement and payment-initiation documents

A complete month-end accounting pack for one small entity: the chart of accounts, the general ledger export that balances, the trial balance that ties to it, the bank statement in five different formats (CSV, camt.053, MT940, OFX and QIF), the reconciliation that matches them, the aged debtors and creditors, a payment initiation file and a legacy fixed-width feed with its column map and COBOL copybook.

All parties, amounts and identifiers are fictional. Fixed snapshot: 2026-09-08. Every record is derived from the shared operating model `accounting-reconciliation`, so identifiers join across this set and across the business-kit fixtures that use the same model.

## Reconciliation identities this set asserts

- Ledger debits equal ledger credits at 22464.00, and every document_id balances on its own.
- Trial balance debits equal credits at 13100.00.
- Trial balance account 1000 equals the bank statement closing balance, 10236.00, in all five statement formats.
- Trial balance account 1100 equals the aged debtors total, 800.00.
- All 24 statement lines match a cash ledger line with a 0.00 difference.
- The pain.001 control sum equals the sum of its instructed amounts and the aged creditors total, 2064.00.

## Files

| File | Format | Validity | What it is |
| --- | --- | --- | --- |
| `chart-of-accounts.csv` | csv | reference | Chart of accounts |
| `chart-of-accounts.json` | json | reference | Chart of accounts JSON |
| `general-ledger-export.csv` | csv | valid | General ledger export |
| `general-ledger-export.json` | json | valid | General ledger export JSON |
| `general-ledger-parentheses-negatives.csv` | csv | valid | General ledger with parenthesised credits and grouped thousands |
| `general-ledger-eu-dialect.csv` | csv | valid | General ledger in the European CSV dialect |
| `trial-balance.csv` | csv | valid | Trial balance that balances |
| `trial-balance.json` | json | valid | Trial balance JSON |
| `trial-balance-out-of-balance.csv` | csv | invalid | Trial balance out by 1250.00 |
| `journal-batch.csv` | csv | valid | Balanced manual journal batch |
| `journal-batch-unbalanced.csv` | csv | invalid | Journal batch with one entry out by 45.00 |
| `bank-statement.csv` | csv | valid | Bank statement CSV |
| `bank-statement-camt053.xml` | xml | valid | camt.053 bank statement |
| `bank-statement-camt053-entry-count-mismatch.xml` | xml | invalid | camt.053 whose entry count does not match its entries |
| `bank-statement-mt940.txt` | txt | valid | MT940 bank statement |
| `bank-statement-mt940-bad-closing-balance.txt` | txt | invalid | MT940 whose :62F: closing balance is out by 100.00 |
| `bank-statement.ofx` | ofx | valid | OFX 1.0.3 bank statement |
| `bank-statement.qif` | qif | valid | QIF bank statement |
| `bank-reconciliation.csv` | csv | valid | Bank reconciliation |
| `bank-reconciliation.json` | json | valid | Bank reconciliation JSON |
| `aged-debtors.csv` | csv | valid | Aged debtors report |
| `aged-creditors.csv` | csv | valid | Aged creditors summary |
| `budget-vs-actual.csv` | csv | valid | Budget versus actual |
| `supplier-payments-pain001.xml` | xml | valid | ISO 20022 pain.001 payment initiation |
| `saft-ledger-extract.xml` | xml | valid | SAF-T style ledger extract |
| `gl-feed-fixed-width.txt` | txt | valid | Fixed-width general ledger feed |
| `gl-feed-layout.json` | json | reference | Fixed-width GL feed column map |
| `gl-feed-fixed-width-short-record.txt` | txt | invalid | Fixed-width GL feed with one record a byte short |
| `gl-feed-copybook.txt` | txt | reference | COBOL copybook for the GL feed |
| `ledger-pack.xlsx` | xlsx | valid | Month-end ledger pack workbook |
| `month-end-close-pack.pdf` | pdf | valid | Month-end close pack PDF |

… 70 lines total: download for the full file.

Specifications

Document Set: accounting
Industry: finance
Source Kit: accounting-reconciliation
Synthetic: true
As Of: 2026-09-08
Documented Files: 33
Documented Defects: 5

Testing contract

Reference control

Scenario: Read the README before using the set, then check that every filename it lists exists in the same directory and that the defect list matches the files marked invalid.
Expected result: The file table lists 33 entries including this README, and the deliberate-defect section names 5 file(s). The reconciliation section states the arithmetic identities the valid files satisfy exactly.

What is a .md file?

Markdown (MD) is a lightweight plain-text markup language that uses simple punctuation conventions to denote headings, lists, links, emphasis, and code. It is designed to be readable as-is and to convert cleanly to HTML. It is widely used for documentation, READMEs, and content authoring.

How to use this file

Use an example Markdown file to test parsers and renderers, verify GitHub-Flavored Markdown extensions like tables and fenced code, and exercise HTML-conversion pipelines.

How to use this file for testing

“Alder Books Reconciliation: Document set README” is a deterministic Testaroo fixture for Data import. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.

Documented properties for this file: MD · 6,373 bytes. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.

Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such, expect parsers to fail loudly rather than silently accept them.

Document fixtures list their internal structure (pages, fields, tracked changes, embedded objects) in the spec table. Test extractors, converters, and OCR against that known structure, and compare searchable↔scanned or format-twin companions when present.

Code examples

import markdown  # pip install markdown

html = markdown.markdown(open("README.md").read())
print(html[:200])

Generated by generation/industry_documents.py. Free for any use, no attribution required, license.