How to Build a BC Cash-to-Close Worksheet
The cash-to-close worksheet is designed for buyers who need dated inputs rather than a single rounded closing-cost estimate.
When to use Input, timing and source instructions
Purchase equity, property transfer tax, professional fees, diligence payments and reserves are reconciled by source and due date.
Input block
Enter purchase price, fair market value, transferred interest, deposit, down-payment target and property type. Record the source and date for each input rather than pasting a number without context.
Tax block
Apply the general PTT bands, then use separate yes/no fields for further residential tax, additional tax and each exemption. Keep unconfirmed exemptions at zero in the conservative cash plan until the legal professional verifies eligibility.
Transaction-cost block
Add legal/notary quote, inspection, specialists, appraisal, insurance, strata documents or move fees, and known adjustments. Tag whether each is already paid, due before completion or included in the legal statement.
Reserve block
Add moving, immediate repairs and a liquidity reserve as buyer decisions, not as official closing charges. Show low/base/high scenarios so one quote does not create false precision.
Reconciliation block
Output total cash needed by date, cash already paid, remaining cleared funds and unconfirmed items. The final sign-off comes from lender and legal instructions.
Input, timing and source instructions
| Worksheet block | Input and source | Calculation test | Confirmation owner |
|---|---|---|---|
| Purchase inputs | Price, fair market value, interest and deposit | Contract, valuation and lender records | Equity is counted once |
| Tax calculation | General PTT bands and separate tax checks | Current statute/program sources | Unconfirmed relief stays out of conservative cash |
| Professional costs | Legal quote, disbursements and lender charges | Scope, payer and due date | Estimate is not mistaken for final instruction |
| Property diligence | Inspection, specialists, appraisal and insurance | Provider quote and decision purpose | Early payments appear on the calendar |
| Liquidity result | Cleared funds, paid amounts and separate reserve | Low/base/high assumptions | Remaining cash is reconciled by date |
Complete the cash-to-close worksheet
- Enter price, value, transferred interest, deposit and down-payment sources.
- Show general PTT arithmetic and keep each other tax or program test separate.
- Add scoped legal, inspection, appraisal and insurance figures with their evidence state.
- Place every amount in paid, pre-condition or completion timing.
- Reconcile available funds to the conservative requirement and list each unknown.
Input, timing and source instructions: a labelled hypothetical
A buyer has recorded the deposit and down payment but left property transfer tax and pre-closing services in one unlabeled estimate. Separate the statutory calculation, legal quote, inspection, appraisal and insurance timing, then show unconfirmed items at zero only in the conservative cash plan—not as assumed exemptions or waived costs.
The incomplete worksheet is fictional. It shows why an unlabeled tax or exemption assumption cannot be treated as available closing cash.
Stress-test the worksheet without inventing precision
Build low, base and high columns only for amounts that genuinely vary. A quote can occupy one column with its date and scope; an unknown repair reserve can use a range with the evidence that would narrow it. Statutory tax calculations should show their formula and assumptions rather than a cosmetic range.
The worksheet should also show what is excluded. Furniture, optional renovations and long-term ownership costs may matter to affordability but are not necessarily completion-day cash. Keeping them in a separate planning block prevents the calculator from mixing the transaction total with every future household expense.
Run the worksheet against three timing views: money already paid, money required before subjects or financing are settled, and money required for completion. An inspection payment may be non-refundable long before the legal closing statement arrives; an appraisal may be ordered through the lender; insurance may require an early deposit or only proof by a cutoff. Place each amount in its actual lane and identify whether the figure is a quote, estimate, statutory calculation or confirmed instruction. When a source changes, keep the earlier number and record the variance so the reader can see whether the cash plan changed because of new facts, wider scope or a corrected assumption.
Related decisions and next contact
- Inspection, appraisal and insurance costs
- BC property transfer tax guide
- Closing day in BC
- Contact JQ Properties
Sources and verification
- BC Laws — Property Transfer Tax Act — Current consolidation: sections 3 and 3.01 establish the general rate bands and the further residential rate.
- Province of British Columbia — Property transfer tax calculation examples — Current worked examples and rate application.
- Province of British Columbia — First time home buyers' program — Eligibility, $835,000 full-threshold context, $860,000 partial phase-out, and occupancy conditions.
- Province of British Columbia — Newly built home exemption — $1,100,000 full threshold and $1,150,000 partial phase-out; page updated January 6, 2026.
- CMHC — Homebuying Step by Step — Current federal guide covering the homebuying team, inspection, appraisal, insurance, legal/notary closing and upfront-cost planning.
Last verified: August 4, 2026. Professional boundary: transaction-specific conclusions belong with BC lawyer/notary for closing amounts; mortgage professional; tax adviser for exemptions.
Justin Qiao Personal Real Estate Corporation
Justin Qiao Group | REMAX Crest Realty
BCFSA licence 192005
