Profit & Loss Statement

Overview

Build a standard income statement (P&L) showing revenue, cost of goods sold, gross profit, operating expenses, and net income. Calculates gross margin and net margin percentages.

Wilson Tools Used

• transaction_search — pull all income transactions (positive amounts) and expense transactions (negative amounts) for the target period
• spending_summary — aggregate expenses by category to populate operating expense line items

Workflow

1. Ask for the reporting period (e.g., "Q1 2026" or "January 2026").
2. Use transaction_search with amount > 0 to find all revenue transactions in the period.
3. Use transaction_search with amount < 0 to find all expense transactions.
4. Use spending_summary for the same period to get category-level expense totals.
5. Separate COGS categories (materials, supplies, direct labor) from operating expenses (rent, utilities, software, payroll, insurance).
6. Build the P&L using this format: