Fabren
All guides

· Bookkeeping

How a bookkeeper runs recurring invoices in QuickBooks Desktop when memorized transactions are not enough

How a bookkeeper or small firm runs recurring invoices in QuickBooks Desktop when memorized transactions are not enough, including a billing schedule sheet and a review before send. General information, not legal advice.

By Fabren EditorialPublished November 3, 2026
12 min read

Audience

Bookkeepers and owners keeping billing in QuickBooks Desktop

Core takeaway

Memorize invoices only when amount and schedule are stable. Put shifting dates on a billing schedule, review the batch, then create or import. Informational, not legal advice.

QuickBooks Online has recurring templates. This page is Desktop only. It is about the billing run: memorized invoices, a schedule sheet when those invoices stop fitting, and a person who reviews the batch before anyone sends. It is not categorization and it is not year end close.

Coding bank feed lines in Online is bookkeeping categorization in QuickBooks Online. The close board those invoices later sit on is the month end close checklist. Same day invoice follow up for a small service shop on Online is appointment reminders and invoice follow up.

02

When memorized transactions fit

Intuit's Desktop help for memorized transactions says you enter the transaction the way you want it to show up each month, and you do not save yet. If a field contains info that may change, leave that field blank. The example they use is leaving Memo blank on a recurring check so you can type a different memo later. On Mac they also say to leave Amount blank when a utility bill changes every month. (Create, edit, or delete memorized transactions)

Intuit then asks how QuickBooks should handle the memorized item:

  • Add to my Reminders List. The item appears in the Memorized Transactions section of reminders. Fill in How Often.
  • Do Not Remind Me. It is not added to reminders and it is not entered automatically. Intuit describes this as a template for transactions that repeat from time to time.
  • Automate Transaction Entry. The transaction is entered when it is due. Fill in How Often and Next Date. If you set an automatic schedule, Next Date should be a day in the future. Number Remaining includes the Next Date transaction.

If several transactions share the same due date, Intuit lets you put them in a memorized transaction group. Open Lists, Memorized Transaction List, then New Group. That is the right tool when a small set of invoices is truly the same amount, the same day, every cycle.

03

When a schedule sheet is safer

Memorized transactions start to hurt when the date moves, when the amount is only usually the same, or when you have a long list of near identical customers. A trucking firm with hundreds of monthly invoices, some monthly, some every two months, some quarterly, is the usual break. The memorized group still wants a shared due date. A customer whose invoice date follows the last load, the last close, or a holiday week will not match that date.

Use the schedule sheet when any of these are true:

  • The invoice date shifts even if the amount does not.
  • You bill many customers the same item and you need a count and a total before send.
  • One customer has more than one cadence, so a single memorized group cannot hold them.
  • You want a named owner to sign the batch before QuickBooks creates or imports anything.

Keep memorized transactions for the short list that really is fixed. Put everyone else on the sheet. Do not fight the memorized list into doing both jobs.

Accounting firms

Want this handled for your firm?

Fabren sets up a done for you operator inside your accounting stack. It drafts client chasing, intake follow ups, and similar admin work. Your staff approve what goes out. Your CPA reviews and signs every return.

Prefer the long form? Use the contact page.

04

The billing schedule sheet

One row per customer cadence. Columns are customer, cadence, next date, amount, item, terms, last invoice number, and owner. Fill next date from the last invoice you actually sent, not from a remembered calendar.

CustomerCadenceWhen the sheet is safer
A bookkeeping client on a fixed monthly feeMonthly, same dayOnly if the invoice date still moves around month end. Otherwise a memorized invoice with Automate Transaction Entry can fit.
A client billed the fifth business day after quarter endQuarterly, date movesAlways. Leave changing fields blank if you still memorize a template, and drive the date from the sheet.
Many near identical invoices for one family of entitiesMonthly or mixedAlways. Spot check count and totals against last period before you create or import.

New bookkeeping clients should land on this sheet during onboarding, not three months later when the first missed invoice shows up. That intake is the bookkeeping client onboarding checklist.

05

Period run checklist

Run the sheet on a named day. Do not create invoices from memory in the last hour before you want cash.

  • Filter the sheet to rows whose Next date falls in this period.
  • Fill invoice dates from those rows. If a date moved, write the new date before you touch QuickBooks.
  • Create the invoices in Desktop, or import only after the sheet is reviewed. Spot check count and totals against last period.
  • A named person approves the batch. Then send. Then write the new invoice number and the next date on each row.

IRS recordkeeping says purchases, sales, payroll, and other transactions generate supporting documents, and those documents contain the information you record in the books. The invoice you send is one of those documents. Keep the schedule sheet next to the company file so you can show what you billed and when. (Recordkeeping, Publication 583)

06

IIF import only with a backup and a review

Intuit Interchange Format files can import lists and transactions into QuickBooks Desktop. Intuit's import article lists invoices among the transactions you can import. You can import transactions but you cannot export them from QuickBooks through this path. When you import IIF files, QuickBooks does not link transactions. You still need to link an invoice and an invoice payment after the import, in Receive Payments. (Export, import, and edit IIF files)

That same article says to back up your company file before you import. If the import goes wrong, restore. Intuit also says it does not offer technical support for IIF import and export. The overview article says creating IIF files from scratch is technically complex, and that it is often faster to enter the information directly unless you have very large amounts of data. It publishes sample IIF files, including invoice samples, and says to check your data carefully after importing. (IIF overview: import kit, sample files, and headers)

Use IIF when the sheet is long and the rows are clean. Do not use it as a way to skip the approval step. A person still compares the imported register to the sheet before anyone sends.

07

Download the billing schedule

Download the billing schedule and period run checklist. Founders still on Desktop can see the AI assistant for a schedule and a review queue drafted from that sheet. Bookkeepers who want the run built for the firm can see the tax season operator. In both cases a person approves the invoices. Nothing posts without that sign off.

Tax season operator

Want this handled for your firm?

Fabren sets up a done for you operator inside your accounting stack. It drafts client chasing, intake follow ups, and similar admin work. Your staff approve what goes out. Your CPA reviews and signs every return.

You read: Recurring Invoices in QuickBooks Desktop: Memorized Transactions and a Billing Schedule

Prefer the long form? Use the contact page.

Next step

Want the Desktop billing run built for the firm?

The tax season operator drafts that named follow up from the schedule. Your staff approve what goes out. A person still reviews every invoice batch before send.

See the tax season operator

Topic hub

Related guides

More in Bookkeeping and CAS workflows.