Xero, Sheets, and Slack: the small-business finance stack nobody writes books about
Most small businesses do not need Looker. They have Xero, a Google Sheet, and a leadership channel on Slack. Here is how to wire the three together so the screenshot habit dies and the numbers stay alive.
Xero, Sheets, and Slack: the small-business finance stack nobody writes books about
There is a remarkable amount of finance reporting in the world being done by exactly three tools: Xero (for the numbers), Google Sheets (for the model), and a Slack #leadership channel (for the audience). Nobody writes BI conference talks about this stack. Everybody runs it.
The setup is basically right. The screenshot step in the middle is the bit that breaks.
Why Xero alone isn't enough
Xero is correct. Xero is also rigid. The reports it ships will give you accurate numbers and not much else. What Xero doesn't easily give you:
- Revenue by product line, when products aren't first-class entities.
- Margin by customer cohort.
- Forecast vs actual with your assumptions baked in.
- Anything that wants a one-off manual adjustment for the weird Q3 invoice.
Sheets is where finance teams add those things. Xero is the input. Sheets is the model. That distinction matters more than it sounds — Sheets isn't an inferior version of a dashboard, it's the actual thinking layer.
Why the screenshot step has to go
Most teams do this:
- Friday afternoon: open the Sheet.
- Screenshot the P&L summary.
- Drop it into
#leadershipwith a couple of sentences. - Field one or two replies, lose half of them to DMs.
- Repeat next Friday.
By the time anyone asks a real question about the screenshot, the underlying numbers have moved. The channel ends up with eight months of screenshots that all look slightly different and none of them link to anything you can drill into. The screenshot is the bit that broke; everything around it was fine.
The two replacements
Xero direct to Slack. When the chart is Xero-native (revenue by month, cash position, expenses by category), connect Xero straight to Slack via Chartcastr. We cover the rhythms in Slack Connect Xero accounting reporting and Xero P&L variance explained in Slack.
Xero through Sheets to Slack. When the chart needs the modelling layer (forecasts, cohorts, custom segmentation), keep the Sheet. Build the chart in it. Use Chartcastr to post the Sheet's chart on a cadence.
Both work. Most finance teams end up using both, for different charts.
Cadence — please, not daily
Finance does not change daily for most businesses. A daily post is noise dressed up as discipline. Here's a rough cadence that holds up:
- Cash position — daily if cash is tight, otherwise weekly. (If you're checking cash daily out of stress, fix the cash situation, not the cadence.)
- Revenue / P&L summary — weekly. Sometimes monthly for slower businesses.
- Forecast vs actual — monthly, post-close.
- Customer or project profitability — monthly.
The longer take is in the agency reporting cadence playbook.
Bonus track: Xero Practice Manager
If you run an accounting practice, the better source is usually Xero Practice Manager — job profitability, WIP, time entries, invoiced vs unbilled. Chartcastr supports it as its own source. Same wiring: pick the report, pick the channel, pick the schedule. Your monthly internal review meeting probably stops being a meeting.
Setting it up
- Add Xero (and/or Xero Practice Manager) as a source in Chartcastr. OAuth, no token-paste.
- For Xero-native reports, pick the report directly.
- For modelled reports, connect the Sheet that holds the model and pick its chart.
- Channel, cadence, done.
