🏗 Construction Budget Tracker

Download the Excel template, fill in your project details on the Setup sheet, add your trade categories and budgets on the Categories sheet, and log each invoice on the Invoices sheet. Then import the file here and the tracker will visualise everything automatically.

Yes. In the Categories sheet of the Excel file, simply add a new row with your category name and budget. You can also add categories directly in the tracker using the sidebar form. The import will pick up any categories defined in your file.

No. All processing happens entirely in your browser using JavaScript. Nothing is sent to any server. Your construction data stays on your device.

Over-budget categories are highlighted in red in the progress bars and counted in the summary stat card at the top. The tracker shows you exactly how much over budget each trade is.

Yes. After making changes in the tracker, click Export to Excel in the sidebar to download an updated .xlsx file with all your categories and invoices in the same template format.

The tracker defaults to EUR (€) but you can switch to USD ($), GBP (£), or CHF in the project setup sidebar. The currency symbol is cosmetic — change it to match your project.

No. Everything lives only in this browser tab's memory — refreshing the page, closing the tab, or navigating away clears your categories and invoices. Click Export to Excel regularly to save a real file, then re-import it next time you want to keep working.

Pending means an invoice hasn't been paid yet. Overdue is a separate status you set manually for invoices that have passed their due date. Both are tracked separately from Paid, with their own colour-coded badge — yellow for pending, red for overdue, green for paid.

Enter each invoice amount excluding VAT, then set that invoice's VAT % separately — the tracker calculates the VAT and gross total for you. Budget-vs-actual comparisons use the gross, VAT-included amount, since that's what actually leaves your account.

Yes. Click Print in the toolbar to generate a print-friendly report combining the budget-vs-actual overview and the full invoice log, with paid/pending/overdue badges preserved — handy for sharing with a partner, bank, or accountant.

No. The tracker uses SheetJS, an open-source JavaScript library, to read your .xlsx file entirely inside your browser tab. The library's code loads from a CDN, but your spreadsheet's contents never leave your device — there's no server-side upload or processing.

Each browser tab tracks a single project at a time. To manage several builds, export each one to its own Excel file and re-import the relevant file whenever you want to switch between projects — your data stays organised as separate spreadsheets rather than mixed together.

Yes. Click any invoice row to edit its details, or use the delete icon next to a category or invoice to remove it. Changes are reflected immediately in the stat cards and progress bars, and carry over the next time you export to Excel.

Three sheets: Setup (project name, total budget, currency, VAT %, start/end dates), Categories (trade name + budget per row), and Invoices (Date, Supplier, Category, Amount excl. VAT, VAT %, Status, Notes). Download the template first if you're starting from scratch — it already has the correct headers.

Yes, the layout adapts to smaller screens so you can log an invoice from your phone on site. For importing or exporting Excel files, use whichever mobile browser your phone's file picker supports — both mobile Safari and Chrome work.

Completely free, no sign-up, no ads, no watermark. It's one of the free browser-based tools at jasperbernaers.com.