Semantik ERPDocs

Project Controls

Project Controls keeps every project's money and schedule in one place: a budget split into budget lines, purchases that go through requests and approvals, goods received on site, change orders, an approved baseline, and earned value figures (SPI, CPI, EAC) that tell you early when a project is slipping.

Budget lines

Per cost code, phase and task

Purchase requests

Budget check and approvals

Goods receipts

Receive what arrives on site

Change orders

Approved, then applied to the budget

Baselines

The plan you measure against

Earned value

SPI, CPI, EAC, VAC, TCPI

Where to find it

ScreenWhere
Cost CodesProject System › Cost Codes
Budget Control, Budget Revisions, Change OrdersOpen a project › Budget Control button (the three screens share a tab bar). The button and the Budget Control / Budget Revisions tabs need view project budget or manage project budget. Users with only change-order permissions open change orders by link, or from the Approval Inbox if they hold an approve permission.
Earned Value and BaselinesOpen a project › Earned Value button; Baselines is linked from there
KPI Scorecard, KPI SettingsProject System › KPI Scorecard / KPI Settings
Purchase Requests, Goods Receipts, Purchase OrdersProject System › Procurement › Purchase Requests / Goods Receipts / Purchase Orders
A project's purchasingOpen a project › Procurement button — see Project procurement page
Approval Inbox, Approval RulesApprovals › Approval Inbox / Approval Rules. A red number next to Approvals shows how many approvals are waiting for you.
Stock postingSettings › System Settings › Company Settings — see Stock posting

The Procurement group appears only when your plan has both the Projects and the POS modules; POS System › Purchase stays where it was. Budgets, baselines and earned value need the Projects module. The Approvals menu appears when your plan has either module. Each menu item shows only if your role has the matching permission.

Set up in this order

  1. Create your cost codes.
  2. Choose the stock posting mode.
  3. Set up approval rules (optional — without rules, requests are approved at once).
  4. For each project: add task budgets and weights, then budget lines.
  5. Create and approve a baseline.
  6. Review the KPI limits once for the company.

Cost codes

A cost code is a type of cost you want to track across projects, for example MAT-01 Concrete. Open Project System › Cost Codes and click + (Create Cost Code).

FieldMeaning
Code, NameThe code must be unique in your company.
CategoryMaterials, Labour, Subcontract, Equipment, Overheads or Other.
Parent CodeOptional, to build a tree (a code cannot be its own parent).
Expense Category, AccountOptional links to an expense category and a chart-of-accounts account.
ActiveInactive codes are hidden from new forms.
  • Create from expense categories makes one code (EXP-…) for each expense category that has none yet. You can run it again safely.
  • A code that has child codes or budget lines can't be deleted — deactivate it instead.

Project budget and budget lines

Open a project and click Budget Control. Click + (Create Budget Line) for each part of the budget.

FieldMeaning
Cost CodeRequired. Create cost codes first.
Phase / Milestone, TaskOptional, to see totals per phase and to link costs to a task.
Original BudgetThe approved amount. The current (revised) budget starts equal to it.
Warn at (%)Default 90. Purchase requests that take the line above this show a warning.
Block at (%)Default 100. Above this, a purchase request needs a budget override approval.

Reading the Budget Control report

ColumnMeaning
OriginalThe budget you entered.
RevisedOriginal plus all revisions and applied change orders. This is the budget used for checks.
CommittedOpen purchase orders not yet turned into actual cost.
ActualCosts already incurred (see where actual cost comes from).
AvailableRevised − Committed − Actual.
Used %(Committed + Actual) ÷ Revised.
StatusOK, Warning (at or above Warn %) or Over budget (above Block %).

Below the lines you see Unallocated costs (no budget line) — project costs posted without a budget line — and Totals by Phase and Totals by Cost Code. Amounts are net of tax and in your base currency.

Changing a line's original budget moves its revised budget by the same amount. A line that already has revisions or costs can't be deleted.

