Journal entry import failing in QuickBooks Online: what the errors mean
Updated
The short answer
Nearly every rejected journal entry import is one of six things: an entry that does not balance, an account name that does not match, a bad date or number format, a missing Name on an accounts receivable or payable line, a file over 1,000 lines, or a column mapped to the wrong field. Find the row, fix the cell, import again.
How to do it by hand
- Does each Journal No. balance?. Sum Debits and Credits per Journal No. A difference of one cent is enough to fail. Check rounding when totals came from percentages.
- Does every account name match?. Compare each Account Name with the chart of accounts character for character: spelling, spaces, ampersands, and Parent:Child for sub-accounts.
- Are the dates and amounts clean?. Use one date format on every row. Remove currency symbols, thousands separators and brackets for negatives. A negative amount belongs on the other side, not as a minus sign.
- Is there a line for accounts receivable or accounts payable?. Those lines need a Name (the customer or vendor). Studio sales normally go through a clearing account instead, which avoids this.
- Is the entry on both sides of a line?. A line has either a debit or a credit, not both and not neither.
- Is the file too long?. More than 1,000 lines is refused. See the split steps in the 1,000-line guide.
- Did the mapping step match your columns?. On the import screen, confirm Journal No., Journal Date, Account Name, Debits and Credits each map to the matching QuickBooks field, especially if your header names differ.
- Look for hidden characters. A byte-order mark, different line endings or a stray quote from a spreadsheet export can shift columns. Open the file in a plain text editor to see it.
Why this happens
The importer validates before it posts anything, so one bad row can hold back its whole entry. The messages it shows can be short, which is why working down this list row by row is faster than guessing.
When the manual way is not enough
For a file with hundreds of rows, use the free journal entry CSV checker. It lists each Journal No. with its debits, credits and difference, flags row-level problems and shows how a long file would split. A clean result means those checks passed; it does not promise QuickBooks will accept the import.
The faster path: Studio Month-End only writes a file when the entry balances, so the balance error cannot reach QuickBooks from a file it builds. Free covers one studio and one month's import file download, ever; Studio is $19/mo and Bookkeeper is $59/mo for up to 15 studios. Your export is read in your browser and never uploaded. Try it free, or see pricing.