Semantik ERPDocs

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.

Tenders to contracts

Leads, deals, priced proposals and a contract register

BOQ as milestones and tasks

WBS code, task budget and progress per item

Cost budget by cost code

Materials, labour, subcontract, equipment, overheads

Labour cost to projects

Timesheets, site-staff payroll and overhead share

Monthly client invoices

Part payments, credit notes and overdue follow-up

Earned value per project

CPI, SPI and estimate at completion

Read this first. Semantik ERP keeps the cost side of a contract well: budget lines, commitments, actual cost and earned value. The revenue side has no project link: client invoices have no project field, and the system has no fields for the contract value on the project, advance payments, retention or IPC cumulative quantities. This guide uses a fixed set of workarounds for these (one income category per project, the CRM contract for the contract value, part payments for retention, credit notes for advance recovery). Use them the same way on every project so the numbers stay comparable.

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 companyRoleWhat they do in the systemPermissions to give or adjust
Tendering / estimationCustom roleLogs tender enquiries as leads, runs bids as deals, prices the BOQ as a proposalmanage 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 managerCustom roleKeeps the contract register, issues the monthly client invoices (IPCs), records client payments and credit notes, follows variationsmanage 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 officeCustom roleKeeps budget lines and baselines, prepares variations, checks progress for the IPCmanage 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 managerProject ManagerApproves requests and direct purchase orders, follows the project's cost and scheduleAdd manage expense, view expense, create expense and edit expense if they record site expenses; no ready-made role has them
Site engineerSite EngineerRaises 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 storekeeperCustom roleRecords goods receipts in the site storemanage 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
ProcurementProcurement OfficerCollects supplier and subcontractor quotes, awards them, creates purchase ordersAs in the real-estate guide: remove approve purchase request and manage goods receipt
HR / timekeeperCustom roleMarks site attendance, logs timesheets for crews, runs payroll, attaches site staff to projectsmanage 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
FinanceFinanceApproves spending, pays suppliers and subcontractors, posts the monthly journal entriesAdd the bill permissions listed in the real-estate guide, plus manage revenue, create revenue, manage journal entry, create journal entry
General manager / ownerCompany account or a named Approver UserSigns off large amounts, uploads contract attachmentsOnly 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:

  1. User Management › Client › +: Name, E-Mail Address, Password.
  2. 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:

BOQIn the systemFields 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 selectedWBS Code = item number, Task Budget = item amount at contract rates, start and end dates, optional Weight
ProgressTask progress % (web, or mobile with photo and GPS)0–100, kept with its history
Set milestone dates when you create the milestone. Editing a milestone today saves its Due Date as empty. Avoid editing milestones, or re-check the date afterwards.

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:

CodeNameCategory
MAT-STEEL / MAT-CONC / MAT-FINRebar, ready-mix concrete, finishing materialsMaterials
LAB-SITESite labour and site staffLabour
LAB-INSEmployer social insurance and on-costsLabour
SUB-ELEC / SUB-PLUMB / SUB-ALUElectrical, plumbing, aluminium subcontractsSubcontract
EQP-HIRE / EQP-OWN / EQP-FUELRented plant, internal charge for own plant, fuel and repairsEquipment
OVH-SITESite office, utilities, security, permitsOverheads
CONT-01ContingencyOther

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.

Timesheet and payroll labour never lands on the LAB-SITE line. Timesheet labour, site-staff payroll and the overhead share reach Budget Control once a month with no budget line, in the row Unallocated costs (no budget line). Keep a LAB-SITE line for the budget figure and compare it by hand with that row. See labour and equipment.

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

  1. 1Win the
    contract
  2. 2Plan the
    budget
  3. 3Buy &
    subcontract
  4. 4Execute &
    record cost
  5. 5Bill the
    client
  6. 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.

TermValue
Contract value24,000,000
Duration14 months
Advance payment10% = 2,400,000, recovered by deducting 10% from each IPC
Retention5% of each IPC, released at handover and after the defects liability period
Cost estimate20,400,000, so a planned margin of 3,600,000 (15%)

1. Win the contract

StepWhereIn 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 DealYes
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 ProposalYes
Send it; the client accepts in the portal, or you set the status to Accepted.Proposal › Send ProposalYes
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 › ContractBy hand
Don't use Convert Invoice on the proposal for progress billing. It copies 100% of the proposal lines into one invoice and also moves product stock. Create each IPC as a new invoice (step 5).

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 Substructure4,800,000
02 Superstructure7,200,000
03 Masonry & finishes6,000,000
04 MEP4,800,000
05 External works1,200,000
Total24,000,000
Budget lineOriginal budget
MAT-STEEL — Rebar3,600,000
MAT-CONC — Ready-mix concrete2,400,000
MAT-FIN — Finishing materials3,000,000
LAB-SITE — Site labour and staff3,000,000
SUB-ELEC — Electrical subcontract2,000,000
SUB-PLUMB — Plumbing subcontract1,500,000
SUB-ALU — Aluminium subcontract1,000,000
EQP-HIRE — Plant hire1,200,000
OVH-SITE — Site overheads1,700,000
CONT-01 — Contingency1,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:

  1. 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.
  2. Revenue entries count as income in Income Summary and Profit & Loss. Leave the advance category out when you read project revenue.
  3. 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:

  1. Create a Service product "Electrical works — PRJ-014" (Products System › Product & Services, type Service).
  2. Project › Procurement › Request materials: the service item, Quantity 100 (%), Est. Unit Price 20,000, Budget Line SUB-ELEC. Total 2,000,000.
  3. 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.)
  4. 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.
  5. 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:

