Skip to content
MyToolers

Printing Press Job Sheet & Quotation Template

One row per print job — customer, size, paper, colours and finishing, with the amount, advance and balance worked out for you.

Download the template

Free, no sign-up. Opens in Excel, Google Sheets, LibreOffice and Numbers, with the formulas already working.

What’s in the template

16 columns, a row of example entries you can overwrite, and a TOTAL row at the bottom. Columns marked “formula” are calculated for you — don’t type over them.

ColumnWhat to enter
Job NoYour own running number, e.g. J-1001. Write it on the job bag too.
DateThe day the order or quotation was taken.
Customer—
Phone—
ProductVisiting cards, flyers, letterheads, banners, boxes…
Size—
Paper / GSMStock and weight, e.g. 350 GSM art card.
ColoursFront + back, e.g. 4+4 (full colour both sides) or 1+0.
FinishingLamination, UV, die-cutting, binding, numbering.
Quantity—
RatePrice per piece (or per set) that you quoted.
AmountformulaFormula: Quantity × Rate.
AdvanceMoney received when the order was confirmed.
BalanceformulaFormula: Amount − Advance — what to collect on delivery.
Due date—
StatusQuotation, design approval, plate, printing, finishing, ready, delivered.

How to use this job sheet

Give every enquiry its own row the moment it arrives — even if it is only a quotation. Fill in the specification columns while you are speaking to the customer, enter the quantity and your rate, and the amount is worked out. When the customer pays an advance, type it in and the balance updates; the TOTAL row at the bottom shows the full value of your open jobs and the money still to collect.

Change the Status column as the job moves through design, plates, printing and finishing. Filtering on Status (Data → Filter in Excel or Google Sheets) gives you a quick list of what is due today, which jobs are stuck on design approval, and which finished jobs have not been delivered.

Use it as a quotation register too

Many presses lose work because quotations are written on paper or sent on WhatsApp and never followed up. Keep quotations in the same sheet with the status “Quotation”, and call back the ones that are a few days old. When the customer confirms, just change the status — the job number, specification and price are already there, so nothing is typed twice.

To quote accurately, work out your cost first: paper sheets per job, plates, ink, press time, finishing and wastage. Our free print job cost calculator does this and suggests a price for your margin.

When a spreadsheet stops being enough

A sheet works well for one person at one desk. It gets harder when several people take orders, designers and machine operators need to see the same job, customers ask for status updates, and you need invoices and receivables at month end. That is when presses move to print management software, where quotes, print jobs, machines, operators, consumables and invoices are linked and nothing depends on one file.

Related guides

Ready to replace the spreadsheet?

PrintFlow turns each quotation into a print job with product, paper, size and quantity, shows it on a production board with machines and operators, and keeps consumables and invoices in the same system.

Frequently asked questions

What should a printing press job sheet include?

At least the customer and contact, product, finished size, paper and GSM, colours front and back, finishing, quantity, rate, amount, advance, balance, due date and current status. This template has all of them; add columns such as designer, machine or plate count if you need them.

Can I change the columns?

Yes. Insert or delete columns freely — the Amount and Balance formulas follow their columns in Excel and Google Sheets. If you add rows below the TOTAL row, widen the SUM ranges or insert rows above TOTAL instead.

Does it work in Excel and Google Sheets?

Yes. The file is a standard CSV with formulas, so it opens in Microsoft Excel, Google Sheets, LibreOffice and Numbers. In Google Sheets you can also use “Copy for Google Sheets”, click cell A1 and paste. Save it as .xlsx or keep it in Google Drive so your formatting and new rows are kept.

Is the template free?

Yes — free to download, change and use in your business, with no sign-up. The file is created in your browser, so nothing you type is sent to us.