---
title: "Reconciling 14 months of Shopify and Amazon payouts"
description: "Reconciling 14 months of Shopify and Amazon payouts. What we did, the numbers before and after, and what changed."
url: https://ledgerbpo.com/case-studies/ecommerce-payout-reconciliation/
updated: 2026-09-11
publisher: LedgerBPO (SS Support Network LLC)
language: en-US
---

# Reconciling 14 months of Shopify and Amazon payouts

Case study · E-commerce

14 months of payouts reconciled

An online retailer in the northeastern US sold through its own Shopify store and on Amazon. Deposits landed in the bank as lump sums net of fees, refunds, chargebacks and reserves, and the owner had been booking each deposit as sales. Fourteen months in, the books showed revenue that matched neither platform report, and the retailer's tax preparer would not work from them.

The owner engaged LedgerBPO for payment-processor reconciliation, e-commerce accounting and catch-up bookkeeping. A named accountant, a backup and a team lead reconciled every payout for the 14 months back to the settlement reports and the bank, then put a monthly routine in place so the gap did not reopen. This ecommerce bookkeeping case study covers the first three months of payout reconciliation.

Updated September 2026

## Before and after

Before

**Months of unreconciled payouts**
: 14

**Sales channels**
: Shopify and Amazon, unreconciled

After

**Months of unreconciled payouts**
: 0

**Sales channels**
: Shopify and Amazon, reconciled monthly

## What we did

1. 01
### Access and setup
We received staff accounts with MFA in Shopify, Amazon Seller Central, the payment processors and QuickBooks Online, plus read-only bank feeds. With the owner's agreement we connected a settlement-summary tool (A2X) so each payout could be posted as one summarized entry with its gross sales, fees, refunds and tax components. Managed devices and access logs applied throughout, and the owner kept admin ownership of every platform.
2. 02
### Reconciling 14 months of payouts
Working oldest month first, we pulled every Shopify payout and every Amazon settlement report for the period and matched each one to a bank deposit through our ReconBot workflow. Each payout was split into gross sales, marketplace and processing fees, refunds, chargebacks, reserve movements and sales tax collected. Deposits previously booked as sales were reversed. Anything that did not match went to the exception log with a reason and an owner.
3. 03
### A monthly close that includes the channels
Once caught up, each payout was matched within the week it landed. The month-end checklist gained channel-specific steps: settlement reports downloaded and tied to the ledger, reserve balances agreed, refunds and chargebacks reviewed, inventory purchases and cost of goods sold posted. Each close went through our Two-Tier Review before the owner received the pack.
4. 04
### Marketplace cases and payout queries
Exceptions that traced back to the platforms, such as missing reimbursements for lost inventory or reserves held longer than expected, were raised as cases with Amazon Seller Support and Shopify under the retailer's own account. The team tracked each case to a resolution in the exception log. Where a balance could not be recovered, the owner made the write-off decision.
5. 05
### Channel reporting
The owner now receives a monthly pack through our LedgerDesk portal: sales, fees and net payout by channel, fee percentage of gross, refund rate, and sales tax collected by state for the retailer's own sales-tax filings. The tax preparer received reconciled books for the full 14 months with the reconciliation reports attached, and the retailer kept LedgerBPO on for the ongoing monthly close.

## KPIs

| KPI | Before | After |
| --- | --- | --- |
| Months of unreconciled payouts | 14 | 0 |

## Services used

- [Stripe, Shopify, Amazon and PayPal payouts that tie out](https://ledgerbpo.com/services/payment-processor-reconciliation/)
- [Channel P&L that matches your payouts](https://ledgerbpo.com/services/ecommerce-accounting/)
- [Months behind? We'll bring your books current](https://ledgerbpo.com/services/catch-up-bookkeeping/)

Next step

## Want the same shape of result?

Tell us where the books or billing hurt. A named person replies within 1 business day with a plan for the first 30 days.

- Reply from a named person within 1 business day
- No setup fee, month-to-month
- Your software, your data, no lock-in

Start with a custom quote

[Get a custom quote](https://ledgerbpo.com/get-a-quote/) [Book a 20-minute call](https://ledgerbpo.com/book-a-call/) Or call [+1-657-777-0006](tel:+16577770006) during US, UK or Australian business hours.

---

Source: https://ledgerbpo.com/case-studies/ecommerce-payout-reconciliation/ · Contact: https://ledgerbpo.com/contact/ · Full site map for agents: https://ledgerbpo.com/llms.txt