Bookkeeping and payroll for small businesses across central Virginia.

Call / Text: (866) 478-7426

How do I reconcile payments from multiple sales channels?

The challenge with multiple sales channels is that money lands in your bank account in different ways and at different times. Square deposits next day minus fees. Shopify deposits on a schedule you configured. Amazon holds funds for two weeks and deducts fees, refunds, and advertising costs before you see anything. Matching those deposits to actual sales gets confusing fast.

Start by reconciling each channel’s sales separately from your bank. Most platforms provide settlement reports showing what you sold, what fees were charged, and what they actually paid you. That report is your source of truth for that channel. If Shopify says you had $4,200 in sales, $120 in fees, and a $4,080 payout, your books should reflect all three numbers.

Don’t just record the deposit amount. Recording a $4,080 deposit and calling it sales means your revenue is understated by $120 and your expenses are missing the payment processing fees. Over a year, those missing fees add up to thousands of dollars in invisible costs. This matters for e-commerce businesses especially, where processing fees can represent a significant chunk of margin.

Use clearing accounts if deposits include multiple days of sales or multiple transaction types bundled together. Amazon is notorious for this. A single deposit might include sales from the past two weeks, returns from three different orders, FBA fees, and advertising charges. A clearing account holds the expected payout until the actual deposit arrives, then you match them. When they reconcile, the clearing account zeroes out.

Timing matters more than you’d expect. A sale on Friday night might not deposit until Tuesday. If you’re trying to reconcile your books on Monday, that sale shows in your POS but not in your bank. Working with consistent cutoff dates and understanding each platform’s payout schedule prevents confusion.

Third-party delivery apps need their own tracking for restaurants and retailers using them. DoorDash, Uber Eats, and Grubhub all charge commissions and deposit net amounts. A $100 order might result in a $70 deposit after their cut. Your books need to show $100 in revenue and $30 in delivery fees, not $70 in sales.

Integrations can automate some of this. Apps like A2X connect platforms like Amazon and Shopify to QuickBooks and break out each component correctly. They’re not free, but they save hours of manual reconciliation and reduce errors. If you have significant volume through marketplaces, the cost is worth it.

The weekly habit that keeps this manageable is reviewing each channel’s settlement reports against your bank deposits. Match the payout amounts. Verify the fees. Confirm returns are recorded. Doing this weekly takes thirty minutes. Waiting until year end takes days and you’ll find discrepancies you can’t explain.

If you’re selling through multiple channels and struggling to keep up, bookkeeping services in Richmond can set up the right tracking structure and handle the reconciliation monthly. This is one of the areas where outsourcing pays for itself in accuracy alone.

Greater Richmond's Small Business Bookkeeper

The Next Step:
A Short Conversation

Fifteen minutes to tell us what you're dealing with. We'll let you know how we can help and give you a clear price quote.

More Questions

What happens if I don't keep good financial records?

Poor records lead to expensive tax prep, missed deductions, IRS audit risk, and cash flow surprises. Banks won't lend without clean financials, and selling your business becomes nearly impossible.

Read answer

What e-commerce expenses are tax deductible?

E-commerce sellers can deduct platform fees, inventory costs, shipping and packaging, software subscriptions, advertising, and home office expenses. The key is tracking expenses properly throughout the year.

Read answer

How do I track tip income and tip-outs for my restaurant?

Track tips daily using your POS system or a written tip log, record all tip-outs to support staff, and run tips through payroll since they're taxable wages. Both credit card and cash tips need documentation.

Read answer

How do I track fees from Shopify, Amazon, and PayPal?

Record gross sales and fees separately instead of just booking net deposits. Each platform provides settlement reports that break down exactly what they charged you, which you need for accurate margins and proper tax deductions.

Read answer

When should I switch from doing my own books to hiring a bookkeeper?

There's no universal trigger point. The signs are usually falling behind on reconciliation, making recurring errors, or spending hours each month on something that pulls you away from actually running your business.

Read answer

Do I need to charge sales tax on services in Virginia?

Virginia generally does not tax most services. The retail sales tax applies mainly to tangible goods, not labor or professional expertise. However, there are exceptions for certain services like accommodations and repair work involving parts.

Read answer

Virginia bookkeeping firm focused on small businesses. Bookkeeping, payroll, and fractional CFO services from a local Richmond team. A decade of working with businesses like yours. QuickBooks ProAdvisor certified.

Client Reviews

5-Star Rated Firm

Social

  • Intuit ProAdvisor Gold tier certification badge
  • Intuit Certified QuickBooks Level 1 ProAdvisor badge
  • Intuit Certified QuickBooks Level 2 ProAdvisor badge
  • Intuit Certified QuickBooks Payroll ProAdvisor badge

© 2026 Tri-County Bookkeeping LLC