Import Expenses into QuickBooks from Excel or a Statement

Quick Answer: QuickBooks has no single "import expenses" button. In QuickBooks Online, the usual route is to upload the spending as a bank or card file (CSV or .QBO) and categorize each line; bills and journal entries can also be imported from a spreadsheet. In QuickBooks Desktop, you import a .QBO Web Connect file, build an IIF file, or use a paid import add-on.

Importing expenses into QuickBooks means turning rows of spending, usually from an Excel sheet or a bank statement, into records QuickBooks understands: bank-feed lines, bills, checks, card charges or journal entries. Which record type you aim for decides the method, the amount of cleanup, and whether the expenses later reconcile against the bank without duplicates.

Which import route should you use?

Start with the source of the rows and the edition you run. The time column is a rough guide for a few hundred lines, assuming a tidy file.

Is it an expense, a bill or a bank line?

The distinction matters more than the file format.

• Already paid from the bank or a card: the money has left. In QuickBooks Online you want these to arrive as bank-account lines so each one is categorized once and the account reconciles. Importing them as standalone expenses and also letting the bank feed bring them in counts every purchase twice.
• Owed but not yet paid: that is a bill. Import it as a bill and pay it later; the payment then matches the bank line.
• Reimbursable employee spending: often recorded as a bill to the employee or through an expense-report tool, not as a bank line, because the company's bank never paid the merchant.

If your spreadsheet mixes these, split it into separate sheets before importing anything.

Getting a spreadsheet of expenses into QuickBooks Online

QuickBooks Online's upload screen takes CSV files with either three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit), according to Intuit's manual upload article. The same page lists QBO, QFX and CSV transaction files, plus PDF or image statements, as accepted uploads, with a 350 KB and 1,000-line limit per transaction file.

Steps, using Intuit's labels:

1. Save the sheet as CSV with one header row and one expense per row. Spending should be negative in a single Amount column, or positive in a Debit column if you use four columns.
2. Go to All apps > Accounting > Bank transactions, open the Link account dropdown and choose Upload from file.
3. Select the file, pick the bank or card account the expenses were paid from, and map the columns.
4. Choose the lines to import and confirm.
5. Categorize them in the review list. Bank rules help a lot here; our guide to categorizing bank transactions in QuickBooks Online walks through rules, splits and matching.

Notice that the category is not imported from your spreadsheet in this route. Even if your Excel file has a Category column, the upload brings in date, description and amount, and you assign accounts during review. That is the main time cost, and it is why people search for an expense import tool.

What Intuit's spreadsheet import does cover

Intuit's importing data FAQ lists bank data, customers, suppliers, the chart of accounts, products and services, invoices, credit notes, sales receipts, journal entries and bills, from CSV, XLS/XLSX or Google Sheets, with fewer than 1,000 rows per sheet. Expenses and checks are not on that list. So, natively, you have three choices for categorized expense rows: bills, a journal entry, or the bank upload followed by review. Paid third-party importers write expenses with categories directly through Intuit's interface; they cost a subscription and need careful mapping, but for thousands of pre-categorized rows they can save days.

Getting expenses into QuickBooks Desktop from Excel

QuickBooks Desktop has no CSV upload into a bank register. Your options:

• Web Connect (.QBO): Desktop's Bank Feeds read .QBO files, which is the cleanest path for spending that went through a bank or card. Intuit's article on downloading bank feed transactions in Desktop starts from Banking > Bank Feeds > Bank Feeds Center. Turning an Excel sheet into .QBO requires a conversion tool, since Excel cannot save that format.
• IIF files: Intuit's IIF tasks article confirms IIF can import lists or transactions, via File > Utilities > Import > .IIF Files. It also warns that imports cannot be undone and that Intuit gives no assisted support for building IIF files. Back up first, test with three rows, and check that every vendor and account name matches your lists exactly.
• Add-on importers: the same commercial tools that serve QuickBooks Online have Desktop versions that read Excel directly.

Our article on converting an Excel file to IIF goes deeper on the IIF layout and its risks.

When the expenses only exist on a PDF statement

Plenty of expense backlogs start as a stack of card or bank statements rather than a spreadsheet. Retyping them is the slowest option. QuickBankConvert reads statement PDFs into rows of date, description and signed amount, and can write the result as CSV or Excel on a free account, or as a QuickBooks .QBO file on the paid plans described on the pricing page. From there, the file follows the bank-upload route above. If you want to tidy descriptions or add a category column for your own records first, take the Excel output; if you want the shortest path into a register, take QBO.

Before relying on any converted file, compare the row count and the statement's total debits with what you see in the preview. Scanned statements in particular are read less accurately than PDFs downloaded from the bank.

Mistakes that cost the most time

• Importing expenses that the bank connection will also download. Pick one source per account and per date range.
• Positive numbers for spending in a three-column file. QuickBooks reads them as deposits. Flip the sign or switch to four columns.
• Vendor names that do not match. Bill imports and IIF files reject or duplicate vendors with slightly different spellings.
• One giant file. Stay under the row and size limits; split by month instead.
• Skipping the backup in Desktop. An IIF mistake has no undo.

For a broader workflow around receipts, categories and monthly review, see tracking business expenses from bank statements.

Related guides

• Import bank transactions into QuickBooks Online
• Categorize bank transactions in QuickBooks Online
• Import CSV bank transactions into QuickBooks Desktop
• Excel template for a QuickBooks import