Skip to main content
H
Haley-Coles
May 8, 2025
Question

How do I upload all of my client's data from Wave (in one file) into QBO? Which upload type do I choose on the "Import Data" page?

  • May 8, 2025
  • 2 replies
  • 0 views

Wave gave me all of the client's transaction data in one single file.

2 replies

S
SIAB
May 8, 2025

What file format? What transaction type? 

G
GenmarieM
May 8, 2025

It's great having you here in the Community, Haley. Let me help you choose which record type to use when importing your client's transaction data from Wave.

 

If you have all your client's transaction data from Wave in a single file, first ensure it is downloaded as a CSV file. Then, in QuickBooks Online (QBO), navigate to the Import Data page via the Gear icon to begin the upload process. If the file contains banking transactions, select Bank Data or Journal Entries.

 

However, if your file contains multiple types of data-such as customers, vendors, bills, and transactions, it is necessary to import each category separately. In that case, make sure each CSV file corresponds to the appropriate category in QBO, such as Customers, Vendors, Bills, or Chart of Accounts, to ensure accurate and organized data integration.

 

For detailed information about importing data to QuickBooks Online, you can visit this article: Importing data to QuickBooks Online.

 

Additionally, I've added this article as your reference in reviewing your imported bank transactions or running a report to check your other transaction types in QuickBooks Online:

 

 

Lastly, you can utilize our QuickBooks Live Expert Assisted to help you streamline various tasks in QuickBooks.

 

For further questions about importing data to QuickBooks Online, don't hesitate to hit the Reply button. We're always here to lend a hand.

H
Haley-ColesAuthor
May 8, 2025

Thanks @GenmarieM. The problem is that I am also trying to import expenses that already have expense accounts associated with them, to recognize bills that have been paid, sales, etc. It doesn't seem that there is any good option to choose from the dropdown to account for all of the different types of transactions. It seems that if I import it as bank data I'm going to lose all of the categorizing. Got any suggestions?

MariaSoledadG
MariaSoledadG
May 9, 2025

Although importing expenses with pre-assigned expense accounts directly into QuickBooks Online (QBO) isn't available right now, don't worry. There are several effective alternatives to get your transactions into QuickBooks Online (QBO), Haley.

 

You can utilize a third-party application to import your expense transactions. Here's how you can do it:

 

  1. Sign into your QBO account.
  2. Go to the Apps tab, and search for an application.
  3. Click Get app now.

     

Another great option is to use the Spreadsheet Sync feature to transfer data between our spreadsheets and QuickBooks Online. Please note that this capability is exclusively available in the Advanced version. To give you more details, check out this article: Get Started with Spreadsheet Sync for QuickBooks Online Advanced or Accountant.

 

If you prefer not to use either of the (2) two options, you can still import your information as a bank data. However, it is important to note that you will lose the categorization, and you will need to manually re-categorize the transactions after the import.

 

Additionally, you will need to compare transactions in QuickBooks with those recorded in your bank statement to ensure accuracy. For guidance on how to reconcile transactions, please refer to this article:: Reconcile An Account in QuickBooks Online.

 

If you are looking for more advanced features and capabilities to meet complex operational need, consider upgrading to QuickBooks Online Advanced.

 

If you have any other concerns while importing data, you can always reply below. I'm always here ready to assist you further. 

Terms & ConditionsAccessibility statement