Dashboard
Agreement duration and projected revenue across the portfolio.
Boosting spend by month
Boosting amount falling in each month, across agreements.
Boosting by game
Total committed boosting split by game.
Payouts per month
Combined payouts to Magnus, Yoshi and Nigel each month.
Agreements
Source records for the dashboard. Every change is logged.
| Agreement | Counterparty | Start | End | Months left | Duration | Boosting | Status | Actions |
|---|
No agreements yet. Add one or import a sheet from Backend.
Boosting
Boosting campaigns pulled from agreements. Active on top; ended ones greyed at the bottom.
| Creator | Game | Channel (URL) | Target CCU | Boosting amount | End date | Status |
|---|
No agreements yet. Boosting campaigns appear here, pulled from your agreements.
Share Calculator
Monthly distribution. Revenue flows through tax, costs, the fund, and investments before each person's share.
Distribution waterfall
Inputs auto-fill from invoices in the selected month. Edit any field.
Fund
Manually tracked reserve. Top up to target from this month's revenue.
Distributable split
Each person's share of the distributable pool.
Invoices
All invoices raised to vendors. Anything over ฿950,000 splits into two equal invoices.
New invoice
Add line items and pick a receiver per invoice. A 3% withholding tax is deducted. Anything over ฿950,000 splits into two equal invoices.
Bill to (overrides the saved client on this invoice only)
Line items
| Title | Period | Amount | Invoices | Issued | Invoice |
|---|
No invoices yet. Create one to generate a PDF.
Payouts
Monthly payouts saved from the Shares page: the distributable total and each person's amount.
Receivers
People who receive payment, selected per invoice. Each receiver is capped at ฿1,500,000 per year.
Backend
Users, share allocation, data import, and the change log.
Monthly history (backfill)
Enter each month by hand. Revenue feeds the Share Calculator "Received". The four payouts add up to Distributable. Fund is recorded per month.
Share allocation
Set each person's percentage. Add or remove people.
Distribution settings
Defaults the monthly Shares page uses for costs and the fund.
Products & pricing
Selectable in invoices. Prices are defaults and stay editable per line.
Client (bill to)
Every invoice is billed to this client.
Cloud sync (all devices)
Sync across devices through a real database. Firebase (Firestore) is recommended: free tier, instant real-time updates, and its config is safe to keep in this file. jsonbin is a simpler fallback. Leave unset to keep data on this device only.
Firebase console → Project settings → Your apps → SDK setup and configuration → Config. Create a Firestore database first. See the setup notes I gave you for the security rule.
Creators
Dropdown options for the agreement creator.
Invoice titles
Dropdown options for the invoice title, e.g. game and publisher.
Users
Accounts allowed to sign in.
Backup & restore
Download a full backup file and keep it somewhere safe. Restore it on any device, anytime. This works whether or not cloud sync is on.
A backup holds agreements, invoices, payouts, receivers, creators, settings and users. Restoring replaces all data on this device.
Import data from a sheet
Export your Google Sheet as CSV, then paste or upload it.
Columns: name, counterparty, startDate, endDate, boosting, status
Import replaces matching names and appends new ones.
Change log
Every create, edit, delete, and login.