Merch Margin & Inventory Planner

The Merch Margin & Inventory Planner is a pricing and stock tool for creators, artists, and small brands running a merch line. You enter each item by SKU with its unit cost, its selling price, how many you have sold, and how many are on hand. The tool computes the contribution margin and sell-through rate for every SKU, flags the reorder points before you sell out, and builds a dead-stock and markdown list for the pieces that are not moving. The goal is plain. A merch table should make money and should not tie up cash in boxes that never sell.

Most people who run a merch line are self-employed or run a small business on the side of their creative work, which means merch profit is taxable business income. The IRS self-employed individuals tax center lays out the income-reporting and self-employment tax duties that come with selling goods on your own account. Knowing your true margin per SKU is not just a pricing exercise, it is the start of knowing what you actually earned once cost of goods is taken out, which is the number that eventually matters at filing time.

The planner is built around the reality that merch cash is easy to misjudge. A shirt that sells well can still lose money if the printing cost was too high, and a slow item can quietly eat your budget by sitting in inventory you already paid for. By putting margin and sell-through next to each other per SKU, the Merch Margin & Inventory Planner shows you which items earn their place on the table and which ones are only there out of habit. Volume can hide a thin margin, and a healthy margin can hide slow sales, so seeing both at once stops either number from fooling you on its own.

Using it is quick. You load your SKUs with cost, price, sold, and on-hand counts, set the reorder thresholds you are comfortable with, and get a margin and reorder report back. There is no accounting background required and no complex system to maintain between drops. If you have been running merch off a POS export and a gut feeling, this is the place those numbers turn into a decision about what to reprice, what to reorder, and what to clear. See the product overview for how a full SKU list comes together.

The honest part is that the tool will sometimes tell you a favorite item does not make money. That is useful, not discouraging. A creator who knows the real margin on every SKU can raise a price, renegotiate a print cost, or retire a design, and can do it with records that also support the business income they report as a self-employed seller. Guessing at merch economics is how good drops still lose cash, and this tool is built to end the guessing. A merch line should fund the next one, not quietly drain the account it was meant to fill, and clear per-SKU numbers are how you keep it on the right side of that line.

If you sell merch through a card reader at shows or an online store, the platform that processes those payments reports them to the IRS on Form 1099-K. The IRS page Understanding your Form 1099-K describes that form as a summary of the payments you received for goods or services during the year. It is a gross figure. It counts the full price a fan paid, not the cost of the shirt, the print run, or the processing fee. If you only ever see that platform total, it is easy to think you earned far more from merch than you actually kept.

The Merch Margin & Inventory Planner helps because it already holds the cost side of every sale. For each SKU you record what the item cost you and what it sold for, so you can move from a gross 1099-K number to a real margin without digging through invoices. When the form arrives, you can compare the reported total against your own record of units sold at their prices, confirm the two line up, and hand your accountant the cost of goods that turns a scary top-line figure into a defensible profit.

There is a reconciliation benefit as well. Sell-through counts in the Merch Margin & Inventory Planner tell you how many units actually moved, which you can check against the sales volume behind a 1099-K. If the platform total looks high, the mismatch might be refunds, a fee the processor withheld, or sales that crossed a year boundary. Because the tool keeps units, prices, and costs per SKU, you have the detail to explain the gap in a sentence rather than guessing at why the numbers differ. That same detail is what your accountant needs to record cost of goods correctly instead of taxing you on a gross figure.

None of this is tax advice, and the planner does not file anything. What it gives you is the cost and volume record that makes a 1099-K a quick reconciliation instead of a source of dread. When you sell across more than one platform, each sending its own form, having one place where every SKU already lives saves you from rebuilding the year by hand. You can read how the tool structures that record on the product overview. A single reconciled view beats three platform statements that each tell only part of the story, and it is ready the moment the form arrives.

The takeaway is steady and simple. The reporting thresholds for 1099-K have dropped, so more creators than ever will receive one for even a modest merch line. A seller who tracks cost, price, and units sold per SKU all year can meet that form with matching numbers and report a true margin. A seller who only sees the platform gross is left either overpaying or unable to explain the figure. Keeping the planner current is the cheaper and calmer habit every filing season, and it costs you a minute at each drop rather than a lost weekend in the spring.

Merch data may feel less sensitive than tax records, but it still deserves care. Your SKU list, your costs, your margins, and your sales volumes describe how your business actually works, and that is information a competitor or a bad actor would find useful. The FTC guide Protecting Personal Information: A Guide for Business lays out a plain way to protect business information, built around holding only what you need, locking down what you keep, and having a plan for the day something goes wrong. Those same ideas fit a small merch operation well.

The Merch Margin & Inventory Planner is designed to hold a narrow set of data. It needs your SKUs with cost, price, sold, and on-hand counts, and it produces margin and reorder reports. It does not need a fan database, mailing addresses, or card numbers to do its work, so there is far less sensitive personal information sitting in it than there would be in a full store platform. Keeping the record narrow is the first safeguard the FTC recommends, and here you get it without extra setup.

Access is the next piece. Your pricing and margin figures are a real part of your competitive position, and the Merch Margin & Inventory Planner is built so the people who see them are the ones you choose to bring in, such as a partner or a bookkeeper. When you share a margin or reorder report, you are handing over a defined output rather than open access to your whole cost structure, which keeps the sensitive detail contained. If a helper only needs the reorder list, that is all they have to receive, not your full markup on every item.

