Handling Irregular Recurring Payments in QuickBooks Online
When a client pays the same amount on no fixed schedule, recurring sales receipts fall short. Here is a setup that fits payments that skip weeks.
A social media thread among QuickBooks users recently pinned down a gap many small firms know firsthand. A customer pays the same amount almost every week. The timing, though, is loose, and some weeks the payment never comes. Service businesses see this often, from cleaning rounds to tutoring slots to week-to-week retainers. The obvious tool, a recurring sales receipt, only partly fits. Here is what it can and cannot do, and a setup that works better.
Recurring transactions expect a fixed calendar
QuickBooks Online offers three kinds of recurring template: scheduled, reminder, and unscheduled. A scheduled recurring sales receipt creates itself on the calendar you choose. That works when the money really does arrive on that calendar. When a week skips, the receipt still posts. Your books then show income that never landed, and the correction lands on you.
Would a repeating sales receipt work when weeks skip?
Not cleanly. The reasoning behind it is sound: one payer, one amount, so let the software do the typing. The catch is that schedules fire on dates, not on deposits. Skipped weeks leave phantom receipts behind, and late weeks put the entry in the books long before the money. The downloaded deposit still has to be matched to the receipt by hand, so the manual part never disappears. Desktop users hit the same wall with memorized transactions, which also post on a set schedule.
An unscheduled template fits better
Build the sales receipt once, with the customer, item, and amount filled in, then save it as an unscheduled recurring template. Nothing posts automatically. On the day money actually arrives, open the template and save that single receipt. You keep the speed of a template and lose the false entries in skipped weeks. This is the closest QuickBooks Online gets to recurring without a calendar.
Bank rules can carry part of the load
Because the amount never varies, a bank rule keyed to the payer and the amount can prefill the categorization for the downloaded deposit. The line arrives mostly ready for review. That removes typing on the bank side and pairs well with the template on the sales side. A rule still cannot decide for you whether a given week had a payment.
Match the deposit, don’t add it
Once the receipt exists and the deposit appears in the feed, match the two. Adding the downloaded line as fresh income records the sale twice. Matching keeps the ledger and the bank statement tied together. This is exactly the manual step that blocks fully automatic handling, whichever template type you pick.
If you already run a weekly scheduled receipt for a payer like this, audit the recent ones first. Delete any receipt with no matching deposit before your next reconciliation. Then switch the template to unscheduled, set the bank rule, and let the arriving money, not the calendar, trigger each entry.