Whatnot Bookkeeping Workflow Example for Sellers

A busy show can produce dozens or hundreds of orders, but your bank balance will not tell you whether that show actually made money. Payout timing, seller fees, shipping charges, inventory costs, refunds, and operating expenses all affect the number that matters: net profit. This Whatnot bookkeeping workflow example shows how to turn weekly selling activity into records you can trust without spending Sunday night fixing a spreadsheet.

The goal is not complicated accounting. It is a repeatable process that answers practical questions quickly: What did I sell? What did Whatnot deduct? What did the inventory cost me? What did I keep after expenses? Once those numbers are organized consistently, tax preparation and business decisions get much easier.

The Whatnot Bookkeeping Workflow Example

Use this workflow on the same day every week. Weekly bookkeeping keeps the work small, catches issues while the details are fresh, and gives you a current view of your business instead of a surprise at tax time.

1. Import your Whatnot sales and earnings data

Start with the earnings CSV for the period you are reconciling. Your sales records should capture the order date, item sold, gross sale amount, seller fees, payment processing charges, shipping-related amounts, refunds, and the net earnings associated with each order.

Do not record only the payout that reaches your bank account as sales income. A payout is the result after deductions, and it may include activity from multiple selling days. If you book the deposit as revenue, you lose visibility into what Whatnot charged and what each show produced.

For example, say you ran two shows during the week and generated $2,400 in gross sales. Whatnot deducted $320 in seller and processing fees, while shipping adjustments and refunds reduced proceeds by another $180. Your earnings data may show net proceeds of $1,900. Record the gross sales and deductions separately so you can see the cost of selling, not just the final deposit.

2. Match every sale to inventory cost

Sales data tells you revenue. It does not tell you profit until you add cost of goods sold, often called COGS. For each item sold, attach the amount you paid to acquire it.

If you bought a sealed trading card collection for $1,000 and assigned $10 of cost to each of 100 cards, a card that sells for $28 has a $10 inventory cost. Its gross margin is $18 before marketplace fees, shipping costs you absorb, and other expenses.

This step depends on how you source inventory. Sellers who buy clearly priced single items can record an exact cost per item. Sellers who buy bulk lots, mystery pallets, or collections need a consistent allocation method. You might allocate cost evenly by item, by estimated resale value, or by category. There is no single allocation method that fits every reseller, but changing methods whenever it benefits a particular sale makes reporting unreliable. Pick a reasonable method, document it, and use it consistently.

3. Categorize deductions and business expenses

Keep platform deductions separate from expenses you pay outside Whatnot. Platform fees and payment processing charges belong with the transaction data because they are directly tied to sales. Other costs should be categorized by what they are: inventory purchases, packaging supplies, postage you paid separately, storage, software, advertising, equipment, and professional services.

For a simple weekly record, you may have these numbers:

• Gross Whatnot sales: $2,400
• Whatnot seller and processing fees: $320
• Refunds and shipping adjustments: $180
• Cost of goods sold: $900
• Packaging supplies: $45
• Storage and software: $75

That produces $880 in net profit for the period: $2,400 minus $320, minus $180, minus $900, minus $45, and minus $75.

The distinction matters. If you lump every cost into one general expense category, you cannot tell whether a weak week came from lower margins, unusually high refunds, expensive inventory, or rising operating costs. Good bookkeeping is not just for filing taxes. It shows where the business needs attention.

4. Reconcile the payout to your bank account

After recording sales and deductions, match the payout reported by Whatnot to the deposit that appears in your bank account. The amount should generally agree, but timing can differ. A payout may be initiated at the end of one week and arrive in the next, especially around weekends or bank holidays.

When the numbers do not match, check for a refund processed after the report date, a previous-period adjustment, multiple payouts grouped in one deposit, or a duplicated import. Do not force the reconciliation by changing sales figures to match the bank. Find the source of the difference and record it properly.

A clean reconciliation gives you confidence that your records reflect real cash movement. It also helps catch duplicate entries before they inflate revenue or expenses.

A Weekly Workflow That Takes Less Time

The best bookkeeping process is the one you can repeat after a long week of sourcing, listing, and live selling. Save receipts as you spend, not weeks later. Keep inventory purchases in one place with the purchase date, supplier, total cost, and a note about how you will allocate that cost across items.

Then set one recurring appointment each week. Import the latest earnings data, review exceptions such as refunds or shipping adjustments, add outside expenses, confirm inventory costs, and reconcile completed payouts. Finish by reviewing your profit-and-loss report for the week and month to date.

Purpose-built tools reduce the manual work here. Whatprofits is built by a Whatnot seller, for Whatnot sellers, and can import earnings CSV files, calculate key deductions, organize expenses and inventory margins, and produce reports without rebuilding the same spreadsheet formulas every week. Automation helps, but you still need to review source data and keep receipts. Software can calculate quickly; it cannot know that a bulk purchase was assigned to the wrong inventory batch.

Common Mistakes This Workflow Prevents

The most expensive bookkeeping errors are usually small ones repeated over time. Recording payouts as sales hides fees. Tracking inventory purchases only when cash leaves your account can distort a month when you buy a large collection but sell it over several months. Ignoring shipping adjustments makes certain shows look more profitable than they were.

Another common issue is mixing personal and business spending. If you use one card or bank account for both, bookkeeping becomes a scavenger hunt. A separate business checking account and card make reconciliation faster and create a cleaner record for your accountant. If you are not ready for a full business account, at least use a dedicated card for selling-related purchases and reimburse yourself with clear notes.

Tax treatment also depends on your location and business structure. Sellers in states with sales tax obligations, and international sellers working with VAT or GST, may need additional settings and records. The workflow stays the same, but the categories and reports need to reflect your actual obligations. When the numbers become material or your setup gets complicated, bring in a qualified tax professional rather than guessing.

Use the Numbers Before the Next Show

Bookkeeping becomes valuable when it changes what you do next. Review profit by show, category, and inventory source. If a category produces strong gross sales but weak margins after fees and shipping, raise starting prices, bundle items differently, or source at a lower cost. If a show had an unusual number of refunds, look at listing accuracy, condition descriptions, and fulfillment practices.

You do not need perfect data on day one. You need a workflow that is accurate enough to guide decisions and consistent enough to improve over time. Start with the next completed selling week, record the real costs behind each sale, and let your profit number tell you what is working.