Crafter Story

How to Set Up Simple Bookkeeping for Your Marketplace Shop

By

Crafter Story Team

in

Sellers who track income and fees separately, every week, catch pricing problems in weeks instead of at tax time.

Get New Seller Stories First

Real stories from real marketplace sellers, straight to your inbox.

Table of Contents

Introduction

Most marketplace sellers find out their real profit margin the hard way: at tax time, when a folder of receipts and a year of platform statements finally get added up. By then it’s too late to fix a pricing mistake that’s been quietly running for eleven months. Here’s exactly what to set up instead: a separate business account, a simple categorized ledger, and a weekly ten-minute habit that keeps your numbers current instead of a year behind.

Why “I’ll Just Check My Marketplace Dashboard” Falls Short

Most sellers assume their marketplace’s own sales dashboard is close enough to bookkeeping. It isn’t.

A platform dashboard shows gross sales, not what actually lands in your bank account after listing fees, transaction fees, payment processing, and shipping labels are subtracted. A dashboard tells you what buyers paid. Bookkeeping tells you what you actually kept. Those two numbers can differ meaningfully once every fee line is accounted for, and the gap is invisible until you sit down and calculate it directly, the same way you’d work through true profit margins after marketplace fees.

The Core Idea: Separate, Then Categorize

Bookkeeping for a small marketplace shop comes down to two habits repeated consistently: keeping business money apart from personal money, and sorting every transaction into a category the moment it happens.

Everything else in this guide, spreadsheets, software, receipt folders, is just a way to make those two habits easier to sustain. Skip either one and no tool will save you from a messy year-end.

Step-by-Step: Building Your System

Here’s how to go from “I have a shoebox of receipts” to a system you can trust in under an hour of initial setup.

Step 1: Open a Dedicated Business Bank Account

What: Open a bank account used only for your shop, separate from your personal checking account.

Why: Mixing personal and business transactions in one account is the single biggest reason sellers can’t answer “am I actually profitable?” without hours of manual sorting. The U.S. Small Business Administration recommends opening a business bank account as soon as a business starts operating, noting that it keeps finances organized and simplifies taxes even for sole proprietors who aren’t legally required to separate accounts.

How: Most banks and credit unions offer a free or low-fee business checking account for sole proprietors; you’ll typically need your name, address, and either an EIN or your Social Security number, depending on how your shop is structured. Route your marketplace payouts into this account and pay all shop expenses, materials, shipping, ads, out of it.

Example: A seller who moved payouts from a personal account into a dedicated business account cut their year-end bookkeeping cleanup from a full weekend to about two hours, because every transaction in that account was already a shop expense by definition.

Step 2: Pick One Ledger Method and Commit to It

What: Choose either a spreadsheet or dedicated bookkeeping software as your single source of truth, and stop tracking numbers anywhere else.

Why: Sellers who split tracking between a notes app, a mental estimate, and an occasional spreadsheet lose the thread within a month. One ledger, updated consistently, beats three tools updated occasionally.

How: A free spreadsheet template works fine for a shop under a few thousand dollars a month in sales. Once volume grows, dedicated e-commerce bookkeeping software that connects directly to your marketplace account saves the manual entry. Either way, set up columns for date, platform, gross sale amount, fees, shipping cost, materials cost, and net amount.

Step 3: Log Every Sale and Fee, Not Just the Payout

What: Record each individual sale’s gross amount and every fee subtracted from it, rather than just the final deposit amount that lands in your bank account.

Why: Marketplace payouts arrive as a lump sum covering multiple orders and fee types. If you only log the deposit total, you lose the ability to see which fees are actually eating your margin, listing fees versus transaction fees versus advertising spend. Etsy’s own Seller Handbook guidance on tracking business expenses recommends recording expenses regularly rather than reconstructing them later, and treats platform fees as a standard deductible business expense category to track alongside materials and shipping.

How: Download your itemized statement or fee breakdown from your marketplace’s seller dashboard rather than relying on the deposit summary alone. Most platforms provide a CSV export of individual order fees; import that directly into your ledger instead of retyping numbers by hand.

