Managing Interior Construction Costs with Excel

In this article

1. When estimates only exist on… paper
2. Cost Overruns — The Hidden Enemy of Profit
3. Cash Flow — The Problem Small Contractors Often Overlook
4. Why Excel — Not Specialized Software?
5. 3 Processes to Digitize for Construction Cost Control
6. Story Part 2 — When Tuan Changed His Approach
7. Start Controlling Costs from the Next Project

When estimates only exist on… paper

Most small interior contractors have an estimate. The problem isn't the lack of one, but that the estimate is merely a round figure. Kitchen cabinets: 80 million. Wooden flooring: 60 million. Gypsum ceiling: 35 million. Total: 430 million. Contract signed for 500 million. Profit: 70 million. Clear, simple.

But of that 80 million for kitchen cabinets, how much is for wood? How much for accessories (hinges, drawer slides, handles)? How much for labor? How much for transportation? When a client requests a change from laminate to natural oak veneer, you know it's more expensive — but how much more expensive? exactly how much? 5 million? 12 million? 20 million? If you can't break it down, you can't answer.

And this is what happens in reality: you nod in agreement to material changes to keep the client happy. You absorb the difference into your profit because you have no basis for negotiation. Your profit shrinks without you realizing it, until you recalculate at the end of the project.

“An estimate that isn't detailed isn't an estimate — it's an approximation. And an approximation doesn't protect your profit.”

The way interior construction cost estimation common today is like driving without a speedometer: you know you're moving, but you don't know if you're going fast or slow, safely or dangerously.

Cost Overruns — The Hidden Enemy of Profit

In interior construction, unforeseen issues are unavoidable. Clients change their minds. Architects adjust drawings. Material prices increase. In-wall pipes are in the wrong position. That's the nature of the work. The problem isn't that these issues occur — but that no one documents it.

Why don't contractors record it? Because of relationship pressure. A client says, “just add a small shelf, it's simple” — you hesitate to say, “sure, but it'll cost extra.” You want to maintain harmony and the relationship to get referred for the next project. And each time you “add something small,” your profit drops by 3–5 million.

5 small changes × 5–10 million each time = 25–50 million in additional costs. On a 500 million project with an expected profit of 70 million, that's 1/3 to 2/3 of your profit. And you only realize this figure when it's too late to do anything about it.

The act of tracking construction variations not to make things complicated, but to protect you. When every change is recorded and billed immediately, you have a basis to tell the client: “Here’s what has changed, and here’s the corresponding cost.” Professional, transparent, and no one feels put on the spot.

Cash Flow — The Problem Small Contractors Often Overlook

Estimates and variations are about total costs. But there's another problem that many contractors don't consider until they run into trouble: construction cash flow — meaning money in and money out at each point in time.

Imagine this: Mr. Tuan advances 150 million to buy initial materials for a project. The client makes an advance payment of 100 million. He's currently 50 million in the red. Mid-project, an additional 80 million is needed to buy supplementary materials and pay workers' wages. The client's next payment installment isn't due yet. Where does the money come from?

The common answer: take it from personal funds, or from an advance payment for another project. This is a dangerous spiral many contractors fall into: using funds from project A to cover project B, then using funds from project C to pay back project A. Everything seems fine until one project's payment is delayed — and the entire system collapses.

“Small contractors don't go bankrupt because of losses. They go bankrupt because they run out of cash.”

When you have a clear spreadsheet construction cash flow — recording every income from clients and every expense for materials, labor, and accessories — you know exactly whether the project is in the black or in the red at any given time. You know when to request the next payment installment. You don't need to borrow money from other projects to cover shortfalls.

Why Excel — Not Specialized Software?

You might be thinking: “If cost management is so important, why not use professional software?” A valid question. And the answer is very practical.

Professional software for construction cost management like MS Project, Primavera, or Vietnamese SaaS apps are usually designed for large general contractors — companies with 50–200 employees, running projects from 10 billion VND upwards. License fees range from several million to tens of millions VND per year. They require several weeks of training. And most importantly: can your crew actually use them?

