Title Goes Here

Back to Blog

Your Platform Reconciliation Report: The Report Almost No One Runs and the One That Catches the Most Errors

The Platform Reconciliation Report is a monthly comparison between what your selling platforms say they paid you and what actually landed in your bank account. When it is done consistently, it catches errors, prevents tax headaches, and keeps your books accurate from the start. When it is skipped, small discrepancies quietly compound until they become a much bigger problem to untangle.

Hannah Kearns

Co-Owner, Director of Operations

6 min

Table of contents

READ YOUR BUSINESS SERIES | A Monthly Financial Guide for eCommerce Entrepreneurs | Article 5 of 5


Welcome to the final article in the Read Your Business series. Over the last four weeks, we have walked through the reports that give you a complete picture of your business: your P&L, your Cash Flow Statement, your Balance Sheet, and your Sales Tax Liability Report.

This fifth report is different from the others. It is not a standard financial statement – it is a process. And it is the one that most eCommerce sellers skip entirely, usually because no one ever told them it existed.

The Platform Reconciliation Report is a monthly comparison between what your selling platforms say they paid you and what actually landed in your bank account. When it is done consistently, it catches errors, prevents tax headaches, and keeps your books accurate from the start. When it is skipped, small discrepancies quietly compound until they become a much bigger problem to untangle.

Let us walk through what this looks like, why it matters, and how to build a simple habit around it.


Why Your Platform Deposits Are Not What You Think

The deposit that hits your bank account from Amazon, Shopify, or Etsy is never your gross sales. It is a net figure – your sales, minus fees, minus refunds, minus any adjustments or reserves the platform applied during that period.

That gap between gross sales and net deposit is completely normal. But if you record the deposit as revenue without breaking it down into its components, your books start out wrong – and everything built on top of them (your P&L, your tax return, your margin analysis) reflects that error.

A helpful way to think about it: Every platform deposit is a package. Inside that package are your sales, your fees, your refunds, and sometimes reserve adjustments or ad charges. The reconciliation report is how you open the package and record each piece correctly.

For Amazon FBA sellers specifically, this is especially important. Amazon’s settlements include a wide range of line items – referral fees, FBA fulfillment fees, storage fees, sponsored product charges, reimbursements, and more. Recording the full settlement deposit as a single revenue entry misses all of that detail and can significantly overstate your income.



What a Platform Reconciliation Report Covers

The report itself does not need to be complex. At its core, it is a monthly side-by-side comparison of three things for each platform you sell on:

  • What the platform says you earned: Your gross sales for the period, pulled from your platform’s transaction or settlement report.

  • What the platform deducted: Fees, refunds, advertising charges, adjustments, and any reserve amounts held back.

  • What actually hit your bank: The net deposit amount, confirmed against your bank statement.

When those three numbers reconcile – meaning the math adds up cleanly – you can record everything with confidence. When they do not, you have found something worth investigating before it becomes a tax-time problem.


What to Check Every Month


1. Gross Sales vs. Net Deposits

Start with the big picture. Pull your gross sales total from each platform and compare it to the net deposit you received. The difference is your total platform cost for the month. For Amazon sellers, effective fee rates — when you add referral fees, FBA fees, and ad spend together — commonly represent a significant portion of gross revenue. Seeing that number clearly each month is one of the most useful things this report gives you.


2. Refunds and Return Adjustments

Refunds issued during a settlement period are deducted from your payout — but they also need to be recorded correctly in your accounting software. A refund is not just a reduction in revenue. Depending on the condition of the returned item, it may also trigger an inventory adjustment. Cross-checking your platform refund report against what has been recorded in your books each month keeps this from piling up.


3. Reserve Balances

Some platforms — particularly Amazon and PayPal — hold a portion of your funds in reserve, especially for newer accounts or accounts with elevated dispute rates. These reserve amounts are your money, but they are not available yet. They should appear as an asset on your balance sheet, not disappear from your records until they are eventually released.

If your bookkeeping does not account for reserves, you may be underreporting assets — and you may also be confused each month when your deposit is smaller than you expected.


4. The 1099-K Gross vs. Your Reported Revenue

This is one of the most important reconciliation points of the entire year — and it connects directly to your tax return.

In 2025, platforms are required to issue a Form 1099-K for any seller with more than $2,500 in gross payments. That threshold will drop to $600 in 2026. The number on your 1099-K represents gross payment volume — before any fees, refunds, or adjustments are deducted.

