QuickBooks Desktop · Recurring bills

Recurring bills in QuickBooks Desktop and the duplicates they cause

Recurring bills in QuickBooks Desktop are memorized transactions that can be entered automatically when due. Set up carelessly, they post the same bill twice.

What QuickBooks Desktop's documentation says

  1. Recurring bills in QuickBooks Desktop are memorized transactions, created with Edit > Memorize and listed in Lists > Memorized Transaction List. Automate Transaction Entry enters them when due, using How Often, Next Date and Number Remaining. Source 1 (opens in a new tab)

Checked against the vendor's documentation on Nov 7, 2026. Products change; the vendor's current help is the final word.

How recurring bills work in QuickBooks Desktop

A recurring bill in QuickBooks Desktop is a memorized transaction. You build the bill once, then choose Edit > Memorize to save it. It then appears in Lists > Memorized Transaction List, where you can see what is set to repeat and when.

To have bills entered for you, turn on Automate Transaction Entry. QuickBooks Desktop uses three fields to decide when and how often to post: How Often, Next Date and Number Remaining. How Often sets the interval, Next Date is the first date the next entry is due, and Number Remaining caps how many entries will be made before the memorized transaction stops.

That is the whole mechanism. It is simple, and that is why it causes trouble. A memorized bill is a template, not a live link to the vendor. Nothing in it checks whether the supplier already sent you an invoice, whether the amount changed, or whether someone keyed the same bill by hand last week. If the template is wrong, or if it runs alongside manual entry, you get two bills for one obligation.

Recurring bills suit fixed, predictable charges: rent, a monthly software subscription, a standing service fee. They fit poorly where the amount moves every month or where the invoice arrives by email and gets entered by whoever opens the mail. That overlap between the template and the inbox is where most duplicates start.

How recurring bills get paid twice

The first pattern is the template plus the paper. A memorized rent bill posts on the first of the month. The landlord's invoice also arrives, and an AP clerk enters it as a fresh bill because it is sitting in the queue. Now the vendor record has two open bills for the same month. Both can pass through approval if nobody checks the vendor's existing balance before paying.

The second pattern is a template that was never stopped. Number Remaining runs out, someone resets it or sets a new Next Date, and the old schedule is still live. Or a bill is memorized twice by two people who each thought they were the only one setting it up. Two memorized transactions, same vendor, same amount, same day. The payment run picks up both.

Invoice numbers make this worse. A supplier bills as INV-1043; the template carries no number, or carries the previous month's. A clerk later keys the same charge as 1043. Matching on the number alone fails, because the two records do not look alike. The same thing happens when a supplier is set up twice in the vendor list, once as Acme Supply Co and once as Acme Supply Company. The duplicate bills sit under different vendor records and never appear side by side in a review.

Statements are another source. A clerk reconciles the monthly statement by entering every line on it as a bill, including charges already entered from the original invoices. The statement gets paid as well as the invoices. Credits are the mirror image: a supplier issues a credit for an overbilling, nobody applies it, and the next recurring bill goes out at the full amount anyway. Re-sent payment runs close the loop. A run is reversed or held, then released again, and the same bills are selected twice.

Controls that help

Keep one owner for the Memorized Transaction List. One person, named in the AP procedure, creates and retires recurring bills. Everyone else requests changes through that person. Review the list on a fixed date each month and confirm that every entry still matches a live obligation, with the right How Often, Next Date and Number Remaining.

Before a bill is entered by hand, check the vendor's open balance in QuickBooks Desktop. If a recurring template covers that supplier, the clerk should see the automated entry or know it is coming. A short note on the vendor record saying which charges are on a template saves a lot of rework.

Match on three things, not one: vendor, amount and a date window. If a new bill lands within a few days of an existing bill for the same vendor at the same amount, hold it and look. Invoice numbers help but they are not reliable, because INV-1043 and 1043 are the same invoice to a human and different strings to a system. When you export bills for review, the supplier invoice number sits in the Num field, so treat that column as a hint and not as proof.

Reconcile statements against bills already entered before adding anything from the statement. Ask suppliers for credits or refunds when you find an overpayment, and log the request so the next recurring bill is not paid at the old amount. If a bill is voided or deleted, check QuickBooks Desktop's own help for what happens to the memorized transaction behind it rather than assuming.

Reviewing recurring vendors

Pull the vendors with memorized transactions and look at each one's bill history for the last few months. You are looking for two bills on the same or adjacent dates at the same amount, and for bills that appear both from the template and from manual entry. A vendor with a steady monthly charge and occasional extra bills at the same figure deserves a closer look.

Work a small example. Rent is $2,400 a month, memorized with How Often set to monthly. In March the template posts on the 1st and a clerk keys the landlord's invoice on the 3rd, also $2,400. The payment run on the 15th clears both. That is $2,400 overpaid, and it stays overpaid until someone reviews the vendor or the landlord says something. Find it first, and you ask for a credit against April.

Check the vendor list for near-duplicates too. The same supplier under two names splits the history and hides the second bill. Merge or retire the unused record, then recheck the open balances under the surviving one.

Keep the review short and repeatable. A monthly pass over recurring vendors, matching on vendor, amount and date window, catches most of what templates and manual entry create between them. Record what you find and what you asked the supplier for, so the next person reviewing the account knows where things stand.

To review paid bills outside QuickBooks Desktop, export them: Export paid bills from QuickBooks Desktop. The supplier's invoice number is in the Num column.

Questions

How do I stop a recurring bill in QuickBooks Desktop?

Open Lists > Memorized Transaction List and find the entry. You can remove it from the list or change its settings so it no longer posts. Check QuickBooks Desktop's own help for the exact effect of each option before you change a live schedule.

Why did a bill get entered twice when it was on a memorized transaction?

The template posted the bill and someone also keyed the supplier's invoice by hand. The two records often carry different invoice numbers, such as INV-1043 and 1043, so a number match misses them. Match on vendor, amount and a date window instead.

What do How Often, Next Date and Number Remaining control?

They drive Automate Transaction Entry. How Often sets the interval between entries, Next Date is when the next one is due, and Number Remaining limits how many entries will be made. A schedule that was reset or extended can keep posting after the obligation has changed.

How do I find duplicate bills from recurring vendors?

Review the vendors that have memorized transactions and look for two bills at the same amount on the same or nearby dates. Also check for the same supplier set up twice in the vendor list, which splits the history. When you confirm an overpayment, ask the supplier for a credit or refund and note it against the next bill.

Updated Nov 17, 2026. Figures on this page are calculated by ERPSav from the definitions shown. The explanatory text is drafted with AI from those figures and checked automatically before it is published. General information only, not legal, tax or financial advice.