Each money figure shows only to people who may see that kind of money (Can see selling prices, Can see purchase costs, Can see profit and margin). "Margin is shown to people who may see prices, costs and profit." Choose the columns with Columns or Show all columns; your choice is kept in your browser.
Projects tab: cards
| Card | Shows |
|---|---|
| Contract value | The awarded quotations of the listed projects, without tax |
| Cost to date | Material, labour and other cost so far |
| Gross margin | Contract value less cost |
| Projects over budget | The number of projects over budget. "Click to show only these"; selecting it again clears it ("Filter on: click to clear"). |
| Blocked stock value | Stock blocked for the projects, "at last purchase rate" |
Under the cards: "As on [date], cost from [date]. Contract value excludes tax. Money in [currency]." A warning "[number] project stock-out(s) ... not linked to any project." with View them shows when some stock outs have no project.
Projects tab: filters and columns
| Filter | Choices |
|---|---|
| Search | Project or customer |
| Status | All statuses, Tender, Won, Lost, Pending, In Progress, Completed, On Hold |
| Customer | A customer name |
| Project manager | All managers, or one |
| From, As on | Dates that limit the cost period |
| Tick boxes | Over budget only, No awarded quotation, Has estimated figures |
| Reset filters | Clears them |
| Column | Shows |
|---|---|
| Project, Customer, Status | The project |
| Contract value | From the awarded quotations, without tax. "Not tracked" when there is no awarded quotation and no contract value. |
| Material quoted, Material actual | Material in the quotation, and issued or blocked for the project |
| Labour quoted, Labour actual | Labour in the quotation, and labour expenses |
| Other expenses | Expenses of the Other cost type |
| Total cost, Margin, Margin % | Cost and margin. The margin is green, amber or red against your margin threshold. |
| Cost burn % | A percentage of cost against the job |
| Last cost entry | The date of the latest cost |
"est." marks an estimated figure. With nothing to show: "No projects match these filters." The export is named Job-Costing-[date].
Services tab
Pick Contracts, One-off jobs or All. The filters are Search (contract, machine or customer), Type, Status (Active (contract), Cancelled (contract), Pending (one-off), Completed (one-off)), Customer, From, As on and Reset filters.
| Column | Shows |
|---|---|
| Service, Customer, Type, Status | The contract or one-off job |
| Contract value or Invoiced | The contract value, or what was invoiced for a one-off job |
| Invoiced | What has been invoiced for it |
| Material, Labour, Other, Total cost | Its cost |
| Margin, Margin % | Its margin |
| Visits (done/total) | Visits done out of all visits |
| Last activity | The date of the latest activity |
Tick rows to use Create invoice ([number]). With nothing to show: "No services match these filters." The export is named Service-Costing-[date]. The tab is greyed out, with "The Service module is turned off for this company", when the Service & Maintenance module is off.
A project's page
| Part | Shows |
|---|---|
| Header | "Contract value: [amount]" with the quotation count, for example "(1 quotation)", which lists the "Awarded quotations (excluding tax)", or "Not tracked". From and As on dates. Back link All projects. |
| Summary tab | Cards Margin, Needs attention and Cost by month, and the cost type picker Set type |
| Materials tab | Each quoted item against what was issued, "Used but not quoted ([number])" and "Unmatched quoted lines ([number])". Export Material-Reconciliation-[name]. |
| Expenses tab | Filters From, To, Category, Added by, Bill (Attached or Not attached), Payment (Paid or Unpaid). Columns Date, Description, Vendor, Added by, Payment, Bill, Amount, Actions, and a Total. Export Project-Expense-Statement-[name]. |
Summary and Materials need View on Job costing sheets. The Expenses tab also shows with View on Expenses alone. The project page's Costing tab shows the same three tabs.
A service's page
| Part | Shows |
|---|---|
| Header | "Visits [done]/[total] done", and "Contract value:" or "Invoiced:". Back link All services. |
| Summary | Card Visits: Visit, Status, Scheduled, Completed, Hours, Technicians, Material, Expenses |
| People | Technician, Visits attended, First visit, Last visit, Hours. Empty: "No technician is assigned to a visit." |
| Materials | Request material, Record parts, "Unlinked parts ([number])", Issued by visit |
| Invoices | Create invoice, then Invoice, Date, Billed for, Status, Billed to this service, Collected, Outstanding |
| Expenses | As on a project's page. Export Service-Expense-Statement-[name]. |
Badges
| Badge | Means |
|---|---|
| Exceeded | The line has gone past what was quoted |
| Nearing | The line is getting close to what was quoted |
| On track | The line is within what was quoted |
| Not quoted | The material has no quoted line |
Margin colour: green at or above the threshold plus 5 points, amber from the threshold to the threshold plus 5, red below the threshold. The threshold is 15% unless DuctArchitect has set another figure for your company.
