bank statement → OFX

Bulk Bank Statement Converter: Convert Multiple Bank Statements and Batch Convert PDF Statements to OFX, QFX and CSV

Upload a year of statements at once instead of one PDF at a time. Up to 50 files per batch, from one account or many banks, exported as a single import ready file.

Up to 50 files per batch
Merge into one file
256-bit encryption

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your bank statement

Extract:
|
|
<OFX> for MS Money & accounting software, <CSV> for spreadsheets

How bulk bank statement conversion works

A bulk bank statement converter takes a stack of PDF statements in one upload instead of one file at a time. You can send up to 50 statements per batch here, each up to 50MB, from one account or from several different banks, and export the extracted transactions as OFX, QFX, QIF, CSV, Excel or JSON. There is also a merge option that combines the statements into a single extraction first, which is what you want when twelve monthly PDFs all belong to the same account and you would rather import one file than twelve. For Quicken, export QFX rather than plain OFX, because QFX carries the transaction identifiers Quicken uses to spot duplicates when batches overlap.

Why one file at a time stops working

Converting a single statement is a two minute job. The moment the work is a year of history, or a client folder, or several accounts at once, the per file workflow is where the whole afternoon goes.

A Year of History Is Twelve Uploads

Banks typically serve about 90 days of downloadable activity while the statement archive goes back years. Catching a register up to date means working through twelve or twenty four separate PDFs, and every one is another upload, another export, another file to keep track of in the downloads folder.

Twelve Files Means Twelve Imports

Even after the conversions are done, importing them one by one into Quicken, MS Money or your accounting software repeats the same dialog a dozen times. Each import is another chance to pick the wrong account or lose track of which month you already did.

Multiple Accounts Multiply Everything

A small business with a checking account, a savings account and two cards is four statements a month. A bookkeeper onboarding a new client is often looking at a hundred documents before any actual bookkeeping starts.

Overlapping Batches Create Duplicates

When history is loaded piecemeal it is easy to import January twice. CSV imports carry no transaction identifier at all, so nothing in the destination software can tell that the rows are the same ones you loaded last week.

Manual Entry Does Not Scale

Typing a year of transactions by hand is the alternative people fall back on, and it is where the errors come from. Transposed amounts and skipped lines only surface later, when a reconciliation refuses to balance and nobody knows which month broke it.

Scanned Statements Slow It Down Further

Older statements are often scans or photos rather than text PDFs. Handled one at a time that turns into a manual retyping job for exactly the periods that are hardest to get any other way.

What batch conversion actually changes

Same extraction, same accuracy checks, run across a whole stack of documents in one pass instead of one document per pass.

Up to 50 Files Per Batch

Select the whole folder rather than the first PDF in it. Each file can be up to 50MB, which covers long business statements with hundreds of lines per month.

Merge Into One File

Turn on merging and the statements are combined before extraction, so twelve monthly PDFs for one account come back as one continuous file covering the year rather than twelve fragments.

Mixed Banks In One Batch

The extraction reads the layout of each document independently, so a batch can hold statements from different banks and different account types without sorting them first.

One Format, Every Statement

Pick OFX, QFX, QIF, CSV, Excel or JSON once and it applies to the batch. QFX for Quicken, OFX for MS Money and other software that reads the open format, CSV or Excel for a spreadsheet.

Transaction IDs That Prevent Duplicates

The OFX and QFX exports carry a unique identifier per transaction, which is what lets the destination software recognize a line it already has when two batches overlap at the month boundary.

Scans and Photos In The Same Batch

Scanned statements, photographed pages and image only PDFs go into the same upload as ordinary text PDFs, so the old paper years do not need a separate workflow.

Convert a stack of statements in 3 steps

The workflow is the same as a single file. The difference is how many you select.

1

Collect the statements

Download the PDFs for the period you need, one file per statement period, and keep each account in its own folder so the batches stay clean.

Tip: Statements usually live in a separate area from the transaction download screen and reach back much further.

2

Upload the batch

Select all the files at once, up to 50 per batch, and turn on merging if they all belong to the same account and you want one combined file at the end.

Tip: Leave merging off when the batch holds several different accounts, so each one stays separate.

3

Check and export

Review the extracted transaction table against the printed statements, then export the batch as QFX, OFX, QIF, CSV or Excel and import it.

Tip: Back up the destination file before a large import, and load non overlapping date ranges where you can.

Who converts in bulk

Volume work, where the job is measured in months of history rather than in single documents.

Bookkeepers Onboarding a Client

