.csv files are used my Eseye to send invoices to customers, they are easily opened in Excel.
For help in finding an invoice, see: How to locate an invoice.
An example .csv file viewed in Excel:
Column A – ItemRef
Column A displays the name of the items used by the SIM card(s). Each row represents one item by a single SIM card (for example if you have seven SIM cards using data there will be seven rows in this column displaying ‘Data’):
Data
This displays the details of mobile data used by a SIM card in the billing period. This is calculated and billed in arrears.
OffNetVoice
This displays the details of the voice calls used by a SIM card in the billing period. This is calculated and billed in arrears.
Service
This displays the details of the service charges, which cover both the active subscription on the HLR MNO and any bundled usage. Service charges are billed in advance.
Monthly billing
The service charges are per calendar month. Due to the service charges being billed in advance the first bill will include two lines labelled ‘Service’ per SIM card. This will total over one month’s agreed service charge, because the bill includes the partial first month (pro-rated for the number of active days) and the second month. This appears as two lines on the bill the first is for the period that the SIM card was activate in the month before the billing date. The second is in advance of the upcoming month.
Annual billing
The service charges are billed in advance. You will have one ‘Service’ row for each SIM card.
SMS
This displays the details of the SMS (small messaging service) used by a SIM card in the billing period. This is calculated and billed in arrears.
Column B - ICCID
Column B displays the integrated circuit card identifier (ICCID) of the SIM card:
Column C – MSISDN
Column C displays the Mobile Station International Subscriber Directory Number (MSISDN) of the SIM card:
Column D – DataMSISDN
Column D displays the Circuit Switched Data number, this is only assigned if the customer package needs it:
Column E – PackageID
Column E displays the number of the Eseye tariff that defines the pricing and configuration of the SIM card:
Column F - Package
Column F displays a description of the tariff that the SIM card has been assigned:
Column G – PackageItem ID
Column G displays the number of the Eseye item tariff. This is a sub section of the ‘PackageID’ based upon type of item and region:
Column H – Description
Column H displays a human readable description of the item, it can include a geographical region (e.g. zone 1) and a rounded quantity of the amount:
Column I - Start
Column I displays the first date of billable usage for each item:
Data
The ‘Start’ column displays the date of the beginning of the first data session within the billable period.
OffNetVoice
The ‘Start’ column displays the date of the beginning of the first voice call within the billable period.
Service
This is dependent upon whether you are billed annually or monthly.
Monthly
SIM card activated within the last month
The .csv file displays two service rows for the SIM card. The first row’s ‘Start’ value is the date that the SIM card was activated. The second row’s ‘Start’ value is the first date of the current month, this is because the ‘Service’ section of the bill is paid in advance of use.
SIM card activated before the last month
The .csv file displays one service row for the SIM card. The ‘Start’ column displays the first date of the current month, this is because the ‘Service’ section of the bill is paid in advance.
Annual billing
The .csv file displays one ‘Service’ row for the SIM card. The ‘Start’ column displays the date of the SIM card activation or anniversary of the activation, this is because the ‘Service’ section of the bill is paid in advance.
SMS
The ‘Start’ column displays the date of the first SMS being sent within the billable period.
Column J – Stop
Column J displays the last date of the billing period that the item was used by the SIM card:
Data
The ‘Stop’ column displays the date of the ending of the last data session within the billable period.
OffNetVoice
The ‘Stop’ column displays the date of the ending of the last voice call within the billable period.
Service
This is dependent upon whether you are billed annually or monthly.
Monthly
SIM card activated within the last month
The .csv file displays two service rows for the SIM card. The first row’s ‘Stop’ value is the last date in the previous month. The second row’s ‘Stop’ value is the last of the current month, this is because the ‘Service’ section of the bill is paid in advance of use.
SIM card activated before the last month
The .csv file displays one service row for the SIM card. The ‘Stop’ column displays the last date in the current month, this is because the ‘Service’ section of the bill is paid in advance.
Annual billing
The .csv file displays one ‘Service’ row for the SIM card. The ‘Stop’ column will display the last date before the SIM card activation anniversary, this is because the ‘Service’ section of the bill is paid in advance.
SMS
The ‘Stop’ column displays the date of the last SMS being sent within the billable period.
Column K - Quantity
Column K displays the amount the item used:
Data
Data is measured in bytes.
OffNetOffice
Voice calls are measured in seconds.
Service
Service is a set price, therefore the ‘Quantity’ always appears as ‘0’.
SMS
SMS are measured in the amount of messages.
Column L - Currency
Column L displays the currency that the item will be paid in:
Column M - Rate
Column M displays the amount of money for each item:
Column N – Amount
Column N displays the total amount billed for each item:
Service
If a SIM card was activated in the month before the billing date then there will also be a partial month service charge that is pro-rated for the number of days the SIM was active.
Column O – FriendlyName
Column O displays the Friendly name of the SIM card.
So you can easily recognise the SIM we recommend the site location or the purpose of the data connection, for help with setting the Friendly Name see: How to change Friendly Name of a SIM card:
Column P – GroupName
Column P displays the Group name that the SIM card belongs to. For help with setting the Group Name see: How to add or edit the Group Name of a SIM card or How to add or edit the Group Name of multiple SIM cards.
Column Q – Activated
Column Q displays the date and time that the SIM card was activated:
Column R – BundleQuantity
Column R displays the amount of the item included in the tariff and therefore do not incur extra costs:
Data
Data is measured in bytes.
OffNetOffice
Voice calls are measured in seconds.
Service
Service is a set price, therefore the ‘BundleQuantity’ always appears as ‘0’.
SMS
SMS are measured in the amount of messages.
Column S – InBundleQuantity
Column S displays the amount of the items included in the tariff that have been used:
Data
Data is measured in bytes.
OffNetOffice
Voice calls are measured in seconds.
Service
Service is a set price, therefore the ‘BundleQuantity’ always appears as ‘0’.
SMS
SMS are measured in the amount of messages.
Comments