Small Business Financial Dashboard

Small Business Financial Dashboard

A comprehensive financial workbook for small businesses that brings together your P&L statement, cash flow tracker, balance sheet, and financial forecasting into a single, interconnected spreadsheet. Built for Google Sheets and Microsoft Excel.

What's Included

This workbook contains 7 interconnected tabs that give you a complete picture of your business finances:

Key Features

• Automated P&L — Revenue and expenses roll up automatically from your transaction data
• Cash Flow Visibility — See exactly where cash enters and exits the business each month
• Balance Sheet — Track assets vs. liabilities with automatic equity calculation
• KPI Indicators — Gross margin, net margin, burn rate, current ratio, quick ratio at a glance
• 12-Month Forecast — Project revenue and expenses forward using growth assumptions
• Sparkline Charts — Mini trend charts embedded in cells for quick visual scanning
• Conditional Formatting — Red/amber/green indicators for KPIs that miss targets

Tab-by-Tab Walkthrough

01 - P&L Statement

Your monthly income statement. Revenue lines at the top (services, products, recurring), cost of goods sold in the middle, and operating expenses at the bottom. The "Net Income" row is the final summary. Each column represents one month, with a trailing 12-month total column.

02 - Cash Flow

Follows the indirect method: start with net income, adjust for non-cash items (depreciation, changes in receivables/payables), then show investing activities (equipment purchases, asset sales) and financing (loans, owner draws). Ending cash balance feeds into the balance sheet.

03 - Balance Sheet

Point-in-time snapshot: current assets (cash, receivables, inventory), fixed assets (equipment, less depreciation), current liabilities (payables, credit lines), long-term liabilities (loans), and owner's equity. Assets must equal liabilities + equity — a check formula flags any imbalance.

04 - Revenue Breakdown

Each revenue stream gets its own row with monthly figures. Includes percentage-of-total calculations and month-over-month growth rates. Useful for identifying which products or services are driving (or dragging) performance.

05 - Expense Tracker

Raw transaction log: date, vendor, category, amount, payment method, notes. Categories roll up into the P&L automatically via SUMIFS formulas. This is where you do your day-to-day data entry.

06 - KPI Dashboard

Summary metrics calculated from the other tabs. Each KPI shows current value, target, variance, and a 6-month trend (sparkline-ready data). Includes gross margin, net margin, current ratio, quick ratio, accounts receivable days, and monthly burn rate.

07 - Forecast

Enter growth assumptions (revenue growth rate, expense inflation rate, hiring plans) and see a 12-month projection. Includes best-case, base-case, and worst-case scenarios. Revenue forecast uses compound growth; expenses use category-specific multipliers.

Quick Start (5 minutes)

1. Import all CSV files as separate tabs (see docs/IMPORT-GUIDE.md)

2. Review the sample data to understand the structure

3. Clear sample data from the Expense Tracker tab (keep headers and formulas)

4. Enter your own revenue categories in the Revenue Breakdown tab

5. Start logging expenses — the P&L and KPI Dashboard update automatically

Works In Both Google Sheets and Excel

... continues with setup instructions, usage examples, and more.