QuickBooks Online Journal Entry CSV Importer

What it does

Upload a spreadsheet of journal entries. Get back a CSV formatted precisely for QuickBooks Online → Accountant → Journal Entries → Import — with balance validation before you export so you don't waste time importing entries QBO will reject.

Who this is for

Accountants and bookkeepers doing:

• Year-end adjusting entries (accruals, deferrals, prepaid expenses)
• Depreciation schedules
• Reclassifications
• Intercompany eliminations
• Opening balance entries for new clients

If you're manually entering 20+ journal entry lines into QBO, this saves you the keystrokes and the inevitable transcription errors.

What it handles automatically

• Balance checking — Validates that debits equal credits for every journal entry group before export. QBO rejects unbalanced entries silently; this surfaces the problem first.
• Date reformatting — Converts to MM/DD/YYYY as QBO requires
• Debit/Credit detection — Handles sources that use a single signed Amount column instead of separate Debit/Credit columns
• Journal grouping — Verifies all rows with the same JournalNo share consistent dates
• Account name matching — Flags journal lines whose Account names don't look like standard chart-of-accounts entries so you can fix them before import

How it works

1. Upload your journal entry spreadsheet (CSV, XLSX, or TSV)
2. Map your columns to the required fields: JournalNo, JournalDate, Account, Debit, Credit
3. The tool validates balance for each journal entry group and shows errors
4. Preview the first 5 entries (free)
5. Export the balanced, formatted CSV — one-time $7

Required fields

| Field | Required | Notes | |-------|----------|-------| | JournalNo | Yes | Groups related debit/credit lines. E.g. JE001 | | JournalDate | Yes | Posting date. Converted to MM/DD/YYYY | | Account | Yes | Must match your QBO chart of accounts exactly | | Debit | One of Debit/Credit | Positive amount. Leave blank for credit lines | | Credit | One of Debit/Credit | Positive amount. Leave blank for debit lines | | Description | No | Line-level note. Optional but recommended | | Name | No | Customer, vendor, or employee name |

QBO import instructions

After downloading your cleaned CSV:

1. In QBO, go to Accountant (left sidebar) → Journal Entries
2. Click the Import button (upper right)
3. Upload the cleaned CSV
4. Map the columns if QBO's auto-detection missed any
5. Review and confirm

FAQ

What does "balance checking" catch? For each unique JournalNo, the tool sums all Debit values and all Credit values. If they don't match within half a cent, it flags the entry and shows you which rows are in the group. Common causes: a row got lost in copy-paste, a formula error, or a rounding issue.

My source data uses a single Amount column (positive for debits, negative for credits) — does that work? Yes. Map your Amount column to both Debit and Credit. The tool will split it: positive values go to Debit, negative values (as their absolute value) go to Credit.

Does it verify account names against my actual QBO chart of accounts? No — that would require API access to your QBO account. The tool validates format and structure. Always review account names before importing; a mismatch will cause an import error in QBO.

Does it store my data? No. All processing is in your browser. Your journal entry data never reaches a server.