For a construction team of 3–15 people, running 2–5 projects concurrently, Excel can meet 90% of their needs managing interior construction costs if the file is built correctly:

3 Processes to Digitize for Construction Cost Control

Regardless of the tool you use — Excel, Google Sheets, or any application — there are 3 processes that every interior contractor needs to shift from “keeping in their head” to “recording in a system” if they truly want to control construction costs.

Process 1: Detailed Itemized Estimates

Each construction item needs to be broken down into specific line items. For example, for kitchen cabinets:

• Cabinet carcass wood: Melamine-coated MDF, 8 sheets × 850,000đ = 6,800,000đ
• Stone countertop: artificial stone 2.4m, 1 sheet × 4,500,000đ = 4,500,000đ
• Hardware: soft-close hinges (12 units), drawer slides (6 sets), handles (8 units) = 3,200,000đ
• Labor: 2 workers × 5 days × 450,000đ/day = 4,500,000đ
• Delivery + installation: 1,500,000đ

Total kitchen cabinets: 20,500,000đ — this figure is far more precise than “kitchen cabinets: 20 million” because you know the exact cost of each component. If a client wants to change the countertop from engineered stone to real granite, you can immediately calculate the difference: 4.5 million → 8.2 million = an increase of 3.7 million.

Process 2: Real-time tracking of incurred changes

Each time there's a change from the original estimate, record it immediately in the variations log: what item, why, who requested it, and the cost difference. The system automatically aggregates and alerts when the total incurred changes exceed the allowed threshold (typically 10–15% of the total estimate).

“Incurred changes aren't scary. What's scary are incurred changes where no one knows the total impact until the project ends.”

Process 3: Actual vs. Planned Cash Flow

Record every payment received from clients (advances, installment 1, installment 2, final settlement) and every expenditure (material purchases, labor payments, accessories, transportation). Compare this with the initial revenue and expenditure plan — to know if the project is in the black or in the red. at any given time during the construction process, there's no need to wait until completion to calculate.

Story Part 2 — When Tuan Changed His Approach

Let's get back to Mr. Tuan. After a 500 million VND project where he didn't know if he made a profit or a loss, he decided: for the next project, I have to do things differently. Not by buying expensive software, not by hiring an accountant. Just by moving from “keeping it in my head” to “recording it in a file with formulas.”

He spent an afternoon setting up the file for the new project — a 350 million apartment. Each item was detailed: materials, labor, accessories. When a client requested a change in hinge type in the third week, he opened the file, entered the change, and immediately replied: “Certainly, madam, this part will increase by 1.8 million, I'll record it as a variation.” The client understood, agreed, and no one was upset.

On the 3rd project after implementing a system, Mr. Tuan discovered something surprising: small accessories (hinges, drawer slides, glue, screws, cover strips) accounted for up to 7% of the total cost. In 10 years of working, he had never noticed this figure because it was scattered among hundreds of small items. With a system, these “leaks” immediately became apparent.

Start Controlling Costs from the Next Project

If you've read this far and resonate with Mr. Tuan's experience, the good news is: you don't need to completely overhaul your workflow. Simply integrate a systemic layer into your existing processes. Begin with your very next project — setup can be completed in just half a day.

1. Prepare a structured file — ensure all sections are interconnected: estimates, variations, and cash flow must update concurrently.
2. Enter detailed line items — clearly delineate materials, labor, and accessories with their respective unit prices. Do not omit minor items.
3. Set a variation threshold of 10–15% — upon reaching this threshold, pause and engage in discussion with the client.
4. Record income and expenses as soon as they occur — avoid deferring recording until the end of the week.
5. 30-minute weekly review — compare actuals vs. estimates, address issues early.

From the second project onwards, you'll have a template and reference unit price data — making estimation much faster and more accurate.

Frequently Asked Questions