SAASInventory

Leasing Reports

Leasing reports track inventory temporarily transferred to customers while maintaining ownership and accountability. These reports support equipment rental operations, asset loans, consignments, and temporary transfers with full visibility into leased stock, return tracking, and lease history.

Report CategoryAccess PathUse For
Lease DocumentationReports → Leasing ReportsLease slips, transfer documentation, customer records
Leased Stock StatusReports → Leasing ReportsCurrent inventory on lease, customer possession, aging analysis
Lease HistoryReports → Leasing ReportsCompleted leases, returns, audit trails, utilization patterns

Access: Reports → Type: Leasing Reports (Type 18)

Understanding Lease Inventory Tracking

Leasing reports provide critical visibility for rental and temporary transfer operations where you maintain inventory ownership while customers possess the assets. These reports answer key business questions:

Lease Documentation answers “What was leased and to whom?” with detailed lease slips showing items, quantities, serial numbers, customer information, lease dates, and reference numbers for record keeping and customer service.

Leased Stock Status answers “What’s currently out on lease?” by showing items with “Leased” hold status that have been transferred to customers but not yet returned, enabling aging analysis and utilization tracking.

Lease History answers “What has been leased and returned?” through complete audit trails of lease transactions including timing, customers, return conditions, and reference numbers for financial reporting and pattern analysis.

Lease Workflows

Inventory Pro supports comprehensive lease tracking through two complementary operations:

Creating Leases (Leasing → Lease Stock):

  1. Select customer and warehouse
  2. Add items to lease with quantities and locations
  3. System generates unique lease ID and applies “Leased” hold status
  4. Items remain visible in inventory but unavailable for other operations
  5. Lease slip documents the transfer for customer records

Processing Returns (Leasing → Lease Stock):

  1. Select existing lease transaction
  2. Specify return quantities and destination locations
  3. System clears hold status and makes items available
  4. Return slip documents the receipt for audit trail
  5. Partial returns supported for phased asset recovery

See Lease Stock for complete workflow documentation.

Business Use Cases

Leasing reports support multiple business models:

Equipment Rental Operations: Track rental inventory out to customers, manage return schedules, analyze utilization rates, and support billing for time-based rentals.

Tool Cribs and Asset Loans: Monitor employee tool checkouts, ensure accountability for borrowed equipment, track overdue returns, and maintain custody chains.

Consignment Operations: Manage inventory at customer sites while retaining ownership, track sell-through, and coordinate replenishment or returns.

Temporary Transfers: Document short-term asset transfers for events, demonstrations, trials, or emergency needs with full audit trails.

Report Features

All leasing reports include:

  • Customer visibility: Track leases across all customers with detailed contact information
  • Real-time status: Reports reflect current leased inventory and recent returns
  • Flexible filtering: Filter by customer, warehouse, date range, item, lease ID
  • Serial tracking: Full lot and serial number visibility for asset accountability
  • Export capabilities: Excel, CSV, PDF for billing, analysis, and customer documentation
  • Customization: Modify columns, grouping, sorting (Admin Option 165 required)

Common Filters

FilterPurposeAvailable In
CustomerSpecific customer or all customersMost reports
WarehouseSource warehouse for leased itemsMost reports
Lease IDSpecific lease transactionDocumentation reports
Date RangeLease or return date windowHistory and analysis reports
Item IDTrack specific item leasesAll reports
StatusActive leases vs returned itemsStatus reports
Serial NumberTrack specific serialized assetsAsset tracking reports
Lease AgeIdentify overdue or aged leasesAging reports

Lease Documentation Reports

These reports provide lease documentation, transfer records, and customer accountability for leased inventory transactions.

Lease Slip Report

Purpose: Generate detailed lease slip documentation showing all items transferred to a customer with line item details, serial numbers, lease terms, and customer information.

Use For:

  • Printing lease documentation for customer signature
  • Transfer records for customer possession
  • Return verification when items come back
  • Lease record keeping and audit documentation
  • Customer service inquiries about current leases

Key Information:

  • Lease ID and creation date
  • Customer name, contact, and shipping address
  • Complete item listing with descriptions
  • Quantities leased and returned
  • Serial numbers and lot tracking
  • Expected return dates (if configured)
  • Item locations at lease and return
  • Leasing user and return user
  • Lease status (Open, Partial Return, Complete Return)

Workflow:

  1. Navigate to Reports → Type: Leasing Reports
  2. Select Lease Slip Report
  3. Filter by lease ID, customer, or date range
  4. Print or export for customer documentation

Tips:

  • Print lease slips for customer signature before asset transfer
  • Include serial numbers for high-value asset tracking
  • Provide copy to customer for their records and return reference
  • File completed slips with return documentation for audit trail
  • Use PDF export for email delivery to customers
  • Attach photos of leased equipment condition when applicable

