Hermetic NetworksHermetic Networks

Admin & Accounting - Finance and Bookkeeping - Session 07

Recurring Revenue and Collections

Reconcile recurring agreements with invoices and recorded revenue. Maintain a collection list that explains what is owed, what may be disputed, and when cash is expected.

1The recurring agreement

Recurring revenue is revenue from arrangements that repeat, such as ongoing managed service agreements. A recurring agreement describes the service, price, billing frequency, and conditions for changes or cancellation. Read the agreement before assuming a monthly accounting amount will continue unchanged.

Monthly recurring revenue, or MRR, is the normalized monthly value of active recurring commitments under a stated definition. A company must decide which charges belong in that definition. A recurring support agreement can qualify, while a one-time project or equipment sale normally does not. Annual or quarterly recurring charges need a documented monthly normalization if included.

Recorded recurring revenue and contract MRR answer different questions. Recorded revenue describes activity under the accounting policy during the report period. Contract MRR describes the active recurring commitment at a date. Credits, service changes, timing, and classification can make the two differ.

The supplied September recurring revenue is $106,456.25. It reports recurring activity during September. A verified contract MRR schedule requires agreement-level evidence. The aggregate exports do not supply client agreements, user counts, or active contract dates. The admin manager should reconcile those records before using September's amount as a growth baseline.

A forecast should distinguish signed work from expected new sales. An opportunity under discussion does not have the same certainty as an active agreement. The CEO selects the assumptions used in a forecast. The admin manager supplies the current contract and billing evidence that those assumptions need.

2The contract and billing schedule

A contract schedule lists active recurring agreements and their billing terms. For each agreement, record a stable client identifier, start and end conditions, service description, pricing method, included quantity, approved extras, billing date, due date, and responsible account contact. Keep sensitive details in approved internal files.

An MSP may price by user, device, location, a fixed agreement amount, or a combination. A user-based agreement needs an agreed method for counting billable users. A quantity change should have evidence and an effective date. Do not assume every account found in a technical system represents a billable user under the contract.

Compare the schedule with the service and billing records in Syncro. Syncro is the service and billing system used in this course. It provides evidence for client activity and invoices. QuickBooks Online is the accounting record. Confirm how the approved billing records reach QuickBooks and how exceptions are detected.

The company bills on the first day of the month. A first-day invoice creates a payment request, but its service period and revenue treatment still need review. The contract may specify payment in advance, payment during service, or another arrangement. Use the due date in the agreement rather than selecting a generic collection assumption.

Check additions, cancellations, temporary holds, discounts, and credits against the schedule. A canceled service left active in a billing system can create a disputed invoice. A new service omitted from the schedule can lead to unbilled work. Both errors make the accounting result harder to interpret.

Keep a dated change log. The log should identify the prior quantity or price, the approved new value, effective date, approver, and the first invoice affected. It gives the reviewer a way to separate genuine contract growth from a billing correction.

3The recurring revenue reconciliation

A reconciliation compares records that should agree and explains their differences. For recurring billing, begin with the active agreement schedule and calculate the expected charge for the service period. Compare expected charges with approved invoices. Then compare the invoices with accounting records and recorded revenue under the accounting policy.

A difference can be valid. A midmonth start may have a partial-period charge. A prepaid annual agreement may have cash collected at one date and revenue recognized over its service period. A client credit may reduce the billed amount. Keep a clear explanation with the supporting document.

A recurring revenue movement table starts with opening contract MRR, adds approved new and expanded commitments, subtracts reductions and cancellations, and arrives at closing contract MRR. Expansion means an existing client's recurring commitment increases. Contraction means it decreases. Churn means the defined recurring commitment ends. State whether churn is measured as dollars, agreements, or clients.

The movement table needs the same definition at both dates. Including equipment in closing MRR but excluding it from opening MRR would create apparent growth from a definition change. Retain the agreed scope beside the calculation.

RecordQuestion answeredReview needed
Contract MRR scheduleWhat is committed at this date?Scope and effective changes
Invoice registerWhat was charged?Price, quantity, period, credits
Accrual revenueWhat was earned?Recognition policy and cutoff
CollectionsWhat money arrived?Payment application and remaining debt

