Import Expenses into QuickBooks Online

Bulk import expenses from Excel, CSV, Google Sheets or IIF. Card and cash spend posts to the account that paid it and the category it belongs to, with payees and locations.

  • Free plan, no credit card needed
  • Card, bank or cash
  • Preview before you post

Where QuickBooks Online Falls Short on Expenses

Intuit lists expenses among the types QuickBooks Online's Import data screen accepts, one spreadsheet of under 1,000 rows at a time, and what that screen offers varies by plan. Day to day, card and cash spend still goes in receipt by receipt, or as feed lines you categorize one at a time.

Import my expenses

Can You Import Expenses into QuickBooks Online?

Yes, you can import expenses into QuickBooks Online using Autymate Transactions. Upload the card statement, expense report or spend log you already keep, as Excel, CSV or IIF, or connect a Google Sheet. Each row becomes an expense against the card, bank or cash account that paid it, carrying its category, payee and location. You review the whole batch first, and nothing reaches your books until you approve it.

Expenses from Wherever Your Team Logs Them

Pick where your spend is recorded. Each row lands as a real expense against the account that paid.

  • XLS/XLSX → Expense

    Excel

    Expense reports and monthly spend logs, in whatever columns they use.

    Import from Excel
  • CSV → Expense

    CSV

    Statement downloads from your card issuer or bank, and exports from spend tools.

    Import from CSV
  • New row → Expense

    Google Sheets

    The shared tracker your team adds receipts to, picked up on the schedule you set.

    Connect a sheet
  • Receipt → Expense

    Receipt Photos & PDFs

    Standard plan

    Snap or upload a stack of receipts. Each one is read for you and checked before it posts.

    See the receipt scanner
  • IIF → Expense

    IIF

    Card charges exported from Desktop-era tools.

    Import from IIF
  • TXT → Expense

    TXT & Other Delimited Files

    Tab, pipe or semicolon files from older accounting tools; the separator is detected.

    Get Started for Free

Let Statements Arrive on Their Own

Drop each month's card statement in Google Drive, an SFTP folder or Amazon S3 and it waits for your review, no upload needed. A custom API works too.

  • Google Drive
  • SFTP folder
  • Amazon S3
  • Custom API

Is your spend in a system we don't reach yet? Ask about a custom integration

Every Expense, Coded and in the Right Account

Everything QuickBooks Online's Expense form asks for, filled in for a whole month of spend.

  • Payment Account

    The credit card, bank account or petty cash that paid.

  • Category Lines

    One category per expense, or a split across several.

  • Payees

    Vendors matched by name, or left blank for small spend.

  • Payment Method

    Card, cash, check or transfer, from your methods list.

  • Billable Costs

    Client spend flagged billable, waiting for the next invoice.

  • Classes & Locations

    Spend sorted by store, department or brand.

  • Ref Numbers & Memos

    Report or receipt numbers and notes carried over.

  • Refunds Held

    A negative line waits for review instead of posting.

Bulk Import Expenses. QuickBooks Online Gets Every Card and Account.

Free plan, no credit card needed.

Get Started for Free
ExpenseSampleAmount$129.99
Payment account
Checking
Payee
Northside Supply
Payment date
11/10/2026
Payment method
Debit card
Ref no.
E-503
Location
Downtown

Category details

  1. 1Supplies · Cleaning stock84.99
  2. 2Office Expenses · Printer tonerBillable · Lee Catering45.00
Memo: Store run, report 11-BTotal $129.99
Expense E-503 from the sample file as QuickBooks Online receives it: the bank account that paid, the payee and both category lines.

QuickBooks Online's Options for Expenses vs Autymate

Beyond its Import data screen, QuickBooks Online takes card and cash spend two ways. Here's how they compare.

QuickBooks Online's Options for Expenses vs Autymate
Receipt captureBank & card feedAutymate Transactions
Works from a spreadsheetNoOnly a 3- or 4-column bank fileYes, any column layout
VolumeReceipt by receipt, each reviewedLines arrive in bulk, categorized one by oneA month of rows, categorized from your file
Split across categoriesBy handBy handYes, rows that share a ref no.
Locations & billableBy handBy hand, or with bank rulesFrom your columns
Cash & out-of-pocket spendYesNo, it never reaches the feedYes
DuplicatesCan match a feed linePossibleAlready-posted rows skipped

QuickBooks Online's options from Intuit, checked November 2026. Intuit's help article also lists expenses under Import data, for spreadsheets of under 1,000 rows; which import options appear depends on your plan and region. A bank file takes a date, a description and an amount. (Intuit: importing data (opens in a new tab) · Intuit: bank file format (opens in a new tab))

How to Set Up Your Expense File

