How to import customer's payments xls file into QBO?

Hello there, gracewang.

Welcome to QuickBooks Community!

One of the best features of QuickBooks Online is that we can import data or files. However, please note that we only support CSV, QFX, QBO, OFX file formats. You'll want to convert your XLS to any of our supported file formats.

Then, here's how to import bank transactions. 

Post again here if you have more questions related to this. Have a great day!

Thank you for connecting once again with the Community, gracewang. Currently, we do not support XLS files, but there are a few options to import customer's payments.

First, you could convert your XLS file and then import it as my colleague mentioned.

Second, use a third party importer tool that supports XLS, such as Transaction Pro Importer. Also, this link provides more resources to find applications available to do this.

Let me know if you need any additional assistance or clarification. We are here to lend a helping hand always. Take care and keep me updated. Enjoy your weekend!