Free Bank Statement Converter for Excel, CSV & QuickBooks
Turn supported bank and credit-card statements into structured transaction data you can review and reuse. Upload a statement, choose an available output, check the extracted rows, and download the result.
No sales call required. If you repeat the same statement download, cleanup, import, and reconciliation process every month, Autymate can help determine whether the recurring workflow can be automated.
Choose your file
Drop your bank statement here
Your file is never uploaded. We never receive it or store it.
The Check No Other Free Converter Does
A bank statement converter online has to infer where the numbers are, so this one checks its own reading before you download anything. Where your statement prints a running balance after each line, every transaction is verifiable against it, and every one is verified. Any line that does not follow is named, with its line number and the exact difference.
Reading a statement is inference. A converter can misread an amount, merge two lines, or drop a transaction entirely, and the output still looks perfectly reasonable. So this one proves its work instead of asking you to take it on trust.
What comes back is a report rather than a pass mark. It states how many transactions were read, the period they cover, the opening and closing balance it derived, and how many lines follow the balance. In the report beside this, 41 of 42 do, and the one that does not is line 38, off by 416.25 and named, so you know which row to hold against the paper in front of you.
| Transactions read | 42 |
|---|---|
| Date range | 1–31 Mar 2026 |
| Opening balance | 4,812.60 |
| Closing balance | 5,062.10 |
| Lines verified | 41 of 42 follow the balance |
| Line 38 | Example TransferOff by 416.25 |
Every line is checked before you can download, and a line that does not follow is named with its exact difference rather than reported as a file that went wrong somewhere.
One Upload, Five Outputs
The statement is read once. Switching the output re-converts it without a second upload.
QBO for Bank Feeds
The QuickBooks Web Connect file, written by the same writer the dedicated QBO pages use. It carries the Intuit Bank ID your bank publishes, which QuickBooks checks before it will read the file at all.
CSV for Spreadsheets
Clean columns and correctly signed amounts, for review, for a system that takes a delimited file, or for handing to whoever does the coding. Tab-separated if that suits the destination better.
Excel for Analysis
A real .xlsx workbook with amounts typed as numbers rather than text, so filters, subtotals and pivots work on it immediately instead of after a column of repairs.
IIF for QuickBooks Desktop
The route when Web Connect will not take the file. An IIF posts through an import rather than a bank feed, which is a different door into the same company file.
QIF for Quicken and GnuCash
The Quicken Interchange Format, for the personal-finance and open-source applications that read a register rather than a bank feed. Categories travel with the entries where the source has them.
What Gets Read Off a Statement
Six fields come off each line, and each one is kept the way the statement wrote it.
The Date, As Printed
The date is carried through in the form the statement used and parsed into a real date on the way out, so a day-first statement read as month-first shows up in the preview rather than three months into your accounting system.
The Description, Unedited
The text between the date and the numbers is kept as the statement wrote it. A payee that wraps onto a second line is joined to the row it belongs to, because a line only begins a transaction when it starts with a date.
Debit and Credit, With Their Column
Where money out and money in sit in two columns, both are read and the direction comes from the column the figure was printed in. Credit less the absolute value of debit, so a withdrawal written without a minus sign still comes out negative.
The Signed Amount, Computed Last
One signed figure is produced only after the direction is settled, never before. That ordering is why a statement using brackets for withdrawals, or a trailing minus, or a European decimal comma reaches the same answer as one that does not.
The Running Balance, Kept Not Recalculated
Where a balance is printed it is preserved exactly as printed and used as the control. It is never recomputed from the transactions, because a balance derived from the rows would agree with the rows by construction and prove nothing.
The Period, Before You Import It
Every conversion is summarised ahead of the download: how many transactions were read, how many rows were skipped, and for a bank feed file the period they cover. Converting the same month twice is visible there rather than after two sets of rows have landed.
How to Convert a Bank Statement
The statement is read once, and every step after that happens on your own machine.
Drop the Statement
It works as a PDF bank statement converter, and it takes a CSV or Excel export or a .qbo, .ofx or .qfx download just as readily. The file is read in your browser, so nothing is uploaded and there is no sign-up.
.pdf · .csv · .xlsx · .qbo · .ofx · .qfx
Pick the Output
QBO, CSV, Excel, IIF or QIF. The statement is already read by this point, so changing your mind re-converts what is in memory instead of asking for the file again.
5 outputs, one upload
Say What the Numbers Mean
Banks differ in what the figures after the description are, so the layout is a question rather than a guess. Map the balance column where the statement prints one, because that column is what the check runs on.
amount · amount + balance · debit/credit + balance
Read the Report, Then Download
The reconciliation report, the transaction count and every line the reader could not use are on screen above the download, not discovered afterwards.
checked before download
Why We Are Careful About This One
Most free tools on this search are a thin parser wrapped in a landing page.
A Thin Parser Fails Quietly
They work on the banks the author tested and fail quietly on the rest, which for financial data is worse than not working at all. You will occasionally be told this tool cannot help you. That is deliberate, and it is the same reason the reconciliation report sits above the download button rather than below it.
No Bank List
There is no compatibility table here because the converter reads the structure of a statement instead of matching a template per bank. It works on banks we have never seen, and an unusual layout tends to need a setting changed rather than a bank added.
Send the Layout, Not the Statement
If your bank's layout does not parse cleanly, tell us which bank it is and describe how the columns are arranged. Layouts are what we improve. Your data we neither want nor receive, and the file never leaves your computer for us to ask for.
Twelve Statements Is Twelve Passes
One statement takes one pass. A year takes twelve, and that is the whole difference.
| Need | Free converter | Autymate |
|---|---|---|
| One statement, once | The right tool for the job | Nothing here to automate yet |
| A year of statements | One file at a time, twelve times over | One scheduled run per account where the source allows it |
| The same bank every period | The same upload and the same column mapping each month | Mapping approved once and reused |
| Several accounts or entities | A separate conversion per file | Controlled routing per account and company |
| A line that does not agree | Named here, then yours to chase | Validation, error context and a named owner |
A Clean Conversion Is Not Reconciled Books
A successful conversion is a claim about the file, not a claim about your accounting.
Converted Is Not Reconciled
A successful run means the tool produced structured output from your statement. It does not mean the accounting is reconciled, or that a single transaction is coded to the account it belongs to. That work still happens where your chart of accounts and your matching rules already live.
No Balance Column, No Check
When a statement prints no running balance there is nothing to verify the reading against, and the tool says exactly that. It shows the transaction total for you to compare by hand instead, rather than implying a check that did not happen.
Page Furniture Is Not a Transaction
A line becomes a transaction only when it starts with a date, so headers, footers and statement notes are not converted into rows. A dated line whose amount cannot be read is reported as skipped, with the text it came from, instead of being passed through as a zero.
Repeated Rows Are Not Collapsed
Two identical charges on one day are two transactions, so nothing is merged because it looks the same. Each row in a bank feed file carries an id built from its own date, amount and description, with an occurrence number where rows genuinely match, so QuickBooks still skips what it has already imported.
Across Accounts and Locations
One statement is one file. What multiplies is everything around it once the same statement arrives every period, for every account, every entity and every company file.
- A different statement layout per bank, standardised before anything reaches accounting
- Account and location coding held as approved rules rather than rebuilt in a spreadsheet each period
- Separate QuickBooks companies, with routing scoped where the source and the destination support it
- A statement that arrives late, with a completeness check and a named owner
- A new location brought on through a documented mapping process instead of a fresh guess
- Historical catch-up, with period boundaries and duplicate prevention agreed before anything loads
Common Questions
What people ask before they trust a converter with their accounting system.
It extracts transaction data from a supported bank or credit-card statement and restructures it into a reusable output such as Excel or CSV, or into an accounting transaction file where the destination needs one. On this page the statement is read once and any of five outputs can be written from that single reading.
Yes, where the converter can read the statement layout reliably. The result is a real .xlsx workbook with amounts typed as numbers, and the dates, descriptions, debit and credit direction, amounts and balances are still worth a read before it is used for accounting.
Yes, whenever transaction rows can be extracted from the statement. CSV suits portable review, imports into another system and downstream processing, and the same reading also writes a tab-separated file where the destination prefers one.
Yes. QBO is one of the five outputs in the picker, written by the same Web Connect writer the dedicated QBO pages use. QuickBooks Desktop reads .QBO files through Bank Feeds, and the file has to carry the Intuit Bank ID for your bank before QuickBooks will accept it.
There is no bank list, because the converter reads the structure of the statement rather than matching a template per bank. That means it works on many banks we have never seen, and it also means an unusual layout may need the column layout or the statement year adjusted. The balance check tells you immediately whether it worked.
No, and it will say so rather than guessing. A scan is an image, and reading one needs character recognition, which cannot run in a browser at the accuracy financial data deserves. If your PDF has no text in it, download the same period again from online banking. A text PDF or a CSV is almost always available.
Not yet. It is one file at a time, so a year of statements means twelve passes, which is honest but tedious. If you are doing that regularly the conversion is not really the problem, and the conversation worth having is about connecting the bank to your accounting system directly.
No. It is read on your own computer and never sent to us, so there is nothing for anyone to store, keep or delete. The only external request this page makes is for the PDF reader library the first time you convert a PDF, and that request carries nothing about your file.
Yes. Intuit currently documents manual upload of an account statement as a PDF or an image. If that native workflow meets the need, a converter may be unnecessary, and the shorter path is the better one.
Current Intuit guidance supports transaction-list uploads using QBO, QFX or CSV files, subject to the file and field requirements in force at the time. Three of those five outputs therefore land somewhere QuickBooks Online will take them.
No, and no free converter can honestly claim it. Layout, scan quality, merged descriptions, missing balances and unusual formatting all affect extraction. What this tool does instead is tell you: lines it could not read are listed, and where the statement prints balances the reading is checked against them before you download.
Written and maintained by The Autymate integrations team. We build and run accounting integrations for multi-location franchises, ISVs and bookkeeping firms: QuickBooks Desktop and Online, POS, payroll and ERP. These converters exist because we kept writing the same ones for customers, and there was no reason to keep them to ourselves.
Last reviewed
When the Statement Is Only the First Step
Converting the file is rarely the whole job. If the same download, the same cleanup, the same mapping and the same import repeat every period, tell us which bank the data starts at, which accounting system has to receive it, and how many accounts are in play.
Exact source access, fields, permissions, QuickBooks behaviour and service scope are confirmed during discovery.