Import receive payments

We're glad to have you here in the Community, nealeb.

You can convert the Excel file into a CSV format. Then, import it into QBO. I'd be glad to share all the steps with you.

Firs, follow the steps in these Microsoft articles on how to convert the Excel file to CSV:

• Import or Export Text (.txt or .csv) Files
• Save a Workbook in Another File Format

Second, follow the format in this article so you can import it: Format CSV Files in Excel to Get Bank Transactions Into QuickBooks.

Third, use these steps to move the transactions to your account:

1. Go to the Bookkeeping menu, then proceed to the Bank transactions tab.
2. Click Upload transactions.
3. Select Drag and drop or select files. Then, look for the CSV file.
4. Click Continue and select the account you want to upload the transactions into. 
5. Choose Continue again to proceed. 
6. Follow the succeeding steps on how to map the data to complete the import process. 

Let me also give you this article that provides more information about this process: Manually Upload Transactions into QuickBooks Online.

After that, you can now categorise the transactions or match them to the invoices in QBO. Let me share these articles for additional guidance:

• Categorise and Match Online Bank Transactions in QuickBooks Online
• Fix Bank Upload Errors in QuickBooks Online

Don't hesitate to always reach out to us again if you need anything else. The entire QuickBooks Team is more than happy to help you again.