Pine Property Services: Service charge reconciliation workbook
Service charge reconciliation workbook for Pine Property Services. A three-sheet workbook: the reconciliation, the expenditure against budget by head of charge, and the budget apportionment. The three sheets close on each other, so the 102,476.00 USD total can be reached down two independent routes, by head of charge and by demise.
Rendered preview of the xlsx file (7.4 KB). Download above for the original.
Specifications
- Document Set
- property
- Industry
- trades-property
- Source Kit
- trades-property
- Entity
- Pine Property Services
- Synthetic
- true
- As Of
- 2026-09-08
- Sheets
- 3
- Actual
- 102476.00
- Routes To The Same Total
- 2
Testing contract
Expected to pass- Scenario
- Total the actual column on the Expenditure sheet and the share of actual column on the Reconciliation sheet.
- Expected result
- Both give 102476.00. By head of charge it is 93160.00 of direct costs plus a 9316.00 management fee; by demise it is six area-apportioned shares.
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
“Pine Property Services: Service charge reconciliation 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: 3 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("service-charge-reconciliation.xlsx")
ws = wb.active
print(ws.title, ws.max_row, ws.max_column)Related files
- docxPine Property Services: Commercial lease (DOCX)Commercial lease (DOCX) for Pine Property Services. A ten year lease of U-02 from 1 April 2024 to 31 March 2034, with a tenant break at 31 March 2029 and a rent review the day after. Clause 3.1 states the rent as 195.00 sq m at 225.00 USD, which is 43,875.00 a year and 10,968.75 a quarter, and clause 4.1 fixes the service charge proportion at 16.2500 percent, the area of the demise over the lettable area. Clause 4.3 says in words that the common parts are excluded from the denominator, which is why the six proportions add to one hundred percent. The PDF twin in the same directory carries the identical text.
- pdfPine Property Services: Commercial lease (PDF)Commercial lease (PDF) for Pine Property Services. A ten year lease of U-02 from 1 April 2024 to 31 March 2034, with a tenant break at 31 March 2029 and a rent review the day after. Clause 3.1 states the rent as 195.00 sq m at 225.00 USD, which is 43,875.00 a year and 10,968.75 a quarter, and clause 4.1 fixes the service charge proportion at 16.2500 percent, the area of the demise over the lettable area. Clause 4.3 says in words that the common parts are excluded from the denominator, which is why the six proportions add to one hundred percent. The DOCX twin in the same directory carries the identical text.
- mdPine Property Services: property document set READMEDocument set README for Pine Property Services. 26 files, 1 of them intentionally invalid, with the reconciliation identities, the declared parameters and the measured size of each deliberate defect named in full.
- pdfPine Property Services: Quarterly rent and service charge demandQuarterly rent and service charge demand for Pine Property Services. The 2026-Q4 demand across the 5 let demises: 61,368.75 USD of rent and 21,400.00 of service charge on account, 82,768.75 in total. It states in words that the vacant demise is not demanded and that the 6,476.00 USD balancing charge is dealt with separately, which are the two amounts most easily double counted.
- xlsxPine Property Services: Rent roll workbookRent roll workbook for Pine Property Services. A two-sheet workbook holding the rent roll and the area schedule. The two sheets carry the same six areas, so the building area check can be run within the workbook: both sum to 1200.00 sq m.
- pdfPine Property Services: Schedule of dilapidationsSchedule of dilapidations for Pine Property Services. A served dilapidations schedule against U-04: 5 remedial items totalling 22,430.00 USD, preliminaries at 8 percent of that, contract administration at 5 percent of the running total, and 5,653.85 USD of lost rent for a 8 week programme, giving a 31,089.47 USD claim. Each on cost states the base it is charged on, so the compounding order is visible rather than assumed.
Generated by generation/industry_documents_two.py. Free for any use, no attribution required, license.