How to Import Journal Entries into QuickBooks Online from Excel

How-to · Updated July 2026 · ~11 min read

You have a month-end adjustment file in Excel — forty lines of accruals, prepaid amortisation and payroll allocations — and keying each one into QuickBooks Online by hand is what is keeping you at your desk. Or someone handed you an .IIF file from an old QuickBooks Desktop system and said "just import it into QBO."

Below: what QuickBooks Online genuinely supports, how to prepare the file, and what actually happens with IIF. Every QuickBooks menu path and rule comes from Intuit's current help articles, named at the end.

What QuickBooks Online natively supports

QuickBooks Online has a built-in journal entry importer, so you do not need a paid tool to get a spreadsheet of debits and credits into the ledger. Two things are worth stating clearly, because search results are stale on both.

It is not Advanced-only. Intuit's US help article "Import journal entries" (updated 6/29/2026) lists the feature for QuickBooks Online Advanced, Plus, Simple Start, Essentials, Free and Lite, and QuickBooks Solopreneur Plus. The "Advanced-only" claim on forums misremembers a restriction on a different transaction type: "Importing Bills is restricted to QuickBooks Online Advanced and higher subscription tiers in the US region." That is bills. Do not let anyone talk you into an upgrade you do not need.

It is available in the US. Some older community content says journal entry import is "currently unavailable in QuickBooks Online United States (US)." The live US article contradicts that. Everything below is scoped to the US interface; on other editions, check your region's article.

What file formats QBO accepts

Per Intuit's "Common questions about importing data to QuickBooks Online" (updated 7/1/2026), the importer accepts exactly three: CSV (Comma Separated Values), Google Sheets and XLS/XLSX. Nothing else — an Intuit staff reply about IIF-to-QBO imports repeats the same three. That list is the whole answer to the IIF question below.

The six fields QBO expects

Intuit lists the information your spreadsheet must include, in this order: Journal No., Journal Date, Account Name, Journal/Description, Debits, Credits.

Plus one conditional column: "Depending on Account Name selection (Accounts Payable or Accounts Receivable), the system will request the Name column to have a vendor selected." Intuit's wording says vendor; whichever name record you use, it must already exist in QuickBooks Online.

Intuit does not publish a journal entry CSV template on a public web page. The sample file lives inside the product — the import wizard offers Download a sample file. Use that, not a header row copied off a blog (including this one): the six items above are what Intuit names in prose, but the sample's literal headers are what your file should match.

Row limit and import order

Intuit's general importing-data FAQ sets the limit: "You can only import spreadsheets with less than 1,000 rows… we suggest that you split your spreadsheet into smaller files, then import them separately."

The recommended order is lists first — Chart of Accounts, Customers, Vendors, Employee, Class, Locations, Products and services — then transactions, including Journal Entries. Every journal line references an account and possibly a name, class and location; if those do not exist, the line fails.

Step by step: preparing the journal in Excel

Most rejected imports are file-preparation problems, not QuickBooks problems.

1. Turn off account numbers, and create missing accounts

Intuit is explicit on both: "Turn off account numbers before you begin… The account numbers can be turned back on once your import is complete," and "If your spreadsheet has new accounts, be sure to add them in your chart of accounts before importing." The importer creates nothing on the fly — same for vendors, customers, classes and locations.

Pre-flight check: export the chart of accounts to a sheet named COA with the names in column A, then add a validation column beside your own account names (column C here):

=IF(COUNTIF(COA!$A:$A, C2)=0, "MISSING", "")

Filter for MISSING and you have your list of accounts to create. COUNTIF ignores case and treats *, ? and ~ as wildcards, so for a character-for-character match use a bounded range:

=IF(SUMPRODUCT(--EXACT(COA!$A$2:$A$500, C2))=0, "MISSING", "")

To match fuzzily — your file says "Telephone & Internet", the COA says "Telephone and Internet" — a Power Query merge is cleaner (Power Query for beginners).

2. Write sub-accounts with the parent name

The single most common cause of a rejected line. Intuit's rule, verbatim:

"Journal Entry Line items must be a parent account, entries for sub accounts will need to include the parent account name and the sub account name separated by a colon. For example, 'Parent account: Sub Account'. Only entering the sub account name will cause a 'Line Account Invalid' error."

So Utilities:Electricity, not Electricity. If your source exports only the leaf name, rebuild the path — data in a table with Parent and Sub Account columns:

=TEXTJOIN(":", TRUE, [@Parent], [@[Sub Account]])

Intuit's written example shows a space after the colon. Rather than guess, copy the exact strings out of your exported chart of accounts.

3. One amount per row, and make each journal balance

Each row is one journal line. Put the amount in Debits or Credits — not both, and never a negative number in the opposite column; a negative debit is not the same thing as a credit to an importer. Then prove each journal out:

=SUMIF($A:$A, A2, $E:$E) - SUMIF($A:$A, A2, $F:$F)

Column A is Journal No., E is Debits, F is Credits. Every row should return 0. If you allocate by percentage, round each line, let the last absorb the difference, and wrap the check in ROUND(…, 2) so you test what QuickBooks will see rather than floating-point residue.

4. Dates: the biggest time sink

• Saving as CSV writes what the cell is displaying. If the cell shows 01/02/2026, so does the file — and whether that is 1 February or 2 January depends on a locale you cannot see. Set the column format explicitly and use four-digit years.
• Text-stored-as-dates. Left-aligned "dates" that are really text survive the save unchanged and land wrong. Test with =ISNUMBER(B2): a genuine date returns TRUE.
• Trailing spaces. "01/31/2026 " can fail to parse. For text values use =DATEVALUE(TRIM(B2)) and format the result as a date. Do not run TRIM() across genuine dates — TRIM returns text, so a real date becomes its serial number as a string (46052).

