Excel HVAC Asset and Maintenance Manager
Excel HVAC Asset and Maintenance Manager: manage HVAC assets, preventive maintenance, work orders, labour, parts, stock, costs, documents, condition and replacement planning in one connected Microsoft Excel desktop system.
- Build a structured multi-site HVAC asset register
- Organise assets by site and location
- Search assets by site, type, status and condition
- Record complete technical and lifecycle information for each asset
Digital download. The GBP listing price is taken from the supplied Etsy export, not a live checkout quote. Etsy confirms the final price, discounts, tax and currency before payment.
Requires Microsoft Excel desktop for Windows with macros enabled. The product is supplied as macro-enabled .xlsm workbooks inside a ZIP download package. The forms, navigation, calculations and automation depend on VBA and will not operate correctly in Excel Online, Google Sheets, Excel mobile or Apple Numbers. Mac compatibility is not guaranteed. The product is best suited to users with basic Microsoft Excel knowledge and permission to open trusted macro-enabled workbooks. The buyer should extract the ZIP package before opening the workbook and keep an untouched backup copy before entering live data.
Key features of the Excel HVAC asset and maintenance manager
Professional laptop-friendly Excel VBA interface
Multi-site Site → Location → Asset hierarchy
Searchable HVAC Asset Manager
Detailed asset records with seven information tabs
Asset Types with expected life and default maintenance settings
Maintenance templates and reusable task checklists
Preventive Maintenance Plans with due-date calculations
Automatic PM Work Order generation
Duplicate open Work Order prevention
Central Work Order completion screen
Task checklist, reading, pass/fail and defect recording
Labour hour and cost calculations
Parts Used with required, reserved, issued and returned quantities
Other Work Order costs and contractor expenses
Document and evidence management
Parts Register with supplier and storage information
Stock receipt, issue, return and adjustment transactions
Transaction-ledger calculation of Current Stock
Faults and repair history
Condition assessments
Simplified End-of-Life replacement planning
Replacement score, priority, cost and target year
Maintenance Dashboard with KPI cards
System Settings and configurable lookup lists
Audit Log of saved activity
Built-in workbook backup
Clean and demonstration workbooks included
Detailed customer user manual included
How it works
How to use HVAC Asset & Maintenance Manager
Download and extract the supplied ZIP package
Open the demonstration workbook to explore the workflow
Open the clean workbook when ready to enter live information
Enable macros when prompted by Microsoft Excel
Configure company details and system settings
Review and customise the lookup lists
Add sites and their locations
Add engineers, suppliers and contractors
Register each HVAC asset at the correct site and location
Create maintenance templates and task checklists
Assign Preventive Maintenance Plans to assets
Allow due PM plans to create scheduled Work Orders
Open each Work Order to complete tasks and record labour
Add parts used, other costs and supporting documents
Complete the Work Order to update the PM Plan and asset history
Review parts, stock movements and reorder information
Record faults, repairs and condition assessments
Assess ageing assets using the End-of-Life workflow
Review Dashboard KPIs and future replacement exposure
Create regular backup copies from the Control Centre
Ideal for
Who this product is designed for
- Small and growing HVAC contractors
- Facilities and estates teams
- Commercial property maintenance departments
- HVAC service and maintenance managers
- Building maintenance teams
- Retail and hospitality maintenance teams
- Schools, offices and public buildings
- Multi-site organisations
- Small maintenance departments
- Businesses replacing paper maintenance records
- Teams replacing disconnected maintenance spreadsheets
- Organisations that need a desktop system without a monthly CMMS subscription
Reports & outputs
Excel HVAC asset and maintenance manager reports
- Live maintenance dashboard with KPI cards
- Searchable multi-site HVAC asset register
- Detailed asset records
- Asset maintenance history
- Asset lifetime maintenance cost
- Preventive maintenance due and overdue status
- Open, scheduled, completed and closed Work Order records
- Work Order task and checklist history
- Labour hours and labour cost history
- Parts usage and Work Order parts cost history
- Other Work Order cost history
- Current, reserved and available stock visibility
- Stock transaction history
- Fault and repair records
- Condition assessment records
- End-of-Life replacement scores and priorities
- Five-year replacement cost exposure
- Document and evidence register
- Audit Log of saved activity
- Workbook backup copies
What you receive
Files and guidance included
- Clean ToolFlowCo HVAC Asset & Maintenance Manager Version 1.0 workbook
- Demonstration workbook with fictional sample data
- Detailed PDF user manual
- Editable Word user manual
- Start Here guidance
- Version history and release notes
- Final testing and setup guidance
- ZIP download package
The Build Story explains the workflow decisions, testing discoveries and improvements made while developing this product.See how this ToolFlowCo system was designed and tested.
Select any image to open the complete 9-image gallery.See the system before you purchase.
Manage products, suppliers, stock movements and reorder levels from one straightforward Access system. Best for: Retail stockrooms Organise receiving, orders, picking, packing, stock counts, quarantine, discrepancies and warehouse actions in one desktop database. Best for: Small warehouses Bring the core admin of a service business into one organised Access database with forms, printable documents and management reports. Best for: Trades and contractorsCompare other ToolFlowCo options.
Microsoft Access Inventory Database for Stock Control and Low Stock Alerts
Microsoft Access Warehouse Management System for Receiving, Picking and Packing
Microsoft Access Service Business Database for Jobs, Quotes and Invoices
Compare this tool and explore the workflow
Before deciding, compare the workflow and read the relevant guidance: Compare workshop and garage management tools; How I Built an Excel HVAC Asset and Maintenance Manager.
Read the supplied-file list and compatibility section on this page. The Etsy listing and licence govern permitted use and any included support or updates; do not assume ongoing upgrades, customisation or a hosted service are included.Purchase and setup essentials
Excel HVAC asset and maintenance manager: practical setup questions
Begin with the site, location and asset hierarchy, then define the planned maintenance and work-order process. Parts, labour and other costs are more useful when they are attributed to the correct work and asset records.
How should the asset structure be prepared?
Agree asset identifiers and the site/location structure before loading the register. Avoid creating several records for the same physical asset just because its description differs between documents. Keep a source copy of the opening register and test the search and location workflow on a small sample.
What should a maintenance test include?
Use an illustrative asset and plan to check work-order generation, task completion and the resulting history. Review labour, parts and other costs against the sample entries. Verify the final asset status in your operating process rather than relying only on the first dashboard view.
How should replacement planning be used?
Condition, end-of-life, replacement and budget records support a structured review. They do not guarantee a particular remaining life or make a professional engineering decision on your behalf. Keep the relevant inspections, operating knowledge and supporting documents alongside the workbook records.
Platform reference: Microsoft guidance on macro security. Platform documentation is separate from this product's supplied requirements and does not add unlisted features.
Review the current listing, supplied files and requirements before purchasing. Ask about any requirement that is not explicitly confirmed. Digital download. The GBP listing price is taken from the supplied Etsy export, not a live checkout quote. Etsy confirms the final price, discounts, tax and currency before payment. Requires Microsoft Excel desktop for Windows with macros enabled.
The product is supplied as macro-enabled .xlsm workbooks inside a ZIP download package. The forms, navigation, calculations and automation depend on VBA and will not operate correctly in Excel Online, Google Sheets, Excel mobile or Apple Numbers.
Mac compatibility is not guaranteed. The product is best suited to users with basic Microsoft Excel knowledge and permission to open trusted macro-enabled workbooks.
The buyer should extract the ZIP package before opening the workbook and keep an untouched backup copy before entering live data.Ready to use HVAC Asset & Maintenance Manager?