Return Receipt Report

Purpose: Document returned items from lease transactions showing quantities, condition notes, and location assignments.

Use For:

  • Verifying returned items against original lease
  • Documenting asset condition upon return
  • Confirming location putaway after return
  • Partial return tracking for multi-item leases
  • Customer dispute resolution

Key Information:

  • Original lease ID and lease date
  • Return date and receiving user
  • Items returned with quantities
  • Serial numbers verified
  • Return location assignments
  • Condition notes (if captured)
  • Outstanding items still on lease

Workflow:

  1. Generate upon processing lease returns
  2. Verify item condition and quantities
  3. Note any damage or missing components
  4. File with original lease documentation
  5. Send copy to customer if discrepancies exist

Tips:

  • Inspect returned items before accepting to document damage
  • Compare serial numbers to original lease slip for verification
  • Note any missing accessories or components
  • Photograph condition for high-value assets
  • Process partial returns separately for clear accountability

Leased Stock Status Reports

These reports show current inventory on lease with customers for real-time visibility, aging analysis, and utilization tracking.

Items on Lease Report

Purpose: Complete listing of all inventory currently on lease showing customers, quantities, lease dates, and aging for active lease management.

Use For:

  • Daily visibility into leased asset inventory
  • Identifying overdue or aged leases requiring follow-up
  • Customer service inquiries about current leases
  • Month-end and quarter-end inventory reconciliation
  • Utilization analysis for rental fleet optimization
  • Planning for upcoming return schedules

Key Information:

  • Item ID and description
  • Quantity currently on lease
  • Customer name and contact
  • Warehouse location (original source)
  • Lease ID and reference number
  • Lease date (when transferred)
  • Days on lease (aging calculation)
  • Expected return date (if configured)
  • Serial numbers (for serialized items)
  • Lease value (cost or rental value)

Aging Analysis: Reports typically group leases by age brackets:

  • 0-7 days: Recent leases
  • 8-30 days: Current leases
  • 31-60 days: Aging leases requiring attention
  • 61-90 days: Overdue leases requiring immediate follow-up
  • 90+ days: Significantly overdue, possible write-off candidates

Workflow:

  1. Navigate to Reports → Type: Leasing Reports
  2. Select Items on Lease Report
  3. Filter by customer, warehouse, or aging threshold
  4. Review aging categories for follow-up actions
  5. Export for customer contact campaigns or billing

Tips:

  • Run daily to monitor lease expirations and returns
  • Sort by days on lease to prioritize customer follow-up
  • Filter by customer for account reviews and renewals
  • Use serial number tracking for high-value asset accountability
  • Export to Excel for aging analysis and utilization charts
  • Set up scheduled delivery for weekly lease status review
  • Cross-reference with customer invoices for billing accuracy

Leased Stock by Customer Report

Purpose: Customer-focused view grouping all leased items by customer account for relationship management and billing support.

Use For:

  • Customer account reviews and lease summaries
  • Billing documentation for rental charges
  • Customer service inquiries
  • Credit limit monitoring for leased asset value
  • Customer-specific utilization analysis

Key Information:

  • Customer name and account details
  • Total items on lease from customer
  • Line item details for each leased asset
  • Lease dates and duration
  • Total lease value at cost
  • Individual lease IDs for transaction reference
  • Customer contact information

Workflow:

  1. Filter report to specific customer or run for all
  2. Review total value of assets in customer possession
  3. Verify lease durations and return schedules
  4. Export for billing department or customer delivery
  5. Use for monthly customer statements or account reviews

Tips:

  • Run before customer meetings for lease status discussions
  • Export as PDF for professional customer documentation
  • Include in monthly customer statements for rental operations
  • Monitor total lease value against customer credit limits
  • Use for customer utilization analysis and upselling opportunities

Leased Stock by Item Report

Purpose: Item-focused view showing lease utilization and availability across the rental fleet for inventory planning.

Use For:

  • Rental fleet utilization analysis
  • Identifying high-demand items for purchase planning
  • Forecasting availability for new lease requests
  • Asset allocation across customer base
  • ROI analysis for rental inventory investments

Key Information:

  • Item ID and description
  • Total quantity owned
  • Quantity currently on lease
  • Quantity available for new leases
  • Number of active leases (customer count)
  • Utilization percentage
  • Average lease duration
  • Total days on lease (lifetime)

Utilization Metrics:

  • High Utilization (>80%): Consider purchasing additional units
  • Moderate Utilization (50-80%): Optimal rental fleet performance
  • Low Utilization (<50%): Evaluate demand, pricing, or disposal

Workflow:

  1. Run report for rental fleet performance review
  2. Sort by utilization percentage
  3. Identify high-demand items for fleet expansion
  4. Review low-utilization items for pricing changes or disposal
  5. Export for purchasing department and financial analysis

Tips:

  • Run monthly for fleet optimization planning
  • Use utilization data to justify capital expenditures
  • Identify seasonal patterns in item demand
  • Compare utilization to rental revenue for ROI analysis
  • Plan maintenance schedules during low-utilization periods

Lease History Reports

These reports provide historical lease transaction data, return analysis, and audit trails for completed leases.

Lease History Report

Purpose: Complete transaction history showing all lease and return activity for financial reporting, audit compliance, and pattern analysis.

Use For:

  • Month-end and year-end lease activity summaries
  • Audit trail documentation for lease transactions
  • Customer lease history and relationship analysis
  • Utilization trend analysis over time
  • Revenue attribution for rental operations
  • Compliance reporting for asset tracking

Key Information:

  • Lease ID and transaction date
  • Customer and lease type
  • Items leased and returned
  • Lease duration (days out)
  • Return date and receiving user
  • Complete serial number history
  • Quantities leased and returned
  • Transaction user and timestamp
  • Return condition notes (if captured)

Time Period Options:

  • Daily: Recent activity for operational review
  • Weekly: Short-term trend monitoring
  • Monthly: Standard financial reporting period
  • Quarterly: Business review and trend analysis
  • Yearly: Annual summaries and long-term patterns

Workflow:

  1. Navigate to Reports → Type: Leasing Reports
  2. Select Lease History Report
  3. Choose date range (last month, quarter, year)
  4. Filter by customer, item, or warehouse if needed
  5. Export for financial reporting or audit documentation

Tips:

  • Run monthly for lease activity summaries
  • Filter by customer for account history reviews
  • Use for financial reconciliation of rental revenue
  • Export to Excel for trend analysis and charting
  • Archive monthly reports for compliance documentation
  • Cross-reference with invoice history for billing accuracy

Customer Lease Summary Report

Purpose: Aggregated customer lease activity showing total leases, returns, average durations, and relationship value.

Use For:

  • Customer relationship analysis
  • Identifying high-value lease customers
  • Customer retention and engagement strategies
  • Sales team account planning
  • Credit evaluation for new leases

Key Information:

  • Customer name and contact
  • Total number of leases (period and lifetime)
  • Total items leased (quantity and distinct items)
  • Average lease duration
  • Return rate (percentage returned vs leased)
  • Current leases outstanding
  • Total lease value (at cost)
  • First lease date and most recent activity

Customer Segmentation:

  • High-Value Customers: Frequent leases, high value, good return rates
  • Growing Customers: Increasing lease frequency over time
  • At-Risk Customers: Declining activity or overdue returns
  • New Customers: Recent first lease, monitoring period

Workflow:

  1. Run report for customer analysis period
  2. Sort by total lease value or frequency
  3. Identify top customers for relationship development
  4. Review return rates for problem identification
  5. Export for sales team or customer success initiatives

Tips:

  • Run quarterly for customer relationship reviews
  • Identify top 20% of customers generating 80% of revenue
  • Monitor new customer onboarding and early lease success
  • Track return rates to identify customer service issues
  • Use for targeted marketing campaigns and customer appreciation
  • Combine with financial data for customer lifetime value analysis

Item Lease Frequency Report

Purpose: Analyze which items are most frequently leased to optimize inventory investment and identify high-demand assets.

Use For:

  • Rental fleet optimization decisions
  • Purchase planning for high-demand items
  • Identifying obsolete or low-demand inventory
  • Pricing strategy for popular items
  • Marketing focus for rental promotions

Key Information:

  • Item ID and description
  • Total number of leases (period)
  • Unique customers who leased item
  • Average lease duration
  • Total days on lease (cumulative)
  • Current leases outstanding
  • Utilization rate percentage
  • Revenue generated (if rental pricing available)

Analysis Insights:

  • High Frequency + High Duration: Core rental products, ensure adequate stock
  • High Frequency + Short Duration: Quick-turn items, optimize for availability
  • Low Frequency + High Value: Specialty items, evaluate retention
  • Low Frequency + Low Value: Consider disposal or sale

Workflow:

  1. Run report for analysis period (month, quarter, year)
  2. Sort by lease frequency or total days
  3. Identify top performers for stock expansion
  4. Review low performers for disposition
  5. Export for purchasing and financial planning

Tips:

  • Run quarterly for fleet optimization reviews
  • Compare lease frequency to purchase cost for ROI analysis
  • Identify seasonal patterns in item demand
  • Use data to justify new equipment purchases
  • Consider customer requests for items not currently stocked
  • Cross-reference with maintenance costs for total cost of ownership

On this page