🔄 SYNC ALL — Updates MOS received qty & rates from Direct Purchases, plus syncs Diesel from owned equipment consumed (L)
📦 MOS — Materials On Site
Inventory · Prev balance carries from last DPR · Closing balance DEDUCTED from expenses
📋 Prev Day Balance auto-carries from yesterday. Click Sync All to pull Received Qty + Rate from Direct Purchases. Closing Balance Value is deducted from expenses (it's stock on site = asset, not cost).
⛽ DIESEL (STORE): Received = from Direct Purchases. Issued/Consumed = total fuel issued to owned + hired equipment. DIESEL (MACHINES): Received = issued from store (auto-matched). Consumed = actual consumed by all equipment (opening + issued − closing).
Material
Unit
Prev Day Bal
Received Today
Issued/Consumed Today
Closing Bal
Rate (MWK)
Closing Balance Value
TOTAL MOS CLOSING BALANCE VALUE (deducted from expenses)
0.00
Site Notes & Observations
Financial Summary
True P&L · MOS closing stock deducted (not double-counted)
Expense Breakdown
Equipment (W/H+S/H+OPT+Fuel)0.00
Labour / Workforce0.00
— Direct Material Purchases0.00
— Machine Hire Charges0.00
— Other Items0.00
✓ LESS: MOS Closing Balance (Stock Asset)0.00
NET TOTAL EXPENSES0.00
REVENUE (WORK + ESC)
0.00
NET EXPENSES
0.00
PROFIT TODAY
0.00
MWK
0.00%
PROFIT MARGIN
⚠ Revenue = BOQ Rate × Qty Today × (% Done ÷ 100) + escalation. Net Expenses = Equipment + Labour + Purchases + Hire + Other − MOS Closing Stock. MOS closing = stock on site (asset). Only consumed materials are an expense.
Signatures
Site Engineer
Project Manager
Client Representative
Project Dashboard
Reports
Select date range and type, then click ▶ Generate
Settings & Guide
👤 Users
ADD NEW USER
🏗 Project Access
Set per-project access for each user: ✏ Data Entry with View Only — can enter & save DPRs 👁 View Only (no data entry) — can view/report only, inputs disabled — No Access — — project not visible to user
🔑 Change My Password
📋 How to Use — Multiple Projects
Step 1 — Create a Project
Click "+ New Project" in the top bar → enter project name.
Each project stores its own DPRs independently.
Step 2 — Import Master Lists (once per project)
Use the green bar above: Import BOQ Excel, Hire Machines, Own Equipment.
These persist in your browser — import once, use always.
Step 3 — Daily Entry
Fill in work done → click Sync All → Save DPR.
Next day: click "New DPR" — MOS & diesel carry forward automatically.
Step 4 — Multiple Computers (PM → Office)
PM clicks Export JSON → shares the .json file (WhatsApp/email).
Office opens the HTML file → Import JSON → data appears instantly.
Office can view dashboards, generate reports, print PDF.
Step 5 — Switching Projects
Select project from dropdown at the top. All DPRs are stored separately.
Dashboard and Reports filter automatically to selected project.
📁 Data Backup
When Cloud is connected: data saves to Google Sheets automatically.
When offline: data saves to browser localStorage as fallback.
Export Full Backup anytime as a .json file for archiving.
Restore Backup re-uploads everything to cloud + local.
☁ Google Sheets Setup
Step 1 — Create a Google Sheet
Go to sheets.google.com → New spreadsheet → name it DPR Cloud.
Copy the Sheet ID from the URL: https://docs.google.com/spreadsheets/d/SHEET-ID-HERE/edit
Step 2 — Open Apps Script
In your Sheet → Extensions → Apps Script → delete default code → paste the GAS_Script.js file provided → Save.
Step 3 — Deploy as Web App
Deploy → New deployment → Type: Web App → Execute as: Me → Who has access: Anyone → Deploy → Copy the URL.