Where actual cost comes from

  • Purchase orders linked to a project post a commitment per line (price × quantity − discount).
  • That commitment turns into actual cost when the supplier bill is saved, or when goods are received — which one depends on the stock posting mode. The same purchase line never counts twice.
  • In the Only when goods are received on site mode the actual is received quantity × order price; a different price on the supplier bill never reaches Budget Control or Earned Value.
  • Project expenses post actual cost when saved from Project System › OverHead with one or more Projects chosen, and when an expense is edited. That create form has an optional Cost Code but no Budget Line (no project is known yet), so to charge a budget line, edit the expense afterwards. Expenses from Generate Projects Costs and from a payment's Add as Project Expense reach the ledger only through the monthly update below.
  • Bills without a purchase order count as actual cost of the project chosen on the bill.
Timesheet labour, site-staff salaries and the overhead share are not posted live. They reach the budget report and earned value through a periodic ledger update: labour cost is refreshed automatically on the 1st of each month at 03:00 (expenses created automatically by the monthly overhead calculation or by import are picked up the same way). These rows have no budget line or cost code, so they always appear under Unallocated costs (no budget line) and never use up a Labour budget line; the overhead share is also counted in earned value's actual cost (AC). If these figures look missing, contact support.

Budget revisions

From Budget Control, click Revise Budget:

  • Increase or Decrease one line, or Transfer an amount from one line to another.
  • A Reason is required. The revision applies at once and is recorded with you as approver.
  • A transfer or decrease only stops the source line going below zero. It ignores what is committed or spent, so it can leave the line Over budget. Check Available on Budget Control first.

Budget Revisions lists every change with its type, amount, lines, reason and who made it.

Purchase requests

A purchase request is how site staff ask for materials or services before anything is ordered. Open Project System › Procurement › Purchase Requests and click + (Create Purchase Request), or use Request materials on the project procurement page.

  1. Choose the Project, and optionally the Project Task and Needed By date. The project is already filled in when you came from Request materials, or when you are a member of exactly one project in progress.
  2. Add items: a product or a description, Quantity, Est. Unit Price and the Budget Line it should be charged to.
  3. The Budget Check panel updates as you type: for each budget line it shows the budget, used, requested and Used after / Available after. Under each item you also see what is left on its budget line after this request, for example EGP 12,000.00 left on MAT-01 Concrete — green when within budget, amber near the warning limit, red when blocked — or EGP 3,000.00 over budget on MAT-01 Concrete.
  4. Click Save Draft to keep working on it, or Save & Submit to send it for approval.

What the budget check does

ResultWhat happens on submit
Within budgetThe request goes to the normal purchase request approval.
Warning: budget almost usedSame as above; the approver sees the warning.
Budget exceeded: needs budget override approvalA second approval flow, Budget Override, starts next to the normal one. If no budget override rule covers the request total (not the overrun), the request can't be submitted.

Items without a budget line are shown as Amount without budget line and never block. The result is saved every time the request is saved (also Save Draft) and again on submit; Checked at shows the last one.

Request status

DraftPendingApprovedOrdered
  • Without any matching approval rule the request is Approved as soon as it is submitted.
  • Any rejection makes it Rejected; you can edit it and submit again.
  • Only draft or rejected requests can be edited; only drafts can be deleted. Cancel Request works until the request is ordered.
  • People with create purchase request see and edit only their own requests; manage purchase request sees all.

Approvals

Approval rules

Open Approvals › Approval Rules. Rules are grouped by module: Purchase Request, Purchase Order, Budget Override and Change Order. Click Add Step to add one.

FieldMeaning
Minimum / Maximum AmountThe amount band the rule applies to. Leave the maximum empty for no upper limit.
StepSteps are approved in order: 1, then 2, …
Approver Role / Approver UserWho approves this step: anyone with the role, or a named user (left empty, the list shows Any role / Any user). The approver also needs the module's approve permission, and the person who raised the document is excluded. One rule counts per step: the one with the higher minimum.
Supplier Quotes RequiredPurchase requests only: how many quotes are needed before a purchase order can be created.

For each document, the rules whose band contains its amount are applied — one approval per step. No matching rule means no approval is needed. Approvers also need the module's approve permission (approve purchase request, approve purchase order, approve budget override, approve change order); the company account can always approve. The person who raised a document can't approve it; only the company account can approve its own.

