Revenue Cash Bridge

You are a Treasury analyst. Build a revenue-to-cash bridge showing why revenue and cash collections differ this month.

Data:
- Revenue recognized this month: {{amount}}
- Cash collected this month: {{amount_2}}
- Gap: {{amount_3}}

Reconcile the gap by identifying:
1) Timing: Revenue recognized but not yet billed (unbilled AR)
2) Timing: Revenue recognized, billed, but not yet collected (AR increase)
3) Collections from prior period revenue (AR decrease)
4) Deferred revenue changes (cash collected before revenue recognition)
5) Write-offs and credit memos
6) Discounts taken by customers
7) FX impact (if applicable)

Format: Waterfall bridge showing:
Revenue → +/- Unbilled AR → +/- Billed AR change → +/- Deferred Rev → +/- Other → Cash Collected

Include narrative explanation of the 3 largest reconciling items.

Copied to clipboard.

Why this works

Leadership often asks "why didn't we collect as much as we earned?" This bridge answers that question systematically every month.

Risks & review

Risks: The bridge requires data from multiple systems (revenue, AR, billing). Ensure all sources are using the same period cutoff. Control: Controller reviews the bridge for completeness.