cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
richelle-gasking
Level 1

Can you import Journal entries with sub accounts in QBO

We keep getting an error when trying to do this so just wondering if it is even possible seems weird that it wouldn't be?
8 Comments 8
4Gal
Level 11

Can you import Journal entries with sub accounts in QBO

Try using the importer tool

https://get.transactionpro.com/qbo

 

MJ_R
QuickBooks Team

Can you import Journal entries with sub accounts in 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!

lthorkelson
Level 1

Can you import Journal entries with sub accounts in QBO

I am having the same issue when trying to import our Payroll Journal Entry into QuickBooks. Only the subaccounts are failing, receiving the error: Line Account Invalid. (These Line Accounts don't exist in QuickBooks.)

 

I have followed your guidance in your original reply to add the parent account separated by a colon (ex. 6000 R&D: 6010 Wages), but I am still receiving the error. 

 

Any guidance on the formatting of subaccounts to have the import be successful?

JamesM4
QuickBooks Team

Can you import Journal entries with sub accounts in QBO

Thanks for elaborating. At this point, I recommend getting in touch with our phone support team so they can share your screen and help get to the bottom of this ASAP . You can reach out by dialing 1-855-253-1536 from Monday to Friday between the hours of 9 AM and 8 PM EST. Feel free to keep me posted on how you make out.

eloisa_
Level 1

Can you import Journal entries with sub accounts in QBO

Same problem with me. I'm located in the Philippines so I can't call your phone support team. Do you have any skype or MS Teams? Thank you

Trish_T
QuickBooks Team

Can you import Journal entries with sub accounts in QBO

Hi eloisa_,

 

Thanks for joining us here.  I recommend contacting the QuickBooks Online Customer Care team at the number provided by JamesM4, in the post above.  With your consent, they can connect with you virtually, and ensure you're able to accomplish your QuickBooks goals as soon as possible!

 

If you have any other questions, please don't hesitate to reach back out.  We would be glad to assist!

WD_IGetItDotHealth
Level 1

Can you import Journal entries with sub accounts in QBO

Just figured this out.  When importing journal entries with sub-accounts, (1) account numbers need to be temporarily turned off, and (2) a colon is placed in between the main acct and the sub account names WITHOUT a space.  example ... Account Name:Sub Account Name

 

Note that account numbers don't seem to need to be turned off when only uploading to main accounts.  The combination of the numbers and the colon is the challenge.  Once the syntax was like this, all my files loaded up without a hitch.  

Alex M
QuickBooks Team

Can you import Journal entries with sub accounts in QBO

Hi there WD_IGetItDotHealth,

 

I'm happy to hear that you found the most effective way to set up your journal entry for success importing, and were willing to share this solution with the Community.

 

If you have any other questions, or need assistance with other matters in QuickBooks Online, please don't hesitate to reach out in the Community.

Need to get in touch?

Contact us