PDF Bank Statement to QuickBooks for Ecommerce Sellers: Convert Processor and Payout Statements to QBO

An online store rarely runs on one account. Money moves through a business checking account, Stripe, PayPal, Shopify Payments, and Amazon settlements, and most of those payouts land net of fees with no clean QuickBooks feed. PDFQBO converts each PDF statement into a QuickBooks QBO file so every payout, fee, and refund reaches your books instead of a spreadsheet.

Quick answer

To get an ecommerce bank or processor statement into QuickBooks, convert the PDF to a QBO file first. Upload the statement to PDFQBO, review the payouts, fees, and refunds it reads, and download a QBO (Web Connect) file. Then import it into QuickBooks Online or Desktop. The same works for Stripe, PayPal, and other processor statements that never connect to a bank feed.

Bank and processor PDFs Payouts net of fees Review before import

Last updated July 2026

Convert a store statement to QBO

Upload a bank or processor PDF and download a QBO file for QuickBooks.

No credit card required to try your first statement.

Any account

Bank, Stripe, PayPal, cards

QBO + IIF

Online and Desktop

Fees split

Gross sales, fees, refunds

Auto delete

Files removed after use

How to convert an ecommerce statement to QuickBooks

Four steps take you from a PDF statement to a QBO file QuickBooks accepts, whether it came from your bank, Stripe, PayPal, or a business credit card.

Gather the PDFs

Download the monthly statement from your business checking account and each processor: Stripe, PayPal, Shopify Payments, Amazon. Most of these produce a PDF or a statement you can save as one, and none of them feed cleanly into QuickBooks.

Upload to the converter

Drag the statements into the tool above. A high-volume store with hundreds of orders and daily payouts converts as easily as a slow month, and you can upload several accounts or months at once.

Review the transactions

PDFQBO reads the date, description, and amount on each line and keeps payouts, fees, and refunds on the correct side. Check the table, fix anything that needs a tweak, then export a QBO or IIF file.

Import into QuickBooks

Upload the QBO file from the Banking screen in QuickBooks Online, or import the Web Connect or IIF file in Desktop. The transactions land in the right account, ready to categorize to sales, merchant fees, and cost of goods.

Why ecommerce books are hard to get into QuickBooks

Money runs through several processors, not one bank feed

A single store can collect through Stripe on the website, PayPal at checkout, Shopify Payments, and Amazon for marketplace orders. Each processor holds the money, takes a fee, and deposits a payout into your bank days later. QuickBooks bank feeds only see the payout that lands in checking, so the sales, fees, and refunds behind it are missing unless you bring in each processor's own statement.

Payouts arrive net of fees, so a bank-only import understates sales

A processor deposits your sales minus its cut, so the bank shows one net number while the processor statement shows gross sales, the processing fee, and any refunds separately. If you only import the bank, your revenue looks low and your fees vanish. Converting the processor PDF lets you record gross sales and the fee as its own expense, which is what your profit and loss and your tax return need.

Refunds, chargebacks, and reserves muddy the deposit

Online sellers deal with returns, disputed charges, and rolling reserves that a bank line never explains. The processor statement itemizes each one. Converting that PDF gives you the refund and chargeback detail so your income is accurate and you are not guessing why a payout was smaller than the sales you shipped.

Built for multi-processor ecommerce books

One tool for every statement behind your store, so reconciliation and your real margin come together faster.

Processor statements, not just the bank

Stripe, PayPal, Shopify Payments, and similar payout statements come as PDFs with gross sales, fees, and refunds listed. Convert each one so the detail behind every bank payout is in QuickBooks, not stuck in a processor dashboard.

Handles long, busy statements

A month with daily payouts and hundreds of transactions converts in one pass. PDFQBO captures each line rather than making you copy a wall of activity, which is where ecommerce bookkeeping usually bogs down.

Business credit card statements

The card you use for inventory, ads, and shipping supplies comes as a PDF too. Convert it to a QBO file so those costs are in QuickBooks and coded to the right account, not left off the books at tax time.

Review before it posts

You see every extracted transaction in a table and can correct it before export. That matters when payouts, fees, refunds, and transfers are mixed together, so nothing gets coded to the wrong side of the ledger.

Batch several months

