Navigation

14.30. Review Deferred Revenue and Unearned Prepaid Balances by Month

Review a monthly deferred-revenue rollforward for prepaid credits and contract bucket hours, then drill into the balances behind monthly activity.

14.30. Review Deferred Revenue and Unearned Prepaid Balances by Month
Review a monthly deferred-revenue rollforward for prepaid credits and contract bucket hours, then drill into the balances behind monthly activity.
14. Billing and ContractsUpdated: 8/29/2026

When an MSP receives payment before delivering the related service, the undelivered portion needs to remain visible. Prepaid credit may still be waiting for a future invoice, and prepaid contract bucket hours may remain unburned at month end. The Deferred Revenue report presents those balances as a monthly rollforward so finance can explain what changed.

Use it during month-end close to trace opening balances, new prepaid value, value recognized through delivery, and closing balances. It is a reporting view, not accounting advice, and it does not replace the general ledger.


What deferred revenue means for an MSP

Operational billing and revenue timing are not always the same event. Funding a contract bucket period records that the client has prepaid for future work; using the hours records delivery of that work. Similarly, a client prepayment can remain available as credit until it is applied to charges.

The report helps finance separate value already received from service already delivered.

Prepaid activityOperational meaningRollforward effect
A client funds prepaid creditCash or value has been received for future billingAdds to the unearned balance.
A contract bucket period is fundedHours have been funded but not yet deliveredAdds the unburned value to the balance.
Prepaid credit is applied to delivered chargesPreviously prepaid value now covers delivered serviceMoves value out through recognition.
Technicians burn prepaid hoursPart of the funded service has been deliveredMoves the related value out through recognition.
A credit or balance is correctedThe amount still owed in future service changesAppears in the activity supporting the applicable movement.

The report follows the source activity recorded in AlgaPSA. If a prepayment, credit application, or hour entry is missing or dated incorrectly, the rollforward will reflect that source record.


Read the monthly rollforward

For the selected month, the report groups activity under Credits and Prepaid hours:

Displayed componentWhat it tells finance
OpeningThe selected month's opening balance. It is not a prior-month comparison column.
IssuedNew prepaid value recorded during the selected month.
AppliedCredit applied or prepaid hours used during the selected month.
ExpiredValue that expired during the selected month.
Adj.Credit adjustments during the selected month. This column appears in the Credits group.
ClosingValue still prepaid at the end of the selected month.

The table also shows Client and Total closing. If the closing balance does not make sense, do not start by adjusting the report total. Drill into the supporting balances to find the client-level activity that produced it.


Open the report and select a month

Go to Reports > Deferred Revenue and select Open report. The page heading is Deferred revenue / prepaid liability. The month input has no visible label, and the selected month is the report's only filter. The report requires the reports:read permission.

Figure 1: The rollforward for a selected month, with per-client movement behind the total.

Start with these checks:

  1. Confirm that Opening represents the balance at the start of the selected month.
  2. Scan Issued for newly funded credit and prepaid hours expected during the month.
  3. Compare Applied with credit applications and prepaid work delivered.
  4. Review the closing balance for large, old, or unexpected items.
  5. Review Expired and credit Adj. activity that cannot be explained from the month's billing records.

The summary cards are Total prepaid liability, Credits, Prepaid hours, and Change vs prior month. Opening remains the selected month's opening balance; it is not the prior-month comparison.


Drill into credits

Open Credit balances to review the prepaid credit contributing to the rollforward. Its columns are Issued, Description, Remaining, Expires, and QBO. QBO displays Synced or Not in QBO.

The entries are plain text. The drill-down does not link to source documents and does not show a user-facing movement-type field. Use the parent report's Issued, Applied, Expired, and Adj. columns to understand the category of activity, then inspect the relevant billing records separately when more detail is required.

A credit note and a prepayment can both affect client credit, but they represent different business events. See 14.23. Issue and Apply Credit Notes for MSP Client Billing for how AlgaPSA distinguishes value given back from money paid ahead.


Drill into unburned hours

Open Prepaid bucket hours to review funded contract bucket value that remains undelivered. Its columns are Line, Period, Included, Used, Remaining, Value, and Fee. Fee displays Not yet billed or Billed, and a carried period is marked rollover.

For each material balance, ask:

  • Does Included agree with the contract bucket allowance?
  • Do burns agree with approved work recorded during the period?
  • Is rollover affecting the period or remaining balance?
  • Does the remaining value reconcile to the unburned hours?

This drill-down reports contract bucket-usage periods, not one-time prepaid hour blocks. One-time hour-block expiration does not appear here. Non-rollover value forfeited when a bucket period ends contributes to the parent report's Expired movement.

See 14.28. Sell and Track Prepaid Hour Blocks Without a Recurring Contract for the separate one-time hour-block workflow.


Month-end close workflow

The report is most useful when finance follows the same review each month.

1. Confirm the period boundary

Make sure billing administrators have completed the relevant prepayment, credit, time, and invoice activity for the month. Late source entries can move the balance after finance has already reviewed it.

2. Confirm the selected month's opening

Treat Opening as the balance at the start of the selected month. Investigate backdated or corrected source activity if that starting point is unexpected.

3. Review issued value

Match newly issued credit and funded contract bucket hours to the billing records finance expected. An unfamiliar item may be valid, but it should have a traceable client and billing record.

4. Review applied value

Connect applied credits and burned hours to the service delivered during the month. Investigate unusual timing rather than assuming the summary is wrong.

5. Inspect the closing balance

Review old or material balances with account managers. A long-held credit or contract bucket balance may be valid, close to expiration or period end, or waiting on work that has paused.

6. Reconcile to the accounting system

Use the report's drill-down as supporting detail, then reconcile the result under your organization's accounting policy in the general ledger. 14.14. How Accounting Works in AlgaPSA: Invoices, Payments, Credits, and Your Books explains the boundary between AlgaPSA billing and the books.


Investigate a rollforward difference

SymptomWhat to inspect
Opening is unexpectedBackdated entries, corrections, or a changed reporting boundary.
Issued is lower than expectedMissing or incomplete prepaid funding activity.
Applied is higher than expectedCredit applications or hour usage dated into the month.
A bucket remains in Closing after expected deliveryMissing time, service mapping, or burn activity.
A client balance is unfamiliarThe credit and unburned-hour drill-downs for that client.

Do not compare the report only to invoice revenue. Deferred activity can span several operational events, and accounting exports may follow a separate finalized-document workflow. See 14.17. Export Finalized MSP Invoices for Import into QuickBooks, Xero, and Other Accounting Systems.


Use the report with operational performance views

Deferred revenue explains undelivered prepaid value; it does not measure whether the work is profitable. Review margin separately in 14.24. Profitability Reporting: Measure Gross Margin per Client, Agreement, and Ticket. Together, the reports answer different questions: what remains to be delivered, and what the delivered work cost the MSP.


Related topics