Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore QuickBooks Payroll
Omer_S
Level 1

Journal entry upload

If the answer to above is yes, can we upload one excel based journal / template for multiple entities?

1. Can we upload excel based journals to QB. If yes, what is the process

2. If the answer to above is yes, can we upload one excel based journal / template for multiple entities?

 

Thanks in advance.

4 Comments 4
SashaMC
Moderator

Journal entry upload

Welcome to the QuickBooks Community, Omer_S!  Yes, you can upload a journal entry. However, you would have to use a CVS file. I am adding some steps if you are interested.

 

Do note that you need to turn off account numbers before you begin. The account numbers can be turned back on once your import is complete. Journal Entry Line items must be a parent account, entries for sub accounts will need to include the parent account name and the sub account name separated by a colon. 

 

For example, "Parent account: Sub Account". Only entering the sub account name will cause a "Line Account Invalid" error.

 

Before you import your journal entries, please make sure that everything appears correct in your spreadsheet.

 

  1. Make sure that your file includes the following info. Depending on Account Name selection (Accounts Payable or Accounts Receivable), the system will request the Name column to have a vendor selected.
    • Journal No.
    • Journal Date
    • Account Name
    • Journal/Description
    • Debits
    • Credits
  2. If your spreadsheet has new accounts, be sure to add them to your chart of accounts before importing.
  3. If you turned on Warn if duplicate journal number is used on the Journal Entry form, you won’t be able to upload some entries with existing numbers. You may have to uncheck that preference on the journal entry before you import.

 

From there, you can import your journal entries by following the steps in this article: 

 

And yes, you can do multiple as well to answer your second question. If you have any other questions or concerns, let me know. My team and I are here to help. 

 

mbengford1
Level 1

Journal entry upload

I've followed the steps. I keep getting an error that states:

Line Account invalid

  • NWB Cap Loan Harlan Interest

I'm coping and pasting the COA name exactly so I don't understand. Is it the name of the account that is catching it? If it is then why the heck why?

mbengford1
Level 1

Journal entry upload

Doesn't work if you make an account a sub under a main. That's annoying. 

Ex: Interest paid-Washington interest 

 

MorganB
Content Leader

Journal entry upload

Thanks for joining this thread, mbengford1.

 

I'm here to provide some additional info so you're able to upload your journal entries in QuickBooks Online.

 

To fix the "Line Account invalid" error in QuickBooks Online when uploading journal entries, you must ensure sub-accounts in your CSV file are formatted as "Parent Account:Sub Account". Try the upload with the colon, rather than a hyphen, and no spaces around the colon. The article mentioned above (Import journal entries) offers even more details about this process.

 

If the issue persists, I recommend clearing your cache to start fresh and rule out any browser related issues. Please feel free to drop a comment below if you have any other questions. The Community always has your back!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us