A new client arrives with a year of statements across four accounts and nothing in the software yet. The catch up work has to happen before any normal monthly work can start.

Tax Preparers Rebuilding a Year

Records for the filing year exist as PDFs and nothing else. Every account has to be loaded and categorized before the return can be prepared.

Landlords With Several Property Accounts

Separate accounts per property, each with its own statement each month, all of which need to land in the right register before a Schedule E makes sense.

Anyone Switching Finance Software

Moving to a new program means the history has to come with you, and the download connection at the bank will only reach back about 90 days.

How many bank statements can I convert at once?

Up to 50 files in a single batch, with each file up to 50MB. That covers a full year for four accounts in one upload, or two years of a single account with room to spare. If you have more than 50 documents, split them into batches by account or by year rather than by an arbitrary count, because keeping each batch to one account is what makes the merge option useful and keeps the imports easy to track.

Should you merge the statements or keep them separate?

This is the decision that shapes the rest of the job, and it comes down to one question: does everything in the batch belong to the same account? If it does, merge. Twelve monthly PDFs for one checking account become one continuous extraction covering the year, you review one transaction table instead of twelve, and you run one import instead of twelve. If the batch spans several accounts, leave merging off, because a merged file mixes transactions that need to land in different registers and separating them afterwards is worse than never combining them.

SituationMerge?Why
12 monthly statements, one checking accountYesOne file covering the year, one review, one import into one register.
Checking, savings and two cards for the same businessNoEach account has its own register in the destination software and needs its own file.
Statements from several different banksNoDifferent institutions, different accounts. Keep them apart so each import goes to the right place.
A statement split across two PDFs by the bankYesIt is one statement period, so merging restores it to one document before extraction.
Several clients in one folderNo, and split the batchRun one batch per client. Mixing client data in one file creates a separation problem you do not want.

Which format to export for a bulk import

The format matters more in bulk than it does for a single statement, because duplicate handling is what decides whether a large import is a five minute job or an evening of cleanup. QFX and OFX both carry a unique identifier on every transaction. When two batches overlap at a month boundary, which happens constantly when you load history in pieces, that identifier is what lets the destination software recognize the repeated lines instead of adding them twice.

CSV has no such field. A CSV import is just rows, so importing January twice puts January in twice, and the only way to find it afterwards is by eye. That is fine when the destination is a spreadsheet and you are going to sort and total it yourself. It is a poor choice for loading a year into finance software.

FormatBest forDuplicate protection
QFXQuickenYes, carries a transaction ID. Quicken does not accept a plain OFX file, so this is the one to pick.
OFXMS Money, GnuCash, Banktivity, Moneydance, XeroYes, carries a transaction ID.
QIFOlder software, and the Quicken account types a QFX import cannot reachNo. In Quicken, QIF import is limited to asset, liability and cash accounts.
CSV or ExcelSpreadsheets, review, categorization by handNo. Reimporting the same period silently doubles it.

How do I import a year of transactions into Quicken?

Convert the statements to QFX, then import through File, then File Import, then Web Connect File, choosing the existing account each time. Quicken cannot read a PDF directly, so the conversion step is not optional. Back the file up before you start, because a large import is not something you want to unpick by hand, and load the periods in date order so the running balance reads sensibly afterwards.

Work in non overlapping ranges wherever the statements allow it. The transaction identifier in a QFX file gives Quicken a real basis for spotting repeats, but it is still less work to avoid the overlap than to review a duplicate prompt on every line of a shared month. If the destination is not Quicken, the same logic applies with OFX: import in order, avoid overlaps, and check the closing balance against the printed statement before moving on. There is a fuller walkthrough on the convert bank statement to Quicken page.

Converting statements from different banks in one batch

This works, and it is the normal case for anyone doing client work. Every bank lays its statement out differently, so the extraction reads each document on its own terms rather than applying one template across the batch. A folder holding Chase, Wells Fargo and a credit union statement converts in one pass.

What you should not do is merge that batch. Merging is for documents that belong to the same account, and a merged file spanning three banks produces one transaction list that has to be pulled apart again before any of it can be imported. Keep mixed batches unmerged, and you get one file per statement, each ready to go to its own register. If a specific bank is giving you trouble, the per bank guides such as Chase not downloading to Quicken cover what that institution serves and what it does not.

Accuracy at volume

Worth being honest about the part that batch processing does not remove. Extraction from a PDF is reading, and reading can be wrong, particularly on scanned pages, on statements with unusual column layouts, and on lines where a description wraps across two rows. In a batch of 50 documents nobody is going to read every line, so check the things that fail loudly rather than the things that fail quietly: the transaction count and the closing balance on each statement.

