Profit Loss Report

1. Determine the reporting period (month or quarter)
2. Gather revenue data — ask the user for one of:
   • CSV or spreadsheet file with transactions
   • Manual list of income sources and amounts
   • Bank/payment processor summary (Stripe, PayPal, Square)
3. Gather expense data — same formats as above
4. Confirm the business type (service, e-commerce, digital products, hybrid) to set appropriate categories

Phase 2: Categorize Transactions

5. Sort all revenue into these standard categories:

6. Sort all expenses into these standard categories:

7. GATE: If any transaction is ambiguous, ask the user to clarify before proceeding. Do not guess categories for amounts over $500.

Phase 3: Generate the P&L Report

8. Build the report using this format:

PROFIT & LOSS STATEMENT
[Business Name]
Period: [Start Date] — [End Date]

═══════════════════════════════════════════════════
REVENUE
───────────────────────────────────────────────────
Product Sales                          $XX,XXX.XX
Service Revenue                        $XX,XXX.XX
Recurring Revenue                      $XX,XXX.XX
Affiliate/Commission                   $XX,XXX.XX
Other Income                           $XX,XXX.XX
───────────────────────────────────────────────────
TOTAL REVENUE                          $XX,XXX.XX

═══════════════════════════════════════════════════
COST OF GOODS SOLD (COGS)
───────────────────────────────────────────────────
[Itemized COGS]                        $XX,XXX.XX
───────────────────────────────────────────────────
TOTAL COGS                             $XX,XXX.XX

═══════════════════════════════════════════════════
GROSS PROFIT                           $XX,XXX.XX
GROSS MARGIN                                XX.X%

═══════════════════════════════════════════════════
OPERATING EXPENSES
───────────────────────────────────────────────────
Marketing & Advertising                $X,XXX.XX
Software & Tools                       $X,XXX.XX
Contractor & Freelancer                $X,XXX.XX
Office & Operations                    $X,XXX.XX
Professional Services                  $X,XXX.XX
Travel & Meals                         $X,XXX.XX
Insurance                              $X,XXX.XX
Education & Training                   $X,XXX.XX
Miscellaneous                          $X,XXX.XX
───────────────────────────────────────────────────
TOTAL OPERATING EXPENSES               $XX,XXX.XX

═══════════════════════════════════════════════════
NET PROFIT (LOSS)                      $XX,XXX.XX
NET MARGIN                                  XX.X%
═══════════════════════════════════════════════════

Phase 4: Add Analysis

9. Below the report, include:
   • Top 3 expense categories by dollar amount
   • Gross margin assessment: Above 50% is healthy for services, above 30% for physical products
   • Net margin assessment: Above 20% is strong, 10-20% is acceptable, below 10% needs attention
   • Month-over-month or quarter-over-quarter trend if prior period data is available
   • One actionable recommendation based on the numbers

Phase 5: Deliver

10. Output the formatted P&L report
11. Output the analysis summary
12. Save to a file if the user requests it

Example 1: Freelance Designer — Monthly P&L

Input data provided by user: "January revenue: 3 client projects at $2,500, $4,000, and $1,800. Sold 12 Canva templates at $29 each. Expenses: Adobe Creative Cloud $55, Figma $15, Webflow hosting $29, hired a VA for 20 hours at $25/hour, Facebook ads $350, co-working space $200, business insurance $89, bought a Skillshare course for $45."

PROFIT & LOSS STATEMENT
Ava Park Design Studio
Period: January 1 — January 31, 2026

═══════════════════════════════════════════════════
REVENUE
───────────────────────────────────────────────────
Service Revenue (3 client projects)    $8,300.00
Product Sales (12 Canva templates)       $348.00
───────────────────────────────────────────────────
TOTAL REVENUE                          $8,648.00

═══════════════════════════════════════════════════
COST OF GOODS SOLD (COGS)
───────────────────────────────────────────────────
Canva Pro (template hosting)              $13.00
───────────────────────────────────────────────────
TOTAL COGS                                $13.00

═══════════════════════════════════════════════════
GROSS PROFIT                           $8,635.00
GROSS MARGIN                              99.8%

═══════════════════════════════════════════════════
OPERATING EXPENSES
───────────────────────────────────────────────────
Marketing & Advertising                  $350.00
Software & Tools                          $99.00
  - Adobe Creative Cloud     $55.00
  - Figma                    $15.00
  - Webflow                  $29.00
Contractor & Freelancer                  $500.00
  - Virtual Assistant (20hrs x $25)
Office & Operations                      $200.00
  - Co-working space
Insurance                                 $89.00
Education & Training                      $45.00
  - Skillshare course
