Profit loss

Skill openaccountant/skills/business/profit-loss

44 open-source financial skills for AI agents — P&L, budgeting, tax prep, debt payoff, and more. Works with Claude Code, Wilson, Cursor, Codex, and Paperclip.

Install

npx -y skills add openaccountant/skills --skill profit-loss

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

What its author says it does

Copied from the file, not written here

Generate a profit and loss statement for any date range.

SKILL.md

3.8 KB, as published. Nobody here has run it

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

Ask for the reporting period (e.g., "Q1 2026" or "January 2026").
Use transaction_search with amount > 0 to find all revenue transactions in the period.
Use transaction_search with amount < 0 to find all expense transactions.
Use spending_summary for the same period to get category-level expense totals.
Separate COGS categories (materials, supplies, direct labor) from operating expenses (rent, utilities, software, payroll, insurance).
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%
═══════════════════════════════════════

Calculate Gross Margin = (Gross Profit / Total Revenue) * 100.
Calculate Net Margin = (Net Income / Total Revenue) * 100.

Without Wilson

Export transactions from your bank as CSV (Chase: Accounts > Activity > Download, select CSV; Amex: Statements & Activity > Download Your Transactions).
Open in Excel or Google Sheets.
Add a "Type" column. Mark each row as Revenue, COGS, or Operating Expense.
Use =SUMIFS(Amount, Type, "Revenue") for total revenue.
Use =SUMIFS(Amount, Type, "COGS") for total COGS (use absolute values).
Gross Profit = Revenue - COGS. Gross Margin formula: =GrossProfit/Revenue*100.
Use =SUMIFS(Amount, Type, "Operating Expense") for total OpEx.
Net Income = Gross Profit - Operating Expenses. Net Margin: =NetIncome/Revenue*100.
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.