How do I handle returns and refunds in my e-commerce bookkeeping without a mess?
The mess happens when refunds get recorded inconsistently or not at all. A sale comes in during March, the customer returns the item in April, and now your March revenue is overstated and April looks worse than it actually was. Multiply that by dozens of returns per month and your financial reports stop meaning anything.
The right way to handle refunds is with a contra-revenue account, sometimes called Sales Returns and Allowances. When you issue a refund, you don’t go back and delete the original sale. Instead, you record the refund in this separate account that offsets your gross revenue. This keeps a clear record of how much you actually sold and how much came back. Your net revenue reflects reality, and you can see your return rate at a glance, which is a number every e-commerce seller should be watching.
Platform fees are where most people lose money without realizing it. When you sell a $50 item on Amazon and the customer returns it, Amazon refunds the customer $50 but does not refund you the full referral fee or FBA fee they charged on the original sale. You might get a partial fee credit, but you’re still out a few dollars on every return. If you’re not tracking this, those lost fees add up to hundreds or thousands over a year. The same applies to Shopify payment processing fees. When you refund a customer, Stripe or Shopify Payments does not return the transaction fee to you.
Partial refunds and exchanges need their own treatment. A partial refund reduces revenue by only the refunded amount. An exchange where the customer swaps for a different item might not involve any revenue change at all, just an inventory adjustment. Lumping these together with full refunds makes your numbers unreliable.
Timing is the other big challenge. Your platform batches payouts, so a refund issued on the 28th might not show up in your bank account until the following month. If you’re doing cash-basis bookkeeping based on bank deposits, the refund hits a different period than when it actually happened. Reconciling your platform payout reports against your bank deposits every month catches these discrepancies before they snowball.
Build a habit of downloading your settlement reports from Amazon Seller Central, Shopify, or whatever platform you use at the end of each month. These reports break down every sale, refund, fee, and adjustment. Match them against what actually landed in your bank account. The difference between those two numbers tells you exactly what fees and refunds are floating in between.
If your return volume is high enough that this takes hours every month, that is a sign you need help. Our bilingual bookkeeping services include reconciling platform payouts so your revenue, fees, and refunds all land in the right accounts. Getting this right means your profit numbers are real, your tax filings are accurate, and you can actually trust your reports when making business decisions.
Central Florida's Trusted Bookkeeping Firm
Start Here:
A 30-Minute Consultation
Tell us about your business and what's going on with your books. We'll figure out exactly what you need, and give you a straightforward quote.
More Questions
What's the best way to connect Shopify to QuickBooks Online without double-counting sales?
Skip the native Shopify-QBO sync. Use a summarization tool like A2X or Klayena that posts daily sales summaries as clean journal entries, breaking out gross sales, discounts, refunds, shipping, taxes, and fees properly.
Read answerHow do I handle payroll bookkeeping for a security company with staff at multiple job sites?
Track every hour by job site using classes or locations in QuickBooks so you can see labor costs per contract. This lets you compare what you're paying guards at each site against what you're billing the client.
Read answerHow do I separate bookkeeping when I have rental properties in different LLCs?
Each LLC needs its own bank account, credit card, and set of books. Keeping finances completely separate is what preserves the liability protection you created the LLCs for in the first place.
Read answerShould I open separate bank accounts for each fix-and-flip project?
Yes. A dedicated checking account per project keeps tracking clean and makes profit calculation straightforward. All purchase costs, renovation expenses, holding costs, and sale proceeds flow through one account so you can see exactly how a deal performed.
Read answerHow does Florida's reemployment tax work and what do I need to track as a small employer?
Florida's reemployment tax is paid by employers on the first $7,000 of each employee's wages per year. New employers start at a 2.7% rate, and the rate adjusts annually based on your unemployment claims history.
Read answerIs QuickBooks auto-categorization reliable or is it messing up my books?
It's useful as a starting point but not reliable enough to accept without review. QuickBooks frequently miscategorizes new vendors, split transactions, and transfers between accounts, which can quietly distort your financial statements.
Read answer

