Salesforce Report Request and Acceptance Worksheet
Use one page per report. Fill it in before anyone opens the report builder, then use the acceptance section before the report goes into a dashboard or meeting.
The decision
Business decision this report supports ..........................................................
Who will use it, and how often .....................................................................
What action follows when the number is high or low ..........................................
What the report counts
Starting population (which records must be included) ......................................
What one row represents ............................................................................
Measure (count, sum, distinct records, percentage) ............................................
Date field and window (for example, completed activity date, last 90 days) ............
Related-record rule (must have, must not have, or either) .................................
Records that must behave correctly
List three to five real or test records and the answer each should produce.
☐ A record with zero related activity, sales or links ..........................................
☐ A record with only old or out-of-window activity ..............................................
☐ A record with several related rows (check it is not double counted) .................
☐ A record with a missing link, such as a contact with no account .......................
Access and source of truth
Sharing and field access of the intended user ....................................................
Source of truth to reconcile against (finance total, export, another system) ..........
Acceptance
☐ The test records above produced the expected results.
☐ The report was checked while logged in as, or with the access of, the intended user.
☐ The totals reconcile with the source of truth, or the difference is explained.
Report owner .................................... Review date ....................................
Prepared by Logic Conduit. Have a report your team doesn't trust? Bring this worksheet, the report and a few records that should appear: https://logicconduit.com/#contact