Excel workbook
Sales-Channel Profit Tracker for Online and Pop-Up Sellers
Which channel makes you money, and which one only looks busy? Sales minus cost of goods, shipping, platform and card fees and event costs, by channel, by event and by month.
$24 one time · example and blank copies · download link by email
Who it is for
Makers and small sellers who sell on a marketplace, their own site, at markets and craft fairs, or wholesale, and want to know where the profit actually is.
Why it is different
- It counts what the event cost you, not just what you sold. A busy craft fair can still lose money.
- The pricing tab solves for the price. You enter your cost and target, it tells you the floor on each channel.
- Fees are inputs you set from your own statements. Nothing is assumed about your platform's current rates.
Free tool: Was that craft fair or market worth it? Free profit calculator
What is inside
- Setup. Report dates, target margin, and up to 8 channels with their platform and card fees.
- Sales Log. One row per day or event. Fees, profit and margin calculate for you.
- Channel Costs. Booth fees, travel, supplies, ads. For pop-ups you get a result for each event and profit per hour, marked WORTH IT or LOST MONEY.
- Channel Summary. Profit, margin and profit per order by channel, with a verdict against your target and a chart.
- Monthly. The same numbers by month, plus revenue by channel by month.
- Sales Tax. Tax you owe the state, kept apart from tax a marketplace collected for you, with a running balance of what is unpaid.
- Pricing Check. The minimum price on each channel that hits your target margin after fees and shipping.
A look inside
Example data, real formulas
Get it
Sales-Channel Profit Tracker
Want every toolkit? The toolkit membership includes all of them, with a lower rate if you pay yearly.
Delivered as a zip with a filled example and a blank copy. Built for Excel, tested in LibreOffice; it should open in Google Sheets but not every feature is tested there. For one business, your own use. General information, not accounting, tax or legal advice. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right.
Also from MCC Solutions
Month-End Close Workbook
A real month-end close in one Excel file. It tells you when a rec does not tie, which variances still need an answer, and when the period is ready to lock.
$19
QuickBooks Cleanup Kit
A structured way to clean up books that got away from you, and a status page that says plainly whether they are ready for tax prep or a lender.
$29