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 percentage of peak-season revenue should a seasonal business set aside for off-season expenses?
Most seasonal businesses target saving 25 to 40 percent of peak-season revenue. Your specific number depends on your total fixed costs and how many months your slow season lasts.
Read answerHow does having a bilingual bookkeeper help with vendor and contractor communication?
A bilingual bookkeeper can communicate directly with Spanish-speaking vendors and contractors to resolve invoice questions, confirm payment terms, and collect accurate tax documents without delays or misunderstandings.
Read answerHow do I manage bookkeeping across multiple franchise locations with different managers?
Standardize your chart of accounts, processes, and reporting across every location. Use one accounting platform with separate files or location tracking, and build in regular oversight so no location falls behind or goes off track.
Read answerHow do I track project-based revenue and expenses as a consultant or creative agency?
Set up each project as a separate tracking category in your accounting software, then assign every invoice and direct expense to the right project. Pair that with consistent time tracking and you'll know exactly which projects and clients are actually profitable.
Read answerHow do I reconcile Amazon FBA settlement reports with what shows in my bank account?
Amazon deposits a net settlement amount after deducting fees, returns, reimbursements, and reserves. You need to break that single deposit into its component parts so your books reflect actual revenue and actual expenses.
Read answerHow do I set up a chart of accounts in QuickBooks that makes sense for a restaurant?
The default QuickBooks chart of accounts doesn't work for restaurants. You need separate accounts for food costs, beverage costs, labor by role, and restaurant-specific operating expenses so your reports actually show where the money is going.
Read answer
