Skip to content

Delivery Fees Total Report Documentation

Menu Location: Reports > Financial > Delivery Fees Total

Access Level: Manager and above

Last Updated: 2026-03-01

Overview

The Delivery Fees Total Report provides comprehensive analysis of shipping and delivery fee revenue across all orders. This report helps track delivery income, analyze delivery pricing effectiveness, and understand shipping cost recovery.

Primary Functions:

  • Track total delivery fee revenue by period
  • Analyze delivery fees by route, zone, or method
  • Compare delivery income to shipping costs
  • Identify delivery fee trends
  • Monitor free shipping promotions impact
  • Export delivery fee data for financial analysis

Page Layout

Header Section

  • Date Range Filter: Filter by delivery or order date
  • Route Filter: Analyze specific delivery routes
  • Delivery Method: Filter by shipping carrier or delivery type
  • Fee Status: Charged, Waived, Promotional

Main Content Area

Summary and detailed view of delivery fees with breakdowns by route, date, and delivery method.

Financial Summary

  • Total delivery fees collected
  • Average fee per order
  • Percentage of orders with delivery fees
  • Total waived fees (promotions)
  • Net delivery revenue

Report Data & Columns

Column Description
Date/Period Day, week, or month depending on grouping
Order Count Number of orders in period
Delivery Fees Charged Total fees collected
Delivery Fees Waived Free shipping promotions
Average Fee Fees / orders
Delivery Method Ground, 2-Day, Overnight, Local, Pickup
Route Delivery route (for local delivery)
Net Delivery Revenue Fees charged minus actual shipping costs (if tracked)

Common Use Cases

Use Case 1: Monthly Delivery Revenue Reporting

Goal: Report delivery fee income for accounting

Steps:

  1. Set date range to last calendar month
  2. Note total delivery fees charged
  3. Note total fees waived
  4. Calculate net delivery revenue
  5. Export for accounting records
  6. Compare to previous month for trends

Example: June 2026: $18,450 in delivery fees, $3,200 waived, net $15,250. Up 8% from May.

Use Case 2: Analyze Free Shipping Promotion Impact

Goal: Measure cost of "Free Shipping Friday" promotion

Steps:

  1. Filter to promotion date
  2. Compare delivery fees charged vs waived
  3. Check if order volume increased to offset fee loss
  4. Calculate:
    • Fees waived (promotion cost)
    • Additional orders gained
    • Net revenue impact
  5. Determine ROI of promotion

Example: Free Shipping Friday waived $1,850 in fees, but generated 85 additional orders averaging $65 each = $5,525 extra revenue. Net positive: $3,675.

Use Case 3: Route-Based Delivery Analysis

Goal: Understand delivery fee revenue by route

Steps:

  1. Group by route
  2. Review delivery fees per route
  3. Compare to route operating costs
  4. Identify:
    • Profitable routes (fees > costs)
    • Subsidized routes (fees < costs)
    • Optimization opportunities
  5. Adjust delivery fees if needed

Use Case 4: Shipping Method Performance

Goal: Analyze delivery fees by shipping method

Steps:

  1. Group by delivery method
  2. Compare:
    • Ground (low cost, low fee)
    • 2-Day (medium cost, medium fee)
    • Overnight (high cost, high fee)
  3. Calculate margin for each method
  4. Identify if fees adequately cover costs
  5. Adjust pricing structure if needed

Goal: Understand long-term delivery revenue patterns

Steps:

  1. Set date range to last 12 months
  2. Group by month
  3. Export to Excel
  4. Create trend chart
  5. Identify seasonality
  6. Compare to prior year same months
  7. Forecast next year delivery revenue

Troubleshooting

Numbers Don't Match Order Revenue Reports

Explanation: This report shows only delivery fees portion. Order revenue reports include products + delivery. Extract delivery fees from order reports to compare.

Waived Fees Seem Too High

Check:

  1. Review active free shipping promotions
  2. Verify promotion rules are correct
  3. Check for unintended fee waivers
  4. Ensure VIP customers eligible for free shipping
  5. Calculate waived percentage (should align with promotion strategy)
  • Orders Report - Overall order revenue including products
  • Shipping Cost Analysis - Actual shipping expenses for comparison
  • Route Management - Delivery route configuration
  • Promotional Campaigns - Free shipping promotion tracking

Quick Reference Card

Task Action
Monthly delivery revenue Date: Last month, view total fees charged
Analyze promotion impact Filter to promo date, compare charged vs waived
Route profitability Group by route, compare fees to costs
Average fee per order View average fee metric
Year-over-year comparison Date: Last 12 months, export, compare to prior year

FAQs

Do delivery fees include taxes?

Depends on configuration. Typically shows fees before tax. Check with administrator.

What if we don't charge delivery fees?

Report will show $0 or may not be relevant for your business model (free shipping always).

Can I see individual order delivery fees?

This report shows aggregates. For individual orders, use Order Detail page.

How do I calculate if delivery fees cover shipping costs?

Compare this report's "Total Fees Charged" to actual shipping invoices from carriers. Ideally fees ≥ costs.

Change Log

2026-03-01

  • Initial documentation created

End of Documentation

For additional help, contact your system administrator or Kiva Logic support.