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 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
transaction_type	String	The type of transaction
transaction_status	String	The status for the transaction
marketplace_id	String	Marketplace identifier of transaction
marketplace_name	String	Information about the marketplace where the transaction occurred
account_type	String	Account type of transaction
total_amount	Numeric	Total amount of transaction
currency_code	String	Currency Code
description	String	Describes the reasons for the transaction
posted_date	Date	The date and time when the transaction was posted
report_start_date	Date	Report Start Date
report_end_date	Date	Report End Date
download_date	Date	Download Date

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 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	Breakdown Heirarchy 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

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 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 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 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	Breakdown Heirarchy 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

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 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.sellercentral_financial_eventgroup

Seller Central Console Report: Link 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
report_start_date	Date	Report Start Date
report_end_date	Date	Report End Date
seller_partner_id	String	Selling Partner ID
marketplace_name	String	Information about the marketplace where the transaction occurred
marketplace_id	String	Marketplace identifier of transaction
financial_event_group_id	String	Financial Event Group ID
processing_status	String	Processing Status
fund_transfer_status	String	Fund Transfer Status
original_total_amount	Numeric	Original Total amount of transaction
original_total_currency_code	String	Currency Code
converted_total_amount	Numeric	Converted Total amount of transaction
converted_total_currency_code	String	Currency Code
fund_transfer_date	DateTime	Fund Transfer Date
trace_id	String	Trace ID
account_tail	String	Account Tail
beginning_balance_amount	Numeric	Beginning Balance Amount
beginning_balance_currency_code	String	Currency Code
financial_event_group_start	DateTime	Financial Event Group Start
financial_event_group_end	DateTime	Financial Event Group End
download_date	Date	Download Date