If the closing balance in the extraction matches the printed one, the amounts in between are almost certainly right, because a missed or misread transaction changes the total. That check takes a few seconds per statement and it is the difference between a bulk conversion you can trust and one you find out about at reconciliation. For volume client work there is more on the workflow side on the bank statement conversion for accountants page.

Bulk Statement Conversion: Common Questions

Up to 50 files in one batch, with each file up to 50MB. That is enough for a full year across four accounts, or roughly two years of a single account. If you have more than that, split the work into batches by account or by year rather than by count, which keeps each import going to a single register.

Yes. Select all the PDFs in one upload instead of adding them one at a time, and the whole batch is extracted in a single pass. The statements can come from one account or from several different banks, and each document is read on its own layout rather than through a shared template.

Turn on the merge option before converting. The statements are combined into a single extraction, so twelve monthly PDFs for one account come back as one continuous file covering the year. Only merge documents that belong to the same account, because a merged file mixing several accounts has to be separated again before importing.

No. Quicken imports QFX, QIF, CSV and QXF files, and a PDF is not among them, so a statement has to be converted first. QFX is the format to choose for Quicken, because it carries the transaction identifiers Quicken uses to recognize lines it already has. Import through File, then File Import, then Web Connect File.

It can, and the format decides how much protection you have. QFX and OFX carry a unique identifier per transaction, so overlapping batches can be recognized as repeats. CSV carries no identifier, so importing the same period twice adds it twice with nothing to flag it. Import non overlapping date ranges and back up before a large batch.

Yes. Each document is read on its own layout, so a batch holding Chase, Wells Fargo and a credit union statement converts in one pass without sorting them first. Leave the merge option off for mixed batches, so each statement comes back as its own file ready for its own account register.

Yes. Pick QFX once and it applies to the whole batch. Each statement comes back as a Web Connect QFX file written to spec, with the balance and transaction blocks Quicken expects. If you merged a year of one account first, that is a single QFX covering the year rather than twelve separate imports.

Download the twelve monthly PDFs for the account, upload them as one batch with merging turned on, review the combined transaction table against the printed closing balances, then export a single QFX or OFX file and import it. The bank download screen usually only reaches back about 90 days, which is why the statements are the practical source for a full year.

Yes. Scans, photographed pages and image only PDFs go into the same batch as ordinary text PDFs, which matters because older statements are the ones most likely to be scans and also the ones hardest to obtain any other way. Check the closing balance on scanned documents in particular, since image quality affects how cleanly the amounts read.

Compare the transaction count and the closing balance of each extraction against the printed statement. A missed or misread amount changes the total, so a matching closing balance is strong evidence the lines in between are correct. That check takes seconds per statement and is far more reliable than skim reading hundreds of rows.

Related Resources

Other Bank Statement Converters

ICICI Bank JPMorgan Chase Bank of America Citigroup Wells Fargo Goldman Sachs Morgan Stanley U.S. Bancorp PNC Financial Services Truist Financial Capital One TD Bank Charles Schwab Bank of New York Mellon State Street BMO USA Ally Financial Regions Financial Fifth Third Bank Huntington Bancshares KeyBank Citizens Financial Group First Citizens BancShares Synchrony Financial M&T Bank First Horizon Cathay Bank USAA Navy Federal Comerica Zions Bancorporation East West Bancorp First National of Nebraska Cullen Frost Bankers BOK Financial Fulton Financial Associated Banc-Corp Valley National Bancorp Wintrust Financial First Midwest Bancorp Commerce Bancshares UMB Financial Pinnacle Financial Partners Webster Financial Cadence Bank Old National Bancorp First Interstate BancSystem Umpqua Holdings First Hawaiian Bank Prosperity Bancshares SouthState Corporation First Merchants First Bank Holding Glacier Bancorp First Financial Bancorp Independent Bank Columbia Banking System Western Alliance Bancorporation Pacific Premier Bancorp Bank OZK United Community Banks Customers Bancorp Texas Capital Bancshares SVB Financial Group Signature Bank First Republic Bank New York Community Bancorp Sterling Bancorp First Bank Bank United First Commonwealth Financial ServisFirst Bancshares Renasant Corporation Simmons First National Trustmark Corporation First Busey Community Bank System First Mid Bancshares Ameris Bancorp Hancock Whitney First BanCorp Third Coast Bancshares Home Bancshares Byline Bancorp Simmons Bank United Bankshares Peoples United Financial American Express HSBC Bank USA