Your tax return, on the other hand, reports net revenue — after all of those deductions. So your 1099-K and your reported revenue will not match. And that is perfectly fine, as long as you have a clear, documented reconciliation that explains the difference.

Why this matters: The IRS receives a copy of every 1099-K issued in your name. If your reported revenue is significantly lower than your 1099-K total with no supporting documentation, it can raise questions. A monthly platform reconciliation report means that documentation already exists — organized and ready — long before tax season arrives.


Selling on Multiple Channels? Learn More

If you sell on Amazon, Shopify, Etsy, Walmart, or any combination of platforms, reconciliation becomes even more important — and a little more layered.

Each platform has its own payout schedule, its own fee structure, and its own reporting format. Amazon pays every two weeks. Shopify Payments may deposit daily or weekly. Etsy has its own settlement cycle. When you are pulling deposits from multiple sources into the same bank account, it is easy for things to blur together without a clear record of where each dollar came from.

A clean platform reconciliation report separates each channel, so you always know exactly what each platform contributed — and what it cost you to sell there. Over time, that data becomes one of your most valuable tools for deciding where to invest your energy and inventory.



Tools That Make Reconciliation Much Easier

Done manually, platform reconciliation can feel time-consuming — especially if you are selling across several channels. The good news is that there are tools designed specifically to automate most of this work.

Link My Books is one of the most widely used by eCommerce accountants. It connects directly to Amazon, Shopify, Etsy, and other platforms, pulls your settlement data automatically, and maps each line item to the correct account in QuickBooks or Xero. Instead of manually parsing settlement reports, you get a clean, categorized summary ready for review each month.

At Tall Oak Advisors, we use Link My Books with many of our eCommerce clients precisely because it makes the reconciliation step accurate and consistent — which means fewer surprises at tax time and more confidence in the numbers throughout the year.


Getting Started This Month

If you are not yet running a platform reconciliation each month, here is a simple way to begin:

  • Download your settlement or transaction report from each platform you sell on for the prior month.

  • Confirm the net deposit amount shown in the report matches what actually hit your bank account.

  • Identify the main components of the difference between gross sales and net deposit: fees, refunds, ad charges, reserves.

  • Make sure each of those components is recorded separately in your accounting software — not combined into a single deposit entry.

  • Note any reserve balances held by any platform and confirm they are showing up as assets in your books.

  • Keep a running reconciliation file that you can reference when your 1099-Ks arrive — it will make tax season significantly easier.

You do not need to reconcile every single transaction on day one. Starting with a high-level summary for each platform — gross in, fees out, refunds out, net deposited — is already a major step forward from recording deposits as a lump sum.


You Do Not Have to Do This Alone

Setting up a clean reconciliation process across multiple platforms is one of those tasks that feels manageable once the systems are in place — but getting there can take time and expertise.

At Tall Oak Advisors, we help eCommerce sellers build exactly this kind of foundation: accurate books, clean monthly reports, and a clear picture of what each channel is actually contributing to the business. If you would like support getting your reconciliation process set up — or if you want someone to handle it for you each month — we would love to talk.

Reach out here and let us figure out the best next step together.


You Made It Through All Five Reports

Over the course of this series, we have covered a lot of ground together:

  • Article 1: Your P&L — whether your business is actually profitable, and what your margins are really telling you.

  • Article 2: Your Cash Flow Statement — why profit and cash are not the same thing, and how to stay ahead of the gaps.

  • Article 3: Your Balance Sheet — a monthly snapshot of what your business owns, owes, and has built over time.

  • Article 4: Your Sales Tax Liability Report — where you have nexus, what you have collected, and what you owe.

  • Article 5: Your Platform Reconciliation Report — making sure every deposit is recorded correctly and your books are accurate from the start.

Reviewed together, these five reports give you a complete and honest picture of your business every single month. Not just how sales are going — but whether the business is healthy, whether it is building real value, and whether it is set up to grow sustainably.

That kind of clarity is not reserved for large companies with full finance teams. It is available to any eCommerce seller who builds the habit of looking at the right numbers, consistently, one month at a time.

We hope this series has made that feel a little more approachable.

Explore More

Keep reading there's more worth your time

Lorem ipsum dolor sit amet consectetur. Dictumst vehicula tincidunt aliquet id. Faucibus vivamus et faucibus diam consectetur.