Skip to content

Dashboard templates

Media & advertising · Finance & accounting

A digital advertising agency buying media for brand clients and keeping books under Circular 200 (VN accounting). Media P&L by client, campaign and platform plus ledger results, expenses against budget by department, client receivables, payments to ad platforms and reconciliation of the books with delivery reports.

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

For accountants and CFOs at agencies buying media for brands. The "Books and media" dashboard reconciles the general ledger with delivery reports: the gap between booked revenue and client billings, and between booked cost of sales and platform media cost. The "Business results and budget" and "Receivables and payables" dashboards cover profit, spend vs budget by department, brand receivables and platform payables. Needs client, campaign, daily delivery, chart of accounts and general ledger entry data.

Use this template to

  • Spot months where client billings were not booked as revenue or were booked twice.
  • Check that booked cost of sales matches platform media cost before closing.
  • Chase brands with overdue balances and see when ad platform payments are due.

5 ready-made dashboards

Books and media

Reconcile booked revenue and COGS with billed amount and media cost in delivery reports.

  • Booked revenue
  • Client billings
  • Booked revenue vs client billings gap
  • Booked COGS vs platform media cost gap
  • Monthly gap between booked revenue and billed amount
  • Monthly gap between booked COGS and media cost
  • Overdue receivables by client
  • Payments by supplier

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

Media overview

Billed revenue, media cost, gross profit and budget pacing by client and client group.

  • Client billings
  • Media gross profit
  • Media gross margin
  • Budget pacing
  • Profit and loss by client
  • Gross profit by client group
  • Budget pacing by campaign
  • Weekly billed revenue

Delivery performance

Impressions, clicks, conversions and buying costs (CPM, CPC, CPA) by platform, campaign and campaign objective.

  • Impressions
  • Click-through rate (CTR)
  • Cost per click (CPC)
  • Cost per acquisition (CPA)
  • By ad platform
  • Monthly CPA by platform
  • By campaign
  • CTR by campaign objective

Ask Si as soon as the build finishes

  • “How did booked COGS vs platform media cost gap change compared with last month?”
  • “What is driving booked revenue vs client billings gap this quarter?”
  • “Show vendor payments by month for the last six months.”
  • “Where is receivables collected highest this month, and why?”

36 defined metrics

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

MetricDefinitionUnit
Booked COGS vs platform media cost gapBooked cost of goods sold (ad platform invoices received) minus platform media cost reported in delivery reports for the same period. Negative means ads have run but the platform invoice has not arrived or been booked.= Cost of goods sold (ledger) - Media costCurrency
Booked revenue vs client billings gapBooked accounting revenue minus media client billings delivered in the same period. Positive means the books show more than delivery reports: non-media service fees (creative retainers) or late invoices from a prior period; negative means media has run but has not been invoiced.= Booked revenue - Client billingsCurrency
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
Client billingsTotal billed to clients for media delivered (media cost plus the service fee per IO, capped at the budget), by delivery date.Currency
New IO booked valueTotal value of insertion orders (IO) signed in the period, by signing date, excluding cancelled IOs.Currency
Budget pacingMedia cost divided by the planned budget for the same period. 1 means on plan; above 1 means spending faster than planned.= Media cost / Planned media budgetRatio (%)
ClicksTotal ad clicks reported by the platforms.Count
Profit after laborMedia gross profit minus labor cost from logged hours. Fixed costs such as office rent are not deducted.= Client billings - Media cost - Labor costCurrency
Platform-reported conversion valueTotal order value of the clients' customers as reported by the ad platforms themselves. Not the business's revenue.Currency
ConversionsTotal conversions (purchases, leads, app installs) reported by the platforms.Count
Media costTotal paid to ad platforms to buy impressions, by delivery date.Currency
Cost per acquisition (CPA)Media cost divided by conversions.= Media cost / ConversionsCurrency
Cost per click (CPC)Media cost divided by clicks.= Media cost / ClicksCurrency
Cost per thousand impressions (CPM)Media cost per 1,000 impressions.= Media cost * 1000 / ImpressionsCurrency
Click-through rate (CTR)Clicks divided by impressions.= Clicks / ImpressionsRatio (%)
Media gross profitClient billings minus media cost. Negative when media spend exceeds the billable amount.= Client billings - Media costCurrency
Logged hoursTotal staff hours logged against clients and campaigns.Number
ImpressionsTotal ad impressions reported by the platforms.Count
Labor costLogged hours multiplied by the internal hourly rate for each role.Currency
Media gross marginMedia gross profit divided by client billings.= (Client billings - Media cost) / Client billingsRatio (%)
Planned media budgetCampaign media budget spread evenly over its flight days, summed over the period (only days that already have data).Currency
Gross profit per hourMedia gross profit (the business's net revenue after paying the platforms) divided by logged hours.= (Client billings - Media cost) / Logged hoursCurrency
Platform-reported ROASPlatform-reported conversion value divided by media cost.= Platform-reported conversion value / Media costNumber

Data you need

Required

client, campaign, delivery_daily, fin_account, fin_journal_line

Add if you have it (unlocks more metrics)

insertion_order, timesheet, 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: client, campaign, delivery_daily, 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 5 dashboards and 36 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 Media & advertising · Finance & accounting with your own data

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