The Friday Site Reality: If you are constructing a 5 Marla, 10 Marla, or 1 Kanal residential project, your single largest unmonitored cash outflow will not be cement or bricks—it will be unrecorded contractor advances. Here is how professional site engineers maintain a clean ledger in Excel and eliminate thekedar overbilling.
On residential building sites across Pakistan, the GCC, and developing markets, contractor disbursements routinely happen on Friday afternoons via cash handoffs, ATM withdrawals, and quick mobile banking transfers.
"Bhai, 50,000 cash de dain, kal mistriyon aur mazdooron ki weekly dihari deni hai."
Without a signed, running reconciliation ledger, this informal practice leads straight to the classic roof-casting dispute: the contractor claims he is owed money, while you know your bank account is already depleted far beyond the agreed milestones.
1. The 3-Column Reconciliation Rule for Site Advances
The primary accounting mistake site owners make is treating labor payouts as generic "site expenses." A labor payment is not an expense until work has been physically measured and verified. It is an Advance Against Work in Progress.
Every contractor transaction row must record three distinct values:
- Gross Certified Work Done: The physical volume completed (e.g., 2,400 sq. ft. of grey structure masonry at your agreed contract rate).
- Cumulative Cash Advances Disbursed: Running sum of all cash, cheque, and online banking advances handed over to date.
- Retention Money Withheld: A compulsory security deduction (typically 5% to 10%) reserved to cover defects, hollow plaster, or snag-list repairs.
2. The 5% to 10% Retention Money Formula in Excel
Retention money is the owner's primary legal and financial leverage. If a contractor walks off the site after casting the slab, having a 5% to 10% retention buffer ensures you have funds to hire rectification labor.
If Gross Certified Work is in Cell D12, enter this in your Retention Column (E12):
=ROUND(D12 * 0.08, 0)
3. The Anti-Dispute Sign-Off Protocol
Spreadsheets only protect you if the contractor acknowledges the balance before receiving new funds. Follow this exact weekly operating procedure:
- Open your contractor ledger tab every Friday morning before noon.
- Log all week-to-date banking receipts and cash slips.
- Export the sheet to PDF or print a hard copy.
- When the thekedar arrives for Friday disbursements, have him review the running balance, sign the printout with his CNIC / National ID number, and write: "Received advances verified."
Material Variance & Overbudget Alert Calculator
Test your planned material cost vs. actual site spending to detect contractor overbilling or material leakage instantly.
Eliminate Site Cash Leaks Today
Download our complete House Construction Cost Tracker & Contractor Ledger v1.0 ($15). Pre-built with running cash reconciliation formulas, 12-trade budget tracking, and automated thekedar deduction tables.
Download Master Construction Workbench ($15) → Instant Digital Download (.xlsx) • 100% Macro-Free • Zero Software Subscriptions