QuickBooks Online supports journal entry imports via CSV or through the QBO API. This guide covers both methods, the correct CSV format, common import errors, and how to automate the process for payroll journal entries specifically.
Method 1: Import journal entries via CSV in QuickBooks Online
As of 2025, QuickBooks Online supports bulk journal entry import via CSV in some regions. The process:
- Go to Settings (⚙️) > Import Data > Journal Entries.
- Download the QuickBooks Online journal entry import template.
- Fill in the template with your journal entry lines (date, account, debit, credit, description).
- Upload the CSV and review any validation errors before confirming.
Note: The bulk CSV import feature is not available in all QBO regions. If you don't see it, use Method 2 or a tool like PostBooks that uses the QBO API.
Method 2: Import via the QuickBooks Online API
The QBO API supports creating journal entries programmatically. PostBooks uses this method: you connect your QBO account (OAuth), and PostBooks posts the journal entry directly via the API — no manual file upload required.
Common QBO journal entry import errors
- "Account not found": The account name in your import file doesn't exactly match the account name in QBO. Check for extra spaces, capitalization differences, or account name changes.
- "Entry is out of balance": Debits and credits don't sum to the same total. Check each line for data entry errors.
- "Date format error": QBO expects dates in MM/DD/YYYY format. Make sure your CSV uses the correct format.
Automating payroll journal entry imports into QuickBooks Online
For payroll specifically, PostBooks automates the entire import process: upload your payroll provider's CSV, PostBooks generates the balanced QBO journal entry and posts it via the QBO API. You can also download the import-ready CSV if you prefer to review before importing.