The honest boundary applies here too. A tool can protect the data it holds, but it cannot protect a cost sheet you paste into an open chat or a shared drive with no password. That human layer is exactly what the FTC guidance addresses, and it works best alongside a tool that keeps your merch numbers in one deliberate place instead of scattered across spreadsheets, POS exports, and screenshots. Fewer copies means fewer places a leak can start. A cost file that lives in six inboxes is six chances for it to end up somewhere you did not intend, so consolidating the record is itself a protective step.

For creators and small brands, this matters because your merch data often lives on the same phone and laptop as everything else you run. A planner that stores only what it needs and shares by report rather than by open door is a safer home for your cost and margin figures than a folder of loose files. You can see how the tool fits the wider creator toolset on the creators & agencies hub, and read the FTC guidance for the human habits that keep the whole thing locked down. The tool handles its part by holding little and sharing narrowly, and you handle yours by keeping the copies few and the passwords real.

Most merch lines are run on two things, a spreadsheet and the reports that come out of a POS system. Each does part of the job and neither does all of it. A POS report tells you what sold, but it rarely knows your true unit cost, so it cannot tell you margin. A spreadsheet can hold cost, but you have to build every formula, update sold and on-hand counts by hand, and remember to check reorder points yourself. Between the two, the answer to a simple question, is this item making money, takes more work than it should.

The Merch Margin & Inventory Planner closes that gap by holding cost, price, sold, and on-hand together per SKU and doing the math for you. Margin and sell-through compute themselves, reorder points flag before you run out, and dead stock surfaces on its own list instead of hiding in a POS export you never scroll to the bottom of. The tool does one job, turning your merch numbers into pricing and reorder decisions, and it does that job the same way every drop.

There is a records benefit too. As a self-employed seller, your merch costs and sales are also tax records, and the IRS self-employed individuals tax center expects you to keep books that support the income you report. A POS report and a hand-built spreadsheet that anyone can overwrite make a weak record. A structured per-SKU log that keeps cost, price, and units together is a strong one, and it is the same data you need to reconcile a payout or a year-end form later. Building that record as you sell, rather than reconstructing it at tax time, is far less work and far less error-prone.

This does not mean your POS or your spreadsheet disappears. The POS still runs the sale at the table, and a spreadsheet is still fine for a quick what-if before a drop. What changes is where the real margin and inventory decisions get made. The planner is the layer that turns raw sales exports and cost notes into a clear answer about what to reprice, reorder, or clear, which is exactly what a spreadsheet and a POS report leave you to work out by hand every single time.

The switch is meant to be light. You are not adopting an accounting suite or migrating history. You enter SKUs the way you already think about your merch, and let the planner keep the margins and reorder flags current. If you have ever stared at a POS export knowing something was not selling but unable to say which item was quietly losing money, that is the exact problem the Merch Margin & Inventory Planner is built to solve. You already do the selling and you already know your designs. The tool adds the one thing a spreadsheet and a POS report leave out, which is a straight answer about which SKUs to reprice, reorder, or clear. Start with the product overview to see the per-SKU view.

This is a fair question, and the honest answer sets a clear boundary. The Merch Margin & Inventory Planner is a money and stock tool. It handles unit cost, price, margin, sell-through, reorder points, and dead stock per SKU. It does not manage the rights to the artwork printed on your merch, and it does not register or track your designs. Those designs are still valuable, though, and it helps to understand where they stand even while you use the planner strictly for the numbers.

The artwork on a shirt, a poster, or a hat is usually an original creative work, and under U.S. law that kind of work carries copyright protection. The U.S. Copyright Office page What is Copyright? explains that copyright attaches automatically once an original work is fixed in a tangible form, which for merch means the moment your design exists as a file or a printed piece. Registration is a separate step that adds enforcement and statutory-damage rights, but the underlying protection begins on its own.

Why raise this in a planner that only tracks margins. Because the two connect in practice. When you decide, based on the tool’s margin and sell-through numbers, which designs to reprint and which to retire, you are making business calls about creative works you own. Knowing that each design is your protected property can change how you treat a strong seller, for instance by keeping the rights clear before licensing it or before letting a print partner run the file again on another job. A best-selling design is both your most profitable SKU and your most valuable piece of intellectual property, and it pays to see it as both at once.

The Merch Margin & Inventory Planner keeps its lane on purpose. It does one job well, telling you which SKUs earn their place and which tie up cash, rather than pretending to be a rights manager it is not. For the money side, the tool gives you margin, reorder, and dead-stock views per item. For the rights side, the Copyright Office guidance is the plain place to start, and a lawyer is the right call once real money or a license is on the table. Trying to force one tool to do both jobs usually means it does neither well, so the planner stays focused on the numbers you check every drop.

The practical framing is this. Track the economics of your merch line in the planner so every drop makes money and does not sit in unsold boxes, and treat the artwork as the protected creative asset it already is. The two together, sound margins on well-managed inventory and a clear understanding of the copyright in your designs, put a creator on far steadier ground than a POS export and a hopeful guess. Money you can measure and art you can protect are the two halves of a merch line that lasts more than one season. Learn how the tool handles the numbers on the creators & agencies hub.