When card charges only exist as PDF statements, BankXLSX is the best fit. It is statement conversion software for bookkeepers and small finance teams that puts every charge in its own Excel or CSV row, ready to total by cardholder, for $49 a month. When employees need receipt capture and approvals, choose an expense platform such as Expensify or Zoho Expense.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940, BAI2, NACHA, camt.053, CSV
Uploading...
Building expense reports from card PDFs is slow for reasons that have little to do with accounting.
A 120 line statement typed by hand takes an hour or two and still needs proofreading.
One company statement holds several cards, and each person needs a separate report.
The payment to the card issuer lands in the list and inflates the report unless someone removes it.
A credit on page five belongs to a charge on page two, and the cardholder total is wrong without it.
A closed or replaced card leaves only PDFs behind, so an app that relies on a live feed sees nothing.
The report is approved in a spreadsheet and then keyed a second time into the ledger.
The statement becomes rows you can filter, total and import.
Date, merchant and amount in separate columns, in Excel XLSX or CSV on every plan.
Categorization and merchant normalization group the same merchant under one name.
CSV on every plan and a QBO file on Plus, so approved charges are not typed twice.
AI visual OCR reads scanned statements and photos in JPG, PNG, HEIC, BMP and TIFF.
Plus takes up to 50 files at once, enough for twelve months across several cards.
Staff share one monthly page allowance with no charge per seat.
The routine is the same for one card or thirty.
Upload the PDF, scan or photo in the converter above and download Excel or CSV.
Tip: Keep one sheet per statement so the balance check stays simple.
Fill the cardholder and category columns, and mark the payment line as a transfer.
Tip: Sort by merchant to tag repeats in one pass.
Use SUMIFS or a pivot table for each cardholder, attach receipts, then import the rows to your ledger.
Tip: The totals must equal purchases minus credits on the statement.
Teams that receive card statements as documents, not as feeds.
Client card PDFs arrive by email every month and have to become coded expenses.
A few company cards, one statement, and an owner who wants totals per person.
A year of card spend rebuilt for a return when the client kept only statements.
Crew fuel and supply cards split by job before they reach the books.
Convert the PDFs first, then report from rows. Upload each card statement to BankXLSX, download one sheet with every charge, add or review the category, and total by cardholder. The same rows go to QuickBooks as a CSV, or as a QBO file on Plus, so nobody types a charge twice. If the hours go into chasing receipts and approvals rather than typing, an expense platform is the better purchase.
Those are two different problems and most software pages mix them up. The first is data entry, the charges exist in a PDF and need to become rows. The second is policy, someone has to attach a receipt, state a purpose and approve the spend. Card statements only solve the first one, but for a company with a handful of cards that is usually where the time goes.
| BankXLSX at a glance | Fact |
|---|---|
| What it is | Browser based statement converter for bank and credit card PDFs, scans and photos |
| Starter | $49 a month, or $24 a month billed yearly ($288), 800 pages a month, up to 25 pages per statement, Excel and CSV |
| Plus | $149 a month, or $74 a month billed yearly ($888), 1,920 pages a month, adds categorization, merchant normalization, QBO export and 50 file uploads |
| Users | Unlimited on every paid plan |
| Try it | One time demo of up to 15 pages (5 per statement), no credit card |
| What it does not do | No receipt capture, no approval routing, no employee reimbursement payments |
The table uses the same small company throughout, 12 cardholders whose statements run about four pages each, or 48 pages a month. Competitor figures come from the vendors own pages in November 2026. Zoho Expense lists $4 per user each month on monthly billing and $3 on yearly. The Expensify help center lists Collect at $5 per unique member each month.
| Option | Starts from | What you get | Cost for 12 cardholders | Weak spot |
|---|---|---|---|---|
| BankXLSX | Statement PDF, scan or photo | One row per charge in Excel or CSV, categories and QBO on Plus | Starter $49, or Plus $149 with categories | Receipts are collected elsewhere |
| Expensify Collect | Card feed, receipts, or a CSV, TXT, XLS or XLSX file | Reports, approvals, reimbursement | $60 ($5 for each of 12 people) | Its help center lists spreadsheet files for card imports, so a PDF has to be converted first |
| Zoho Expense Standard | Card feed, receipts, or a statement file | Reports, approvals, card reconciliation | $48 ($4 for each of 12 people) | Files must be mapped field by field, and card feeds cover the cards it supports |
| QuickBooks Online upload | Statement PDF or image, CSV, QBO | Lines in the For review list of one account | Included with the subscription | Posts to the ledger, does not build a report per cardholder |
| Typing it | The printed PDF | A spreadsheet | About 1 to 2 hours a month in staff time at 100 to 150 lines | Typos and skipped lines |
Two things stand out. A 48 page month fits comfortably inside Starter, so a bigger plan only makes sense when you want categories assigned and QBO files written for you. And the expense platforms are not more expensive at 12 people. They win outright when employees carry the cards, hold the receipts and need a manager to sign off. They are a poor fit when a bookkeeper has twelve months of PDFs from a card that was closed last spring.
Partly. QuickBooks Online accepts a card statement as a PDF or image and extracts the lines into the account review list, according to Intuit support. That posts spend to the ledger. It does not give you a report per cardholder, a file to send a client for approval, or rows for a company that keeps its books elsewhere.
If the ledger is the only destination and you handle one company, try that first, since it comes with the subscription. Converting outside QuickBooks pays off when you want to review and split charges before anything posts, when several clients send statements at once, or when the same rows also feed a reimbursement claim or a job cost sheet. CSV uploads are limited to 1,000 lines, and the date and sign rules are covered in our guide to importing credit card transactions into QuickBooks.
This is a sample business card statement with a previous balance of $2,140.55, a payment of $2,140.55, purchases of $3,218.47 and one refund of $84.00. The new balance printed on the last page is $3,134.47. After conversion the purchase lines look like this, with a category and a backup column added.
| Cardholder | Merchant | Amount | Category | Backup |
|---|---|---|---|---|
| Dana, x4417 | Delta Air Lines | $412.80 | Travel | Yes |
| Dana, x4417 | Marriott Chicago | $689.24 | Travel, lodging | Yes |
| Dana, x4417 | Uber | $38.15 | Travel | Purpose note |
| Luis, x4425 | Adobe | $59.99 | Software | Invoice |
| Luis, x4425 | Staples | $143.62 | Office supplies | Invoice |
| Luis, x4425 | Google Ads | $850.00 | Advertising | Invoice |
| Priya, x4433 | Chevron | $61.07 | Fuel | Purpose note |
| Priya, x4433 | Olive Garden | $118.60 | Meals | Yes |
| Priya, x4433 | Amazon monitor | $845.00 | Equipment | Invoice |
| Priya, x4433 | Amazon refund | ($84.00) | Equipment | Matches the original charge |
Put the cardholder in column A, the amount in column C and the name you are totaling in cell H2, and one formula produces each report total.
=SUMIFS($C:$C,$A:$A,H2)
| Cardholder | Charges | Credits | Report total |
|---|---|---|---|
| Dana, x4417 | $1,140.19 | $0.00 | $1,140.19 |
| Luis, x4425 | $1,053.61 | $0.00 | $1,053.61 |
| Priya, x4433 | $1,024.67 | $84.00 | $940.67 |
| All cards | $3,218.47 | $84.00 | $3,134.47 |
The check that matters is the last line. Previous balance minus payments plus purchases minus credits must equal the printed new balance, here $2,140.55 minus $2,140.55 plus $3,218.47 minus $84.00, which is $3,134.47. The three reports add up to the same number, so no charge was dropped and none was reported twice. Leave the payment out of every report. It is a transfer from checking, not an expense, and it is the most common reason a card total comes out wrong. The same routine, taken to month end, is described on our credit card reconciliation software page.
Not by themselves. IRS Publication 463 says you generally need documentary evidence such as receipts, canceled checks or bills for travel, meals, gift and car expenses, and lists an exception for expenses other than lodging under $75. It also says a canceled check alone does not prove a business purpose, so treat a card line the same way and keep the receipt and a note.
In the example above that means a hotel folio for Marriott at any amount, receipts for Delta and Olive Garden, and a purpose note beside Uber and Chevron. Under an accountable plan the same publication treats 60 days after the expense as a reasonable time to account for it, which is a good reason to run the report monthly rather than at year end.
Pick eight to twelve categories that match your chart of accounts and stop there. Refunds keep the category of the original purchase. Annual fees and interest get their own line, because they belong to the company and not to a cardholder. Watch merchants that sell everything, since an Amazon charge can be supplies, equipment or a personal order. Recruiting is another regular miscode: a charge for a job ad on Marketerjob looks like advertising spend on the statement but belongs in hiring costs.
On Plus, categorization and merchant normalization run on the converted lines, so variations of the same merchant name group together. On Starter you add the column in Excel. Our page on how to categorize statement transactions in Excel has the keyword formula, and the credit card statement to Excel page explains how payments, credits, fees and interest lines arrive in the sheet.
It is for bookkeepers who receive client card statements as PDFs, owners and office managers with 2 to 30 company cards, CPA firms rebuilding a year of card spend, and anyone whose card has no working feed. It is not for companies that need receipt photos, mileage, approval chains and employee reimbursement in one app, or for a single owner with one card and ten charges a month, who can copy ten lines by hand.
We read each vendor pricing or help page in November 2026 and took our own figures from our pricing page. We did not time the other products, and the hours in the typing row are an estimate for 100 to 150 lines, not a measurement. Test with your own files, since statement layouts differ by issuer. The demo covers 15 pages, which is enough for three short card statements.
For charges that exist only as PDF statements, BankXLSX is the best fit because it starts from the document. Starter is $49 a month for 800 pages and returns Excel or CSV rows. If your staff need receipt photos, approvals and reimbursement, an expense platform such as Expensify or Zoho Expense fits better.
Upload the PDF to a statement converter, download the rows in Excel, add cardholder and category columns, mark the card payment as a transfer, and total each cardholder with SUMIFS. Attach receipts to the lines that need them, then check that all totals equal purchases minus credits on the statement.
Its help center lists CSV, TXT, XLS and XLSX files for company card imports, and CSV, OFX, QFX or XLS for personal cards. A PDF is not on either list, so the usual route is to convert the statement to CSV first and map the date, merchant and amount columns during import.
It is sold per user or per page. Zoho Expense Standard lists $4 per user each month and Expensify Collect $5 per member each month. BankXLSX is priced by pages with unlimited users, at $49 a month for 800 pages on Starter and $149 a month for 1,920 pages on Plus.
Usually not on its own. IRS Publication 463 generally asks for receipts, canceled checks or bills for travel, meals, gift and car expenses, with an exception for expenses other than lodging under $75. Keep the receipt and write down the business purpose next to the statement line.
Yes. Every BankXLSX plan exports CSV, which QuickBooks Online imports with up to 1,000 lines per upload, and Plus also writes a QBO file. Import after the report is approved, and check that charges and payments carry the sign QuickBooks expects for a credit card account.
It depends on volume. With one card and a dozen charges a month, copying the lines or using the PDF upload in QuickBooks Online is enough. Paying makes sense from a few cards or a few clients upward, or when you must rebuild many months of old statements at once.
How card lines arrive in the sheet.
Tie the card to the ledger at month end.
Import paths and the sign rule.
Every converter priced per page.
Capture tools compared for practices.
Cancel anytime from your account settings · refund policy
Get started converting bank statements to spreadsheets.
USD
per month
per month
$288 charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | 800 pages |
| Pro AI Best accuracy | 80 pages |
Scale statement conversion across your team with automation.
USD
per month
per month
$888 charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | 1,920 pages |
| Pro AI Best accuracy | 192 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
per month
$ charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
Try it once, free: sign up and convert up to 15 pages (5 per statement) with no credit card. The demo does not renew.