I need help creating a custom board to track daily statistics and revenues for various lodges and resorts. The idea is that each property can enter daily data through a form, including details like rooms occupied, number of adults, number of children, #OOO, #OOS, number of covers, rooms revenue, restaurant & bars revenue, C&B revenue, other revenue, and so on.
This data should then be grouped by property and provide both daily and monthly reports.
Is this something that can be done using Monday.com? If yes, could someone assist me with designing such a board?
You can absolutely have daily and monthly reports grouped by property having collected all the details by form - we’d love to help you set this one up.
Yes, this setup is absolutely doable in Monday.com, and I’ve built similar operational dashboards for hospitality groups, rental property networks, and multi-location businesses that need clean, reliable daily reporting.
The structure you’re describing can be designed using a combination of:
Custom forms for each property to submit daily data
Automations to organize entries by property and date
Connected boards for Daily → Monthly rollups
Formula + aggregation columns to compute KPIs (RevPAR, ADR, occupancy %, etc.)
Dashboard widgets to show charts, revenue summaries, and property-level performance
Filters and permissions so each lodge only sees and edits its own data
I can design the full workflow so the process is simple for staff entering data, and powerful for management reviewing the insights.
If you’d like, I can also map out:
A clean form layout that matches the exact metrics you listed
A consolidated monthly analytics board with automatic rollups