Purchase Order rules apply to purchase orders created directly: the order can't be sent, paid or billed until approved, and once the order is sent, any increase of its total is refused when a Purchase Order rule covers the new total (even within the same band, and also on orders created from a quote); with no covering rule the increase is allowed. A draft order created from a request is never re-approved. To change a refused amount, cancel the order and create a new one; an order with receipts or bills can't be cancelled, so close it instead. See POS › Purchase order approval.

Approval inbox

Approvals › Approval Inbox (with a red count of what is waiting for you) shows Waiting for my approval — only items whose current step you can act on — and My recent decisions. Filter by module at the top.

  • Approve with an optional comment, or Reject with a comment (required).
  • Budget override rows link to the project's Budget Control report; purchase orders and change orders link to the document.
  • The requester is notified when the request is approved or rejected, and the next approver when it is their turn.
  • A reminder is sent once a day when a step has waited more than 24 hours.

You can also approve from the mobile app.

Supplier quotes and the purchase order

Once a request is Approved, open it and click Supplier Quotes.

  1. Add Quote for each supplier: Vendor, Quoted Total, Delivery (days), Payment Terms and an optional Quote File.
  2. Compare Quotes shows them side by side with the difference against the estimate; the Lowest and Fastest are marked.
  3. When you have the number of quotes your rules require, click Select on the chosen quote. In the Select Quote & Create Purchase Order window choose the purchase date, category and warehouse, and click Create Purchase Order.

The purchase order takes its lines from the request; the quoted total is spread over the lines in proportion to their estimated amounts. You can edit the purchase order afterwards. The request becomes Ordered, and the order's amount is committed against the budget lines.

You can also create a purchase order directly (POS System › Purchase, or Project System › Procurement › Purchase Orders): the form now has Project and Project Task at the top and Cost Code / Budget Line on each line. It may need approval first. To stop an order, use Cancel Purchase or Close Purchase, which release its commitment — see POS › Cancel or close a purchase order.

Goods receipt

  1. Open the purchase order and click Receive Goods.
  2. Choose the Receipt Date. The Warehouse appears, and is required, only when your plan has warehouses; it defaults to the order's warehouse and moves stock only in the Only when goods are received on site mode.
  3. For each line enter Received Now and, if needed, Rejected. You can't receive more than is still open on the order; decimals are allowed.
  4. Click Save Receipt.

The purchase order's Receiving & Billing panel shows ordered, received, billed and open quantities per line, its receipts and its bills. Project System › Procurement › Goods Receipts lists every receipt (GRN). Deleting a receipt reverses its received quantities and the stock it posted, removes its actual cost, re-opens the commitment and re-checks the order's bills. Stock can go negative, because material already used is not checked. Receipts of a cancelled or closed order can't be deleted.

Stock posting: two modes

In Settings › System Settings › Company Settings, the Stock posting field decides when purchased goods enter stock:

ModeStock is addedActual project cost comes fromGoods receipt
When purchase orders and bills are saved (current) — the defaultThe full ordered quantity when the purchase order is saved, and bill lines not linked to an order line (even on a bill from an order) — as before. Close Purchase doesn't take stock back; only Cancel or Delete doThe supplier billRecords received quantities only
Only when goods are received on siteOnly by a goods receiptThe goods receiptAdds stock to the chosen warehouse

In both modes, a bill made from a purchase order (Create Bill from PO) adds no stock for its linked lines, because the order or its receipt already added it. Bill lines without a purchase order still add stock as before. In the second mode, saving a purchase order adds no stock either.

Each purchase order remembers the mode it was created under. Switching the mode affects new purchase orders only; existing orders, their receipts and their bills keep following their original mode, so editing them after a switch still posts and reverses stock correctly.

Bills and three-way match

On a purchase order, Create Bill from PO opens a bill already filled with the open quantities, prices, cost codes and budget lines. The bill keeps its link to the order, and the bill page shows a Three-Way Match panel comparing order, receipt and bill:

  • Quantity: billed must not exceed the received quantity (receipt mode) or the ordered quantity (default mode).
  • Price: the bill's unit price must be within 2% of the purchase order price.

