Profit & Loss

Overview

The Profit & Loss skill generates formatted income statements (P&L reports) for any time period, breaking down revenue streams and expense categories with margin calculations.

Standard P&L Format

Revenue
  Service revenue          $XX,XXX
  Product revenue          $XX,XXX
  Other income             $XX,XXX
  ────────────────────────────────
  Total Revenue            $XX,XXX

Cost of Goods Sold (COGS)
  Materials                $XX,XXX
  Direct labor             $XX,XXX
  ────────────────────────────────
  Total COGS               $XX,XXX

GROSS PROFIT               $XX,XXX
  Gross Margin             XX.X%

Operating Expenses
  Marketing & Advertising  $XX,XXX
  Office & Supplies        $XX,XXX
  Software & Tools         $XX,XXX
  Professional Services    $XX,XXX
  Insurance                $XX,XXX
  Travel                   $XX,XXX
  Meals & Entertainment    $XX,XXX
  Utilities                $XX,XXX
  Other                    $XX,XXX
  ────────────────────────────────
  Total Operating Expenses $XX,XXX

NET INCOME                 $XX,XXX
  Net Margin               XX.X%

Workflow

Identify revenue — Finds all income/credit transactions for the requested period, categorized by revenue stream
Identify COGS — Separates cost of goods sold from operating expenses
Categorize operating expenses — Breaks down all other expenses by category
Calculate margins:
- Gross Profit = Revenue - COGS
- Gross Margin = Gross Profit / Revenue x 100
- Net Income = Gross Profit - Operating Expenses
- Net Margin = Net Income / Revenue x 100
Period comparison — Optionally compares against prior period (MoM or QoQ)
Generate P&L report — Formatted statement with all breakdowns
Export — Underlying data export available

Usage

/skill profit-loss

Or ask naturally:

Show me a P&L for last quarter
Generate an income statement for January through March

You can also use the CLI flag:

wilson --pnl month
wilson --pnl quarter --offset 1