How to Import Journal Entries into QuickBooks Desktop?

Journal entries record debit and credit transactions in the general ledger to maintain accurate financial records. Businesses import journal entries into QuickBooks Desktop to transfer bulk data from spreadsheets or accountant files, reduce manual entry, and maintain consistency across accounts. This process improves accuracy, saves time, and ensures that large volumes of financial data are recorded without duplication or posting errors. A structured import workflow also helps preserve links between accounts and supports reliable reporting.

Before importing, you must prepare data files, verify accounts, and back up your company file. QuickBooks supports multiple import methods, including native IIF or QBJ files and third-party tools like Dancing Numbers for Excel or CSV imports. This article explains prerequisites, supported file formats, account setup, step-by-step import journal entry methods in QuickBooks Desktop (QBDT), field mapping, customization settings, and post-import verification.

What Is a Journal Entry Import and When Do You Need It?

A journal entry import involves transferring bulk debit and credit entries from external files, such as spreadsheets or accountant records, into the QuickBooks Desktop general ledger. This process records transactions in a structured format and updates account balances without manual data entry.

You use a journal entry import in specific situations:

• Year-end adjustments: Depreciation, accruals, and other closing entries recorded in bulk
• Data migration: Moving opening balances or historical transactions from another system
• Accountant corrections: Applying adjustments received in a .QBJ file
• Bulk entries from Excel or CSV: Importing large volumes of journal data without manual entry

Each scenario benefits from a structured import process that maintains accuracy, reduces manual work, and preserves links between accounts, customers, vendors, and classes.

Before You Begin: Prerequisites and File Requirements

Before you import any journal entries, you must complete a few essential steps to protect your data and avoid errors.

• Create a backup of your company file
  QuickBooks Desktop does not offer a bulk undo for imported transactions. If an import fails or posts incorrect data, you must either delete the entries individually or restore from a clean backup. Perform a full backup before starting the import and store it in a separate location.
• Run in single‑user mode as the Admin user
  Open QuickBooks Desktop and switch to Single‑User Mode by going to File > Switch to Single‑User Mode. Log in using the Admin credentials. This prevents conflicts from other users and ensures that the import process runs without interruptions.
• Verify that all required accounts exist
  Every account you reference in your import must match a real account in your QuickBooks Chart of Accounts. If an account name in the file does not match a name in QuickBooks, the import fails for that line (in native IIF) or flags the error (in tools such as Dancing Numbers).

You update your Chart of Accounts first and then proceed with the import.

Supported File Types (CSV, XLS, XLSX)

QuickBooks Desktop supports journal entry imports through specific file formats and does not accept raw spreadsheets for this type of transaction.

• Native Supported Formats:
  
  • .IIF: Intuit Interchange Format. This is the standard format for importing journal entries, items, and other transaction‑type data.
  • .QBJ: Accountant’s Copy journal file. This format is used when an accountant sends adjustments to your company file.
• Spreadsheets (CSV, XLS, XLSX):
  QuickBooks Desktop does not import journal entries directly from CSV, XLS, or XLSX files. You must convert these files into an IIF structure or use a third‑party integration tool that maps the spreadsheet into QuickBooks‑compatible journal entries. You perform a QuickBooks Desktop import journal entries CSV workflow through such tools, not through the native Excel/CSV importer.
• Important note on the Excel/CSV Toolkit:
  The built‑in Excel/CSV Importer in QuickBooks Desktop is designed for lists (customers, vendors, items), not journal entries. You do not use this tool to perform a bulk journal entry import QuickBooks Desktop.

Setting Up Accounts in the Chart of Accounts

Every account that appears in your import file must exist in your QuickBooks Chart of Accounts with the exact name and account type required.

• Ensure that all account names, including sub‑accounts, match the names in your file exactly. A single space, extra character, or case difference can cause the import to fail or assign the entry to the wrong account.
• Verify that the account types (for example, Bank, Accounts Receivable, Accounts Payable, Expense, Revenue) align between your file and your chart of accounts.
• If you plan to use a third‑party tool that supports automatic account creation, you still define the account type and basic properties in the tool’s mapping screen. Native IIF imports do not auto‑create accounts.

If you need to add or adjust accounts, update your Chart of Accounts first and then proceed with the import.

Method 1: Import Journal Entries Using the Native QuickBooks Spreadsheet (IIF/.QBJ)