The bill is marked Matched or Exception; bills with no linked order lines are Not Matched. The status is recalculated whenever another bill or receipt of the same order changes. A bill marked Exception can't be paid, except by the company account, and while any bill of the order is Exception other users can't add a payment on the purchase order either. Paying a bill needs create payment bill, which no ready-made role has. See also Accounting › Bills.

Project procurement page

Open a project and click Procurement to see all purchasing for that project on one page.

CardShows
Open requestsDraft, pending or approved requests not ordered yet
Committed on ordersThe gross amount of the project's purchase orders, cancelled, closed and fully received ones included. The open amount is in the card's Open: hint; Budget Control's Committed column is the open commitment.
ReceivedReceived quantity × order price
BilledBills before tax
Budget usedOpen commitment + actual cost as a % of the budget lines' revised total (or of the project budget when there are no lines)

Below the cards are the project's Purchase Requests (with approval status), Purchase Orders (with the % received and Receive Goods / Create Bill from PO), Goods Receipts and Bills (with their three-way match status). Request materials opens a new purchase request with the project filled in. The button shows when your plan has the POS module and you have one of the purchase request, goods receipt or purchase permissions.

Change orders

From Budget Control, open the Change Orders tab and click + (Create Change Order): Title, Description, Cost Impact (negative for a reduction) and Days Impact.

  1. Submit for Approval. Change order rules use the absolute cost impact; without a matching rule it is approved at once.
  2. The approver decides in the Approval Inbox or on the change order page (Your Approval).
  3. When approved, click Apply to Budget and split the cost impact over budget lines. The amounts must add up to the cost impact; each one is recorded as a budget revision. A change order can be applied once.

Only draft or rejected change orders can be edited or deleted.

The schedule baseline is not changed automatically. If the approved days impact should count, create and approve a new baseline.

Baselines

A baseline is a frozen copy of the plan — task dates, task budgets and weights — that progress and earned value are measured against. From the project's Earned Value page, open Baselines.

  1. Click Create baseline and add a note (for example Contract schedule). It is saved as the next version, as a draft.
  2. Check it with Compare with current: planned vs current start, end and budget per task, and the end variance in days.
  3. Approve it. It becomes the current baseline.
  • Budget at completion (BAC) is the sum of the project's budget lines; without budget lines, the sum of task budgets.
  • To go back to an older approved version, use Set as current. Only drafts can be deleted.
  • Moving tasks in the Gantt chart changes the current dates, never the baseline.

Task budgets, weights and progress

The task form has three new fields: WBS Code, Task Budget and Weight.

  • Progress is a percentage per task, set with the slider on the task, from the mobile app, or by marking the task complete (which sets 100%). Each update is logged.
  • Project progress is a weighted average of task progress: by weight when tasks have weights, otherwise by task budget, otherwise every task counts the same.
  • The Gantt chart and the projects list show this same progress.
Un-ticking a completed task leaves its progress at 100% — move the slider to correct it.

Earned value (EVM)

Open a project and click Earned Value. The page shows today's figures, an S-curve (weekly snapshots plus today) and a table By phase (one row per milestone).

Each card has a plain-language sentence under the number, and an ⓘ icon whose tooltip gives the definition and formula:

CardExample sentence
SPIBehind schedule by 8% / Ahead of schedule by 5% / On schedule
CPIOver budget: each EGP buys 80 piastres of work (in other currencies: every 100 spent buys 80 worth of work) / On budget
TCPIRemaining work must be 16% more efficient to finish on budget
EAC, VACExpected to finish at EGP 1,250,000.00, EGP 250,000.00 over budget

Without enough data the sentence reads Not enough data yet — add task budgets or save a snapshot. The same SPI and CPI sentences appear on the KPI Scorecard and in the health tooltip on the projects list.

The three base values

