· 8 min read
A multi-channel profit and loss sheet in Excel, step by step
Build an Excel profit and loss file for Shopee, TikTok Shop and your website: sheet layout, SUMIFS and XLOOKUP formulas, splitting vouchers, fees and ads.
Blog
· 8 min read
Build an Excel profit and loss file for Shopee, TikTok Shop and your website: sheet layout, SUMIFS and XLOOKUP formulas, splitting vouchers, fees and ads.
· 6 min read
Alert on falling revenue or rising returns without drowning in messages: choose the period, threshold, change or anomaly condition, wait time and recipients.
· 6 min read
20 data tasks in the 4 weeks before 11.11 and 12.12 to measure true profit, catch errors early and avoid arguing about numbers after the sale.
· 5 min read
Define your own KPIs without skewing shared numbers: naming, versions, checking numbers before activation, who approves, with a profit-after-packaging example.
· 6 min read
Connect Claude Code and Cursor to business numbers over MCP: create a read-only token, configure the client, keep the token out of the repo, and sample prompts.
· 5 min read
Send sales numbers to Google Sheets for your accountant on a schedule: pick metrics, overwrite or append, set up a service account, keep formulas intact.
· 6 min read
A Telegram bot your whole team can ask about revenue: link accounts, bind the group to a workspace, ask with /ask, and set group rules so numbers stay safe.
· 5 min read
Why profit falls hard when revenue dips only a little: how to split a profit change by formula, channel and product, and how to read Si's answer.
· 6 min read
Sales data checks: mismatched SKUs, duplicate rows, unknown order statuses, missing cost of goods, provisional fees. Catch them in Excel or automatically.
· 6 min read
Set up scheduled P&L reports and alerts in Telegram: which metrics to send, when, how to set thresholds without noise, and how to ask Si in the group.
· 5 min read
Eight metrics that tell a multi-channel seller how much real profit they make, where, and whether to trust the numbers, with a 5-minute read.
· 6 min read
Seven signs your Excel reporting file is overloaded, what a data warehouse really does, the cost and risk of each step, and how to move without dropping Excel.
· 5 min read
What the Model Context Protocol is, why pasting sales files into a chatbot is risky, and how to give Claude or your own agent read-only access to approved metrics.