Interactive analytics showcase

Profit & Loss
Dashboard

A profit and loss dashboard that turns example transactions into a clear view of revenue, expenses and net profit. Explore monthly performance, spending categories and the records behind each figure.

Sample dataset · January–June 2026 Explore dashboard ↓

Portfolio demonstration. Figures are example data, not my earnings or verified client results. The $ symbol follows the sample dataset; currency jurisdiction is unspecified.

Financial overview

Business Performance

TOTAL REVENUE $46,500 Sum of income records
TOTAL EXPENSES $7,470 Sum of expense records
NET PROFIT $39,030 Revenue minus expenses
PROFIT MARGIN 83.9% Net profit ÷ revenue

Revenue vs Expenses

Revenue Expenses
$0$2,325$4,650$6,975$9,300Jan: $6,200Jan: $830JanFeb: $6,900Feb: $1,170FebMar: $7,400Mar: $1,130MarApr: $8,100Apr: $930AprMay: $8,600May: $1,310MayJun: $9,300Jun: $2,100Jun

Expense Breakdown

  • Advertising$2,330 · 31.2%
  • Contractors$2,050 · 27.4%
  • Taxes$1,200 · 16.1%
  • Shipping$520 · 7.0%
  • Supplies$410 · 5.5%
  • Software$390 · 5.2%
  • Professional Fees$350 · 4.7%
  • Utilities$220 · 2.9%

Net Profit Trend

Monthly profit within the selected reporting period.

$0Jan: $5,370$5,370JanFeb: $5,730$5,730FebMar: $6,270$6,270MarApr: $7,170$7,170AprMay: $7,290$7,290MayJun: $7,200$7,200Jun

Sample insight: May has the highest net profit in this selection ($7,290). Largest expense category: Advertising.

Transaction Details

18 of 18 records

Search filters this table only. KPI cards and charts follow the reporting period.

Sample transaction records
DateTypeCategoryDescriptionAmount
2026-01-04IncomeProduct SalesJanuary sales$6,200
2026-01-06ExpenseAdvertisingPaid ads$650
2026-01-10ExpenseSoftwareSubscriptions$180
2026-02-04IncomeService RevenueClient services$6,900
2026-02-09ExpenseContractorsContractor support$950
2026-02-15ExpenseUtilitiesUtilities$220
2026-03-03IncomeConsultingConsulting projects$7,400
2026-03-08ExpenseAdvertisingMarketing campaign$780
2026-03-14ExpenseProfessional FeesProfessional support$350
2026-04-05IncomeProduct SalesApril sales$8,100
2026-04-12ExpenseShippingShipping costs$520
2026-04-18ExpenseSuppliesBusiness supplies$410
2026-05-04IncomeService RevenueMay services$8,600
2026-05-10ExpenseSoftwareSoftware tools$210
2026-05-16ExpenseContractorsProject support$1,100
2026-06-04IncomeProduct SalesJune sales$9,300
2026-06-13ExpenseAdvertisingPaid advertising$900
2026-06-20ExpenseTaxesTax reserve$1,200
Project contribution

What This Shows

This portfolio sample demonstrates dashboard layout, transaction aggregation, KPI presentation, interactive period filtering and chart design.

Use the month selector to see how the same transaction records flow through every metric and chart.

Format: Interactive HTML dashboard. This preview is not an embedded Power BI report.

Transparent methodology

How Figures Are Calculated

Revenue = total Income records.
Expenses = total Expense records.
Net profit = Revenue − Expenses.
Profit margin = Net profit ÷ Revenue × 100.

The sample covers the listed transactions only. Costs not recorded in the dataset are not included, so these margins should not be treated as a complete real-business financial assessment.

Turn your records into useful reporting

Need a Clearer View of Your Business?

Share your data format, reporting goals and the questions you want answered. We can discuss a suitable dashboard scope.

Discuss your dashboard →
Duaa Batool · Data Analysis Portfolio · Sample-data dashboard