QuickBooks HelpQuickBooksHelpIntuit

Create and manage recurring transactions in QuickBooks

by Intuit30 Updated about 5 hours ago

Learn how to create, edit, and manage recurring transactions. This article covers how to create templates, schedule recurring transactions, automate credit card payments with sales receipts, and troubleshoot common issues. You can also create recurring transactions from existing ones, duplicate and edit templates, and delete them when necessary.

🛈 This article is for customers who use QuickBooks Online (Simple Start, Essentials and Plus).

Note: You can automate credit card payments with a recurring sales receipt.

Scheduled: Use this type for transactions with a fixed schedule and amounts that don't change, such as rent payments or loan payments. Invoices created using scheduled templates are finalised when created.

Reminder: Use this type for transactions with a fixed schedule that needs to be edited before being created, such as utility bills. Invoices created using reminder templates are saved as drafts and need to be finalised before being sent.

Unscheduled: Use this type for transactions with a lot of detail that aren't needed on any set schedule, such as complicated invoices that go to different customers. Unscheduled invoices are saved as drafts and need to be finalised before being sent.

Recurring transactions automate repetitive tasks like invoicing or expense recording. Here's how to create a new recurring template:

  1. Go to Settings ⚙.
  2. In the Lists column, select Recurring transactions.
  3. Select New.
  4. Select the type of transaction to create, and then select OK.
  5. Enter a Template name.
  6. Select a Type:
    • Scheduled: Creates a series of transactions according to the schedule you set.
    • Reminder: Creates a schedule to remind you to create transactions.
    • Unscheduled: Saved with partial or complete data and without a schedule.
  7. Complete the relevant fields (customer, amount, date, etc.) and select Save template.

You can turn an existing transaction into a recurring template:

  1. Open an existing transaction.
  2. In the footer of the form, select Make recurring to create a template (or Enable Recurring Payments). If you opened an invoice, then select Make recurring.

Important notes:

  • Estimates: Recurring estimates are currently only supported in the classic estimate and invoice experience. You'll need to switch to the classic experience to create a recurring estimate.
  • PayPal: Recurring transactions using PayPal as the payment method are not currently supported.

Create templates more quickly by duplicating existing templates.

  1. Go to Settings ⚙.
  2. Select Recurring transactions.
  3. In the Action column, select Duplicate from the Edit ▼ dropdown menu. All settings except the title will be in the duplicate copy.

You can edit recurring templates for any changes in invoices, expenses, and other tasks you do regularly.

  1. Go to Settings and then select Recurring transactions.
  2. From the Action column, select Edit for the transaction you want to edit.
  3. Edit the template name, type, and the customer or payee name as needed.
  4. If you're editing a Scheduled or Reminder type template, you can adjust how far in advance QuickBooks creates the template or sends you a reminder. You can also set the frequency in the Interval section.  
  5. Add or remove any product or service details in the Item details section.
  6. When you're done, select Save template.

Note: These changes only apply to the recurring template and transactions that use the template. It doesn't apply to other transactions in QuickBooks. To change settings or other transactions, go to the customer profile or the specific transaction to make updates directly.  

Change the service date on transactions

Recurring transaction templates don't automatically populate the service date field on transactions. You'll need to find each transaction and manually enter the correct service date.  

To find transactions recently created by a recurring template:

  1.  Go to Reports (Take me there).
  2. Search for and run the Recent Automatic Transactions report.
  3. Set the report dates. 
  4. Select Run report
  5. Select the individual transaction to display it. 
  6. Manually update the Service Date field to the date the service was actually performed. 
  7. Select Save.  

If you edit an item or customer that's used by a recurring template, you'll get a message. QuickBooks tells you if the changes affect any recurring templates. You have a few options:  

  • Select Update for all to save the changes to the item or customer. This also applies the updates to all relevant templates.
  • Select One time only to save the changes only for the transaction for which you made the change.

Changing the following fields also affects recurring templates:  

  • Payment method
  • Terms
  • Taxable status
  • Transaction dates
  • Transaction number
  • Transaction amount
  • Location & Class

If you edit company settings that are used by a recurring template, you'll get a message. Unlike items or customers, you won't see a warning message. However, making changes to the following fields will affect recurring templates:

  • Customer estimates message
  • Customer sales forms message  
  • Sales tax rate
  • Account for tax
  • Account for shipping
  • Account for discount
  • MAS deposit account
  1. Go to Settings ⚙.
  2. From Lists, select Recurring transactions.
  3. Locate the Template Name and select ▼.
  4. Select Delete from the Action column.
  5. Select Yes to confirm that you want to delete the template.

Occasionally, you may notice that one or more of your recurring transactions were not created. To fix this issue, follow the recommended solutions below:  

Tip: For any templates that don't run, a quick way to create the needed transaction is to "Use" the template.

  1. Go to Settings ⚙.
  2. Under Lists, select Recurring transactions.
  3. From the list, find the recurring transaction.
  4. Select Use from the Edit ▼ dropdown.
  5. Review the transaction details and add more if needed, then select Save and close and Save and new. This manually creates a new transaction from the template.

Is the recurring template set to scheduled?

Recurring templates will only create transactions automatically when the type is set to Scheduled and the template has not reached its End Date or Maximum Occurrences.

  1. Go to Settings ⚙.  
  2. Under Lists, select Recurring transactions.
  3. Find the template for the transaction that was not created and in the Action column, select Edit.
  4. Make sure the Type is set to Scheduled and End is set to None or the appropriate end date/number of occurrences.
  5. Select Save template.

Is the credit card associated with the recurring sales receipt still active?

When QuickBooks prepares to create recurring transactions, it skips transactions that have an expired credit card. It’s important to review and make sure that your customer’s card is not expired or expiring soon. If it is, you need to update it as soon as you have your customer's new card information so that any recurring sales receipts that are scheduled continue to run.  

Was the VAT code changed?

If some item or VAT code used within a recurring template is changed indirectly, the template should automatically update to use the new information. However, we have seen some instances when an error occurs and the VAT used needs to be re-saved on the actual template.  

Tip: If the recurring template did not run, but the next date advanced, open the recurring template and make sure everything looks right then save the template and see if any errors are displayed. These errors give clues into what stopped the recurring transaction from being created.  

Recreate then delete the problematic template

If all else fails and it's unclear why the recurring template failed, first try recreating the problematic recurring template.  

  1. Go to Settings ⚙.  
  2. Under Lists, select Recurring transactions.
  3. Find the template you want to recreate and in the Action column, select Edit.
  4. Print or write down any details you will need to recreate in the template.
  5. Once ready, return to the list of recurring templates and select New.  
  6. Fill out the template and be sure to select Scheduled from the Type ▼ dropdown.
  7. Select Save template.

You then need to delete the old template.

  1. Go to Settings ⚙.
  2. Under Lists, select Recurring transactions.
  3. From the list, find the recurring transaction template you want to delete.
  4. In the Action column, select the Edit ▼ dropdown, then select Delete.
  5. Select Yes to confirm.

Additional tips

  • You can automate credit card payments with recurring sales receipts.
  • Use recurring invoices to save time and maintain consistency.
  • Review and update your recurring templates regularly to ensure they are accurate and up-to-date.


What's next?

You might also be interested in:

We're here to help
If you have questions about invoices or need help creating, customising or importing them, let us know. Sign in to QuickBooks start a discussion with a qualified QuickBooks expert in our community.

QuickBooks Online EssentialsQuickBooks Online Plus

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.