Preorder & Mailing List Tracker – Preorder Goals, Unpaid and Late Orders, Booth Email Signups by Show (Google Sheets + Excel)

INSTANT DOWNLOAD: you get the download link right after checkout. Nothing is shipped.

Running a pin, charm or zine preorder, and collecting email signups at the table on paper? Set each item price, unit cost and your maker minimum order: the sheet counts orders and units, shows profit and how many to go. Log every order with paid and status, and alerts flag UNPAID and LATE. The Mailing List tab records where you met each person and whether they said yes to email, so you only email people who agreed and can see which show grows your list.

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:

• Campaigns tab: preorder price, unit cost, minimum order, orders, units, revenue, cost, profit and GOAL MET / x TO GO (50 items; refunds excluded)
• Orders tab: customer, contact, item, qty, price, shipping, total, where ordered, status, paid, ship-by date and UNPAID / LATE / OPEN / DONE alert (500 orders)
• Mailing List tab: date, name, email, where you met, yes to email, interests, OK TO EMAIL / DO NOT EMAIL (1,000 signups)
• Events tab + Dashboard: signups, consents, preorders and revenue by show, totals and best event for signups

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 Pricing & Margin Calculator (set the preorder price) and Inventory & Sales Tracker. Keep customer 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:

• Artist Alley Pricing & Margin Calculator
• 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.