Why use it
- Close the month on an accrual basis — see revenue earned in the month next to cash collected, with the difference explained.
- Carry a deferred revenue balance — know how much collected cash is still owed as service, and when it will be earned.
- Post summary journal entries — export one line per account pair per month instead of translating the summary by hand.
- Explain revenue by plan — see which plans and billing periods drive booked, recognized, and deferred revenue.
How revenue is recognized
Every figure in the report follows these rules.- Only settled payments count. A payment enters the report when the processor settles it. Declined, failed, cancelled, and still-pending payments are excluded.
- A payment is booked in the month it was authorized. Authorization is when the customer’s charge is approved and access begins. Until the funds settle, the amount is a receivable from the processor.
- The service period starts on the authorization day and runs for the billing period of the subscription on the payment. A trial payment covers its trial period. A payment without a subscription period is a one-time purchase and is recognized in full on the authorization day.
- Revenue is spread evenly per day over the service period and allocated to calendar months. Amounts are rounded to whole cents so the months of one payment always sum to the payment.
- Tax is not revenue. Collected tax is shown separately as a liability. Tax returned to customers reduces that liability.
- A refund reverses revenue from the refund date. The share already recognized becomes contra revenue in the refund month. The share not yet recognized is removed from deferred revenue in the same month.
- Cash figures use the settlement date. The cash view shows what the processor settled in the month, including tax, less refunds settled in the month.
The report books no estimate for future refunds. It shows a suggested refund reserve as a memo so your finance team can decide whether to book one.
Worked example
A customer pays $29.99 for a 28-day plan on 20 August. The processor settles the payment on 22 August.
On the cash basis, August shows $29.99 collected and September shows nothing. On the accrual basis, August earns $12.85 and September earns $17.14.
If the customer is refunded on 1 September, recognition stops on that day. August keeps its $12.85. September shows refunds of $12.85, reversing the revenue already earned, and credits issued of $17.14, clearing the deferred balance. Together they reverse the full $29.99.
Period summary
The Period summary shows one month as a statement. Pick the month and the basis in the card title. The default is the last closed month on the accrual basis.Accrual basis rows
Only payments that have since settled are included, because the report counts settled payments only. An authorization that is still unsettled today appears in the pending settlement memo instead.
Cash basis rows
Pending settlement memo
Payments that are authorized but not yet settled appear in a memo section at the bottom of the summary. They are never part of the rows above.
Use these rows to judge when a month is stable. When pending revenue for a closed month is close to zero, no material settlements are outstanding.
Suggested refund reserve
The last memo row estimates a refund reserve for the month. It multiplies the revenue booked this month by your average refund rate. The rate uses months booked at least 60 days ago, so their refunds have had time to arrive, and attributes each refund to the month its payment was booked. The row shows the rate used. Nothing is booked; whether to record a reserve is your accounting policy.Cash vs accrual
The chart shows net cash as bars and net recognized revenue as a line. The table below it lists every month in the selected range.
A positive “Accrual minus cash” means you earned more than you collected, usually because earlier prepayments are being recognized. A negative value means you collected cash for service still to be delivered.
Revenue waterfall
The waterfall shows, for revenue booked in each month, how much was earned in every later month.
For a cohort without refunds, Recognized + Remaining = Total. Refunds reduce the month columns of the refunded payments, so for a cohort with refunds the difference to Total equals its credits issued.
Deferred revenue roll-forward
The roll-forward shows the movement of the deferred revenue balance month by month.
Future unwind of ending balance lists, month by month, when the current ending balance will be earned. It stops when the balance reaches zero.
Revenue by plan
Pick the month in the card title and choose to group by plan or by period. Grouping by period combines all plans with the same billing period, such as every 28-day plan.
Payments without a subscription plan are grouped as One-time payments. The total row equals the Period summary of the same month.
Journal entries export
In the Period summary, open Export CSV and choose Journal entries (all months). The file contains one line per account pair per month for every month in the selected range. Zero amounts are skipped. Account names are placeholders; map them to your chart of accounts when importing.
Lines for pending settlement carry
memo=true. They describe authorizations still in flight and are not booked; exclude them when posting.
Columns are accounting_period (YYYY-MM), debit, credit, amount (USD with two decimals), memo (true or false), and description.
Close a month
1
Select the range
Choose a date range that ends after the month you are closing. The report defaults to the last 6 months.
2
Check pending settlement
In the Period summary, pick the month and confirm the pending settlement rows are close to zero. If not, wait for the remaining authorizations to settle or book the pending amounts as an accrual.
3
Reconcile the balances
Confirm the Period summary ending balance equals the roll-forward ending balance for the month, and that the Revenue by plan total equals the Period summary.
4
Export the journal entries
Open Export CSV → Journal entries (all months), keep the lines for the month you are closing, and drop the lines with
memo=true.5
Add what the report does not cover
Record disputes and chargebacks, processor fees, foreign exchange differences, and any refund reserve from your own sources before posting.
Filters and date range
- The date range selects whole calendar months. The current month is included as month-to-date.
- The payment filters on the Dashboard apply to every card.
- Figures for the current and previous month can change until late-settling authorizations resolve. A payment is added when it settles and is booked back into its authorization month.