What is ecommerce payment matching and why does it matter?
Ecommerce payment matching is the work of tying what your sales platform reports to what your payment processor actually deposits into your bank account. Shopify, Amazon, Etsy, and similar platforms record gross sales. Stripe, PayPal, Shopify Payments, and Amazon then take fees, hold reserves, process refunds, and pay out a net amount days or weeks later. If you only book what hits the bank, your revenue is understated. If you book both the sales and the deposits, your revenue is doubled. Matching is what keeps your records honest.
Here is how the gap shows up. A Shopify store rings up $10,000 in sales for the week. Shopify Payments takes its processing fee, holds back a few hundred dollars for a pending refund, and deposits $9,420 to the bank three days later. The accounting needs to show $10,000 in revenue, the processing fees as an expense, the refund recorded properly, and the deposit reconciled against all of it. Skip the matching and you might record $9,420 as revenue, miss the fee deduction, and have no idea what your real margin looks like.
Duplication is the other failure mode. An owner sees the Shopify payout hit the bank and books it as sales. Then a bookkeeper imports the Shopify sales report and books that too. Now the same revenue is on the books twice. At tax time, the business pays income tax on money it never made. We see this regularly during cleanup work for stores that grew faster than their bookkeeping and accounting support kept up with.
Matching gets harder when you sell on multiple channels. Amazon settles every two weeks with fees, FBA charges, advertising deductions, and storage fees all netted against sales. Walmart, eBay, and Etsy each have their own payout schedule and deduction structure. Add a Shopify storefront with Shopify Payments, PayPal, and Afterpay and you have five or six payout streams that all need to reconcile to gross sales recorded somewhere else.
Beyond accurate revenue, payment matching protects sales tax accuracy. Sales tax is owed on gross sales, not net deposits. If your books only reflect net payouts, you are underreporting taxable sales and creating exposure with state tax agencies. The matching process surfaces the gross figures that sales tax returns need to be built on.
This is the work behind our ecommerce AR payment matching service. Each payout gets traced back to the sales, fees, refunds, and adjustments that produced it. Clearing accounts hold the timing differences between when a sale happens and when the money lands. The end result is books that show real revenue, real fees, and real margin, with a bank reconciliation that actually ties out.
Trusted Accounting for Small Businesses
First Step:
Start With a Call
Tell us about your business and what you need help with. We'll ask a few questions, evaluate your current situation, and let you know how GMJ can support your books, taxes, and day-to-day operations.
More Questions
What financial reports should a small business owner review every month?
At minimum, review your profit and loss, balance sheet, cash position, AR aging, AP aging, sales tax liability, and payroll costs. Add any industry-specific reports like job profitability or inventory that matter for how your business runs.
Read answerWhat QuickBooks training should a business owner get before handing tasks to staff?
Learn enough QuickBooks yourself to oversee the work before delegating it. That means understanding bank feeds, receipts, invoices, bills, rules, reconciliation, reports, and user permissions well enough to catch mistakes and prevent duplicate entries.
Read answerWhat records should I gather before hiring a bookkeeper?
Pull together bank and credit card statements, payroll records, sales tax filings, merchant or POS reports, open invoices and bills, loan statements, prior tax returns, and access to your accounting software. Having these ready makes onboarding faster and helps your bookkeeper start producing useful work immediately.
Read answerHow should a warehouse or fulfillment business track inventory, labor and shipping costs?
Track customer-owned inventory separately from your own supplies, then allocate labor, shipping, storage, and overhead by customer or job. The goal is customer-level profitability so you can see which accounts actually make money after all the activity-based costs are accounted for.
Read answerHow should freight brokers track customer invoices and carrier payables?
Track every load with a unique load number that ties the customer invoice, carrier bill, and supporting documents together. This gives you accurate AR and AP, accounts for factoring correctly, and shows gross margin by load and by customer.
Read answerHow can bill payment support help avoid late fees and duplicate payments?
Bill payment support prevents late fees and duplicates through five control points. Approval workflows, due-date tracking, accurate vendor records, consistent payment recording, and monthly reconciliation. Each step catches problems before they cost you money.
Read answer
