---
title: Parts Consumption by Location (Report)
description: Download a report of the parts each warehouse and service van used over a date range, with optional location and asset sub-type filters.
---
[Skip to content](https://support.metafleet.ai/parts-consumption-report#main-content)
English
Show submenu for translations
Open main navigation
Close main navigation
- English
Show submenu for translations
- [Contact us](mailto:support@metafleet.ai)
[Contact us](mailto:support@metafleet.ai)
How can we help you?
- There are no suggestions because the search field is empty.
1. [MetaFleet Answer Hub](https://support.metafleet.ai/?hsLang=en)
2. [Parts, Inventory & Vendors](https://support.metafleet.ai/parts-inventory-vendors?hsLang=en)
3. [Reports](https://support.metafleet.ai/parts-inventory-vendors?hsLang=en#reports)
# Parts Consumption by Location (Report)
## Download a CSV of the parts each warehouse and service van used over a date range, to spot usage and plan restocking.
**For:** Managers, dispatchers and inventory staff · **Permission:** Request Reports (View Reports to download; Inventory View Cost for the cost columns) · **Time:** ~2 minutes
### Quick summary
1. Open **Reports** in the left menu, on the **Generate** tab.
2. Set the **Start Date** and **End Date**.
3. Choose **Parts Consumption by Location**, then pick locations or asset sub-types if you want to narrow the result.
4. Click **Generate Report**, then click **Download** in the **History** tab when the status is **Ready**.
### Before you start
- The report counts parts that were installed on a job (consumed), deducted automatically when a job closed, or issued by hand for a job. It also counts ad-hoc and special-order parts billed on jobs. It does not count parts that are only reserved for a job. For the difference, see [Understanding Available, Allocated and Consumed](https://support.metafleet.ai/understanding-available-allocated-and-consumed?hsLang=en).
- The report covers inventory locations: warehouses, service vehicles and consignment stock kept at a customer's site. See [Track Inventory on Service Vehicles](https://support.metafleet.ai/track-inventory-on-service-vehicles?hsLang=en).
### Set the date range
In the left menu, open the **Reports** group and click **Reports**. On the **Generate** tab, section **A · Global Filters** sets the dates. Change **Start Date** and **End Date**, or click **Reset to last 30 days**. Both days are included in full, in your time zone.
> The **State** and **Locations** filters in this section don't change this report, even though the section says they apply to every report. Use the **Inventory locations** filter in the next step instead.
### Choose the report and filters
In section **B · Report**, open **Which report?** and choose **Parts Consumption by Location**. Section **C · Additional Filters** then shows two optional filters:
- **Inventory locations:** pick one or more warehouses or service vehicles. Each one is labeled with its type.
- **Asset sub-types (filter):** pick one or more types of customer equipment, such as Dozer or Excavator. This list only appears when your shop has asset sub-types.
Leave a filter empty to include everything.
> **Asset sub-types drops older records.** Picking a sub-type keeps only parts used on a serviced vehicle of that sub-type. Consumption with no vehicle link, such as older transactions, is left out.
### Generate the report
Click **Generate Report**. The report runs in the background, so you can keep working. The page switches to the **History** tab, where the report shows its status in the first row.
### Download the file
When the status shows **Ready**, click **Download** on its row. You get a CSV file named like `PartsConsumption_2026-09-15_to_2026-10-15.csv`. It opens in Excel or Google Sheets.
### Read the results
The first line of the file is the title and date range. After it, each row is one part at one location, with the total used in the date range. Rows are sorted by location, then part number.
| Column | What it shows |
| --- | --- |
| Location | The warehouse or service vehicle the parts came from |
| Location Type | Warehouse, Service Van or Consignment. Blank for **(Ordered for the job)** rows. |
| Part # | The part number |
| Part Name | The part name |
| Qty Consumed | Total quantity used in the date range |
| Unit Cost | The cost per unit, averaged over the quantity used. It uses the cost recorded when the part was used, or the catalog cost if none was recorded. For job-ordered rows, see the cost order below the table. |
| Total Cost | The cost of all the units used. It is blank when no cost is known for a part. |
Ad-hoc and special-order parts were never in stock, so they appear under the location **(Ordered for the job)**. They count in the date range in which the job's invoice was first sent. Parts on preventive maintenance and inspection invoices count the same way, by the date the invoice was sent. Their cost is the cost recorded on the service order line, or the purchase order cost if it has none, or the catalog cost.
The last row, **TOTALS**, adds up the quantity and the cost. Rows with a blank **Total Cost** add nothing to the cost total.
> **Filtering by location hides job-ordered parts.** When you pick an inventory location, the **(Ordered for the job)** rows are left out, because those parts were never at a location. Leave **Inventory locations** empty to include them.
> **No cost columns?** **Unit Cost** and **Total Cost** only appear if you have the permission to view inventory cost when you click **Generate Report**. Ask an admin to grant it, then generate the report again.
### Troubleshooting
| Symptom | Likely cause | Fix |
| --- | --- | --- |
| The file has only a TOTALS row with 0 | No parts were consumed at the chosen locations, or no job invoices were sent, in that date range | Widen the dates or clear the location filter, then generate again. |
| Parts I used are missing | A location filter is set (it hides ad-hoc parts), an asset sub-type is selected, or the parts were only reserved, not installed | Clear **Inventory locations** and **Asset sub-types (filter)**. Check that the job's parts were installed or the job was closed. |
| No Unit Cost or Total Cost columns | You didn't have the permission to view inventory cost when you generated the report | Get the permission, then generate the report again. |
| The report row doesn't show Download yet | It's still running | Wait on the **History** tab until the status is **Ready**. |
| Generate works, but there is no History tab or Download | You have Request Reports without View Reports | Ask an admin to grant View Reports. |
| No Asset sub-types filter shows | Your shop has no asset sub-types | Use the location filter, or leave the report unfiltered. |
### FAQs
**Does the report include parts that are only reserved for a job?**
No. It counts consumed parts: installed on a job, deducted automatically when a job closes, or issued by hand for a job. It also counts ad-hoc and special-order parts billed on jobs.
**Can I report on one service van?**
Yes. Pick that van in **Inventory locations**.
**Where is the stock movement behind a number?**
In the part's inventory transactions. See [Inventory Transactions and Transfers](https://support.metafleet.ai/inventory-transactions-and-transfers?hsLang=en).
**Why is an ad-hoc part missing from the file?**
Its job's invoice may not be sent yet, or you filtered by location. Send the invoice, or clear **Inventory locations**, then generate again.
### Related articles
- [Understanding Available, Allocated and Consumed](https://support.metafleet.ai/understanding-available-allocated-and-consumed?hsLang=en)
- [Track Inventory on Service Vehicles](https://support.metafleet.ai/track-inventory-on-service-vehicles?hsLang=en)
- [Inventory Transactions and Transfers](https://support.metafleet.ai/inventory-transactions-and-transfers?hsLang=en)
- [Start Here](https://support.metafleet.ai/start-here?hsLang=en)
- [Companies & Contacts](https://support.metafleet.ai/companies-contacts?hsLang=en#main-content)
- [Create/Edit Companies](https://support.metafleet.ai/companies-contacts?hsLang=en#create-edit-companies)
- [Contacts](https://support.metafleet.ai/companies-contacts?hsLang=en#contacts)
- [Vehicles](https://support.metafleet.ai/companies-contacts?hsLang=en#vehicles)
- [Work Intake (Requests & Service Orders)](https://support.metafleet.ai/work-intake-requests-service-orders?hsLang=en#main-content)
- [Creating Service Orders](https://support.metafleet.ai/work-intake-requests-service-orders?hsLang=en#creating-service-orders)
- [Customer & Partner Requests](https://support.metafleet.ai/work-intake-requests-service-orders?hsLang=en#customer-partner-requests)
- [Reference](https://support.metafleet.ai/work-intake-requests-service-orders?hsLang=en#reference)
- [Customer Portal](https://support.metafleet.ai/work-intake-requests-service-orders?hsLang=en#customer-portal)
- [Estimates & Approvals](https://support.metafleet.ai/estimates-approvals?hsLang=en#main-content)
- [Approval Gates](https://support.metafleet.ai/estimates-approvals?hsLang=en#approval-gates)
- [Estimates](https://support.metafleet.ai/estimates-approvals?hsLang=en#estimates)
- [Invoices](https://support.metafleet.ai/estimates-approvals?hsLang=en#invoices)
- [Billing](https://support.metafleet.ai/estimates-approvals?hsLang=en#billing)
- [Parts, Inventory & Vendors](https://support.metafleet.ai/parts-inventory-vendors?hsLang=en#main-content)
- [Add Parts & Kits](https://support.metafleet.ai/parts-inventory-vendors?hsLang=en#add-parts-kits)
- [Stock & Counts](https://support.metafleet.ai/parts-inventory-vendors?hsLang=en#stock-counts)
- [Locations & Bins](https://support.metafleet.ai/parts-inventory-vendors?hsLang=en#locations-bins)
- [Purchase Orders](https://support.metafleet.ai/parts-inventory-vendors?hsLang=en#purchase-orders)
- [Parts Catalog](https://support.metafleet.ai/parts-inventory-vendors?hsLang=en#parts-catalog)
- [Vendors & Manufacturers](https://support.metafleet.ai/parts-inventory-vendors?hsLang=en#vendors-manufacturers)
- [Pricing](https://support.metafleet.ai/parts-inventory-vendors?hsLang=en#pricing)
- [Service Vehicles](https://support.metafleet.ai/parts-inventory-vendors?hsLang=en#service-vehicles)
- [Sourcing & Hand-Off](https://support.metafleet.ai/parts-inventory-vendors?hsLang=en#sourcing-hand-off)
- [Part Numbers](https://support.metafleet.ai/parts-inventory-vendors?hsLang=en#part-numbers)
- [Notifications](https://support.metafleet.ai/parts-inventory-vendors?hsLang=en#notifications)
- [Reports](https://support.metafleet.ai/parts-inventory-vendors?hsLang=en#reports)
- [Invoicing & Payments](https://support.metafleet.ai/invoicing-payments?hsLang=en)
- [Dispatch & Scheduling](https://support.metafleet.ai/dispatch-scheduling?hsLang=en#main-content)
- [Preventative Maintenance](https://support.metafleet.ai/dispatch-scheduling?hsLang=en#preventative-maintenance)
- [Technician Assignment](https://support.metafleet.ai/dispatch-scheduling?hsLang=en#technician-assignment)
- [Scheduling & Calendar](https://support.metafleet.ai/dispatch-scheduling?hsLang=en#scheduling-calendar)
- [Technician Schedule](https://support.metafleet.ai/dispatch-scheduling?hsLang=en#technician-schedule)
- [Technicians & Mobile App](https://support.metafleet.ai/technicians-mobile-app?hsLang=en#main-content)
- [Time Tracking](https://support.metafleet.ai/technicians-mobile-app?hsLang=en#time-tracking)
- [Tech Workflow](https://support.metafleet.ai/technicians-mobile-app?hsLang=en#tech-workflow)
- [Evidence & Photos](https://support.metafleet.ai/technicians-mobile-app?hsLang=en#evidence-photos)
- [AI Assistant](https://support.metafleet.ai/technicians-mobile-app?hsLang=en#ai-assistant)
- [Alerts, Alarms & Notifications](https://support.metafleet.ai/alerts-alarms-notifications?hsLang=en#main-content)
- [Email/SMS/App Settings](https://support.metafleet.ai/alerts-alarms-notifications?hsLang=en#email-sms-app-settings)
- [Reporting & Dashboards](https://support.metafleet.ai/reporting-dashboards?hsLang=en)
- [Admin & Settings](https://support.metafleet.ai/admin-settings?hsLang=en#main-content)
- [Rates & Fees](https://support.metafleet.ai/admin-settings?hsLang=en#rates-fees)
- [Branding](https://support.metafleet.ai/admin-settings?hsLang=en#branding)
- [Roles, Permissions & Users](https://support.metafleet.ai/admin-settings?hsLang=en#roles-permissions-users)
- [Service Areas](https://support.metafleet.ai/admin-settings?hsLang=en#service-areas)
- [Workflows](https://support.metafleet.ai/admin-settings?hsLang=en#workflows)
- [Taxes](https://support.metafleet.ai/admin-settings?hsLang=en#taxes)
- [Integrations](https://support.metafleet.ai/admin-settings?hsLang=en#integrations)
- [Integrations](https://support.metafleet.ai/integrations?hsLang=en#main-content)
- [Phone Setup](https://support.metafleet.ai/integrations?hsLang=en#phone-setup)
- [AI Assistant Access](https://support.metafleet.ai/integrations?hsLang=en#ai-assistant-access)
- [QuickBooks](https://support.metafleet.ai/integrations?hsLang=en#quickbooks)
- [Getting Around](https://support.metafleet.ai/getting-around?hsLang=en#main-content)
- [Search & Command Bar](https://support.metafleet.ai/getting-around?hsLang=en#search-command-bar)
[](http://www.metafleet.ai)
[mailto:support@metafleet.ai](mailto:support@metafleet.ai)
Copyright © 2025, MetaFleet, Inc