How do I download my Bandwidth 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 in the Bandwidth App:
Log in to the Bandwidth App.
In the side navigation bar, select Insights > Reports > Billing.
Under Type, select Invoices.
Under Date range, choose if you want to download the invoice for the Previous month, Current month, or a Custom date range (if you selected Custom, please also select Start date and End date).
Click Submit.
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 App to further analyze the charges that appear on your Bandwidth Invoice.
What data is on the Wholesale CSV?
Field | Example |
Global_Account_Number | BW-XXXXXXX |
Provisioning_Account_Number | XXXXXXX |
Subaccount_Number | This is only available for voice usage charges, and assumes a one-to-one relationship between sub-accounts and IP addresses |
Location_Number | This is only available for voice usage charges, and assumes a one-to-one relationship between Locations and IP addresses |
Global_Account_Name | Account Name |
Provisioning_Account_Name | Name Corp |
Subaccount_Name | Other Name Corp |
Location_Name |
|
Category | Voice, Messaging, Telephone Numbers, Other, Taxes |
Description | DID MRC Tier 0, SMS Outbound, ETC. |
Type | Usage, Monthly Recurring, Non-recurring, Prorated Monthly Recurring |
Service_Start | Beginning of the service period |
Service_End | End of the service period |
Quantity | #### |
Calls | #### |
Base_Currency | $ |
Charge_In_Base_Currency | $$$ |
Charge_Currency | Currency |
Fx_Rate | #### |
Charge_In_Fx_Currency | $$$ |
Billing_Group | Not applicable at this time |
Billing_Account_Number | BW-xxxxxxx |
Billing_Account_Name | Account Name |
Invoicing_Company | 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. You can use the PivotTable tool in Excel to filter it by Sub-account or Location and see all of the associated charges:
Open the CSV file.
Go to Insert Tab and select PivotTable.
A pop-up window will appear. Keep the Select a table or range selected – you don't need to change the range.
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.
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.
Drag Subaccount_Name, Location_Name, and Description into the Rows box.
Drag Charge into the Values box (you can also drag in the Quantity for some more detail).
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 call us at (855) 864-7776!