Skip to main content
dipti
May 26, 2020
Question

How to copy journal entry from excel to quickbook in one shot, if it is there in excel in the same format?

  • May 26, 2020
  • 3 replies
  • 0 views
Original commenter did not share additional details

3 replies

Rea_M
May 26, 2020

Hello there, @dipti.

 

I'm here to ensure you're able to copy your journal entry from an excel file to QuickBooks Online (QBO). This way, you can update your accounts and monitor your transactions.

 

With QBO’s import feature, you can easily transfer/copy your accounting data. Just make sure to fill in the required columns such as Date, Account number, Journal code, Debit, and Credit to successfully execute the process. 

 

Please note that in case your spreadsheet has new accounts, you need to add them to your chart of accounts first before importing.

 

Once everything is all set, you can now start importing your excel file to QBO. Here's how:

  1. Go to the Gear icon.
  2. Select Import Data.
  3. Choose Journal Entries.
  4. On the Download page, select Browse.
  5. Note: If you need help formatting your journal entries, select Download a sample file.
  6. Find and select your CSV or Excel file. Select Open, then Next.
  7. 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.
  8. Select Next.
  9. Click Start import. If there’s an error, select Download and correct. Then, edit the file and try again.
  10. Select Done.

 

After that, you can pull up a report to check the complete list of your imported transactions. The system will let you view and print single or multiple journal entries on one report. For the step-by-step guide, kindly refer to this article: Journal entry report.

 

Please let me know if you have other concerns. I'm just around to help.

peterjang
February 23, 2022

I can not find the journal entry icon in the import data.

 

LieraMarie_A
LieraMarie_A
February 23, 2022

Hi there, @peterjang. I'll make sure you can import your journal entries right away.

 

Missing buttons or icons are usually the result of too much historical data stored in your browser. We can perform basic troubleshooting to resolve it. First, let's try accessing your account through an incognito window to rule out the possibility of a webpage issue. You can refer to these shortcut keys to open an incognito window in all supported browsers:

  • Chrome: Ctrl+Shift+N
  • Firefox: Ctrl+Shift+P
  • Safari: Command+Shift+N

 

If everything is fine, clear your browser's cache. This way, you can access QuickBooks with a clean slate. You can also switch to a different supported browser to see if it has something to do with it.

 

Additionally, before you import your journal entries, make sure that your file includes the following information:

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

 

Furthermore, if your spreadsheet has new accounts, be sure to add them to your Chart of Accounts before importing. You can also check out this article for more info: Common questions about importing data.

 

If the Journal Entry option is still missing, I'd suggest reaching out to our Customer Care Team support. They can perform further troubleshooting and raise a ticket to our engineering team if necessary.

 

You can swing by anytime you need more help with importing your data into QuickBooks Online. I'd be glad to assist.

Terms & ConditionsAccessibility statement