Bank Statement Conversion for E-Commerce Sellers — Complete UK Guide (2026)

It's 10pm. Your Amazon seller client has just sent you a 30-page settlement statement, a PayPal activity download with 400 line items, and a Shopify Payments CSV that doesn't look like anything your accounting software has ever seen. Their VAT return is due next week, and you're staring at columns of raw transaction-type codes, multi-currency fees, and chargeback reversals that don't add up to any bank deposit you can find.

If this sounds familiar, you're not alone. E-commerce bookkeeping in the UK has exploded in complexity over the last five years, and the bank statement side of it — the bit that should be the simplest part — has become the biggest time sink of all. This guide covers everything you need to know about converting e-commerce seller statements to clean, workable spreadsheets, no matter which marketplace, payment processor, or bank your client uses.

And if you need a solution that handles all of this automatically, BankScan AI processes Amazon, Shopify, eBay, PayPal, Stripe, and high-street bank statements in one place, producing bookkeeping-ready Excel files in under a minute.

Why E-Commerce Bank Statements Are Fundamentally Different

Standard bank statement conversion is relatively straightforward: a single bank sends you a PDF with date, description, money in, money out, and balance. Convert that into columns in a spreadsheet and you're mostly done. E-commerce sellers don't have that luxury. Their financial data arrives from three or four completely different sources, each in a different format:

1. Marketplace settlement reports (Amazon Seller Central, eBay, Shopify Payments) — these show gross sales minus fees, refunds, and adjustments. They are accounting summaries, not bank statements.
2. Payment processor statements (Stripe, PayPal, Worldpay, Klarna) — these handle the actual payment flow, and each has its own export format with different columns and naming conventions.
3. Business bank statements (Barclays, HSBC, Monzo, Tide, etc.) — these show net deposits from marketplaces and processors, often as lump sums that don't match any individual transaction.
4. Multi-currency accounts (Wise, Revolut Business, Airwallex) — increasingly common for sellers trading across Europe and internationally, adding exchange rate calculations to every reconciliation.

The challenge isn't just converting one document — it's converting and reconciling all of them together so that your sales figures, fees, refunds, and bank deposits actually match. Most generic bank statement converters were built for high-street bank PDFs. Throw an Amazon settlement report at them and they produce gibberish.

The Anatomy of an E-Commerce Seller's Statement

To understand why conversion is difficult, let's look at what's actually inside each type of statement an e-commerce seller receives.

Amazon Seller Central Settlement Reports

Amazon settlement reports — accessed from Seller Central under Reports → Payments → All Statements — are the most complex documents in e-commerce bookkeeping. A single settlement might span 14 days and contain transaction types including:

• Order — product sale amount
• Refund — customer return or refund
• Service Fee — Amazon referral fee (typically 7-15% depending on category)
• Shipping Chargeback — carrier claim adjustments
• FBA Inventory Fee — Fulfilment by Amazon storage and picking fees
• Advertising Fee — Sponsored Products and Sponsored Brands charges
• Subscription Fee — Professional selling plan monthly charge
• Other — miscellaneous credits and debits

All these transaction types are listed in a single column. To get useful bookkeeping data out, each row must be interpreted by its transaction type, then split into appropriate income, expense, and adjustment columns. A generic PDF converter or copy-paste into Excel will put everything into one mixed column, making the data unusable for accounting.

Shopify Payments Statements

Shopify Payments is simpler than Amazon at first glance but has its own challenges. Shopify provides two key exports:

Payouts Report: Shows net amount per payout period deposited to your bank. Clean but insufficient for full bookkeeping — it doesn't break down fees per transaction or show individual order detail.

Finances CSV: Provides transaction-level detail including the Shopify Payments processing fee per order, currency conversion markups (typically 1.5-2% above interbank rate), and any chargeback or dispute fees. This is the file you actually need for accurate bookkeeping, but it's dense — a seller processing 500 orders a month can have a Finances CSV running to thousands of rows with column headers that don't map neatly to standard accounting categories.

eBay Payout Statements

Since eBay moved to Managed Payments, sellers no longer receive PayPal payments — eBay collects from buyers and pays sellers directly. eBay payout statements are cleaner than Amazon's but still require conversion for bookkeeping:

• Each payout covers a batch of transactions across multiple days
• Fees are deducted at the individual transaction level (final value fees, promoted listings fees, international fees)
• The payout amount in your bank account is the net of all sales minus all fees, with no per-transaction breakdown on the bank statement
• Refunds are processed against future payouts, which means you might sell an item in May, have it refunded in June, and only see the net effect in your July payout

