How I Manually Calculated Project Profitability — And How Many Mistakes I Made

In my career, especially at the dawn of the «Dom i Sad» company, I spent countless hours manually calculating the profitability of each project. It seemed simple enough: costs minus revenues. But in practice, it turned into an endless quest with a pencil, calculator, and dozens of spreadsheets. And, as I later realized, this path was riddled with errors that cost me not only time but also real money.

The Beginning: The Illusion of Control and the First Warning Signs

When I was just starting out, first at NPF «Alkar» and then at «Alkar-invest», we already faced the need for accounting. Back then, I assigned tasks to programmers for management accounting, understanding its importance. But in the landscape business «Dom i Sad», where each project is unique, I initially tried to control everything personally, relying on my notes and common sense. I thought I knew every detail: the cost of materials, the time spent on work, the team's wages. I believed I could keep all the numbers in my head or in a couple of Excel spreadsheets. This was an illusion of control. In reality, the more projects appeared, the harder it became to account for all the nuances, and the first 'warning signs' of inaccuracies began to manifest as unexpectedly low profits on seemingly successful projects.

Why Manual Calculation Always Fails

Manual calculation of profitability is not just slow; it's fundamentally inaccurate. The human factor plays a huge role. Fatigue, distractions, a simple typo — and suddenly, there's an error in the calculations. I had cases where, due to one incorrectly entered figure in the material estimate, the overall project profitability 'fluctuated' by 5-10%. Moreover, a landscape project isn't just about materials and labor. It involves logistics, tool depreciation, small consumables that seem insignificant individually but add up to a substantial expense. Manually tracking all these micro-costs is practically impossible, and they constantly slipped out of sight.

Typical Mistakes That Ate Into My Profits

Over the years, I identified several key mistakes that constantly recurred with manual calculation:

• Unaccounted Overhead Costs. Office, communications, fuel, equipment repair, insurance, accounting – these expenses were often ignored or allocated 'by eye,' leading to an underestimation of project costs. For example, fuel costs for site visits or the depreciation of expensive garden equipment (e.g., a ride-on lawnmower costing 10,000 euros) were rarely accounted for individually per project.
• Inaccurate Time Tracking. Teams work based on actual hours, but with manual accounting, you often round up or fail to account for downtime, travel between sites, or loading/unloading time. As a result, the actual labor cost turned out to be 15-20% higher than planned.
• Losses and Reworks. A broken pot, a poor-quality plant that had to be replaced, a layout error leading to a path relocation. These 'minor' issues are common in landscape design. Manually accounting for them and attributing them to a specific project is extremely difficult, so they were either written off as general losses or ignored entirely, distorting the true picture of profitability.
• Price Dynamics. Material prices change. Buying something today at one price and a month later at another makes it very easy to get confused if you don't keep strict track of receipts. Consequently, an estimate prepared at the beginning of a project could differ significantly from the actual costs by its completion.

The Cost of Inaccuracy: When Mistakes Become Critical

Inaccurate profitability calculations have far-reaching consequences. Firstly, it leads to incorrect pricing. If I underestimate the cost, the selling price will be below optimal, and I lose profit. If I overestimate, I risk losing a client. Secondly, it hinders strategic decision-making. Without knowing the actual profitability of projects, it's impossible to understand which services are most profitable, where to invest, and what to abandon. I remember once we took on a large pond construction project that seemed very promising. In the end, due to hidden costs and several reworks, its actual profitability turned out to be almost zero, even though my manual calculations indicated it should have brought good profit. Such mistakes don't just eat into current profits; they undermine trust and slow down company growth.

From Pain to Solution: The Search for Automation

My 'pain' from inefficient manual accounting accumulated over years. I understood that to scale the business and make informed decisions, a system was needed. My experience assigning tasks to programmers back in the 90s, and later, attempts to implement various CRM systems in «Dom i Sad», showed that there simply were no universal solutions for the landscape business. Standard CRMs didn't account for the specifics: working with zoning, plants, materials, and site-specific considerations. This understanding became one of the key moments that prompted me to start developing my own tool – formspace.design. I wanted to create a system that would not just calculate but also help prevent errors at the planning stage, making the entire process transparent and manageable. I discussed in more detail why a landscape company director needs management accounting, not financial accounting, in the article «Why a Landscape Company Director Needs Management Accounting, Not Financial Accounting».

How to Plan in formspace.design and Avoid Mistakes from the Start

The accuracy of project profitability calculation begins at the planning stage. In formspace.design, I implemented functionality that allows minimizing errors and shortcomings even before construction work begins.

