Automated Garden Center Weekly Revenue Report
Every Monday, WebRun opens NCR Counterpoint, pulls last week's gross and net revenue by department, calculates prior-year variance and week-over-week change, appends the figures to the rolling revenue log in Google Sheets, and posts a structured weekly summary to the owner's Slack channel before the morning meeting.
How do I get an automated weekly revenue report for my garden center?
WebRun opens NCR Counterpoint every Monday, pulls last week's net revenue by department, calculates week-over-week and prior-year variance in Google Sheets, and posts a structured summary to the owner's Slack channel. The full rolling history lives in Sheets so owners can plan the next week with last week's numbers already in hand.
- Owner starts every Monday with last week's revenue already in hand
- Department-level breakdown shows exactly where the business is growing or slipping
- Prior-year comparisons take seconds instead of hours of manual spreadsheet work
Built for garden center owners · nursery general managers · retail nursery finance teams
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
ncrcounterpoint.comin a real browser with your saved login - no setup, no API keys. -
1
NCR Counterpoint - pull last week's revenue by department
ncrcounterpoint.com
WebRun opens NCR Counterpoint to pull last week's revenue by department. - Open NCR Counterpoint and navigate to Sales Reports
- Filter for the prior full week (Monday to Sunday)
- Capture gross sales, returns, net sales, and transaction count broken down by department
- Note average transaction value for the week
Done when Last week's revenue figures by department and transaction metrics are captured.
-
2
Google Sheets - log and calculate variances
google.com
WebRun opens Google Sheets to log and calculate variances. - Open the weekly revenue log sheet
- Append last week's figures for each department
- Calculate week-over-week change versus the prior week
- Calculate prior-year variance versus the same calendar week last year
Done when Last week's revenue is logged with week-over-week and prior-year variance calculated.
-
3
Slack - post weekly revenue summary to owner
slack.com
WebRun opens Slack to post weekly revenue summary to owner. - Post a structured weekly revenue summary to the owner's Slack channel
- Include total net revenue, top and bottom departments, average transaction value, and both variance figures
- Include a link to the full Google Sheet for deeper review
Done when Owner has last week's full revenue summary in Slack before the Monday morning meeting.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Can it break revenue down by department, not just show a single weekly total?
Yes. WebRun captures department-level figures from NCR Counterpoint, so the report shows annuals, perennials, trees, hard goods, supplies, and any other departments you have set up.
Where is the historical revenue data stored?
Every week's figures are appended to a Google Sheet, building a rolling history your team can use for seasonal planning, budgeting, and year-over-year trend analysis.
What if our POS data is still being reconciled on Monday morning?
WebRun reads whatever is in NCR Counterpoint at the time it runs. If you reconcile by end of Sunday, the Monday report will reflect the final figures. You can reschedule the run to later in the day if needed.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.