ValueMeaning
BAC — Budget at completionThe total planned budget (from the current baseline).
PV — Planned valueThe budget of the work that should be done by today: each task's budget spread evenly between its planned start and end.
EV — Earned valueThe budget of the work actually done: Σ task budget × task progress %.
AC — Actual costActual cost posted to the project up to today.

Indicators and formulas

IndicatorFormulaHow to read it
SPI — Schedule performanceEV ÷ PV1 = on schedule; below 1 = behind.
CPI — Cost performanceEV ÷ AC1 = on budget; below 1 = spending more than the work earned.
EAC — Estimate at completionBAC ÷ CPIExpected final cost if cost performance stays the same.
VAC — Variance at completionBAC − EACNegative = expected overrun.
TCPI — To-complete index(BAC − EV) ÷ (BAC − AC)The CPI needed on the remaining work to finish on budget; above 1 = harder.
SV — Schedule varianceEV − PVIn money; negative = behind.
CV — Cost varianceEV − ACIn money; negative = over cost.
Example: BAC 1,000,000 · PV 400,000 · EV 360,000 · AC 450,000
SPI = 360,000 ÷ 400,000 = 0.90   (10% behind schedule)
CPI = 360,000 ÷ 450,000 = 0.80   (paying 1.25 for each 1 of work)
EAC = 1,000,000 ÷ 0.80 = 1,250,000
VAC = 1,000,000 − 1,250,000 = −250,000
TCPI = (1,000,000 − 360,000) ÷ (1,000,000 − 450,000) = 1.16

Each card is coloured On track, Watch or Act now using the KPI limits. EAC and VAC follow CPI's status.

Good to know

  • n/a appears when a ratio can't be calculated: SPI before any work is planned (PV = 0), CPI before any actual cost (AC = 0), TCPI when actual cost has reached BAC. Without a CPI, EAC is AC + (BAC − EV).
  • Without an approved baseline, planned value uses the current task dates and budgets, and the page says so.
  • If tasks have no budget, earned value stays at zero — add task budgets (or budget lines).
  • Actual cost per phase counts only costs posted to tasks of that phase.
  • A snapshot is saved automatically every Sunday morning for each project that is In progress. Save snapshot saves today's figures to the trend at any time.
  • The projects list, the project health and the KPI Scorecard read SPI and CPI from the latest snapshot, so they show n/a until the first weekly snapshot or Save snapshot.

KPI settings

Project System › KPI Settings sets, for each KPI, a Target, a Watch from limit and an Act now from limit.

  • Higher is better: On track from the Watch limit up, Watch between the two limits, Act now below the Act now limit.
  • Lower is better: On track up to the Watch limit, Watch up to the Act now limit, Act now above it.
  • The Act now limit must be beyond the Watch limit. Reset to defaults brings back the values below.
KPIUnitDirectionTargetWatch fromAct now from
SPIHigher10.950.90
CPIHigher10.950.90
Budget used vs work donepointsLower5510
Purchases within budget%Higher1009895
Request to PO timedaysLower336
Approval turnaroundhoursLower242448
Supplier on-time delivery%Higher909080
Change orders vs budget% of BACLower5510
Milestones on time%Higher909075
Time elapsed vs progress (project health)pointsLower01530
Budget used (project health)%Lower9090100

SPI, CPI, time elapsed vs progress and budget used also decide the project health on the projects list: Act now makes a project Off track, Watch makes it At risk. Milestones on time can be set but is not calculated yet.

KPI scorecard

