Procurement for Real-Estate Developers
A real-estate developer buys for several projects, buildings and phases at the same time: steel, cement, ready-mix concrete, finishing materials and subcontract works, ordered by head office and received on site. This guide shows how to set Semantik ERP up for that, follows one rebar order for Tower B through every step, and is open about what the system does not do yet. The step-by-step screens are in Procurement and Project Controls.
Budget lines by cost code and phase
Checked against the budget as you type
Steps by amount band, in EGP
Minimum number of supplier quotes
Partial deliveries and rejected material
Three-way match before payment
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). Map your organisation onto them like this:
| In your company | Ready-made role | What they do in the system | Adjust |
|---|---|---|---|
| Site engineer | Site Engineer | Raises material requests on the web or the mobile app, receives deliveries, reports task progress | — |
| Site storekeeper | Site Engineer (or a custom role with manage goods receipt) | Records every delivery as a goods receipt (GRN), including rejected quantities | manage goods receipt also lets the holder delete receipts — give it only to trusted store staff |
| Head-office procurement | Procurement Officer | Manages requests, collects and compares supplier quotes, creates and sends purchase orders | Remove approve purchase request so the person who awards a quote is not also an approver. Also remove manage goods receipt, so the buyer who sends an order can't record or delete receipts on it; only site stores receive |
| Project manager | Project Manager | Approves requests and direct purchase orders, manages budget lines, change orders and baselines | See the note on budget revisions |
| Cost controller / technical office | Custom role | Checks requested quantities against the BOQ and shop drawings, keeps budget lines and transfers, applies approved change orders | Give view project budget, manage project budget (taken away from the Project Manager) and manage change orders; optionally approve purchase request, as an early step that checks quantities |
| Finance | Finance | Approves requests, purchase orders, budget overrides and change orders; views budgets | Add create bill, edit bill, send bill, create payment bill, create debit note, create payment purchase, show purchase and manage purchase — the ready-made role can only view bills |
| General manager / owner | Named Approver User on the top approval bands; the company account | Signs off large amounts; the company account is the only one that can pay a bill marked Exception | A named user also needs the module's approve permission. Give their role approve purchase request, approve budget override and approve change order (and approve purchase order if they sign purchase orders). Not needed if they sign in as the company account |
Nobody can approve a request or purchase order they raised themselves, even with the permission; only the company account can act on its own requests. Full permission lists: Project Controls › Ready-made roles.
One-time setup
Projects, phases and buildings
There is no separate "building" field. Use the structure the system has:
- One project per phase (or per separately budgeted development). Every purchase request belongs to exactly one project, and each project has its own Procurement page and Budget Control.
- One milestone per building inside the project — Tower A, Tower B, Infrastructure. Budget lines can be placed under a Phase / Milestone (and a Task), and Budget Control then shows Totals by Phase. See Projects › Milestones.
- Add the team as project members. Users other than the company account see and open only the projects they are members of. Open the project › Members › + and add the site engineers, storekeepers, project manager and Finance users, otherwise the project's Procurement and Budget Control pages used in this guide are out of their reach.
Cost codes
Cost codes are company-wide and shared by all projects. Open Project System › Cost Codes and click +. Each code has a Category (Materials, Labour, Subcontract, Equipment, Overheads, Other) and an optional Parent Code, Expense Category and Account. A typical developer tree:
| Code | Name | Category | Parent |
|---|---|---|---|
| MAT | Materials | Materials | — |
| MAT-STEEL | Reinforcement steel | Materials | MAT |
| MAT-CEM | Cement | Materials | MAT |
| MAT-CONC | Ready-mix concrete | Materials | MAT |
| MAT-FIN | Finishing materials | Materials | MAT |
| LAB-SITE | Site labour | Labour | — |
| SUB-ELEC | Electrical subcontract | Subcontract | — |
| SUB-PLUMB | Plumbing subcontract | Subcontract | — |
| EQP-CRANE | Tower crane hire | Equipment | — |
| CONT-01 | Contingency | Other | — |
Details: Project Controls › Cost codes.
Budget lines
Open the project › Budget Control › + and add one line per cost code and building: Cost Code, Phase / Milestone, Task, Description, Original Budget, Warn at (%) and Block at (%).
- Set Warn at (%) to about 70–80 rather than the default 90. Approved requests do not reserve budget until they become purchase orders, so an early warning helps (see limits).
- Add a contingency line (CONT-01) per project. It is the source for transfers when prices rise.
Details: Project Controls › Budget lines.
Site stores as warehouses
Create a warehouse for each site store in Products System › Warehouse, and use Parent to group them, for example "Palm Residence — Central yard" with "Palm Residence — Tower B store" under it. A warehouse cannot be linked to a project on screen, so use the project name in the warehouse name. The Warehouse field on a goods receipt appears only when your plan includes warehouses. See Warehouse › Hierarchical warehouses.
Stock posting: receive on site
In Settings › System Settings › Company Settings, set Stock posting to Only when goods are received on site. For a developer this is the right choice:
- Stock enters the site store only when the storekeeper records a goods receipt. In the other mode (When purchase orders and bills are saved (current)), the full ordered quantity enters stock as soon as the order is saved, before anything arrives, and rejected material is counted as stock.
- Project actual cost is booked on the receipt date at the order price, so Budget Control and Earned Value follow what is physically on site.
- Supplier bills can't be matched for more than was received.
Approval matrix
Open Approvals › Approval Rules and click Add Step. A rule applies when the amount is between its Minimum Amount and Maximum Amount (empty = no limit); steps are approved in order, and a document with no matching rule is approved automatically. An example for a developer, in EGP:
| Module | Step | Minimum | Maximum | Approver | Quotes required |
|---|---|---|---|---|---|
| Purchase Request | 1 | 0 | — | Role: Project Manager | 1 |
| Purchase Request | 2 | 250,000 | — | Role: Finance | 3 |
| Purchase Request | 3 | 1,000,000 | — | User: the general manager | 3 |
| Budget Override | 1 | 0 | — | Role: Finance | — |
| Budget Override | 2 | 1,000,000 | — | User: the general manager | — |
| Purchase Order | 1 | 0 | — | Role: Project Manager | — |
| Purchase Order | 2 | 285,000 | — | Role: Finance | — |
| Change Order | 1 | 0 | — | Role: Finance | — |
| Change Order | 2 | 500,000 | — | User: the general manager | — |
With these rules a request of 180,000 needs the project manager and one quote; 600,000 needs the project manager, then Finance, and three quotes; 2,000,000 needs all three signatures. Points to keep in mind:
- Request amounts are before VAT (quantity × estimated price), but purchase order amounts include VAT. That is why the Purchase Order band above starts at 285,000 (250,000 + 14%).
- Budget Override is matched on the whole request total, not on the overrun. A 2,000,000 request that is 5,000 over budget needs Finance and then the general manager on the Budget Override flow.
- Rules are company-wide. "Role: Project Manager" lets any project manager with the permission approve any project's request. Name an Approver User where one specific person must sign.
- Only one rule counts per step (the one with the highest minimum). Two signatures at the same level need two steps.
- An approver needs the module's approve permission as well as the role or name on the rule. The ready-made Project Manager role has no approve change order, which is why change orders go to Finance above; project managers raise them, and nobody can approve a change order they raised.
- Purchase Order rules apply to orders created directly. An order created from a selected quote is already approved.
- Approvers are notified in the app and by mobile push, with a daily reminder for steps waiting more than 24 hours (sent at 09:00 by the scheduler; your server's cron must run it). No email is sent.
Details: Procurement › Approval rules.
Roles and segregation of duties
- Revise Budget is applied at once, with no approval, by anyone with manage project budget (the ready-made Project Manager role has it). Editing a line's Original Budget also changes it without a revision record. Give manage project budget to a cost controller or Finance, and use change orders for changes that need sign-off. Apply to Budget on a change order needs both manage project budget and manage change orders, so give both to whoever applies approved change orders (e.g. the cost controller).
- People who only handle change orders also need view project budget; without it the Budget Control button is hidden and they can reach change orders only through the Approval Inbox.
- Restrict create vender and delete vender so only procurement adds suppliers.
The site-to-payment cycle
Site-to-payment cycleThe site asks, head office buys, the store receives, Finance pays.
Worked example: rebar for Tower B
Project Palm Residence — Phase 1 has the milestones Tower A, Tower B and Infrastructure. Stock posting is Only when goods are received on site, and the approval matrix above is in place.
The starting budget
| Budget line | Phase | Original | Used so far | Available | Warn / Block |
|---|---|---|---|---|---|
| MAT-STEEL — Rebar — Tower B | Tower B | 6,000,000 | 3,900,000 (65%, all actual cost) | 2,100,000 | 80% / 100% |
"Used" is actual cost plus the open commitment of purchase orders not yet received.
1. The site engineer requests 50 tons
The Tower B site engineer opens the project › Procurement › Request materials (or uses the mobile app) and fills in:
- Needed By: 45 days from today, which leaves time for approvals and the tender before the supplier's delivery period starts. It feeds the supplier on-time delivery KPI later.
- Item: product "Rebar 16 mm", Quantity 50 (tons), Est. Unit Price 40,000, Budget Line "MAT-STEEL - Reinforcement steel (Rebar — Tower B)" (the list shows code - name (description)). The request total is 2,000,000.
The Budget Check panel shows: used after 5,900,000 = 98.3% of the line, 100,000 left. That is above the 80% warning and below the 100% block, so the result is Warning: budget almost used. The engineer clicks Save & Submit.
2. Approval
The request is 2,000,000, so it goes to step 1 (Project Manager), step 2 (Finance) and step 3 (the general manager). Each approver sees it in Approvals › Approval Inbox with the Warning badge, or under Your approval is required on the request. A rejection needs a comment and ends the flow; the engineer can edit and resubmit. After step 3 the request is Approved.
3. Supplier tender
The rules for 2,000,000 require 3 quotes. Procurement opens the request › Supplier Quotes › Add Quote three times, attaching each supplier's offer as the Quote File. Enter Quoted Total without VAT: the purchase order adds the product's tax on top.
| Vendor | Quoted Total | vs. Estimate | Delivery (days) |
|---|---|---|---|
| Steel supplier A | 1,960,000 | −2.0% | 21 |
| Steel supplier B | 1,920,000 Lowest | −4.0% | 30 |
| Steel supplier C | 2,040,000 | +2.0% | 14 Fastest |
Supplier B meets the needed-by date and is cheapest. If you pick a quote that is not the lowest, record the reason in the uploaded file — the system has no field for it.
4. Purchase order
Procurement clicks Select under supplier B. In the Select Quote & Create Purchase Order window they set the Purchase Date, Category and Warehouse ("Palm Residence — Tower B store") and click Create Purchase Order.
- The order has 50 t at 38,400 (the quoted total spread over the lines), carries the budget line and cost code, and is already approved.
- 1,920,000 is committed on the budget line. Used is now 3,900,000 + 1,920,000 = 5,820,000 (97%).
- The request becomes Ordered. Procurement sends the order to the supplier.
5. Site receipt: partial delivery and rejected bars
For each truck the storekeeper opens the project › Procurement › Purchase Orders tab and clicks the Receive Goods (truck) icon on the order, or uses the mobile app. (The Site Engineer role can't open the purchase order page itself: that needs show purchase.) Received Now starts at the open quantity, so overwrite it with what actually arrived. Days are counted from the purchase order date.
| Receipt | Received Now | Rejected | Open after | Actual cost posted |
|---|---|---|---|---|
| GRN 1 (day 10) | 20 t | 0 | 30 t | 768,000 |
| GRN 2 (day 18) | 18 t | 2 t | 12 t | 691,200 |
| GRN 3 (day 25) | 12 t | 0 | 0 t | 460,800 |
- On GRN 2, two tons of bent bars were refused. The rejected quantity does not reduce the open quantity, so the order stays open for the replacement. Write the reason and the supplier's delivery-note number in Notes.
- GRN 3 brings the last 10 t plus the 2 t replacing the rejected bars.
- Each receipt adds stock to the Tower B store and posts actual cost (received quantity × 38,400, before VAT) to the budget line on the receipt date. The commitment falls by the same amount.
- If the supplier will not replace the rejected bars, use Close Purchase after the last delivery: the remaining commitment is released and the unbilled amount is credited back to the vendor.
- A wrong receipt can't be edited: delete it and enter it again. Deleting also removes its stock and actual cost and re-checks the order's bills.
6. Bill and payment
After GRN 2 the supplier invoices 38 t. Finance opens the order › Create Bill from PO; the bill is filled with the 38 t received but not yet billed. The supplier's invoice says 39,500 per ton.
- 39,500 is 2.9% above the order price of 38,400, outside the 2% tolerance, so the Three-Way Match panel shows a Price failure and the bill is Exception.
- Only the company account can pay an Exception bill, and while it exists other users can't add a payment on the purchase order either.
- Finance gets a corrected invoice at 38,400 from the supplier and edits the bill's price to 38,400 (or deletes the Exception bill and then enters the corrected one; a second bill next to it would count 76 t billed against 38 t received). The bill is Matched (38 t ≤ 38 t received, price within 2%).
- After GRN 3, a second bill for the last 12 t completes the order: 100% received and billed. It stays open until it is paid; Close Purchase is only for stopping an order short.
Finance pays each bill with Add Payment (needs create payment bill). See Accounting › Bill from a purchase order.
Where the line ends up
| Budget line | Revised | Committed | Actual | Available | Used % |
|---|---|---|---|---|---|
| MAT-STEEL — Rebar — Tower B | 6,000,000 | 0 | 5,820,000 | 180,000 | 97% |
Price escalation and contingency
There is no indexation or escalation-clause feature. Handle steel and cement price rises with these tools:
| When the price rises | What to do |
|---|---|
| Before the request is submitted | Budget Control › Revise Budget › Transfer from the CONT-01 line to the affected line, with a Reason. Check the source line's Available first: the system only stops a line going below zero, not below what is already committed or spent. |
| The winning quote is above the approved request | Nothing stops the award, and the order is not re-checked against the budget. Make it a rule that procurement cancels the request and raises a new one at the quoted amount, so it goes through approvals and the budget check again. |
| After the order is sent | An increase to a sent order is refused whenever a Purchase Order rule covers the new total. If goods have already arrived the order can't be cancelled: Close Purchase and create a new order for the balance at the new price. |
| On the supplier's invoice | More than 2% above or below the order price makes the bill an Exception, so put an agreed discount on the order line before billing. In receipt mode the project's actual cost always uses the order price, so even an accepted difference never reaches Budget Control. Post the difference as a project expense with the cost code and budget line (Project › Expense, needs view expense and create expense). |
Variations and change orders
Open the project › Budget Control › Change Orders › +: Title, Description, Cost Impact (negative for an omission) and Days Impact.
- Submit for Approval. The Change Order rules are matched on the absolute cost impact.
- After approval, click Apply to Budget (needs both manage project budget and manage change orders) and split the cost impact over budget lines — for example +350,000 to "MAT-FIN — Finishes — Tower A" and +150,000 to "SUB-ELEC — Electrical — Tower A". The amounts must add up exactly; each part is recorded as a budget revision.
- If the days impact should count, create and approve a new baseline; the schedule does not move by itself. See Project Controls › Baselines.
A change order changes cost budget lines only. It has no link to the client contract or sales price, to a subcontractor or purchase order, and no attachments. Put the client instruction or site instruction number in the Description, and handle the revenue side in sales and accounting. Details: Project Controls › Change orders.
Month-end control
| Where | What to look at |
|---|---|
| Project › Procurement | Open requests not yet ordered, orders with their % received, receipts, and bills with their match status. Budget used = actual + open commitment, as a % of the budget lines' revised total. Committed on orders is the gross amount ever ordered (the open part is in the card's hint), so don't add it to actual. Billed is not converted to your base currency. |
| Project › Budget Control | The reference for money decisions: Original, Revised, Committed (the open commitment), Actual, Available and Used % per line, Totals by Phase (per building) and Totals by Cost Code. Investigate the Unallocated costs (no budget line) row and move those costs to lines. |
| Project › Earned Value | Actual cost (AC) comes from the same ledger, so goods receipts (in receipt mode) or bills (in the default mode) move CPI at once; open commitments are not in AC. See Project Controls › Earned value. |
| Project System › KPI Scorecard | Purchases within budget, Request to PO time, Approval turnaround, Supplier on-time delivery (receipt date vs. Needed By) and Change orders vs budget. See Project Controls › KPI scorecard. |
| Approvals › Approval Inbox | Items stuck at a step. The "Requested" date is when the whole flow started, not when the current step began. |
What the system doesn't do yet
These are the gaps a developer will meet, with the workaround we recommend today.
Budget and requests
| Need | Today | Workaround |
|---|---|---|
| Reserve budget for approved requests | Missing. The check counts only actuals and open orders, so two requests of 60% of a line can both pass. | Turn approved requests into orders quickly, lower Warn at (%), and check Budget Control before selecting a quote. |
| Budget check on purchase orders | Missing. Only requests are checked; direct orders and awarded quotes are not. | Require requests for all project buying, and add Purchase Order rules so direct orders need sign-off. |
| One request for several projects | Missing. A request belongs to one project. | Raise one request per project; group the buying with the supplier. |
| Limit site staff to their own projects | Partial. The Projects list and project page show only projects the user is a member of, but the Project field on a purchase request lists every project, and Budget Control and Procurement pages open for any project by link. | Add people only to their own projects. Approvers check the project; each project's own budget lines make a wrong choice stand out. |
| Task narrows the budget lines | Missing. Project Task is a header field and doesn't filter lines. | Pick the right line on each item, or raise one request per building. |
| Unit, specification and needed-by date per item | Missing. One Needed By per request. | Write unit and spec in Description; split staged deliveries (concrete pours, steel batches) into separate requests. |
| Approval on budget revisions | Missing. Applied at once. | Limit manage project budget; use change orders for approved changes. |
| Non-recoverable VAT as project cost | Missing. Budgets, commitments and actual cost are all net of VAT. Where residential unit sales are VAT-exempt and input VAT can't be recovered, Budget Control and Earned Value understate cost by up to 14%. | Budget net and track VAT separately, or post the non-recoverable VAT monthly as a project expense with the cost code and budget line. Agree the policy with your tax adviser. |
Approvals and tendering
| Need | Today | Workaround |
|---|---|---|
| Approvers per project, or rules by cost code or category | Missing. Rules match module and amount only. | Use a named Approver User where one person must sign. |
| Delegation, joint signatures, escalation | Missing. | Two signatures = two steps. For holiday cover, change the rule's Approver User (affects new submissions only); the company account can always approve. |
| Email notifications | Missing. In-app and mobile push only. | Install the mobile app for all approvers. |
| Approve from the purchase order page | Missing. The order shows only its Approval Status. | Use the Approval Inbox (web or mobile). |
| Split one request between suppliers | Missing. One quote per request, as a lump sum. | One request per package (steel, cement…), or extra direct orders. |
| Per-line price comparison | Missing. | Attach the priced BOQ as the Quote File; correct line prices on the order before sending. |
| Distinct bidders, reason for not choosing the lowest | Missing. Two quotes from one supplier count as two. | Enforce by policy; keep the justification in the quote file. |
| Approval of the award (supplier choice and final price) | Missing. Approvals run on the estimate before quotes are collected, and the order created from a selected quote is already approved. | Give manage supplier quotes only to the procurement manager, upload the signed award-committee minutes as the Quote File, and raise a new request when the award is above the approved one. |
| Supplier prequalification (trade, registration, insurance, blacklist) | Missing. The vendor record has contact, tax number and addresses. | Keep the files outside the system; restrict who can add vendors. |
| Purchase order list by project and approval status | Partial. The list has no project or approval column. | Use each project's Procurement page; filter the inbox by Purchase Order. |
Site stores and receiving
| Need | Today | Workaround |
|---|---|---|
| Transfer material between sites | Missing. | Product Stock › Subtract Stock at the source and Add Stock at the destination, with a reason. The source store can go negative, and the project cost stays on the first project in Budget Control and Earned Value; it can't be moved there. A journal entry corrects only the accounts. See Warehouse › Adjusting stock. |
| Issue material from the store to a building | Missing. | Subtract Stock with a reason. Cost is not affected: it was charged on receipt. |
| Return to supplier for rejected material | Partial. Only the rejected quantity is stored, shown on the receipt page. | Reject on the receipt before billing. After billing, use a debit note with quantities — an amount-only debit note does not reduce project cost. |
| Over-delivery tolerance (e.g. +3% steel weight) | Missing. You can't receive more than is open. | With the recommended matrix a sent order can't be increased (any increase is refused when a Purchase Order rule covers the new total). Receive up to the open quantity, write the extra weight and weighbridge ticket in Notes, and raise a separate request or direct order for the excess, or agree it free of charge. |
| Delivery note number, truck, photos, quality sign-off | Missing. | Use Notes. |
| Edit a receipt; stop deleting used material | Missing. | Delete and re-enter; give manage goods receipt only to trusted staff and review the Goods Receipts list. |
| Receive only against orders sent to the supplier | Partial. A draft order can be received. | Make it a store rule. |
Subcontracts, retention and advances
| Need | Today | Workaround |
|---|---|---|
| Retention (5–10% held until handover) | Missing. | Pay each bill partly and leave the retention as the bill's open balance, or post it by hand to a "Retention payable" account. There is no retention report per project. |
| Advance / mobilisation payment | Partial. A sent, approved purchase order can be paid before any bill, but the payment is not set against the later bills. | Record it on the order (Add Payment) and settle the bills against it by hand, reconciling on the vendor balance. Make sure nobody pays the same bills again in full. |
| Subcontractor interim payment certificates | Missing. | Create a Service product (Products System › Product & Services, type Service), e.g. "Electrical works — Tower B", and use it as the request item with quantity 100 (%). Select the quote, and each month receive the % certified on a goods receipt; then Create Bill from PO. (A free-text item can't be billed: the bill needs a real product.) In receipt mode a bill for more than was certified is marked Exception. (The direct purchase order form doesn't list service items, so start from a request.) |
| Approve a match exception (e.g. accepted escalation) | Missing. Only the company account can pay it. | Correct the invoice or the order price, or have the owner pay. |
| Payments posted as "Add as Project Expense" | Partial. They don't reach Budget Control or Earned Value. | Record project costs in Project › Expense with a cost code and budget line. |
| Withholding tax on supplier / subcontractor payments | Missing. | Pay the net amount and post the withheld part by journal entry to a "Withholding tax payable" account so the bill is settled; reconcile per vendor for the quarterly return. |
| Report of match exceptions and supplier balances per project | Missing. | Project › Procurement › Bills tab; Accounting reports. |
Go-live checklist
- One project per phase, one milestone per building.
- Site engineers, storekeepers, project managers and Finance users added as members of each project.
- Company cost codes created (MAT, LAB, SUB, EQP, CONT).
- Budget lines per cost code and building, with the building in the Description and Warn at (%) around 75.
- A contingency line in every project.
- A warehouse for every site store, grouped under a parent, named after the project.
- Stock posting set to Only when goods are received on site.
- Approval rules for Purchase Request, Budget Override, Purchase Order and Change Order, with quotes required per band.
- Ready-made roles created; Finance given bill and payment permissions; approve purchase request and manage goods receipt removed from Procurement Officer; manage project budget limited and given, with manage change orders, to the cost controller.
- Named approvers (the general manager) hold the approve permissions of every module they sign.
- Approvers have the mobile app installed.
- Company policy: every project purchase starts with a request; quote totals are entered without VAT; rejected material is recorded on the receipt.
Quick reference
| Task | Path |
|---|---|
| Create the ready-made roles | User Management › Role › Create Project Controls roles |
| Cost codes | Project System › Cost Codes › + |
| Budget lines per building | Project › Budget Control › + |
| Move contingency to a line | Project › Budget Control › Revise Budget › Transfer |
| Stock posting mode | Settings › System Settings › Company Settings › Stock posting |
| Approval matrix | Approvals › Approval Rules › Add Step |
| Request materials | Project › Procurement › Request materials (or the mobile app) |
| Approve | Approvals › Approval Inbox (or the mobile app) |
| Tender and award | Purchase request › Supplier Quotes › Add Quote / Select |
| Receive on site | Project › Procurement › Purchase Orders › Receive Goods (or the order page, or the mobile app) |
| Bill the supplier | Purchase order › Create Bill from PO |
| Stop the rest of an order | Purchase order › Close Purchase |
| Variation | Project › Budget Control › Change Orders › + |
| Month-end review | Project › Procurement, Budget Control, Earned Value; KPI Scorecard |