Import Bank Transactions into QuickBooks Online
Bring in bank and card statement lines from the CSV or Excel file your bank exports, for any period your statements cover. Each line posts as an expense, deposit or transfer, with the category and location from your file.
- Free plan, no credit card needed
- Your bank's own export
- Preview before you post
Intuit Gold PartnerSOC 2 Type II audited
1,000+ Five-Star Reviews
Your bank statement
Date,Description,Amount,Category10/14/2026,RIVERSIDE LINEN,-318.40,Laundry10/14/2026,CARD SETTLEMENT,4906.15,Sales10/15/2026,TRANSFER TO SAVINGS,-2500.00,SavingsAutymate does the work
- Read
- Map
- Check
- Post
238lines
DateTxn dateDescriptionMemoCategoryAccount
4 of 4 matched
- 186Money out
- 44Money in
- 6Already posted
- 2Needs review
230records
from 238 lines
230records posted
Undo
In QuickBooks Online
- ExpenseRIVERSIDE LINEN−$318.40
- DepositCARD SETTLEMENT$4,906.15
- TransferTo Savings−$2,500.00
- +227 more
Where QuickBooks Online's Bank Upload Falls Short
The QuickBooks Online bank CSV format is fixed: three columns (date, description, amount) or four (date, description, credit, debit). Every uploaded line then waits in For review to be categorized or matched, by hand or with bank rules. Banks without a feed and history older than the feed are the slow cases.
Import my bank transactionsCan You Import Bank Transactions into QuickBooks Online?
Yes, you can import bank transactions into QuickBooks Online using Autymate Transactions. Upload the CSV or Excel statement your bank exports, map its columns once, and map each line to the record QuickBooks Online keeps: an expense or check for money out, a deposit for money in, a transfer between your own accounts. You preview every line, anything unclear is held for review with the reason, and nothing posts until you approve.
Statement Lines from Any Bank's CSV or Excel Export
Pick where your statement lines come from. Each lands in QuickBooks Online against the right bank or card account.
- CSV → Records
Bank CSV
The download from online banking, whatever its columns. You map them once.
Import from CSV - XLSX/XLS → Records
Excel Statements
Statements exported to a workbook, or cleaned up in one before import.
Import from Excel Sheet → Records
Google Sheets
A shared sheet where statement lines get pasted, picked up on the schedule you set.
Connect a sheet- Card CSV → Expenses
Credit Card Statements
Import credit card statement into QuickBooks Online: charges post against the card account, and paying it off posts as a card payment.
Get Started for Free - TXT → Records
TXT & Other Delimited Files
Tab, pipe or semicolon exports. The separator is detected for you.
Get Started for Free - IIF → Records
IIF
Checks, deposits and transfers from a Desktop-era IIF export.
Import from IIF
Drop Statements in a Folder Instead
Save each month's statement to Google Drive, an SFTP folder or Amazon S3, and Autymate picks the file up and lines it up for your approval.
- Google Drive
- SFTP folder
- Amazon S3
Statements in a format you can't export as CSV or Excel? Ask about a custom integration
Coded Lines, Not a Pile to Review
Each statement line becomes the QuickBooks Online record it really is, with the detail your reports need.
Money Out → Expenses
Withdrawals, card charges and bank fees posted as expenses or checks.
Money In → Deposits
Card settlements and other money in, posted as deposits to that account.
Transfers
A move between two of your accounts, posted once as a transfer.
Card Payments
Paying off a business card from checking, posted as a credit card payment.
Categories from Your File
Map the category column you already filled in to the account field.
The Bank's Description
Carried over as the memo, so every line stays searchable later.
Classes & Locations
Each line tagged from a column, so P&L by location stays right.
Any Period
Years of history from your files, not just what the feed reaches back to.
Upload Bank Transactions. QuickBooks Online Gets Real Records.
Free plan, no credit card needed.
| Date | Type | Memo | Account | Amount |
|---|---|---|---|---|
| 10/14 | Expense | RIVERSIDE LINEN | Laundry | −318.40 |
| 10/14 | Deposit | CARD SETTLEMENT | Sales | +4,906.15 |
| 10/15 | Transfer | TRANSFER TO SAVINGS | Savings | −2,500.00 |
| 10/16 | Check | CHECK 2047 | Repairs | −640.00 |
| 10/17 | Card Payment | PAYMENT BUSINESS CARD | Business Card | −1,212.88 |
| 10/17 | Expense | MONTHLY SERVICE FEE | Bank Fees | −15.00 |
QuickBooks Online's Bank Options vs Autymate
QuickBooks Online gives you two ways to bring in bank transactions. Here's where each one fits.
| Bank feed | Bank file upload | ||
|---|---|---|---|
| Which banks | Banks QuickBooks connects to | Any bank, in Intuit's fixed layout | Any bank that exports CSV or Excel |
| File layout | n/a | 3 or 4 columns, or a bank download file | Your bank's own columns, mapped once and saved |
| How far back | What the bank connection provides | What's in the file | Any period your files cover |
| Categorizing | In For review, one by one or with bank rules | In For review, one by one or with bank rules | From your file's columns, previewed before posting |
| Records created | Added or matched from For review | Added or matched from For review | Expenses, checks, deposits, transfers, card payments |
| Locations & classes | Added by hand | Added by hand | From a column in your file |
| Duplicates | Handled by the feed | Possible if the file overlaps the feed | Skips lines it posted, and can skip lines the feed brought in |
QuickBooks Online's options from Intuit, checked November 2026: a bank upload takes a 3- or 4-column CSV (or a bank download file) and lands in For review. They can change by plan and region. Use the bank feed where it works; reconciliation stays in QuickBooks Online either way. (Intuit: uploading bank transactions (opens in a new tab) · Intuit: bank CSV format (opens in a new tab))
How to Set Up Your Statement File
Use the export your bank gives you, as it comes. Statement files have habits of their own, and these keep every import clean:
Signed amounts or two columns. One Amount column with money out as negatives works, and so does a bank's separate Debit and Credit columns. Keep whichever your bank exports.
One file per account. A statement covers one bank or card account. Set that account once when you map, or add an Account column if one file holds several.
Mind the dates your feed already brought in. If the bank feed covers October, import September and earlier. Autymate can also skip any line the feed already brought into QuickBooks Online.
Post a transfer from one side only. A move to savings shows on both statements. Import it as a transfer from one account's file and leave the matching line out of the other.
Keep the category column if you have one. Lines you already coded map straight to the account field. A category QuickBooks doesn't have is held for review, not guessed.
Import Bank Statement into QuickBooks Online, Line by Line
Date,Description,Amount,Category11/02/2026,CITY POWER AUTOPAY,-412.75,Utilities11/03/2026,CARD SETTLEMENT,6118.40,Sales Deposits11/04/2026,TRANSFER TO SAVINGS,-5000.00,Transfer:Savings11/05/2026,MONTHLY SERVICE FEE,-15.00,Bank Fees
Becomes 4 records in Checking
- ExpenseCITY POWER AUTOPAYUtilities$412.75
- DepositCARD SETTLEMENTSales Deposits$6,118.40
- TransferTo SavingsSavings$5,000.00
- ExpenseMONTHLY SERVICE FEEBank Fees$15.00
How Statement Columns Map to QuickBooks Online
Autymate suggests the mapping from your headers. Change any field, then save it for every statement after.
| Your column | QuickBooks Online field | Notes |
|---|---|---|
Date | Payment date / Deposit date | One date rule formats every line |
Description | Memo | The bank's own text, kept for search |
Amount | Amount | Money out and money in, each on its own record |
Debit / Credit | Amount | When your bank splits the two, map each column |
Account | Bank or card account | Or one default for the whole file |
Category | Category / Account | Matched to your chart of accounts by name |
Transfer to | Transfer account | The other side of a move between your accounts |
Check no. | Ref no. | Kept on the expense, or the line posts as a check |
Location / Class | Location / Class | Kept when tracking is on in QuickBooks Online |
Where Each Field's Value Comes From
- Source
Take the value from a statement column.
- Default value
Fill a blank cell, such as one bank account per file.
- Override value
Use one fixed value on every line.
- Advanced Function
Trim bank text, format a date or join two columns.
How to Import Bank Transactions into QuickBooks Online
Five steps and a few minutes for the first statement. After that, each month is one upload.
Create a free Autymate Transactions account and sign in with Intuit to connect the QuickBooks Online company your bank accounts sit in.