PayPal Business Statements

PayPal is still widely used by eBay sellers operating outside managed payments, as well as by Shopify sellers using PayPal as a secondary payment method and by independent e-commerce sites. PayPal's transaction history downloads include:

• Standard PayPal fee (2.9% + £0.30 for UK domestic transactions)
• Cross-border fee surcharges
• Currency conversion fees (3-4% above interbank rate — higher than most alternatives)
• Chargeback fees (£14 per chargeback in the UK)
• PayPal Working Capital loan repayments (deducted as a percentage of each sale)

PayPal's CSV exports include all of this data, but the fee lines and the sale lines are separate rows, requiring them to be paired up before you can calculate net revenue per transaction. Multi-currency transactions appear with both the original currency amount and a GBP equivalent, but the exchange rate used is buried in the detail column — not its own field.

Stripe Statements

Stripe is the payment processor behind Shopify Payments and powers countless independent e-commerce sites. For sellers using Stripe directly (rather than through a marketplace), Stripe's dashboard provides:

• Balance reports: Summarise all pay-ins, pay-outs, and fees over a period
• Payout reconciliation reports: Show which transactions are included in each bank deposit
• Individual transaction exports: Include Stripe processing fees, refund details, and dispute information per transaction

Stripe's CSV exports are among the cleanest in the e-commerce space, but they don't eliminate the core problem: you still have to reconcile Stripe payouts (which arrive in your bank as lump sums every 2-7 days) against the individual transactions they contain. The Stripe payout of £3,247.18 in your Barclays statement doesn't tell you which 87 orders it came from without cross-referencing the Stripe reconciliation report.

E-Commerce Statement Formats Compared

The Reconciliation Problem: Matching Marketplace Settlements to Bank Deposits

This is where most e-commerce bookkeepers hit a wall. Let's walk through a real scenario:

Your client sells on Amazon UK and Amazon EU. On 15 May, their Barclays business account receives a deposit of £12,847.33 from "Amazon Payments". On the same day, a separate deposit of €3,421.50 arrives from "Amazon EU Sarl". Neither of these amounts matches any single transaction, order, or invoice in your client's records.

To reconcile, you must:

1. Locate the settlement period in Amazon Seller Central that corresponds to these deposits (typically 14 days, ending about 5-7 days before the bank deposit date).
2. Download the settlement report — a CSV or flat text file listing every order, fee, refund, and adjustment within that period.
3. Convert the settlement report into a spreadsheet with separate columns for gross sales, Amazon fees (by type), refunds, and the net settlement amount.
4. Verify the total matches the bank deposit, accounting for any reserve Amazon holds (typically 7-14 days of gross sales set aside for potential refunds).
5. Handle currency conversion for the EU deposit — the settlement report shows amounts in EUR, but your bank statement shows the GBP equivalent at whatever rate the receiving bank applied.
6. Repeat for every marketplace — Amazon UK, Amazon EU, eBay, Shopify, and any direct website sales through Stripe or PayPal.

This process, done manually for a seller active on three marketplaces, can take 3-5 hours per month. For a busy Amazon seller with high transaction volume or sellers active on five or more European marketplaces, it can stretch to a full day of work. And that's before you've done any actual bookkeeping — you've just prepared the data.

VAT on Marketplace Fees — A Hidden Complexity

One of the most frequently overlooked aspects of e-commerce bookkeeping is VAT treatment of marketplace fees. Since the 2021 marketplace facilitator rules, Amazon and eBay collect and remit VAT on sales in the UK and EU, which simplifies the sales side. But the fees side is different:

• Amazon referral fees, FBA fees, and advertising fees — These are B2B services provided to you as a seller. If you're UK VAT-registered, Amazon charges UK VAT on these fees. You can reclaim this input VAT on your VAT return, but only if you record it correctly.
• Cross-border marketplace fees — If you sell on Amazon.de, Amazon.fr, or other EU marketplaces, the fees may carry local VAT at that country's rate. You may need to use the reverse charge mechanism or, if registered for VAT in that country, reclaim the local VAT through that country's system.
• eBay final value fees — eBay charges UK VAT on fees for UK-registered sellers. These need to be split out of the payout statement and recorded as an expense with recoverable VAT.
• Stripe processing fees — Stripe is based in Ireland for EU/UK sellers. Stripe fees are subject to the reverse charge for UK VAT-registered businesses — you don't pay VAT to Stripe but must account for it on your VAT return.

