Your Cart
Loading

Picture Framing Order Kit - Excel & Google Sheets

On Sale
$8.00
$8.00
Added to cart

Order tracker for picture framing shops. Price frame types from your own rate list, track glass and extras, and see revenue and money still owed.


TRACKS

  • Settings: your frame types (poster, custom, shadow box) with prices
  • - Orders: date, customer, frame type (dropdown), glass and extras you type, an optional price override for one-off jobs, status (Quoted, Working, Done, Paid, Cancelled)
  • - Month rollups for any months you type (no hardcoded years)

CALCULATES

  • Order total = frame price + glass and extras
  • - Orders, revenue, money collected, and amounts outstanding, overall and per month
  • - Quoted and in-progress value- Status-based: no partial payments. Cancelled orders are ignored. Month rollups count Done and Paid orders only. A frame type not on your Settings list shows in red, and a check row flags orders with a total but no status.

No tax or filing features.


WHAT'S INSIDE

  • Picture Framing Order Tracker.xlsx with Orders, Dashboard, Settings, Monthly, Instructions
  • - Fictional sample rows you can delete in seconds to start fresh
  • - Quick-start README with step-by-step instructions for Excel and Google Sheets

INSTANT DOWNLOAD

One ZIP file: the spreadsheet (xlsx) and a README (txt). Works in Microsoft Excel and Google Sheets (upload the xlsx to Google Drive). Designed for Excel and Google Sheets; tested in LibreOffice Calc.


Created with AI assistance and reviewed before publication.

You will get a ZIP (15KB) file