mcpField
P
profit-loss

profit-loss

github.com/openaccountantData & databases103456 installsUpdated 29w ago
Repository

About profit-loss

profit-loss is a skill for preparing cash-basis income statements from transaction data. It organizes revenue, COGS, and operating expenses, then calculates gross and net margins.

Key features

  1. 01Period-based revenue and expense totals
  2. 02COGS and operating expense classification
  3. 03Gross profit and margin calculations
  4. 04Net income and margin calculations

Use cases

  1. 01Prepare a monthly or quarterly P&L
  2. 02Review cash-basis business results
  3. 03Compare margins across reporting periods

MCP support

The skill uses Wilson's `transaction_search` and `spending_summary` tools to gather income and expense data.

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/openaccountant/skills --skill profit-loss

After installing, type/profit-lossin Claude Code to confirm it loaded.

Details

From the project README

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:
PROFIT & LOSS STATEMENT — [Period]
═══════════════════════════════════════
Revenue
  Sales Revenue                  $XX,XXX
  Service Revenue                $XX,XXX
───────────────────────────────────────
  Total Revenue                  $XX,XXX

Cost of Goods Sold
  Materials                      ($X,XXX)
  Direct Labor                   ($X,XXX)
───────────────────────────────────────
  Total COGS                     ($X,XXX)

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

Operating Expenses
  Rent                           ($X,XXX)
  Utilities                        ($XXX)
  Software & Subscriptions         ($XXX)
  Payroll                        ($X,XXX)
  Insurance                        ($XXX)
  Other                            ($XXX)
───────────────────────────────────────
  Total Operating Expenses       ($X,XXX)

NET INCOME                        $X,XXX
  Net Margin                        XX.X%
═══════════════════════════════════════
  1. Calculate Gross Margin = (Gross Profit / Total Revenue) * 100.
  2. Calculate Net Margin = (Net Income / Total Revenue) * 100.

Without Wilson

  1. Export transactions from your bank as CSV (Chase: Accounts > Activity > Download, select CSV; Amex: Statements & Activity > Download Your Transactions).
  2. Open in Excel or Google Sheets.
  3. Add a "Type" column. Mark each row as Revenue, COGS, or Operating Expense.
  4. Use =SUMIFS(Amount, Type, "Revenue") for total revenue.
  5. Use =SUMIFS(Amount, Type, "COGS") for total COGS (use absolute values).
  6. Gross Profit = Revenue - COGS. Gross Margin formula: =GrossProfit/Revenue*100.
  7. Use =SUMIFS(Amount, Type, "Operating Expense") for total OpEx.
  8. Net Income = Gross Profit - Operating Expenses. Net Margin: =NetIncome/Revenue*100.
  9. For multi-month P&L, add a =TEXT(Date,"YYYY-MM") column and use pivot tables to break out by month.

Important Notes

  • Wilson uses negative amounts for expenses and positive for income. The P&L should display expenses as positive numbers in parentheses.
  • COGS vs. operating expense classification depends on your business type. A freelancer may have zero COGS. A product business should separate materials and shipping from overhead.
  • This is a cash-basis P&L (based on transaction dates), not accrual. If you invoice Net-30, revenue appears when paid, not when invoiced.

Comments

Markdown supported