Start from the statement, report or tracker you already have. There's no template to fill in; these habits keep every run clean:

  • One row per expense. For a split, one row per category line, all sharing the same ref number.

  • Say which account paid. Name the card, bank account or petty cash on each row, or set one default while mapping.

  • A category on every row. Payee can stay blank for small spend like parking or postage.

  • Refunds come back for review. A negative amount is held with the reason rather than posted.

  • Keep reimbursements apart. Out-of-pocket spend you pay an employee back for usually belongs on a bill or check to them.

Import Credit Card Expenses into QuickBooks Online

CSVnov-ops-card.csvSample
  1. RefNo,Date,PaidFrom,Payee,Category,Amount
  2. E-501,11/09/2026,Ops Card,Harbor Fuel,Fuel,64.20
  3. E-502,11/09/2026,Ops Card,City Cab,Travel,38.50
  4. E-503,11/10/2026,Checking,Northside Supply,Supplies,84.99
  5. E-503,11/10/2026,Checking,Northside Supply,Office Expenses,45.00

Becomes 3 expenses in 2 accounts

Four rows, three expenses: two on the company card, one split expense from checking. (The payees are made up.)

Expense, Check or Bill: Which Record Fits the Row?

Expense, Check or Bill: Which Record Fits the Row?
RecordWhen it's paidPaid fromTypical source
ExpenseOn the spot, by card, cash or transferA credit card, bank or cash accountCard statements, petty cash logs, company-card expense reports
CheckOn the spot, by a written checkA bank account, with a check numberA check register
BillLater: you owe it now and pay it by its due dateAccounts payable, then a bill paymentVendor invoices, and reimbursements owed to employees

Import checksImport bills

How Expense Columns Map to QuickBooks Online

Autymate pairs your headers with expense fields. Adjust any pairing, add defaults, and save it for next month.

How Expense Columns Map to QuickBooks Online
Your columnQuickBooks Online expense fieldNotes
RefNoRef no.Rows that share one become a single expense
DatePayment dateFormatted with one date rule
PaidFromPayment accountA credit card, bank or cash account in QuickBooks Online
PayeePayeeOptional; an unknown payee is held for review, with the reason
MethodPayment methodMatched to your payment methods list
CategoryCategoryMatched by name to your chart of accounts
AmountAmountLines must add up; a negative amount is held
Customer / BillableCustomer, BillableFor spend you pass on to a client
Location / ClassLocation / ClassWhen location or class tracking is on
MemoMemo / DescriptionOn the expense or on its line

Fill Any Field Four Ways

  • Source

    Take the value from a column in your file.

  • Default value

    Used when a row leaves it blank, such as the card account.

  • Override value

    One value every time, whatever the file says.

  • Advanced Function

    Reformat a date, tidy a payee name, or join two columns.

How to Import Expenses into QuickBooks Online

Five steps and a few minutes for the first statement. Next month, the saved mapping makes it one upload.

  1. Create your free Autymate Transactions account, then sign in with Intuit to link the QuickBooks Online company your spend belongs to.

    The Autymate destination card: QuickBooks Online, connected for the Store 101 location, with the record still to choose.
    QuickBooks Online linked for one location, ready for a record type.
  2. Pick Expense as the record, then upload a statement or report file, or connect the Google Sheet your team logs spend in.

    The Autymate record menu for QuickBooks Online, listing Daily Sales Receipt, Invoice, Deposit, Journal Entry, Expense and Bill, each with its field count; Expense has 8 fields.
    Expense sits in the record menu, beside Bill.
  3. Headers are paired with expense fields for you. Set a default payment account when the file doesn't say which card paid.

    The Autymate mapping preview from a sales-receipt sample: each field shows the column, default, override or function that fills it, such as customer_name, Account with a Default, and Payment method with an Override.
    The mapping view, drawn on a sales-receipt sample: every field names the column, default or override that fills it.
  4. Check each expense the way QuickBooks Online will show it: payment account, category, payee and amount. Anything that can't post is held back first.

    The Autymate Preview before publishing dialog on a sample run: 123 rows read, 121 ready, 2 need review, with a row flagged Totals don't balance, and nothing written to QuickBooks Online until you publish.
    The preview before publishing, on a sales-receipt sample: rows read, records ready, rows held back.
  5. Post the batch, then match each expense to its card or bank feed line instead of adding the line again. Fix held rows and run again; posted ones stay skipped.

    A finished Autymate sample run: 121 of 123 posted to QuickBooks Online and 2 needing review, with each row's status and a Resolve button on the held row.
    A finished sample run: what posted, and what waits for review.

Common Expense Import Errors, Handled

What usually stops an expense import into QuickBooks Online, and how Autymate deals with each one.

