Money in
RM 0
Payments received from clients.
This year
Money out
RM 0
Everything the company paid for.
What's left
RM 0
Money in minus money out.
Clients who paid
0
Clients with at least one payment in this period.
Expected every month
RM 0
What clients are set to pay you each month, based on their plans.
Money in the bank (estimate)
RM 0
Opening balance plus everything in, minus everything out, since the sheet began.
Paid, amount not entered yet
0
Clients marked “P” this month — they've paid, the amount isn't in the sheet yet.
Paying clients right now
0
Marked “Yes” in the sheet. Not affected by the period.
Month by month
Blue is what came in, orange is what went out. The dark line is what was left each month.
Money in vs money out
How the bank balance moved
What it costs to run each month
RM 0
Fixed costs every month
RM 0
Typical one-off spending
0
clients cover the fixed costs
Your regular bills
Where the money went
Spending by type, each month
Each colour is a type of expense from the sheet. Taller bar = more spent that month.
Biggest types of spending
Share of all money out in this period.
Top places you paid
Who received the most money in this period.
How you paid
Card vs company bank vs cash.
Where the money came from
Top clients
Who paid the most in this period.
Client status
How every client in the sheet is marked right now.
Expected every month, by service
Website plans vs ads management, for clients who haven't stopped.
How clients paid
Clients coming and going
New clients vs stopped clients
Green = a client's first payment was that month. Red = a stopped client's last payment was that month.
How many clients paid each month
How long clients stay
Red = clients who stopped, grouped by how many months they stayed. Blue = current clients, by how long they've been with you so far. Not affected by the period.
In plain words
0
months — average stay of stopped clients
—
months — when most leave
0
months — current clients, average so far
What a client is worth
Average client, all-time
RM 0
Per client, per month
RM 0
Expect from a new monthly client
RM 0
Average one-time job
RM 0
By kind of client
“Worth” is everything a client has paid you, start to finish. “Typical” is the middle client — half paid more, half less.
| Kind of client | Clients | Average worth | Typical | Average stay | Per month |
|---|
How much clients have paid, in total
Each bar is a group of clients. Tall bar on the left = many small clients.
Who to chase
Paying clients whose payment date has passed or is within 7 days and who have nothing (no amount, no “P”) entered for this month. Always up to date, not affected by the period.
| Client | Expected | Due date | Status | Why | Contact |
|---|
Nobody to chase right now 🎉
All clients
Every row in the Revenue sheet. Click a client to see their payments month by month.
| Client | Status | Monthly fee | Paid in period | Paid so far | Per month | First paid | Last paid | Months paid | Next due |
|---|
All payments out
Every row in the Expenses sheet for the selected period.
| Date | Paid to | Type | Amount | Method | Note |
|---|---|---|---|---|---|
| Total for this view | RM 0 | ||||
Showing up to 500 rows. Narrow the filters or download the CSV for everything.
Sheet check
Things in the sheet that look off. Nothing here is changed by the dashboard — fix them in Google Sheets.