---
title: "Budget Tracking Tool for a Small Interior Design Studio"
date: 2026-11-18
lang: en
url: https://archiboard.design/blog/budget-tracking-tool-interior-design-studio
---

# Budget Tracking Tool for a Small Interior Design Studio

A good budget tracking tool for an interior design studio keeps five numbers for every project in one place: the approved budget, the current estimate, client payments, supplier payments and the expected studio earnings. A well-built spreadsheet can do this for a few projects. A dedicated tool pays off once advances, several suppliers and parallel projects start to overlap. The method below works with either, and you can start it today without buying anything.

## The five numbers every project budget needs

Most budget problems in small studios do not come from missing software. They come from mixing up different numbers: what the client approved, what the estimate says now, what the client has paid, what has left the account and what the studio keeps. Track these five separately and most surprises disappear.

| Number | Question it answers | Source |
| --- | --- | --- |
| Approved budget | How much has the client agreed to spend? | Signed proposal or written confirmation |
| Current estimate (client prices) | Where is the project heading right now? | Estimate with all approved and proposed items |
| Client payments | How much money has actually arrived? | Bank records, one line per payment |
| Supplier payments | How much has gone out, and what is still owed? | Invoices and receipts, one line per payment |
| Studio earnings | What will the studio keep when the project ends? | Client price minus purchase cost, plus any fees or commissions |

### A worked example

Take a living-and-kitchen project with an approved budget of 48,000 EUR. The current estimate at client prices is 51,200 EUR, so the project is 3,200 EUR over budget (about 6.7%). The purchase cost of all items is 41,000 EUR, so expected earnings are 10,200 EUR, or about 19.9% of the client price.

The client has paid 30,000 EUR and you have paid suppliers 21,500 EUR. The difference of 8,500 EUR is a free balance, not profit. You still owe suppliers 19,500 EUR and still expect 21,200 EUR from the client. Keep these two views apart: the budget view tells you about overspending, and the cash view tells you whether you can pay the next invoice.

## How to set up budget tracking in seven steps

1. **Fix the approved budget and its currency.** Write down the amount, what it includes (furniture, lighting, finishes, fees) and what it excludes. If a client approves a range, record the upper limit.
2. **Split the budget by room or category.** A total of 48,000 EUR is hard to control. Kitchen 18,000, living room 20,000, hallway 5,000 and reserve 5,000 is easy to check against the estimate.
3. **Give every item the same fields.** At minimum: room, name, quantity, supplier, purchase price, client price, status. Use the same markup logic across items. If you are unsure about it, test it with a [markup calculator](/tools/markup-calculator) before you quote.
4. **Log every payment as its own line.** Date, direction (client to studio, or studio to supplier), amount, and the item or invoice it covers. Do not overwrite a total; add a line.
5. **Mark advances as advances.** A 50% prepayment to a supplier is not a completed purchase. Record the remaining balance and its due date so it appears in your cash view.
6. **Calculate the five numbers on a fixed day.** Once a week is enough for most studios. Compare the estimate with the approved budget and the free balance with the next supplier invoices.
7. **Set a trigger for talking to the client.** Decide in advance when you raise a budget conversation, for example when the estimate exceeds the approved budget by any amount, or when one room is over its share. A rule you chose beforehand is easier to follow than a judgement call under pressure.

## Choosing a tool: spreadsheet, accounting package or project tool

Studios usually start with what they already have. Each option covers part of the picture.

| Approach | Cost | Works well for | Weak spots |
| --- | --- | --- | --- |
| Spreadsheet | Low or none | One to three projects, one person maintaining it | Formulas break, versions multiply, no link between estimate, payments and deadlines |
| Accounting package | Monthly subscription | Invoices, bookkeeping, reporting to an accountant | Does not know your items, rooms or approvals, so it cannot show project-level overspend |
| Messengers and email only | None | Nothing beyond a single small purchase | Payments and approvals are scattered, and reconstructing the balance takes hours |
| Project tool built for design studios | Free tier or subscription | Several projects, shared work, advances and supplier tracking | Needs a one-time migration of existing estimates |

If you are weighing the first option against a dedicated tool, this [comparison with spreadsheets](/compare/excel-google-sheets) lists the practical differences.

### Signs you have outgrown a spreadsheet

- You keep more than one copy of the estimate and are not sure which is current.
- A colleague edits the same file and you cannot see who changed a price.
- You find out about an unpaid supplier balance from the supplier, not from your own records.
- Building the client's payment report takes more than a few minutes.
- You cannot say, for a given project, how much you have earned so far without an hour of work.

