Uploading csv to categorize revenue

I have all the information you need to upload a CSV file successfully in QuickBooks Online, lumming.

You can either use the 3-column or 4-column format in uploading a CSV file. Check out this link: Format CSV files in Excel to get bank transactions into QuickBooks.

Once your CSV file is ready, these are the steps you can take to import them:

1. In QuickBooks Online, go to the Transactions tab.
2. Select the blue tile for the account you want to upload the transactions into.
3. Select the Link account ▼ dropdown and then Upload from file.
4. Click Drag and drop or select files and choose the file you downloaded from your bank. Then select Continue.
5. In the QuickBooks account ▼ dropdown, select the account you want to upload the transactions into. Then select Continue.
6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Continue.
7. Select the transactions you would like to import. Then select Continue.
8. Select Yes.
9. When you accept your transactions, select Done.

Afterward, you can start categorizing and matching them to ensure they are posted to the correct accounts.

Moreover, you can browse this link for tips and detailed instructions on how to keep your accounts balanced and in order: Reconcile an account in QuickBooks Online. 

If you require further assistance uploading transactions or related matters, reply to this thread. I am here to support you at any time.

@lumming 

You need to prepare data as Invoice + Receive Payment or only Sales Receipt (if you didn't  use Invoice) then use an importer tool proceed. Which one do you prefer to use?

Thanks so much. What would the csv file look like in both scenarios? I'm not sure which is best. 

Also what do you mean by importer tool? 

Thanks! 

Did you use Invoice or not?

Sometimes yes and sometimes no.