Seller Finances & Supply Chain Power BI

Monitor financial and operations performance with an overview and history of your Amazon Seller KPIs. Improve them with our seller recommendations.

Use Cases

  • Profit & Loss (P&L): Get an overview, history, and period-to-period comparison of your financial performance.
  • Unit Economics: Analyze finances from an SKU, ASIN, seller, or overall-level with enhanced filtering.
  • Supply Chain: See inventory and supply chain recommendations side-by-side with your P&L.

What's Inside

General Usage

Filters

  • Dates: Pick a range of dates for overview and history data or two date ranges for comparison.
  • Entity: Set your level of analysis with a selection between the SKU, ASIN, seller, or overall-level.
  • Currency: Convert all monetary values to the desired currency.
  • Seller Name: Filter your data to a selection of seller accounts.
  • Marketplace: Filter your data to a selection of marketplaces.
  • Product Tag: Filter your products to those attributed to at least one among a selection of tags.
  • ASIN: Filter your data to a selection of ASINs.
  • SKU: Filter your data to a selection of SKUs.
  • Brand: Filter your data to a selection of Brands
  • Product Name: Filter your data to a selection of Product Names

Sales Overview

Sales Detailed

Profit and Loss Overview

P&L Detailed

Profit & Loss History

Profit & Loss Period Comparison

Amazon FBA Restock Recommendations

Data

The Seller Finances and Supply Chain dashboard sources data from the Product Profit & Loss data models.

Getting Started

Requirements

You need to add the following sources to use the Seller Finances and Supply Chain report template:

Report Template

Dashboard PBIX TemplateContentChangesChanges
Seller Finances & Supply Chain- Profit & Loss
- SKU-Level P&L
- Unit Economics
- Inventory
- Replenishment Recos
February 21, 2024Last datapoint date is shown on each tab. Data refresh tracking has been lightened.

Accessing the Template

You can access the template on Power BI Online or on Power BI Desktop.

Old Templates Versions

You can download below older versions of our Power BI dashboard templates in PBIX format.

Dashboard PBIX TemplateChangesChanges
Seller Finances & Supply ChainFebruary 19, 2024Orders tab removed for performance
Tabs have been renamed for clarity - the Sales tabs rely on Orders data for analyzing sales performance, while the P&L tabs provide the accounting view through financial events.
Unified currency for Sales data, added currency filter.
Added Product Names and Brands to visualizations and filters
Seller Finances & Supply ChainJanuary 10, 2024Orders data has been added to the dashboard along with new visuals. Sales from orders indicate earned sales from completed purchases while sales from financial events indicate realized sales from collected payments.
Seller Finances & Supply ChainDecember 12, 2023All associated seller account names across marketplaces are now displayed as seller account name on tables.
Seller Finances & Supply ChainSeptember 19, 2023Show last refresh time on report tabs.
Seller Finances & Supply ChainSeptember 01, 2023Faster performance on the Sales Charts, Overview and Inventory, P&L History, and P&L Comparison tabs. Other filters no longer depend on the entity filters e.g. you can filter SKUs even if displaying account-level metrics. The P&L Comparison tab now has a selector for using actual values or adjusted values for base metrics instead of displaying both at the same time.
Seller Finances & Supply ChainAugust 22, 2023Fixed inventory and restock recommendations for SKUs sold in multiple marketplaces. Included a P&L comparison tab where you can compare financial KPIs across two different periods.
Seller Finances & Supply ChainAugust 04, 2023Set data anonymization to be off by default
Seller Finances & Supply ChainAugust 03, 2023Set data to be unanonymized by default
Seller Finances & Supply ChainAugust 01, 2023Fixed advertising to be in negative values similar to other costs
Seller Finances & Supply ChainJuly 19, 2023Fixed project and tags slicers when adding more than 1 but less than all options
Speed up on the Overview and Inventory tab
Seller Finances & Supply ChainJuly 11, 2023Changed format of locked columns (account/product/sku) to remove gaps in tables
Added TACoS and TRoAS
Fixed Sales Growth to be calculated in the correct direction
Polished the Amazon FBA Restock Recommendations to have more readable field names
Polished misc. field names and formatting
Polished slicer layout
Seller Finances & Supply ChainJuly 05, 2023Now has both ASIN and SKU level product metrics
Now has weekly historical
Fewer tabs, more slicers
FBA data available two ways
Raw Amazon restock recommendations
Custom metrics with user-selected quantity formula, lead time, and target weeks on hand
Fixed Warehousing cost, ROAS, FBA inventory, Growth and Ad Spend metrics
Seller Finances & Supply ChainJune 08, 2023Fixed Inventory data
Seller Finances & Supply ChainMay 25, 2023Made financial metrics sortable in the "Product Overview" tab
Seller Finances & Supply ChainMay 23, 2023Ads and FBA metrics available in product overview tab
Fixed various data quality issues
Seller Finances & Supply ChainMay 19, 2023
Seller Finances & Supply ChainApril 2, 2023
Seller Finances & Supply ChainMarch 27, 2023