Last updated on: 2018-10-25
Authored by: David Hendler
You can use a comma-separated-values (CSV) invoice to filter and manipulate your Rackspace billing data. Three pivot tables, which provide data filters, are available to help you find the information that you need.
The pivot tables provide the following data filters:
Use the following steps to view billing data in pivot tables:
Select the pivot table spreadsheet from the following list, and download it:
Note: The following steps use the current version of Microsoft Excel on Windows ® or Mac ® OSX ®. If you are using a different spreadsheet application version or a different OS, adjust your steps accordingly.
Log in to the portal.
a. Dedicated account customers: Log in to the MyRackspace Portal.
b. Cloud customers: Log in to the Cloud Control Panel.
In the top navigation bar, click Billing.
Click Billing History > Invoice Details.
On the Invoice Details page, click the CSV link, and export the CSV invoice file.
Open Microsoft Excel, and create a new workbook. Do not open the CSV invoice file.
In the new workbook, click Data > From Text/CSV.
In the import dialog box, select your CSV invoice file, and click Get Data.
In the import wizard, select Delimited (using commas as the delimiter value), change the file origin to Unicode (UTF-8), and click Load.
The resulting spreadsheet looks similar to the following example:
Click the small blank square at the top left of the spreadsheet to select all of the values.
Copy the data to your clipboard.
Open the spreadsheet file that you downloaded in step 1.
Paste the CSV data into the Invoice CSV Data worksheet.
Note: Ensure that you select the A1 cell when you paste.
In each of the three pivot tables (worksheets), right-click the pivot table, and select Refresh.
Save the spreadsheet with a new name to your computer.
The following videos show how to view your data in a pivot table:
The charge shown for Cloud Servers is the charge for saved images, and the charge shown for Cloud Files is the charge for storage.
The column headers in the CSV file are defined as follows:
ACCOUNT_NO: Your account number in the billing system
BILL_NO: The identification number of this invoice
BILL_START_DATE: The start date of the billing cycle contained in this invoice
BILL_END_DATE: The end date of the billing cycle contained in this invoice
SERVICE_TYPE: The products that accrued the charges, such as:
EVENT_TYPE: Within the product (SERVICE_TYPE), the event that accrued the charge, such as:
EVENT_START_DATE: The start date of the specified event
EVENT_END_DATE: The end date of the specified event
IMPACT_TYPE: Whether the event was a debit or credit (for example, Discount, Charge, Tax)
QUANTITY: The number or the amount of things being counted for charges, such as 300 (GB)
UOM (Unit of Measure): How the QUANTITY is measured, such as GB
RATE: The cost per chargeable unit
CURRENCY: The medium of exchange in which accrued charges are billed (for example, USD, AUD, GBP, EUR)
AMOUNT: The number of chargeable units
USAGE_RECORD_ID: The ID of the charge
DC_ID: The data center in which the charges were accrued
REGION_ID: The region in which the charges were accrued
RES_ID: The ID of the resource
RES_NAME: The name of the resource
ATTRIBUTE_1, ATTRIBUTE_2, ATTRIBUTE_3: Any other important aspects of the resource
©2020 Rackspace US, Inc.
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License