Year-over-year growth by product line
“compare each 2026 month to the same month in 2025 for quickbooks sales by product line, show growth % and a Status that says "Agrees" when growth is between -25% and 25%, else what's off”
compare each 2026 month to the same month in 2025 for QuickBooks sales by product line monthly summary, show growth % and a Status that says "Agrees" when growth is between -25% and 25%, else what's off
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileQuickBooks sales by product line monthly summaryCSV export · 8 rows
- StepCompare month pairsStep 1
- ResultMonthly sales growth48 rows · 2 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 48 rows came out.
- Download QuickBooks sales by product line monthly summary sample (8 rows)QuickBooks: Reports > Sales by Product/Service Summary > Customize > Group by Product/Service and Month > Export to Excel
What you get back
The result of that run, the rows to look at first.
| Product/Service | Month | 2025 Sales | 2026 Sales | Growth % | Status |
|---|---|---|---|---|---|
| API Usage | Jul | 3,010 | 4,510 | 0.5 | Up sharply |
| Training | Aug | 3,480 | 4,450 | 0.3 | Up sharply |
| API Usage | May | 2,810 | 3,220 | 0.1 | Agrees |
| API Usage | Jun | 2,940 | 3,380 | 0.1 | Agrees |
| API Usage | Aug | 2,890 | 3,460 | 0.2 | Agrees |
| API Usage | Sep | 3,070 | 3,580 | 0.2 | Agrees |
| API Usage | Oct | 3,140 | 3,710 | 0.2 | Agrees |
| Add-ons | May | 5,290 | 6,180 | 0.2 | Agrees |
| Add-ons | Jun | 5,410 | 6,340 | 0.2 | Agrees |
| Add-ons | Jul | 5,560 | 6,490 | 0.2 | Agrees |
| Add-ons | Aug | 5,640 | 6,610 | 0.2 | Agrees |
| Add-ons | Sep | 5,780 | 6,740 | 0.2 | Agrees |
How do you calculate year over year growth by product line?
Export your monthly sales by product line from QuickBooks, with one row per month and product line. Compare each month this year to the same month last year, then calculate growth as the change divided by last year. Add a Status that says Agrees when growth is between -25% and 25%, and flag rows outside that range.
How it works
How to use the Monthly sales growth workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Monthly sales growth: questions
What export should you use?
What happens to rows that do not match the rule?
How do you change the rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Cohorts, churn, repeat purchases, retention, RFM segments and recurring revenue, from your orders or payments.
- CAC payback periodSee how many months it takes each cohort to earn back acquisition cost from spend and new MRR, from your Stripe export.See the workflow Built by the agent
- Involuntary churn and failed payment recoveryTrack failed subscription payments, retries, and churn from Stripe exports, with invoice and subscription status for this month.See the workflow Built by the agent
- Stripe failed payments, weeklyList failed Stripe payments each week, with decline reason and whether the customer paid later.See the workflow Built by the agent
- Stripe MRR by planShow MRR by plan each month from your Stripe subscriptions export, with customer counts and row checks.See the workflow Built by the agent
- Chargebee MRR movementCheck Chargebee monthly MRR movement by customer and subscription, including new, expansion, contraction, churn, and reactivation.See the workflow Built by the agent
- Cohort retentionEach month's new customers, and the share still buying 1, 2, 3… months laterSee the workflow Template