Excel / VBA
Construction site dashboard
Excel workbook with VBA macros for complete job tracking: quote creation, hours tracking per intervention, automatic billing calculation, client reminders and monthly summary dashboard.
ExcelVBAMacros
Dashboard · Overview
4Active jobs
CHF 11 550Revenue in progress
147hHours logged
JobClientAmountHoursStatus
Dupont Villa – TilingMr DupontCHF 3 20042hactive
Lefèvre Properties – PlumbingLefèvre PropertiesCHF 1 45018hactive
Martin Flat – ElectricalMrs MartinCHF 2 10031hdone
Town Hall – Room paintingSt-Paul Town HallCHF 4 80056hactive
01
Main dashboard — overview of ongoing jobs
Job sheet · Dupont Villa – Tiling
Work log
DateWorkHours
12/11Remove old tiles8h
13/11Floor preparation7h
14/11Living room tiling8h
15/11Kitchen tiling7h
18/11Grouting + finishing12h
Materials
ItemCost
Tiles 60×60 (28m²)CHF 840
Tile adhesive 25kg×4CHF 120
Grout 5kg×6CHF 48
AccessoriesCHF 35
Materials totalCHF 1 043
02
Job sheet — hours, materials and progress detail
Quote generator · VBA macro
New quote — No. QUO-2024-047
Client
Leblanc Properties
Date
28/11/2024
Job
Bathroom renovation
Valid for
30 days
ServiceQtyUnit priceTotal
Remove old bathtub1CHF 250CHF 250
Supply + fit shower1CHF 680CHF 680
Floor tiling (4m²)4CHF 55CHF 220
Wall painting1CHF 180CHF 180
Total excl. VAT: CHF 1 330
Total incl. VAT: CHF 1 437.75
03
Quote generator — professional template in one click
Invoice tracking · November 2024
CHF 8 240Collected
CHF 3 310Pending
CHF 0Overdue
InvoiceClientAmountDueStatus
INV-044Mr DupontCHF 3 20030/11paid
INV-045Mrs MartinCHF 2 10002/12paid
INV-046Town HallCHF 2 94015/12sent
INV-047Lefèvre PropertiesCHF 1 45020/12pending
04
Billing tracker — payment status and automatic reminders
Monthly report · November 2024
Monthly revenue
CHF 11 550Gross revenue
147hHours
CHF 78.57Hourly rate
Oct 2024CHF 9’200
Nov 2024CHF 11’550
Avg 2024CHF 8’400
05
Monthly report — revenue summary and profitability analysis
Ce type de projet vous intéresse ?
Démarrer un projet similaire