If your converted statements don't cleanly separate the fee from the VAT on that fee, you'll either overpay VAT (by not reclaiming input tax) or underreport it (by failing to apply the reverse charge correctly). Either way, HMRC penalties can follow.

A Practical Workflow for E-Commerce Bookkeepers

If you're a bookkeeper or accountant handling e-commerce clients, here's the workflow that actually works at scale:

Step 1: Collect All Statement Sources Monthly

For each client, gather these files at month-end:

• Business bank statement PDFs (Barclays, HSBC, Monzo, Tide, etc.)
• Amazon settlement reports (CSV download from Seller Central → Reports → Payments → Date Range Reports)
• Shopify Finances CSV (Shopify Admin → Finances → Export)
• eBay payout CSV (Seller Hub → Payments → Download Report)
• PayPal activity download (PayPal → Activity → Download → CSV)
• Stripe export (Stripe Dashboard → Payments → Export)
• Any multi-currency account statements (Wise, Revolut, Airwallex)

Step 2: Convert Everything to a Consistent Format

This is the bottleneck. Converting each source individually using different tools and methods — and then manually formatting them to have consistent columns — is where 80% of the time goes. BankScan AI handles this step by processing all statement types through a single upload, producing unified spreadsheets with standardised columns (date, description, reference, debit, credit, currency, category).

Step 3: Reconcile Marketplace Settlements to Bank Deposits

With everything in a consistent spreadsheet format, use VLOOKUP or XLOOKUP to match bank deposit amounts to settlement report totals. Flag any discrepancies — a deposit that doesn't match a settlement total may indicate a reserve release, a missed report, or a payment processor deposit (Stripe, PayPal) that needs to be matched separately.

Step 4: Split Fees and VAT

For each marketplace and payment processor, separate the fee lines from the sales lines. Record the net fee amount and the VAT component in separate columns. For Stripe and other reverse-charge services, create a journal entry for the reverse charge calculation.

Step 5: Import into Accounting Software

Import the cleaned and reconciled data into Xero, QuickBooks, Sage, or FreeAgent. BankScan AI formats output to match each platform's import requirements, eliminating column mapping errors and rejected imports.

How BankScan AI Handles E-Commerce Statements

BankScan AI was built specifically for the complexity of UK financial documents, including the e-commerce formats that trip up generic converters. Here's how it handles each source:

Amazon Settlement Reports: BankScan AI reads the transaction-type field on each row and routes the data to the correct output column — Order amounts to Sales, Service Fees to Amazon Fees, Refunds to a dedicated refund column, FBA fees to Fulfilment Costs, and advertising fees to Advertising. The net settlement total is calculated and displayed for easy reconciliation against the bank deposit.

Shopify Payments: The platform reads both the Finances CSV and Payouts report, correlating them to produce a bookkeeping-ready spreadsheet with gross sales, Shopify processing fees, currency conversion costs, and net payouts in separate columns. Multi-currency transactions are flagged with the original and converted amounts.

eBay Payouts: Transaction-level detail — sales, final value fees, promoted listing fees, shipping label costs, and refunds — is extracted and sorted into consistent debit/credit columns. BankScan AI also identifies refund timing mismatches, flagging refunds that offset future payouts for attention during reconciliation.

PayPal Statements: The platform pairs fee rows with their parent transaction rows, producing a net revenue per transaction that accounts for all PayPal charges. Multi-currency line items are decoded from PayPal's detail columns with the exchange rate extracted into its own field.

Stripe Exports: BankScan AI reads Stripe's payout reconciliation reports alongside balance reports, automatically matching individual transactions to their parent payout. This eliminates the manual cross-referencing step that typically consumes the most time with Stripe data.

High-Street Bank Statements: For the bank side of things, BankScan AI handles all major UK banks — Barclays, HSBC, Lloyds, NatWest, Monzo, Starling, Tide, Revolut, and more — converting PDF and scanned statements to clean Excel with the same AI-powered parsing engine.

Frequently Asked Questions

Why are e-commerce bank statements so much harder to convert than standard bank statements?

E-commerce sellers receive statements from multiple sources — payment processors (Stripe, PayPal), marketplaces (Amazon, eBay), and their business bank account — all in different formats. Marketplace settlement statements show gross sales minus fees, refunds, and adjustments, while bank deposits show net amounts that don't match individual transactions. Reconciling these sources requires understanding the full payment flow, not just converting one document. Generic converters designed for high-street bank statements cannot handle the nested fee structures, multi-currency line items, and chargeback reversals that are standard in e-commerce statements.

