Top 5 Reasons Your QuickBooks Doesn’t Match Your Marketplace Reports

When QuickBooks disagrees with a marketplace report, the cause is almost always one of five things: the two systems are measuring different date ranges, one is reporting gross while the other is reporting net, refunds and reimbursements are being treated as the same event, inventory is moving in one system and not the other, or sales tax is landing in the wrong account. The disagreement is rarely a software fault. It is usually two correct reports answering two different questions.

1. The date ranges are not the same

Marketplace reports run on settlement periods. QuickBooks runs on calendar months. Those two calendars line up by coincidence a few times a year and not otherwise.

Amazon settles roughly every fourteen days, which guarantees that most months contain a settlement that opens in one month and closes in the next. A seller comparing an Amazon settlement report to a QuickBooks monthly profit and loss statement is comparing fourteen days of activity that crosses a boundary against thirty days of activity that does not.

Before investigating anything else, confirm both reports cover identical dates. A surprising share of reconciliation panics end here. If the variance disappears when the ranges are aligned, there was never a problem, and the real fix is to split settlements at the period boundary going forward so the comparison works without manual effort.

2. One report is gross and the other is net

Marketplace reports generally show gross sales. Bank deposits show net proceeds. If QuickBooks was set up by matching deposits to a revenue account, the books are carrying net and the marketplace is showing gross, and the two will never agree.

The gap is roughly the size of the marketplace’s total take. Amazon’s referral fees alone range from 5 percent to 45 percent by category, with most categories at 15 percent, according to Amazon’s published seller pricing as of the 2026 schedule, and referral sits alongside fulfillment, storage, advertising, and refunds. A seller booking net deposits is understating revenue by all of it and carrying no fee expense at all.

The correction is a chart of accounts that posts revenue at gross and each fee category to its own expense line, with the deposit as the reconciling total. It is more accounts and more setup. It is also the only arrangement where the two reports can agree, and where a seller can see which fee is growing faster than sales.

3. Refunds and reimbursements are collapsed together

These arrive on the same settlement report and mean opposite things. A refund reverses a sale because a customer returned goods. A reimbursement is the marketplace compensating a seller for inventory it lost or damaged while holding it.

Booked as one number, neither is visible. Return rate disappears, so a product with a quality problem hides behind reimbursements earned on unrelated SKUs. Inventory stops tying out, because a refunded unit usually returns to sellable stock while a reimbursed unit is gone for good. Net them together and the books will show units on hand that nobody has, with the gap widening every month.

Three separate treatments are needed: contra revenue for refunds, other income for reimbursements, and an inventory adjustment for the physical units. The settlement report distinguishes them. The books have to as well.

4. Inventory moves in one system and not the other

Marketplace reports are transaction records. They describe what sold and what it sold for. They do not maintain an inventory asset account, and they have no view of stock sitting in a third party warehouse or in transit from a supplier.

QuickBooks can maintain that asset account, but only if something is posting movements into it. When nothing is, inventory sits frozen at whatever figure was last entered and cost of goods sold becomes whatever the bookkeeper plugs to make the period look plausible. At that point the profit and loss statement is a guess and the balance sheet is stale.

This is the gap that dedicated integrations exist to close, and it is the reason a bank feed connection is not sufficient on its own. ConnectBooks is one of several tools built to carry marketplace activity into QuickBooks Online with cost of goods sold and unit level inventory movement intact rather than summarized into a single journal entry. Whatever the mechanism, the test is the same: if inventory on the balance sheet does not move when units ship, the two systems are describing different businesses.

5. Sales tax is in the wrong place

Collected sales tax is a liability, not revenue. It belongs to a state from the moment it is collected until it is remitted. Recorded as income, it inflates revenue, inflates profit, and creates a tax exposure on money that was never the seller’s to keep.

Marketplace facilitator rules make this harder to see rather than easier. In most states the marketplace now collects and remits on the seller’s behalf for marketplace transactions, so that tax may never touch the seller’s bank account at all, while the seller’s own storefront is generally still their responsibility. A seller running Shopify alongside Amazon has one channel where the obligation is handled for them and one where it is not, and the marketplace report and the books will disagree by exactly that amount if the distinction is not modeled.

Thresholds and registration requirements vary by state and change regularly, so the question of where a seller is obligated belongs with a state department of revenue or a tax professional. The bookkeeping treatment does not vary: collected tax goes to a liability account and leaves it only on remittance.

A reconciliation order that works

Work the five in sequence rather than hunting. Align the date ranges first, because it costs nothing and resolves a meaningful share of variances outright. Then confirm gross versus net, which is usually the largest single number. Then separate refunds from reimbursements, and check whether inventory moved. Last, check where the tax landed.

Anything still outstanding after those five is usually a genuine timing item, most often a settlement still open at the period end or a deposit in transit. Those are accruals, not errors, and they should reverse in the following period.

If a variance survives all of that and does not reverse, it is worth escalating rather than plugging. A recurring unexplained difference is the kind of thing that stalls a diligence process years later, and the Small Business Administration guidance on financial recordkeeping is a reasonable reminder of why the audit trail matters more than a tidy looking month.