cancel
Showing results for 
Search instead for 
Did you mean: 
Intuit

Import journal entries in QuickBooks Online

Learn how to import journal entries in QuickBooks Online.

With QuickBooks Online’s import feature, you can easily import journal entries. We’ll show you how using a CSV or Excel file.

Note: Turn off account numbers before you begin importing your journal entries. This will ensure a smooth import. The account numbers can be turned back on once your import is complete.

Step 1: Prep your spreadsheet


Before you import your journal entries, make sure everything looks correct in your spreadsheet.

  1. Make sure that your file includes following information (at least):
      • Journal No

    • Journal Date
    • Journal Code
    • Account Name
      • Debits
      • Credits
      • Select date format

      If your spreadsheet has new accounts, be sure to add them in your chart of accounts before importing.

Step 2: Import your journal entries

Note: You can turn on class tracking to import journal entries with classes.

  1. Go to Settings ⚙️, then select Import Data.
  2. Select Journal Entries.
  3. On the Download page, select BrowseNote: If you need help formatting your journal entries, select Download a sample file.
  4. Find and select your CSV or Excel file. Select Open, then Next.
  5. Map your information. Your Field represents the headers on your spreadsheet. From each small arrow ▼ icon, select the one that matches a field in QuickBooks Online.
  6. Select Next. If there’s an error, edit the file and try again.
  7. Select Start import.
  8. Select Done.

Once you’re done, you can use the search function to check and edit the journal entries.

Was this helpful?

You must sign in to vote, reply, or post