✏️Prompts

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