How to Reconcile Your Ecommerce Accounts
Before You Start
Reconciliation requires three things: your bank statement for the period (available from your online banking portal), your platform payout reports (from Shopify, Amazon Seller Central, Stripe, and PayPal), and your accounting software with all transactions categorized for the period. If you have uncategorized transactions in your bank feed, categorize them first. Trying to reconcile with unprocessed transactions creates confusion and makes discrepancies harder to isolate.
If this is your first reconciliation and you have months of uncategorized transactions, start by bringing your bookkeeping up to date for the most recent complete month. Going forward, reconcile monthly. Then work backward through prior months as time allows, starting with the most recent and moving toward the beginning of the year.
Step-by-Step Bank Reconciliation
Download your bank statement for the month in PDF or CSV format. Pull payout reports from each platform: Shopify Payments (Settings, then Payments, then View payouts), Stripe (Payments, then Payouts), PayPal (Activity, then Statements), Amazon Seller Central (Reports, then Payments, then All Statements). Having all documents open before you start prevents interruptions during the matching process.
In QuickBooks, go to Accounting, then Reconcile. In Xero, go to Accounting, then Bank Accounts, then Reconcile. Select the bank account you are reconciling. Enter the statement ending date (the last day of the month) and the ending balance from your bank statement. The software will show the difference between your book balance and the statement balance. Your goal is to reduce this difference to zero by matching and correcting transactions.
Go through each transaction in the reconciliation screen and check it off against the bank statement. Deposits should match payment processor payouts. Withdrawals should match expenses you recorded. If you use an integration app like A2X, each payment processor deposit should already have a matching journal entry with the detailed breakdown of sales, fees, and refunds. Check the deposit amount from the bank statement against the journal entry total. If they match, mark the transaction as reconciled. Work through all deposits first, then all expenses.
After matching all transactions you can find, check the remaining difference. Common causes of discrepancies include: transactions that cleared the bank but were not imported to your accounting software (manual check deposits, wire transfers, or bank feed lag), transactions recorded in your books but not yet cleared at the bank (outstanding checks or pending transfers), duplicate entries from both bank feed and integration app recording the same deposit, bank fees or interest that were not recorded in your books, and timing differences where a transaction occurred on the last day of the month in one system but posted on the first day of the next month in the other.
For each discrepancy, create the appropriate entry. Add any missing transactions (bank fees, interest, unrecorded deposits). Delete any duplicates. Create journal entries for corrections that do not fit standard transaction types. Once the difference reaches zero, finalize the reconciliation. Your accounting software locks reconciled transactions to prevent accidental changes, which protects the integrity of your historical records.
Platform-Specific Reconciliation
Shopify Payout Reconciliation
Each Shopify Payments payout should match a bank deposit within one to two business days. Pull the Shopify Payments Payout report for the month and compare each payout amount against your bank deposits. If you use A2X, each payout has a journal entry that breaks down the components. The journal entry net amount should exactly match the bank deposit. Discrepancies of a few cents are usually due to rounding in payment processing and are not concerning. Discrepancies of $1 or more warrant investigation.
Check the Shopify Finances Summary for the month against your accounting totals: gross sales, returns, discounts, net sales, shipping collected, taxes collected, and total fees should all match between Shopify's reports and your books. If they do not match, the most common cause is a payout that spans month boundaries. A payout initiated on January 31 but deposited on February 1 appears in January's Shopify report but February's bank statement.
Amazon Settlement Reconciliation
Amazon settlements occur every 14 days and are the most complex to reconcile because of the number of fee types bundled into each settlement. The settlement total deposited to your bank should exactly match the net amount shown on the settlement report and the journal entry from your integration app. If all three numbers agree, the settlement is reconciled.
If numbers do not match, download the detailed settlement report from Seller Central and compare each line item category against your journal entry. Common causes of Amazon discrepancies include: reserve balance changes (Amazon holds a percentage of revenue as a reserve, especially for newer sellers, and releases it later), timing of advertising charges (some ad spend may settle in a different period than the sales it generated), adjustments posted after the settlement was calculated, and reimbursements processed outside the normal settlement cycle.
Stripe Reconciliation
Stripe payouts are straightforward to reconcile because each payout corresponds to a specific set of charges, minus fees and refunds. Pull the Stripe Payout report for the month and match each payout against your bank deposits. Stripe accounting is simpler than Shopify or Amazon because Stripe is purely a payment processor without the additional marketplace fees and complexities.
If you use Stripe with multiple platforms (your own website, an invoicing tool, and a subscription system), payouts may bundle charges from different sources. In this case, use the Stripe Dashboard to filter charges by metadata or source and verify that each source's charges are recorded in the correct income account in your books.
PayPal Reconciliation
PayPal can be the most difficult platform to reconcile because it handles both business payments and personal transfers if not properly separated. If your PayPal account receives both business revenue and personal payments (Venmo transfers, friends and family payments), separate them before reconciling. Use PayPal's Activity Download filtered by transaction type to isolate business payments.
PayPal's fee structure varies by transaction type: standard payments, invoiced payments, micro-payments, and international payments all have different rates. Verify that the fees recorded in your books match what PayPal actually charged. PayPal's monthly statement shows total fees, which should match the sum of your recorded PayPal processing fees for the month.
Common Reconciliation Issues and Solutions
Timing differences at month end. A sale processed on January 31 might deposit on February 1. This creates a temporary mismatch that resolves itself in the next period. Note the timing difference and carry it forward. Do not create adjusting entries for timing differences because the transaction will match in the next period's reconciliation.
Duplicate entries. If both your bank feed and integration app record the same deposit, you have double the revenue and double the deposit in your books. The solution is to match (not add) bank feed transactions against the integration entries. Most accounting software lets you link a bank feed transaction to an existing entry rather than creating a new one.
Missing bank fees. Banks charge monthly maintenance fees, wire transfer fees, and other charges that may not import automatically through the bank feed. Check the bank statement for any fees that do not appear in your books and record them as Bank Fees expense.
Partial refunds and adjustments. A customer refund might not include the original processing fee refund, or it might include a restocking fee that reduces the refund amount. These partial amounts create small discrepancies if your books recorded the full refund but the bank received a slightly different amount. Match the actual amounts rather than the expected amounts.
Currency conversion differences. If you receive payments in foreign currencies, the exchange rate at the time of sale may differ from the rate at the time of bank deposit. This creates realized exchange gains or losses that should be recorded in a separate account. Your international accounting setup should handle these conversions automatically.
Monthly Reconciliation Checklist
- Reconcile all bank accounts (checking, savings, credit cards)
- Match all payment processor deposits (Shopify, Stripe, PayPal, Amazon)
- Verify total revenue by channel matches platform reports
- Verify total fees by processor matches platform fee reports
- Confirm sales tax liability balance is reasonable (collected minus remitted)
- Review inventory value for reasonableness given purchase and sales activity
- Generate and review the profit and loss statement for the month
- Generate and review the balance sheet
- Save or archive all platform reports used for reconciliation
The full reconciliation process takes 30 to 90 minutes per month for a typical ecommerce business selling on one to three channels. Multi-channel sellers with Amazon, Shopify, wholesale, and multiple payment processors may need two to three hours. The time investment is worth it because unreconciled books degrade in accuracy over time, and catching errors monthly is dramatically cheaper than catching them during tax preparation or, worse, during an IRS inquiry.