MIS vs spreadsheets for flexo prepress trade shops: when the switch pays back

Most flexographic prepress trade shops still run a meaningful share of their business in spreadsheets — quoting, plate-area calculations, gang allocation, customer rate cards, AR aging. Spreadsheets work fine up to a point. The point usually arrives somewhere between 200 and 600 plates a month, and the trade shops that recognize it earliest tend to be the ones with the highest gross margins.

This is what changes at the threshold.

Where spreadsheets actually work

Spreadsheets are a perfectly reasonable system for a flexo trade shop running below ~150 plates a month with two or three CSRs, a single shift, and a stable customer list. The math is simple, the volume is low, and the same person who quoted the job also tracks it through the floor. The cost of a real MIS is high relative to the benefit, and the benefit shows up as preventing problems the shop isn’t experiencing yet.

The spreadsheets that work best at this stage:

• Quote calculator — plate type and gauge inputs, rate card lookup, line-item adders for proofs and mounting.
• Job board — one row per active job, columns for stage (file prep, imaging, washout, ship), CSR, and due date.
• Plate-area log — measured area, customer rate, line total, invoiced flag.
• Customer rate sheets — one sheet per customer, with their negotiated rates, terms, and shipping defaults.

None of this requires software. A disciplined CSR running tight spreadsheets can hit 95%+ invoicing accuracy at this scale.

Where spreadsheets break

The breakdown is rarely a single event. It’s a steady erosion that becomes visible in margin reports six months after it started. The most common breakage points:

1. Rate card drift. A senior CSR negotiates a new tier with a customer in October. The shared rate-sheet doesn’t get updated until February. Four months of invoices go out at the wrong rate. Recovery is awkward (do you re-bill?) so the customer gets the better deal forever.

2. Forgotten line items. Rush fees, revisions, mounting, and proof line items are easy to capture when the same person who quoted is the same person who invoiced. As volume grows and quoting splits from invoicing, line items get waived by default. Industry benchmark: shops without structured intake leak 3–6% of annual revenue here.

3. Gang allocation arithmetic errors. When unrelated jobs share a plate, the area has to allocate across customer POs in proportion to each job’s contribution. Doing this in a spreadsheet means one person owns the math. That person occasionally makes an error, and the error gets caught only if a customer disputes the invoice (rare).

4. Area drift. Hand-measuring plates from a PDF or printout typically loses 2–8% of area to rounding and human error. At 35% plate-cost margin, that’s a direct 0.7–2.8 points of gross margin erased — quietly.

5. AR aging by gut feel. A growing shop’s AR ages by customer and party (brand vs. converter vs. designer). Tracking that in a spreadsheet means the AR clerk has a mental model of who’s late. When the clerk takes vacation or leaves, the mental model leaves with them.

6. Shift handoffs. Once a second shift exists, the night-shift CSR has no current view of the day-shift quote book. Two CSRs occasionally quote the same job at different rates. Customers notice.

7. Press-date risk. Spreadsheets don’t predict. A whiteboard of due dates doesn’t tell you on Monday morning that the Thursday press date for Customer X is at risk because plate-room capacity is full. The first you hear about it is Wednesday afternoon when the CSR calls.

The math on the switch

The case for switching to an MIS isn’t “spreadsheets are bad.” It’s that the cost of running on spreadsheets — measured in invoice leakage, margin drift, and operator hours — eventually exceeds the cost of running an MIS.

A rough benchmark for a 600-plates-per-month shop running on spreadsheets and an offset-era MIS retrofit:

• Area drift: 2–8% of plate revenue. On $2M/year of plate revenue at 35% margin: $14K–$56K annual margin loss.
• Forgotten line items: 3–6% of annual revenue. On $2.5M total revenue: $75K–$150K annual revenue loss.
• Rate card drift: Hard to measure precisely; commonly 1–3% of revenue: $25K–$75K.
• Operator hours on manual reconciliation: 8–15 hours/week per CSR, 2–3 CSRs: $25K–$60K of fully-loaded time.

Total range: $139K–$341K of annual cost from running on spreadsheets at this scale.

A purpose-built flexo MIS runs in the $20K–$60K/year range for a shop this size. The payback is almost always inside the first year, and the margin recovery compounds.

The shops that resist switching usually do so because they’ve tried generic print MIS (built for offset) and the implementation was painful and ended in a partial-rollout that didn’t fix the problem. That’s a real concern. Generic print MIS retrofitted to flexo doesn’t model plate area, doesn’t handle gang allocation, and doesn’t have the brand-converter-designer customer model — so the spreadsheets stick around in parallel.

A flexo-native MIS solves a different problem.

What “flexo-native” actually means

A flexo-native MIS is one whose data model assumes plates are the unit of business, not impressions or jobs:

• Plate area, gauge, type, and screening are first-class fields, not custom-field bolt-ons.
• Gang allocation runs automatically against the right customer POs.
• Three-party customers (brand, converter, designer) are modeled natively.
• Plate area reads off the step-and-repeat at imaging time, not hand-measured at month-end.
• Rate cards apply automatically by plate class, with negotiated tiers per customer.
• Converter delivery is its own workflow, not a generic shipping module.

Without this data model, the MIS works against the shop instead of for it — and the spreadsheets quietly come back, in parallel, within a year.

When to start looking

The leading indicator is not volume. It’s the number of times per week the founder or GM has to reconstruct what happened on a job from three different systems to answer a customer question. When that number passes ~3, the spreadsheets are no longer the system of record — they’re a slow leak in one.

For more on this:

• Flexo prepress software for trade shops — the MIS that sits next to your workflow tool.
• Prepress MIS software for flexographic trade shops — the flexo-native data model.
• ePS Pace alternative for flexo shops — why offset-era MIS retrofits don’t fit.
• Plate-area billing, end to end — the five places shops leak margin without structured invoicing.