How to understand a csv file invoice

.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.

 

Have more questions? Submit a request

Comments

Powered by Zendesk