All work/Own operations systemLive
Five-Channel Profit Sheet
Strong revenue does not mean profit. This sheet works out every day what each channel actually keeps.
Walkthrough · 21s
The video is an illustration of the process. All data shown is for demonstration.
01 · The problem
How much is left after platform fees, shipping and advertising used to be known only at month end, and a pile of numbers had to be typed in by hand each month until nobody kept it up.
02 · Our approach
- One page per channel, counting only the costs that can be attributed to it, and working up layer by layer to contribution margin.
- A company sheet adds up the channels, deducts shared costs and carries on to net profit after tax.
- Fee rates that platforms change are not written into formulas. The sheet reads the amounts actually deducted.
- Manual inputs are kept to 5 or fewer per month. Anomalies are flagged by the program, not by eyeballing.
03 · Process
- 01Orders and payouts imported per channel
- 02Deduct platform fees, shipping and ads
- 03Work out each channel's contribution margin
- 04Add up to company P&L, flag anomalies
04 · Results
- All five channels connected
- 5 or fewer manual inputs per month
Want something similar?
Tell us how you do it today and which step takes the most time: