cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
gracewang
Level 1

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

 
16 Comments 16
AlexV
QuickBooks Team

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!

Fiat Lux - ASIA
Level 15

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

@Nnelsondaniel1  @gracewang 

Do you need to import Receive Payment data or else?

RefNumberTxnDatePaymentRefNumberCustomerPaymentMethodDepositToAccountInvoiceApplyToLineAmountPrivateNoteCurrencyExchangeRate
128/11/202050245Janice JohnsonCheckChecking101100.00   
228/11/20204908Leonard Walker IncCheckChecking102138.78   
328/11/20204908Lisa SmithCheckChecking103126.50   
gracewang
Level 1

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

Yes, I need to import the payments customer made. The payments should post into to each customer's account. Is there a way to import the xls file?

SashaMC
Moderator

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

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!

 

 

Fiat Lux - ASIA
Level 15

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

...

jackie_therainmakerinstitute
Level 1

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

Where do you go in QBO to import this file?  If I go to Import Data, it only gives me the option to import lists, invoices, etc.  No place there to import payments that I can tell.

Tori B
QuickBooks Team

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

Hey there, @jackie_therainmakerinstitute.

 

Thanks for following the thread and sharing your concerns. 

 

When using a third-party importer tool as mentioned above, you'll need to discuss the details of importing with that third party. The third-party tool that you use would have the information about the tool and how it works, I recommend contacting them to gain some insight. 

 

In the meantime, please let me know if you have any other questions or concerns. I'm happy to lend a hand. As always, feel free to reach out to the Community any time you need assistance. Have a great day! 

Fiat Lux - ASIA
Level 15

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

@jackie_therainmakerinstitute 

Prepare the Receive Payments data with the following template

RefNumberTxnDatePaymentRefNumberCustomerPaymentMethodDepositToAccountInvoiceApplyToLineAmountPrivateNoteCurrencyExchangeRate
128/11/202050245Janice JohnsonCheckChecking101100.00   
228/11/20204908Leonard Walker IncCheckChecking102138.78   
328/11/20204908Lisa SmithCheckChecking103126.50   

 

then utilize the importer tool as I mentioned eaarlier.

DanGot
Level 1

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

Hi-

I tried importing transactions into QB Online using the template you suggested but the import did not associate the transaction with the customer. is there a way to correct this so that when I import transactions the transaction is associated with the customer?

  Thank you,

      Dan

Fiat Lux - ASIA
Level 15

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

@DanGot 

Did you use the importer tool as I mentioned earlier?

https://transactionpro.grsm.io/qbo

 

juma1
Level 2

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

I have the same problem. Do I need to use an importer tool like trasnaction pro to upload customer payments and apply to customer account?  Or is there any way I can upload in to QBO myself without use of importer tool? I don't want to pay extra fees to 3rd parties to accomplish this task.

ReymondO
Moderator

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

Thanks for joining the thread, @juma1.

 

Let me join in this conversation and share with you additional info about importing customer payments in QuickBooks. 

 

If you're trying to import data in XLS format, you have to use convert it to CSV, QFX, QBO, OFX file formats first. You can do this using a file format converter tool which you can find outside QuickBooks. 

 

You can also search for free file converters on web browsers. This way, you don't have to pay for another app and accomplish your task.

 

Once done, here's how to import bank transactions into QuickBooks Online. 

 

Let me know if you need any additional assistance or clarification. We are here to lend a helping hand always. Have a good one. 

jsorrells
Level 1

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

Why is no one answering the actual question? This should be simple to do. Assume the file type is correct. Assume the user does not want to use a third-party tool. Given those assumptions, how are payments imported and associated to the customer

AlverMarkT
QuickBooks Team

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

I'll hear you out, @jsorrells.  I can see you want to import your customer payments into QuickBooks Online (QBO) using an XLS file, and I understand the need for a seamless process without relying on third-party tools. We can still ensure this gets done effectively, and I want to provide an alternative way to handle it.

 

If the customer payments are automatically reflected in your bank feeds or have the option to import them manually, they can be an efficient option. You can review and match transactions directly to the open invoices, and QBO will create the corresponding payment transactions. You can follow these steps:

 

  1. Go to the Bank transactions page in your QBO account. 
  2. Pick the Blue tile for your bank account where the customer payment/s are deposited.
  3. Select the money-in transaction for the customer payment/s. 
  4. Click on the Match radio button. Then, choose Find other matches to match it to multiple invoices.
  5. Hit Match.

 

If the transactions aren't pulled up directly to your bank feeds, manually upload them into QBO. For a detailed guide, refer to this article: Manually upload transactions into QuickBooks Online.

 

Once done, pull up the Invoice and Received Payments report and compare it side-by-side with the data in your XLS file to ensure the payment details are accurate. You can follow these steps:

 

  1. Go to Reports
  2. Enter Invoice and Received Payments and select the report. 
  3. Click on the payment transaction that you want to modify. 
  4. Review the Payment Date, Payment method, and other details.
  5. Choose Save and close when done.

 

The software should be able to meet various business needs, particularly by allowing the import of invoice payment transactions directly into QBO. I encourage sending your feedback to our Product Engineers so they can consider adding this feature in the future.

 

  1. Select the Gear icon.
  2. Choose Feedback.
  3. Enter your comments and suggestions.

 

When this is resolved and you need to reconcile your accounts, refer to this article as a guide: Reconcile an account in QuickBooks Online.

 

I hope these steps help you get your customer payments correctly recorded in QBO while the option of direct import without the use of external tools isn't available yet, @jsorrells. If you need further assistance or anything else comes up, feel free to click on the Reply button. We're committed to offering ongoing support.

treas1
Level 2

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

Importing a bank transaction list does not solve my issue.  My bank has combined 10 customer payments as one deposit transaction.  I then enter each customer payment separately and combine them into one bank deposit that is matched with the bank transaction.  Instead of the manual work is there a way to import the list of 10 customer payments?

Tori B
QuickBooks Team

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

Thanks for checking back with us, @treas1

 

Since your bank is sending the transactions as a group deposit, the best method to enter them into QuickBooks would be to do it manually as you are. 

 

Another solution would be to contact your bank, request a file where the transactions are separated, and import that file into QuickBooks. 

 

For more information about manual bank imports, check out Manually Upload Bank Transactions in QuickBooks Online

 

Please don't hesitate to let me know if there is anything else I can assist you with. I'm happy to help. Have a good one! 

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up