Skip to content

Dashboard templates

Retail · Finance & accounting

A retailer selling via marketplaces and website and on credit to dealers. Channel P&L from orders plus ledger results, expenses against budget by department, and accounts receivable and payable.

Free plan with no time limit · No card required · Sample workspace ready in minutes

For owners and accountants at shops selling on marketplaces, a website and on credit to dealers. The "Books and sales channels" dashboard puts the general ledger next to orders: the gap between booked revenue and channel revenue, and operating cost over channel revenue. The "Business results and budget" and "Receivables and payables" dashboards cover gross profit, gross margin, spend vs budget and overdue balances, while the profit and loss dashboards by channel and product show where the profit comes from. Needs channel, product, order, order line, chart of accounts and general ledger entry data.

Use this template to

  • Know how far booked revenue is from marketplace revenue before closing taxes.
  • Keep each department's spend within budget and spot overruns early.
  • Collect overdue dealer balances using days sales outstanding.

8 ready-made dashboards

Books and sales channels

Reconcile booked revenue with net revenue from retail channels, and selling and admin expenses over channel revenue.

  • Booked revenue
  • Net revenue
  • Booked vs channel revenue gap
  • Operating expenses to channel revenue
  • Monthly gap between book and channel revenue
  • Monthly expenses over channel revenue

Business results and budget

Ledger revenue, COGS and profit, and selling and admin expenses against budget by cost center.

  • Booked revenue
  • Gross margin %
  • Operating profit
  • Net profit after tax
  • Monthly gross margin
  • Monthly expenses by cost center
  • Expenses vs budget by cost center
  • Expenses by account

Receivables and payables

Credit sales, collections, overdue receivables, days sales outstanding and supplier payments.

  • Credit sales
  • Receivables collected
  • Overdue receivables
  • Average days to collect
  • Receivables by customer
  • Weekly collections
  • Payments by supplier

Profit and loss overview

Actual revenue down to profit after marketplace fees, returns and ads.

  • Net revenue
  • Contribution margin
  • Net profit after fees and ads
  • Net margin
  • From revenue to profit
  • Weekly profit after fees by channel
  • Weekly orders by channel

Sales channels

Compare channels by revenue, fees, return rate, profit and margin.

  • Profit and loss by channel
  • Return rate by channel
  • Profit after fees and ads by channel
  • Cancellation rate by channel
  • Weekly net revenue

Products

SKUs ranked by profit; loss-making SKUs in red; COGS coverage shows which SKUs have no cost yet.

  • Profit by SKU (biggest losses first)
  • Gross profit after fees by category
  • Units sold by SKU
  • Monthly COGS by SKU

Advertising

Spend by platform and campaign, platform-reported ROAS, and the gap between reported and actual revenue by channel.

  • Ad spend
  • Blended ROAS
  • Platform-reported ROAS
  • Ad-reported vs actual revenue gap
  • Ad platform reported vs actual revenue by channel
  • Campaigns
  • Spend by ad platform
  • Monthly platform ROAS by campaign

Data health

Quality test results with row numbers in the Excel file; COGS coverage and unsettled fees.

  • COGS coverage
  • Provisional fee rate
  • Data quality checks
  • COGS coverage by SKU

Ask Si as soon as the build finishes

  • “How did operating expenses to channel revenue change compared with last month?”
  • “What is driving booked vs channel revenue gap this quarter?”
  • “Show vendor payments by month for the last six months.”
  • “Where is receivables collected highest this month, and why?”

37 defined metrics

Versioned definitions, shared by dashboards, Si, reports and MCP.

