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

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 transactions

Can 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.

Get Started for Free
CheckingSampleLocation: Downtown
One October week in the Checking register after an import (sample figures): each line is the record type it should be, with its account and location.
DateTypeMemoAccountAmount
10/14ExpenseRIVERSIDE LINENLaundry−318.40
10/14DepositCARD SETTLEMENTSales+4,906.15
10/15TransferTRANSFER TO SAVINGSSavings−2,500.00
10/16CheckCHECK 2047Repairs−640.00
10/17Card PaymentPAYMENT BUSINESS CARDBusiness Card−1,212.88
10/17ExpenseMONTHLY SERVICE FEEBank Fees−15.00
Ending balance$38,412.07
One October week in the Checking register after an import (sample figures): each line is the record type it should be, with its account and location.

QuickBooks Online's Bank Options vs Autymate

QuickBooks Online gives you two ways to bring in bank transactions. Here's where each one fits.

QuickBooks Online's Bank Options vs Autymate
Bank feedBank file uploadAutymate Transactions
Which banksBanks QuickBooks connects toAny bank, in Intuit's fixed layoutAny bank that exports CSV or Excel
File layoutn/a3 or 4 columns, or a bank download fileYour bank's own columns, mapped once and saved
How far backWhat the bank connection providesWhat's in the fileAny period your files cover
CategorizingIn For review, one by one or with bank rulesIn For review, one by one or with bank rulesFrom your file's columns, previewed before posting
Records createdAdded or matched from For reviewAdded or matched from For reviewExpenses, checks, deposits, transfers, card payments
Locations & classesAdded by handAdded by handFrom a column in your file
DuplicatesHandled by the feedPossible if the file overlaps the feedSkips 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:

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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

CSVchecking-nov.csvSample
  1. Date,Description,Amount,Category
  2. 11/02/2026,CITY POWER AUTOPAY,-412.75,Utilities
  3. 11/03/2026,CARD SETTLEMENT,6118.40,Sales Deposits
  4. 11/04/2026,TRANSFER TO SAVINGS,-5000.00,Transfer:Savings
  5. 11/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
Four lines, four records: two expenses, a deposit and a transfer, each with the category from the file. (Sample figures.)

How Statement Columns Map to QuickBooks Online

Autymate suggests the mapping from your headers. Change any field, then save it for every statement after.

How Statement Columns Map to QuickBooks Online
Your columnQuickBooks Online fieldNotes
DatePayment date / Deposit dateOne date rule formats every line
DescriptionMemoThe bank's own text, kept for search
AmountAmountMoney out and money in, each on its own record
Debit / CreditAmountWhen your bank splits the two, map each column
AccountBank or card accountOr one default for the whole file
CategoryCategory / AccountMatched to your chart of accounts by name
Transfer toTransfer accountThe other side of a move between your accounts
Check no.Ref no.Kept on the expense, or the line posts as a check
Location / ClassLocation / ClassKept 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.

  1. Create a free Autymate Transactions account and sign in with Intuit to connect the QuickBooks Online company your bank accounts sit in.

    The Destination card in Autymate: QuickBooks Online, with the Store 101 company connected and a green Connected badge, and a Select Entity menu beside it.
    QuickBooks Online connected as the destination.
  2. 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 in Autymate for QuickBooks Online, open on Sales Receipt, Daily Sales Receipt, Invoice, Deposit, Journal Entry and Expense, each with its field count.
    The record-type list. Statement lines post as types like Deposit and Expense from this list.
  3. Match date, description and amount, pick the bank or card account, and map your category column if the file has one.

    The Autymate field mapping table: each QuickBooks Online field, its mapping type (Function, Source, Default value or Override), the column or value it takes, and a sample result.
    The field mapping table, shown on a sample sales file: each field, where its value comes from, and the result.
  4. See every line as the record it will become, with totals for the period. Anything unclear is held for review before anything posts.

    The Autymate Preview before publishing dialog: rows read, records ready and rows that need review, a table of the records with a Ready or Totals don't balance status, and the note that nothing is written to QuickBooks Online until you publish.
    The preview, on a sample run: rows read, ready and held, before anything reaches QuickBooks.
  5. Post the lines, then reconcile the account against the statement in QuickBooks Online. Re-runs skip lines already posted.

    A finished Autymate run: 121 of 123 posted, with tabs for All, Ready, Posted, Review and Failed, and one row marked Needs review with a Resolve button.
    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.

Common Bank Import Errors, Handled
ErrorWhat causes itHow 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 reversedA 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 feedThe 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 twiceA 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 wrongDay 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.

The Autymate Amount does not balance panel: the reason in plain words, the note that nothing was posted for this transaction, three fixes to choose from, and Do this automatically from now on.
A held item from a sample run: the reason, the note that nothing was posted, and the fixes to choose from.

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.

  1. Create your free account
  2. Connect QuickBooks Online
  3. Upload your bank statement