Fee categories and deduction rules vary by marketplace and by your local tax jurisdiction. This guide covers general bookkeeping organization, not specific tax advice; confirm what’s deductible for your situation with a licensed tax professional.

Step 4: Categorize Every Expense as You Go

What: Assign each expense to a specific category, materials, packaging, shipping, software subscriptions, advertising, the day it happens, rather than in a batch later.

Why: Batch categorizing months of receipts at once is where most sellers give up on bookkeeping entirely. Categorizing in the moment takes seconds; reconstructing it later from a pile of statements takes hours and introduces guesswork.

How: Keep your categories short and consistent, five to eight total is usually enough for a small shop. Every time you buy materials or pay for shipping labels, log it immediately in the same sitting, before the receipt gets lost or the memory of what it was for fades.

Step 5: Reconcile Weekly, Not Yearly

What: Set a recurring ten-to-fifteen-minute weekly appointment to match your ledger against your actual bank statement and marketplace payouts.

Why: A small discrepancy caught weekly takes two minutes to trace. The same discrepancy discovered eleven months later, buried under hundreds of other transactions, can take an entire afternoon and sometimes never gets fully explained. The IRS’s own guidance on good recordkeeping frames consistent, regular recordkeeping as the foundation that makes both financial decision-making and tax filing easier, rather than something to reconstruct once a year.

How: Pick a fixed day, Sunday evening or the first slow hour of your week, and treat it as non-negotiable. Compare your ledger’s running total against your bank balance and your platform’s payout report for the same period.

Step 6: Set Aside Records for Tax Time as You Build Them

What: Keep digital or physical copies of receipts, invoices, and platform fee statements organized by month as you generate them, rather than searching for them later.

Why: Supporting documentation is what turns a bookkeeping ledger into something you can actually defend if a claimed expense is ever questioned. The IRS notes that business records should generally be kept for at least three years from the date a return was filed, longer in specific situations like underreported income or unfiled returns.

How: A single folder per calendar year, digital or physical, with monthly subfolders for receipts and statements, is enough for most small shops. Scan paper receipts as you get them; faded thermal receipts often become unreadable within months.

Common Mistakes and Advanced Habits

  1. Treating your marketplace payout as your income. Your income is the payout minus every fee already subtracted before it landed in your account. Tracking the payout alone overstates your real earnings.
  2. Waiting for tax season to categorize anything. By the time a full year of transactions needs sorting at once, most sellers either pay someone else to untangle it or give up partway through and estimate.
  3. Keeping business and personal expenses in one account “just for now.” This habit rarely gets fixed later; it tends to compound instead.
  4. Ignoring small recurring costs. A $12 monthly app subscription or a $6 packaging supply reorder feels too small to log, but a dozen of these add up to a meaningful chunk of your actual expenses by year-end.
  5. Not reviewing the numbers at all once they’re logged. Bookkeeping that’s recorded but never reviewed still leaves you guessing about which products or platforms are actually profitable, the same blind spot covered in 7 pricing mistakes that are quietly costing marketplace sellers money.

Tools and Resources

  • Business checking account: the foundation everything else depends on; most banks offer one free for sole proprietors.
  • Spreadsheet template: free and sufficient for shops under roughly a few thousand dollars a month in sales; build one with columns for date, platform, gross amount, fees, and net.
  • E-commerce bookkeeping software: paid options that connect directly to marketplace accounts and auto-import fees once sales volume makes manual entry too time-consuming.
  • Marketplace fee/CSV export: found in your seller dashboard’s payment or finance section; the most accurate source for itemized fee data, more reliable than the payout summary alone.
  • Digital receipt folder: a single cloud folder organized by year and month, so records exist before they’re needed rather than being reconstructed after the fact.

A Realistic Example

Picture a seller running a small jewelry shop who, for the first year, tracked only the weekly deposit amount from their marketplace in a personal checking account. At tax time, they couldn’t separate materials costs from shipping costs, and had no record of which months were actually profitable versus which just felt busy.

