Journal entries (JEs) are a key element in double-entry accounting, recording debits and credits for financial transactions outside of regular invoices, bills, or receipts. Importing journal entries into QuickBooks Online (QBO) is essential for businesses that need to manage large volumes of data or complex accounting tasks, including tracking cryptocurrencies in QuickBooks Online, such as system migrations, payroll summaries, or period-end adjustments.
Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Online. Utilize import, export, and delete services of Dancing Numbers software.
The bulk import process helps save time, reduce errors, and ensure accurate financial reporting. By using QBO’s native import tool or third-party solutions, businesses can streamline their accounting workflows and maintain a balanced general ledger. In this article, you will find a step-by-step guide to importing journal entries into QBO, the reasons for importing, the prerequisites, and answers to frequently asked questions.
Step 1: Preparing Your Data File for QBO Import Success
Before attempting any import, your spreadsheet must adhere to strict QuickBooks Online formatting rules. Failure to prepare your file correctly is the source of nearly all import errors.
Mandatory Fields Checklist (CSV/Excel)
Your import file must be saved in CSV (Comma Separated Values) or Excel (.XLSX) f ormat, and the following headers are required for a standard journal entry:
- Journal Date: Must be consistently formatted (e.g., MM/DD/YYYY or DD/MM/YYYY).
- Ref Number (Journal No.): A unique reference number for each entry. All lines belonging to the same journal entry must use the same Ref Number.
- Account Name: The name of the account from your Chart of Accounts.
- Debit: The amount to be debited. Enter a positive number.
- Credit: The amount to be credited. Enter a positive number.
- Journal/Description (or Memo): A description for the transaction line.
- Name (Conditional): REQUIRED if the Account Name is an Accounts Receivable or Accounts Payable type. This field must specify the Customer (for A/R) or Vendor (for A/P).
Critical Data Formatting and Account Mapping Rules
This is where most imports fail. Follow these rules precisely:
- Check for Balance: The total sum of the Debit column must equal the total sum of the Credit column for every single journal entry (i.e., for every unique Ref Number). An unbalanced entry will fail the entire batch.
- Turn off Account Numbers: Before starting the import process in QBO, ensure you disable the “Use account numbers” preference in your QuickBooks Online settings. You can re-enable it after the import is complete.
- Exact Account Name Match: The name in your spreadsheet’s “Account Name” column must match the name in your QBO Chart of Accounts exactly, including spacing and capitalization.
Note:
When posting to a sub-account, you cannot use just the sub-account’s name. The correct format is to enter the name as follows: Parent Account: Sub-Account Name. For example, if you have a parent account called “Fixed Assets” and a sub-account named “Equipment,” the entry should be written as: Fixed Assets: Equipment. Failure to follow this format is a common cause of the “Line Account Invalid” error.
Step 2: The Two Methods for Importing Journal Entries
QuickBooks Online offers a native import function, but many users (especially those with Advanced subscriptions) turn to third-party tools for higher volume, more flexibility, and better error resolution.
Comparison Table: QBO Native Import vs. Dancing Numbers
| Feature | QBO Native Import Tool | Dancing Numbers Importer |
| File Formats Supported | CSV only (sometimes XLSX/IIF, but often unreliable). | Excel, Google Sheets, CSV, IIF (most flexible). |
| Max Volume | Subject to QBO limitations (often fails with >100 entries). | High-volume handling (break large files into manageable batches). |
| Required QBO Version | Available consistently only in QuickBooks Online Advanced and Accountant editions. | Works with Simple Start, Essentials, Plus, and Advanced. |
| Error Handling | Often vague error messages or the “spinning wheel” of death; difficult to identify bad data. | Provides a detailed error log and validation rules to easily identify and correct bad lines before the final import. |
| Automation | None. | Allows for import scheduling and recurring templates. |
Option A: Using the Native QuickBooks Online Tool
Use this method for small, simple, one-off imports (1–50 entries) and ensure you have followed all the preparation steps in Step 1.
- Log in to QuickBooks Online.
- Click the ⚙️ Gear Icon (Settings) in the top right corner.
- Under the Tools column, select Import Data.
- Click the Journal Entries tile.
- Click Browse and select your prepared CSV file.
- Click Next.
- Map Your Data: On the mapping screen, match the columns from your spreadsheet (Your Field) to the corresponding QBO fields (QuickBooks Online Field).
- Click Next, review the data, and then click Start Import.
- Click Done.
Option B: Using the Dancing Numbers Importer
This is the recommended approach for high-volume, complex, or recurring imports, as it bypasses the native tool’s common errors and limitations.
- Open App Store: Navigate to the Intuit App Store and search for Dancing Numbers (or use your existing dashboard).
- Select Transaction Type: Click Start Import and choose Journal Entry as the transaction type.
- Upload File: Upload your Excel, Google Sheets, CSV, or IIF file.
- Map Fields: The tool will automatically map most fields, and you can confirm the mapping.
- Data Validation: Run the validation feature to proactively check for errors (unbalanced entries, non-existent accounts) before committing the data.
- Import: Once validated, proceed with the import. The tool provides a detailed report of all successful and failed entries.
Common Journal Entries Errors
A few users may face an error while they are importing journal entries in QuickBooks Online. The table given below shows why each error occurs and how it can be resolved.
| Error/Issue | Why It Happens | Solution (Steps to Fix) |
| “Line Account Invalid” | The account name in your spreadsheet does not exactly match your Chart of Accounts, or you used a sub-account without the parent name. | Fix: Check for typos. If using a sub-account, reformat the entry as Parent Account: Sub Account. |
| “Import Did Not Complete” / Spinning Wheel | A general failure, often due to file size, a single bad line of data, or a QBO timeout. | Fix: Break your file into smaller batches (no more than 50 entries per file). Check for invisible formatting errors in the dates or numbers. |
| “Journal Entry Unbalanced” | The total of all Debits for a single Ref Number is not equal to the total of all Credits. | Fix: Review the specific entry number flagged. In Excel, use the SUM function to verify that Debits – Credits = 0 for every unique entry. |
| “Name Missing” | You used an Accounts Receivable (A/R) or Accounts Payable (A/P) account without providing a corresponding Customer or Vendor name. | Fix: Add a Name column to your spreadsheet and populate it with the correct Customer or Vendor for every line involving an A/R or A/P account. |
Note: Before importing thousands of transactions, perform a test run using a file containing only two simple, balanced journal entries. If these imports are successful, your formatting and mapping are correct, and you can proceed with the full dataset.
Accounting Professionals, CPA, Enterprises, Owners
Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.
Frequently Asked Questions (Faqs)
How can I import journal entries into QuickBooks Online?
To import journal entries into QuickBooks Online, you can use the built-in Import Data tool in QBO’s settings, or you can also use Dancing Numbers Importer to import the data in bulk without any errors.
What file formats are supported for importing journal entries into QBO?
QuickBooks Online primarily supports CSV (Comma Separated Values) files for importing journal entries. Ensure your Excel ledger is saved and formatted correctly as a CSV before upload.
Is there a limit to the number of journal entries I can import at once?
While QBO can handle large datasets, it is best practice to split very large files into smaller, manageable batches. This ensures optimal system performance and reduces the chance of import errors.
How do I migrate journal entries when switching to a new QuickBooks company?
Export your existing journal entries from the old company as a CSV or XLS file. Then, use the Import Data tool in your new QuickBooks Online setup to bring the transactions over.
Can I import journal entries from other accounting software into QuickBooks Online?
Yes, you can import data from other software by exporting the journal entries into a supported format, such as CSV. Then, use the QBO import tool for the transfer.
What should I check before importing an Excel ledger into QuickBooks Online?
Ensure your Excel file is saved as a CSV and that you understand the import does not bring in individual transactions, only the summarized ledger data needed for the journal entries.
How can I Duplicate a Journal in QuickBooks Online and make it Recurring?
At first your need to pull up the already posted or created journal entry and click on ‘make recurring‘. After that, enter the name of the template, change the type to unscheduled, and save it.
How can I Create Recurring Journal Entries Template in QuickBooks Online?
At first click on settings > click recurring transactions from the list and select new. Now select the type of transactions that you want to create and click OK. You need to enter the template name and choose type as scheduled, unscheduled, or reminder, etc.
What are the Significant Fields in a Journal Entry?
TXN date, is Adjustment, Ref Number, is home Company Adjustment, Credit, Currency Ref, Debit, Class, Memo, Entry Ref, Billable Status and more
When to use Journal Entry in QuickBooks online?
- Sending money between expense and income accounts
- Transferring money from liability, or an asset
- When user require filling debits and credits in the ledger
How can I Create a Journal Entry in QuickBooks online?
- Click on the +New button
- Choose Journal entry
- Click an account through the Account field
- Write the amount in a suitable column
- Choose the other account you are transferring money from or to
- Verify the amounts
- Fill memo section
- Click on Save and close
