Skip to main content

Documentation Index

Fetch the complete documentation index at: https://help.mathership.com/llms.txt

Use this file to discover all available pages before exploring further.

Reports & Analytics

Access powerful reporting and analytics tools to understand your business performance and make data-driven decisions. Reports Overview

Report Categories

Sales Reports

  • Revenue analysis
  • Sales trends
  • Top products
  • Customer sales
  • Order volume

Inventory Reports

  • Current stock levels
  • Stock valuation
  • Turnover rates
  • Low stock alerts
  • Dead stock analysis

Customer Reports

  • Customer performance
  • New customers
  • Customer retention
  • Account receivable
  • Customer segmentation

Financial Reports

  • Revenue by period
  • Profit margins
  • Payment collection
  • Invoice aging
  • Cost analysis

Operational Reports

  • Order fulfillment
  • Delivery performance
  • Route efficiency
  • Driver performance
  • Processing times
Report Categories

Accessing Reports

Navigate to Reports in the main menu to access the reporting dashboard.

Report Dashboard

The dashboard provides:
  • Quick Stats: Key metrics at a glance
  • Trending Charts: Visual data trends
  • Recent Reports: Recently generated reports
  • Favorites: Your frequently used reports
  • Scheduled Reports: Automated report schedule

Standard Reports

Sales Reports

Sales by Period

  • Daily, weekly, monthly, yearly sales
  • Compare periods
  • Identify trends
  • Revenue breakdown

Product Sales

  • Best-selling products
  • Revenue by product
  • Quantity sold
  • Product performance trends

Customer Sales

  • Sales by customer
  • Top customers
  • Customer purchase patterns
  • Customer lifetime value

Sales by Category

  • Revenue by product category
  • Category performance
  • Category trends
Sales Reports

Inventory Reports

Stock Status

  • Current inventory levels
  • Products by stock status
  • Location-wise inventory
  • Stock valuation

Inventory Movement

  • Stock in/out transactions
  • Adjustment history
  • Turnover analysis
  • Slow-moving items

Reorder Report

  • Items below reorder point
  • Suggested reorder quantities
  • Lead time considerations
  • Stock-out predictions

Customer Reports

Customer List

  • All customers with details
  • Filterable by group, status, region
  • Contact information
  • Account status

Customer Performance

  • Revenue per customer
  • Order frequency
  • Average order value
  • Growth trends

Customer Profitability

  • Revenue vs. costs per customer
  • Margin analysis
  • Resource allocation
  • Focus opportunities

Financial Reports

Invoice Report

  • All invoices by period
  • Payment status
  • Outstanding amounts
  • Collection metrics

Accounts Receivable Aging

  • Invoices by age buckets
  • 0-30, 31-60, 61-90, 90+ days
  • Customer-wise aging
  • Collection priorities

Payment Collection

  • Payments received
  • Collection trends
  • Payment methods
  • Average days to payment
Financial Reports

Operational Reports

Order Fulfillment

  • Orders by status
  • Processing times
  • Fulfillment rates
  • Order accuracy

Delivery Performance

  • On-time delivery percentage
  • Late deliveries
  • Delivery times
  • Route performance

Driver Performance

  • Deliveries per driver
  • On-time rate
  • Issues reported
  • Efficiency metrics

Custom Reports

Create custom reports:

Report Builder

  1. Go to Reports → Custom Reports
  2. Click New Custom Report
  3. Select data source
  4. Choose fields to include
  5. Add filters
  6. Group and sort
  7. Save report

Custom Report Options

  • Data Sources: Orders, products, customers, inventory
  • Fields: Select specific data points
  • Filters: Date range, status, category, etc.
  • Grouping: Group by category, customer, period
  • Sorting: Sort by any field
  • Calculations: Sum, average, count, min, max
Custom Reports

Report Filters

Filter reports by:
  • Date Range: Specific period
  • Customer: Individual or group
  • Product: Specific products or categories
  • Status: Order status, payment status
  • Location: Warehouse, zone, region
  • Driver/Route: Delivery routes
  • Custom Fields: Your specific criteria

Report Formats

Export reports in various formats:

Available Formats

  • PDF: For printing and sharing
  • Excel (XLSX): For analysis in Excel
  • CSV: For data import to other systems
  • HTML: For web viewing
  • Email: Send directly via email

Exporting Reports

  1. Generate report
  2. Click Export
  3. Select format
  4. Choose options (page size, orientation)
  5. Download or email
Export Reports

Scheduled Reports

Automate report generation:

Creating Schedule

  1. Generate a report
  2. Click Schedule Report
  3. Set schedule:
    • Frequency (daily, weekly, monthly)
    • Day and time
    • Recipients
    • Format
  4. Save schedule