Native importing in QuickBooks Desktop relies on the Intuit Interchange Format (IIF) for bulk journal entries or the accountant’s .QBJ file for client‑reviewed adjustments. This method does not require third‑party software but demands strict formatting in the QuickBooks IIF journal entry format.

Follow these steps to import journal entries using the native IIF or QBJ workflow.

Step 1: Prepare Your Spreadsheet / IIF File

You start with a spreadsheet (Excel or CSV) and then convert it into an IIF‑compatible format.

• Use an IIF template or a conversion tool that outputs the correct .IIF structure. Many integrations and utilities provide downloadable templates or direct export‑to‑IIF functions.
• Download the IIF template kit from Intuit via Help > QuickBooks Help > search ‘IIF files’ or File > Utilities > Export IIF for examples.
• Include the required column headers in your IIF file. For journal entries, common fields are:
  • TRNSID: A unique transaction ID for each journal entry.
  • TRNSTYPE: Set to GENJRNL for general journal entries.DATE: The transaction date in MM/DD/YYYY format.
  • ACCNT: The full account name, exactly as it appears in your Chart of Accounts.
  • DEBIT: The debit amount for the line.
  • CREDIT: The credit amount for the line.
  • NAME: Customer, vendor, or job name for Accounts Receivable or Accounts Payable entries.
  • CLASS: The class name, if you use class tracking.
  • MEMO: A brief description of the line item.

For multi‑line journal entries, assign the same TRNSID or journal number to all lines that belong to the same transaction. Total debits must equal total credits for each transaction ID. An unbalanced transaction generates validation errors and fails the import.

• Save the file in .IIF format with UTF‑8 encoding and ensure there are no empty required columns or special characters that IIF does not recognize.
• Test the process on a small subset of entries first before full import.

Step 2: Begin the Import Process

After preparing the IIF file, you import it into QuickBooks Desktop.

• Open QuickBooks Desktop and log in as the Admin user in Single‑User Mode.
• Go to File > Utilities > Import > IIF Files.
• Browse to the location of your .IIF file and select it.
• Click Open to start the import.

QuickBooks processes the file and displays a confirmation message after the import completes. If the file contains errors, QuickBooks lists the issues and stops at the first major format problem. You correct the file and run the import again.

For accountant-provided .QBJ files, go to File > Utilities > Import > General Journal Entries, select the file, and follow the on-screen prompts to apply the adjustments. In QuickBooks Desktop for Mac, use File > Import > General Journal Entries.

Because this method is sensitive to formatting, you test the process on a small subset of entries first, verify the results, and then run the full import.

Method 2: Import Journal Entries Using Dancing Numbers

Dancing Numbers simplifies journal entry imports by allowing direct Excel or CSV files without manual IIF formatting. The tool maps your spreadsheet columns to QuickBooks fields and validates the data before posting a bulk journal entry import QuickBooks Desktop.

Follow these steps to import journal entries using Dancing Numbers.

Step 1: Select Your File

• Install and launch the Dancing Numbers application on the same computer system as QuickBooks Desktop.
• Connect the application to your QuickBooks company file by selecting the file and authenticating as the Admin user.
• Choose Import from the main menu.
• Navigate to the folder that contains your Excel or CSV file, then select it.
• Confirm the file type and encoding, then click Next or Continue to move to the mapping screen.

The tool reads the headers and sample rows to display a preview of your data. You use this screen to prepare your QuickBooks Desktop import journal entries CSV or Excel workflow.

Step 2: Map Your Fields to QuickBooks

The mapping screen aligns your spreadsheet columns with QuickBooks journal fields.

• Match your Account column in the spreadsheet to the Account field in QuickBooks.
• Map the Debit and Credit columns to the corresponding Debit and Credit fields.
• If your file includes Journal No., map it to the Journal Number field to preserve numbering.
• Map Date to the Date field, ensuring the tool’s date‑format setting matches MM/DD/YYYY or your chosen format.
• If you use Class tracking, map the appropriate column to the Class field.
• If your entries relate to specific customers or vendors (Accounts Receivable or Accounts Payable), map the Name column to the Name field.

Dancing Numbers typically flags unmapped or unrecognized columns and allows you to skip or assign them. You also define how the tool handles missing accounts (either by skipping the line or creating a new account if supported by your license). This improves accuracy and reduces the chance of posting entries to incorrect accounts.

Step 3: Review and Import

Before posting, you review the data and tool settings.

