# Finance Reports

### Financial Transactions Reports - For Sellers

These Reports for Finances help you obtain financial information relevant to a seller's business. You can obtain financial events for a given order or date range without having to wait until a statement period closes.

## **Financial Transactions Report**

Table name: **amazon\_source\_data.sellercentral\_financialtransactions**

Seller Central Console Report: [Link](https://developer-docs.amazon.com/sp-api/docs/finances-api-v2024-06-19-use-case-guide)\
\
Download Frequency: Daily

<table><thead><tr><th width="225">Column Name</th><th width="92">Data type</th><th width="432">Description</th></tr></thead><tbody><tr><td>account_name</td><td>String</td><td>Display Name</td></tr><tr><td>account_id</td><td>Integer</td><td>Intentwise Account ID</td></tr><tr><td>seller_id</td><td>String</td><td>Selling Partner ID</td></tr><tr><td>country_code</td><td>String</td><td>Country Code</td></tr><tr><td>transaction_id</td><td>String</td><td>The unique identifier for the transaction</td></tr><tr><td>transaction_type</td><td>String</td><td>The type of transaction</td></tr><tr><td>transaction_status</td><td>String</td><td>The status for the transaction</td></tr><tr><td>marketplace_id</td><td>String</td><td>Marketplace identifier of transaction</td></tr><tr><td>marketplace_name</td><td>String</td><td>Information about the marketplace where the transaction occurred</td></tr><tr><td>account_type</td><td>String</td><td>Account type of transaction</td></tr><tr><td>total_amount</td><td>Numeric</td><td>Total amount of transaction</td></tr><tr><td>currency_code</td><td>String</td><td>Currency Code</td></tr><tr><td>description</td><td>String</td><td>Describes the reasons for the transaction</td></tr><tr><td>posted_date</td><td>Date</td><td>The date and time when the transaction was posted</td></tr><tr><td>report_start_date</td><td>Date</td><td>Report Start Date</td></tr><tr><td>report_end_date</td><td>Date</td><td>Report End Date</td></tr><tr><td>download_date</td><td>Date</td><td>Download Date</td></tr></tbody></table>

## **Financial Transactions Item Level Breakdowns Report**

Table name: **amazon\_source\_data.sellercentral\_financialtransactions\_itemlevelbreakdowns**\
\
Note: This table should be used along with sellercentral\_financialtransactions. Use the transaction\_id column for the join.

Seller Central Console Report: [Link](https://developer-docs.amazon.com/sp-api/docs/finances-api-v2024-06-19-use-case-guide)\
\
Download Frequency: Daily

| Column Name                  | Data type | Description                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| ---------------------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| account\_name                | String    | Display Name                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| account\_id                  | Integer   | Intentwise Account ID                                                                                                                                                                                                                                                                                                                                                                                                                           |
| seller\_id                   | String    | Selling Partner ID                                                                                                                                                                                                                                                                                                                                                                                                                              |
| country\_code                | String    | Country Code                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| transaction\_id              | String    | The unique identifier for the transaction                                                                                                                                                                                                                                                                                                                                                                                                       |
| breakdown\_type              | String    | The type of charge                                                                                                                                                                                                                                                                                                                                                                                                                              |
| breakdown\_amount            | Numeric   | The amount of the charge                                                                                                                                                                                                                                                                                                                                                                                                                        |
| breakdown\_id                | Integer   | Break Down ID                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| parent\_break\_down\_id      | Integer   | Parent Break Down ID                                                                                                                                                                                                                                                                                                                                                                                                                            |
| currency\_code               | String    | Currency Code                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| item\_id                     | Integer   | Item ID                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| id                           | Integer   | ID                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| report\_start\_date          | Date      | Report Start Date                                                                                                                                                                                                                                                                                                                                                                                                                               |
| report\_end\_date            | Date      | Report End Date                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| download\_date               | Date      | Download Date                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| parent\_breakdown\_hierarchy | String    | <p>Breakdown Heirarchy<br></p><ul><li>This helps disambiguate breakdown line items with repeated names by providing their full hierarchical context. for eg. if "Commission" was a break down type under "Amazon Fee" and it was part of "Expenses", then column "parent\_breakdown\_hierarchy" for "Commission" will have value - "Expenses-AmazonFees". This will help in understanding how nested price components are broken down</li></ul> |

## **Financial Transactions Item Related Identifiers Report**

Table name: **amazon\_source\_data.sellercentral\_financialtransactions\_itemrelatedidentifiers**\
\
Note: This table should be used along with sellercentral\_financialtransactions. Use the transaction\_id column for the join.

Seller Central Console Report: [Link](https://developer-docs.amazon.com/sp-api/docs/finances-api-v2024-06-19-use-case-guide)\
\
Download Frequency: Daily

| Column Name                      | Data type | Description                                                  |
| -------------------------------- | --------- | ------------------------------------------------------------ |
| account\_name                    | String    | Display Name                                                 |
| account\_id                      | Integer   | Intentwise Account ID                                        |
| seller\_id                       | String    | Selling Partner ID                                           |
| country\_code                    | String    | Country Code                                                 |
| currency\_code                   | String    | Currency Code                                                |
| transaction\_id                  | String    | The unique identifier for the transaction                    |
| item\_related\_identifier\_name  | String    | Enumerated set of related item identifier names for the item |
| item\_related\_identifier\_value | String    | Corresponding value of ItemRelatedIdentifierName             |
| item\_id                         | Integer   | Item ID                                                      |
| id                               | Integer   | ID                                                           |
| report\_start\_date              | Date      | Report Start Date                                            |
| report\_end\_date                | Date      | Report End Date                                              |
| download\_date                   | Date      | Download Date                                                |

## **Financial Transactions Items Report**

Table name: **amazon\_source\_data.sellercentral\_financialtransactions\_items**\
\
Note: This table should be used along with sellercentral\_financialtransactions. Use the transaction\_id column for the join.

Seller Central Console Report: [Link](https://developer-docs.amazon.com/sp-api/docs/finances-api-v2024-06-19-use-case-guide)\
\
Download Frequency: Daily

| Column Name          | Data type | Description                                              |
| -------------------- | --------- | -------------------------------------------------------- |
| account\_name        | String    | Display Name                                             |
| account\_id          | Integer   | Intentwise Account ID                                    |
| seller\_id           | String    | Selling Partner ID                                       |
| country\_code        | String    | Country Code                                             |
| id                   | Integer   | ID                                                       |
| transaction\_id      | String    | The unique identifier for the transaction                |
| description          | String    | Describes the reasons for the transaction                |
| total\_amount        | Numeric   | Total Amount                                             |
| currency\_code       | String    | Currency Code                                            |
| asin                 | String    | Amazon Standard Identification Number (ASIN) of the item |
| quantity\_shipped    | Integer   | Quantity of the item shipped                             |
| sku                  | String    | Stock keeping unit (SKU) of the item                     |
| fulfillment\_network | String    | Fulfillment network of the item                          |
| context\_type        | String    | Context Type                                             |
| report\_start\_date  | Date      | Report Start Date                                        |
| report\_end\_date    | Date      | Report End Date                                          |
| download\_date       | Date      | Download Date                                            |

## **Financial Transactions Transaction Level Breakdowns Report**

Table name: **amazon\_source\_data.sellercentral\_financialtransactions\_transactionlevelbreakdowns**\
\
Note: This table should be used along with sellercentral\_financialtransactions. Use the transaction\_id column for the join.

Seller Central Console Report: [Link](https://developer-docs.amazon.com/sp-api/docs/finances-api-v2024-06-19-use-case-guide)\
\
Download Frequency: Daily

| Column Name                  | Data type | Description                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| ---------------------------- | --------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| account\_name                | String    | Display Name                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| account\_id                  | Integer   | Intentwise Account ID                                                                                                                                                                                                                                                                                                                                                                                                                           |
| seller\_id                   | String    | Selling Partner ID                                                                                                                                                                                                                                                                                                                                                                                                                              |
| country\_code                | String    | Country Code                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| transaction\_id              | String    | The unique identifier for the transaction                                                                                                                                                                                                                                                                                                                                                                                                       |
| breakdown\_type              | String    | The type of charge                                                                                                                                                                                                                                                                                                                                                                                                                              |
| breakdown\_amount            | Numeric   | The amount of the charge                                                                                                                                                                                                                                                                                                                                                                                                                        |
| breakdown\_id                | Integer   | Break Down ID                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| parent\_break\_down\_id      | Integer   | Parent Break Down ID                                                                                                                                                                                                                                                                                                                                                                                                                            |
| currency\_code               | String    | Currency Code                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| report\_start\_date          | Date      | Report Start Date                                                                                                                                                                                                                                                                                                                                                                                                                               |
| report\_end\_date            | Date      | Report End Date                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| download\_date               | Date      | Download Date                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| parent\_breakdown\_hierarchy | String    | <p>Breakdown Heirarchy<br></p><ul><li>This helps disambiguate breakdown line items with repeated names by providing their full hierarchical context. for eg. if "Commission" was a break down type under "Amazon Fee" and it was part of "Expenses", then column "parent\_breakdown\_hierarchy" for "Commission" will have value - "Expenses-AmazonFees". This will help in understanding how nested price components are broken down</li></ul> |

## **Financial Transactions Transaction Related Identifiers Report**

Table name: **amazon\_source\_data.sellercentral\_financialtransactions\_transactionrelatedidentifiers**\
\
Note: This table should be used along with sellercentral\_financialtransactions. Use the transaction\_id column for the join.

SSeller Central Console Report: [Link](https://developer-docs.amazon.com/sp-api/docs/finances-api-v2024-06-19-use-case-guide)\
\
Download Frequency: Daily

| Column Name                | Data type | Description                                                  |
| -------------------------- | --------- | ------------------------------------------------------------ |
| account\_name              | String    | Display Name                                                 |
| account\_id                | Integer   | Intentwise Account ID                                        |
| seller\_id                 | String    | Selling Partner ID                                           |
| country\_code              | String    | Country Code                                                 |
| currency\_code             | String    | Currency Code                                                |
| transaction\_id            | String    | The unique identifier for the transaction                    |
| related\_identifier\_name  | String    | Enumerated set of related item identifier names for the item |
| related\_identifier\_value | String    | Corresponding value of RelatedIdentifierName                 |
| id                         | Integer   | ID                                                           |
| report\_start\_date        | Date      | Report Start Date                                            |
| report\_end\_date          | Date      | Report End Date                                              |
| download\_date             | Date      | Download Date                                                |

## **Financial Transactions Event Group Report**

Table name: **amazon\_source\_data.**&#x73;ellercentral\_financial\_eventgroup

Seller Central Console Report: [Link](https://developer-docs.amazon.com/sp-api/docs/finances-api-v2024-06-19-use-case-guide)\
\
Download Frequency: Daily

<table><thead><tr><th>Column Name</th><th width="241.7999267578125">Data type</th><th>Description</th></tr></thead><tbody><tr><td>account_name</td><td>String</td><td>Display Name</td></tr><tr><td>account_id</td><td>Integer</td><td>Intentwise Account ID</td></tr><tr><td>seller_id</td><td>String</td><td>Selling Partner ID</td></tr><tr><td>country_code</td><td>String</td><td>Country Code</td></tr><tr><td>report_start_date</td><td>Date</td><td>Report Start Date</td></tr><tr><td>report_end_date</td><td>Date</td><td>Report End Date</td></tr><tr><td>seller_partner_id</td><td>String</td><td>Selling Partner ID</td></tr><tr><td>marketplace_name</td><td>String</td><td>Information about the marketplace where the transaction occurred</td></tr><tr><td>marketplace_id</td><td>String</td><td>Marketplace identifier of transaction</td></tr><tr><td>financial_event_group_id</td><td>String</td><td>Financial Event Group ID</td></tr><tr><td>processing_status</td><td>String</td><td>Processing Status</td></tr><tr><td>fund_transfer_status</td><td>String</td><td>Fund Transfer Status</td></tr><tr><td>original_total_amount</td><td>Numeric</td><td>Original Total amount of transaction</td></tr><tr><td>original_total_currency_code</td><td>String</td><td>Currency Code</td></tr><tr><td>converted_total_amount</td><td>Numeric</td><td>Converted Total amount of transaction</td></tr><tr><td>converted_total_currency_code</td><td>String</td><td>Currency Code</td></tr><tr><td>fund_transfer_date</td><td>DateTime</td><td>Fund Transfer Date</td></tr><tr><td>trace_id</td><td>String</td><td>Trace ID</td></tr><tr><td>account_tail</td><td>String</td><td>Account Tail</td></tr><tr><td>beginning_balance_amount</td><td>Numeric</td><td>Beginning Balance Amount</td></tr><tr><td>beginning_balance_currency_code</td><td>String</td><td>Currency Code</td></tr><tr><td>financial_event_group_start</td><td>DateTime</td><td>Financial Event Group Start</td></tr><tr><td>financial_event_group_end</td><td>DateTime</td><td>Financial Event Group End</td></tr><tr><td>download_date</td><td>Date</td><td>Download Date</td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.intentwise.com/iac-source-data/data-models/amazon-source-data/seller-central/finance-reports.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.