cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
aghiadb-hotmail-
New Member

can We import a set of invoices, purchases, payments, purchase returns, sales returns, expenses, and entries from Excel to QuickBooks in an easy and secure manner?

 
2 Comments 2
Aldren18
QuickBooks Team

can We import a set of invoices, purchases, payments, purchase returns, sales returns, expenses, and entries from Excel to QuickBooks in an easy and secure manner?

Yes, you can import certain types of data from Excel to QuickBooks Online easily and securely. However, it's important to note that there are some limitations, particularly for certain transaction types. Let me break it down for you:

 

QuickBooks Online allows you to import the following data:|

 

• Bank data

• Customers

• Vendors

• Chart of Accounts

• Products and Services

• Invoices

• Journal Entries

 

Importing purchases, payments, purchase returns, sales returns, and expenses is not available in QBO. For these transactions, I recommend manually entering them directly in QuickBooks Online. This ensures accuracy and proper categorization.

 

You may want to consider using a certified third-party importer tool. These often offer more advanced importing capabilities, but make sure to choose a reputable option that's compatible with your QBO version.

 

Furthermore, I'll share these articles that will help you learn more about managing invoices and bills in QBO:

 

 

Drop your questions below if you have other concerns about importing transactions in QBO. If you require assistance with your other entries or any QuickBooks-related concerns, feel free to reach out, and I'll be glad to help.

4Gal
Level 11

can We import a set of invoices, purchases, payments, purchase returns, sales returns, expenses, and entries from Excel to QuickBooks in an easy and secure manner?

@aghiadb-hotmail- 

You can use an importer tool

https://get.transactionpro.com/qbo