Ecommerce sellers can convert PDF bank and credit card statements to .qbo files for QuickBooks Online and Desktop so payouts, fees, and ad spend post cleanly.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF
Uploading...
Ecommerce sellers on Shopify, Amazon, eBay, Etsy, Stripe, and PayPal can convert PDF bank and credit card statements into .qbo Web Connect files for QuickBooks Online and Desktop. Upload a statement to the converter at the top of this page and it comes back as a .qbo, so payout deposits, merchant fees, ad spend, inventory buys, and shipping costs post cleanly into the right accounts. QuickBooks cannot read a PDF directly, and this turns any US bank or card statement into a file it imports without hand keying.
Last updated July 2026.
Built for the statements US banks actually send, checked before it exports.
The converter adds up the transactions it parsed and matches that to the statement total before you export, so nothing is silently dropped.
Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.
OCR runs before parsing, so a scanned or photographed paper statement comes out the same as a digital PDF.
Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.
Enter the password on upload. Multi-column and multi-page statement layouts are parsed too.
One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.
Three steps. No column-mapping wizard.
Drag in a PDF, a scan, or a phone photo. Password-protected and multi-page files are fine.
Every transaction is extracted and checked against the statement total. You see the parsed rows before exporting.
Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.
The specifics that decide whether the import is clean. If your case is not here, email [email protected].
When a payout processor like Shopify Payments, Stripe, or PayPal sends money to your bank, the deposit that lands is already net of fees. Your platform showed $10,000 in gross sales, but the bank saw $9,650 arrive after processing fees came out. The bank statement is the source of record for the cash that actually moved, so it has to be right before you reconcile anything else.
History is the second reason. Live bank feeds in QuickBooks usually only reach back about 90 days, and payout dashboards roll off older detail too. A manual upload has no date limit, so a statement from last year imports as easily as last month's. That is how catch-up bookkeeping gets done. Start with the PDF to QBO converter if you have older periods to bring in.
One thing to be clear about: this tool handles the bank and card statement side. It converts the deposits, fees, and charges as they appear on your statement into a clean feed for QuickBooks. It does not do a full order-by-order payout reconciliation that ties every Shopify or Amazon order to its settlement line. That deeper split usually comes from an app or a spreadsheet built off your processor reports. The statement gets your cash accounts accurate first.
Merchant fees are the cost of getting paid, and they show up two ways. Sometimes the processor deposits net and reports the fee separately, so your bank only sees the smaller number. Other times the fee posts as its own line on the statement. Either way, you want fees landing in an expense account (many sellers use a Merchant or Payment Processing Fees account) rather than buried in sales. Recording them separately keeps your gross revenue honest and your margins visible.
A lot of ecommerce spend runs through a business credit card, and that statement converts the same way as a bank statement. Convert it with the credit card statement to QuickBooks tool and every charge keeps its date, merchant, and amount.
Advertising is usually the biggest card line for online sellers. Meta, Google, and TikTok ad charges belong in an Advertising expense account. Inventory is trickier: a payment to a supplier is not automatically an expense, because inventory is an asset until it sells. Many sellers post inventory buys to a Cost of Goods Sold or Inventory Asset account and let their accountant handle the adjustment. Shipping labels, 3PL fees, and packaging round out the card statement.
| Statement line | What it is | Typical QuickBooks category |
|---|---|---|
| Shopify or Stripe payout deposit | Net sales after fees | Sales / Undeposited Funds (split later) |
| Processing fee | Cost of accepting payment | Merchant / Payment Processing Fees |
| Meta or Google Ads charge | Paid advertising | Advertising |
| Supplier or wholesaler payment | Inventory purchase | Cost of Goods Sold / Inventory Asset |
| Shipping label or 3PL charge | Fulfillment cost | Shipping / Freight |
| Sales tax remittance | Tax collected, paid to state | Sales Tax Payable |
| Refund or chargeback debit | Money returned to a buyer | Refunds / Returns (contra revenue) |
Treat this as a starting point, not tax advice. Your chart of accounts and your accountant's preferences decide the exact mapping, but the pattern holds: keep sales, fees, ads, inventory, and tax in separate buckets so your reports mean something.
Sales tax you collect is not revenue, it is money you owe a state. When a remittance debit hits the bank, it should reduce a Sales Tax Payable liability rather than post as an expense. Chargebacks and refunds show up as debits too. A refund reverses a sale, and a chargeback is a disputed charge pulled back by the buyer's bank. Categorizing these as returns or contra revenue keeps your net sales accurate instead of overstated.
Once the .qbo is imported, reconciliation is straightforward: the deposits and charges in QuickBooks match the statement line for line, because they came from the statement. The parsed total is checked against the statement total before you export, so the numbers tie out. If you run several accounts, the bulk bank statement to QuickBooks workflow converts a batch at once.
QuickBooks Online manual uploads accept .csv, .txt, .qbo, .qfx, and .ofx files, up to 1,000 lines and 350 KB per file, in English. There is no date limit on a manual upload, which is why long statement histories import fine. For the full walkthrough, see how to import a bank statement into QuickBooks Online.
Yes, QuickBooks works well for ecommerce when your bank and card data is clean. It handles multiple accounts, sales tax liabilities, and expense tracking across advertising, fees, and inventory. The main gap is that it does not automatically split gross sales from processor fees, so you feed it accurate statement data first and then layer in payout detail from your platform.
Record the Shopify payout as the net deposit that hits your bank, then split it into gross sales and processing fees. Convert your bank statement so the deposit imports with the right date and amount, then use the Shopify payout report to break it into sales and the fee that came out. That keeps revenue gross and fees separate.
Categorize merchant fees to a dedicated expense account, often called Merchant Fees or Payment Processing Fees. When a fee posts as its own statement line, code it directly. When it is netted out of a payout, split the deposit so the fee shows as expense and the full sale shows as revenue. Never leave fees inside your sales number.
Yes. Convert a PayPal or Stripe PDF statement with the converter at the top of this page and it becomes a .qbo you upload into QuickBooks. This brings in the deposits, fees, and transfers as they appear on the statement. For order-level detail, pair it with the reports those processors export, since the statement covers cash movement rather than every order.
Record Amazon seller fees as an expense, separate from your gross sales. Amazon deposits are net of referral fees, FBA fees, and other charges, so the bank sees a smaller number than you sold. Import the deposit from your statement, then use your Amazon settlement report to split it into sales and the fee categories, posting fees to an expense account.
Upload a PDF, get a QuickBooks-ready .qbo back in seconds. No card to try it.
No, QuickBooks does not read PDF statements. It imports .csv, .txt, .qbo, .qfx, or .ofx files, so a PDF has to be converted first. The converter on this page turns your PDF bank or card statement into a .qbo that QuickBooks Online or Desktop reads with no field mapping. You can start from the homepage anytime.
Same converter, tuned for the layout each bank uses. Find yours:
For one bookkeeper running monthly close.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
For an accounting firm or finance team with steady volume. Adds QuickBooks .qbo export and bulk conversion.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
For lenders, audit firms and analysts running thousands of statements a month.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
