Mozaik to Cost Sheet: Turning Cabinetry CSV Exports into Usable What Mozaik CSV exports actually contain, why they're not client-ready as-is, and what a properly formatted cabinetry cost sheet should include. target_keyword: mozaik csv export, mozaik cost sheet
If you run cabinetry or joinery jobs through Mozaik, you already know the software is excellent at generating cut lists, part programs, and hardware schedules — and far less helpful when it comes to handing a client or estimator a clean, readable cost breakdown. The raw CSV export is built for machines, not people, and turning it into something usable takes more than opening it in Excel.
Here's what's actually in a Mozaik export, where the gaps show up, and what a properly formatted cost sheet needs to fix them.
A typical Mozaik export lists every part, panel, and hardware item that makes up a job — dimensions, materials, quantities, and a per-line "Amount" column. It's comprehensive at the component level, but it's flat: hundreds of rows with no grouping by room, cabinet, or cost category, and no summary totals a client or project manager would want to see first.
For someone estimating or quoting a job, that raw structure means manually scrolling through hundreds of line items just to answer a simple question like "what's the hardware cost for this kitchen."
One issue worth flagging specifically: Mozaik's internal cost totals and the numbers in the exported CSV don't always match exactly. In practice, the software can apply an internal per-item uplift — commonly in the range of around 10% on hardware — that isn't reflected in the exported "Amount" column. If you build your cost sheet purely off the raw export without accounting for this, your hardware totals can come in noticeably under what Mozaik itself calculated internally.
This is easy to miss because the export looks complete — it has an amount for every line — but the export figure and the software's own summary total can genuinely disagree. Worth checking against Mozaik's internal report before treating the CSV as the source of truth.
A cost sheet that's actually usable — whether for internal estimating or a client-facing quote — typically needs:
Section headers grouping items by category (carcass materials, hardware, benchtops, doors, labor) rather than one long undifferentiated list
Subtotals per section, so a reviewer can sanity-check "does the hardware total look right" without adding up 80 rows by hand
A margin structure applied consistently — for example, cost divided by (1 − target margin %) to hit a specific gross profit percentage on the sell price, rather than a flat markup that quietly erodes margin on more expensive items
A clear separation between cost and sell price columns, so internal cost data doesn't accidentally get shared externally
A summary page with the job total, broken down by major category, before anyone has to read the detail sheet at all
None of this exists in the raw Mozaik export — it has to be built on top of it.
The manual version of this process — export, reformat, regroup, recalculate margins, check against Mozaik's internal totals — is repetitive enough that it's worth automating once the format is settled. Whether that's a script that reformats each new export automatically, or a repeatable spreadsheet template with formulas already in place, the goal is the same: get from "raw CSV" to "client-ready cost sheet" without re-solving the same formatting problem on every job.
Working with Mozaik exports regularly? We build formatted cost sheets directly from Mozaik CSV exports — grouped, margin-calculated, and ready to send to clients or estimators. See our Mozaik Kitchenette & Cabinets Design service →