JWillum productsFree guide · JWillum products
QuickBooks journal entry import: "account not found" and how to fix it
QuickBooks Online journal entry CSV import says an account does not exist or is not found? Match names exactly, use Parent:Child for sub-accounts, and create missing accounts first.
Published
Short answer: QuickBooks Online matches the Account Name column against your chart of accounts by text. If a name differs at all (spelling, extra spaces, a sub-account without its parent, or an account that doesn't exist yet), that line can't be mapped. Copy names exactly from the chart of accounts, write sub-accounts as Parent:Child, and create any missing account before importing.
Steps
- Export or view your chart of accounts (Settings → Chart of accounts) and copy the exact names you need.
- List the unique account names in your CSV (a pivot table or a UNIQUE() formula in a spreadsheet) and compare them one by one.
- Fix sub-accounts: if Stripe Fees sits under Bank Charges, write
Bank Charges:Stripe Fees. - Remove stray spaces with TRIM() and check for look-alike characters such as non-breaking spaces or curly quotes.
- Create missing accounts in QuickBooks first, with the right account type.
- Re-import one journal to test, then the full file.
Worked example (illustrative)
Journal No.,Journal Date,Account Name,Description,Debits,Credits
SC-2026-10-15,10/15/2026,Stripe Fees ,Fees,5.98,
SC-2026-10-15,10/15/2026,Stripe Clearing,Fees,,5.98In this company file, Stripe Fees is a sub-account of Bank Charges, and the CSV has a trailing space. Fixed line: SC-2026-10-15,10/15/2026,Bank Charges:Stripe Fees,Fees,5.98,
Other causes worth checking
- The account is inactive (deleted accounts in QuickBooks Online are made inactive). Reactivate it or use another one.
- The CSV uses an account number while your file is set up to show names, or the other way round. Use the name.
- Bank and A/R or A/P accounts may need extra columns (such as a customer or vendor name). Keep those lines out of the import if you don't have them.
Other errors (unbalanced entries, dates, amounts): see QuickBooks journal entry CSV import errors.
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
- Why does my QuickBooks journal entry CSV import fail, and how do I fix it?
- Why doesn't my Stripe payout match my bank deposit?
- How do I record Stripe fees in a QuickBooks journal entry?
- Stripe refund fees: how to record them in QuickBooks
- How to export Stripe to QuickBooks as journal entries (one per payout or day)
- Stripe refunds and chargebacks: how to book them
- Whatnot fee calculator: how Whatnot fees are calculated
FAQ
Why does QuickBooks say my account does not exist?
The name in the CSV doesn't exactly match an active account in your chart of accounts, often because of a typo, a trailing space or a missing parent account.
How do I write a sub-account in the import CSV?
Use the full path with a colon, for example Bank Charges:Stripe Fees.
Can the import create accounts for me?
Create them in the chart of accounts first so you control the account type, then import.
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.