Can you import Journal entries with sub accounts in QBO

Try using the importer tool

https://get.transactionpro.com/qbo

Hi richelle-gasking,

Thanks for reaching out in the QuickBooks Community. QuickBooks is a versatile program that enables you to get your work done faster. I'd be happy to provide some more information on importing journal entries with sub-accounts.

Here are the steps you should take to import those journal entries:

Step 1: Prepare Your Spreadsheet before you import your journal entries, make sure everything looks correct in your spreadsheet. Your file should include the following information at least:

• Journal Number
• Journal Date
• Account Name
• Journal Debits and Credits

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

Step 2: Import Your Journal Entries

1. Go to Settings, then select Import Data.
2. Select Journal Entries.
3. On the Download page, select Browse.
4. Find and select your CSV or Excel file.
5. Select Open, then Next.
6. 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.
7. Select Next.
8. If there’s an error, edit the file and try again.
9. Select Start import.
10. Select Done.

Please note that you should 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.

For sub-accounts, you can specify them in your spreadsheet by using a colon (:) to separate the parent account and the sub-account.

The information provided by @4Gal also includes some the information that could successfully import your journal entries seamlessly. Here is an link to our Apps to help with the import.

As an example, you can download a sample file from QuickBooks Online to get a full view of the required elements for a smooth import.  Here's how:

1. Open your Settings and select Import Data

2. Click on the Journal Entries tile

3. Hit the link to Download an example

Note;  Ensure there are no empty columns, or blank lines on your spreadsheet.

4. Prepare your spreadsheet and save it where it's easy to locate

5. Proceed with the import process.

Please don't hesitate to reach back out with other questions.  We are always happy to help!

Still having the same problem in Feb 2025. QB did not learn anything. QB does not change anything to make its UX any better.