Willow Community Fund: Pledge and receipt workbook
Pledge and receipt workbook for Willow Community Fund. Two worksheets: Instalments (18 rows) and Receipts (9 rows). Every paid instalment on the first sheet has a receipt on the second for the same amount, and the unpaid instalments have none, which is why the sheets total 2850.00 and 1800.00.
Rendered preview of the xlsx file (7.4 KB). Download above for the original.
Specifications
- Document Set
- nonprofit
- Industry
- nonprofit
- Source Kit
- nonprofit-fundraising
- Synthetic
- true
- As Of
- 2026-09-08
- Sheets
- 2
- Instalments
- 18
- Receipts
- 9
Testing contract
Expected to pass- Scenario
- Open the workbook and join the two sheets on pledge_id.
- Expected result
- The 9 receipts match the 9 paid instalments one for one on pledge_id and amount. The 9 unpaid instalments have no receipt, and 2850.00 less 1800.00 is 1050.00, the outstanding pledge value.
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
“Willow Community Fund: Pledge and receipt 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: 2 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("pledge-schedule.xlsx")
ws = wb.active
print(ws.title, ws.max_row, ws.max_column)Related files
- pdfWillow Community Fund: Annual donor acknowledgement letter PDFAnnual donor acknowledgement letter PDF for Willow Community Fund. A one-page acknowledgement for DON-01. The gift table lists 2 receipts and closes on 400.00 gross, 25.50 of benefits and 374.50 deductible, and the closing paragraph quotes the whole-organisation figures.
- mdWillow Community Fund: Document set READMEDocument set README for Willow Community Fund. 24 files, 1 of them intentionally invalid, with the reconciliation identities and the exact defect in each broken file named in full.
- pdfWillow Community Fund: Donation receipt PDF, pure giftDonation receipt PDF, pure gift for Willow Community Fund. A one-page receipt for RCPT-2026-0001. The deductible table starts at 100.00 gross, deducts nothing and ends at 100.00 deductible. The statement of goods and services says in words what the table says in figures.
- pdfWillow Community Fund: Donation receipt PDF, quid pro quo giftDonation receipt PDF, quid pro quo gift for Willow Community Fund. A one-page receipt for RCPT-2026-0009. The deductible table starts at 300.00 gross, deducts 25.50 of benefits and ends at 274.50 deductible. The statement of goods and services says in words what the table says in figures.
- xlsxWillow Community Fund: Grant reporting workbookGrant reporting workbook for Willow Community Fund. Two worksheets: Grant register (3 rows) and Budget vs actual (10 rows). The budget column of the second sheet rolls up to the awarded column of the first, 4500.00, and the pending grant appears on the register with no budget sheet rows at all.
- 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.
Generated by generation/industry_documents.py. Free for any use, no attribution required, license.