I designed an Excel financial dashboard that turns a business's accounting data into one page the owner can read in a minute. Instead of going through separate P&L and balance sheet reports, they see revenue, profit, cash, receivables, payables, and equity together.
What the dashboard includes:
Headline KPI cards: total revenue, gross profit, net profit, cash and bank, accounts receivable, accounts payable, total assets, total liabilities, and equity
Profit & Loss summary:
net sales, other income, cost of goods sold, gross profit, operating cost, and net profit, each shown as a percentage of revenue
Operating expense breakdown:
expenses by category (salaries, interest, marketing, depreciation, legal and audit, rent, commissions, freight, training) with each one's share of total expenses
Balance sheet summary:
cash, receivables, inventory, prepayments, fixed assets, payables, short-term and long-term loans, and equity
Charts: income components and asset composition, for quick visual comparison
Result:
The owner can see profitability, cost structure, and financial position at a glance. For example, they can tell that salaries make up nearly half of operating costs and that net profit is about 46% of revenue. It works for monthly reviews, lender conversations, and budgeting.
Noorly is a modern EdTech SaaS dashboard designed for teachers, students, and parents.
The platform brings classroom management, assignments, student analytics, performance reports, and parent communication into one cohesive experience. The design combines a playful purple and lime green color palette with soft pastel tones, rounded cards, and clear data visualizations.
The goal is to make complex business data easier to scan and understand through clear visual hierarchy, structured analytics cards, and organized navigation.
Still refining the details and exploring ways to make the experience more intuitive.
What matters more to you in a dashboard: clean visuals or faster access to insightful?
For a dashboard like this, I’d test whether the key action stays visible when the cards are filled with real, uneven data—not just placeholder numbers. What kind of business data are you designing the first view around?