ποΈ Project Information
π Cost Deductions from Planned Cash OUT
These % are deducted from your planned cost each month to show your true project cash out target (excluding HO recovery and profit margin).
π
Baseline Programme
Programme Period
-
-
π·οΈ Manage Trades
Customise cost categories used in BOQ and charts.
πΉ Actual Cash IN vs Cash OUT β All Transactions
Includes pre & post programme transactions Β· Monthly bars
π Bill of Quantities
π‘ Excel import: Download the template, fill in your BOQ items, then upload. Columns: Trade | Description | Unit | Qty | Rate (AED). Data starts from row 3.
π S-Curve
Planned Revenue (Cum. IPC)
Cash IN β BOQ Actual Completed (Cum.)
Cash OUT β Actual Expenses (Cum.)
π₯ Monthly Revenue β Planned vs BOQ Actual
π€ Monthly Cash OUT by Category
πΉ Actual Cash IN vs Cash OUT β All Transactions
Includes pre & post programme transactions Β· Monthly bars with running net position line
π° Project Cashflow Statement
π₯ CASH IN β Revenue received from Client
β’ Main contract advance received from client
β’ Monthly IPC / Progress Claims certified
β’ Advance recovery = deducted FROM your claim (reduces Cash IN)
β’ Monthly IPC / Progress Claims certified
β’ Advance recovery = deducted FROM your claim (reduces Cash IN)
π€ CASH OUT β Costs paid by the Company
β’ Petty Cash expenses (auto from date entered)
β’ Purchase Orders / LPOs (auto from LPO date)
β’ Staff & Labour Salaries (auto from month entered)
β’ Purchase Orders / LPOs (auto from LPO date)
β’ Staff & Labour Salaries (auto from month entered)
π¦ Supplier Cost Basis:
Using LPO dates β rate from LPO Γ qty
π₯ Main Contract Advance β Received from Client
This is the mobilisation advance paid by your client to your company β it is Cash IN. Recovery is deducted from future IPC claims.
π IPC / Progress Claims Register (Cash IN)
Enter each certified IPC. Gross Claim = what you submitted. Deductions (retention, advance recovery) are shown separately. Net Certified = Cash IN actually received.
π Monthly Cashflow β Cash IN vs Cash OUT
π‘ Cash IN is automatic. Calculated from Main Contract Advance + IPC Net Certified by date. | Planned Revenue auto-spreads from your Revised Contract Sum (BOQ + Approved VOs). Use βοΈ to override per month if needed.
π Project Costing Statement
π Variation Order Register
π΅ Petty Cash Expenses
π¦ Purchase Orders (LPO / International)
π Delivery Notes
π· Salary Records
π Staff Salary
π§ Labour Salary
π³ Advance Payments & Recovery
π‘ How it works: Add each advance payment below. Each advance can have multiple recovery entries (deducted from progress payments). The outstanding balance is tracked automatically per advance.