Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
Showing results for 
Search instead for 
Did you mean: 
Level 2

Import Customers for Recurring payment set up

I have a client that just transitioned to Quickbooks and would like to set up most of their clients for recurring payments. Is there a way to import the client list into recurring payments or does that have to be done manually one at a time? They have approx. 1800 clients. 


Import Customers for Recurring payment set up



There might be an app that you can use with QuickBooks but I'm not sure.  Once you have your customers imported into QB (manual entry or from an Excel spreadsheet) you have to create a separate recurring sales receipt for each customer.

Level 2

Import Customers for Recurring payment set up

Thank you, there is not automatic or import solution for this? This will take me hours to complete. 


Import Customers for Recurring payment set up

Thanks for your quick response, Fullcircleacctg3922.


Let me add some details about importing customers for recurring payments in Merchant Services.


While we don't have an option to import customer list directly into Merchant Services, you'll want to import the customer data into QuickBooks Online (QBO) using an Excel spreadsheet. Once done, manually create the recurring sales receipts for each customer.


Next, link your Merchant Service account to a QBO company.


Here's how:


To import customer data:

  1. Click the Gear icon, and select Import Data.
  2. Choose Customers (see the first screenshot below).
  3. Select the Browse button.
  4. Find and select the Excel file, click Open then select Next to continue.
  5. Map your data then select Next.
  6. Adjust your data if necessary then select Import.



To create a recurring sales receipt:

  1. Click the Gear icon at the top.
  2. Select Recurring Transactions, and click the New button.
  3. Choose the Sales Receipt under Transaction Type, and click OK.
  4. Enter the template name, and choose a customer.
  5. Enter the needed information, and click the Save template button (see the second screenshot).



To link your Merchant Service account to a QBO company:


  1. Sign in to your QuickBooks Online account.
  2. Select the Gear icon, then Account and Settings.
  3. Choose Payments, then Connect.
  4. Select Next to proceed.
  5. When the account has been successfully linked, you'll receive a confirmation page.
  6. Select Done.
  7. To confirm the account is linked go to Account and Settings, then Payments (see the third screenshot).



Once done, your customers and recurring sales receipt templates will be automatically imported into your Merchant account.


Since we don't have an automatic option for this, you can try searching for a third-party application that may help you set this up. Just click Apps on the left menu, and search for a relevant app.


That's it. Keep in touch with me if you still need more help with this. I'll be here. Have a good day.


Import Customers for Recurring payment set up



In answer to your question about setting up the recurring sales receipts, no there is no "batch" or "import" or "group" way to create the recurring transactions.  You would have to create an individual recurring transaction template for each customer.

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

Need to get in touch?

Contact us