Scheduled Report Options

  • Frequency: How often to generate
  • Recipients: Email addresses
  • Format: PDF, Excel, CSV
  • Delivery: Email or save to folder
  • Filters: Dynamic (e.g., “last 30 days”)

Managing Schedules

  • View all scheduled reports
  • Edit schedules
  • Pause/resume
  • Delete schedules
  • View schedule history
Scheduled Reports

Report Visualization

Charts and Graphs

Visualize data with:
  • Line Charts: Trends over time
  • Bar Charts: Comparisons
  • Pie Charts: Distribution
  • Area Charts: Cumulative data
  • Tables: Detailed data

Dashboard Widgets

Add report widgets to dashboard:
  1. Customize dashboard
  2. Click Add Widget
  3. Select report
  4. Choose visualization
  5. Set refresh rate
  6. Save to dashboard
Report Visualization

Key Performance Indicators (KPIs)

Track important metrics:

Sales KPIs

  • Total revenue
  • Revenue growth %
  • Average order value
  • Orders per day
  • Conversion rate

Operational KPIs

  • Order fulfillment time
  • On-time delivery %
  • Order accuracy %
  • Stock turnover rate
  • Fill rate

Financial KPIs

  • Gross profit margin
  • Operating expenses
  • Days sales outstanding
  • Accounts receivable turnover
  • Cash flow

Customer KPIs

  • Customer acquisition
  • Customer retention rate
  • Customer lifetime value
  • Average revenue per customer
  • Customer satisfaction

Comparative Analysis

Compare performance across periods:

Period Comparison

  • This month vs. last month
  • This year vs. last year
  • Quarter over quarter
  • Year-to-date vs. previous year-to-date

Variance Analysis

Shows:
  • Absolute difference
  • Percentage change
  • Positive/negative indicators
  • Trend direction
Comparative Analysis

Drill-Down Capabilities

Explore data in depth:
  1. View summary report
  2. Click on any data point
  3. See detailed breakdown
  4. Continue drilling down
  5. Access source records
Example:
  • Total Sales → Sales by Customer → Customer’s Orders → Order Details

Report Sharing

Share reports with team:

Sharing Options

  • Email: Send report via email
  • Link: Generate shareable link
  • Export: Download and share file
  • Dashboard: Share dashboard view
  • Portal: Publish to customer portal (if applicable)

Access Control

Control who can:
  • View specific reports
  • Generate reports
  • Export data
  • Schedule reports
  • Access raw data
Report Sharing

Report Templates

Use pre-built templates:

Available Templates

  • Executive summary
  • Sales dashboard
  • Inventory snapshot
  • Financial overview
  • Operational metrics

Using Templates

  1. Go to Reports → Templates
  2. Select template
  3. Customize parameters
  4. Generate report
  5. Save customizations

Data Analytics

Advanced analytics features:

Trend Analysis

Identify patterns:
  • Sales trends
  • Seasonal patterns
  • Growth trajectories
  • Performance cycles

Forecasting

Predict future performance:
  • Sales projections
  • Inventory needs
  • Resource requirements
  • Revenue estimates

Cohort Analysis

Analyze customer cohorts:
  • By signup date
  • By first purchase
  • By customer type
  • Retention analysis
Data Analytics

Mobile Reporting

Access reports on mobile:
  • View key metrics
  • Quick report generation
  • Export and share
  • Real-time data
  • Push notifications for milestones

Report Performance

For large data sets:

Optimization Tips

  • Use date filters to limit data
  • Schedule heavy reports for off-hours
  • Use summary reports for quick overview
  • Cache frequently used reports
  • Archive old data

Background Processing

Large reports process in background:
  • Receive notification when ready
  • Continue working while processing
  • Download when complete

Best Practices

  • Define key metrics for your business
  • Review reports regularly (daily/weekly/monthly)
  • Compare periods to identify trends
  • Act on insights from data
  • Share with stakeholders appropriately
  • Schedule routine reports to automate
  • Customize dashboards for different roles
  • Validate data accuracy periodically
  • Archive old reports for historical reference
  • Train team on report usage

Troubleshooting

Report Not Generating

Check:
  • Date range has data
  • Filters not too restrictive
  • Permissions configured
  • System not overloaded

Data Looks Wrong

Verify:
  • Date range selected
  • Filters applied correctly
  • No duplicate records
  • Recent data synced
  • Cache refreshed

Export Failing

Try:
  • Smaller date range
  • Different format
  • Reduce columns
  • Check file size limits
  • Verify disk space