Behind after a busy Q4? Upload a quarter or a year of bank and processor statements together and convert them in one session. Each file is tracked on its own so you can see what converted cleanly.

Reads any layout

Chase, Bank of America, a local bank, Stripe, or PayPal each format a statement their own way. PDFQBO finds the transaction rows on each one and leaves out the summary boxes that are not transactions.

Who uses it in an online store

Anyone keeping an ecommerce business's books in QuickBooks from PDF statements.

Shopify and website sellers

You collect through Shopify Payments and maybe Stripe or PayPal on the side. Converting each payout statement plus the bank gets gross sales, fees, and refunds into QuickBooks so your margin is real, not a net deposit guess.

Amazon and marketplace sellers

Amazon settlements bundle sales, referral fees, FBA fees, and refunds into one payout. Converting the settlement PDF and the bank statement keeps those pieces separate in QuickBooks instead of one lump you cannot explain later.

Ecommerce bookkeepers

If you do books for online stores, clients hand you PDFs from several processors, not a clean feed. One converter for bank and processor statements gives you a repeatable way to bring any client's month into QuickBooks and reconcile it.

Year-end and tax catch-up

Behind on the books before tax time? Batch convert every bank and processor statement for the year, import the QBO files, and categorize. It beats rebuilding a year of payouts and fees by hand from processor dashboards.

Common ecommerce categories once the transactions are in

Once the statements are converted and imported, you code each transaction to an account. These are the categories an online store leans on most, and having every payout and fee in QuickBooks is what makes your gross margin and your tax numbers trustworthy.

• Product sales recorded gross, before the processor takes its fee.
• Merchant and processing fees from Stripe, PayPal, Shopify Payments, and Amazon.
• Cost of goods sold for inventory you buy to resell.
• Advertising for Meta, Google, and marketplace ad spend.
• Shipping and fulfillment for postage, boxes, and FBA or 3PL fees.
• Refunds and chargebacks netted against sales, not hidden in a payout.

For a step-by-step on coding the imported lines, see the guide on categorizing bank transactions in QuickBooks, and to handle payouts that arrive net of fees, the business credit card reconciliation guide.

Frequently asked questions

How do I get an ecommerce bank statement into QuickBooks?

Convert the PDF statement to a QBO file, then import it. Upload the bank, Stripe, PayPal, or Shopify Payments statement to PDFQBO, review the payouts, fees, and refunds it reads, and download a QBO (Web Connect) file. In QuickBooks Online you upload it from the Banking screen; in Desktop you import the Web Connect or IIF file. This works even for processor accounts that have no bank feed.

Is QuickBooks good for ecommerce accounting?

QuickBooks works for ecommerce when every processor and bank account is in it and sales are recorded gross with fees split out. The multiple processors and net payouts are what trip sellers up. Converting the bank and processor PDFs to QBO files gets the full picture into QuickBooks, and from there it handles profit and loss, gross margin, and tax prep.

How do I record Stripe or PayPal payouts in QuickBooks?

Record the gross sales as income and the processor fee as an expense, so the net equals the payout that hit your bank. Converting the Stripe or PayPal PDF statement gives you both numbers plus any refunds. Import it alongside the bank statement and reconcile, and your sales and fees are both accurate instead of buried in one net deposit.

Can I convert Amazon settlement statements to QuickBooks?

Yes. Save the Amazon settlement report as a PDF and convert it like any other statement. The settlement bundles sales, referral and FBA fees, and refunds into one payout, so converting it keeps those pieces separate in QuickBooks instead of one lump. Import the resulting QBO file and reconcile it against the deposit Amazon sent to your bank.

Can I convert a whole year of store statements at once?

Yes. Upload every monthly PDF from your bank and each processor for the year and convert them together. Each file is tracked separately, so you export a QBO file per account per month and import each into the matching QuickBooks account. Batch converting is how most sellers catch up after a busy season.

Do I need to install software to convert the statements?

No install is required. PDFQBO runs in your browser, so you can convert a statement from a laptop or tablet without buying and installing a Windows desktop program. You review each file before exporting, and your first statement is free to try.

Get your store statements into QuickBooks

Upload a bank or processor PDF, review the payouts, fees, and refunds, and download a QBO file QuickBooks accepts. No install, and your first conversion is on us.

Convert a statement View pricing