Report this item to Etsy

Black Friday Profit Optimizer, Calculator & Promo Planner for Etsy and Shopify Sellers | Excel Spreadsheet

Price:$29.00

Loading
Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by FiscalAIHQ
  • Digital download
  • Digital file type(s): 1 File

Black Friday profit calculator and promo planner for Etsy and Shopify sellers. Know exactly how far each product can go on sale, which offer earns you the most, and how your cash holds up all the way to January, before you set a single discount.

Built by Sarah Gordon, a Senior Financial Analyst with 10+ years at Mastercard and Ameriprise Financial. These are the same planning methods used by Fortune 500 finance teams, sized for your shop.

Black Friday is the biggest sales weekend of the year, and every discount decision carries real weight. Take 30% off a product with thin margins, and once Etsy or Shopify fees, shipping, returns and ad costs come out, that sale can quietly cost you money. The Black Friday Profit Optimizer runs those numbers for every product in your shop, so each offer you launch is one that pays you.


HOW IT WORKS:

Download your product list from Etsy Shop Manager or your Shopify admin.
Paste it into the Store Paste tab. Every product fills in automatically.
Enter your fees, shipping cost, return rate, ad cost and the minimum profit you want per order.
Read your plan. Every product, offer, bundle and week of cash is calculated for you.

WHAT’S INCLUDED (9 TABS):
1. Start Here - Step-by-step setup, a color guide to the workbook, and quick links that take you straight to every tab.
2. Settings - Enter your payment processing rate, fixed fee per order, shipping and packing cost, return allowance, ad cost per order, profit floor, planned sale % and average items per order. Benchmarks for Etsy and Shopify fees are listed beside each input, so you’re never guessing.
3. Store Paste - Paste your Etsy or Shopify export here. The workbook recognizes your products, variants and prices on its own. No reformatting.
4. Results - Your sale at a glance: how many products clear your profit floor at your planned discount, which are better suited to bundles, which need a capped offer, and your average margin across the catalog.
5. Catalog - Every product gets its own row: full-price margin, the max discount it can take and still make you money (with ad costs and without), profit at your planned sale, and break-even ad returns at 20%, 30% and 40% off. Each product is then marked Include, Bundle or Cap, so you know exactly what to do with it.
6. Promo Planner - Percentage off, spend-and-save tiers or free shipping with a gift? Five sale structures are compared side by side and ranked by the profit you actually keep each week. In the sample store, free shipping earns $595 a week, while 35% off sitewide loses $655.
7. Bundle Builder - Your products load into dropdown menus, so you can mix and match bundles in seconds. See the bundle price, the profit per order, and how much more it earns than selling the same items at your sitewide discount. One sample bundle earns $19.48 more on every order.
8. January Cash Plan - Map ten weeks of revenue, ad spend, product costs and restocks from Black Friday through January. Your safety buffer stays in view, so every restock and ad dollar is funded before you spend it.
9. End Here - A summary of everything you planned, plus four principles to carry into the new year: Hindsight, Insight, Foresight, Wealth.

WHO IT’S FOR:
Etsy and Shopify sellers planning a Black Friday, Cyber Monday or holiday sale. Works for handmade, print-on-demand, vintage, apparel, home goods and digital shops alike.

WHAT YOU RECEIVE:
1 Excel workbook (.xlsx), preloaded with a sample store so you can see every tab working before you add your own numbers.

FULLY EDITABLE:
Type your own numbers into the gold cells. Every calculation updates automatically. No formulas to write, and step-by-step instructions on every tab.

COMPATIBILITY:
Microsoft Excel 2019 or later (including Microsoft 365) and Google Sheets, on Mac and PC.
Handles up to 250 product variants.
Instant digital download. Set up your holiday sale in one sitting.

YEARS OF USE:
Yours to keep. Reopen it for Valentine’s Day, Mother’s Day, summer sales and next Black Friday. Update Settings and your new plan is ready.

LICENSE:
For use in your own business. Please don’t resell, share or redistribute the file.

PLEASE NOTE:
This is a digital file. No physical item will be shipped.
Results are planning estimates based on the numbers you enter.

Questions? Message the shop. I answer personally.

Hindsight · Insight · Foresight · Wealth
Total Fiscal Order.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms