Reports and exports in Foreman are essential tools for maintaining accurate inventory and asset records. They provide visibility into your operations, help identify discrepancies, support audits, and allow your team to make informed decisions about asset management and inventory control.

Goal: Reporting cadence established, and the team knows how to access and interpret data.

Asset export completed and reviewed

Inventory export completed and reviewed

Reorder report generated and actionable items identified

At least one scheduled report is configured

Ad hoc report tested with a custom date range

Reports shared with relevant stakeholders

Team trained on when to use each report type

Before diving into the steps, here’s why you might generate reports or exports:

• Audit Preparation: Verify that your Foreman setup matches previous systems or spreadsheets.
• Inventory Accuracy: Ensure all assets and inventory items are uploaded and tracked correctly.
• Operational Planning: Identify offline locations and confirm limits on item quantities.
• Stock Management: Monitor items approaching their reorder thresholds to prevent shortages.
• Compliance and Documentation: Maintain a record of your inventory and asset data for internal or external audits.

By using reports regularly, your organization can maintain operational efficiency, reduce errors, and strengthen internal controls.

Exporting Assets

Asset exports provide a complete snapshot of all items currently recorded in Foreman, making them useful for audits, reconciliation, or reviewing historical data. These exports help ensure all assets are accurately recorded, prior system data aligns with Foreman, and proper documentation is maintained for internal or external audits.

Steps to export assets:

1. Navigate to Operations → Assets.
2. Scroll to the bottom of the Assets table.
3. Click Export.

The export will process in the background and automatically download to your device. You now have a full snapshot of your assets for review, sharing, or archival purposes.

Exporting Inventory

Inventory exports provide a complete snapshot of your stock, allowing you to check levels, confirm assignments, and validate data for accuracy. These exports are especially useful for inventory managers and auditors who need to track changes, reconcile discrepancies, or maintain documentation for reporting purposes.

Steps to export inventory:

1. Navigate to Operations → Inventory.
2. Scroll to the bottom of the Inventory table.
3. Click Export.

The export will process in the background and automatically download to your device, giving you an up-to-date record of all inventory items.

Export Reorder Report:

You can also generate a Reorder Report, which identifies items below their notification thresholds.

• The report includes:
  • Item name
  • Item type
  • Client
  • Offline location
  • Quantity on hand
  • Assigned quantity
  • Notification threshold
  • Reorder amount

Example use case: A technician responsible for replenishing stock can quickly see which items need to be reordered, reducing the risk of operational delays.

Additional Reports

Foreman provides a variety of reports beyond the standard exports to help track asset and inventory activity over time. These reports can be scheduled for recurring delivery or generated ad hoc as needed. Using these reports ensures your team has visibility into historical changes, helps maintain accuracy, and supports audit and compliance efforts.

• Asset History Report
  • Tracks changes made to assets over time.
  • Includes: date, asset, user, action performed, and the details of what changed.
  • Only days with historical actions are included; each day is generated into its own file.
  • Use case: Auditors or managers can quickly see who modified an asset and what was changed.
     

• Asset Report
  • Provides a daily snapshot of all historical events per asset.
  • Includes: date, asset name, type, identifier, client, client ID, location, and custom fields.
  • Use case: Review all asset activity for a given day, week, or month for operational oversight.
     
• Inventory History Report
  • Tracks changes to inventory items over time.
  • Includes: date, item, user, action performed, and the details of what changed.
  • Only days with historical actions are included.
  • Use case: Verify adjustments or updates made to inventory counts or locations.
     
• Inventory Report
  • Provides a daily summary of all historical events per inventory item.
  • Includes: date, inventory name, type, count, count threshold, client, location, and custom fields.
  • Use case: Review inventory trends and reconcile any discrepancies over time.

Interpreting Reports: What to Look For

Generating reports is only valuable if you know how to analyze the data and take action. Here's what to watch for in each report type and what actions to take.

Asset Report Analysis

Red Flags to Watch For:

Frequent location changes for the same asset

• What it means: Asset is being moved repeatedly, possibly indicating deployment issues or recurring failures
• Action: Investigate why this asset is unstable; consider retiring it or assigning to a less critical role

Assets with no activity for 90+ days

• What it means: Equipment may be forgotten, lost, or not deployed
• Action: Physical audit of these assets; update locations or redeploy to active use

Multiple assets showing warranty expiration in the next 30 days

• What it means: The window for warranty claims is closing
• Action: Review assets for any known issues; file warranty claims before expiration

High concentration of assets in "Repair" offline locations

• What it means: Possible bottleneck in repair workflow or parts shortage
• Action: Analyze if specific components are causing failures; prioritize procurement of those parts

Assets with mismatched client assignments

• What it means: Equipment may have been transferred between facilities, but records weren't updated
• Action: Verify physical location matches system records; update client assignments as needed

Multiple assets with identical custom field values

• What it means: Possible data entry error during bulk upload or default values not updated
• Action: Review affected assets individually; ensure each has accurate, unique information

Healthy Indicators:

• Assets are evenly distributed across active locations
• Minimal movement between offline and online locations (indicates stable deployments)
• Recent activity dates show assets are being monitored and maintained
• Warranty expiration dates spread throughout the year (avoiding mass replacement events)
• Low percentage of assets in repair or storage locations (most equipment actively deployed)

Inventory Report Analysis

Red Flags to Watch For:

Items consistently at or below the notification threshold

• What it means: Reorder quantities or thresholds are set too low for actual usage
• Action: Increase reorder quantities or adjust thresholds based on consumption rate; analyze lead times from suppliers

Items with assigned quantity but no movement for 30+ days.

• What it means: Parts assigned to tickets that were never closed or used
• Action: Review open tickets; close resolved tickets to free up inventory; investigate if parts were returned to stock

The quantity is decreasing rapidly over a short period.

• What it means: Possible component failure trend or upcoming shortage
• Action: Investigate if specific failures are driving usage; place emergency orders if needed; identify root cause of failures

Zero quantity with open tickets requiring that item

• What it means: Technicians need parts that are out of stock, causing repair delays
• Action: Expedite procurement; identify alternate parts or temporary solutions; improve forecasting

High quantity with zero usage over 90+ days

• What it means: Overstocking or obsolete parts taking up storage space
• Action: Consider returning excess inventory, selling, or reallocating to other facilities; review why items were over-ordered

Negative inventory quantities

• What it means: Items were used or assigned without proper inventory records, or a data entry error occurred
• Action: Conduct a physical count immediately; investigate recent ticket activity; correct system records to match reality

Multiple small adjustments to the same item

• What it means: Ongoing counting errors, theft, or process compliance issues
• Action: Increase security or access controls; retrain team on proper check-out procedures; consider cycle counting this item more frequently

Healthy Indicators:

• Inventory quantities are maintained buffer above notification thresholds
• Assigned quantities are regularly cleared as tickets close
• Steady, predictable usage rates that align with operational scale
• Notification emails triggering before stockouts occur
• Even distribution of inventory across appropriate offline locations

Asset History Report Analysis

Patterns to Identify:

Same technician repeatedly working on same asset

• Insight: Technician may need additional training, or asset has chronic issue requiring escalation
• Action: Pair technician with mentor; consider replacing problem asset; review repair procedures

Specific asset type requiring frequent repairs

• Insight: Design flaw, environmental issue, or supplier quality problem affecting entire model line
• Action: Escalate to procurement; consider switching manufacturers or models; demand supplier review

Repairs clustering around specific timeframes (e.g., every summer)

• Insight: Environmental factors (heat, humidity, dust) causing seasonal failures
• Action: Proactive maintenance before high-risk seasons; improve cooling/environment; adjust deployment strategies

Short time between repairs on same asset (e.g., repaired twice in one month)

• Insight: Incomplete repair, wrong diagnosis, or defective replacement parts being used
• Action: Review repair quality; implement secondary inspection process; verify parts supplier quality

High volume of activity during specific hours (e.g., 2-4am)

• Insight: Identifies peak failure times or shift patterns; may indicate systematic issues
• Action: Adjust staffing to match activity; investigate why failures cluster at those times; check for power or environmental issues

Assets moving through multiple offline locations before deployment

• Insight: Possible inefficiency in receiving, testing, or deployment workflow
• Action: Streamline location transitions; identify bottlenecks; clarify roles and handoff procedures

Identical repair notes across multiple assets

• Insight: Systemic issue affecting multiple units; possible copy-paste without actual diagnosis
• Action: Investigate common root cause; verify each repair was actually performed; improve documentation standards

Long gaps between asset creation and first deployment

• Insight: Equipment sitting idle after purchase; possible procurement timing issues
• Action: Align procurement with deployment schedules; identify what's blocking faster deployment

Inventory History Report Analysis

Trends to Monitor:

Consumption rate increasing over time

• What it means: Operation is scaling, or failure rates are increasing
• Action: Adjust reorder quantities upward; investigate if failure rate increase is concerning; plan for long-term capacity

Multiple small quantity adjustments (e.g., +2, -1, +3)

• What it means: Possible data entry errors, manual corrections, or informal borrowing between locations
• Action: Train team on proper bulk adjustment procedures; investigate if physical counts are accurate; enforce checkout protocols

Same items repeatedly going out of stock

• What it means: Reorder process is too slow, minimum stock levels are too low, or supplier is unreliable
• Action: Increase safety stock; consider consignment agreements with suppliers; evaluate alternate vendors

Sudden large quantity increases

• What it means: Bulk shipment received or data correction applied
• Action: Verify shipment was properly inspected and logged; confirm pricing and PO match; check for receiving process compliance

Inventory moving between multiple offline locations frequently

• What it means: Inefficient storage organization or unclear item ownership between teams
• Action: Consolidate inventory to fewer locations; establish clear storage assignments; improve labeling

Items with no history of assignment to tickets despite quantity decreases

• What it means: Parts being used without proper documentation in ticket workflows
• Action: Retrain team on ticket-based inventory tracking; investigate informal or emergency usage patterns

Consistent discrepancies after cycle counts

• What it means: Ongoing process issues with inventory management, possible theft, or data accuracy problems
• Action: Increase cycle count frequency for problem items; improve physical security; audit checkout procedures

Notification threshold changes without corresponding usage pattern changes

• What it means: Someone is manually adjusting thresholds reactively rather than strategically
• Action: Establish threshold-setting guidelines; base thresholds on data-driven usage analysis; limit who can adjust thresholds

Creating Action Plans from Report Data

Use this framework to turn report insights into operational improvements:

Weekly Review (15-30 minutes)

Reports to run:

• Reorder Report
• Asset Report filtered to warranty expiration within 30 days
• Open tickets with assigned inventory

Actions to take:

• Place orders for items below the threshold
• Schedule inspection or file warranty claims for expiring assets
• Follow up on long-open tickets to close or escalate

Assign to: Inventory Coordinator or Warehouse Manager

Monthly Review (1-2 hours)

Reports to run:

• Asset History Report for previous 30 days
• Inventory History Report for previous 30 days
• Export current asset and inventory snapshots

Actions to take:

• Identify top 10 most-repaired assets; tag for replacement consideration
• Calculate consumption rates for high-use inventory; adjust reorder quantities
• Review discrepancy patterns from recent cycle counts; update training or procedures
• Compare current snapshot to previous month; identify significant changes

Assign to: Operations Manager with support from Maintenance Lead

Quarterly Review (2-4 hours)

Reports to run:

• Comprehensive Asset Report for previous 90 days
• Full Inventory usage analysis
• Location capacity and utilization report
• Cycle count summary and discrepancy trends

Actions to take:

• Calculate mean time between failures by asset type; inform purchasing decisions
• Identify obsolete or slow-moving parts; return or liquidate excess stock
• Determine if offline locations need expansion, reorganization, or consolidation
• Review all asset types for performance trends; identify candidates for early retirement
• Assess whether current inventory levels align with operational scale
• Update forecasting models based on quarterly trends

Assign to: Senior Operations Leadership with input from Finance and Procurement

Annual Review (4-8 hours)

Reports to run:

• Complete year-over-year asset performance comparison
• Total cost of ownership analysis by asset type
• Full inventory turnover and carrying cost analysis
• Compliance and audit documentation package

Actions to take:

• Identify most reliable and cost-effective equipment for future procurement
• Calculate total maintenance costs by facility and asset type
• Evaluate supplier performance based on warranty claims and part quality
• Review and update all cycle count configurations and frequencies
• Assess ROI on Assets & Inventory module; document cost savings and efficiency gains
• Plan capital expenditures for next fiscal year based on asset lifecycle data

Assign to: Executive Leadership, Finance, Operations, and Procurement

Key Metrics to Track Over Time

As you build reporting discipline, track these key performance indicators:

Asset Metrics:

• Mean Time Between Failures (MTBF) by asset type
• Average repair time by asset type
• Percentage of assets actively deployed vs. in storage/repair
• Asset utilization rate (uptime vs. downtime)
• Cost per repair by asset type
• Warranty claim success rate

Inventory Metrics:

• Inventory turnover rate (how quickly stock is used and replenished)
• Stockout frequency (how often items hit zero)
• Carrying cost (value of inventory sitting unused)
• Reorder accuracy (ordered quantity vs. actual usage)
• Shrinkage rate (unexplained inventory loss)
• Average fulfillment time (time from ticket creation to part assignment)

Operational Metrics:

• Cycle count accuracy rate (percentage of items counted correctly)
• Discrepancy resolution time (days from identification to correction)
• Ticket closure rate for inventory-related issues
• Average time in each offline location (identifying bottlenecks)
• Percentage of tickets with proper inventory assignment

Using Reports to Drive Continuous Improvement

The ultimate goal of reporting isn't just to document what happened—it's to predict what will happen and prevent problems before they occur. As you analyze reports over time, you'll start to see patterns that enable proactive decision-making:

Predictive Maintenance: Asset history shows certain models consistently fail at 18 months; implement replacement schedules at 16 months to prevent unplanned downtime.

Smart Procurement: Inventory consumption data reveals you use 50 fans per month in summer but only 20 in winter; adjust seasonal ordering to reduce carrying costs.

Process Optimization: Reports show 40% of assets spend more than 7 days in "Receiving Inspection"; streamline the inspection workflow to accelerate deployment.

Risk Mitigation: Trend analysis identifies increasing failure rates for a specific supplier's components; switch vendors before widespread failures impact operations.

Financial Planning: Historical data enables accurate budgeting for repairs, replacements, and inventory—turning reactive spending into planned capital allocation.

By regularly analyzing reports and taking targeted action based on the insights above, you transform raw data into operational excellence. Your team moves from reactive firefighting to proactive management, where problems are anticipated and solved before they impact productivity.

Schedule Reports

Scheduled reports allow you to automatically receive updates on a regular basis without manually generating them each time.

Steps to schedule a report:

1. Navigate to the Reports tab in the left-hand menu.
2. Click Add Report to open the scheduling modal.
3. Configure the report settings:
   • Recipients: Who will receive the report?
   • Report Type: Select from Asset History, Asset Report, Inventory History, or Inventory Report.
   • Time Frame: Choose Previous Day, Previous Week, or Previous Month.
   • Frequency: Select Daily, Weekly, or Monthly.
4. Click Save to schedule the report.

Once scheduled, the report will automatically generate and be delivered to the recipients at the selected frequency.

Ad Hoc Report

Ad hoc reports are useful for one-time or custom data requests. They allow you to specify a custom time frame and generate the report immediately.

Steps to generate an ad hoc report:

1. Navigate to the Reports tab in the left-hand menu.
2. Click Ad Hoc Report.
3. Configure the report:
   • Recipient: Who should receive the report?
   • Report Type: Select the type of report you need.
   • Time Frame: Specify a custom period or range.
4. Click Send.

The report will be generated and emailed to the recipient once completed.

Tips Best Practices for Reporting and Exports

To get the most value from Foreman’s reporting and export features, follow these guidelines:

• Use a mix of scheduled and ad hoc reports:
  • Scheduled reports are ideal for regular operational tracking, ensuring your team consistently receives updates on assets and inventory.
  • Ad hoc reports are useful for audits, investigations, or custom data ranges, providing flexibility when you need specific data.
• Keep records up to date: Schedule regular exports to maintain accurate, current data for review and reconciliation with prior systems or spreadsheets.
• Maintain transparency and accountability: Share reports with relevant team members to ensure everyone has access to the same information.
• Monitor inventory proactively: Review reorder and inventory reports before planning new purchases to prevent stockouts or overstocking.
   

Following these best practices ensures your team always has the information needed to make informed decisions, maintain accurate records, and support operational and audit processes.

Step Complete

In this step, you learned how to leverage Foreman’s reporting and export features to maintain accurate, up-to-date records of your assets and inventory. You now know how to:

• Export both assets and inventory to capture complete snapshots for review, audits, and reconciliation.
• Generate Reorder Reports to monitor stock levels and prevent shortages.
• Access additional reports, including Asset and Inventory History Reports, for tracking historical changes and supporting operational oversight.
• Schedule recurring reports or generate ad hoc reports for specific timeframes and custom needs.
• Apply best practices for reporting and exports to maintain transparency, accuracy, and accountability across your team.

By completing this step, your organization is equipped to use Foreman’s reports proactively, ensuring inventory integrity, supporting audits, and enabling informed decision-making.