Free Bank Statement to QBO Converter for QuickBooks
Turn a digital PDF, CSV or Excel bank statement into a .QBO file, and review each row before you import.
QBO can mean QuickBooks Online or the .qbo file it imports. This page covers both: the routes a statement takes into QuickBooks, and the converter for the ones that need a file.
Embed this converter on your website for freeChoose your file
Drop your bank statement here
Your file is never uploaded. We never receive it or store it.
How Do You Import Bank Transactions Into QuickBooks Online?
QuickBooks Online takes bank transactions three ways: a connected bank feed, a file added through Upload from file, or entries you type yourself. In the US, that upload also reads the statement PDF itself, alongside QBO, QFX and CSV files. When your file is none of those, or you use QuickBooks Desktop, Autymate's free Bank Statement to QBO Converter turns the statement into a .QBO file that both versions import.
The first three routes need no converter, so try them first. Converting a bank statement to QuickBooks makes sense in the cases they leave open: QuickBooks Desktop, which reads only .qbo files for bank transactions; QuickBooks Online outside the US, where the upload lists no PDF; and a bank that exports a spreadsheet workbook, a format the upload does not list at all.
Connect the bank feed
Your bank- Starts with
- Your online banking login
- QuickBooks Online
- Pulls 90 days to 24 months back
- QuickBooks Desktop
- Bank Feeds, where your bank offers it
Upload your bank's download
Your bank- Starts with
- A .qbo, .qfx or .csv file from your bank's site
- QuickBooks Online
- Upload from file takes all three
- QuickBooks Desktop
- Web Connect takes .qbo only
Upload the statement PDF
Your region- Starts with
- The PDF statement, or a photo of it
- QuickBooks Online
- US only, English statements: upload the bank statement to QuickBooks and check what it pulled
- QuickBooks Desktop
- Not accepted
Convert, then upload
This converter- Starts with
- A digital PDF, CSV, Excel workbook or bank download
- QuickBooks Online
- Upload the .QBO the converter writes
- QuickBooks Desktop
- Import the .QBO through Web Connect
Type it in
Last resort- Starts with
- The statement in front of you
- QuickBooks Online
- One entry at a time
- QuickBooks Desktop
- One entry at a time
Routes 1 to 3 depend on your bank and your region. Route 4 needs only a digital copy of the statement.
When the QuickBooks Bank Feed Stops Short
A feed is the easiest way to import transactions into QuickBooks, as far back as your bank allows.
Older Months Than the Feed Reaches
On first connection, QuickBooks Online downloads between 90 days and 24 months of history, depending on the bank. Anything earlier has to come from a file, and Intuit's own guidance for an earlier period is Upload from file.
A Bank That Does Not Connect
Some banks and card issuers offer no feed at all. Intuit points those accounts to the same upload, so a statement or a download from your bank is the only record QuickBooks will get.
An Account That Is Already Closed
Once an account closes there is often no login left to connect. The statements you kept are what remains, and the upload needs no live connection.
A Gap After a Disconnect
If a feed stayed disconnected long enough for your bank's window to move on, reconnecting cannot fetch the missing weeks. The statement for that period fills them.
How to Convert a Bank Statement to a QBO File
Four steps in the converter above, then one upload inside QuickBooks.
Add Your Statement File
A digital PDF, a CSV or Excel export, or a .qbo, .qfx or .ofx download. The converter works out which one it has. A scanned PDF is turned away, because there is no text on it to read.
Keep QBO and Set the Account
QBO is already selected as the output. Set the account type to checking, savings, or credit card and line of credit, to match the account the statement belongs to.
Confirm Which Column Is Which
Point it at the date, description and amount columns. If your bank prints withdrawals as positive numbers in a single Amount column, tick Flip every sign so money out comes through as negative.
Check the Balances, Then Download
When the statement carries a running balance, the converter checks each row against it before you download. Then upload the file through Upload from file in QuickBooks Online, or import it as a Web Connect file in QuickBooks Desktop.
Upload Transactions to QuickBooks Online Without Doubling Them
Duplicates start where a statement file meets a live feed. Three habits keep them out.
End the File Before the Feed Begins
Intuit lists a file that overlaps the bank feed as a cause of duplicate transactions. End your file the day before the feed's first transaction, and nothing arrives twice.
Upload in Batches of 1,000 Lines
Upload from file takes up to 1,000 lines and 350 KB at a time. A year of a busy account can run past that, so convert and upload it a quarter at a time.
Uploaded Rows Wait for You
Uploaded transactions arrive for review, not in your books. Match each one to what is already there or categorize it. Until you do, your reports do not move.
From a Statement Backlog to a Monthly Workflow
The converter clears the months a feed missed. Autymate handles the data that keeps coming.
Free Bank Statement Converter for QuickBooks
- Catching up on months the feed never reached
- One statement and one account at a time
- Reads the file in your browser; you do the upload
- You match, categorize and reconcile in QuickBooks
Autymate
- Recurring data from POS, payment processors and 300+ other tools
- Posts to QuickBooks and other accounting systems
- One mapping for every location and entity
- Anything unclear is held for your team's decision before it posts
| Need | Free converter | Autymate |
|---|---|---|
| Six months your feed never pulled | Convert each statement once | Nothing repeating to set up |
| Processor or POS data you re-key each month | Convert the export every month | Connected once, posted every period |
| Several locations or entities | One file per account, per period | One mapping across all of them |
Common Questions
What people ask before they trust a converter with their accounting system.
People search it both ways. QuickBooks Online is the product; .qbo is the Web Connect file both QuickBooks versions import. This page covers the routes into QuickBooks Online, and the free Bank Statement to QBO Converter for the routes that need a .qbo file.
Between 90 days and 24 months on first connection, depending on your bank, and you pick the start date inside that window. Anything older comes in through Upload from file: as a QBO, QFX or CSV file, or in the US as the statement PDF.
Yes. Upload from file needs no live connection. Use the last QBO or CSV download you saved from that bank if you have one. Otherwise, upload the PDF in the US, or convert the PDF bank statement to QBO first and upload that.
Not for bank transactions. QuickBooks Desktop's Web Connect reads .qbo files only, and Intuit notes that QFX and QIF files will not work. CSV import is limited to Batch Enter in the Enterprise and Accountant editions. A PDF or CSV statement needs to become a QuickBooks Web Connect file first.
The same routes as a bank account: the card's feed, its download, or the statement. To convert a credit card statement to QBO, set the account type to credit card and line of credit. If the export prints charges as positive numbers in one Amount column, tick Flip every sign, then upload the file to the card's account.
Not as a workbook. Intuit's upload page lists QBO, QFX, CSV, TXT and OFX files, and no Excel format. Save the sheet as a CSV in QuickBooks' three- or four-column layout, or drop the workbook into the converter above and download a .QBO file.
No. The file is read inside your browser tab and does not leave your computer. Converting a PDF loads a PDF-reading library once, and that download contains nothing from your statement.
Offer the Bank Statement to QBO Converter on Your Website
Your clients convert their files right on your site, free, without ever leaving it.
Free, with no sign-up
Copy the code and paste it. No account, no API key.
Client files stay private
Every file is converted in your visitor’s browser and never uploaded, not even to us.
Always up to date
Improvements reach your page automatically, and it sizes itself to fit.
Paste it into
Webflow
WordPress
Squarespace- Any HTML page
<div class="autymate-embed" data-tool="bank-statement-to-qbo-converter">
<p>Bank Statement to QBO Converter · Powered by
<a href="https://www.autymate.com/tools/bank-statement-to-qbo-converter">Autymate</a></p>
</div>
<script async src="https://www.autymate.com/embed/v1.js"></script>Paste it where you want the converter to appear.
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 Really Sales Data
If the numbers you convert every month come from a POS or a payment processor, Autymate connects those sources and posts them to QuickBooks and other accounting systems, location by location.
Exact source access, fields, permissions, QuickBooks behaviour and service scope are confirmed during discovery.