QuickBooks Online connected as the destination. Pick what your statement lines post as, such as expenses, deposits or transfers, then upload the file exactly as your bank exported it.

The record-type list. Statement lines post as types like Deposit and Expense from this list. Match date, description and amount, pick the bank or card account, and map your category column if the file has one.

The field mapping table, shown on a sample sales file: each field, where its value comes from, and the result. See every line as the record it will become, with totals for the period. Anything unclear is held for review before anything posts.

The preview, on a sample run: rows read, ready and held, before anything reaches QuickBooks. Post the lines, then reconcile the account against the statement in QuickBooks Online. Re-runs skip lines already posted.

A finished sample run: what posted, and what is held for review with a Resolve button.
Common Bank Import Errors, Handled
Why QuickBooks Online won't accept bank CSV files, the other usual stops, and what Autymate does about each.
| Error | What causes it | How Autymate handles it |
|---|---|---|
| “File format not supported” | The bank's CSV has more, fewer or differently ordered columns than the upload accepts. | Reads the columns your bank exports. You map them once and the mapping is saved. |
| Money in and out reversed | A bank signs amounts the other way round, or splits debits and credits. | The preview shows each line as money out or in, so a flipped file is caught before posting. |
| Duplicates with the bank feed | The file overlaps dates the feed already brought in. | Autymate can skip lines the feed already brought in, and skips lines it posted itself on every re-run. |
| Transfers counted twice | A move shows as money out on one statement and money in on the other. | Post it once, as a transfer, from one account's file, and leave the matching line out of the other. |
| Dates read wrong | Day and month swapped, or dates stored as text. | One date rule formats every line, and the preview shows the result first. |
| “Account doesn't exist” | A category in the file isn't in your chart of accounts. | Holds the line with the reason, so you can map it to the right account. |
What a Held Statement Line Looks Like
When a line can't post as it is, Autymate keeps it back, says why, and lists the fixes that apply. Nothing reaches your books until it's resolved.

