A recurring-billing total can look complete during a close. It may still leave one key question unanswered: Which transactions support this number?
QuickBooks Online and Xero do not document a recurring-billing total that opens its contributing transactions. This workflow builds a manual evidence trail instead.
Set up a read-only review
View and compare records only. Do not edit templates, change transaction status, alter accounting records, save report changes, or change settings.
Set each report to the relevant transaction-date period. Do not use the template’s creation timing as the reporting basis.
Record only these displayed fields:
- Template name
- Template amount
- Template frequency/cadence as displayed — how often the template runs
- Report period/date range as displayed
- Transaction date
- Transaction amount
The template shows scheduled details. It does not show that a matching transaction exists or reached a particular status.
When you compare rows, treat one row as a likely match only when its date and amount fit the displayed template details. A matching row is evidence, not proof that the template created it.
QuickBooks Online: review the template and account detail
Open Reports, then open Recurring Template List. Find the template and record its displayed name, amount, and frequency.
Next, run General Ledger for the relevant transaction-date period. Review the account shown on the template.
For recurring customer billing, use Transaction List by Customer when it is available in your company. Set that report to the same transaction-date period.
Compare each transaction date and amount with the template details. A row that fits is a likely match.
These reports can include transactions created outside the recurring template. That can leave more than one possible matching row. If more than one row fits, record the result as inconclusive rather than selecting one row.
Xero: review the repeating template and invoice detail
Open Sales, then Invoices, then Repeating. Find the repeating invoice template and record its displayed name, amount, and frequency.
Run Receivable Invoice Detail for the relevant transaction-date period. Compare each transaction date and amount with the template details.
A row that fits is a likely match. Receivable Invoice Detail can also include credit notes, overpayments, and prepayments. If several rows fit, record an inconclusive result.
For an approved, customer-specific review, use Customer Invoice Activity. Do not use that report when the review needs activity beyond approved transactions.
Handle access limits before you draw a conclusion
If you cannot view the template, report, or source transactions, stop and request access.
In QuickBooks Online, a user who can view reports may not be able to view the underlying transactions. Ask an administrator to confirm access to the needed sales, expense, or accounting records.
In Xero, a read-only user can view invoices and reports. That role cannot access repeating invoice templates. Ask an administrator to confirm sales and reports permissions.
Describe the result accurately
Use likely match when one transaction row fits the displayed template details.
Use inconclusive when several rows fit or the needed records are unavailable.
A likely match supports a documented comparison to one transaction row; it does not prove the template created that transaction. An inconclusive result means you should not select one row as the match.
Official sources
- QuickBooks Online: Review recurring transactions
- QuickBooks Online: Create a report showing debits and credits by transaction
- QuickBooks Online: User roles and access rights
- Xero: Add or edit a repeating invoice template
- Xero: Customer Invoice Activity report
- Xero: User roles and permissions
Last verified: 2026-08-28