Whatnot Bookkeeping and Inventory Tracking for Sellers

Whatnot bookkeeping is the unglamorous part of live selling that decides whether you actually know if you are making money. A busy show with lots of bids can feel like a success and still lose money once you account for what the items cost, the fees, the mailers and the giveaways. Good records turn that guesswork into numbers you can act on.

The good news is that you do not need accounting expertise or expensive software to start. A simple spreadsheet with three tabs covers inventory tracking, per-show sales and expenses for most new sellers. This guide shows you how to set up a Whatnot spreadsheet, how to handle cost of goods for lots and collections, how to reconcile with payouts, and what accounting habits make tax time easier. It is general information, not tax advice; consult a qualified professional for your situation.

Why Bookkeeping Matters for Whatnot Sellers

Bookkeeping does three jobs for a live seller:

• It tells you what is profitable. Which categories, price points, formats and show times actually make money after all costs?
• It protects your cash flow. Knowing what you have spent, what is in transit as payouts and what you need for the next inventory buy prevents nasty surprises.
• It makes taxes manageable. In the US, profit from selling is taxable income whether or not you receive a 1099-K. Without records of what you paid for inventory, you may struggle to show your real profit. The Whatnot 1099 and taxes guide explains the reporting basics.

Sellers who track their numbers can make decisions like "drop the Tuesday show and add a Saturday one" or "stop buying this type of lot" based on evidence. That is often what separates shops that improve from shops that stall.

How to Set Up a Whatnot Spreadsheet

A three-tab spreadsheet is enough to start. Use any spreadsheet app you like.

Tab 1: Inventory

Tab 2: Sales by show

Tab 3: Expenses

Record every non-inventory cost with date, vendor, category, amount and a note. Useful categories include shipping supplies, giveaways (item cost plus shipping you pay), equipment, promotion such as Boost, software and subscriptions, grading fees, travel for sourcing and seller-paid shipping. Keep the receipt for each line.

Whatnot Inventory Tracking: Practical Systems

A spreadsheet is only useful if it matches what is physically on your shelves. These habits keep them in sync.

1. Log items when they arrive, not when you list them. Sourcing day is when you know the cost.
2. Label everything with its ID. Sticky labels on bags, sleeves or bins make it quick to find sold items.
3. Organize by show. Pull items for an upcoming show into a dedicated bin and mark their status as "listed."
4. Update status right after each show. Mark items sold, given away or unsold and returned to stock.
5. Count periodically. A monthly or quarterly physical count catches lost, damaged or mislabeled items.
6. Track aging inventory. Sort by purchase date to spot stock that has sat too long. Decide whether to discount, bundle or move it to another channel.

If you sell on several platforms, a single master inventory list is essential to avoid selling the same item twice. See selling on Amazon and Whatnot and cross-listing Whatnot for multi-channel tracking.

How to Handle Cost of Goods for Lots and Collections

Many Whatnot sellers buy in bulk: binders of cards, boxes of comics, bags of clothing, pallets. To know the profit on each item, you need to allocate the lot's cost across its contents. Two common approaches:

Even split

Divide the total cost by the number of items. A hypothetical $200 lot of 100 items becomes $2 per item. Simple, but it understates the cost of valuable items and overstates the cost of cheap ones.

Value-weighted split

Allocate cost in proportion to each item's estimated resale value. In the same hypothetical lot, if one card is expected to sell for $100 and the lot's total expected resale is $500, that card carries 20% of the cost, or $40. This gives a more realistic profit per item.

Whichever method you choose, apply it consistently and record the allocated cost for every item. For bulk items that you sell in small groups, you can track cost per group instead of per piece. Ask a tax professional which method is appropriate for your records.

Recording items you keep, give away or damage

Not every item from a lot ends up sold. Some you keep for your personal collection, some become giveaways and some arrive damaged. Mark each with its status in the inventory tab rather than deleting it. Items used as giveaways belong in your giveaway expenses for that show, and items you keep personally should be removed from business inventory so their cost does not distort your profit numbers.

Per-Show and Monthly Profit Reports

Once your tabs are set up, a simple summary turns data into decisions. For each show, calculate:

