Automated MicroBiz Pen Brand Margin Report
Every Monday, WebRun opens MicroBiz to pull the past week's pen sales by brand, matches each brand's landed cost from QuickBooks, and builds a Google Sheets report ranking brands by gross margin dollars and margin percentage, so a high-volume brand that barely profits does not crowd out a slower brand that pays better.
How do I find out which pen brands actually earn the most margin?
WebRun pulls the past week's pen sales by brand from MicroBiz, matches each brand's landed cost from QuickBooks, and builds a Google Sheets report ranking brands by gross margin dollars and percentage, not just units sold. It flags any brand whose margin dropped more than 5 points week over week, so a popular but low-profit brand never hides.
- Low-margin bestsellers stop crowding out more profitable brands
- Margin drops of 5 points or more get flagged the week they happen
- A running weekly report replaces manually cross-referencing two systems
Built for stationery shop owners · pen retailers · independent pen and paper stores · multi-brand stationery boutiques
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
microbiz.comin a real browser with your saved login - no setup, no API keys. -
1
MicroBiz - pull pen sales by brand
microbiz.com
WebRun opens MicroBiz to pull pen sales by brand. - Open MicroBiz and pull the past week's pen sales grouped by brand
- Capture units sold and revenue for each brand
- Include both individual pens and multi-pack sales
Done when The past week's pen sales by brand are pulled with units and revenue.
-
2
QuickBooks - match each brand's cost
- Open QuickBooks and pull the landed cost for each pen brand, including freight
- Match each brand's cost to the sales pulled from MicroBiz
- Calculate gross margin dollars and margin percentage per brand
Done when Every brand has a matched cost and a calculated margin.
-
3
Google Sheets - rank brands by margin
google.com
WebRun opens Google Sheets to rank brands by margin. - Add this week's row to the margin report in Google Sheets, ranked by margin dollars
- Show margin percentage alongside units sold so volume and profit are both visible
- Flag any brand where margin percentage dropped more than 5 points from last week
Done when The margin report ranks every pen brand with margin dollars, margin percent, and week-over-week change.
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
Does this look at sales volume or actual profit?
Actual profit. It matches each pen brand's landed cost from QuickBooks against its MicroBiz sales, so a brand that sells a lot but earns little no longer looks better than a slower brand with a healthier margin.
Will it change my prices or reorder anything?
No. It only builds a ranked margin report in Google Sheets. Any pricing or reorder decision is still yours to make.
How far back does the margin comparison go?
Each week's row is added to a running sheet, so you can compare this week's margin against the week before, or scroll back to spot a longer trend.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.