Hi everyone,
For a property management company - how to create the next quarterly report?
I have a board for:
Assets
Faults
Clients
Every quarter I want to send the client a report with the income for his assets (the income for each asset is recorded on the Assets board and a client can have multiple assets)
The expenses for each asset (the expense for each asset is recorded on the Assets board) + the expenses for the faults in the quarter (there is a board for Faults).
Then I want to show the client the total income minus the total expenses.
Additionally, I want automation that will send the client the quarterly report every quarter.
How can I do this?
As I understand it, I need to prepare a dashboard for each client and if I have a lot of clients it’s a hassle.
I would be happy to hear if there is a more efficient way to build the report.
Thanks in advance!