How do I download Billing Detail Records (BDRs) and Message Detail Records (MDRs)?

Follow

Chase Greiser

Updated

pendo_pay-invoice.png

The Bandwidth Dashboard is capable of producing rated call detail reports. We call them Billing Detail Records (BDRs) for voice and Message Detail Records (MDRs) for messaging. To download them:

  1. Log into the Bandwidth Dashboard.
  2. In the top navigation menu, select Insights and click Billing.
  3. Use the Type field to select either BDR or MDR.
  4. Use the Date range field to choose if you want to download the report for the Previous Month, Month to Date, or a Custom time frame.
    • If you select Custom, please manually enter the start and end dates or use the calendar tool. To do the latter, click the Calendar icon and then double-click on the date to lock it.

      Screen_Shot_2020-05-28_at_7.05.25_PM.png

  5. Click Submit.
  6. This will download an Excel file into your web browser. Double click to open it.
    • Note: If you don't see the file, check the Downloads section in your web browser or the Downloads folder on your computer. 

When you first open the file, all of the data may appear in a single column. If that's the case, here's how you can format it so that each piece of data appears in a separate column:

  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. For more information about each of these columns, please see BDR field descriptions or MDR field descriptions.

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

Article is closed for comments.