Project System › KPI Scorecard gives a company-wide view:

  • Active projects — progress, budget used, budget used vs work done, SPI, CPI (with the same plain-language sentences as Earned Value) and health, with links to Earned Value and Budget Control.
  • Procurement KPIs for the last 3, 6 or 12 months: purchases within budget, request to PO time, approval turnaround, supplier on-time delivery (receipt date vs the request's Needed By) and change orders vs budget. Each card shows the value, the target and its status.

On the project dashboard

The project dashboard has two Project Controls cards:

  • Waiting for your approval — the 5 oldest items waiting for you (request, type, amount, how long), with Open inbox.
  • Projects needing attention — active projects with SPI or CPI in Watch or Act now, or that are Off track, with the reason; each links to the project's Earned Value page.

Alerts and notifications

NotificationSent toWhen
Approval requiredThe approvers of the current stepWhen a purchase request, budget override, purchase order or change order reaches their step. Purchase order notifications open the Approval Inbox
Approval reminderThe same approversDaily, when a step has waited over 24 hours
Request approved / rejectedThe person who submitted it (on a purchase order, the last person who edited and resubmitted it)When the flow ends
KPI alert: watch / act nowProject members who can manage the project; the company account too for Act nowWeekly snapshot, when a project's SPI or CPI gets worse and enters Watch or Act now

Notifications arrive as push notifications in the mobile app; tapping an approval request or reminder opens the app's Approvals screen.

Permissions

PermissionAllows
manage cost codesCost Codes screen
view project budget / manage project budgetSee Budget Control / also edit budget lines and revisions
create purchase request / manage purchase requestRaise own requests / see and edit all requests
approve purchase request, approve purchase order, approve budget override, approve change orderAct on approval steps of that module
manage approval rulesApproval Rules screen
manage supplier quotesAdd quotes and create the purchase order
manage goods receiptReceive goods, Goods Receipts list
manage change ordersCreate and submit change orders (applying one also needs manage project budget)
manage project baselineCreate, approve and delete baselines; Save snapshot
view project controlsEarned Value, Baselines (view) and KPI Scorecard
report task progressReport progress from the mobile app
manage kpi settingsKPI Settings screen

The company role gets all of them. Roles that already had manage project also got view project budget, view project controls, report task progress and create purchase request; roles with manage purchase got the purchase request, supplier quote and goods receipt permissions. The migration gives approve permissions only to the company role; the ready-made roles from Create Project Controls roles already include them (see Ready-made roles). Add them to other roles in Roles & Permissions.

On the Create / Edit Role screen these permissions are grouped by service. Project tab: Project Controls, Cost Codes, Project Budget, Change Orders, Project Baseline, Progress Updates, Approval Rules. POS tab: Purchase Request, Supplier Quotes, Goods Receipt, purchase order approval.

Ready-made Project Controls roles

On User Management › Role, the company account can click Create Project Controls roles (shown when the plan has the Projects module). It adds four roles; a role with the same name that already exists is not changed. Only permissions the company account has and that its plan includes are given.

RolePermissions
Site EngineerBasic project access* + create purchase request, report task progress, view project controls, manage goods receipt
Procurement Officermanage / create / approve purchase request, manage supplier quotes, manage goods receipt, manage / create / edit / show / send purchase, show pos dashboard
Project ManagerBasic project access* + create / edit / share project, create / delete project task, create / edit milestone, control timesheet, project expenses, view activity, view / manage project budget, manage change orders, manage project baseline, view project controls, approve purchase request, approve purchase order, report task progress, create purchase request
Financeshow project dashboard, manage project, view project, project expenses, approve purchase request, approve purchase order, approve budget override, approve change order, view project budget, view project controls, manage bill, show bill

* Basic project access: show project dashboard, manage project, view project, manage / view / edit project task, view milestone, view gantt chart, manage timesheet, create timesheet. Edit the roles afterwards like any other role.

Quick reference

TaskPath
Add a cost codeProject System › Cost Codes › +
Add a budget lineProject › Budget Control › +
Move budget between linesProject › Budget Control › Revise Budget › Transfer
Raise a purchase requestProject System › Procurement › Purchase Requests › +, or Project › Procurement › Request materials
All purchasing of one projectProject › Procurement
Approve or rejectApprovals › Approval Inbox
Compare quotes and orderPurchase request › Supplier Quotes
Receive goodsPurchase order › Receive Goods
Bill an orderPurchase order › Create Bill from PO
Change orderProject › Budget Control › Change Orders › +
BaselineProject › Earned Value › Baselines › Create baseline
SPI / CPI of a projectProject › Earned Value
Company KPIsProject System › KPI Scorecard
Add the ready-made rolesUser Management › Role › Create Project Controls roles
Still need help?

Write to us and we will get back to you.

Contact support