• Examine the data preview to confirm that debits and credits balance for each transaction, and that account names match your Chart of Accounts.
• Check the import summary, including the number of rows, journal entries, and potential errors.
• Click Import to start the transfer. The tool validates each line, posts it to QuickBooks, and generates a log of successful entries and any rejected lines.

You verify the results in QuickBooks using the Journal report and the Trial Balance. If you require live support or a trial, you can access the Dancing Numbers free trial.

Mapping QuickBooks Fields for Journal Entry Imports

Accurate field mapping is essential for a successful import. Use the following table to align your source data with QuickBooks Desktop journal fields.

Field Reference Table (Field Name, Format, Character Limits)

Field Name	Required?	Format/Example	Character Limit	Description/Notes
Journal No.	Yes	Numeric or alphanumeric	7 characters	Identifies the transaction; use the same number for all lines in one entry.
Date	Yes	MM/DD/YYYY (e.g., 03/15/2026)	10 characters	The effective date of the transaction.
Account	Yes	Full account name from Chart of Accounts	150 characters	Must match the exact account name in QuickBooks.
Debit	Conditional	100.00, 1,500.75	15 characters	Debit amount; required if the Credit field is blank for that line. Amounts entered as positive values (QuickBooks handles debit/credit logic based on account type).
Credit	Conditional	100.00, 1,500.75	15 characters	Credit amount required if the Debit field is blank for that line. Amounts entered as positive values (QuickBooks handles debit/credit logic based on account type).
Ref Number	No	Numeric/Alphanumeric	11 characters	Alternate transaction reference.
Memo	No	“Adjustment for office supplies”	100 characters	A brief description for the line item.
Entry Ref	No	Text	209 characters	Additional entry description.
Name	No	Customer or vendor name	41 characters	Required for Accounts Receivable or Accounts Payable entries.
Class	No	Class name (if used)	100 characters	Used for segment, department, or location tracking.

For multi‑line journal entries, ensure that all lines belonging to the same transaction use the same Journal No. and that the sum of debits equals the sum of credits for that number. Mismatched totals cause the entry to fail or be rejected during validation.

Import Settings and Customization

Customizing import settings helps maintain accuracy and reduces manual adjustments after posting.

Journal Number Handling and Lookup Strategies

You choose how journal numbers behave during the import of journal entries into QuickBooks Desktop.

• Preserve existing numbers from your file. QuickBooks Desktop accepts the journal numbers as long as they are unique and do not conflict with existing entries.
• Allow the import method or tool to generate new journal numbers automatically. This option avoids conflicts when the source numbers overlap with QuickBooks‑generated numbers.

You check your preferences with your accountant or internal policy before importing large sets of historical entries.

Date Format Settings

QuickBooks Desktop typically expects dates in the MM/DD/YYYY format, but the user‑interface setting must match the format in your source file.

• In your spreadsheet, ensure that all dates follow the same format and do not mix US, European, or ISO styles.
• If you use a third‑party tool, confirm that the date‑format setting (for example, MM/DD/YYYY vs DD/MM/YYYY) matches your file. A mismatch can post entries in the wrong fiscal period and affect account reconciliation and trial balance validation.

Handling Missing Accounts and Auto‑Creation Options

Native IIF imports do not automatically create accounts. If an account in your file does not exist in QuickBooks, the import either skips that line or fails the entire transaction, depending on the validation settings.

Some third‑party tools support automatic account creation during import. When enabled, the tool:

• Checks for the account name in the Chart of Accounts.
• If the account does not exist, it creates a new account using the account type and basic details from your file.
• Post the journal line to the newly created account.

If you enable auto‑creation, you review the new accounts afterwards to confirm they match your chart‑of‑accounts structure and naming standards. This step supports accurate account reconciliation and trial balance validation.

After the Import: Verifying Your Journal Entries in QuickBooks

After importing, you verify that the entries posted correctly and that your books remain balanced.

• Open Reports in QuickBooks Desktop.
• Go to Accountant & Taxes and select Journal.
• Apply a date filter to show entries from the import period.
• Scan the list to confirm that each multi‑line entry appears as a single journal number with matching total debits and total credits.
• Run a Trial Balance report for the same period and compare the totals to your original spreadsheet.
• Use the Audit Log report to track who created the entries and when, if your file is set up to track changes.

If you detect errors, you correct them manually by editing or deleting individual entries. If the errors are widespread or critical, restore the company file from the backup you created before the import, then repeat the process with corrected data. This approach preserves accuracy and supports account reconciliation.

---

Frequently Asked Questions