Filter Spend Reporting for Multi-Site Portfolios: What Data to Track

For facility managers and property managers, filter spend reporting is most useful when it shows more than a single invoice total. Across a multi-site portfolio, the real value comes from consistent data that lets you compare sites, understand why filters were replaced, and see where labour, freight or product choice is affecting the job.

If each site records the same core fields, reporting becomes practical rather than administrative. It also makes it easier to order the right product again, manage stock, and support servicing decisions with clear records.

Start with clean site identification

The first field to standardise is the site itself. It sounds simple, but many portfolios have naming differences that make reporting messy: shortened site names, legacy labels, or separate names for the same building in different systems.

Use a consistent site identifier that stays the same across purchase orders, service reports and invoices. Where useful, include:

• •Site name
• •Site code or asset ID
• •Address or campus name
• •Building or tenancy name
• •State or region

If your portfolio includes multiple properties under one owner or manager, grouping by portfolio, business unit or region can also help you compare patterns without losing site-level detail.

Record the system type, not just the filter type

A filter SKU tells you what was supplied, but not always where it was installed or why it was chosen. For reporting that supports future planning, capture the system type as well.

Helpful system fields include:

• •HVAC air handling unit
• •Packaged unit
• •Split system with return air filtration
• •Dust extraction or process ventilation
• •Fresh air intake
• •Critical or high-spec filtration application
• •Kitchen or odour control application

It can also help to note the filter stage or location within the system, such as pre-filter, final filter, intake filter or return air filter. That makes it easier to review whether a site is using the same product in different positions or whether a change in system setup has altered spend.

For sites where filtration is tied to ventilation design, it is worth checking the equipment requirements and, where relevant, confirming site needs with the mechanical services engineer or building owner. If you need product guidance, our products and custom air filters can help narrow the options.

Capture SKU, size and specification details

The filter SKU is central to spend reporting because it lets you track product-level usage over time. But a SKU alone is not always enough, especially when the same site uses several filter sizes or grades.

Include fields such as:

• •SKU or product code
• •Filter dimensions
• •Media type or construction type
• •Frame material
• •Efficiency or rating class used on the job ticket
• •Quantity supplied
• •Unit cost and extended cost, if you track pricing internally

Where possible, keep the naming format consistent with the way the product is ordered. If your team measures on site, it helps to use a standard method so the recorded size matches what is actually needed. If that is an issue in your portfolio, how to measure an air filter is a useful internal reference.

Be careful when comparing ratings across different standards. MERV, EN 779 and ISO 16890 do not convert directly, so avoid trying to force a simple crosswalk into reporting fields. If your site requires HEPA filtration, record the exact class used, such as H13 or H14, rather than a vague “HEPA” label.

Track labour separately from product spend

Labour is often blended into a service invoice, which makes it hard to see whether spending is driven by product choice, access issues or time on site. For portfolio reporting, separate labour from filter supply wherever possible.

Useful labour fields include:

• •Labour hours or visit duration
• •Number of technicians
• •Standard service labour
• •After-hours or scheduled shutdown work
• •Call-out or urgent attendance
• •Access delays or restricted access notes
• •Disposal or clean-up labour, where applicable

This is especially useful when the same filter SKU appears on multiple sites but labour costs vary widely. The difference may be due to roof access, tenancy access windows, plant room layout, or the need to isolate equipment before servicing.

If your portfolio includes sites with variable service requirements, a structured service record can make filter servicing or commercial filter servicing easier to manage across the board.

Log freight, delivery method and stock handling

Freight is another field that gets overlooked until the spend report is reviewed. On a multi-site portfolio, freight can vary because of location, order size, packaging, urgent dispatch or direct-to-site delivery.

Track freight in a way that lets you distinguish between:

• •Standard freight
• •Direct site delivery
• •Consolidated delivery to a depot or head office
• •Urgent dispatch
• •Split delivery across multiple sites
• •Packaging or handling charges, if shown separately

If filters are being sent to a central store before distribution, record that path too. It can explain why the invoice looks different from the service sheet and help you decide whether ordering direct to site or through a depot is more efficient from an operational perspective.

For portfolios with multiple buildings or branches, freight data can also reveal whether some sites are receiving small, repeated orders that would be easier to combine.

Note why the filter was replaced

Replacement reason is one of the most useful fields you can track, because it turns spend data into operational information. Without it, all replacements look the same, even though the cause may vary from site to site.

Common replacement reason fields might include:

• •Routine inspection change-out
• •Pressure drop or airflow issue
• •Visible dust loading
• •Physical damage
• •Water exposure or moisture damage
• •Odour complaint or contamination concern
• •Maintenance access or contractor direction
• •Failed fit or incorrect size
• •Upgrade or specification change

If your maintenance team records pressure drop where gauges are fitted, that reading should be linked to the replacement record. It helps show whether the filter was changed because of system condition or because the servicing team was already on site for another task.

Where the cause is not obvious, add a short note field rather than leaving it blank. A few words such as “external dust load”, “construction nearby” or “post-tenant fit-out” can be useful when you review patterns later.

Build reporting that supports decisions, not just invoices

A useful filter spend report should help you answer practical questions:

• •Which sites spend the most on a specific filter SKU?
• •Are some locations paying more freight because orders are too small or too urgent?
• •Which systems are using the same product for different reasons?
• •Where does labour take longer than expected?
• •Which replacement reasons are most common at each site?

Once the fields are standardised, you can sort by site, system type, product code or reason and start to spot variation that deserves attention. That might lead to better stock planning, clearer site notes, or a change in the way servicing is scheduled and recorded.

For sites with ventilation requirements, it is also worth checking whether the current setup still matches the building’s needs and the relevant system design expectations. AS 1668.2:2024 is a useful reference point for ventilation-related discussions, but site requirements should always be confirmed with the mechanical services engineer or building owner.

Keep the field list simple enough to use every time

The best reporting fields are the ones technicians and administrators will actually complete. Too many categories slow the process down, while too few make the report hard to analyse.

A practical minimum set is usually:

• •Site
• •System type
• •SKU
• •Quantity
• •Labour
• •Freight
• •Replacement reason
• •Date
• •Notes

If you manage more specialised sites, you can add fields such as filter stage, pressure drop reading, access notes, and disposal method. Some filters are designed to be washable, but check the product instructions before assuming a reusable product is suitable for your site.

Need filters supplied or made to match your reporting needs?

If you want cleaner portfolio reporting, it helps to pair good data fields with the right product range and sizing support. Total Air Filtration is a family-owned air filter manufacturer and supplier in Hillcrest, Brisbane QLD, and we can help supply standard products or make filters to suit your requirements.

Call 07 3800 3448 or request a quote. You can also browse our products or get in touch through contact us.