Imagine a client approaches you with a request to landscape a 10-are plot. Instead of immediately diving into calculations on paper, you can use formspace.design. First, in module 1.x «Plan/Zones/Objects», you upload the site plan or draw it from scratch. Then, using zoning tools, you divide the territory into functional areas: a recreation zone, a playground, a garden, a vegetable patch. By selecting objects from the extensive library — trees, shrubs, small architectural forms, pathways, lighting elements — you effectively create a detailed 3D model of the future garden. Each added element has its parameters, which can be linked to material consumption and labor costs. This allows for a very precise estimation of the scope of work and the quantity of necessary resources.

Furthermore, module 2.1 «AI-Concept» can help quickly generate several design options, considering your input. This not only saves time on concept creation but also allows you to offer the client multiple options with varying costs, immediately seeing their impact on the overall estimate. For example, if you want to show how the budget would change with more expensive plants or a different type of paving, formspace.design allows you to promptly make these changes and get updated data. This provides the opportunity not only to get an accurate estimate but also to avoid costly reworks and changes during implementation, which inevitably 'eat into' profitability. This approach to planning is the foundation for healthy profit, because, as I've already mentioned, a CRM made by a designer for designers inspires more trust.

Management Accounting for Landscape Business: What You Need to Know

Management accounting is not financial accounting. Its purpose is not tax reporting, but providing information for effective management decisions. For a landscape business, this means understanding the true cost of each service, each project element. It's crucial to clearly separate direct and indirect costs, control the budget at each stage, and analyze deviations. Only then can you understand which projects truly generate profit and which merely create an illusion of busy activity. This allows for timely strategy adjustments, process optimization, and ultimately, an increase in the company's overall profitability. Without this, any attempt to increase revenue can be negated by hidden losses.

FAQ

Can I track profitability in Excel if I have few projects?

In theory, yes, for 1-2 simple projects per year, Excel might suffice. However, as soon as the number of projects exceeds 5-7, or they become more complex and multi-component, the risks of errors and inaccuracies sharply increase. Excel quickly becomes cumbersome and inconvenient for dynamically tracking all expense and revenue items.

What hidden costs are most often overlooked in manual calculations?

Most often, indirect costs are overlooked, such as depreciation of tools and equipment, transportation costs (fuel, vehicle maintenance), small consumables (fasteners, gloves, film), subcontractor services not included in the main estimate, as well as project management time and administrative overhead. These 'minor' items can account for up to 10-15% of the total project cost.

How do I know if my manual calculations are inaccurate?

The first sign is a discrepancy between expected and actual profit. If you work a lot but constantly lack funds or your profit is much lower than you anticipated, that's a clear signal. Frequent budget overruns, the need to purchase additional materials that were 'forgotten' to be included, or constant client complaints due to misunderstandings about the scope of work also indicate inaccuracy.

Does planning quality affect project profitability?

Absolutely. High-quality and detailed planning, for example, using tools like formspace.design, allows for the most accurate determination of the scope of work, necessary materials, and labor costs. This minimizes the risks of errors, reworks, and unplanned expenses during implementation, directly impacting the final project profitability.

At what project volume should one switch to automated accounting?

I would recommend considering automation with as few as 5-7 active projects per year. If you are managing several projects simultaneously, or you have regular clients with ongoing work, manual accounting ceases to be effective. This is the threshold where the time saved through automation begins to justify the investment in a system.

What are the main advantages of automating management accounting?

Automation ensures data accuracy, prompt report generation, transparency of all financial flows, and the ability to analyze the profitability of each project in real-time. This allows for informed decision-making, identifying 'weak spots' in the business, and optimizing processes, leading to sustainable profit growth.

What should I do if I've already found errors in old calculations?

Don't panic. It's important to use this experience to improve future processes. Analyze exactly where errors were made and which expense categories were ignored. Use these findings to adjust your estimate templates, improve expense control, and start implementing a more systematized approach to accounting, possibly with the help of specialized tools. This is a valuable lesson that will help avoid repeating mistakes.

My journey from manual calculations and constant errors to understanding the need for automation was long but extremely insightful. Experience has shown that without a clear management accounting system, without tools that provide a complete picture, it's virtually impossible to develop a business sustainably. Today, I am confident that investing in proper planning and automation is not just an expense but a strategic investment in the future of your company. This is precisely why I am creating formspace.design, so landscape designers can focus on creativity, not on wrestling with numbers.