LineActual to date
MAT-STEEL — Rebar1,450,000
MAT-CONC — Ready-mix concrete1,100,000
SUB-ELEC — Electrical subcontract300,000
SUB-PLUMB — Plumbing subcontract150,000
EQP-HIRE — Plant hire260,000
OVH-SITE — Site overheads340,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:

  1. 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.
  2. Category = PRJ-014 Contract revenue; Ref Number = "PRJ-014 / IPC-03". The invoice is for the gross 3,000,000.
  3. Don't put retention or advance recovery in the line Discount: the discount lowers the invoice total and the tax.
  4. Send Invoice › Send.

6. Collect and close the month

  1. 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.)
  2. 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.
  3. 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.
  4. 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.
  5. 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:

ItemAmountWhere you see it
Billed to date (gross)6,000,000Income Summary, category PRJ-014 Contract revenue
Advance received2,400,000Revenue list, category PRJ-014 Client advance
Advance recovered (IPC-01 to 03)600,000Credit notes on the three invoices
Advance still to recover1,800,000By hand: 2,400,000 − 600,000
Retention held by the client300,000 (60,000 + 90,000 + 150,000)Invoice Summary › Customer, Status = Partialy Paid
Cash received in total7,500,0002,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

FigureAmountSource
Value of work billed to date6,000,000Income Summary (project category)
Actual cost to date (AC)5,300,000Budget Control › Actual, or Earned Value › AC
Margin to date700,000 (11.7%)By hand
Earned value (EV)5,100,000Earned Value
CPI = EV ÷ AC0.96Earned Value
EAC = BAC ÷ CPI21,200,000Earned Value
TCPI = (BAC − EV) ÷ (BAC − AC)1.01Earned Value
Forecast margin = contract value − EAC2,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:

HalfWhereVO-01: extra canopy, sell 1,200,000, cost 1,000,000, 20 days
CostProject › 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 valueCRM System › Contract › EditContract Value 24,000,000 → 25,200,000; record the client's approval letter in Comments or Notes.
BOQProject tasksAdd tasks under a "Variations" milestone, Task Budget 1,200,000, so task budgets again add up to the contract value.
ScheduleEarned Value › BaselinesCreate and approve a new baseline. The 20 days do not move the schedule by themselves.
BillingNext IPCBill 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

WhoHow they are costedWhere you set it
Engineers and staff with Has TimeSheetEach 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 timesheetsTheir 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 neitherEnter 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 contractorsEvery 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-costsNot 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

CaseWhat 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 plantThere 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 repairsProject 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:

  1. Close payroll (Generate Payslip) and attach site staff to projects in Project Payslips.
  2. Make sure every supplier bill, subcontractor certificate (goods receipt) and site expense of the month is entered.
  3. Issue each project's IPC, record client payments, credit notes and the month's journal entries; record the IPC in Projects Income.
  4. After the 1st-of-month 03:00 run has posted labour and overhead, review each project:
WhereWhat to look at
Project › Budget ControlActual 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 ValueEV ÷ 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 dashboardAll 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 SummaryOverdue 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 SummaryRevenue per project category, for the margin.
Project System › Projects Expenses › Export year Total ExPer project: Projects Income next to direct, overhead and total cost (no bills or receipts, no profit column).
Three different "spent" figures. The Projects list and KPI Scorecard count only timesheet labour and project expenses against the project Budget; the project's Expense card counts expenses only; Budget Control and Earned Value use the full cost ledger. A contractor buying through orders and bills should decide on Budget Control and Earned Value.

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

NeedTodayWorkaround
BOQ with unit, quantity, rate and measured quantitiesMissingMilestones 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 projectMissingCreate the project and contract by hand; re-key the BOQ.
Won/Lost status and win rateMissingAwarded and Lost deal stages; CRM reports by stage.
Bid bond, deadline, tender numberMissingDeal 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 fieldsMissingWrite them in the contract description; attach the bonds.
Contract value on the projectMissingCRM contract linked to the project; task budgets at contract value.
Staff manage contract attachmentsPartial: company account and client onlyThe owner uploads, or use the project's or deal's files.
One client record across CRM, projects and accountingPartialClient user plus Customer with the same name, linked through Client User Connection.

