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
How do I track 1099 contractor payments across multiple rehab projects?
Set up each rehab property as a separate project in your accounting software and assign every contractor payment to both the vendor and the project. This gives you job-level costs for profitability and vendor-level totals for 1099 filing.
Read answerDo I need to collect Florida sales tax if I run an online business from my home?
If you're selling taxable goods from Florida, yes. Operating from your home still creates sales tax nexus in the state. Whether you actually need to collect depends on what you sell, since Florida taxes tangible products but most services are exempt.
Read answerHow do I track raw materials vs finished goods in QuickBooks for a small manufacturer?
Set up separate sub-accounts under your Inventory Asset account for raw materials and finished goods, create individual inventory items mapped to each, and use inventory assemblies or a third-party app to move costs from materials to finished products when you build.
Read answerWhat are the most common bookkeeping mistakes restaurant owners make in their first year?
The biggest mistakes include mixing personal and business finances, not tracking food costs at the item level, falling behind on sales tax, and failing to reconcile POS reports with bank deposits. Most of these are preventable with the right systems from day one.
Read answerWhat are the benefits of working with a bookkeeper who understands both English and Spanish business documents?
A bilingual bookkeeper correctly interprets and categorizes documents in both languages without relying on translation tools. This improves accuracy, speeds up your monthly close, and ensures nothing gets misclassified because a document wasn't fully understood.
Read answerWhat financial reports does a lender want to see from a rental property investor?
Lenders typically want a profit and loss statement, a balance sheet, a rent roll, and a schedule of real estate owned. They also ask for tax returns and bank statements to verify what those reports show.
Read answer

