How Vendor Rates Are Uploaded
- Select one or multiple vendor Excel files and click Upload.
- System parses all sheets
- normalizes route names (CC_1 → CC) If a sheet is named UNKNOWN, assign a route category from the prompt
How to Compare Vendor Pricing
- Vendor Price Summary table shows Lowest / Highest / Average per vendor Price
- Overview donut shows the overall min, avg, max across filtered data
How to Find LCR
- Use the Destination filter to search
- by country or by destination
- Use the Vendor filter to narrow down to a specific carrier
- Use the Route filter by category that is setup in reference to the prefix
- CC
- CLI
- NCLI
- to compare like-for-like
- Rate table shows all matching rows with prefix, interval, and price
How Rate Updates Are Handled
- Upload the vendor Rate file
- System will perform a comparison
- The rates that are changed will be updated only. Rest will remain same. The change can be
- Decreased
- Increased
- Deleted
- New ones will be inserted
- Unchanged rates are skipped entirely
- Deleted vendors log all their rates before removal
How Daily Reports Work
- Open Settings (gear icon)
- → Set recipient email and send time
- Report emails automatically every day showing
- Added rates
- Updated rates
- Deleted rates
- Use Send Now to trigger a report instantly at any time