Tax item data feed
This data feed provides information about tax calculations for a customer invoice.
There can be multiple line items (line_item_id) for a given product
(product_id) of a given customer invoice (invoice_id), one or more
for each tax jurisdiction. This happens, for example, with usage-based bills for customers who
are using different AWS Region rules by different AWS entities (say, the US and Ireland). To
learn more about where AWS collects sales tax, VAT, or GST on your sales and remits such taxes
to the local tax authorities, in the name of AWS, Inc., see Amazon Web Service Tax Help
The tax item data feed is refreshed every 24 hours, so new data is available daily.
Tax item data is immutable.
The following table explains the names and descriptions of the data feed's columns. For information about data history columns, see Historization of the data.
| Column name | Description |
|---|---|
| tax_item_id | A unique identifier for a tax item record. |
| invoice_id | The AWS invoice ID. You can use this value with the value of
product_id to find related tax billing events. |
| line_item_id | A unique identifier for a customer bill line item. Refund transactions have the same line item ID as their forward tax transactions. |
| customer_bill_id | The unique identifier of the customer bill. Buyers can share this identifier with the seller to help identify and resolve tax calculation questions. |
| tax_liable_party | Either If no taxes are collected, there is no value shown here. The seller needs to determine whether some taxes were collected for each invoice, as the seller is liable for tax collection. |
| transaction_type_code | The type of transaction. Possible values are as follows:
Refund transactions share the line item ID with their original forward transactions. |
| product_id | A foreign key to the product. Can be used to join to the |
| product_tax_code | A standard code to identify the tax properties for a product. Sellers choose the properties when creating or modifying the product. |
| invoice_date | The date the invoice was created. |
| taxed_customer_account_id | A foreign key to the account entity who is taxed. Can be used to join to the
|
| taxed_customer_country | The ISO 3166 alpha 2 country code of the address used for tax calculations. |
| taxed_customer_state_or_region | The state, region, or province used for tax calculations. |
| taxed_customer_city | The city used for tax calculations. |
| taxed_customer_postal_code | The postal code used for tax calculations. |
| tax_location_code_taxed_jurisdiction | The vertex geocode that is associated with the taxed location. |
| tax_type_code | The type of tax that is applied to the transaction. The possible values are
None, Sales, and SellerUse. |
| jurisdiction_level | The jurisdiction level of the address that is used for tax location. The possible values
are State, County, City, and District. |
| taxed_jurisdiction | The name of the tax jurisdiction. |
| display_price_taxability_type | Whether the price that buyers see is inclusive or exclusive of taxes. All AWS Marketplace offerings are exclusive of taxes. |
| taxable_amount | The amount of the transaction that is taxable, at this jurisdiction level. |
| nontaxable_amount | The amount of the transaction that is nontaxable, at this jurisdiction level. |
| tax_jurisdiction_rate | The tax rate that is applied, at this jurisdiction level. |
| tax_amount | The amount of tax that is charged, at this jurisdiction level. |
| tax_currency | The ISO 4217 alpha 3 currency code for above amounts. |
| tax_calculation_reason_code | Whether the transaction is taxable, not taxable, exempt, or zero-rated, organized by the jurisdiction level. |
| date_used_for_tax_calculation | The date that is used for calculating tax on the transaction. |
| customer_exemption_certificate_id | The certificate ID of the exemption certificate. |
| customer_exemption_certificate_id_domain | The location where the certificate is stored on Amazon systems. |
| customer_exemption_certificate_level | The jurisdiction level that supplied the exemption. |
| customer_exemption_code | The code that specifies the exemption; for example, RESALE. |
| customer_exemption_domain | The Amazon system that is used to capture the customer exemption information, if available. |
| transaction_reference_id | An identifier that allows you to cross-reference data from the following reports: |
Note
Beginning August 5, 2021, international Marketplace Facilitator taxes for AWS Marketplace sales will have entries in the tax item data feed. This means that, beginning August 5, 2021, every AWS_TAX_SHARE and SELLER_TAX_SHARE record in the billing event data feed is expected to have a corresponding record in the tax item data feed.
Example of tax item data feed
The following shows an example of the tax item data feed. In the data feed, this information is presented in a single table. For readability, the data is shown in multiple tables here, and all columns aren't shown.
| tax_item_id | invoice_id | line_item_id | customer_bill_id |
|---|---|---|---|
| 6p2ni6tu041xagvhbyanbgxl3xameha16txjoav_0001 | 781216640 | 71000000000000000000 | 2210000000000000000 |
| 6p2ni6tu041xagvhbyanbgxl3xameha16txjoav_0002 | 781216640 | 53000000000000000000 | 2210000000000000000 |
| flr4jobxjzww8czdsrq4noue2uxd56j39wxw0k7_0001 | 250816266 | 76400000000000000000 | 5720000000000000000 |
| gfkjjobxjzw56jgkrsrqgjtk52uxd56j39wgj567d_0002 | 280336288 | 76400000000000000000 | 5724390000000000000 |
| wwk1qpvb8ran3geiw8e3mp6dgs2qj7wpkuwhgk1_0001 | 451431024 | 99300000000000000000 | 1230000000000000000 |
| wwk1qpvb8ran3geiw8e3mp6dgs2qj7wpkuwhgk1_0002 | 451431024 | 99300000000000000000 | 3120000000000000000 |
| fnohdid8kwgqq9lvii2k30spn3ftgwihbe8h75x_0001 | 229987654 | 92100000000000000000 | 6390000000000000000 |
| tax_liable_party | transaction_type_code | product_id | product_tax_code | invoice_date |
|---|---|---|---|---|
| Seller | AWS | prod-o4grxfafcxxxx | AWSMP_SOFTWARE_RA | 2018-12-31T00:00:00Z |
| Seller | AWS | prod-o4grxfafcxxxx | AWSMP_SOFTWARE_RA | 2018-12-31T00:00:00Z |
| Seller | AWS | prod-t3grxfafcxxxy | AWS_REMOTE_ACCESS_SOFTWARE | 2018-08-31T00:00:00Z |
| Seller | REFUND | prod-t3grxfafcxxxy | AWS_REMOTE_ACCESS_SOFTWARE | 2018-08-31T00:00:00Z |
| Seller | AWS | prod-x8faxxfafcxxy | AWS_REMOTE_ACCESS_SOFTWARE | 2018-08-31T00:00:00Z |
| Seller | TAXONLYREFUND | prod-x8faxxfafcxxy | AWS_REMOTE_ACCESS_SOFTWARE | 2018-05-31T00:00:00Z |
| AWS | AWS | prod-wghj8xfafrhgj | AWS_REMOTE_ACCESS_SOFTWARE | 2019-07-31T00:00:00Z |
| taxed_customer_account_id | taxed_customer_country | taxed_customer_state_or_region | taxed_customer_city | taxed_customer_postal_code |
|---|---|---|---|---|
| VIeGa2t9j3MuxioH9wc8lsndXXCgGCGUreeXriocM5 | US | GA | MILTON | 48573-4839 |
| VIeGa2t9j3MuxioH9wc8lsndXXCgGCGUreeXriocM5 | US | GA | MILTON | 48573-4839 |
| 7nyo5jwTRoPlyX81vx9ji04eEwTurO1Ff8biQi88W8 | US | NC | DURHAM | 27517-4834 |
| 7nyo5jwTRoPlyX81vx9ji04eEwTurO1Ff8biQi88W8 | US | NC | DURHAM | 27517-4834 |
| 7nyo5jwTRoPlyX81vx9ji04eEwTurO1Ff8biQi88W8 | US | TX | NOT APPLICABLE | 75844-1235 |
| 7nyo5jwTRoPlyX81vx9ji04eEwTurO1Ff8biQi88W8 | US | TX | HOUSTON | 75844-1235 |
| 192a0421313e41f069b52962ed7babf716291b688 | US | CT | NEW HAVEN | 06002-2948 |
| tax_location_code_taxed_jurisdiction | tax_type_code | jurisdiction_level | taxed_jurisdiction | display_price_taxability_type | taxable_amount | nontaxable_amount |
|---|---|---|---|---|---|---|
| 460473664 | Sales | State | GA | Exclusive | 100 | 0 |
| 66301164 | Sales | County | FULTON | Exclusive | 0 | 100 |
| 692938178 | SellerUse | State | NC | Exclusive | 58.1 | 523.8 |
| 692938178 | SellerUse | State | NC | Exclusive | -58.1 | 523.8 |
| 356794387 | Sales | State | TX | Exclusive | 1105.14 | 0 |
| 528887443 | Sales | City | HOUSTON | Exclusive | -36 | 0 |
| 171248162 | Sales | State | CT | Exclusive | 0 | 114.55 |
| tax_jurisdication_rate | tax_amount | tax_currency | tax_calculation_reason_code | date_used_for_tax_calculation |
|---|---|---|---|---|
| 0.206 | 20.6 | USD | Taxable | 2018-10-31T00:00:00Z |
| 0 | 0 | USD | NonTaxable | 2018-10-31T00:00:00Z |
| 0.1 | 5.8 | USD | Taxable | 2018-07-31T00:00:00Z |
| 0.1 | -5.8 | USD | Taxable | 2018-07-31T00:00:00Z |
| 0.06 | 66.3 | USD | Taxable | 2018-07-31T00:00:00Z |
| 0.01 | -0.36 | USD | NonTaxable | 2018-07-31T00:00:00Z |
| 0 | 0 | USD | Exempt | 2019-06-30T00:00:00Z |
