Software

Spreadsheets vs print shop software: the real cost of staying manual

A spreadsheet costs nothing to license and a lot to operate. Count the hours spent re-keying customer and order details, chasing approvals by hand, answering status enquiries, and rebuilding prices per quote. In most shops past roughly twenty orders a month, that time exceeds the cost of software several times over.

A spreadsheet is free until you count the re-keying, the chased approvals and the jobs that fall through. Here is how to work out your own number.

The case for a spreadsheet is that it is free and it does what you tell it. Both are true. The problem is the second half: it only ever does what you tell it, every single time.

Count the hours honestly

Take a normal week and count, per order:

Task Typical time
Re-typing customer and address details 3 to 5 min
Building the price from scratch 5 to 15 min
Producing and sending a proof 5 min
Chasing approval by hand 5 to 15 min
Answering "where is my order" 3 to 8 min
Re-typing the order into an invoice 5 min
Working out what to order in blanks 5 to 10 min

That is 30 to 60 minutes per order of pure administration, none of which decorates a garment. At 40 orders a month and a £30 loaded hourly cost, that is £600 to £1,200 a month, most of which is your own time as the owner.

Then count what falls through

Harder to measure, more expensive:

Where a spreadsheet genuinely wins

Be fair about this. A spreadsheet is the right tool when:

If that is you, buying software is premature and you should keep your money.

The signals that you have passed the point

Three or more of those and the arithmetic has already decided.

Move in an hour, not a project

Migrating from spreadsheets is the easiest migration there is, because a spreadsheet is already tabular. Customers, products and historical orders paste into an import template. Most shops are done in under an hour. See switching print shop software for the harder case of moving between systems, and our spreadsheet comparison for the direct version of this argument.

Free download

Get the pricing pack

One formula per decoration method, a worked example, and the seven numbers to watch. Free PDF.

  • One formula per decoration method
  • 100 black tees, priced line by line
  • The seven numbers to watch weekly

Questions

At what point should a shop stop using spreadsheets?
The usual trigger is around twenty orders a month, or the point at which more than one person needs to know an order's status. Before that a spreadsheet plus discipline is genuinely fine.
Can I keep my spreadsheet as a backup?
Export to CSV whenever you like, so yes in principle. In practice shops stop within a fortnight because maintaining two systems is worse than either one alone.
What do I lose by moving off spreadsheets?
Total flexibility. A spreadsheet does exactly what you tell it, which is why it never chases anything, never enforces anything, and never tells you a job is late.

Run the shop, not the chaos.

Printer's Friend turns every job in this article into a tracked order: quote, artwork approval, production stage, invoice.

Start free

Read next

Print shop software buyer's guide → Switching print shop software without losing order history → Do you need a customer portal? →