Then open the saved CSV in Notepad — not Excel — to see the literal characters written. For messier source data, how to clean messy data in Excel covers the wider fixes.

5. Classes, locations and duplicate journal numbers

Intuit confirms: "You can turn on class tracking and location tracking to import journal entries with classes and locations." Both must be switched on first and the records must already exist. Intuit does not name their column headers, so read those off the in-product sample file.

Also check the Warn if duplicate journal number is used preference on the Journal Entry form. Intuit's note: with it on, "you won't be able to upload some entries with existing numbers," so uncheck it before you import.

6. Save as CSV, then run the import

The exact path in US QuickBooks Online, per Intuit's article updated 6/29/2026:

1. Go to Settings ⚙️, then select Import Data.
2. Select Journal Entries.
3. On the Download page, select Browse. (If you need help formatting your journal entries, select Download a sample file.)
4. Find and select your CSV file. Select Open, then Next.
5. Map your information. "Your Field" represents the headers on your spreadsheet. From each small arrow ▼ icon, select the one that matches a field in QuickBooks Online.
6. Select Next. If there's an error, edit the file and try again.
7. Select Start import.
8. Select Done.

Intuit notes you "can use the search function to check and edit the journal entries." Spot-check the first, last and largest against your Excel file before closing the period — remembering that anything you pull back out of QuickBooks arrives as values, not formulas.

The IIF question, answered

If you searched for how to import an IIF file into QuickBooks Online, the answer is: you cannot. No setting, no hidden menu, no workaround. IIF is not on the accepted list.

Per Intuit's IIF overview (updated 5/26/2026): "Intuit Interchange Format (.IIF) files are ASCII text, TSV (Tab-Separated Value) files that QuickBooks Desktop uses to import or export lists or transactions." Desktop. Intuit's IIF how-to (updated 6/1/2026) is scoped to "QuickBooks Desktop for Windows and Mac," and its product list contains only Desktop, Enterprise, Accountant and Mac — zero QuickBooks Online products. The path File > Utilities > Import > Import IIF, as admin in Single-user Mode, exists only in Desktop, and Intuit "doesn't offer technical support for the import and export of IIF files."

What to do with an IIF file instead

An IIF file is just tab-separated text, so Excel can read it.

1. Rename a copy of journal.iif to journal.txt, leaving the original untouched.
2. In Excel, go to Data > Get Data > From File > From Text/CSV, pick the .txt copy, and set Delimiter to Tab in the preview window before loading.
3. An IIF transaction export comes in header/data pairs: rows starting !TRNS, !SPL and !ENDTRNS name the columns; the matching TRNS and SPL rows carry the transaction header and its splits.
4. Reshape into the QBO layout — Journal No., Journal Date, Account Name, Journal/Description, Debits, Credits — one line per row, plus a Name column where AP or AR is involved.
5. Split IIF's single signed amount into two columns. In a table with an Amount column, Debits is =IF([@Amount]>0, [@Amount], "") and Credits is =IF([@Amount]<0, -[@Amount], "").
6. Map the Desktop account names onto your QBO chart of accounts, remembering the Parent account: Sub Account rule.
7. Save as CSV and run Settings ⚙️ > Import Data > Journal Entries.

Doing this weekly through a migration? Build the reshape once in Power Query so it reruns in one click (what to use now that the QuickBooks Power Query connector is gone). The alternative is a third-party IIF-to-CSV converter — Intuit endorses none ("We're unable to recommend a specific application"), so test one on a copy of your data first.

Paid tools and the API route

A product category sits at the top of these search results, offering bigger batches, saved field mappings, extra transaction types and an undo of an imported batch. None of it changes the fact that your data must be correct, your accounts must exist and debits must equal credits. For 30 journal lines a month, the native importer plus a good Excel template does the job at no extra cost; for thousands of lines weekly across several entities, a paid tool earns its keep.

Those tools mostly skip the file entirely and write through the QuickBooks Online API, so the journal posts directly. The rules above — colon-path account strings, the 1,000-row split, CSV date roulette — belong to the spreadsheet importer, not to QuickBooks.

HISAB 360 is one option: a paid Excel add-in that puts an AI chat panel inside Windows desktop Excel and connects to six accounting systems — QuickBooks Online, Xero, Zoho Books, Odoo, FreshBooks and Sage — with read and write access. You can read ledgers, journals and reports into a sheet to check your file against what is really in QuickBooks, then post journal entries back from that sheet. It also handles the surrounding work — reconciling bank statements and pulling tables out of PDFs.

The honest limitations: Windows desktop Excel only (Excel 365 or 2019+) — no Mac, no Excel for the web. It is paid, with no free tier, though there is a limited free trial credit allowance: $7/month (or $60/year) if you bring your own AI provider key, $10/month for HISAB AI Basic, $20/month for HISAB AI Plus, or $199 perpetual, with credit top-ups at $4.99 and $12.99. Connecting to QuickBooks Online requires OAuth authorisation. And most importantly: review every journal before you approve the write, and reconcile afterwards. An API write is faster than a CSV import, so a mistake is faster too — any tool that posts to a ledger, this one included, is a drafting assistant, not an unattended process. See features, pricing and the ERP write-back page.

Frequently asked questions

Try HISAB 360 on your own workbook

HISAB 360 is an AI assistant inside Excel for accountants and finance teams — it writes macros, Power Query and formulas from plain English, and connects two-way to QuickBooks, Xero, Zoho Books, Odoo, FreshBooks and Sage. The 15-day trial is the full product, no card required.