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.