Who Imports Bank Transactions into QuickBooks Online
Catch-Up Bookkeeping
Months or years of statements mapped and posted in one pass, instead of one line at a time.
Banks Without a Feed
Credit unions and local banks QuickBooks doesn't connect to. Their statement export is enough.
Bookkeepers & Accounting Firms
Each client's statement layout, with its own saved mapping.
Switching to QuickBooks Online
Import old bank transactions: QuickBooks Online gets the history from before the feed's reach, so year-to-date is complete.
Multi-Location Businesses
An account per location, each line tagged to its store.
Broken Bank Connections
Fill the gap while a feed is disconnected by importing only the missing dates.
Bank Transaction Import Pricing for Every Location
Start free with no card required. Standard imports statements for every location at $19 per location.
Free
Start here$0no card required- 1 location
- 200 rows a month
- Preview, undo and saved mappings
Standard
$19per location, per month- Unlimited locations
- Unlimited rows, 30 runs a month
- Everything in Free
Every new account starts on Free, so you can connect QuickBooks Online and post a real statement in your first session. Get started for free
What Comes with Autymate Transactions
- Bank and card statement import to QuickBooks OnlineExpenses, deposits, transfers and card payments, previewed before anything posts.
- Excel, CSV, Google Sheets and IIFStatement files in whichever format your bank or team already uses.
- Direct POS connectionsSales come from your POS into QuickBooks Online without exporting a file first.
- One automation for every locationBuild the mapping once and run it at each location, even across separate QuickBooks companies.
- Review every location in one placeOne person checks every location's run from one screen, without switching companies.
Importing Bank Transactions into QuickBooks Online
Yes. QuickBooks Online's own upload takes a bank CSV in a fixed 3- or 4-column layout, or a bank download file, and every line waits in For review. Autymate Transactions imports your bank's CSV or Excel export in its own layout and posts each line as an expense, deposit or transfer after you preview it.
Connect QuickBooks Online to Autymate Transactions, choose the record type, upload the statement file, map its columns, preview the lines, then import. Reconcile the account against the statement in QuickBooks Online afterwards.
Its bank upload expects three columns (date, description, amount) or four (date, description, credit, debit), so an export with extra columns or a different order is rejected. Autymate reads the columns your bank exports, and you map them once.
Autymate Transactions reads file formats like CSV, Excel and Google Sheets. Most banks let you download the same statement as a CSV or Excel file from online banking; import that, and each line posts as the record it is.
As far back as your statement files go. The bank feed is limited by what the bank connection provides; a file import covers any period, which suits catch-up work and moving to QuickBooks Online mid-year.
It doesn't have to. Autymate can skip lines your bank feed already brought into QuickBooks Online, and it always skips lines it posted itself, so re-running the same file never doubles them. For the cleanest start, import the dates the feed doesn't cover.
Not if your file carries a category column. Map it to the account field and each line posts with that category, instead of waiting in For review. A line whose category isn't in your chart of accounts is held for review with the reason.
Post each transfer once, as a transfer, from one account's statement, and leave the matching line out of the other account's file. That keeps it from showing as an expense in one account and a deposit in the other.
Yes. To import a credit card statement into QuickBooks Online, point the import at the card account: charges post as expenses against the card, and paying the card from checking posts as a credit card payment.
Autymate Transactions starts free, with no card, one location and 200 rows a month. The Standard plan is $19 per location per month, with unlimited rows.
Stop Coding Bank Lines One at a Time
Import bank transactions into QuickBooks Online today. Free plan, no credit card needed.
- Create your free account
- Connect QuickBooks Online
- Upload your bank statement
Intuit Gold PartnerSOC 2 Type II audited
1,000+ Five-Star Reviews