Common Expense Import Errors, Handled
ErrorWhat causes itHow Autymate handles it
Wrong payment account typeThe paid-from account is an expense or income account, not a card or bank account.Holds the expense with the reason, so you can point it at the right card or bank.
“Account doesn't exist”A category in the file isn't in your chart of accounts.Holds the row and names the missing category, so you can map it to one you have.
Expense already in the feedThe same charge came in from the bank or card feed and was added there.Never posts a row twice. Match feed lines to imported expenses rather than adding them.
Refunds as expensesA card refund arrives in the statement as a negative amount.Holds it with the reason instead of posting a negative expense.
Payee missing or newSmall spend with no vendor, or a vendor QuickBooks hasn't seen.A blank payee posts as is. An unknown one is held for review, with the reason.
Split lines don't add upThe category lines of one expense don't match its total.Holds the expense and shows the difference.

When an Expense Doesn't Add Up

A split expense whose lines miss its total stays out of QuickBooks. You decide how to settle it once, and can apply that choice to every row like it.

The Autymate Amount does not balance panel: the mapped amount does not equal the sum of its lines, nothing was posted for the transaction, and the options are Recalculate from line items, Post with a rounding adjustment, or Skip the affected rows, with Do this automatically from now on.
The review panel for an amount that doesn't balance. Nothing posted for the row.

Who Imports Expenses into QuickBooks Online

  • Office Managers with Company Cards

    The month's coded card spend, posted in one run instead of one charge at a time.

  • Multi-Location Businesses

    Each store's supplies, repairs and fuel kept apart by class or location.

  • Bookkeepers & Accounting Firms

    Every client's spend log, whatever its layout, with a mapping saved per client.

  • Agencies & Consultants

    Project spend flagged billable, so it lands on the client's next invoice.

  • Field & Fleet Teams

    Fuel, tolls and parts tagged by vehicle, crew or job.

  • Catch-Up Bookkeeping

    Six months of card statements and receipt trackers, cleared in an afternoon.

Expense Import Pricing for Every Location

Begin on the free plan with no card. Standard covers every location's spend 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

New accounts open on Free, so your first statement can post real expenses the day you sign up. Get started for free

What Comes with Autymate Transactions

  • Bulk expense import to QuickBooks OnlinePayment account, category lines and payee on every expense, reviewed before posting.
  • Excel, CSV, Google Sheets and IIFStatements, expense reports and shared spend trackers, as they are.
  • Direct POS connectionsPoint-of-sale data reaches QuickBooks Online with no file export in between.
  • One automation for every locationMap a statement layout once and reuse it at each location, even in separate QuickBooks companies.
  • Review every location in one placeEvery location's posted and held expenses on one screen, with no company switching.

Importing Expenses into QuickBooks Online

Yes. Intuit lists expenses among the types QuickBooks Online's own Import data screen takes, in spreadsheets of under 1,000 rows, and the options it shows depend on your plan. Autymate Transactions imports expenses in bulk from Excel, CSV, Google Sheets and IIF, with payment accounts, category lines, payees and locations.

Connect QuickBooks Online to Autymate Transactions, pick Expense, upload your file or connect a sheet, map the columns, preview, then post. Next month, the saved mapping does the pairing for you.

Yes. Give each expense a row with its date, payment account, category and amount, in .xlsx or .xls. Autymate pairs your headers with expense fields and turns each row, or each group of rows sharing a ref number, into one expense.

Yes. Name the credit card account as the payment account, and each row posts as an expense in that card's register. A negative row, such as a refund, is held for review with the reason rather than posted.

An expense is spend paid on the spot by card, cash or transfer. A check is paid on the spot by a written check from a bank account. A bill is owed now and paid later through accounts payable. Autymate imports all three.

No. QuickBooks Online lets an expense go without a payee, which suits small card and cash spend. Add one when you want vendor reports; a payee QuickBooks doesn't have yet is held for review, with the reason.

Not if you match them. After the import, match each feed line to the expense that's already there instead of adding the line. Autymate also remembers what it posted, so running the same file twice never doubles an expense.

Yes. Map a customer column and the billable flag, and the cost waits on that customer, ready to add to their next invoice. QuickBooks Online needs billable expense tracking turned on first.

Yes. Spend on a company card posts as expenses against that card. Out-of-pocket spend you pay back usually goes on a bill or check to the employee instead, and Autymate imports those too.

Autymate Transactions has a free plan with no card: one location and 200 rows a month. Standard is $19 per location per month, with unlimited rows.

Stop Coding Expenses One at a Time

Bulk import a month of card and cash spend into QuickBooks Online. Free plan, no credit card needed.

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