Sales, stock and operations,
in one set of reports
your managers trust.
We connect the data you already keep in QuickBooks, Shopify, spreadsheets and ERP exports, build dashboards around the numbers you run the business on, and keep them refreshed every month. Small and midsize businesses only.
What a project covers
Five chapters, one engagement
- 01
Data review
We start with your goals, not a tool. In a short call and a look at sample exports, we list every data source, the reports people build by hand today, and the questions nobody can answer quickly. You get a written summary either way.
- 02
Data preparation
Sales, inventory and accounting rarely agree on SKU codes, customer names or dates. We clean and map them into one model with a shared calendar, so a unit sold means the same thing in every report.
Data source mapping status for a retail clientSources in this project
Sources in this project Source Status Shopify orders API connection Mapped QuickBooks Online Invoices & COGS Mapped Warehouse stock sheet Excel, weekly Cleaning ERP purchase orders CSV export Duplicate SKUs - 03
Dashboards
Tailored views for the people who use them: weekly sales against last year, gross margin by category, days of stock on hand, open orders. Built in Power BI, Tableau, Data Studio or Excel, inside your own account.
Sales and inventory dashboard exampleOR Ops Report- Sales
- Inventory
- Orders
- Margin
Weekly sales
Week 46
- Net sales
- $84,320
- +6.2% vs LY
- Gross margin
- 38.4%
- -0.9 pts
- Days of stock
- 41
- Target 35
Net sales by week ($k) This year Last year Illustrative product interface - 04
Recurring reports
Scheduled refreshes and reports that arrive on their own: the Monday sales summary, the month-end stock valuation, the reorder list for the buyer. If a refresh fails, we are alerted before your team notices.
Scheduled refresh and report delivery log- Power BI service Scheduled refresh completed: Sales model Mon 6:00 AM
- Subscription Weekly sales summary emailed to 4 managers Mon 7:00 AM
- Alert Refresh failed: warehouse sheet moved in SharePoint Tue 6:00 AM
- Pacific Crest support File path updated, refresh re-run Tue 9:40 AM
- 05
Ongoing support
Businesses change: a new store, a new product line, a switch in accounting software. Optional monthly support covers report updates, data maintenance and refresh monitoring, with a fixed number of hours each month.
Monthly support plans from $350 / month →
How we work
No work starts until you have a written proposal with the scope, schedule and fees, and you have agreed to it.
We build inside your own Microsoft, Google or Tableau account using credentials you issue, and you remove our access when we are done.
Every measure on a dashboard has a written definition, so "net sales" means one thing across the company.
The models, reports and documentation belong to you, and BI licenses are bought directly from the vendor with no markup from us.
Tell us which numbers you can't get today.
Send a short note on your data sources and the reports you need. We reply within one business day and the first review is free.