SPECIMEN · SYNTHETIC DATA · NOT A CLIENT RESULT
THE $500 SCOPE REVIEW / Shopify · Year-end sales
A complete written report: what we found, why it matters, what to change and what still needs approval. Read it all in one PDF.
Read the full PDF report ↗net sales
Handoff status OPEN
A fictional year-end deck labels gross sales less discounts as net sales, omitting a documented sales-reversal component. The review traces month-to-quarter-to-year arithmetic, adjustment signs and scope limits; it does not provide financial assurance.
The PDF explains what is wrong, the figures that support that conclusion, and the actions needed before the report can be accepted. It includes the completed check results and recommendations in one document; the supporting files are optional.
Read the full PDF report ↗REVIEW DISPOSITION / OPEN
6 checks pass · 1 fails · 2 remain open.
The corrected report and dated definitions approval are missing. This specimen does not claim an implemented fix or a signed-off client outcome.
RP-SHOPIFY-YEAR-01 · 2025-01-01 inclusive / 2026-01-01 exclusiveA $500 assessment of one workflow, one primary schema and one representative client, with up to three agreed export formats. Implementation is separately scoped.
The synthetic calculation log uses only gross_sales_usd and discounts_usd, despite $8,000 sales_reversals_usd in the same frozen rows.
$208,000 draft vs $200,000 net control; +$8,000 / +4.0%.
Evidence: SH-D01; SH-C04; SH-MAP48
Recommend subtracting the documented positive reversal amount once; recalculate each required output.
Twelve fabricated months preserve every original quarter component and sum to $228,000 total sales.
Reconciled arithmetic on a simplified single-currency sales-report basis.
Evidence: SH-C02; SH-C03; SH-C05; SH-C06
Retain component fields, signs, period and zero duties/fees assumptions; do not infer payouts or profit.
Adjustment date treatment, approver identity/date and corrected outputs are not provided in this packet.
No financial assurance or completed report acceptance follows from synthetic arithmetic.
Evidence: SH-C08; SH-C09
Obtain the authorized definition decision and dated final-output acceptance.
The review includes 12 synthetic source rows and 48 explicit source-to-output mappings. Download the CSVs to inspect every row and transformation.
Freeze the fictional period, channel/action/component basis, currency when applicable, and cutoff.
Inspect individually identified synthetic aggregate rows; no personal records.
Trace exact source row IDs and fields through grouped and headline output calculations.
Reproduce the deliberately incorrect draft calculation; this log is invented fixture evidence, not a live diagnosis.
Separate arithmetic passes, reproduced draft failures, and unresolved approval/evidence items.
Review recommendations and leave handoff acceptance unresolved until an authorized approver and corrected outputs exist.
| ID | Source rows / field | Output | Rule / basis |
|---|---|---|---|
| SH-MAP01 | SH-M01;SH-M02;SH-M03gross_sales_usd | quarters.Q1.gross_sales_usd | SUM(gross_sales_usd)Positive discounts/reversals deducted; USD; calendar months |
| SH-MAP02 | SH-M01;SH-M02;SH-M03discounts_usd | quarters.Q1.discounts_usd | SUM(discounts_usd)Positive discounts/reversals deducted; USD; calendar months |
| SH-MAP03 | SH-M01;SH-M02;SH-M03sales_reversals_usd | quarters.Q1.sales_reversals_usd | SUM(sales_reversals_usd)Positive discounts/reversals deducted; USD; calendar months |
| SH-MAP04 | SH-M01;SH-M02;SH-M03shipping_net_usd | quarters.Q1.shipping_net_usd | SUM(shipping_net_usd)Positive discounts/reversals deducted; USD; calendar months |
| SH-MAP05 | SH-M01;SH-M02;SH-M03tax_net_usd | quarters.Q1.tax_net_usd | SUM(tax_net_usd)Positive discounts/reversals deducted; USD; calendar months |
| SH-MAP06 | SH-M01;SH-M02;SH-M03duties_usd | quarters.Q1.duties_usd | SUM(duties_usd)Positive discounts/reversals deducted; USD; calendar months |
Each check retains an evidence reference, a way to reproduce it and the next action. A calculation pass does not close an approval gap.
Evidence
source.csv SH-M01..SH-M12
Reproduce
Count each month 2025-01 through 2025-12 once and map three months per Q1..Q4.
Next action
Retain disjoint calendar grain and store time zone.
Evidence
SH-MAP01..36
Reproduce
Group gross/discounts/reversals/shipping/tax/net: Q1 40000/2000/1000/3000/2500/37000; Q2 50000/2500/1500/3200/3100/46000; Q3 55000/3000/2000/3500/3400/50000; Q4 75000/4500/3500/4300/5000/67000.
Next action
Compare final quarter table with all component controls.
Evidence
SH-MAP37..45; SH-MAP46
Reproduce
Sum gross=220000; discounts=12000; reversals=8000; net=200000; shipping=14000; tax=14000.
Next action
Retain annual component reconciliation.
Evidence
SH-D01; SH-MAP48
Reproduce
220000-12000=208000; reversals absent; excess 8000/200000=4.0%.
Next action
Recommend subtracting the documented sales-reversal component once.
Evidence
source.csv all twelve rows
Reproduce
Each net_sales_usd = gross_sales_usd - discounts_usd - sales_reversals_usd; both deduction fields nonnegative.
Next action
Preserve sign convention; avoid subtracting an already negative number.
Evidence
SH-MAP47
Reproduce
200000+14000+14000+0+0=228000; monthly total_sales_usd sums to same.
Next action
Compare corrected annual net and total lines together.
Evidence
metadata.json; source.csv duties_usd/fees_usd
Reproduce
All duties and fees zero; single USD basis with stated store time zone and cutoff.
Next action
Escalate changed components or currency to a written scope decision.
Evidence
acceptance-record.txt; metadata.json
Reproduce
No named approver/date approves adjustment signs, date treatment or definition mapping.
Next action
Obtain written definition approval; legacy return labels need explicit mapping if relevant.
Evidence
acceptance-record.txt
Reproduce
No regenerated report/export or final-output sign-off supplied.
Next action
Compare all quarter controls, $200000 net and $228000 total in each required output, then obtain dated sign-off.
Delivery for an agreed $500 review is three business days after written scope, payment and complete agreed inputs. It is an assessment, not an implementation or a guarantee of report accuracy.
The findings, supporting figures, check results, recommendations and acceptance decision are explained together in one PDF. You do not need to open a spreadsheet or recreate a calculation.
Read the full report · PDF ↗All report data and draft logs are synthetic, not a client result.
These files preserve the detailed evidence trail. Everything needed to understand the review is already in the PDF.
FROM A QUESTIONABLE NUMBER TO A REPRODUCIBLE DECISION.
Get a written fit answer for the $500 review. Implementation is agreed separately; this review is included once in a $2,500 sprint when both scopes fit.
Ask about your report ↗Browse all case files →