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