Automate Monthly Financial Report for Land Trading Company Using Monday.com Data

We're a land and forest trading company. Our business involves buying land plots, selling cutting rights or harvesting forests, and then either reselling or holding the land as an investment.We track our operations in Monday.com:Our purchasing manager logs each new land deal (terms, amounts, size, etc.)Our sales team inputs data when a plot is sold (sale date, amount, etc.)Until now, I’ve been preparing a monthly Excel report manually to calculate core business metrics like:Capital cost per dealNet profitSales marginsNow we want to automate this entire process to:Eliminate repetitive manual reportingEnsure metrics are updated automatically and dynamically as colleagues input data in MondayKeep data entry strictly within Monday.com (no double entry elsewhere)What We Need from You:Build a system (using Monday.com + Make.com/Zapier/API) that automates data extraction and calculation of financial metricsSet up a dynamic dashboard or report (can be in Monday, Google Sheets, Excel, or similar)Help translate our current Excel report structure into this automated versionProvide a step-by-step explanation so I (as the financial controller) can maintain or tweak it in the futureIdeal Profile:Strong experience automating workflows between Monday.com and reporting toolsFamiliar with financial reporting and business metricsCan teach and document the setup clearlyAble to work independently and deliver a self-sufficient systemProject Scope:One-time setupSystem handover with brief walkthrough/trainingDeadline: flexible but ideally within 2–3 weeks

Apply Now