How to import your budget into Hemma

01What you need

An Excel file (.xlsx or .xls) or a CSV with your construction budget. That's it.

Most users import their architect's cost estimate or a spreadsheet they built themselves. Both work. Your columns don't need specific names. Hemma figures them out automatically.

The maximum file size is 10 MB. For most construction budgets, that's more than enough.

02How the import works

Go to Budget → Import from Excel. The wizard walks you through it:

1. Upload. Drop your file or click to select it. Hemma accepts .xlsx, .xls, and .csv.
2. Pick a sheet. Multiple sheets in your Excel? Pick the one with your budget. Only one sheet? You'll skip this step.
3. Map your columns. Hemma reads your column headers and suggests mappings: code, name, description, quantity, unit, estimated, budgeted. Check the suggestions and adjust where needed.
4. Confirm the structure. Hemma detects your hierarchy: categories, subcategories, and line items. Think: chapter 1, article 1.2, item 1.2.3. You can correct the result if it's off.
5. Review and import. You see a preview of your budget tree, with any warnings highlighted. Confirm, and Hemma writes your budget. Once it's in, you can map invoices and quotes against it.

03What AI does during import

Column mapping. Hemma reads your column headers and recognises which column is the code, which is the name, the estimated amount, and so on. You see the suggestions and can override them. You always have the final say.

Structure detection. Hemma analyses your codes and indentation to understand the hierarchy of your budget. For example: 1.2.3 = chapter 1, article 2, item 3. If your budget uses a different structure, you can indicate that.

Both steps are suggestions. Hemma helps, but you decide. If the AI gets it wrong, you correct it with a few clicks.

04What happens after import

Your budget is live. And from now on, something fundamental changes in how Hemma works for you:

• Every invoice and quote you upload or forward is automatically linked to a budget line.
• The Budget page shows estimated vs. budgeted vs. quoted vs. invoiced, in real time.
• Signal colours tell you at a glance what's on track and what needs attention.
• Your partner or project collaborator sees the same numbers, always up to date, without you having to forward anything.

In short: your budget becomes a living document. No more static spreadsheet. A real-time overview of your entire construction project.

05No budget file? No problem

Not everyone starts with a ready-made Excel file. That's fine. Add categories and items manually on the Budget page. Start with the big categories (shell construction, technical installations, finishing) and fill in as your project progresses.

You can always import later. Hemma will still link all previously uploaded invoices and quotes to your budget lines.