Invoice revenue chart from a Notion database
A freelance invoice database turned into three charts: who pays the most, how revenue moves from month to month, and how many invoices are still unpaid. Hover any bar, point or slice to read the exact figure.
Free for 5 charts · no card · no expiry
Revenue by client
Free planRevenue per month
Free planInvoices by status
Starter planThe data behind it
The first 10 of 23 rows of Sample · Freelance invoices. Every chart above is built from these columns and nothing else.
| invoice | client | amount | issued | status |
|---|---|---|---|---|
| INV-1001 | CV 2 Putra | 2474 | 2026-01-04 | paid |
| INV-1002 | PT Amanah | 2611 | 2026-01-05 | paid |
| INV-1003 | CV 2 Putra | 2748 | 2026-02-06 | paid |
| INV-1004 | PT Amanah | 2885 | 2026-02-07 | unpaid |
| INV-1005 | Studio Rio | 422 | 2026-02-08 | paid |
| INV-1006 | CV 2 Putra | 559 | 2026-03-09 | paid |
| INV-1007 | PT Amanah | 696 | 2026-03-10 | paid |
| INV-1008 | Studio Rio | 833 | 2026-03-11 | paid |
| INV-1009 | CV 2 Putra | 970 | 2026-04-12 | unpaid |
| INV-1010 | PT Amanah | 1107 | 2026-04-13 | paid |
How to build this in Notion
- Give the database the right properties. Keep one row per invoice. You need a number property for the amount, a date property for the issue date, and a select property each for the client and the status. The invoice number can stay the title.
- Connect the database. Create an account, open Data sources and connect Notion. On Notion's screen, share the invoice database. ChartOmodo reads it and never writes to it.
- Build revenue by client. In the builder, pick Bar. Set X-axis (category) to client, Y-axis (value) to amount and the aggregation to Sum, then sort by value, descending, so the biggest client comes first.
- Add the month and status charts. Make a second chart with Line, the X-axis on issued and Date grouping set to Month. For the third, pick Donut, put status on the X-axis and choose Count.
- Embed it back in Notion. Copy the embed link from the builder, type /embed in your Notion page and paste it. The chart refreshes on a timer set by your plan, and sooner when Notion reports an edit.
Notion's own chart block draws bar, line and donut charts as well, and on Notion's Free plan it allows 1 chart. Charts built here do not count toward that, and the same chart can be embedded in as many Notion pages as you like.