April 17, 2026
6 min

Problem: Why Your Revenue Doesn’t Match Your Bank Deposits

Revenue and bank deposits don’t match due to fees, refunds, and VAT deductions. Learn how to reconcile marketplace payouts and fix accounting mismatches.
Problem: Why Your Revenue Doesn’t Match Your Bank Deposits
Table of contents

Your revenue does not match your bank deposits because marketplaces do not pay you your full sales amount. They deduct fees, refunds, VAT adjustments, and other charges before sending payouts. Your accounting system often records either gross sales or net deposits, but not both correctly, which creates a mismatch.

If this feels like a difficult puzzle to solve, you are not alone. It is a common challenge that describes the reality of online selling.

Key Takeaways from this Post

Revenue ≠ cash received
Marketplace payouts are net of fees, refunds, and VAT—your bank shows cash, not true revenue. Confusing the two leads to inaccurate reporting.

The real issue is data structure, not missing data
Most setups fail because they don’t separate sales, fees, refunds, and VAT or align timing—so reports can’t reconcile properly.

Reconciliation requires structured breakdowns
To fix the mismatch, you must break settlements into components and map them correctly—automation becomes essential as you scale.

General News BannerAmazon News BannerEbay News BannerEtsy News BannerShopify News BannerTiktok News BannerWalmart News Banner

Problem: Why Your Revenue Doesn’t Match Your Bank Deposits

Your revenue does not match your bank deposits because marketplaces do not pay you your full sales amount. They deduct fees, refunds, VAT adjustments, and other charges before sending payouts. Your accounting system often records either gross sales or net deposits, but not both correctly, which creates a mismatch.

If this feels like a difficult puzzle to solve, you are not alone. It is a common challenge that describes the reality of online selling.

What is Actually Causing the Mismatch

This is one of the most common problems in ecommerce accounting. The issue is not an error; it is simply how the systems work. Marketplaces like Amazon and Shopify operate on settlement models. That means:

  • You make sales
  • Fees are deducted
  • Refunds are processed
  • VAT is applied
  • A net payout is sent

Your bank receives the final number. Your accounting system, depending on its setup, may record gross sales, net payouts, or a mix of both. This creates a disconnect between the revenue in your reports and the cash in your bank. Recognizing this disconnect is the first step toward resolving it.

Why This Becomes More Visible as You Scale

At low volume, the difference is small. As you scale, the gap grows. More orders mean:

  • More fees
  • More refunds
  • More VAT adjustments
  • More timing differences

This increases the difference between what you expected to receive and what actually lands in your bank. This is often the moment when sellers start questioning their numbers. You cannot lay out a strategy or move forward if you do not understand your own money.

What is Missing From Your Accounting Setup

The issue is not that data is missing. It is that it is not structured correctly. Most setups fail because they do not:

  • Separate revenue from fees: Sales are recorded without clearly isolating costs.
  • Account for refunds properly: Refunds reduce revenue but are not always tracked accurately.
  • Handle VAT correctly: VAT is embedded in transactions and not always mapped clearly.
  • Align timing: Sales and payouts do not always occur in the same period.

Without this structure, your reports cannot match your bank.

Why Native Accounting Setups Do Not Solve This

Xero and QuickBooks are designed to record transactions and generate reports. They are not designed to break down marketplace settlements or structure ecommerce data natively.

This means your bank feeds show net deposits, while your sales reports show gross revenue. Without reconciliation, the two will never match.

How Tools Provide a Solution

This is the category that automated accounting tools operate in. They solve one core issue: turning marketplace data into structured accounting entries before it hits your books.

Link My Books

Breaks down settlements into sales, fees, refunds, and VAT. Designed for ecommerce sellers using Xero or QBO, focusing heavily on accurate reconciliation and UK VAT handling.

A2X

Widely used within accounting firms with a strong reputation and high adoption rate among professionals.

Dext Commerce

Offers broad automation across general accounting workflows, though slightly less focused specifically on reconciliation structure.

Finaloop

Takes a broader financial platform approach, expanding steadily into comprehensive ecommerce accounting workflows.

A good tool eliminates the manual work and resolves the discrepancy between your sales and your deposits.

Commercial Implications of This Mismatch

This is not just a reporting issue. It affects how you run your business:

  • Profit visibility: If revenue and costs are not separated, margins are unclear. You might think you are making money while actually losing it.
  • Decision-making: If your numbers do not align, you cannot rely on them to scale.
  • VAT compliance: Incorrect data leads to incorrect filings, putting you on the wrong side of the law in the UK and Europe.
  • Time cost: Manual reconciliation takes time and introduces expensive errors.

Practical Examples

Amazon Seller Example

You receive £10,000 in your bank. You assume you made £10,000 in sales.

The actual breakdown might be:

  • £12,000 sales
  • £2,000 fees
  • £500 refunds
  • VAT adjustments

Without proper structuring, your revenue is understated, your costs are hidden, and your reports are inaccurate.

Multi-Channel Seller Example

You sell on Amazon, Shopify, and eBay. Each platform deducts fees differently, pays out on different schedules, and reports data differently. Without standardisation, your accounts become inconsistent across channels.

Risks and Misconceptions

"My bank shows the real number."

Your bank shows net cash, not actual revenue. Accepting this as your total revenue is a massive mistake.

"My revenue report is correct."

Revenue reports from platforms often do not include full cost breakdowns.

"It is just a timing issue."

Timing plays a role, but the underlying data structure is the main issue.

"I can ignore small differences."

Small differences compound rapidly as volume increases.

FAQ

Why does my revenue not match my bank deposits?

Revenue reflects total sales, while bank deposits reflect net payouts after fees, refunds, and VAT adjustments. The mismatch occurs because these elements are not always separated and recorded correctly in accounting systems.

Is this a problem for all ecommerce sellers?

Yes, especially for sellers using marketplaces like Amazon or Shopify. As order volume increases, the difference between gross sales and net payouts becomes much more noticeable.

Can I fix this manually?

It is possible at low volumes by reviewing reports and adjusting entries. However, as transaction volume increases, manual reconciliation becomes incredibly time-consuming and prone to error.

Does this affect VAT reporting?

Yes. VAT is calculated based on transaction data, not bank deposits. If your data is not structured correctly, VAT calculations may be wildly inaccurate, increasing your compliance risk.

How do I make my revenue match my bank deposits?

You do not make them match directly. Instead, you structure your accounting so that revenue, fees, refunds, and VAT are recorded separately. When done correctly, your reports will reconcile perfectly even if the raw numbers are not identical.

What This Means for Your Financial Setup

Your revenue and bank deposits are not supposed to match. They represent completely different parts of your business.

The goal is not to force them to align, but to understand and structure the difference. When your accounting setup separates revenue from costs, tracks fees accurately, and handles VAT correctly, your numbers become reliable. That is the point where reporting stops being confusing and starts being usable.

Share this post:
General News BannerAmazon News BannerEbay News BannerEtsy News BannerShopify News BannerTiktok News BannerWalmart News Banner

Keep reading

all posts →

Accurate Ecommerce Accounting

Accurate Ecommerce Accounting

On Autopilot

Check
Save time and money by automating your bookkeeping
Check
All sales, refunds, fees and taxes accurately accounted for
Check
Automatic bank deposit matching with Xero & QuickBooks
Check
Built in support for VAT, GST and Sales Tax
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Link My Books - Bookkeeping for e-commerce sales
Amazon
Xero App Store
Shopify
QuickBooks
WANT TO TALK TO AN EXPERT BEFORE GETTING STARTED?
Dan Little