Skip to main content

Interactive example · Trades & building

Stock that moves when the job does, and margins you can see before the invoice

Most workshops run stock on a spreadsheet nobody updates until stocktake, cost jobs from memory, and find out the margin when the accountant does. The sheets get used, the reorder gets missed, and a job that was quoted at 30% comes in at 12. Use the version below, for a fictional Ballarat joinery: scan a bay on the floor, issue four sheets, and watch the office's numbers move.

In short

A custom workshop inventory and job costing app lets the floor scan and issue stock to a job from a phone, updates on-hand and the job's material cost in the same moment, shows each job's quote against cost and margin as it stands, raises purchase orders from the reorder list grouped by supplier, and receives deliveries against them so stock, landed cost and short lines are all right.

Interactive demo: Stock and job costing for a workshop

Live demo · Sovereign Joinery, Ballarat is a fictional business with sample data. Nothing you do here is saved or sent.

Example app · sample stock

Sovereign Joinery

Workshop floor · Gareth Vinh

Sovereign Joinery · Ballarat · office@sovereignjoinery.com.au · Stock, jobs, prices and suppliers are sample data. Barcode scans, emails and the supplier invoice are simulated.

Sovereign Joinery is fictional. Stock, jobs, prices, suppliers and margins are sample data. Barcode scans, supplier emails and the invoice are simulated. Software names in the comparison are their owners' trademarks and are mentioned for comparison only.

Built for joiners, cabinet makers, fabricators and small manufacturers

Three people it has to work for, and what each is hiring it to do

  • OwnerKnow the margin on every job today, not at year end, and stop paying for stock twice
  • OfficeReorder before the floor runs out, and cost the invoice from real numbers
  • FloorGrab the sheets and get on with it; two taps, no clipboard

What you just used

How Sovereign Joinery runs, screen by screen

  1. Try this step in the demoBay scanned, stock issuedFloorFour sheets to the kitchen job
  2. Stock and job cost updateSystemOne record, both screens
  3. Try this step in the demoMargin checkedOfficeQuote against cost, right now
  4. Try this step in the demoPurchase orders raisedOfficeFrom the reorder list, by supplier
  5. Try this step in the demoDelivery receivedFloorAgainst the PO, one sheet short
  6. Landed cost appliedSystemCredit requested, jobs recosted

How the work moves through Sovereign Joinery: who does what, and where the software takes over. Steps with a mint mark are ones you can do in the demo above.

  1. Scan, pick the job, done

    A label on every bay and bin. The floor scans it, picks the job, sets a quantity and issues. On hand drops, the job's material cost rises, and nobody transcribes anything at 5 pm.

  2. Quote against cost, as it stands

    Every job shows materials issued, hours logged and the margin they leave against the quote, with a marker for the margin you aimed at. The one that's going wrong is red before it's invoiced.

  3. A reorder list that builds itself

    Drop under a reorder point and the item lands on the list with a suggested quantity, grouped by supplier with their lead time. One button raises and emails the purchase orders.

  4. Receive against the order

    The delivery is checked on the phone against the PO, line by line. Short or damaged lines are recorded, the credit is requested, and stock is right without a stocktake.

  5. Landed cost on the job

    When the supplier's invoice price differs from the standard cost, the jobs that used the stock are recosted. The margin you see is the real one.

  6. Reserved, not just on hand

    Open jobs reserve what they still need, so the office sees what's spoken for and what's actually free to issue, and the reorder point counts both.

Built for you

Your rules, not a template's

The demo is one rack and four jobs. Built for yours, it carries your own:

  • Your stock list, units, reorder points and suppliers, imported from the spreadsheet you run today
  • Barcodes or QR labels printed for every bay, bin and offcut rack, with a scanner or the phone camera
  • Job costing the way you quote: materials, labour rates by person, machine time, subcontractors and markup
  • Cut lists and nesting exports that reserve sheets when the job is released
  • Purchase orders emailed in each supplier's format, with price lists and lead times kept current
  • Sync with Xero or MYOB for bills, and with your quoting software so the quote and the cost meet

Connects to what you already use

Where a tool offers an API or a calendar feed, the build talks to it directly. Your data stays in accounts you own.

  • Xero
  • MYOB
  • Zebra label printers
  • Barcode scanners
  • Cabinet Vision
  • Microvellum
  • Email
  • Google Sheets

