A PRPTY Network resource

Closing adjustment worksheet

Adjustments settle who owes what for costs that straddle the closing date. This worksheet takes only figures you supply from the tax bill, the condo status certificate, the fuel invoice and your lawyer's statement, and shows the arithmetic for each one. Nothing is prefilled, nothing is typical, and nothing is stored.

Your lawyer or notary prepares the binding statement of adjustments. Use this to understand and sanity-check that statement — not to replace it.

A closing-day desk: a tabbed document folder with a survey sketch, a blank lined pad and pen, printed photographs of a house and of utility meters, a filing envelope and a set of keys.
Editorial illustration commissioned for HomeCosts.ca showing the documents an adjustment is built from — the tax bill, meter readings and the lawyer's file. It is an illustration, not a source.

The completion date on your agreement. Adjustments are usually calculated to this date; confirm with your lawyer whether the buyer is charged for the closing day itself.

1. Property tax adjustment

Take the annual levy from the current municipal tax bill for this property — not an estimate, not last year's figure unless that is what the bill shows.

Enter the closing date and the annual tax to see the calculation.

Instalment billing, arrears, supplementary assessments and lender tax accounts all change this. Confirm the exact treatment with your municipal tax office and your lawyer.

2. Condo / common expense adjustment

Use the monthly contribution shown on the status certificate or estoppel certificate, including any special assessment instalment described there.

Enter the closing date and the monthly common expense to see the calculation.

Reserve fund contributions, special assessments and any arrears are handled separately — read the status certificate with your lawyer. See condo ownership costs.

3. Prepaid fuel and utilities

Oil or propane left in a tank is normally measured at closing and bought from the seller at the supplier's invoiced price. Metered utilities are usually not adjusted at all: the accounts are read and closed on the closing date and each party pays its own final bill. Enter units and unit price only if a fuel adjustment applies.

Enter measured units and the invoiced unit price to see the calculation.

Book the meter readings and account transfers before possession day — see the utilities setup guide.

4. Lawyer-provided and other adjustments

Add each remaining line exactly as your lawyer or notary states it — rent and deposit transfers on a tenanted property, water or sewer accounts billed to the property, local improvement charges, deposit credits, or a per diem interest item. Type the figure from the statement; nothing here is generated.

Worksheet total

Buyer credits seller
$0.00
Seller credits buyer
$0.00
Net added to buyer's funds due
$0.00

This total covers only the lines you entered above. It is not a statement of adjustments, does not include land transfer tax, legal fees, title insurance or your mortgage advance, and has no legal effect. Confirm the binding figures with your lawyer or notary before wiring funds. Verify land transfer tax with your provincial tax authority.