The following year, the seller opened a dedicated business account, built a simple four-column spreadsheet, and set a Sunday evening reminder to log the week’s sales and expenses. Within two months, the numbers showed one product line was consistently priced below its true cost once shipping and fees were included, a gap that had been invisible in the payout total alone. Fixing that one listing’s price, informed by the same method covered in how to calculate true profit margins after marketplace fees, recovered more margin in a single quarter than the entire bookkeeping habit cost in time.

Frequently Asked Questions

Do I need accounting software, or is a spreadsheet enough?

A spreadsheet is enough for most small shops, especially early on. Consider dedicated software once manual entry starts taking more than fifteen to twenty minutes a week, or once you’re selling across more than one marketplace and want fees pulled in automatically.

How much does marketplace bookkeeping software typically cost?

Pricing varies widely by provider and by how many sales channels you connect, and rates change over time. Check current pricing directly on each provider’s own pricing page before choosing one, rather than relying on a figure quoted elsewhere.

Do I need a separate business bank account if I’m just a hobby seller?

If you’re selling with the intent to make a profit rather than as an occasional hobby, treating it as a business from the start, including a separate account, makes the transition to a larger operation much smoother later. Whether your specific activity counts as a hobby or a business for tax purposes depends on your situation; a tax professional can help you determine that.

What’s the most common bookkeeping mistake new sellers make?

Logging only the marketplace payout total instead of the itemized sale and fee breakdown behind it. This hides exactly which fees and costs are cutting into margin.

How often should I actually update my books?

Weekly is the sweet spot for most small shops: frequent enough that reconciling takes minutes, infrequent enough that it doesn’t feel like a daily chore.

Do I need to track every single small expense, even a $5 purchase?

Yes, small recurring costs add up over a year and matter for an accurate profit picture. Skipping them is one of the more common ways sellers underestimate their true costs.

Is this guide giving me tax advice?

No. This is general bookkeeping organization guidance, not legal, tax, or financial advice. Confirm deduction rules, entity structure, and filing requirements with a licensed tax professional for your specific situation.

How long should I keep my business records?

General guidance from the IRS suggests keeping records for at least three years from when a return was filed, with longer periods required in specific situations. Confirm the exact retention period that applies to you with a tax professional, since it depends on your circumstances.

Can I use the same system if I sell on more than one marketplace?

Yes, and it’s especially useful there. Add a platform column to your ledger so you can see fees and net profit broken out by marketplace, which also helps if you’re deciding which marketplace is right for your product.

What if I’ve already fallen behind on a year of bookkeeping?

Start the weekly habit now rather than waiting to catch up on the backlog first. Set aside a separate block of time to reconstruct the missed period using your bank and marketplace statements, but don’t let that catch-up project delay starting the going-forward system.

Does a payment dispute or chargeback need to be logged differently?

Yes, log it as its own line item rather than folding it into your regular sales total, since it directly reduces income you may have already counted. If you’re dealing with an active dispute, see how to handle a chargeback or payment dispute for the process itself.

Key Takeaways

  • Open a dedicated business bank account before building anything else.
  • Log itemized sales and fees, not just the lump-sum payout deposit.
  • Categorize each expense the moment it happens, not in a year-end batch.
  • Reconcile your ledger against your bank and marketplace statements weekly.
  • Keep supporting receipts and statements organized by month as you go.
  • This is bookkeeping organization, not tax advice; confirm deduction and filing rules with a professional.
  • A consistent weekly habit beats an elaborate system used inconsistently.

The Bottom Line

A good bookkeeping habit tells you, in real time, whether your shop is actually making the money your marketplace dashboard makes it look like it’s making. Start by opening a dedicated business account this week, then build a basic ledger with gross sale, fees, and net columns before your next payout arrives. Once that’s running, Calculate your true profit margins after marketplace fees to see exactly where the weekly habit pays off.

About This Research

Crafter Story Team is the in-house editorial team behind Crafter Story, a publication built around real, submitted stories from marketplace sellers on Etsy, eBay, Amazon, and similar platforms.

This guide draws on publicly available seller resources, including marketplace expense-tracking guidance and IRS and SBA recordkeeping publications, rather than on a single proprietary data set. It is general informational guidance, not legal, tax, or financial advice.

Content reviewed and updated: 2026-09-30

Inspired By This Story?

Join the newsletter for more real seller stories.

More posts