Alder Books Reconciliation: Month-end ledger pack workbook
Month-end ledger pack workbook for Alder Books Reconciliation. Five worksheets: Chart of accounts (9 rows), General ledger (66), Trial balance (10), Bank statement (24) and Aged debtors (9). The trial balance sheet totals 13100.00 on each side and the bank statement sheet closes on the same cash figure.
Rendered preview of the xlsx file (13 KB). Download above for the original.
Specifications
- Document Set
- accounting
- Industry
- finance
- Source Kit
- accounting-reconciliation
- Synthetic
- true
- As Of
- 2026-09-08
- Sheets
- 5
- Rows
- 118
Testing contract
Expected to pass- Scenario
- Open the workbook and reconcile the trial balance sheet against the general ledger sheet without leaving the file.
- Expected result
- Summing the debit and credit columns of the General ledger sheet gives 22464.00 each; netting them per account reproduces the Trial balance sheet, whose TOTAL row reads 13100.00 on both sides; and the cash account 10236.00 equals the last balance on the Bank statement sheet.
What is a .xlsx file?
XLSX is the default Microsoft Excel format, an Office Open XML spreadsheet stored as a ZIP archive containing worksheet XML, shared strings, styles, and formulas. It supports multiple sheets, cell formatting, charts, and calculated values. It is the standard for editable tabular workbooks.
How to use this file
Use an example XLSX to test spreadsheet parsing, formula and multi-sheet handling, shared-string extraction, and pipelines that read or generate Excel workbooks.
How to use this file for testing
“Alder Books Reconciliation: Month-end ledger pack workbook” is a deterministic Novus Examples fixture for Data import. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 118 rows · 5 sheets. 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
from openpyxl import load_workbook
wb = load_workbook("ledger-pack.xlsx")
ws = wb.active
print(ws.title, ws.max_row, ws.max_column)Related files
- mdAlder Books Reconciliation: Document set READMEDocument 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.
- pdfAlder Books Reconciliation: Month-end close pack PDFMonth-end close pack PDF for Alder Books Reconciliation. A two-page close pack: page one carries the 10-row trial balance totalling 13,100.00 on each side and the receivables ageing summing to 800.00; page two states the bank reconciliation and the budget variance of 2,136.00.
- mdAlder Books Reconciliation: banking document set READMEDocument set README for Alder Books Reconciliation. 25 files, 1 of them intentionally invalid, with the reconciliation identities, the declared parameters and the measured size of each deliberate defect named in full.
- docxAlder Books Reconciliation: Credit application (DOCX)Credit application (DOCX) for Alder Books Reconciliation. An unsecured working capital application for 15,000.00 USD. Every figure in the financial summary names the wave-one accounting file and column it comes from, so the whole table is checkable: closing cash 10,236.00, invoiced 8,100.00, received 7,300.00, outstanding 800.00 and expenditure 2,064.00 USD. The PDF twin in the same directory carries the identical text.
- pdfAlder Books Reconciliation: Credit application (PDF)Credit application (PDF) for Alder Books Reconciliation. An unsecured working capital application for 15,000.00 USD. Every figure in the financial summary names the wave-one accounting file and column it comes from, so the whole table is checkable: closing cash 10,236.00, invoiced 8,100.00, received 7,300.00, outstanding 800.00 and expenditure 2,064.00 USD. The DOCX twin in the same directory carries the identical text.
- pdfAlder Books Reconciliation: Operating report PDFOperating report PDF for Alder Books Reconciliation. Three readable pages summarize the same model, chart, source tables and usage instructions. Net cash change=5,236.00 USD; Journal debits=9,364.00 USD; Journal credits=9,364.00 USD.
Generated by generation/industry_documents.py. Free for any use, no attribution required, license.