• Total item sales
• Total Whatnot fees
• Total cost of goods sold
• Giveaway cost for that show
• Supplies used (estimate per order if needed)
• Show profit = sales minus fees, cost of goods, giveaways and supplies
• Profit per hour = show profit divided by total hours, including prep and packing

Monthly, add overhead such as equipment, software and promotion to get a true monthly profit. Compare months to spot trends. Whatnot's own seller analytics can complement your spreadsheet with viewer and engagement data; see Whatnot seller analytics.

Here is a hypothetical monthly summary to show the structure, not a typical result:

Reconciling With Whatnot Payouts

Your bank deposits will not match your sales on any given day. Proceeds generally become available after orders ship or are delivered and processing clears, and payouts then go to your linked bank account, with optional faster payouts sometimes available for a fee. Timing details are in the Whatnot payouts guide.

Once a month, reconcile:

1. Total net sales in your spreadsheet for the month
2. Payouts received in your bank account
3. Any amounts pending, refunded or adjusted

Differences usually come from timing, refunds, instant payout fees or orders that spanned month-end. Investigate anything you cannot explain. Refunds and cancellations should be recorded against the original sale; see Whatnot refunds and returns.

Whatnot Accounting Habits That Save You at Tax Time

• Use a separate bank account for all business income and expenses.
• Keep receipts for inventory, supplies, equipment and services, digitally if possible.
• Set aside a percentage of each payout for taxes. A tax professional can help you choose a sensible amount.
• Record giveaways and damaged items so their cost is captured.
• Back up your spreadsheet regularly.
• Know the reporting thresholds. The federal 1099-K threshold is commonly reported as more than $20,000 and more than 200 transactions per year after the 2025 change, with lower thresholds in some states. Profit is taxable regardless.
• Understand sales tax. Whatnot generally collects and remits sales tax on buyer purchases in US states that require it, but rules for sales outside Whatnot differ. See Whatnot sales tax.
• Consider your business structure as you grow. Read do you need an LLC to sell on Whatnot.

When volume grows or you add employees and channels, accounting software or a bookkeeper may become worthwhile. Choose tools that categorize expenses and produce a profit and loss statement your tax professional can use.

Common Whatnot Bookkeeping Mistakes

• Tracking sales but not costs. Revenue alone says nothing about profit. Every item needs a cost.
• Forgetting giveaways. Giveaway items and their shipping are real expenses. Log them per show so you can see whether they pay back in sales.
• Mixing personal and business purchases. Buying inventory on a personal card alongside groceries makes it hard to separate later.
• Estimating fees instead of using actual data. Bundled orders, shipping and tax all change processing totals.
• Updating records "later." A month of unrecorded shows is hard to reconstruct. Update after every show while it is fresh.
• Ignoring unsold inventory. Money tied up in stock that does not move is a cost too. Review aging items monthly.
• Not counting your hours. Profit per hour is one of the most useful numbers a seller can know, and it requires tracking time.

Choosing Bookkeeping Tools as You Grow

A spreadsheet can carry a small shop a long way. Signs it may be time for something more include several hundred orders a month, more than one sales channel, employees or contractors, a growing inventory that is hard to count, or an accountant who asks for a particular format.

When evaluating tools, look for the ability to categorize income and expenses, attach receipts, produce profit and loss reports, connect to your business bank account and export data your tax professional can use. For inventory, look for SKU support, quantity tracking and, if you sell on multiple platforms, a way to keep stock levels in sync. Try free trials with a month of real data before committing. The guide to third-party Whatnot seller tools covers how to evaluate apps that connect to your shop, and the guide to scaling a Whatnot business explains how bookkeeping fits into larger operations.

Next Steps

Set up your three-tab spreadsheet before your next show, label your inventory with IDs and log every expense from today forward. Then use your first month of data to calculate real profit per show. To see how this data feeds into earnings planning, read how much Whatnot sellers make and the full make money on Whatnot playbook. If you are still at the stage of building your sourcing and business plan, the free Marketplace SuperHeroes workshop offers a structured, beginner-friendly overview at no cost.