Quick answer
Record a recurring expense in Xero with a repeating template: open an existing bill, click Bill Options, then Repeat, set the frequency and start date, and choose whether generated bills arrive as drafts, awaiting approval, or approved. Xero then creates the bill on schedule without anyone typing it. Use approved status for fixed amounts, draft status for variable ones, and an end date whenever the underlying contract has one.
What belongs on a repeating template
The candidates are costs that arrive on a fixed cadence: rent, software subscriptions, insurance instalments, retainers, storage, hosting, loan fees. The test is not whether the cost recurs but whether the amount is predictable and whether the supplier sends a usable invoice. A supplier whose invoice lands in your capture inbox every month already has a path into Xero; adding a template on top creates duplicates. Templates earn their keep for charges that hit the bank with no invoice attached, and for fixed contractual amounts where waiting for paperwork adds nothing.
Setting up a repeating bill
- Create or open a bill for the supplier with the lines, account codes, and tax rates you want every period. Get this one right; every future bill inherits it.
- Click Bill Options, then Repeat.
- Set the frequency (every 1 month for most subscriptions), the start date of the next bill, and the due date rule.
- Optionally set the end date from the contract term.
- Choose the status generated bills take: Save as draft, Save awaiting approval, or Approve.
- Save the template. It now lives on the Repeating tab of the Bills screen, showing the next run date.
Templates for spend money work the same way from the bank account screen and suit direct debits with no supplier invoice.
Draft versus auto-approved
This choice decides how much checking survives. Auto-approved templates post straight into payables; nothing prompts a human. That is right for fixed rent and wrong for anything metered. The failure mode is quiet: a price rise takes effect, the template keeps posting the old amount, and the difference surfaces months later as a supplier statement mismatch. Draft templates put the generated bill in front of someone who swaps in the real amount from the invoice before approving, which is the pattern to follow for utilities, usage-billed software, and anything in a currency that moves. Price-indexed contracts deserve a calendar reminder to update the template on the anniversary.
Recurring does not mean accrual
A repeating bill books the cost in the period the bill is dated, which keeps monthly figures smooth for genuinely monthly charges. Two neighbouring cases need different tools. An annual premium paid up front but consumed monthly is a prepayment to spread, not a template to repeat. A cost you incur monthly but get billed for quarterly needs an accrual in the unbilled months. Templates automate data entry; they do not decide which period a cost belongs to.
Common mistakes
- Running a repeating template and invoice capture for the same supplier, doubling the cost until reconciliation catches it.
- No end date on templates for cancelled services; the ledger keeps accruing a liability to a supplier who will never invoice again.
- Auto-approving variable amounts, then discovering a price rise months late through a statement mismatch rather than a review.
- Stale tax rates on templates after a rate change; the template keeps the rate it was created with until someone edits it.
- Forgetting the template exists after switching suppliers, leaving both the old and new cost posting.
A quarterly sweep of the Repeating tab against the actual subscription list catches most of these. Every template should map to a live contract; every fixed monthly cost should have either a template or a capture path, not both.
Software that helps
- Xero repeating templates are free and native; the review discipline is the part you supply.
- ExpenseFlow fits the invoice-backed recurring suppliers: it captures each month’s invoice, flags duplicates, applies the correct tax code, and posts to Xero through an approval step, so variable charges get real numbers instead of template guesses.
- Spend analysis in reporting tools helps spot subscription creep, but the ledger fix still happens on the Repeating tab.
Related guides
See recording supplier bills in Xero for the underlying bill workflow, then prepayments and accruals for the period-matching cases a template cannot handle. Definition: operating expenses.
From ExpenseFlow
Expense coding on autopilot
ExpenseFlow reads every receipt, assigns the right tax treatment and account code, and syncs to Xero or QuickBooks Online once you approve.