--- title: "Convert Merchant Statement PDF to Excel" description: "Need to convert merchant statement PDF to Excel? Use processor reports first, then text-PDF conversion for payouts, fees, refunds, chargebacks, tax, and QBO." canonical_url: https://getbankstatement.com/blog/merchant-statement-pdf-to-excel markdown_url: https://getbankstatement.com/blog/merchant-statement-pdf-to-excel.md last_updated: 2026-09-03 --- # Convert merchant statement PDF to Excel The GetBankStatement Team · September 3, 2026 · 9 min read **Convert merchant statement PDF to Excel when the monthly processor statement is the record you need for close, tax support, fee review, lender packages, or chargeback cleanup. Start with the payment processor export when it gives clean transaction rows. Use text-PDF conversion when the issued merchant statement is the proof file.** The quick answer: if Stripe, Square, Shopify Payments, PayPal, Bank of America Merchant Services, Worldpay, Fiserv, Adyen, Toast, Clover, or another processor can export the exact period to CSV, Excel, payout reconciliation, balance activity, fee, dispute, refund, or settlement reports, use those first. Convert the merchant statement PDF when the official monthly statement is required, older periods are trapped in PDFs, or the workbook must tie statement totals to bank deposits before QuickBooks, tax prep, audit, financing, or controller review. This page targets the exact query convert merchant statement PDF to Excel. It does not claim GetBankStatement has verified parser coverage for every payment processor, merchant acquirer, gateway, marketplace, POS platform, statement layout, fee schedule, or settlement report. Research checked September 3, 2026. Current results are split between generic bank-statement converters, payment-reconciliation posts, processor export docs, and merchant-service support pages. The useful gap is a conservative workflow that keeps payouts, gross sales, processor fees, refunds, chargebacks, reserves, adjustments, deposits, and tax fields visible instead of pretending a merchant statement is just another PDF table. ## Use processor exports before the statement PDF A merchant statement is not just a transaction list. The close package often needs gross sales, captured payments, tips, taxes, discounts, refunds, disputes, chargebacks, chargeback reversals, reserve holds, reserve releases, processing fees, interchange, scheme fees, assessment fees, batch totals, payout IDs, deposit dates, locations, card brands, payment methods, gateway fees, hardware fees, currency conversion, and bank-deposit references. Processor portals usually have better row-level data than the monthly PDF. Stripe's balance report documentation says report sections can be downloaded as CSV, and Stripe support describes Balance Summary and Payout Reconciliation Report exports. Square support says transaction data can be exported as CSV from Square Dashboard and reports can be exported from Dashboard. Shopify Payments documentation says the Payouts page lets merchants export payout transactions to CSV, while the activity report supports period-level review across a date range. PayPal's current reporting docs describe activity, balance reconciliation, fee, and transaction-code reports for payment activity, disputes, fee-incurring events, withdrawals, and transaction classification. Bank of America Merchant Services reconciliation guidance says statement reconciliation uses multiple reports in addition to the monthly statement: sales, funded deposits, disputes, adjustments, fees, and charges. Use the native export when it has the fields accounting needs. A PDF converter cannot recreate a missing payout ID, order ID, processor fee breakdown, interchange detail, reserve release, VAT/GST/HST column, 1099-K support row, dispute status, or processor-side timezone rule that never appears in the PDF. ## When the merchant statement PDF is still the right source - The accountant, bookkeeper, tax preparer, lender, auditor, buyer, controller, franchisor, or investor asked for the official monthly merchant statement. - The processor export gives transaction rows, but the fee total, chargeback total, reserve movement, statement fee schedule, or deposit summary must tie to the issued statement. - The client sent merchant statement PDFs without processor dashboard access. - The processor portal only keeps recent exports, while older merchant statements are still downloadable as PDFs. - A bank deposit needs support from the processor statement because net deposits combine sales, fees, refunds, chargebacks, and adjustments. - The workbook needs one row set by processor, merchant ID, location, terminal, currency, payout, batch, department, store, entity, or statement period before accounting import. Merchant deposits are where bookkeeping gets messy. The amount that hits the checking account is often net of fees, refunds, disputes, reserve movements, and timing differences. Treating the bank deposit as revenue is how gross sales disappear, processing fees vanish, refunds get double counted, and chargebacks become a month-end surprise. ## How to convert merchant statement PDF to Excel - Sign in to the official processor, acquirer, gateway, POS, marketplace, or merchant-services portal on desktop if possible. - Check first for native Excel, CSV, payout, balance, activity, sales, funded-deposit, fee, dispute, adjustment, charge, 1099-K, VAT, GST/HST, QBO, QuickBooks, Xero, OFX, or accounting exports for the exact period. - If the official statement is required, download the original merchant statement PDF from the statements, documents, reporting, deposits, payouts, fees, tax, or reconciliation area. - Use the downloaded PDF, not a scan, phone photo, screenshot, printed packet, merged lender package, or email image. - Upload the original text-based PDF to GetBankStatement. - Export Excel, CSV, JSON, or QBO and label the workbook with processor, merchant ID, location, currency, statement period, and source file. - Compare the converted totals to the PDF before importing anything into QuickBooks, Xero, NetSuite, Sage, a lender model, or a tax support workbook. ## What to keep in the spreadsheet - Statement period, processor, merchant ID, legal entity, store, location, terminal, account, and currency. - Gross sales, captured payments, tips, tax collected, discounts, refunds, voids, reversals, and net sales. - Processor fees, interchange, card-brand fees, assessment fees, gateway fees, monthly fees, hardware fees, PCI fees, and chargeback fees. - Payout date, deposit date, payout ID, batch ID, settlement ID, authorization count, capture count, and bank-reference notes. - Chargebacks, disputes, inquiry amounts, representment, chargeback reversals, reserve holds, reserve releases, adjustments, rejects, and corrections. - Bank deposits, pending balances, ending processor balance, withholding, negative balances, and timing differences. - 1099-K, VAT, GST/HST, BAS, EOFY, sales-tax, and local tax support fields when they appear in the statement or export. If the PDF only contains monthly totals, do not pretend it is transaction-level data. Convert it as statement support, then pair it with the processor's payout, balance, activity, dispute, or fee exports for the rows that explain each deposit. ## How to reconcile merchant statements to bank deposits Start with the bank statement deposit. Match it to the processor payout or funded-deposit report, not directly to gross sales. One bank deposit can represent a payout after processing fees, refunds, chargebacks, reserve changes, currency conversion, processor loans, platform fees, or delayed settlement. Then tie the monthly merchant statement totals to the detailed exports. Sales should agree to the sales or activity report. Deposits should agree to payout or funded-deposit reports. Fees should agree to fee or balance reports. Disputes, chargebacks, reserves, and adjustments should agree to their own reports when the processor provides them. Finally, decide the accounting entry pattern. Many bookkeepers record gross sales, processor fees, refunds, and chargebacks separately so revenue and fees do not disappear inside one net bank deposit. Your accountant should decide the chart-of-accounts mapping, especially for sales tax, VAT, GST/HST, tips, marketplace facilitator taxes, and 1099-K support. ## Where generic PDF-to-Excel tools break merchant statements - Gross sales, fees, refunds, reserves, chargebacks, and deposits flatten into one amount column. - Negative signs, parentheses, debit/credit labels, adjustment signs, and reserve releases flip direction. - Payout IDs, merchant IDs, batch IDs, locations, terminals, and card brands detach from the related rows. - Monthly fee sections turn into transaction rows even though they are statement-summary lines. - Multi-currency statements lose currency codes or mix converted and original amounts. - Rows around page breaks duplicate, disappear, or attach to the wrong payout, location, or merchant account. - Tax support fields such as 1099-K, VAT, GST/HST, BAS, EOFY, or sales-tax columns are stripped out of context. ## GetBankStatement fit and limits GetBankStatement is a fit when you have an original text-based merchant statement PDF and need Excel, CSV, JSON, or QBO output for review. It is especially useful when the PDF is the document of record and copy-paste cleanup would be slower than conversion plus validation. The anonymous GetBankStatement workflow is intentionally narrow. It does not include scanned statements, image-heavy PDFs, OCR-only files, password-protected PDFs, bulk upload, API access, or webhook delivery. Anonymous users can process one preview page every 24 hours. Registered free users can convert up to five text-PDF pages every 24 hours. Uploaded files and generated outputs are deleted within 24 hours. Do not use this article as a parser-coverage claim. A merchant-services PDF from a processor, acquirer, gateway, POS provider, marketplace, or bank may have a custom layout. Convert, then check the financial logic before trusting the workbook. ## Validation checklist before QuickBooks or tax use - Statement opening balance, ending balance, sales totals, fee totals, refund totals, dispute totals, and deposit totals match the PDF. - Processor payout totals match bank statement deposits after expected timing differences. - Gross sales, tips, taxes, discounts, refunds, fees, disputes, reserves, and net deposits remain separate where the accounting workflow needs them separate. - Negative signs, chargeback signs, refund signs, reserve holds, reserve releases, and adjustments point the right way. - Payout IDs, merchant IDs, batch IDs, locations, terminal IDs, card brands, currencies, and settlement dates stay attached to the correct rows. - Rows around page breaks were not duplicated, dropped, or attached to the wrong processor, payout, location, or currency. - QBO, CSV, Excel, or JSON output is reviewed before import into QuickBooks, Xero, NetSuite, Sage, tax software, lender models, or audit workpapers. ## Methodology and sources We checked current search results, processor reporting docs, merchant-services reconciliation guidance, generic converter pages, payment-reconciliation posts, and GetBankStatement product truth on September 3, 2026. The useful gap was not another generic PDF-to-Excel page. It was a merchant-statement workflow that keeps processor exports, official PDF proof, payouts, fees, refunds, chargebacks, reserves, taxes, bank deposits, and GetBankStatement's actual text-PDF limits in one place. - [Stripe balance report](https://docs.stripe.com/reports/balance) — Official Stripe context for balance reports, payout sections, downloadable CSV report data, and reconciliation workflow. - [Stripe exporting payment data](https://support.stripe.com/questions/exporting-payment-data) — Official Stripe support context for exporting payment, Balance Summary, and Payout Reconciliation report data. - [Square view and search transactions](https://squareup.com/help/us/en/article/5145-transaction-search) — Official Square context for filtering transactions and exporting transaction details as CSV from Square Dashboard. - [Square print, export, or email reports](https://squareup.com/help/us/en/article/8362-print-export-or-email-your-reports) — Official Square context for exporting Dashboard reports and report columns. - [Shopify Payments activity report](https://help.shopify.com/en/manual/payments/shopify-payments/payouts/payouts-activity-report) — Official Shopify context for payout transactions CSV export and period-level Shopify Payments activity reporting. - [Shopify lower or missing payouts](https://help.shopify.com/en/manual/payments/shopify-payments/payouts/lower-or-missing-payouts) — Official Shopify context for amount, fee, net, refunds, chargebacks, adjustments, payouts, and payout troubleshooting. - [PayPal Activity Download report](https://developer.paypal.com/reports/activity-download) — Official PayPal developer context for exporting detailed transaction activity by date range, format, and fields. - [PayPal Balance Reconciliation report](https://developer.paypal.com/reports/balance) — Official PayPal reporting context for reconciling payments, disputes, fee-incurring events, and withdrawals. - [Bank of America Merchant Services Statement Reconciliation](https://merchanthelp.bankofamerica.com/Merchant-Services-Statement-Reconciliation) — Official merchant-services reconciliation guidance for sales, funded deposits, disputes, adjustments, fees, and charge reports. - [Worldpay exporting fee data](https://support.worldpay.com/support/iq-reporting-and-analytics-user-guide/content/exporting_fee_data.htm) — Official Worldpay context for exporting fee data and reconciliation-dashboard report data to CSV. - [GetBankStatement full LLM context](https://getbankstatement.com/llms-full.txt) — Current GetBankStatement limits, pricing, privacy, retention, export formats, and unsupported anonymous features. ## Bottom line Use processor reports first when they explain payouts, fees, refunds, disputes, reserves, taxes, and bank deposits. Use the merchant statement PDF when the official monthly statement is the required proof file or the only surviving record. For clean text-based merchant statement PDFs, GetBankStatement can turn the PDF into Excel, CSV, JSON, or QBO. The important work comes next: compare the spreadsheet to the processor reports, statement totals, and bank deposits before sending it downstream. ## Frequently asked questions ### How do I convert merchant statement PDF to Excel? Download the original text-based merchant statement PDF from the processor or merchant-services portal, upload it to GetBankStatement, export Excel, CSV, JSON, or QBO, and then compare sales, fees, refunds, chargebacks, deposits, reserves, and balances back to the PDF and processor reports. ### Should I use a merchant statement PDF or processor CSV export? Use the processor CSV, payout, balance, activity, fee, dispute, or settlement export when you need row-level data. Use the merchant statement PDF when the official monthly statement is the proof file requested by an accountant, lender, auditor, buyer, tax preparer, or internal reviewer. ### Does GetBankStatement support every merchant processor statement? No. This is a statement-family workflow, not a verified parser-coverage claim for every processor, acquirer, gateway, marketplace, POS provider, bank merchant-services statement, fee schedule, or layout. ### Can I convert scanned merchant statements with GetBankStatement? Not in the anonymous workflow. GetBankStatement's anonymous flow is for original text-based statement PDFs and excludes scanned statements, image-heavy PDFs, OCR-only files, password-protected PDFs, bulk upload, API access, and webhook delivery. ### What should I check after converting a merchant statement to Excel? Check gross sales, fees, refunds, chargebacks, disputes, reserve holds, reserve releases, payout IDs, deposit dates, bank-deposit matches, statement totals, negative signs, currency codes, tax fields, and page-break rows before QuickBooks, tax, audit, lender, or close use. ### Can merchant statement Excel files help with 1099-K, VAT, GST/HST, BAS, or EOFY review? They can support review when the source statement includes the relevant sales, fee, tax, payout, or currency fields, but the converted spreadsheet should be reconciled to processor exports, bank deposits, and accountant-approved tax treatment before filing or audit use. ## Related guides - [Bank statement PDF to Excel converter](/bank-statement-pdf-to-excel) — The core text-PDF conversion workflow with exports, validation, and privacy details. - [Bank statement converter vs PDF-to-Excel tools](/blog/bank-statement-converter-vs-pdf-to-excel) — Decide when statement-specific extraction beats generic PDF table conversion. - [Loan statement PDF to Excel](/blog/loan-statement-pdf-to-excel) — A statement-family workflow for lender, payment, payoff, fee, and balance cleanup. - [Business credit card statement PDF to Excel](/blog/business-credit-card-statement-pdf-to-excel) — Convert business-card PDFs without flattening employee, fee, payment, and tax context. - [Commercial card statement PDF to Excel](/blog/commercial-card-statement-pdf-to-excel) — Handle card-portal exports, hierarchy, GL coding, payments, rebates, and fees. - [Convert a statement now](/) — Upload a text-based statement PDF and export Excel, CSV, JSON, or QBO. - [Pricing](/pricing) — Review GetBankStatement free and paid page allowances. - [FAQ](/faq) — Read file type, privacy, deletion, and free-tier answers. [Convert a bank statement PDF to Excel](https://getbankstatement.com/bank-statement-pdf-to-excel) with a free text-PDF test, validation, and 24-hour file deletion.