The CEO uses the reconciliation to understand which changes should recur in the forecast. The admin manager identifies billing gaps and unexplained differences. An unexplained gap should not be included as dependable cash until the record and collection expectation are established.

4Receivable aging and expected receipts

Accounts receivable is money clients owe for amounts already recorded as due. An aging report groups unpaid balances by how long they have been outstanding or overdue under its settings. Confirm whether the report uses invoice age or days past the due date before calling an invoice late.

A collection list adds the practical information an aging report may lack: contact person, last contact, disputed amount, promised payment date, next action, and the person responsible. Separate a confirmed promise from an assumption. Keep the original due date visible even when a client promises a later payment.

The company September receivable total is $10,860.00. The October 1-6 total is $128,891.43 after the company's first-day billing cycle. The increase of $118,031.43 requires invoice and collection detail. The balance alone does not prove that the amount is overdue or that it will be collected on a particular day.

A negative total can conceal several situations. The supplied July and August balances are negative. Review client credits, advances, and unapplied payments. An unapplied payment is money received but not yet assigned to the correct invoice or account balance. Resolve payment application before contacting a client about a debt that may already have been paid.

For a disputed invoice, identify the reason and the person able to resolve it. A quantity dispute needs the agreed user or device evidence. A service dispute needs the account or service owner. The admin manager can organize the information and follow up without deciding a pricing concession outside the approved rules.

The CEO approves unusual credits, payment arrangements, or service decisions under the company's policy. The accountant advises on collectibility, allowances, and write-offs. A write-off is an accounting removal of an amount under an approved treatment; it is not a collection and does not itself produce cash.

5The billing and collection routine

Before billing, review agreement changes and quantity evidence. After billing, verify that expected invoices were created, transferred, and sent as intended. Check failed delivery or payment status in the tools you actually use. Do not assume an invoice was received simply because it was generated.

Apply client payments to the intended invoices using remittance information. Remittance information explains which invoices the payer intends to settle. A payment can cover several invoices or only part of one. Processing fees may reduce the bank deposit without reducing the client's gross payment; reconcile the fees separately under the approved procedure.

Before collection contact, confirm the balance and dispute status. Use a factual message that identifies the invoice, service period, amount, due date, and request for a payment date or explanation. The course does not send messages or set company collection deadlines. Agree the actual contact schedule and escalation rules together.

Record each contact and follow-up date in one approved location. If the admin manager and CEO both contact a client, shared notes prevent conflicting promises. Avoid treating the latest verbal estimate as guaranteed cash. Update the cash forecast according to evidence and the CEO's assumptions.

Review the collection list regularly using the cadence the team agrees. Focus on larger or older balances, unresolved disputes, and broken payment promises. A large recent first-day invoice and a small invoice overdue for months require different investigations even if both appear in the same total.

The monthly report should identify the recurring reconciliation status and material collection exceptions. A clear list helps the CEO decide whether a billing process, client relationship, or credit decision needs attention. It also gives the admin manager a specific task and a record of completion.

6Practice example: an agreement change

This is a hypothetical arithmetic exercise, not the company's contract data. A client's agreement starts the month with 20 billable users at $100 per user per month. Five approved additional users are effective for the full new month. A one-time project invoice is $1,000. The recurring invoice is prepared for $2,400 by mistake, and the client pays $2,000 toward it. Assume no tax or other charges.

  1. Calculate opening contract MRR, the approved expansion, and closing contract MRR.
  2. Calculate the expected recurring invoice. Compare it with the issued amount and identify the billing difference.
  3. Explain whether the one-time project belongs in the defined MRR schedule.
  4. Calculate the remaining balance on the invoice as currently issued. Then calculate the remaining balance after an approved $100 correction increases the invoice to the proper amount.
  5. Prepare the evidence and approval request needed for the correction and a collection note that distinguishes current records from the proposed correction.
Check your work

Opening MRR is 20 × $100 = $2,000. Expansion is 5 × $100 = $500. Closing contract MRR is $2,500. The expected recurring invoice is $2,500, so the $2,400 invoice is $100 below the agreed amount. The $1,000 project is excluded from the stated recurring definition.