MetricDefinitionUnit
Operating expenses to channel revenueBooked selling and administrative expenses divided by net revenue of the retail channels.= Selling and administrative expenses / Net revenueRatio (%)
Booked vs channel revenue gapBooked revenue minus net revenue computed from retail channel orders. Positive means the books show more than the channels: off-channel revenue (credit sales to dealers) or timing differences in recognition.= Booked revenue - Net revenueCurrency
Vendor paymentsTotal value of payable invoices paid, by payment date.Currency
Receivables collectedTotal value of receivable invoices collected, by collection date.Currency
Credit salesTotal value of credit sales invoices (creating accounts receivable) by invoice date.Currency
Average days to collectAverage days from invoice date to collection date for invoices collected in the period.= fin_collect_days_total / fin_ar_collected_countNumber
Expense budgetBudget for selling and administrative expense accounts. Budgets are set monthly, recorded on the first day of the month.Currency
Cost of goods sold (ledger)Debit postings minus credit postings on the cost of goods sold account (account 632).Currency
Gross margin %Gross profit divided by booked revenue.= (Booked revenue - Cost of goods sold (ledger)) / Booked revenueRatio (%)
Gross profitBooked revenue minus cost of goods sold.= Booked revenue - Cost of goods sold (ledger)Currency
Net profit after taxCredits minus debits across all income statement accounts (revenue, cost of goods sold, expenses, financial income and expenses, other income and expenses, corporate income tax).Currency
Operating profitGross profit minus selling and administrative expenses. Excludes financial income and expenses and other income and expenses.= Booked revenue - Cost of goods sold (ledger) - Selling and administrative expensesCurrency
Selling and administrative expensesDebit postings minus credit postings on selling expense (account 641) and general administrative expense (account 642) accounts; under Circular 133 these are accounts 6421, 6422.Currency
Expenses vs budgetActual selling and administrative expenses divided by budget. Above 100% means over budget.= Selling and administrative expenses / Expense budgetRatio (%)
Overdue receivablesTotal value of invoices due in the period that remain uncollected as of the data date.Currency
Booked revenueGeneral ledger revenue: credit postings minus debit postings on revenue accounts (account 511), net of revenue deductions (account 521). Excludes financial income and other income.Currency
Ad spendTotal advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to.Currency
Average order valueLine revenue after discounts divided by valid orders.= line_net_total / Valid ordersCurrency
Cancellation rateCancelled orders divided by total orders.= cancelled_orders / all_ordersRatio (%)
Cost of goods soldQuantity times unit cost on the order date (half-open validity interval). SKUs without a cost count as 0; see COGS coverage. Returned lines do not reverse their COGS.Currency
COGS coverageShare of line revenue (after discounts) coming from SKUs that have a cost. Below 100% means the profit metrics are overstated.= line_net_with_cost / line_net_totalRatio (%)
Contribution marginNet revenue minus COGS, marketplace fees, payment fees, shipping and return costs (before advertising).= Net revenue - Cost of goods sold - Marketplace fees - Payment fees - Seller-paid shipping cost - Return costCurrency
GMV (gross merchandise value)Total quantity times unit price of the order lines in valid orders (before discounts, vouchers and refunds).Currency
Net marginProfit after fees and advertising divided by net revenue.= Net profit after fees and ads / Net revenueRatio (%)
Net profit after fees and adsNet revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spendCurrency
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
Valid ordersOrders that were not cancelled (standard status other than cancelled).Count
Payment feesMarketplace transaction fees and payment gateway fees, allocated to lines by line revenue.Currency
Marketplace feesMarketplace commission and service fees, allocated to lines by line revenue.Currency
Ad-reported vs actual revenue gapAd-platform-reported revenue minus actual net revenue for the same channel and period. Positive means the platform reports more than reality.= ad_conversion_value - Net revenueCurrency
Provisional fee rateShare of fees (marketplace, payment, shipping) not yet settled, which may still change.= provisional_fees / (Marketplace fees + Payment fees + Seller-paid shipping cost)Ratio (%)
Return costReturn shipping cost borne by the shop. Does NOT include refunds to buyers (already deducted in net revenue).Currency
Return rateReturned orders divided by valid orders.= returned_orders / Valid ordersRatio (%)
Blended ROASActual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spendNumber
Platform-reported ROASAd-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spendNumber
Seller-paid shipping costOutbound shipping cost paid by the shop, allocated to lines by line revenue.Currency
Units soldTotal quantity of products in the order lines of valid orders.Count

Data you need

Required

channel, product, order, order_line, fin_account, fin_journal_line

Add if you have it (unlocks more metrics)

product_cost, customer, cost, return, ad_performance_daily, fin_cost_center, fin_budget, fin_ar_invoice, fin_ap_bill

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: channel, product, order, order_line, fin_account, fin_journal_line.

  2. 2

    Approve Si's proposal

    Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.

  3. 3

    Dashboards and Q&A

    The build gives you 8 dashboards and 37 metrics; ask Si anytime.

Data sources for this template

Connectors with a setup guide that feed the entities this template needs. Excel always works.

Related templates

Build Retail · Finance & accounting with your own data

Free plan with no time limit · No card required · Sample workspace ready in minutes