Revenue Cash Bridge Prompt
Prompt
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] - Gap: [Amount] 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.
Why it works
Leadership often asks "why didn't we collect as much as we earned?" This bridge answers that question systematically every month.
Watch out for
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.
Used by
Finance Teams