Print Shop Order Kit - Excel Spreadsheet
On Sale
$8.00
$8.00
Order tracker for print shops. Business cards, flyers, banners - price from your product list with quantity and setup fees.
TRACKS
- Settings: your products with unit prices
- - Orders: date, customer, product (dropdown), quantity, an optional Unit price override, setup fee, status (Quoted, Printing, Done, Paid, Cancelled)
- - Month rollups for any months you type (no hardcoded years)
CALCULATES
- Order total = quantity x unit price + setup fee
- - Orders, revenue, money collected, and amounts outstanding, overall and per month
- - Value of quoted and printing work not yet done
- - Cancelled orders are ignored. Month rollups count completed and paid orders only. A product name not on your Settings list shows in red; check rows flag orders with a total but no status or a product with no quantity.
No tax or filing features.
WHAT'S INSIDE
- Print Shop Order Tracker.xlsx with Orders, Dashboard, Settings, Monthly, Instructions
- - Fictional sample rows you can delete to start with your own data
- - Quick-start README with step-by-step instructions
INSTANT DOWNLOAD
One ZIP file: the spreadsheet (xlsx) and a README (txt). Standard .xlsx file; tested in LibreOffice, should open in Excel and Google Sheets.
Created with AI assistance and reviewed before publication.