Islamic Home Finance Quote Reconciliation Worksheet
Home-finance quotations are difficult to compare when one shows rent, another shows profit, fees are separated differently and variable-rate assumptions are hidden. A reconciliation worksheet places every cash flow and ownership event on the same timeline.
This worksheet is general information, not credit, legal, tax, property or Shariah advice. Use signed offers and current professional advice.
1. Use the same property and date
Compare quotations for the same purchase price, deposit, term and expected registration date. Record the quotation expiry and valuation assumptions.
2. Identify the contract structure
State whether the proposal uses Murabaha, Ijarah, Diminishing Musharakah or another structure. Summarise legal ownership, beneficial interests and security.
3. Reconcile the deposit
Show when the deposit is paid, who holds it, whether it is refundable and how it changes the provider’s funding or ownership units.
4. List acquisition costs
Separate transfer duty or VAT where relevant, conveyancing, bond or security registration, valuation, initiation and administration costs. Mark what is paid in cash and what is added to the transaction.
5. Break down monthly payments
Identify rent, profit, unit purchases, capital, fees and cover. Show the first payment and the method used to calculate future payments.
6. Use consistent rate scenarios
Model unchanged, higher and lower benchmark scenarios where payments can vary. Apply the same assumptions to every proposal rather than comparing one provider’s optimistic case with another’s stress case.
7. Include service and maintSuggested worksheet columns
Use separate columns for property price, customer deposit, provider funding, initial fees, legal costs, first monthly payment, stressed monthly payment, total paid after five and ten years, settlement estimate, ownership percentage, sale process and default process. Add a source-document reference beside every figure. Leave uncertain values visibly unresolved rather than filling them with an assumption.Have the provider confirm the completed worksheet in writing before the offer expires, and retain the final version with the signed contract pack.enance
Record rates, levies, insurance or Takaful, ordinary maintenance and ownership-related repairs. Note which obligations change under the proposed structure.
8. Test early settlement
Request settlement examples at several dates. Include outstanding price or units, accrued rent or profit, fees, legal costs and any rebate policy.
9. Test sale and refinancing
Map consents, valuations, transfer documents, cancellation fees and distribution of sale proceeds. Note whether the customer may choose the buyer and sale timing.
10. Test arrears and default
Record notices, hardship options, default charges, enforcement, sale process and treatment of any shortfall or surplus. Confirm National Credit Act application with qualified advice.
11. Check Shariah evidence
Retain the current approval, named adviser or board, contracts and explanation of ownership, variable pricing, late payment, maintenance and exit.
12. Compare total and practical fit
Calculate cash paid before registration, payments over the chosen horizon, estimated settlement and fees. Also compare service, documentation, flexibility and the family’s ability to understand and administer the structure.
Official starting points
Practical outcome: every proposal should reconcile to one timeline showing upfront cash, monthly payments, variable assumptions, ownership, fees and exit costs.
