JWillum productsFree guide · JWillum products
Why does my QuickBooks journal entry CSV import fail, and how do I fix it?
Fix QuickBooks Online journal entry CSV import errors: unbalanced entries, account names that do not match, date formats, number formats and missing columns.
Published
Short answer: most QuickBooks Online journal entry imports fail for one of five reasons: an entry whose debits and credits don't balance, an account name that doesn't exactly match your chart of accounts, a date in the wrong format, amounts with currency symbols or thousand separators, or missing or misnamed columns. Check each journal number balances on its own, copy account names exactly from QuickBooks, and use plain numbers.
The common errors and fixes
| Problem | Fix |
|---|---|
| Debits ≠ credits for a journal | Group by journal number and sum debits and credits. Every journal must balance on its own, not just the whole file. |
| Account not found | Copy names exactly from the chart of accounts, including spelling and sub-account format (Parent:Child). Create missing accounts first. |
| Date not recognised | Use one date format that matches your QuickBooks region settings throughout the file. |
| Amount not a number | Remove currency symbols and thousand separators. Use a dot or comma decimal consistently with your settings. Watch for amounts in cents (10000 instead of 100.00). |
| Columns not mapped | Include at least journal number, date, account, debit and credit columns, and map them in the import screen. |
| Both debit and credit on one line | Put each amount on its own line: one line debit, another line credit. |
Worked example (illustrative numbers only)
Example: this file fails because journal SC-2026-10-15 is off by 0.01 and the fee account is misspelled:
Journal No.,Journal Date,Account Name,Description,Debits,Credits
SC-2026-10-15,10/15/2026,Stripe Clearing,Gross charges,175.00,
SC-2026-10-15,10/15/2026,Sales,Gross charges,,175.00
SC-2026-10-15,10/15/2026,Stripe Fee,Fees,5.98,
SC-2026-10-15,10/15/2026,Stripe Clearing,Fees,,5.97Fixed: rename Stripe Fee to the exact account name (Stripe Fees) and change 5.97 to 5.98. Debits 180.98 = credits 180.98, so it imports.
Prevent it next month
- Round each amount to two decimals before totalling, so rounding can't unbalance a journal.
- Keep a fixed list of account names and reuse it.
- Test with one small journal before importing a whole month.
For Stripe data specifically, see how to record Stripe fees in a journal entry and the full Stripe reconciliation guide.
Doing it faster: StripeClear Journal
StripeClear Journal is a single offline HTML file ($8 one-time). Drop in your Stripe balance transactions CSV and it builds one balanced QuickBooks Online journal per day, with a payout summary and an audit file. It runs in your browser; nothing is uploaded. It is a reconciliation helper, not accounting advice. Want to look at your data first? Try the free Stripe Payout Check.
Related guides
FAQ
Why does QuickBooks say my journal entry is not balanced?
At least one journal number has debits that do not equal credits, often by a rounding cent. Sum debits and credits per journal number to find it.
Why does QuickBooks not find my account?
The account name in the CSV must match the chart of accounts exactly. Sub-accounts usually need the Parent:Child form.
Which date format should I use?
Use one format consistently that matches your QuickBooks company region settings.
Can I import Stripe data straight into QuickBooks as journal entries?
Not from the raw Stripe export; it has to be grouped into balanced journals first. You can do that in a spreadsheet, or use a tool that outputs a journal CSV.
Check your own export for free
Drop a Stripe balance CSV into the free Stripe Payout Check to see per-category totals and whether every row ties out (gross − fee = net). It runs in your browser and nothing is uploaded.