───────────────────────────────────────────────────
TOTAL OPERATING EXPENSES               $1,283.00

═══════════════════════════════════════════════════
NET PROFIT                             $7,352.00
NET MARGIN                                85.0%
═══════════════════════════════════════════════════

Analysis:

• Top 3 expenses: Contractor ($500), Marketing ($350), Office ($200)
• Gross margin: 99.8% — Exceptional. Typical for service businesses with minimal COGS.
• Net margin: 85.0% — Very strong. Well above the 20% benchmark for healthy businesses.
• Recommendation: Marketing spend ($350) generated $8,648 in revenue. If those Facebook ads are driving client inquiries, consider increasing ad budget to $500-$700 to test whether revenue scales proportionally.

Example 2: E-Commerce Candle Business — Quarterly P&L

Input data: Q4 2025 — sold 847 candles at $32 average price, 45 gift sets at $78 each. COGS per candle $9, per gift set $28. Expenses: Shopify $79/mo, shipping supplies $1,240, Instagram ads $2,100, hired a photographer $800, packaging designer $450, PO Box $45/mo, product liability insurance $125/quarter, attended a craft fair (booth fee $350 + travel $280).

PROFIT & LOSS STATEMENT
Ember & Sage Candle Co.
Period: October 1 — December 31, 2025 (Q4)

═══════════════════════════════════════════════════
REVENUE
───────────────────────────────────────────────────
Product Sales (847 candles)           $27,104.00
Product Sales (45 gift sets)           $3,510.00
───────────────────────────────────────────────────
TOTAL REVENUE                         $30,614.00

═══════════════════════════════════════════════════
COST OF GOODS SOLD (COGS)
───────────────────────────────────────────────────
Candle materials (847 x $9)            $7,623.00
Gift set materials (45 x $28)          $1,260.00
Shipping supplies                      $1,240.00
───────────────────────────────────────────────────
TOTAL COGS                           $10,123.00

═══════════════════════════════════════════════════
GROSS PROFIT                          $20,491.00
GROSS MARGIN                              66.9%

═══════════════════════════════════════════════════
OPERATING EXPENSES
───────────────────────────────────────────────────
Marketing & Advertising                $2,100.00
  - Instagram ads
Software & Tools                         $237.00
  - Shopify ($79 x 3 months)
Contractor & Freelancer                $1,250.00
  - Photographer              $800.00
  - Packaging designer        $450.00
Office & Operations                      $135.00
  - PO Box ($45 x 3 months)
Insurance                                $125.00
  - Product liability (quarterly)
Travel & Events                          $630.00
  - Craft fair booth           $350.00
  - Travel                    $280.00
───────────────────────────────────────────────────
TOTAL OPERATING EXPENSES               $4,477.00

═══════════════════════════════════════════════════
NET PROFIT                            $16,014.00
NET MARGIN                                52.3%
═══════════════════════════════════════════════════

Analysis:

• Top 3 expenses (excluding COGS): Marketing ($2,100), Contractors ($1,250), Travel/Events ($630)
• Gross margin: 66.9% — Strong for physical products (benchmark: 30%+). Gift sets have lower margin (64%) vs. candles (72%) due to higher COGS ratio.
• Net margin: 52.3% — Excellent. Well above the 20% target.
• Q4 vs. typical quarter: Holiday season likely inflated revenue. Track Q1 to establish a non-seasonal baseline.
• Recommendation: Gift sets generated $3,510 on 45 units. Test increasing gift set promotion — the AOV ($78) is 2.4x a single candle ($32), and despite the lower margin percentage, profit per gift set ($50) is higher than profit per candle ($23).

Recovery and Fallback

• If the user cannot provide exact numbers, help them estimate from bank statements or payment processor dashboards (Stripe Dashboard > Payments > Export)
• If categories are unclear, ask the user for the three largest expenses and their purpose — this usually reveals the right categorization
• If the user has mixed personal and business transactions, flag this and only include clearly business-related items — recommend they open a separate business bank account
• If prior period data is unavailable for comparison, note this in the report and recommend starting monthly tracking going forward

Constraints

• Always include the financial disclaimer — this is not a substitute for professional accounting
• Do not estimate tax liability — recommend consulting a CPA for tax calculations
• Do not include owner draws/salary in operating expenses unless the user explicitly requests it (this is an accounting choice)
• If transactions are a mix of personal and business, ask the user to separate them — do not categorize personal expenses as business
• Round all amounts to two decimal places
• Use accrual basis by default (revenue when earned, expenses when incurred), but switch to cash basis if the user specifies
• Do not provide investment advice based on P&L results