The issued invoice balance is $2,400 minus $2,000 = $400. After the approved correction, the proper recurring balance is $2,500 minus $2,000 = $500. Do not request the corrected amount as if it were already recorded and approved.

Evidence includes the agreement, user change approval, effective date, invoice, and applied payment. The admin manager prepares the proposed correction. Approval follows the company's rules. The collection note should state the recorded balance and the separate correction status so the next person does not duplicate or contradict the action.

7Your company recurring and collection file

The admin manager prepares a dated contract MRR schedule from approved agreements and Syncro billing information. Compare the schedule with one completed month's invoices and the recurring revenue accounts. Use the company reference for the accounting totals, while keeping individual contract data in approved finance files.

Prepare a collection list from current aging and payment application detail. Mark due dates, disputes, promises, and next actions. Investigate negative client balances before presenting a net total as evidence that no one owes money.

The CEO reviews the MRR definition, material differences, and collection exceptions. Decide which actions require CEO involvement and which the admin manager can complete under established rules. Ask the accountant about recognition or credit-balance presentation questions.

The deliverable is a recurring reconciliation and a collection list with assigned next actions. These records will supply evidence for the revenue forecast and the 13-week cash forecast later in the course. Keep agreement value, earned revenue, invoices, and cash collections separately labeled.

8Going deeper

Going deeper

Revenue retention can be measured in more than one way. A calculation excluding expansion asks how much of the starting recurring commitment remained after reductions and cancellations. A calculation including expansion also counts increases from those same clients. New clients belong in a separate growth category. Before using a retention percentage, state the opening cohort, period, recurring definition, and included changes. Aggregate recurring revenue accounts cannot supply that contract-level calculation by themselves.

9The completed work

A dated recurring revenue reconciliation and a client collection list.

Keep approved company work in your finance workspace. The course records study progress in this browser; it does not store your reports or forecast files.

10Quiz

  1. September's recurring revenue account shows $106,456.25. What establishes contract MRR at September end?
    Answer

    Recorded recurring revenue is an accounting period amount. Contract MRR needs current agreement-level evidence.

  2. A client grows from 20 to 25 full-month billable users at $100 each. What is the MRR expansion?
    Answer

    The recurring commitment increases by $500. Keep opening, movement, and closing amounts distinct.

  3. The expected recurring invoice is $2,500, the issued invoice is $2,400, and $2,000 is paid. What remains on the current issued invoice?
    Answer

    The current balance is $400. A separate approved $100 correction would change it to $500.

  4. October receivables rise after first-day billing. What should determine whether a particular invoice is late?
    Answer

    Inspect invoice-level dates and whether the aging report uses invoice age or days past due.

  5. A client's payment has arrived but is unapplied. What should occur before an overdue collection request?
    Answer

    Use remittance and payment evidence to apply the receipt correctly, then review the remaining debt.

  6. A one-time project is invoiced alongside monthly support. How should it enter the stated support MRR schedule?
    Answer

    Keep one-time work separately identified so the recurring forecast does not repeat revenue without a commitment.

11Glossary

Recurring revenue
Revenue from arrangements that repeat, such as ongoing managed service agreements.
Monthly recurring revenue (MRR)
The normalized monthly value of active recurring commitments under a stated definition.
Contract schedule
A list of active agreements and their pricing, quantities, dates, and billing terms.
Expansion
An increase in an existing client's recurring commitment.
Contraction
A decrease in an existing client's recurring commitment.
Churn
The ending of a defined recurring commitment, measured under a stated dollar, agreement, or client definition.
Accounts receivable
Money clients owe for amounts already recorded as due.
Aging report
A report grouping unpaid balances by how long they have been outstanding or overdue under its settings.
Unapplied payment
Money received but not yet assigned to the correct invoice or account balance.
Remittance information
The payer's explanation of which invoices a payment settles.
Write-off
An accounting removal of an amount under an approved treatment; it does not itself collect cash.
Collection list
A working record of unpaid balances, contacts, disputes, expected dates, and next actions.

12Sources

Company examples use the accrual reports supplied on October 6, 2026. Report periods, selected totals and limits are recorded in the company reference. Examples labeled practice use hypothetical inputs.

  • Syncro: Invoice payments: Official background reading supporting the records, reconciliations, and payment mechanics in this session.