## Weekly budget review checklist

Fifteen minutes per active project is usually enough if the data is current. Run through this list on the same day each week.

- Is the estimate within the approved budget, and within each room's share?
- Were all new items added with both purchase price and client price?
- Are all client payments received this week recorded?
- Are all supplier payments and advances recorded, with the remaining balance and due date?
- Which supplier invoices fall due in the next two weeks, and is the free balance enough to cover them?
- Are there items still waiting for a price from the supplier?
- Have rejected or replaced items been removed from the totals?
- Has any commission or discount share owed to the studio been requested?
- Does the expected earnings figure still match your target margin?

### Mistakes that distort the numbers

- **Treating the free balance as profit.** Money in the account may already be committed to open supplier balances.
- **Counting rejected or optional items.** They inflate the estimate and hide the real position against the budget.
- **Changing a price without a trace.** When the client asks why the total moved, you need the history.
- **Mixing currencies in one column.** If items are priced in different currencies, convert to the project currency in a consistent way and note the rate you used.
- **Leaving the reserve outside the budget.** Quantity reserves for tiles or flooring and a contingency line belong in the plan from the start.

## How to do it in ArchiBoard

ArchiBoard keeps the estimate, supplier payments and project finances connected, so the five numbers update from the same data. The steps below follow the [project finance feature](/features/project-finance); the [projects chapter in the help center](/help/projects) covers the project setup in more detail.

1. On the home page click "New Project", then enter the name, city and your studio's role in the project.
2. Open the project and go to "Project Finances". Fill in the finance settings: studio role, how you earn (commission, markup or share of supplier discount), who pays whom ("Client → Supplier" or "Client → Studio → Supplier"), project currency and approved budget.
3. In "Rooms", check each room card. It shows "Budgeted", "Left" or "Over budget" so you can see overspending by room. The budget can be allocated by room in the finance settings.
4. In "Estimates", switch the view to "Economics" to see supplier discount, procurement price, markup, profit and client price for each item. The client does not see these columns in the PDF export or on the portal unless you enable them.
5. Record client payments and supplier payments as transactions in "Project Finances". Supplier payments are grouped by supplier.
6. For part payments, open "Vendor & payment" on the item row, go to "Supplier payment" and check "This is an advance". The [supplier payment guide](/help/how-to/supplier-payment) walks through it.
7. From a payment, generate a PDF: an invoice to the client, an invoice to the supplier for commission, or a report to the client. Studio details are taken from your profile settings.
8. Check the home page for the totals across all projects: budget, client payments, supplier payments, profit and free balance.

If the estimate goes above the approved budget, a warning appears. Supplier commission is tracked in three states (accrued, requested, received), and the system creates a task to request it. A combined "Finances" item for all projects in the main menu is marked as coming soon, so use the home page for cross-project totals for now. The Free plan allows up to 20 items and 2 participants, which is enough to test the workflow on a small project.

## FAQ

### What is the simplest way to track an interior design project budget?

Keep one estimate with purchase and client prices, plus a payment log with one line per payment. From these two sources calculate five numbers weekly: approved budget, current estimate, client payments, supplier payments and expected earnings. A spreadsheet is enough for this on a small scale, as long as there is only one current version.

### How do I know whether a project is making money before it ends?

Subtract the total purchase cost from the total client price of approved items, then add fees or commissions. This is expected earnings. Do not use the account balance for this: it includes money already owed to suppliers. Recalculate when items are added, rejected or replaced.

### Do I need accounting software to track project budgets?

Not for project budgets. Accounting software records invoices and payments for bookkeeping, but it does not know your rooms, items or approvals. Many studios use a project-level tool or spreadsheet for budget control and pass the payment records to their accountant separately.

### How often should I update the budget tracker?

Record payments and approvals as they happen, and review the five numbers once a week. During active procurement, when many orders and advances are placed, a short review twice a week helps. Updating only at the end of the month usually means you discover overspending too late to discuss it with the client.

### How should I handle items priced in different currencies?

Choose one project currency and convert every item into it in a consistent way. Record the original currency and amount next to the converted price so you can explain differences later. Check converted totals again when large supplier payments are due, because rates can shift between quoting and paying.

### Should clients see the budget tracking?

Clients should see their own side: the estimate, what they have paid and what is still due. Keep purchase prices, markup and profit internal. Showing a clear client-facing payment schedule and approved items reduces disputes without exposing how the studio earns.
