Looker Studio Finance KPI Scorecard With Targets
Design a scorecard for leaders with variance to target.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Design a finance scorecard in Looker Studio as a reporting design, not financial advice. KPIs and targets: [KPIS_AND_TARGETS]. Data sources: [SOURCES]. Audience and use: [AUDIENCE]. Agree definitions with finance before building. Specification table with KPI, Definition, Formula, Source field, Period, Target, Status rule and Owner. Variance is actual minus target and variance percentage is that divided by target. Fill three examples: revenue (actual 540 against target 600, variance -60 or -10 percent, red below 95 percent of target), gross margin (actual 41 percent against 40, variance +1 point), and cash balance. Define status rules with thresholds and a non-colour indicator. Finance numbers may be final only after month-end close, so show the data date and a note when figures are provisional. Add a commentary box for variances above a threshold with the owner who explains them, a review rhythm, a reconciliation check against the finance system, and a sign-off before the scorecard is shared. Mark connector and feature names [VERIFY].
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.