Covers receipts, approvals, FX evidence, scope change, contingency, custody of funds, privacy, and the boundary between tracking and escrow. This guide is part of FRELUX’s educational library. It explains how to interpret a preliminary calculator output and how to keep the assumptions visible. It is not a substitute for project specifications, professional design, supplier quotations, legal advice, or local approvals.
For reliable project control, retain dated exchange-rate evidence, remittance and bank fees, receipts, approved work certificates, local-currency ledgers, outstanding commitments, and scope changes. Agree who may authorize spending, who verifies completion, and how disputed records are handled. The word escrow has a specific custody and legal meaning that a calculation screen does not provide. Do not tell a sponsor that funds are protected or held in escrow because a tracker records budgets. Use a regulated and contractually appropriate service for custody, release conditions, dispute handling, identity checks, and applicable legal obligations. The tracker should complement, not replace, those controls. The calculation is useful when its input boundary is clear and its output is treated at the right project stage. It cannot establish facts that were never supplied, independently confirm a site condition, or grant approval for construction, procurement, payment, or compliance. A consistent formula can make the same result reproducible; it cannot make an unsuitable assumption valid.
Covers receipts, approvals, FX evidence, scope change, contingency, custody of funds, privacy, and the boundary between tracking and escrow. For reliable project control, retain dated exchange-rate evidence, remittance and bank fees, receipts, approved work certificates, local-currency ledgers, outstanding commitments, and scope changes. Agree who may authorize spending, who verifies completion, and how disputed records are handled.
The word escrow has a specific custody and legal meaning that a calculation screen does not provide. Do not tell a sponsor that funds are protected or held in escrow because a tracker records budgets. Use a regulated and contractually appropriate service for custody, release conditions, dispute handling, identity checks, and applicable legal obligations. The tracker should complement, not replace, those controls.
a
A useful estimate begins by stating what decision it is meant to support. A concept-stage feasibility check, a quantity review, a tender comparison, a procurement schedule, and an issued-for-construction package have different evidence requirements. Write the intended stage and audience at the top of the worksheet. State what is included, what is excluded, who supplied the inputs, and which drawing or record revision was used. This prevents a preliminary calculation from silently acquiring the authority of a construction instruction. If the scope changes, preserve the earlier version and record what changed rather than editing history away. For this topic, apply that discipline to the relevant records and questions rather than treating a default as a project fact. Ask who owns the input, how current it is, what unit and scope it uses, and what evidence will close any uncertainty. If the record is missing, mark it as missing and assign an owner to obtain it. That practice makes the estimate easier to revise and safer to share.
Gather the primary source documents first: current drawings, schedules, specifications, surveys, supplier data, or financial records appropriate to the task. Check revision numbers, dates, units, naming conventions, and whether the information is approved or provisional. List missing inputs explicitly. Do not replace a missing dimension, rate, grade, or site condition with a plausible-looking default unless the interface clearly identifies it as an assumption and the reviewer accepts it. When several documents disagree, log the discrepancy and ask the responsible designer or project lead to resolve it before relying on the output. For this topic, apply that discipline to the relevant records and questions rather than treating a default as a project fact. Ask who owns the input, how current it is, what unit and scope it uses, and what evidence will close any uncertainty. If the record is missing, mark it as missing and assign an owner to obtain it. That practice makes the estimate easier to revise and safer to share.
For each assumption, record its value, unit, source, date, reason, owner, and status. Separate confirmed facts from estimates, defaults, and unresolved questions. The distinction matters because arithmetic can be exact while its inputs remain uncertain. A result with two decimal places does not become more reliable merely because it is formatted precisely. When an input is changed, document the reason and compare the old and new result. If the app supplies a default, make sure the person using the result understands that the default is a convenience for a preliminary scenario, not evidence of local practice or project approval. For this topic, apply that discipline to the relevant records and questions rather than treating a default as a project fact. Ask who owns the input, how current it is, what unit and scope it uses, and what evidence will close any uncertainty. If the record is missing, mark it as missing and assign an owner to obtain it. That practice makes the estimate easier to revise and safer to share.
Before comparing quantities, confirm that both sides use the same unit system and scope boundary. A length may be measured along a centreline or to an outside face; a cost may include or exclude tax, delivery, labour, or fees; a material volume may refer to compacted output or loose supply. Write down the conversion factor and keep the source quantity visible. Avoid mixing nominal labels with physical equivalence: standards, products, and quality classes require explicit specification review. Unit conversion can preserve a physical dimension, but it cannot reconcile different engineering criteria or procurement definitions. For this topic, apply that discipline to the relevant records and questions rather than treating a default as a project fact. Ask who owns the input, how current it is, what unit and scope it uses, and what evidence will close any uncertainty. If the record is missing, mark it as missing and assign an owner to obtain it. That practice makes the estimate easier to revise and safer to share.
Recalculate at least one representative line independently, preferably using a hand check or a second reviewer. Check whether totals reconcile to component lines, whether rounding is applied at the right stage, and whether a zero or blank has a clear meaning. Test a small and a large case to notice discontinuities caused by whole-package rounding or preset thresholds. Review warnings and missing inputs; do not hide them in a screenshot or export. Where possible, retain the unrounded intermediate values and show how the displayed purchase quantity was derived. A transparent worksheet is easier to correct than a polished total with no traceable path. For this topic, apply that discipline to the relevant records and questions rather than treating a default as a project fact. Ask who owns the input, how current it is, what unit and scope it uses, and what evidence will close any uncertainty. If the record is missing, mark it as missing and assign an owner to obtain it. That practice makes the estimate easier to revise and safer to share.
A quantity and a price answer different questions. A product price should identify the exact specification, supplier, market, currency, quotation date, tax treatment, delivery terms, and whether stock is actually available. A stale, unverified, or generic price should not be presented as a current local rate. Record price coverage separately from calculation coverage. If no defensible price is configured, leave the cost unpriced or request a dated quotation rather than multiplying a quantity by an unsupported placeholder. Keep labour, plant, transport, waste, taxes, and contingency visible as separate assumptions when they are relevant. For this topic, apply that discipline to the relevant records and questions rather than treating a default as a project fact. Ask who owns the input, how current it is, what unit and scope it uses, and what evidence will close any uncertainty. If the record is missing, mark it as missing and assign an owner to obtain it. That practice makes the estimate easier to revise and safer to share.
Give each calculation a project identifier, preparer, reviewer, date, source revision, and status. Keep an immutable exported copy for each decision gate, with the input assumptions included. If the design team revises a drawing or the sponsor changes a budget, create a new revision and explain the impact. Assign an owner to resolve open questions and set a due date. The review should ask not only whether the arithmetic is correct, but whether the inputs are authorized, the method is applicable, and the proposed use falls within the calculator’s limits. For this topic, apply that discipline to the relevant records and questions rather than treating a default as a project fact. Ask who owns the input, how current it is, what unit and scope it uses, and what evidence will close any uncertainty. If the record is missing, mark it as missing and assign an owner to obtain it. That practice makes the estimate easier to revise and safer to share.
Stop using an estimate as soon as it would be asked to make a design, life-safety, legal, payment, or compliance decision that the tool does not support. Escalate to the appropriately qualified professional or authorized commercial party. Provide them with the source documents, assumptions, units, calculation output, unresolved questions, and the intended decision. The purpose of a preliminary tool is to make a discussion more informed, not to bypass professional review. A conservative, clearly marked unknown is safer and more useful than an invented value presented as certainty. For this topic, apply that discipline to the relevant records and questions rather than treating a default as a project fact. Ask who owns the input, how current it is, what unit and scope it uses, and what evidence will close any uncertainty. If the record is missing, mark it as missing and assign an owner to obtain it. That practice makes the estimate easier to revise and safer to share.
Now test a changed assumption that a real project could encounter: a revised drawing, a different stock or package size, a new supplier quotation, a changed route, or a different delivery date. Save both scenarios and note which output lines changed. A useful sensitivity comparison explains why the change occurred and whether it affects the decision threshold. It does not claim that one scenario is more likely unless there is evidence for that conclusion.
Set the reporting basis before entering transactions. Choose the sponsor currency and local currency, specify the rate convention as local units per one sponsor-currency unit, and choose a date for each rate. Do not mix a purchase rate, a remittance rate, a bank settlement rate, and an indicative parallel quote under one unlabeled field. Fees and spreads should be recorded separately where they affect the money received or the local funds available.
When a positive official rate is supplied, the engine calculates a percentage gap against the manual parallel rate. This is a scenario calculation, not a sourced market quote, a bank offer, a remittance price, or a prediction of settlement proceeds.
No. The rates are entered by the user and the result is a scenario calculation. Record the source, time, rate basis, fees, and currency convention for every rate used. For a project-specific decision, confirm the applicable specification and evidence with the responsible professional or authorized supplier.
No. It does not hold, transfer, or safeguard funds and does not provide escrow custody, legal protections, payment execution, or dispute resolution. Use an appropriate regulated service and contract for those functions. For a project-specific decision, confirm the applicable specification and evidence with the responsible professional or authorized supplier.
The current engine sums foreign allocations for milestones marked completed. That status is a user-entered tracking signal, not proof of a transfer. Reconcile against bank and remittance statements. For a project-specific decision, confirm the applicable specification and evidence with the responsible professional or authorized supplier.
It compares local spend converted at the entered rate with allocations for completed milestones. It does not identify the cause. Review timing, scope, rate evidence, receipts, and milestone statuses before drawing conclusions. For a project-specific decision, confirm the applicable specification and evidence with the responsible professional or authorized supplier.
No. It applies the entered annual percentage and duration using a compounding formula. It does not draw on live inflation data or predict supplier prices; use documented scenarios and updated quotations. For a project-specific decision, confirm the applicable specification and evidence with the responsible professional or authorized supplier.
Keep dated transfer confirmations, received amounts after fees, receipts, approvals, exchange-rate evidence, work certificates, commitments, milestone status changes, and a versioned local-currency ledger. For a project-specific decision, confirm the applicable specification and evidence with the responsible professional or authorized supplier.