Find files, editable templates and browser test targets by what you need to make or test. The directory below is cut by format; the two collections under it cut the same library by subject and by workflow.
Lien waiver register for Pine Property Services. Two waivers, one per payment application. LW-2026-001 is unconditional for 1341.00 because that payment has been received; LW-2026-002 is conditional for 1582.20 and takes effect only on receipt of the current payment. The two amounts sum to 2923.20, the total earned less retainage, so nothing certified is unwaived and the 324.80 of retainage is covered by neither, which is exactly right.
Linked operating model for Pine Property Services. 57 records across 6 linked tables; no duplicate primary keys or missing references. Estimated work=3,858.00 USD; Recorded job costs=2,838.00 USD; Work orders=12.00 records.
Loss run report for Pine Property Services. The policy-year loss run: 3 claims with a total row. Paid 17,890.00, reserved 2,760.00, incurred 20,650.00 USD against an earned premium of 3,344.66 USD at the 2026-09-08 snapshot, a loss ratio of 617.4 percent. Earned premium is the 7,630.00 USD subtotal, excluding fees and tax, for the 160 days of the 365 day policy period that have elapsed.
Material purchase register for Pine Property Services. 12 material purchases, one per work order, alternating between two fictional merchants. The amounts are the materials column of the job cost report and sum to 498.00, which is the 02-200 actual on cost-code-summary.csv. Every purchase is dated the day its work order was raised.
Numeric expected results for Pine Property Services. Exact table counts, metric formulas, 12 chart points and three negative-test outcomes. Estimated work=3,858.00 USD; Recorded job costs=2,838.00 USD; Work orders=12.00 records.
Planned maintenance schedule for Pine Property Services. 6 planned reviews, one per property, all on the same 92-day cycle: last carried out 2026-06-15 and next due 2026-09-15, which is 7 days after the 2026-09-08 snapshot. interval_days and days_until_next are both derived from the two date columns.
Premium breakdown for Pine Property Services. The full premium chain in 11 numbered lines, each stating the basis it is computed from, so every subtotal can be recomputed from the lines above it. Line 1 is 2700000.00 of insured value at 0.85 per 1000, which is 2295.00; line 11 is 8016.08 USD.
Premium instalment schedule for Pine Property Services. 5 instalments with a running balance that starts at 8,016.08 USD and reaches exactly 0.00 on the last row. The first 4 are 1603.22 and the last is 1603.20, because 8,016.08 divided by 5 does not land on a whole cent and the remainder is taken off the final instalment.
Property reconciliation identities for Pine Property Services. 5 named identities covering the areas, the rent, the service charge apportionment, the demands and the dilapidations build-up, with the figures behind each. The deliberate defect and its measured 18.50 sq m shortfall are listed separately.
Property register with job costs for Pine Property Services. 6 properties, each with exactly 2 work orders. total_cost equals labour_cost plus materials on every row and the column sums to 2838.00, the whole job cost. Costs per property run from 328.00 to 618.00.
Quarterly 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.
Rent 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.
Rent roll JSON for Pine Property Services. The same 6 demises with the building level figures hoisted out of the rows: lettable area, common area, occupied area and occupancy by area. Occupancy is stated as a percentage of lettable area, not of lettable plus common, which is the choice that moves the number.
Rent 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.
Retainage ledger for Pine Property Services. Two payment applications. Application 001 certified 1341.00 and retained 149.00; application 002 adds 1758.00 of completed and stored value, retains a further 175.80 and certifies 1582.20. Cumulative retainage reaches 324.80, which is 10 percent of the 3248.00 completed and stored to date.
Schedule 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.
Schedule of dilapidations lines for Pine Property Services. The same 12 lines as data, with subtotal and total rows carrying an empty item_ref so they can be told apart from costed items. Only the 5 rows with a reference beginning D are remedial works; the rest are on costs, subtotals or the consequential loss.
Schedule of insured locations for Pine Property Services. The 6 scheduled properties with their insured values and each one share of the 2,700,000.00 USD total. The share column is apportioned by largest remainder at four decimal places, so the six shares sum to exactly 100.0000 rather than to 100.0002, which is what rounding each share independently produces.
Schedule of insured vehicles for Pine Property Services. The 4 scheduled vehicles with the delivery route each is assigned to and a flat 620.00 USD premium each, which is the 2,480.00 USD commercial auto line on the policy schedule. The vehicle and route identifiers are the ones the inventory-manufacturing model holds.
Schedule of unit areas for Pine Property Services. The 6 demises in PROP-1 with their floor areas and each one share of the 1200.00 sq m lettable area. Areas sum to the lettable area exactly and the shares sum to exactly 100.0000 percent because they are apportioned by largest remainder. The 185.00 sq m of common parts sits outside this table and is never apportioned, which is why no row accounts for it.
Schedule of values for Pine Property Services. 12 contract line items, one per work order, plus a total line. Each scheduled_value is the approved estimate for that item and the column sums to 3858.00, the original contract sum every payment application starts from. labour_allowance plus material_allowance equals scheduled_value on every line, and each allowance sits a fixed margin above the recorded cost: 65.00 on labour and 20.00 on materials, which is where the 85.00 per item of estimate-over-actual comes from.
Service charge budget apportionment for Pine Property Services. The 96,000.00 USD budget apportioned across all six demises by area, including the vacant one, because a vacant unit share falls on the landlord and not on the other tenants. The six annual amounts sum to the budget exactly and the percentages sum to exactly 100.0000.
Service charge expenditure against budget for Pine Property Services. 6 heads of charge plus a management fee and a total. Actual expenditure is 102,476.00 USD against a budget of 96,000.00, and the management fee on both sides is 10 percent of the heads above it rather than a fixed amount, so it moves with the expenditure it is charged on.
