Online Order & Shipping Tracker – Ship-By Dates, LATE Alerts, Postage Charged vs Paid, Profit per Order (Google Sheets + Excel)
INSTANT DOWNLOAD: you get the download link right after checkout. Nothing is shipped.
Selling leftover stickers, prints and pins online between shows? Log each order from your own shop, a marketplace, DMs or after-show requests. The sheet sets the ship-by date from your processing days, flags LATE, DUE TODAY and DUE SOON, marks orders that shipped late, and shows whether the postage and packing you paid cost more than the shipping you charged, plus profit per order and by channel. A Packing Supplies tab flags mailers and sleeves to REORDER.
AI disclosure: made by LB3 Trackers with AI assistance. AI tools helped write the code that builds the files, plus the layouts and wording; every file was checked before listing.
What's included:
- Orders tab: date, order #, buyer, channel, items, item total, shipping charged, postage, packing, fees, item cost, ship-by, shipped date, status, tracking, days late, shipping +/-, profit and alert (1,000 orders)
- Channels tab: orders, revenue, profit and shipping +/- by channel (15 channels)
- Packing Supplies tab: on hand, reorder point, cost and REORDER flag (40 supplies)
- Dashboard: late, due today, due soon, on-time ship rate, revenue, shipping +/-, profit, average order profit
Format: one .zip with a SAMPLE and a BLANK .xlsx (Excel 2019 or newer, or Google Sheets).
Spreadsheet files: one SAMPLE copy with made-up example data and one BLANK copy. Open the .xlsx in Excel, or upload it to Google Sheets (File > Import > Upload). Standard formulas only; no macros, add-ons or links to other files.
Pairs with our Artist Alley Inventory & Sales Tracker and Preorder & Mailing List Tracker. Keep buyer details private.
Generic, original design: no show, character, studio or brand names, and no copyrighted art. Not affiliated with or endorsed by any company, event or service.
Free sample: Artist Alley Break-Even Quick Sheet (printable) (free on our Payhip shop).
You may also like:
- Preorder & Mailing List Tracker
- Artist Alley Inventory & Sales Tracker
- Artist Alley Income & Expense Ledger
Questions or a problem with a file? Message us through the store contact page. If a file doesn't work for you, we'll fix it or refund you.
License: personal use. Please don't resell, share or re-upload the files.