How do I use the CSV included with my invoice?

Follow

Alicia Raphael

Updated

How do I download my invoice CSV?

To download your Bandwidth invoice in the CSV format, please either refer to the attachment in your monthly statement delivery email or access it through the Bandwidth Dashboard. To do the latter:

  1. Log into the Bandwidth Dashboard.
  2. Click Insights in the top navigation bar and select Billing.
  3. Under Type, select Invoices.
  4. Under Date range, choose if you want to download the invoice for the Previous Month, Month to Date, or a Custom time frame.
  5. Click Submit.

Bandwidth Dashboard Billing page

How do I use the CSV?

The CSV breaks down the charges and quantities in greater detail. This lets you pull additional reports in the Bandwidth Dashboard to further analyze the charges that appear on your invoice. To learn what other reports are available in the Bandwidth Dashboard, check out this support article

What data is on the Wholesale CSV? 

Please scroll right to see all the available fields.

Global Account Number

Provisioning Account Number

Subaccount Number

Location Number

Global Account Name

Provisioning Account Name

Sub Account Name Location Name Category Description Type Service Start Service End Quantity Calls Base Currency Charge In Base Currency Charge Currency Fx Rate Charge In Fx Currency Billing Group Billing Account Number Billing Account Name Invoicing Company
BW-XXXXXXX XXXXXXX This is only available for voice usage charges, and assumes a one-to-one relationship between sub-accounts and IP addresses  This is only available for voice usage charges, and assumes a one-to-one relationship between Locations and IP addresses Account Name  Name Corp Other Name Corp   Voice, Messaging, Telephone Numbers, Other, Taxes DID MRC Tier 0, SMS Outbound, ETC.   Usage, Monthly Recurring, Non-recurring,  Prorated Monthly Recurring Beginning of the service period  End of the service period #### #### $ $$$ Currency  #### $$$ Not applicable at this time BW-xxxxxxx Account Name Bandwidth Inc or Voxbone Inc

 

What data is on the UC CSV? 

The UC CSV has more visibility in terms of Location and Sub-account numbers. Because of this, you can filter by Sub-account or Location and see all of the associated charges. You can use the PivotTable tool in Excel to filter this report. Here are the instructions on how to do that:

  1. Open the CSV file.
  2. Go to Insert Tab and select PivotTable.
  3. A pop-up window will appear. Keep the Select a table or range selected – you don't need to change the range.
  4. Select New Worksheet under Choose where you want the PivotTable report to be placed - this option will create a new sheet in the CSV file. Then click OK.

Create PivotTable page

  1. A new sheet will populate with the PivotTable Fields. Please note that if you click outside of the pivot table box, the PivotTable Fields will disappear. However, if you click back in the box, the field options will appear.
  2. Drag Subaccount_Name, Location_Name, and Description into the Rows box.
  3. Drag Charge into the Values box (you can also drag in the Quantity for some more detail).
  4. This will create the pivot table with the breakdown of Sub-account and Locations with the totals.

Questions? Please open a ticket with your Bandwidth Billing Team or hit us up at (855) 864-7776!

Article is closed for comments.