Your Cart
Loading

Print Shop Order Kit - Excel Spreadsheet

On Sale
$8.00
$8.00
Added to cart

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.

You will get a ZIP (16KB) file