How do I convert an Amazon Seller Central settlement statement to Excel?

Amazon settlement reports come as flat CSV or text files with dozens of transaction types (Order, Refund, Service Fee, Shipping Chargeback, etc.) packed into a single column. Each row needs to be interpreted by its 'transaction-type' field before it can be split into meaningful debit/credit columns. BankScan AI processes these reports automatically, separating sales, fees, refunds, and adjustments into clean columns ready for Excel, Xero, or QuickBooks. For PDF-format settlement statements — common with older Amazon accounts or downloaded Europe-specific reports — BankScan AI's OCR handles the extraction with the same transaction-type awareness.

Can I convert Shopify Payments statements for my UK bookkeeping?

Yes. Shopify Payments exports include a 'Finances' CSV export and a payouts report. The payouts report is cleaner but only shows net amounts per payout period. The full finances export gives you transaction-level detail including Shopify's processing fee per order, currency conversion fees, and chargeback reserves — but it's a dense file that benefits from automated structuring. BankScan AI reformats Shopify Payments exports into bookkeeping-ready columns (date, description, gross, fees, net, currency) for direct import into Xero, QuickBooks, or Excel.

How do I reconcile marketplace settlements with my bank deposits?

Marketplaces like Amazon and eBay don't deposit individual order amounts — they deposit net settlement batches that may combine hundreds of transactions across multiple days. To reconcile, you need to compare each deposit on your bank statement against the corresponding settlement report period from the marketplace. The bank deposit amount should match the settlement total minus any reserve holds. BankScan AI helps by converting both your bank statements and marketplace reports into a uniform format, making it easy to match settlement periods to deposits in a spreadsheet with VLOOKUP or XLOOKUP.

Do I need to account for VAT on marketplace fees if I sell cross-border?

Yes, and this is one of the most frequently missed items in e-commerce bookkeeping. Since 2021, marketplace facilitator rules mean Amazon and eBay collect and remit VAT on sales in certain jurisdictions, but sellers still need to account for VAT on marketplace fees (referral fees, FBA fees, advertising fees). If you're VAT-registered, these fees often carry VAT that you can reclaim — but only if you have the correct invoice or statement detail. Cross-border sales through European marketplaces add further complexity with different VAT rates per country and potential reverse charge obligations on B2B services like Stripe processing fees. Keep your marketplace settlement reports meticulously, as they provide the fee breakdown necessary for accurate VAT returns.

What is the fastest way to process multiple marketplace statements for a bookkeeping client?

For bookkeepers handling multiple e-commerce clients, batch processing is essential. BankScan AI's bulk upload feature lets you drag and drop all your client's statements — bank PDFs, Amazon CSVs, Shopify exports, Stripe reports, PayPal statements — at once and receive a unified, reconciled spreadsheet with consistent columns. This cuts a 3-hour monthly reconciliation process per client down to roughly 10 minutes, letting you serve more e-commerce clients without adding headcount. The platform also remembers each client's statement format, so repeat monthly processing becomes even faster.

How do I handle multi-currency in e-commerce bank statements?

Multi-currency is standard in e-commerce. Amazon EU, eBay international sales, and Shopify Markets all involve transactions in EUR, USD, or other currencies that arrive in your UK bank account as GBP. The key challenges are: (1) marketplace exchange rates differ from interbank rates by 2-4%, (2) your bank may apply its own conversion rate and fees on the deposit side, and (3) currency fluctuations between sale date and settlement date create small gains or losses. To handle this properly, record the original currency amount, the exchange rate used, and the GBP equivalent as separate columns. Read our full multi-currency statement guide for a deeper breakdown. BankScan AI automates this by extracting all three values from each multi-currency transaction line.

Should e-commerce sellers use bank feeds or manual import for Xero and QuickBooks?

Bank feeds work well for the business bank account side — they automatically pull in the net deposits from Amazon, eBay, and payment processors. However, bank feeds alone are insufficient because the net deposit amounts don't provide transaction-level detail for bookkeeping. You still need to process the marketplace settlement reports and payment processor statements separately. The most effective approach is: use bank feeds for the bank account (automatic), and manually import the converted marketplace and processor statements as separate transaction batches with full line-item detail. This gives you both the automated bank reconciliation and the granular reporting you need for accurate P&L statements, VAT returns, and marketplace fee tracking.

Last updated: 20 May 2026. Have a question about e-commerce bank statement conversion? Visit BankScan AI or read our other guides for UK accountants and bookkeepers. Next read: our multi-currency statement handling guide and automation guide for sole practitioners.