How do I download and format BDRs?

How do I download BDRs?

Billing Detail Record (BDR) is a report that documents the details of your voice traffic. To download it, complete the following steps:

1. Log in to the Bandwidth App.
2. In the side navigation bar, select Insights and click Billing.
3. Under Type, select BDR.
4. Under Date range, select if you want to download the report for the Previous Month, Month to Date, or Custom time frame.
5. Click Submit. This will download a CSV file into your browser. If you don't see it, please check your browser's Downloads section or your computer's Downloads folder. 

How do I download Statement BDRs?

Statement Billing Detail Record (BDR) is a report that documents the details of your voice traffic and will match up exactly to what was invoiced. To download it, complete the following steps:

1. Log in to the Bandwidth App.
2. In the side navigation bar, select Insights and click Billing.
3. Under Type, select Statement BDR.
4. Under Date range, select if you want to download the report for the Current Month's invoice, Previous Month's invoice, or Custom time frame. For Custom, select the date range for the invoice date. (Ex: If you want the voice usage for the 3/7 invoice, select the 3/1-3/31 date range.)
5. Click Submit. This will download a CSV file into your browser. If you don't see it, please check your browser's Downloads section or your computer's Downloads folder. 

How do I format BDRs?

Once you open a BDR file, the data may appear in a single column. In that case, you can follow the instructions below to format it so that each piece of data appears in a separate column. For more information about the meaning of each column, see BDR field descriptions.

1. Highlight column A. 
2. Click the Data tab and select Text to Columns. 
3. This will open a new Text to Columns wizard. For Step 1, choose Delimited and click Next. 
4. Under the Delimiters section, choose Other and use Shift + Backslash on your keyboard to enter a vertical bar (|) into the textbox.
5. Click Finish. Now your spreadsheet data has been organized into separate columns
6. With any cell in the first row selected, navigate to the Home tab and select Sort & Filter (CTRL + Shift + L in Windows) to make the headers filterable.

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