# Create monthly invoice for each client
**URL:** https://forums.knack.com/t/create-monthly-invoice-for-each-client/18870
**Category:** Get Answers
**Created:** [March 5, 2025, 2:31pm UTC](https://forums.knack.com/t/create-monthly-invoice-for-each-client/18870 "2025-03-05T14:31:21Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Gary4](https://forums.knack.com/u/Gary4)
#### Post date: [March 5, 2025, 2:31pm UTC](https://forums.knack.com/t/create-monthly-invoice-for-each-client/18870/1 "2025-03-05T14:31:21Z")
Hi,
I sell leads to multiple clients. Each client has its own dashboard.
I have four tables:
1. Clients
2. Leads
3. Relationships (Assigned client\<-\>lead relationships… basically “deals” for which i get paid a lead commission. The commission data for each deal is stored here.
4. Invoices
I want to automate creating invoices for each client at the end of the months. However, I can’t find a way to consolidate all deals (“relationships”) per client per month in the Invoices table…
Any help would be much appreciated!
---
### Author:  [@Hugo](https://forums.knack.com/u/Hugo)
#### Post date: [March 5, 2025, 4:19pm UTC](https://forums.knack.com/t/create-monthly-invoice-for-each-client/18870/2 "2025-03-05T16:19:03Z")
Hi @Gary4,
it might be that you gould do thi in Knack, but you might need to use Make to help, especially if you need clear line items. Happy to have a look and point you in the right direction, or if interested I can help build it out; just drop me a DM.
Cheers, Hugo