Import Tariff Rates
Import tariffs and monthly rates from CSV or Excel files
Upload File
File Format Requirements
Your CSV/Excel file must contain the following columns:
| Column | Required | Description | Example |
|---|---|---|---|
tariff_code |
Yes | Unique identifier for the tariff | FUEL-DIESEL-50 |
name |
Yes | Display name of the tariff | Diesel 50ppm Inland |
category |
Yes | Category (fuel, electricity, water, materials, etc.) | fuel |
unit |
Yes | Unit of measurement | liter |
year |
Yes | Year for the rate (2020-2100) | 2024 |
month |
Yes | Month for the rate (1-12) | 6 |
rate |
Yes | Rate value in ZAR | 24.56 |
Tips
- One row per tariff per month
- Multiple months/years can be imported in one file
- Existing rates will be updated if the same tariff/month/year combination exists
- New tariffs will be automatically created if the tariff_code doesn't exist
Sample Template
Download a sample CSV file to see the expected format:
Download Sample CSVAvailable Categories
- fuel Fuel & Petroleum
- electricity Electricity
- water Water
- gas Gas
- materials Raw Materials
- commodities Commodities
Available Units
- liter Liter (L)
- kWh Kilowatt Hour
- m3 Cubic Meter
- kg Kilogram
- ton Metric Ton
- unit Unit