Hi, Gloria39. Welcome to the QuickBooks Community.
Before importing your journal entries, ensure everything is correct in your spreadsheet. I’ll explain more below.
Before you start, turn off account numbers to help your import go smoothly. You can turn them back on after you finish. Make sure each journal entry line uses a parent account. If you use subaccounts, you might get a Line Account Invalid error, which means QuickBooks may not find an exact match for the account names in your spreadsheet.
Here’s how:
- Go to Settings and select Account and Settings.
- Navigate to the Advanced tab.
- Click the Pencil icon to edit in the Chart of Accounts section.
- Turn off Enable account numbers.

- Hit Save and then Done.
Another one is to ensure that your file includes the following information.
- Journal No.
- Journal Date
- Account Name
- Journal/Description
- Debits
- Credits
Also, special characters like commas, periods, or other symbols in the account name must match exactly.
If your spreadsheet includes any new accounts, add them to your chart of accounts before you import.
Here’s what to do:
- Open your QuickBooks.
- Go to Transactions, then Chart of Accounts.
- Select New Account.

- Enter the details needed.
- Once done, click Save.
I also added this helpful article to learn more about what to do before importing your journal entries and provided guided steps to accurately import your JE: Import journal entries in QuickBooks Online.
Let us know in the comments below if you have any other questions about QuickBooks.