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 in the Bandwidth App:
Log in to the Bandwidth App.
In the side navigation bar, click Insights and select Billing.
Under Type, select Invoices.
Under Date range, choose if you want to download the invoice for the Previous Month, Month to Date, or a Custom time frame.
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 invoice. To learn what other reports are available in the Bandwidth App, 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:
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 hit us up at (855) 864-7776!