Client billing and receivables

NeedTodayWorkaround
Invoice linked to a projectMissingOne 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 itemMissingDuplicate last month's invoice and enter this period only; keep the IPC sheet outside and attach it to the payment receipt.
Milestone billingMissingA normal invoice when the milestone is reached, named in Ref Number.
RetentionMissingLeave it as the invoice's open due; release with Add Payment; Dr Retention receivable by journal entry.
Advance payment and recoveryMissingRevenue entry in an advance category; credit note per IPC for the recovery; journal entries for the books.
Price adjustment / escalation claimsMissingBill them as extra IPC lines with the claim number, as for a VO.
Other client deductions (social insurance, stamp duty)MissingHandle them like WHT: a credit note with a label, plus a journal entry.
Withholding tax deducted by the clientMissingCredit note marked WHT, or leave it open; journal entry to WHT receivable.
Receivables aging and customer statementMissingCustomer page (Balance, Overdue), invoice list (red due dates), Invoice Summary exported to a spreadsheet.
Automatic posting to the general ledgerMissingMonthly summary journal entries for revenue, VAT, receivables, retention and advances.
Credit notes in the customer balance and reportsPartial: they lower the invoice due but move the customer Balance the wrong way, and Income Summary ignores themTrust invoice dues over the customer Balance; post revenue reversals by journal entry.

Cost and margin control

NeedTodayWorkaround
Project margin or profitability reportMissingIncome Summary by project category against Budget Control actual, as in the margin check.
Cash flow per projectMissingProjects Income and client payments for cash in; bill payments and the Projects Expenses export for cash out.
Variation that changes contract value and cost togetherPartial: cost onlyChange order for cost, edit the contract value, extra tasks, new baseline.
Labour against the LAB budget lineMissing: always in UnallocatedCompare the LAB line with the Unallocated row or with Projects Expenses.
Labour cost during the monthPartial: posted on the 1st of the next monthRead Projects Expenses mid-month; expect CPI to look better than reality until the monthly run.
Cost report by category (materials, labour, subcontract, equipment)MissingOne budget line per category code, Totals by Cost Code.
Project Report detail page for project managers and site engineersPartial: works correctly only for the company accountUse the project page, Budget Control and Earned Value.
Site progress photos on the webPartial: in the mobile app onlyReview them in the app.
Earned value and budgets on the mobile appMissingUse the web on a phone, and the SPI/CPI push alerts (sent when an index worsens).
Milestones-on-time KPIMissing: can be set, never calculatedTrack milestone due dates by hand.

Labour and equipment

NeedTodayWorkaround
Add an expense from the project's Expense pageBroken: the save failsProject System › OverHead › Create with the project selected; set the budget line by editing it from the project.
Keep the task when an expense is editedPartial: editing clears itRe-create the expense instead of editing it if the task matters.
Labour cost with employer on-costs, or standard daily ratesMissing: net pay onlyMonthly LAB-INS project expense.
Casual labour without email or loginPartialBuy labour as a service, or a weekly wage-sheet expense.
Attendance geofence per project sitePartial: per branchOne branch per site; change the employee's branch when they move.
Spreading head-office salaries when site staff have no timesheetsPartial: Generate Projects Costs needs timesheet costEnter head-office salaries as overhead expense.
Equipment register, hours, internal rates, depreciationMissingMonthly EQP-OWN expense per machine; depreciation by journal entry.
Subcontractor certificates with retention and advance recoveryMissingService purchase order, monthly goods receipt, bill from PO, part payment for retention (see real-estate guide).
Site expenses from the mobile appMissingEnter 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

TaskPath
Tender pipeline and stagesCRM System › CRM System Setup
Log a tender / bidCRM System › Leads › + ; lead › Convert to Deal
Priced BOQ for the clientAccounting System › Proposal › Create Proposal
Contract registerCRM System › Contract › +
Project per contractProject System › Projects › + Create Project
BOQ sections and itemsProject › Milestones card › + ; Tasks › + Create Task
Cost codes and budget linesProject System › Cost Codes ; Project › Budget Control › +
BaselineProject › Earned Value › Baselines › Create baseline
Advance paymentAccounting System › Income › Revenue › +
Monthly IPCAccounting System › Income › Invoice › Duplicate
Client payment / advance recoveryInvoice › Add Payment ; Accounting System › Income › Credit Note › +
Project revenue logProject System › Projects Income › +
Site expenseProject System › OverHead › Create (with Projects)
Site staff to projectsProject System › Project Payslips › Create
TimesheetsProject System › Timesheet › Add Timesheet
Variation (cost side)Project › Budget Control › Change Orders › +
Period cost and income exportProject System › Projects Expenses › Export year Total Ex
Month-end reviewBudget Control, Earned Value, KPI Scorecard, Invoice Summary, Income Summary
Still need help?

Write to us and we will get back to you.

Contact support