Custom build, inventory software off the shelf, or the spreadsheet?

Cin7, Unleashed and Katana are capable inventory systems, and simPRO and Tradify cost jobs well. The question is whether a workshop that cuts sheets, keeps offcuts and costs by the job fits their model, and whether you'll pay per user for a floor that just wants to scan.

CriteriaInventory software off the shelfCustom-builtThe spreadsheet
Time to startWeeks, plus data cleanupWeeks to monthsAlready running
Fit for a workshopBuilt for warehouses and retail; sheets and offcuts are awkwardYour units, your bays, your offcuts, your cut listsWhatever you made it do
Job costingOften a separate productMaterials, labour and margin on the same screen as stockA second spreadsheet, updated at the end
The floorPer-user licences for people who scan once an hourA phone screen with two taps, no licence per personDoesn't touch it
PurchasingReorder reports, POs built inReorder list to POs to receiving, in your suppliers' formatsA phone call and a memory
Best whenYou're mostly buying and selling finished goodsYou make things from stock and need the job margin, not just the countTwo people and twenty items

How we'd build yours

Fixed price, agreed before we start

  1. Walk the workshop with the spreadsheet open

    We map every column to what actually happens on the floor: where stock lives, how it's issued, who orders, what gets counted and what doesn't.

  2. Fix the scope and the price

    A written scope: stock, labels, issuing, job costing, purchasing and integrations in the first version, with one fixed price you approve before we start.

  3. Labels and the phone first

    The floor starts scanning against the real stock list in week one, while the office keeps the spreadsheet. The two are compared until the app is trusted.

  4. Costing, then purchasing, then the accountant

    Job costing goes live once issues are flowing, purchase orders once reorder points are tuned, and Xero last, when the numbers are already right.

What moves the price

Custom work is quoted individually, at a fixed price, once the scope is written down. These are the things that make the biggest difference.

Stock complexity
Sheets, lengths and offcuts with partial use take more modelling than boxes of hardware.
Costing depth
Materials and labour is standard; machine time, subcontractors and progress claims add rules.
Purchasing
Reorder lists and POs are standard; supplier price lists and receiving with credits add work.
Integrations
Xero or MYOB bills are standard; cut-list software and label printers are each their own piece.
Australian app build costs, published openly

When you shouldn't build this

If you're two people and the spreadsheet works, keep it, and put reorder points in a column. If you buy and sell finished goods, Cin7 or Unleashed will do. Custom makes sense when you make things from stock and the margin on each job is the number you're missing, when the floor won't touch a per-user system, or when the spreadsheet has become a job in itself. The app is the spreadsheet you meant to build, with a phone on the floor.

Want this, with your name on it?

Tell us how the work runs today. We'll reply within one business day with what we'd build first, what we'd leave out, and whether an off-the-shelf tool would serve you better.

Email

jayson@pixelapps.com.au

Location

Macedon Ranges, Victoria

Serving clients across Australia

Only if a quick call would be easier than email.

What are you after?(optional)
Rough budget(optional)

A range is enough. It helps us recommend the right approach, not the biggest one.

We reply within 24 hours. No obligation, and we never share your details.

Common questions

Software that tracks the stock a workshop makes things from, lets the floor issue it to jobs by scanning, shows each job's material and labour cost against its quote, and handles reordering and receiving. It replaces the stock spreadsheet, the job cost spreadsheet and the clipboard with one record everyone updates by doing their job.

Yes, and that's the usual starting point. Your spreadsheet already holds the stock list, units and (roughly) the reorder points, and its columns tell us the rules. We import it, add labels and a phone screen for the floor, and keep the spreadsheet running alongside until the app is trusted.

No. The phone camera reads the same labels, and a cheap Bluetooth scanner works if hands are full. Labels are printed from the app for bays, bins and offcut racks, so anything that moves has a code.

Each job carries its quote and the materials and hours you budgeted. Every issue and timesheet adds to cost, and the margin is shown as it stands with a marker for your target. When a supplier's invoice comes in higher than the standard cost, the jobs that used that stock are recosted, so the margin is real.

Xero and MYOB receive purchase orders as bills and jobs as invoices. Cut-list software such as Cabinet Vision or Microvellum can push the sheet requirements so a released job reserves its material. Each integration is scoped separately, and none is required for the first version.