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
Intuit Gold PartnerSOC 2 Type II audited
1,000+ Five-Star Reviews
- ✓Read
- ✓Map
- ✓Check
- ✓Post
- PaidFromPayment account
- CategoryCategory
- PayeePayee
- 244Ready
- 1Already posted
- 2New payee
- 1Negative amount
- 11/09Harbor FuelFuelOps Card$64.20
- 11/09City CabTravelOps Card$38.50
- 11/10Northside SupplySuppliesChecking$129.99
- +241 more
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 expensesCan 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 planSnap 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
- Approved report → Expense
Expense Management Tools
Employee reports once a manager signs them off.
Talk to an expert - Card charge → Expense
Corporate Card Programs
Charges your cardholders have already coded.
Talk to an expert - Fuel charge → Expense
Fuel & Fleet Cards
Fill-ups and tolls by driver or vehicle.
Talk to an expert - Paid-out → Expense
Register Paid-Outs
Cash taken from the drawer to buy supplies.
Talk to an expert - Booking → Expense
Travel & Booking Tools
Flights, hotels and rides charged to company cards.
Talk to an expert - Custom → Expense
Your Own System
Our custom integration team builds the connection for you.
Talk to an expert
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.
- Payment account
- Checking
- Payee
- Northside Supply
- Payment date
- 11/10/2026
- Payment method
- Debit card
- Ref no.
- E-503
- Location
- Downtown
Category details
- 1Supplies · Cleaning stock84.99
- 2Office Expenses · Printer tonerBillable · Lee Catering45.00
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.
| Receipt capture | Bank & card feed | ||
|---|---|---|---|
| Works from a spreadsheet | No | Only a 3- or 4-column bank file | Yes, any column layout |
| Volume | Receipt by receipt, each reviewed | Lines arrive in bulk, categorized one by one | A month of rows, categorized from your file |
| Split across categories | By hand | By hand | Yes, rows that share a ref no. |
| Locations & billable | By hand | By hand, or with bank rules | From your columns |
| Cash & out-of-pocket spend | Yes | No, it never reaches the feed | Yes |
| Duplicates | Can match a feed line | Possible | Already-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
RefNo,Date,PaidFrom,Payee,Category,AmountE-501,11/09/2026,Ops Card,Harbor Fuel,Fuel,64.20E-502,11/09/2026,Ops Card,City Cab,Travel,38.50E-503,11/10/2026,Checking,Northside Supply,Supplies,84.99E-503,11/10/2026,Checking,Northside Supply,Office Expenses,45.00
Becomes 3 expenses in 2 accounts
Ops Card
- Harbor FuelE-5011 line$64.20
- City CabE-5021 line$38.50
Checking
- Northside SupplyE-5032 lines$129.99
Expense, Check or Bill: Which Record Fits the Row?
| Record | When it's paid | Paid from | Typical source |
|---|---|---|---|
| Expense | On the spot, by card, cash or transfer | A credit card, bank or cash account | Card statements, petty cash logs, company-card expense reports |
| Check | On the spot, by a written check | A bank account, with a check number | A check register |
| Bill | Later: you owe it now and pay it by its due date | Accounts payable, then a bill payment | Vendor invoices, and reimbursements owed to employees |
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.
| Your column | QuickBooks Online expense field | Notes |
|---|---|---|
RefNo | Ref no. | Rows that share one become a single expense |
Date | Payment date | Formatted with one date rule |
PaidFrom | Payment account | A credit card, bank or cash account in QuickBooks Online |
Payee | Payee | Optional; an unknown payee is held for review, with the reason |
Method | Payment method | Matched to your payment methods list |
Category | Category | Matched by name to your chart of accounts |
Amount | Amount | Lines must add up; a negative amount is held |
Customer / Billable | Customer, Billable | For spend you pass on to a client |
Location / Class | Location / Class | When location or class tracking is on |
Memo | Memo / Description | On 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.
Create your free Autymate Transactions account, then sign in with Intuit to link the QuickBooks Online company your spend belongs to.

QuickBooks Online linked for one location, ready for a record type. Pick Expense as the record, then upload a statement or report file, or connect the Google Sheet your team logs spend in.

Expense sits in the record menu, beside Bill. Headers are paired with expense fields for you. Set a default payment account when the file doesn't say which card paid.

The mapping view, drawn on a sales-receipt sample: every field names the column, default or override that fills it. 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 preview before publishing, on a sales-receipt sample: rows read, records ready, rows held back. 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 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.
| Error | What causes it | How Autymate handles it |
|---|---|---|
| Wrong payment account type | The 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 feed | The 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 expenses | A card refund arrives in the statement as a negative amount. | Holds it with the reason instead of posting a negative expense. |
| Payee missing or new | Small 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 up | The 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.

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.
- Create your free account
- Connect QuickBooks Online
- Upload your card statement
Intuit Gold PartnerSOC 2 Type II audited
1,000+ Five-Star Reviews

