Semantik ERP for Contracting Companies
A contracting company wins a contract, prices it in a BOQ, then builds it with its own labour, rented and owned equipment, subcontractors and bought materials, while billing the client every month through interim payment certificates (IPCs). It does this on many projects at once and lives on each project's margin and cash flow. This guide shows how to set Semantik ERP up for that, follows one school contract from award to the third IPC, and is open about which steps the system does and which you handle with a workaround. The screens are explained in CRM, Accounting, Project Controls and Procurement.
Leads, deals, priced proposals and a contract register
WBS code, task budget and progress per item
Materials, labour, subcontract, equipment, overheads
Timesheets, site-staff payroll and overhead share
Part payments, credit notes and overdue follow-up
CPI, SPI and estimate at completion
Who does what
The company account can create four ready-made roles in one click: User Management › Role › Create Project Controls roles (needs the Projects module in the plan). The other contractor roles are built by hand in User Management › Role › +, ticking the permissions on each module tab.
| In your company | Role | What they do in the system | Permissions to give or adjust |
|---|---|---|---|
| Tendering / estimation | Custom role | Logs tender enquiries as leads, runs bids as deals, prices the BOQ as a proposal | manage lead, create lead, edit lead, view lead, convert lead to deal, manage deal, create deal, edit deal, view deal, manage proposal, create proposal, edit proposal, show proposal, send proposal |
| Contracts / commercial manager | Custom role | Keeps the contract register, issues the monthly client invoices (IPCs), records client payments and credit notes, follows variations | manage contract, create contract, edit contract, show contract, manage invoice, show invoice, create invoice, edit invoice, send invoice, duplicate invoice, create payment invoice, manage credit note, create credit note, manage change orders, manage project, view project, view project budget, view project controls, project expenses (for Projects Income), invoice report, income report |
| Quantity surveyor / technical office | Custom role | Keeps budget lines and baselines, prepares variations, checks progress for the IPC | manage project, view project, manage project task, view project task, create project task, edit project task, view milestone, create milestone, edit milestone, view project budget, manage project budget (taken away from the Project Manager), manage change orders, manage project baseline, view project controls |
| Project manager | Project Manager | Approves requests and direct purchase orders, follows the project's cost and schedule | Add manage expense, view expense, create expense and edit expense if they record site expenses; no ready-made role has them |
| Site engineer | Site Engineer | Raises material requests, receives deliveries, reports task progress with photos from the mobile app | — (they also get the SPI/CPI push alerts sent on Sundays when a project's SPI or CPI drops into Watch or Act now, because the role has manage project and they are project members) |
| Site storekeeper | Custom role | Records goods receipts in the site store | manage goods receipt, manage warehouse, show warehouse, stock report, plus manage project and view project (and add them as project members, so they use Project › Procurement › Receive Goods), or show purchase |
| Procurement | Procurement Officer | Collects supplier and subcontractor quotes, awards them, creates purchase orders | As in the real-estate guide: remove approve purchase request and manage goods receipt |
| HR / timekeeper | Custom role | Marks site attendance, logs timesheets for crews, runs payroll, attaches site staff to projects | manage attendance, create attendance, manage timesheet, create timesheet, control timesheet, multi task timesheet, manage employee, manage set salary, manage pay slip, create pay slip, project expenses |
| Finance | Finance | Approves spending, pays suppliers and subcontractors, posts the monthly journal entries | Add the bill permissions listed in the real-estate guide, plus manage revenue, create revenue, manage journal entry, create journal entry |
| General manager / owner | Company account or a named Approver User | Signs off large amounts, uploads contract attachments | Only the company account and the client can upload Contract Attachments, and only the company account can download them |
Add the commercial manager and the QS as project members too: Budget Control, Change Orders and Earned Value open only from the project page.
Full permission lists: Project Controls › Ready-made roles and Roles & Permissions.
One-time setup
Tender pipeline
Open CRM System › CRM System Setup. Its tabs are Pipeline, Lead Stages, Deal Stages, Sources, Labels and Contract Type.
- Pipeline: for example "Government tenders" and "Private clients".
- Deal Stages: Tender received › Site visit › Pricing › Submitted › Negotiation › Awarded › Lost. Deals have no Won/Lost button, so the Awarded and Lost stages are how you mark the result.
- Sources: Tender portal, Consultant referral, Repeat client.
- Labels: Bid / No-bid.
- Contract Type: Lump Sum, Re-measured, Cost Plus. The type is a name only; the system applies no rules to it.
See CRM › Pipeline setup.
The client, twice
Projects, deals and contracts use a Client (a client user who can log in to the portal); proposals and invoices use a Customer. Create both, with the same name:
- User Management › Client › +: Name, E-Mail Address, Password.
- Accounting System › Customer › +, and under Client User Connection (Optional) choose Link to Existing Client User. The client then sees and can accept your quotations in the portal (Dashboard › Quotations). Invoices are not shown in the portal.
Income categories per project
A client invoice can't be linked to a project, but every invoice must carry an Income category, Income Summary can be filtered by category, and Profit & Loss lists income per category. So open Accounting System › Accounting Setup › Category › + and create, for each project, Category Type = Income:
- PRJ-014 Contract revenue, used on every IPC of the project;
- PRJ-014 Client advance, used only for the advance payment (see the example).
Also create, once, in the chart of accounts: Retention receivable, Advances from clients and Withholding tax receivable. They are used in the monthly journal entries.
One project per contract
Open Project System › Projects › + Create Project: Project Name, Start Date, End Date, Client, User (the team), Budget, Estimated Hours, Description and Status.
- Budget is the cost budget, not the contract value. Project health, "Over budget" and Budget Control all treat it as cost. Set it equal to the total of the budget lines.
- Add the team as project members (project › Members › +): site engineers, storekeepers, the project manager, the QS and Finance users. Users other than the company account only see projects they are members of.
- For the consultant or the client's engineer, the project page has a share icon (Shared project settings): a read-only link, optionally with a password, showing only the sections you switch on (tasks, milestones, timesheet, expenses…).
- For a similar job, Duplicate a past project from the list. It copies tasks and milestones but not WBS Code, Task Budget, Weight or budget lines, and the copied tasks still point at the old project's milestones. Re-link them and re-enter the budget fields.
The contract record
Create the project first, then CRM System › Contract › +: Client, Subject, Contract Type, Contract Value, Start Date, End Date, Projects (filtered to the client's projects) and Description. Write the commercial terms in the contract description: advance %, retention %, how the advance is recovered, defects liability period, bonds. The system has no fields for them. Then upload the signed contract, BOQ and drawings as Contract Attachments (company account). The contract starts as pending; the client accepts or declines it in the portal.
The contract value appears only on the Contract list (CRM System › Contract) and in the CRM dashboard's latest contracts. No project screen shows it, so the QS keeps it in mind when reading margin. See CRM › Contracts.
The BOQ inside the project
There is no BOQ object with unit, quantity and rate. Build the BOQ from milestones and tasks:
| BOQ | In the system | Fields to fill |
|---|---|---|
| Bill / section (Substructure, Superstructure…) | Milestone (project page › Milestones card › +) | Title, Status, Start Date, Due Date, Cost — all required |
| Item (02.03 RC columns) | Task, with the milestone selected | WBS Code = item number, Task Budget = item amount at contract rates, start and end dates, optional Weight |
| Progress | Task progress % (web, or mobile with photo and GPS) | 0–100, kept with its history |
Put quantity and unit in the task name or description ("RC columns GF — 85 m³"). Task budgets at contract value let the earned-value page give you the share of contract work done, once a baseline is approved (next step).
Cost codes
Project System › Cost Codes › +. Codes are company-wide and each has a Category (Materials, Labour, Subcontract, Equipment, Overheads, Other) and an optional Parent Code. A contractor's tree:
| Code | Name | Category |
|---|---|---|
| MAT-STEEL / MAT-CONC / MAT-FIN | Rebar, ready-mix concrete, finishing materials | Materials |
| LAB-SITE | Site labour and site staff | Labour |
| LAB-INS | Employer social insurance and on-costs | Labour |
| SUB-ELEC / SUB-PLUMB / SUB-ALU | Electrical, plumbing, aluminium subcontracts | Subcontract |
| EQP-HIRE / EQP-OWN / EQP-FUEL | Rented plant, internal charge for own plant, fuel and repairs | Equipment |
| OVH-SITE | Site office, utilities, security, permits | Overheads |
| CONT-01 | Contingency | Other |
Details: Project Controls › Cost codes.
Budget lines from the cost estimate
Open the project › Budget Control › + and add one line per cost code (and, if you want totals per section, per milestone): Cost Code, Phase / Milestone, Task, Description, Original Budget, Warn at (%), Block at (%). Budget Control shows the project's Budget next to the Sum of budget lines, so you see at once if they differ.
Baseline
Once tasks and budget lines are in, open the project › Earned Value › Baselines › Create baseline and approve it (needs manage project baseline). The baseline's BAC is the total of the budget lines (the cost budget). The task budgets, which you entered at contract value, are scaled to that BAC, so:
- At project level, EV, AC and CPI are all in cost terms and comparable;
- EV ÷ BAC is the share of contract work done, weighted by the BOQ amounts. Multiply it by the contract value to get the gross value of work done for the IPC.
Without an approved baseline, BAC is the sum of the task budgets (contract value), and CPI would compare selling value with cost. See Project Controls › Baselines.
Approvals, site stores and stock posting
Set these up exactly as in the real-estate guide: the approval matrix in EGP (Purchase Request, Budget Override, Purchase Order, Change Order), one warehouse per site store named after the project, and stock posting set to Only when goods are received on site, so material costs the project on the day it arrives.
Sites for attendance
- HRM System › HRM System Setup › Branch › + for each site, with its Latitude and Longitude. In Settings › System Settings › Company Settings tick Enforce Location on Clock In/Out and set Allowed Radius (meters) (default 200). Staff clocking themselves in from the app must then be on site. See HRM › Location-based attendance.
- On each employee, tick Has TimeSheet for engineers and staff who log hours against tasks. Leave it off for foremen and site staff who are charged to a site as a whole.
The contract-to-cash cycle
- 1Win the
contract - 2Plan the
budget - 3Buy &
subcontract - 4Execute &
record cost - 5Bill the
client - 6Collect &
close
Contract-to-cash cycleWin it, budget it, build it, bill it, collect it — every month until handover.
Worked example: a school building
Your company wins PRJ-014 — New Cairo school, a lump-sum contract with a government education authority. All amounts are in EGP and before VAT / table tax. If you select a tax on the IPC lines, the client also pays the tax, so Add Payment = net + tax; and Income Summary shows invoices including tax, so subtract the tax before the margin check. The deductions below don't change.
| Term | Value |
|---|---|
| Contract value | 24,000,000 |
| Duration | 14 months |
| Advance payment | 10% = 2,400,000, recovered by deducting 10% from each IPC |
| Retention | 5% of each IPC, released at handover and after the defects liability period |
| Cost estimate | 20,400,000, so a planned margin of 3,600,000 (15%) |
1. Win the contract
| Step | Where | In the system? |
|---|---|---|
| The tender notice arrives; log it as a lead (Subject, User, Name, Email, Phone). A web enquiry form can create leads by itself (CRM System › Form Builder). | CRM System › Leads › + | Yes |
| Decide to bid; convert the lead to a deal with Deal Name, Price 24,000,000 and the existing client. Put tender documents and the bid bond in the deal's Files, deadlines as deal Tasks. | Lead › Convert to Deal | Yes |
| Price the BOQ for the client: one Service product per BOQ item, Quantity = BOQ quantity, Price = rate. Add a Tender No. as a proposal custom field. | Accounting System › Proposal › Create Proposal | Yes |
| Send it; the client accepts in the portal, or you set the status to Accepted. | Proposal › Send Proposal | Yes |
| Mark the deal as won by moving it to the Awarded stage. | CRM System › Deals (Kanban) | Workaround no Won/Lost status |
| Create the project and the contract record (see setup). Nothing is carried over from the deal or proposal: re-key the BOQ as tasks. | Project System › Projects; CRM System › Contract | By hand |
2. Plan the budget
The QS builds the BOQ as five milestones with tasks whose Task Budgets add up to the contract value, and the cost estimate as budget lines:
| Milestone (BOQ section) | Σ Task Budget (contract value) |
|---|---|
| 01 Substructure | 4,800,000 |
| 02 Superstructure | 7,200,000 |
| 03 Masonry & finishes | 6,000,000 |
| 04 MEP | 4,800,000 |
| 05 External works | 1,200,000 |
| Total | 24,000,000 |
| Budget line | Original budget |
|---|---|
| MAT-STEEL — Rebar | 3,600,000 |
| MAT-CONC — Ready-mix concrete | 2,400,000 |
| MAT-FIN — Finishing materials | 3,000,000 |
| LAB-SITE — Site labour and staff | 3,000,000 |
| SUB-ELEC — Electrical subcontract | 2,000,000 |
| SUB-PLUMB — Plumbing subcontract | 1,500,000 |
| SUB-ALU — Aluminium subcontract | 1,000,000 |
| EQP-HIRE — Plant hire | 1,200,000 |
| OVH-SITE — Site overheads | 1,700,000 |
| CONT-01 — Contingency | 1,000,000 |
| Total (= project Budget = BAC) | 20,400,000 |
The project's Budget field is set to 20,400,000 and a baseline is approved, so BAC = 20,400,000.
The advance payment
The client pays the 2,400,000 advance in month 1. There is no advance-payment feature, so:
- Accounting System › Income › Revenue › +: Customer = the school authority, Category = PRJ-014 Client advance, Account = the bank account, Amount 2,400,000. The bank balance and the customer's balance move.
- Revenue entries count as income in Income Summary and Profit & Loss. Leave the advance category out when you read project revenue.
- In the books, post a journal entry (Accounting System › Double Entry › Journal Account): Dr Bank 2,400,000 / Cr Advances from clients 2,400,000. Invoices, payments and revenue entries do not post to the chart of accounts by themselves.
Stop the recovery credit notes once Advance still to recover reaches 0: after a variation raises the billing, 10% of every IPC would recover more than the 2,400,000 received.
3. Buy materials and subcontract
Materials follow the full procurement cycle: request on a budget line, approval, quotes, purchase order, site receipt, bill with three-way match. It is shown step by step in the real-estate rebar example and works the same for a contractor.
The electrical subcontract (2,000,000) is bought as a service:
- Create a Service product "Electrical works — PRJ-014" (Products System › Product & Services, type Service).
- Project › Procurement › Request materials: the service item, Quantity 100 (%), Est. Unit Price 20,000, Budget Line SUB-ELEC. Total 2,000,000.
- After approval, add the subcontractors' quotes under Supplier Quotes and Select the winner. The purchase order keeps the service line, budget line and cost code. (The direct purchase order form does not list service items, so always start from a request.)
- Each month, the engineer certifies the subcontractor's progress as a goods receipt: in month 3, 15 (%). In receipt mode this posts 15 × 20,000 = 300,000 actual cost to SUB-ELEC.
- Finance opens the order › Create Bill from PO for the certified 15% (300,000) and pays 285,000 with Add Payment, leaving 15,000 (5%) open on the bill as retention.
Plant hire: the rented loader for month 3 (22 days × 3,000 = 66,000) is entered as a bill (Accounting System › Bill › Create) on a service product, with the project and the EQP-HIRE budget line; it posts actual cost at once.
4. Execute and record cost
During the month the site records progress and cost:
- Progress: site engineers update each task's progress %, from the web or from the mobile app with a photo and GPS. Progress feeds earned value immediately.
- Site expenses (fuel, petty cash, permits): Project System › OverHead › Create, with the project in Projects and the cost code. The receipt picked in the Create form is not saved: open the project › Expense › Edit on the row to set the Budget Line and attach the receipt in one go. Don't use the Create button on the project's Expense page: saving from it currently fails.
- Labour: engineers log timesheets on tasks; site staff are attached to the project in Project Payslips after payroll. On the 1st of the next month at 03:00, labour, site-staff payroll and the overhead share are posted to the project's Unallocated row. See labour and equipment.
At the end of month 3, after the labour posting, Budget Control shows:
| Line | Actual to date |
|---|---|
| MAT-STEEL — Rebar | 1,450,000 |
| MAT-CONC — Ready-mix concrete | 1,100,000 |
| SUB-ELEC — Electrical subcontract | 300,000 |
| SUB-PLUMB — Plumbing subcontract | 150,000 |
| EQP-HIRE — Plant hire | 260,000 |
| OVH-SITE — Site overheads | 340,000 |
| Unallocated costs (labour, site staff, overhead share) | 1,700,000 |
| Total actual cost (AC) | 5,300,000 |
The LAB-SITE line still shows 0 actual: its labour is in the Unallocated row.
5. Bill the client: IPC-03
The Earned Value page shows EV 5,100,000 against BAC 20,400,000, so 25% of the contract work is done. The consultant certifies the same. The IPC sheet itself (previous, this period, cumulative per item) is kept outside the system:
Gross value of work to date 24,000,000 × 25% = 6,000,000 Less previous IPCs 1,200,000 + 1,800,000 = 3,000,000 This IPC, gross 3,000,000 Advance recovery 10% × 3,000,000 = 300,000 Retention 5% × 3,000,000 = 150,000 Net payable by the client 2,550,000
In the system:
- Accounting System › Income › Invoice › Duplicate on IPC-02. The copy keeps the customer, category and lines; change the quantities or prices to this period's values (here: Substructure 600,000 and Superstructure 2,400,000 as Service lines) and re-type the descriptions, which are not copied. It also copies IPC-02's Due Date and Ref Number: set a new Due Date (for example Issue Date + the contract's payment period), otherwise the IPC shows as overdue at once.
- Category = PRJ-014 Contract revenue; Ref Number = "PRJ-014 / IPC-03". The invoice is for the gross 3,000,000.
- Don't put retention or advance recovery in the line Discount: the discount lowers the invoice total and the tax.
- Send Invoice › Send.
6. Collect and close the month
- Accounting System › Income › Credit Note › +: Invoice = IPC-03, Amount 300,000, Date, Description "Advance recovery IPC-03". The open due falls to 2,700,000. (The Add Credit Note button on the invoice page appears only for the company account and only after a first payment.)
- When the client pays, Add Payment: Amount 2,550,000, Account = bank, Reference = the client's payment number. The invoice is Partialy Paid with 150,000 open: that is the retention.
- If the client withholds tax, receive the net amount and clear the withheld part with a credit note marked "WHT", keeping the certificate on file.
- Journal entry for the month: Dr Receivable 3,000,000 / Cr Contract revenue 3,000,000; then Dr Bank 2,550,000, Dr Advances from clients 300,000, Dr Retention receivable 150,000 / Cr Receivable 3,000,000.
- Project System › Projects Income › +: Projects = PRJ-014, Amount 3,000,000, Notice Date, Comment "IPC-03 gross". This puts the revenue next to cost in the yearly Excel export.
The client's position after IPC-03:
| Item | Amount | Where you see it |
|---|---|---|
| Billed to date (gross) | 6,000,000 | Income Summary, category PRJ-014 Contract revenue |
| Advance received | 2,400,000 | Revenue list, category PRJ-014 Client advance |
| Advance recovered (IPC-01 to 03) | 600,000 | Credit notes on the three invoices |
| Advance still to recover | 1,800,000 | By hand: 2,400,000 − 600,000 |
| Retention held by the client | 300,000 (60,000 + 90,000 + 150,000) | Invoice Summary › Customer, Status = Partialy Paid |
| Cash received in total | 7,500,000 | 2,400,000 advance + 5,100,000 net on IPCs |
Income Summary shows invoice totals including VAT, one calendar year at a time: for a taxed contract, take the amounts before VAT (Invoice Summary or the invoice subtotals), and for a contract that spans years add the years together. In Invoice Summary set the date range from the first IPC to today.
At handover, release half or all of the retention with Add Payment on each old IPC when the client pays it.
The margin check
| Figure | Amount | Source |
|---|---|---|
| Value of work billed to date | 6,000,000 | Income Summary (project category) |
| Actual cost to date (AC) | 5,300,000 | Budget Control › Actual, or Earned Value › AC |
| Margin to date | 700,000 (11.7%) | By hand |
| Earned value (EV) | 5,100,000 | Earned Value |
| CPI = EV ÷ AC | 0.96 | Earned Value |
| EAC = BAC ÷ CPI | 21,200,000 | Earned Value |
| TCPI = (BAC − EV) ÷ (BAC − AC) | 1.01 | Earned Value |
| Forecast margin = contract value − EAC | 2,800,000 (11.7%, against 15% planned) | By hand |
The project is spending 1.04 EGP for every 1 EGP of budgeted work. The planned 15% margin is down to 11.7%. The QS looks at Totals by Cost Code and the Unallocated row to find out where the extra cost is.
Two things to keep in mind when reading these figures. AC includes the head-office overhead share that the monthly run posts, while the cost estimate has only site overheads (OVH-SITE): treat the margin as net of head-office overhead, or add a budget line such as OVH-HO "Head-office overhead allocation" to the estimate. And with stock posting on receipt, rebar and concrete delivered but not yet installed are already in AC but not yet in EV, so early CPI and margin look worse than they are: read them with the stock still on site in mind.
Client variations and cost change orders
A change order in Semantik ERP changes cost budget lines only (Cost Impact, Days Impact). It has no selling value. A client variation therefore has two halves, and you record both:
| Half | Where | VO-01: extra canopy, sell 1,200,000, cost 1,000,000, 20 days |
|---|---|---|
| Cost | Project › Budget Control › Change Orders › + | Title "VO-01 canopy", Cost Impact 1,000,000, Days Impact 20, client instruction number in the Description. Submit, approve, then Apply to Budget: MAT-STEEL +300,000, MAT-CONC +200,000, SUB-ALU +500,000. Revised budget becomes 21,400,000. |
| Contract value | CRM System › Contract › Edit | Contract Value 24,000,000 → 25,200,000; record the client's approval letter in Comments or Notes. |
| BOQ | Project tasks | Add tasks under a "Variations" milestone, Task Budget 1,200,000, so task budgets again add up to the contract value. |
| Schedule | Earned Value › Baselines | Create and approve a new baseline. The 20 days do not move the schedule by themselves. |
| Billing | Next IPC | Bill the VO as extra lines, with "VO-01" in the description and Ref Number. |
A cost-only change (rework, a price rise, a change in method) has no client half: use a change order or Budget Control › Revise Budget › Transfer from CONT-01. An omission is a negative Cost Impact plus a lower Contract Value. Details: Project Controls › Change orders.
Labour and equipment
How labour reaches a project
| Who | How they are costed | Where you set it |
|---|---|---|
| Engineers and staff with Has TimeSheet | Each payslip's net pay is spread over all the minutes they logged in the payroll period. The project share goes to each project; time not on projects goes to the overhead pool. | Project System › Timesheet › Add Timesheet / Add Multi Timesheet (or the mobile app) |
| Foremen and site staff without timesheets | Their payslip's net pay is split equally over the projects they are attached to for that month. | Project System › Project Payslips › Create (after Generate Payslip) |
| Head-office staff with neither | Enter their salaries as a company overhead expense (OverHead › Create with Projects empty). Overhead is spread over projects in proportion to their labour and project-expense cost (bills and goods receipts are not counted). | Project System › OverHead |
| Casual labourers and labour-supply contractors | Every employee needs a unique email and a login. Buy crew labour as a service from the labour supplier (request, order, bill on LAB-SITE), or record the weekly wage sheet as a project expense with LAB-SITE. | Procurement, or OverHead › Create |
| Employer insurance and on-costs | Not included: project labour uses net pay. Post the employer on-cost monthly as a project expense with LAB-INS, split over the sites. | OverHead › Create, several Projects |
- Attendance: mark a whole crew at once in HRM System › Attendance › Attendance Day (filter by Date, Branch, Department), import a file or sync ZKTeco devices. Payroll turns missing hours into a deduction and extra hours into overtime. See HRM › Payroll.
- A foreman with manage employee can clock in a crew member from the app. The location is saved, but the distance check only applies when people clock themselves in.
- Multi-day timesheets fill only days with Present attendance (using that day's attendance hours) and skip Fridays and Saturdays. Mark attendance first, and log Saturday work as single-day entries.
- Attach only staff without timesheets in Project Payslips. Timesheet employees attached there are ignored in project cost.
- Project System › Projects Expenses shows each project's Total Timesheet Cost, Total OnSite Cost, Total Other Cost and Overhead for any period, with Excel exports. It doesn't include supplier bills and goods receipts; Budget Control does.
Equipment
| Case | What to do |
|---|---|
| Rented plant (crane-day, loader-hour) | A service product and an EQP-HIRE budget line; buy through request › quote › order › receipt › bill, or a direct bill with the project and budget line. Small cash hires: OverHead › Create with the EQP code, then Edit from the project's Expense page to attach the receipt. |
| Own plant | There is no equipment register, hours log or internal hire rate. Charge each machine monthly as a project expense on EQP-OWN (for example "Loader L-02 — 22 days × rate"), and book depreciation by journal entry. |
| Fuel and repairs | Project expenses on EQP-FUEL, receipt attached with Edit on the project's Expense page. |
Month-end control
No single month-end screen exists. This routine uses the screens that do:
- Close payroll (Generate Payslip) and attach site staff to projects in Project Payslips.
- Make sure every supplier bill, subcontractor certificate (goods receipt) and site expense of the month is entered.
- Issue each project's IPC, record client payments, credit notes and the month's journal entries; record the IPC in Projects Income.
- After the 1st-of-month 03:00 run has posted labour and overhead, review each project:
| Where | What to look at |
|---|---|
| Project › Budget Control | Actual and Available per line, Totals by Cost Code, and the Unallocated row (labour + overhead) against the LAB-SITE budget. This is the most complete actual cost. |
| Project › Earned Value | EV ÷ BAC for the IPC, CPI, SPI, EAC and the By-phase table. In By phase, BAC and EV are at contract value: phase EV is the gross value of work done in that BOQ section, so use it for the IPC lines (for example Substructure 600,000 this period). Ignore the per-phase CPI and EAC: phase AC only includes costs tagged to a task of that milestone. Save snapshot (a snapshot is also saved every Sunday for In Progress projects). See Earned value. |
| Project System › KPI Scorecard and the project dashboard | All active projects with budget used, SPI, CPI and health; Projects needing attention and Waiting for your approval cards. See KPI scorecard. |
| Accounting System › Customer, and Reports › Invoice Summary | Overdue per client and open dues per invoice (retention = Partialy Paid). Don't use the customer Balance: the advance and the credit notes distort it. Overdue includes retention once due dates pass. |
| Reports › Income Summary | Revenue per project category, for the margin. |
| Project System › Projects Expenses › Export year Total Ex | Per project: Projects Income next to direct, overhead and total cost (no bills or receipts, no profit column). |
If the schedule changed (an extension of time, a variation), create and approve a new baseline.
What the system doesn't do yet
These are the gaps a contractor will meet, with the workaround we recommend today. Procurement limits (budget reservation, tendering, site stores) are in the real-estate guide.
Tenders and contracts
| Need | Today | Workaround |
|---|---|---|
| BOQ with unit, quantity, rate and measured quantities | Missing | Milestones and tasks with WBS Code and Task Budget; quantity in the name; proposal lines for the priced BOQ. |
| Won deal or accepted proposal becomes a project | Missing | Create the project and contract by hand; re-key the BOQ. |
| Won/Lost status and win rate | Missing | Awarded and Lost deal stages; CRM reports by stage. |
| Bid bond, deadline, tender number | Missing | Deal Files and Tasks, Labels, a custom field on the proposal (custom fields are not available on deals, contracts or projects). |
| Advance %, retention %, defects period, bonds as contract fields | Missing | Write them in the contract description; attach the bonds. |
| Contract value on the project | Missing | CRM contract linked to the project; task budgets at contract value. |
| Staff manage contract attachments | Partial: company account and client only | The owner uploads, or use the project's or deal's files. |
| One client record across CRM, projects and accounting | Partial | Client user plus Customer with the same name, linked through Client User Connection. |
Client billing and receivables
| Need | Today | Workaround |
|---|---|---|
| Invoice linked to a project | Missing | One Income category per project; project and IPC number in Ref Number, or in Invoice custom fields (Accounting Setup › Custom Field, module Invoice). |
| IPC with previous / this period / cumulative per item | Missing | Duplicate last month's invoice and enter this period only; keep the IPC sheet outside and attach it to the payment receipt. |
| Milestone billing | Missing | A normal invoice when the milestone is reached, named in Ref Number. |
| Retention | Missing | Leave it as the invoice's open due; release with Add Payment; Dr Retention receivable by journal entry. |
| Advance payment and recovery | Missing | Revenue entry in an advance category; credit note per IPC for the recovery; journal entries for the books. |
| Price adjustment / escalation claims | Missing | Bill them as extra IPC lines with the claim number, as for a VO. |
| Other client deductions (social insurance, stamp duty) | Missing | Handle them like WHT: a credit note with a label, plus a journal entry. |
| Withholding tax deducted by the client | Missing | Credit note marked WHT, or leave it open; journal entry to WHT receivable. |
| Receivables aging and customer statement | Missing | Customer page (Balance, Overdue), invoice list (red due dates), Invoice Summary exported to a spreadsheet. |
| Automatic posting to the general ledger | Missing | Monthly summary journal entries for revenue, VAT, receivables, retention and advances. |
| Credit notes in the customer balance and reports | Partial: they lower the invoice due but move the customer Balance the wrong way, and Income Summary ignores them | Trust invoice dues over the customer Balance; post revenue reversals by journal entry. |
Cost and margin control
| Need | Today | Workaround |
|---|---|---|
| Project margin or profitability report | Missing | Income Summary by project category against Budget Control actual, as in the margin check. |
| Cash flow per project | Missing | Projects Income and client payments for cash in; bill payments and the Projects Expenses export for cash out. |
| Variation that changes contract value and cost together | Partial: cost only | Change order for cost, edit the contract value, extra tasks, new baseline. |
| Labour against the LAB budget line | Missing: always in Unallocated | Compare the LAB line with the Unallocated row or with Projects Expenses. |
| Labour cost during the month | Partial: posted on the 1st of the next month | Read Projects Expenses mid-month; expect CPI to look better than reality until the monthly run. |
| Cost report by category (materials, labour, subcontract, equipment) | Missing | One budget line per category code, Totals by Cost Code. |
| Project Report detail page for project managers and site engineers | Partial: works correctly only for the company account | Use the project page, Budget Control and Earned Value. |
| Site progress photos on the web | Partial: in the mobile app only | Review them in the app. |
| Earned value and budgets on the mobile app | Missing | Use the web on a phone, and the SPI/CPI push alerts (sent when an index worsens). |
| Milestones-on-time KPI | Missing: can be set, never calculated | Track milestone due dates by hand. |
Labour and equipment
| Need | Today | Workaround |
|---|---|---|
| Add an expense from the project's Expense page | Broken: the save fails | Project System › OverHead › Create with the project selected; set the budget line by editing it from the project. |
| Keep the task when an expense is edited | Partial: editing clears it | Re-create the expense instead of editing it if the task matters. |
| Labour cost with employer on-costs, or standard daily rates | Missing: net pay only | Monthly LAB-INS project expense. |
| Casual labour without email or login | Partial | Buy labour as a service, or a weekly wage-sheet expense. |
| Attendance geofence per project site | Partial: per branch | One branch per site; change the employee's branch when they move. |
| Spreading head-office salaries when site staff have no timesheets | Partial: Generate Projects Costs needs timesheet cost | Enter head-office salaries as overhead expense. |
| Equipment register, hours, internal rates, depreciation | Missing | Monthly EQP-OWN expense per machine; depreciation by journal entry. |
| Subcontractor certificates with retention and advance recovery | Missing | Service purchase order, monthly goods receipt, bill from PO, part payment for retention (see real-estate guide). |
| Site expenses from the mobile app | Missing | Enter them on the web; receipt attached with Edit on the project's Expense page. |
Go-live checklist
- Pipelines, deal stages (including Awarded and Lost), sources and contract types set up.
- Each client created as a Client user and as a Customer linked to it.
- Two Income categories per project (contract revenue, client advance); retention, advance and WHT accounts in the chart of accounts.
- One project per contract, with the Budget field = cost budget and all team members added.
- A CRM contract per project with the contract value, terms in the description and the signed documents attached.
- BOQ as milestones (dates set on creation) and tasks with WBS Code and Task Budget at contract value.
- Company cost codes (MAT, LAB, SUB, EQP, OVH, CONT) and budget lines adding up to the project Budget.
- A baseline approved on every project.
- Approval rules, site-store warehouses and stock posting Only when goods are received on site, as in the real-estate guide.
- One branch per site with coordinates; Has TimeSheet set correctly on every employee.
- Custom roles created for tendering, commercial, QS, storekeeper and HR; Finance given bill, revenue and journal permissions.
- The server cron runs the scheduler, so labour posts on the 1st and EVM snapshots save on Sundays.
- Company policy written down: IPCs are invoiced gross; advance recovery by credit note; retention left open; project category and IPC number on every invoice.
Quick reference
| Task | Path |
|---|---|
| Tender pipeline and stages | CRM System › CRM System Setup |
| Log a tender / bid | CRM System › Leads › + ; lead › Convert to Deal |
| Priced BOQ for the client | Accounting System › Proposal › Create Proposal |
| Contract register | CRM System › Contract › + |
| Project per contract | Project System › Projects › + Create Project |
| BOQ sections and items | Project › Milestones card › + ; Tasks › + Create Task |
| Cost codes and budget lines | Project System › Cost Codes ; Project › Budget Control › + |
| Baseline | Project › Earned Value › Baselines › Create baseline |
| Advance payment | Accounting System › Income › Revenue › + |
| Monthly IPC | Accounting System › Income › Invoice › Duplicate |
| Client payment / advance recovery | Invoice › Add Payment ; Accounting System › Income › Credit Note › + |
| Project revenue log | Project System › Projects Income › + |
| Site expense | Project System › OverHead › Create (with Projects) |
| Site staff to projects | Project System › Project Payslips › Create |
| Timesheets | Project System › Timesheet › Add Timesheet |
| Variation (cost side) | Project › Budget Control › Change Orders › + |
| Period cost and income export | Project System › Projects Expenses › Export year Total Ex |
| Month-end review | Budget Control, Earned Value, KPI Scorecard, Invoice Summary, Income Summary |