E-Commerce Sellers: Reconcile Statements with Shopify & Amazon

If you sell on Shopify, Amazon, or both, your bank statement tells a very different story than your sales dashboard. Platform payouts arrive as lump-sum deposits that bundle dozens or hundreds of individual orders into a single bank transaction. Fees, refunds, and chargebacks are netted out before the money ever hits your account. Reconciling what your bank statement shows against what your e-commerce platform reports is one of the most time-consuming and error-prone parts of running an online store.

This guide breaks down the reconciliation process for Shopify and Amazon sellers, explains why the numbers never seem to match on the first try, and shows you how to build a reliable system for keeping your books accurate.

Why E-Commerce Bank Reconciliation Is Uniquely Difficult

Traditional bank reconciliation is straightforward: match each transaction in your accounting software to a corresponding entry on your bank statement. For e-commerce sellers, several factors make this process significantly more complicated.

• **Batched payouts**: Shopify and Amazon pay you in batches, not per order. A single deposit on your bank statement might represent 3 days of sales, minus fees, minus refunds. Matching this deposit to individual orders requires unpacking the payout.
• **Fee complexity**: Amazon charges referral fees, FBA fees, storage fees, advertising costs, and subscription fees. Shopify deducts payment processing fees and may charge transaction fees depending on your plan. These fees are often netted against your payout, so they never appear as separate line items on your bank statement.
• **Multi-currency transactions**: If you sell internationally, currency conversion adds another variable. The exchange rate at the time of sale differs from the rate at the time of payout, creating small discrepancies that are legitimate but confusing.
• **Refund timing**: A customer might place an order in January, receive a refund in February, and the refund hits your bank statement in March. Matching refunds to the correct original order and accounting period requires tracking across multiple months.
• **Multi-platform selling**: Sellers who use both Shopify and Amazon (plus possibly Etsy, eBay, or Walmart Marketplace) have multiple payout streams depositing into the same bank account, each with its own fee structure and timing.

Step 1: Get Your Bank Statement Data Into a Spreadsheet

Before you can reconcile anything, you need your bank transactions in a format you can work with. Most e-commerce sellers use Chase or Capital One for their business banking, and both provide monthly statements as PDFs.

1. Download your bank statement PDFs for the period you want to reconcile. Monthly reconciliation is ideal, but quarterly works if you are catching up.
2. Upload each statement to StatementVision to extract all transactions into a clean spreadsheet. Pay attention to the transaction descriptions: payout deposits from Shopify typically show as "SHOPIFY" or "STRIPE" while Amazon deposits show as "AMAZON" or "AMZN MKTP".
3. Export as Excel. You will need to filter and annotate these transactions, and Excel gives you the most flexibility.
4. Highlight or filter all deposits that come from your e-commerce platforms. These are the transactions you will reconcile against your platform reports.

Also flag any bank transactions related to e-commerce that are not platform payouts: advertising charges from Meta or Google, shipping label purchases, inventory supplier payments, and subscription fees for e-commerce tools. These are business expenses you will need to track separately.

Step 2: Reconcile Shopify Payouts

Shopify Payments deposits funds into your bank account on a regular schedule, typically every business day or every few days depending on your country and account standing. Each payout bundles all orders, refunds, and fees from a specific period.

Download Your Shopify Payout Report

In your Shopify admin, navigate to Settings, then Payments, then View payouts. You can export a CSV of all payouts for a given date range. Each row shows the payout date, payout amount, and a breakdown of orders, refunds, adjustments, and fees included in that payout. You can also export a transactions-level report that shows every individual order and fee within each payout.

Match Payouts to Bank Deposits

With both your bank statement data and Shopify payout report in spreadsheets, match each Shopify payout to a corresponding bank deposit. Match on amount first, then verify the date. Shopify payouts typically appear in your bank account 1-3 business days after the payout is initiated, so the dates will not match exactly. When the amounts match and the dates are within a few business days, you have a confirmed match.

Step 3: Reconcile Amazon Payouts

Amazon's payout cycle is typically every two weeks for most sellers. Each settlement period produces a detailed settlement report that breaks down every component of your payout.

In Seller Central, go to Reports, then Payments, then All Statements. Download the settlement report for each period as a CSV. The report includes columns for product sales, shipping credits, gift wrap credits, promotional rebates, selling fees, FBA fees, other transaction fees, and the final settlement amount.

Match the net proceeds from each settlement report to a deposit on your bank statement. Amazon settlement deposits typically arrive 3-5 business days after the settlement period closes. If the amounts do not match, check for reserves: Amazon may withhold a portion of your balance as a reserve, especially for newer seller accounts.

Common Discrepancies and How to Resolve Them

Even with careful matching, you will encounter discrepancies. Here are the most common ones and how to track them down.

• **Small rounding differences** (less than $1): These are usually caused by currency conversion or fee rounding. If the difference is under a dollar, note it and move on. Most accounting standards accept immaterial rounding differences.
• **Missing deposits**: If a payout appears in your platform report but not on your bank statement, check whether it was sent to a different bank account, held in reserve, or offset against a negative balance from a prior period.
• **Extra deposits**: Unexplained deposits might be promotional credits, reimbursements for lost inventory (common with FBA), or adjustments from a case you opened with seller support months ago.
• **Timing differences at month boundaries**: A payout initiated on January 30 might not arrive in your bank account until February 2. If you reconcile by calendar month, these boundary transactions will create temporary mismatches that resolve in the next period.
• **Chargeback adjustments**: When a customer disputes a charge with their credit card company, the chargeback amount is deducted from a future payout. This deduction may appear in a different settlement period than the original sale.

Building a Monthly Reconciliation System

Reconciliation should not be a once-a-year scramble at tax time. Building a monthly habit takes about an hour per month and saves you from facing a year's worth of unresolved discrepancies during your busiest season.

1. Within the first week of each month, download your bank statements for the prior month and convert them to spreadsheets.
2. Download your Shopify payout reports and Amazon settlement reports for the same period.
3. Match every platform deposit on your bank statement to a payout or settlement report. Mark each as reconciled.
4. Investigate and document any discrepancies. Most will resolve with a timing explanation or a small rounding note.
5. Record the reconciled totals in your accounting software, broken down by platform: gross sales, fees, refunds, and net deposits.

Simplify the Bank Statement Side of Reconciliation

The platform side of e-commerce reconciliation is well-served by Shopify and Amazon's built-in reporting tools. The bank statement side is where most sellers get stuck, manually flipping through PDF pages to find deposit amounts and dates. StatementVision eliminates that friction by converting your bank statements into clean spreadsheets where every deposit is searchable, sortable, and ready to match against your platform data.