LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Wajid1
Level 1

Data Import in Quickbooks online

Hi All, 

Hope you are well.

We have a new business and from the past several months, i am doing accounting in Excel. i have maintained a list of all accounting entries in excel. But now i have started using Quickbooks online, and i have already created my own chart of accounts in QK, The problem is how do i import all of my accounting entries in QB?

2 Comments 2
MarkAngeloG
QuickBooks Team

Data Import in Quickbooks online

Hi there, @Wajid1.

 

Not a problem anymore, I'm here to help you import your accounting entries in QuickBooks Online.

 

First, let's prepare your accounting entries file. Ensure that the file is formatted correctly for import. If everything is aligned correctly, let's proceed with importing them to your QBO account. Here's how:

 

  1. Go to the Gear icon and select Import Data.
  2. Choose the type of data you want to import (e.g., Bank Data, Invoices, Journal Entries).
  3. Upload your prepared file for the data type you're importing and assign them to the account you recently created.
  4. Map the columns from your file to QBO fields. You'll see a preview for verification.
  5. Review the transactions and ensure their amounts are correct, then click Import.

 

Our QuickBooks Live Expert Assisted team can help you seamlessly import your accounting entries from Excel into QuickBooks Online, ensuring accuracy and saving you valuable time.

 

You can also categorize your transactions to assign them to the appropriate accounts. This practice is highly effective for accurate tax tracking and compliance.

 

If you need guidance with categorizing your transactions in QBO or have other questions, please don’t hesitate to reply. I’m here to provide support and make sure everything runs smoothly for you.

Chrea
Level 8

Data Import in Quickbooks online

@Wajid1 

Another option, you can purchase a 3rd party conversion service.

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

Need to get in touch?

Contact us