Pine Property Services: Deposit register
Deposit register for Pine Property Services. The 5 deposits, each two quarterly instalments of the rent on its own lease, holding 122,737.50 USD in total. Every deposit is released on expiry subject to a dilapidations claim, which is what connects this register to the dilapidations schedule in the same directory.
csv
text/csv
- Document Set
- property
- Industry
- trades-property
- Source Kit
- trades-property
- Entity
- Pine Property Services
- Synthetic
- true
- As Of
- 2026-09-08
Binary csv: no in-browser preview. Download it above to open in a compatible application.
Specifications
- Document Set
- property
- Industry
- trades-property
- Source Kit
- trades-property
- Entity
- Pine Property Services
- Synthetic
- true
- As Of
- 2026-09-08
- Rows
- 5
- Total
- 122737.50
- Interest Bearing
- false
Testing contract
Expected to pass- Scenario
- Recompute each deposit as twice the quarterly rent in lease-abstract.csv.
- Expected result
- All 5 deposits equal twice their own quarterly rent. The deposit on U-04 is 18375.00 USD and the dilapidations claim against the same unit is larger, so the deposit does not cover it.
What is a .csv file?
CSV (Comma-Separated Values) is a plain-text tabular format where rows are lines and fields are separated by commas, with quoting rules for values that contain delimiters, quotes, or newlines. It has no formal type system and depends on encoding and dialect conventions. It is the most portable format for tabular data exchange.
How to use this file
Use an example CSV to test parsers against quoting and embedded-delimiter edge cases, header handling, encoding detection, and import pipelines into databases or spreadsheets.
How to use this file for testing
“Pine Property Services: Deposit register” is a deterministic Novus Examples fixture for Data import, CSV parsing. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 5 rows. 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.
Data fixtures document their exact quirks (delimiters, encodings, null handling, schema, and row counts) in the spec table. Point your parser or importer at the file and assert it handles the documented edge cases; clean and deliberately-messy siblings make before/after diffs straightforward.
Code examples
import pandas as pd
df = pd.read_csv("deposit-register.csv")
print(df.head())
print(df.dtypes)Related files
- csvPine Property Services: Arrears reportArrears report for Pine Property Services. The one genuine arrear: U-05 owes 16012.50 USD for 2026-Q3, due 2026-07-01 and 69 days overdue at the 2026-09-08 snapshot, which puts it in the 61 to 90 day bucket. The 5 fourth-quarter demands are deliberately absent because a demand for a quarter that has not started is not an arrear.
- csvPine Property Services: Building works recharged to the service chargeBuilding works recharged to the service charge for Pine Property Services. The 2 work orders the trades-property model records against PROP-1, with their labour and material costs, totalling 328.00 USD. All of them are recharged to the repairs and maintenance head, which is budgeted at 32,192.36 USD and spent at 31,240.00, so these rows are a subset of that head rather than the whole of it.
- csvPine Property Services: Quarterly rent and service charge demandsQuarterly rent and service charge demands for Pine Property Services. 20 demands across four quarters for the five let demises. Each total is rent plus service charge and each outstanding is total less paid. Demanded rent and service charge across the year come to 331,075.00 USD, and 98,781.25 is outstanding: one genuine arrear and 5 demands for a quarter that has not started at the 2026-09-08 snapshot.
- csvPine Property Services: Rent rollRent roll for Pine Property Services. The 6 demises with area, rent, passing rent and estimated rental value. Unit areas sum to 1200.00 sq m, which is the building_area_sq_m value every row carries. Passing rent is 245,475.00 USD and estimated rental value 271,475.00, the difference being the 26000.00 USD that U-06 would produce if it were let. Annual rent is area times rate on every row and quarterly rent is a quarter of passing rent.
- csvPine Property Services: Rent roll whose unit areas do not sum to the building areaRent roll whose unit areas do not sum to the building area for Pine Property Services. The same 6 demises with one number changed: U-03 reads 211.50 sq m instead of 230.00. Unit areas now sum to 1181.50 against the 1200.00 that every row still declares as building_area_sq_m, a shortfall of 18.50 sq m. The rent columns are untouched, so U-03 annual rent no longer equals its area times its rate either, and the two failures are the same mutation seen twice.
- csvPine Property Services: Schedule of conditionSchedule of condition for Pine Property Services. The 6 elements recorded at lease start and again at the exit inspection, with the dilapidations item each defect leads to. Five of the six lead to a costed item and the sixth records no defect and no action, so the schedule proves the claim is complete rather than only that it is arithmetically right.
Generated by generation/industry_documents_two.py. Free for any use, no attribution required, license.