A journal entry import error in QuickBooks Online almost always traces back to the CSV, not to QuickBooks. Check four things in order: each journal's debits equal its credits, every account name matches the chart of accounts exactly, the Journal No. column groups the right lines together, and every date is a real date in one format.
Reading a journal entry import error before editing the CSV
A journal entry import error tells you which part of the file QuickBooks Online could not accept, and reading it closely saves editing the wrong column. Note the row or journal number the message names, then open the CSV and look at that entry as a whole, every line sharing its Journal No., not just the one line.
Intuit's article on importing journal entries into QuickBooks Online lists the columns the file should carry: Journal No., Journal Date, Account Name, Journal/Description, Debits and Credits. Its advice for an error is short: edit the file and try again. The sections below turn that into specific checks.
Before you edit, do three things:
- Save a copy of the original CSV. You will want to compare after changes.
- Sort by Journal No. Lines of one entry should sit together so you can total them.
- Open the chart of accounts in another tab. Most fixes involve comparing names against it.
Numbered banking codes are a different problem. A code such as 179 comes from a bank feed sign-in, not from a journal entry file, and error 179 and being signed in too many places covers it.
Do the journal entry debits equal the credits?
Each journal entry in the file must balance: the debits on its lines must add up to exactly the same amount as its credits. QuickBooks treats every group of lines sharing a Journal No. as one entry, so a single unbalanced group can block that entry even when the file as a whole balances.
Check it with a small pivot or a SUMIF by Journal No. Total Debits and Credits for each number, then subtract. Anything other than zero is a problem. The usual causes:
- A missing line. An entry has its debit to an expense account but nobody added the credit to the bank.
- Rounding. Amounts calculated in a spreadsheet, such as a split of a bill into thirds, can be off by a cent. Round each line to two decimals before totalling, not after.
- Both columns filled on one line. A line should have a debit or a credit, not both. Put the second amount on its own line.
- Negative numbers. A negative debit is not a credit. Move it to the Credits column as a positive number.
- Formatted numbers. A currency symbol or thousands separator saved as text can be read as nothing at all.
The published guide covers why entries must balance and how to plan them, in balancing debits and credits in each journal entry.
Journal No. values that group or split entries
The Journal No. column decides which lines belong to the same journal entry. Lines with the same number become one entry, and a new number starts a new one. A mistake in this column joins two unrelated entries or splits one in half, and either can leave an entry unbalanced.
Watch for these:
- A number repeated for two different entries. Two months of rent, both numbered 101, are merged into one entry dated on the first line's date.
- A number that changes partway through an entry. If the credit line has 102 and the debit line 101, each half is unbalanced on its own.
- Blank Journal No. cells. Leave none. Fill every line, even if your spreadsheet visually groups them.
- Numbers stored differently. "101" and "101.0", or "JE-101" and "JE101", are different values to an import.
A worked example
The file below is an example with made-up accounts and amounts. It should hold three entries, and it has several faults.
| Journal No. | Journal Date | Account Name | Debits | Credits |
|---|---|---|---|---|
| 101 | 03/31/2026 | Rent Expense | 1,500.00 | |
| 101 | 03/31/2026 | Checking | 1,500.00 | |
| 102 | 03/31/2026 | Depreciation | 212.50 | |
| 103 | 03/31/2026 | Accumulated Depreciation | 212.50 | |
| 104 | 02/30/2026 | Utilities | 96.20 | |
| 104 | 02/30/2026 | Checking | 96.02 |
Entry 102 and 103 should be one entry; each is unbalanced on its own. Entry 104 has an impossible date and its credit has two digits swapped. Here is the corrected version:
| Journal No. | Journal Date | Account Name | Debits | Credits |
|---|---|---|---|---|
| 101 | 03/31/2026 | Rent Expense | 1500.00 | |
| 101 | 03/31/2026 | Checking | 1500.00 | |
| 102 | 03/31/2026 | Depreciation Expense | 212.50 | |
| 102 | 03/31/2026 | Accumulated Depreciation | 212.50 | |
| 104 | 02/28/2026 | Utilities | 96.20 | |
| 104 | 02/28/2026 | Checking | 96.20 |
The thousands separators are gone, the depreciation lines share one number, and "Depreciation" now matches the real account name, which brings us to the next check.
Journal entry account names QuickBooks can't match
Every Account Name in the file must match an account that already exists in the chart of accounts, spelled the same way. QuickBooks Online does not create accounts during a journal entry import. An account that is new, renamed or written in a different form will stop the line.
Intuit's journal entry article gives three specific rules:
- Add new accounts first. Any account in the spreadsheet that isn't in the chart of accounts yet must be added before you import.
- Write sub-accounts with their parent. A sub-account is entered as the parent name, a colon and then the sub-account name, such as "Utilities:Electric". Entering only "Electric" produces a Line Account Invalid error.
- Turn account numbers off while importing. Intuit recommends switching account numbers off for the import and back on afterwards, so the names match without numbers in front.
Other mismatches to look for:
- Trailing spaces after a name, invisible in the spreadsheet.
- "&" in the file where the account says "and".
- An account that was made inactive. Reactivate it for the import, or point the line at the account you use now.
- The same name used by two accounts at different levels, which a full Parent:Sub path resolves.
If the file came out of another system, its names rarely match one for one. Moving from Zoho Books to QuickBooks covers mapping one chart of accounts onto another before any entries come across.
Why do A/P and A/R lines fail in a journal entry import?
Lines posted to Accounts Payable or Accounts Receivable fail when the Name column is empty or holds a name QuickBooks can't link. Intuit's journal entry article says that when A/P or A/R is the account, the import asks for a name in the Name column, and its wording names a vendor. Fill that column on every such line.
Two things go wrong most often:
- There is no Name column at all. Add one, even if only the A/P and A/R lines use it.
- The name doesn't match a contact. "ABC Supply" in the file and "ABC Supply Co." in QuickBooks are different. Copy the display name from the vendor or customer list.
Think twice before posting to A/P or A/R by journal entry at all. Entries there do not link to a bill or an invoice, so the open balance for that vendor or customer can look wrong until you apply the entry by hand. If the goal is to record bills, a bill import is usually the cleaner route.
Journal Date values and duplicate journal numbers
A journal entry can be refused for a date that QuickBooks can't read, and for a Journal No. that already exists in the company. Dates need to be real calendar dates in one consistent format across the file. Journal numbers collide with existing entries when QuickBooks is set to warn about duplicates.
Dates
Use one format for every row and write four-digit years. Check for impossible dates such as February 30, and for dates a spreadsheet silently changed into a number or a different style when it saved the CSV. Open the saved file in a text editor to see what was actually written. Also check that no date falls in a period you have closed with a closing date, since entries dated there may need the closing password or be blocked.
Duplicate numbers
Intuit's article says that when the "Warn if duplicate journal number is used" preference is on, entries reusing an existing number may fail, and suggests turning the preference off before the import. The alternative is to renumber the file so it starts above the last journal number already in QuickBooks. Renumbering is safer if several people import entries, because it keeps every number unique.
When a journal entry import is the wrong tool for bank lines
A journal entry import is the wrong tool when the lines come from a bank or card statement and need to be matched against a bank account. Journal entries post straight into the books and skip the review step, so they can double up with any bank feed that later brings the same lines in.
Bank and card lines belong in a bank upload, where QuickBooks shows each line for review before it lands. That route has its own failure points, such as a file meant for a card account being uploaded to a checking account; what to do when a QBO file's account type doesn't match covers that one.
Use journal entries for what they do well: depreciation, accruals, payroll summaries from an outside provider, year-end adjustments and opening balances. For bank lines that only exist on a PDF statement, the job is to turn the statement into a CSV or QBO file for the bank upload. SimpleBankConvert is being built for that conversion; it is not taking accounts yet, and the homepage describes the files it will produce.