> ## Documentation Index
> Fetch the complete documentation index at: https://help.agatabo.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Profit & Loss Statement
> View income, expenses, and net profit or loss for a specific period
## What is a Profit & Loss Statement?
The **Profit & Loss Statement** (P\&L, also called Income Statement) shows revenue earned minus expenses incurred during a specific period, resulting in net profit or loss. Unlike the balance sheet (which shows position at a point in time), the P\&L shows performance over a period.
**Key formula**: Net Profit/Loss = Total Revenue - Total Expenses
* **Profit** (positive): Revenue > Expenses (organization made money)
* **Loss** (negative): Expenses > Revenue (organization lost money)
***
## API Endpoint
**Get profit & loss report:**
```http theme={null}
GET /reports/profit-loss?startDate={date}&endDate={date}
Headers:
x-organization-id: {organizationId}
```
**Query parameters:**
| Parameter | Type | Required | Description |
| ----------- | ----------------- | -------- | ---------------------------------------------------------------------------------- |
| `startDate` | string (ISO date) | No | Period start date (YYYY-MM-DD). Defaults to organization creation date if omitted. |
| `endDate` | string (ISO date) | No | Period end date (YYYY-MM-DD). Defaults to current date if omitted. |
**Response structure:**
```json theme={null}
{
"message": "Profit/loss report fetched successfully",
"data": {
"periodStart": "2026-01-01T00:00:00.000Z",
"periodEnd": "2026-06-30T23:59:59.999Z",
"revenue": {
"total": 2350000,
"items": [
{
"name": "Interest Income",
"amount": 2000000,
"percentage": 85.11
},
{
"name": "Entry Fee Income",
"amount": 250000,
"percentage": 10.64
},
{
"name": "Penalty Income",
"amount": 100000,
"percentage": 4.26
}
]
},
"expenses": {
"total": 1450000,
"items": [
{
"name": "Operating Expense",
"amount": 1200000,
"percentage": 82.76
},
{
"name": "Bank Charge Expense",
"amount": 150000,
"percentage": 10.34
},
{
"name": "Bad Debt Expense",
"amount": 100000,
"percentage": 6.90
}
]
},
"netProfitLoss": 900000
}
}
```
***
## Report Structure
### Revenue Section
**Revenue (Income) accounts:**
All INCOME type accounts with activity during the period are included:
| Account Role | Description | Example |
| ------------------------------- | --------------------------- | ------------- |
| **INTEREST\_INCOME** | Interest earned on loans | 2,000,000 RWF |
| **PENALTY\_INCOME** | Late payment penalties | 100,000 RWF |
| **ENTRY\_FEE\_INCOME** | Membership fees | 150,000 RWF |
| **DISBURSEMENT\_FEE\_INCOME** | Loan processing fees | 100,000 RWF |
| **BAD\_DEBT\_RECOVERY\_INCOME** | Recovered written-off debts | 0 RWF |
| **OTHER\_INCOME** | Miscellaneous income | 0 RWF |
**For each revenue item:**
* **Name**: Formatted role name (e.g., "Interest Income")
* **Amount**: Total for the period
* **Percentage**: Proportion of total revenue
**Total Revenue**: Sum of all income accounts
***
### Expenses Section
**Expense accounts:**
All EXPENSE type accounts with activity during the period are included:
| Account Role | Description | Example |
| ------------------------- | ------------------------------------------------------------- | ------------- |
| **OPERATING\_EXPENSE** | General operating costs (rent, utilities, salaries, supplies) | 1,200,000 RWF |
| **BANK\_CHARGE\_EXPENSE** | Bank fees and charges | 150,000 RWF |
| **BAD\_DEBT\_EXPENSE** | Loan write-offs | 100,000 RWF |
**For each expense item:**
* **Name**: Formatted role name (e.g., "Operating Expense")
* **Amount**: Total for the period
* **Percentage**: Proportion of total expenses
**Total Expenses**: Sum of all expense accounts
***
### Net Profit/Loss
```
Net Profit/Loss = Total Revenue - Total Expenses
```
**Positive value** = **Profit** (revenue exceeded expenses)
**Negative value** = **Loss** (expenses exceeded revenue)
***
## Example Profit & Loss Statement
**For Period: January 1 - June 30, 2026**
### REVENUE
```
Interest Income 2,000,000 RWF (85.11%)
Entry Fee Income 250,000 RWF (10.64%)
Penalty Income 100,000 RWF (4.26%)
-----------
Total Revenue 2,350,000 RWF (100.00%)
```
***
### EXPENSES
```
Operating Expense 1,200,000 RWF (82.76%)
Bank Charge Expense 150,000 RWF (10.34%)
Bad Debt Expense 100,000 RWF (6.90%)
-----------
Total Expenses 1,450,000 RWF (100.00%)
```
***
### NET PROFIT/LOSS
```
Total Revenue 2,350,000 RWF
Less: Total Expenses -1,450,000 RWF
===========
Net Profit 900,000 RWF ✓
```
**Profit Margin**: 900,000 / 2,350,000 = **38.30%**
***
## Key Financial Metrics
### Profit Margin
```
Profit Margin = (Net Profit / Total Revenue) × 100
```
**Interpretation:**
* Measures profitability efficiency
* Shows how much of each revenue dollar becomes profit
* Higher is better
**Example:**
```
Net Profit: 900,000 RWF
Total Revenue: 2,350,000 RWF
Profit Margin: (900,000 / 2,350,000) × 100 = 38.30%
```
**Benchmarks:**
* Under 10%: Low profitability, review expenses
* 10-20%: Moderate profitability
* 20-40%: Good profitability
* Over 40%: Excellent profitability
***
### Expense Ratio
```
Expense Ratio = (Total Expenses / Total Revenue) × 100
```
**Interpretation:**
* Measures operational efficiency
* Shows how much of revenue goes to expenses
* Lower is better (inverse of profit margin)
**Example:**
```
Total Expenses: 1,450,000 RWF
Total Revenue: 2,350,000 RWF
Expense Ratio: (1,450,000 / 2,350,000) × 100 = 61.70%
```
**Relationship**: Expense Ratio + Profit Margin = 100%
***
### Return on Assets (ROA)
```
ROA = (Net Profit / Total Assets) × 100
```
**Interpretation:**
* Measures how efficiently assets generate profit
* Requires balance sheet data (total assets)
* Higher is better
**Example:**
```
Net Profit (from P&L): 900,000 RWF
Total Assets (from B/S): 23,550,000 RWF
ROA: (900,000 / 23,550,000) × 100 = 3.82% annually
```
**For 6-month period, annualize**: 3.82% × 2 = 7.64% annual ROA
**Benchmarks:**
* Under 3%: Low returns
* 3-6%: Moderate returns
* 6-10%: Good returns
* Over 10%: Excellent returns
***
### Return on Equity (ROE)
```
ROE = (Net Profit / Total Equity) × 100
```
**Interpretation:**
* Measures return to members/owners
* Requires balance sheet data (total equity)
* Higher is better
**Example:**
```
Net Profit (from P&L): 900,000 RWF
Total Equity (from B/S): 5,500,000 RWF
ROE: (900,000 / 5,500,000) × 100 = 16.36% for 6 months
```
**Annualized**: 16.36% × 2 = 32.73% annual ROE
***
## Understanding Results
### Profitable Operations (Revenue > Expenses)
**What it means:**
* Organization earned more than it spent
* Financial health is improving
* Equity is growing
**What you can do:**
* ✅ Distribute dividends to members
* ✅ Allocate to reserves (emergency fund, loan loss reserve)
* ✅ Fund growth and expansion
* ✅ Invest in fixed assets
* ✅ Increase lending capacity
**Example decision:**
```
Net Profit: 900,000 RWF
Allocation:
- Dividends to members: 400,000 RWF (44%)
- Emergency fund reserve: 300,000 RWF (33%)
- Loan loss reserve: 100,000 RWF (11%)
- Retained for growth: 100,000 RWF (11%)
-----------
Total: 900,000 RWF
```
***
### Loss (Expenses > Revenue)
**What it means:**
* Organization spent more than it earned
* Equity is declining
* Unsustainable if continued
**What to do:**
**Review expenses:**
* ❌ Cut unnecessary operating costs
* ❌ Reduce bank charges (negotiate better rates)
* ❌ Minimize bad debt (improve loan screening)
**Increase revenue:**
* ✅ Increase interest rates on loans (if market allows)
* ✅ Expand loan portfolio (more lending)
* ✅ Add fee-based services
* ✅ Improve loan recovery (reduce defaults)
**Example:**
```
Net Loss: -200,000 RWF
Causes:
- Operating expenses too high (80% of revenue)
- Bad debt expense: 300,000 RWF (large write-offs)
- Interest income declining (fewer loans)
Actions:
1. Reduce operating costs by 20% (save 150,000/period)
2. Improve loan screening (reduce bad debt to 100,000)
3. Increase lending by 25% (boost interest income by 500,000)
Expected next period:
Revenue: +500,000, Expenses: -200,000 = +300,000 swing to profit
```
***
## Period Comparisons
### Monthly Trends
**Track performance month-over-month:**
| Month | Revenue | Expenses | Net Profit | Margin |
| --------- | ------------- | ------------- | ----------- | --------- |
| Jan 2026 | 400,000 | 250,000 | 150,000 | 37.5% |
| Feb 2026 | 380,000 | 240,000 | 140,000 | 36.8% |
| Mar 2026 | 420,000 | 260,000 | 160,000 | 38.1% |
| Apr 2026 | 390,000 | 245,000 | 145,000 | 37.2% |
| May 2026 | 410,000 | 255,000 | 155,000 | 37.8% |
| Jun 2026 | 350,000 | 200,000 | 150,000 | 42.9% |
| **Total** | **2,350,000** | **1,450,000** | **900,000** | **38.3%** |
**Analysis:**
* ✅ Consistent profitability (every month profitable)
* ✅ Stable profit margins (36-43%)
* ⚠️ June revenue dipped (investigate why)
* ✅ June expenses also lower (good cost control)
***
### Year-over-Year Comparison
**Compare same period across years:**
| Period | Revenue | Expenses | Net Profit | Growth |
| ------------ | ------------ | ------------ | ------------ | ------ |
| Jan-Jun 2025 | 1,800,000 | 1,200,000 | 600,000 | - |
| Jan-Jun 2026 | 2,350,000 | 1,450,000 | 900,000 | +50% |
| **Change** | **+550,000** | **+250,000** | **+300,000** | |
**Analysis:**
* ✅ Revenue grew 30.6% year-over-year
* ⚠️ Expenses grew 20.8% (slower than revenue - good)
* ✅ Profit grew 50% (excellent growth)
* ✅ Profit margin improved from 33.3% to 38.3%
***
## Revenue Analysis
### By Income Source
**Breakdown of revenue sources:**
```
Interest Income 2,000,000 RWF (85.11%) ← Primary revenue
Entry Fee Income 250,000 RWF (10.64%)
Penalty Income 100,000 RWF (4.26%)
-----------
Total 2,350,000 RWF (100.00%)
```
**Interpretation:**
* **Interest Income dominates** (85%) - typical for lending organizations
* **Diversified income** - not 100% dependent on one source
* **Penalties are modest** (4%) - members paying on time
**Risks:**
* ⚠️ 85% concentration in interest income (vulnerable if lending slows)
* ✅ Entry fees provide stable baseline revenue
**Opportunities:**
* ✅ Increase lending to grow interest income
* ✅ Add new fee-based services
* ✅ Consider new income streams (training, consulting)
***
### Revenue Trends
**Track revenue growth:**
```
Q1 2026 (Jan-Mar): 1,200,000 RWF
Q2 2026 (Apr-Jun): 1,150,000 RWF (-4.2% decline)
```
**Investigation needed**: Why did Q2 revenue decline?
* Fewer loans disbursed?
* Loan repayments slower?
* Members leaving?
***
## Expense Analysis
### By Category
**Breakdown of expenses:**
```
Operating Expense 1,200,000 RWF (82.76%) ← Largest category
Bank Charge Expense 150,000 RWF (10.34%)
Bad Debt Expense 100,000 RWF (6.90%)
-----------
Total 1,450,000 RWF (100.00%)
```
**Interpretation:**
* **Operating expenses dominate** (83%) - rent, salaries, utilities, supplies
* **Bank charges significant** (10%) - negotiate better rates?
* **Bad debt moderate** (7%) - 100,000 write-offs on 2M revenue = 5% of revenue
**Red flags:**
* ⚠️ Operating expenses over 50% of revenue (51% in this example)
* ⚠️ Bad debt over 5% of revenue
**Efficiency targets:**
* ✅ Operating expenses: 30-40% of revenue
* ✅ Bank charges: under 5% of revenue
* ✅ Bad debt: under 3% of revenue
***
### Expense Control
**Monthly expense tracking:**
| Month | Operating | Bank Charges | Bad Debt | Total |
| ----- | --------- | ------------ | -------- | ------- |
| Jan | 200,000 | 25,000 | 25,000 | 250,000 |
| Feb | 190,000 | 25,000 | 25,000 | 240,000 |
| Mar | 210,000 | 25,000 | 25,000 | 260,000 |
| Apr | 195,000 | 25,000 | 25,000 | 245,000 |
| May | 205,000 | 25,000 | 25,000 | 255,000 |
| Jun | 200,000 | 25,000 | -25,000 | 200,000 |
**Analysis:**
* ✅ Operating expenses relatively stable (190-210K range)
* ✅ Bank charges consistent (25K/month - consider negotiating)
* ⚠️ Bad debt lumpy (write-offs happen irregularly)
***
## Using the Profit & Loss Statement
### Monthly Board Reports
**Generate monthly P\&L:**
```http theme={null}
GET /reports/profit-loss?startDate=2026-06-01&endDate=2026-06-30
```
**Review with board:**
* Revenue vs budget
* Expense control
* Profit margins
* Trends vs prior months
***
### Quarterly Member Reports
**Generate quarterly P\&L:**
```http theme={null}
GET /reports/profit-loss?startDate=2026-04-01&endDate=2026-06-30
```
**Share with members:**
* Profitability summary
* Revenue sources
* Major expenses
* Dividend distribution potential
***
### Year-End Financial Statements
**Generate annual P\&L:**
```http theme={null}
GET /reports/profit-loss?startDate=2026-01-01&endDate=2026-12-31
```
**Use for:**
* Tax filing (if required)
* Annual report to members
* External audit
* Regulatory compliance
***
### Budget Planning
**Use prior year P\&L to plan next year's budget:**
```
Prior year actual:
Revenue: 4,500,000 RWF
Expenses: 2,800,000 RWF
Profit: 1,700,000 RWF
Next year budget (10% growth):
Revenue: 4,950,000 RWF (+10%)
Expenses: 3,000,000 RWF (+7% - controlled growth)
Profit: 1,950,000 RWF (+15%)
```
***
## Best Practices
**Profit & Loss best practices:**
**Timing:**
* ✅ Generate monthly P\&L for board review
* ✅ Generate quarterly P\&L for member updates
* ✅ Generate annual P\&L after year-end close
* ✅ Compare periods for trend analysis
**Accuracy:**
* ✅ Ensure all transactions posted before generating
* ✅ Verify no draft entries pending
* ✅ Reconcile to general ledger
* ✅ Cross-check totals with account balances
**Analysis:**
* ✅ Calculate key ratios (profit margin, expense ratio)
* ✅ Compare to prior periods
* ✅ Investigate significant variances
* ✅ Identify trends (improving or declining)
**Action:**
* ✅ Use insights to control expenses
* ✅ Identify revenue growth opportunities
* ✅ Make data-driven decisions
* ✅ Allocate profits (dividends, reserves, growth)
**Distribution:**
* ✅ Board members (monthly)
* ✅ Management (monthly)
* ✅ Members (quarterly or annually)
* ✅ Auditors (annually)
* ✅ Tax authorities (as required)
**Documentation:**
* ✅ Archive all P\&L reports
* ✅ Keep supporting schedules
* ✅ Document unusual items
* ✅ Maintain variance explanations
***
## Relationship to Balance Sheet
**P\&L and Balance Sheet are connected:**
### Net Income Transfer
**During open period:**
* P\&L shows Current Period Net Income
* Balance Sheet shows same amount in equity section
**After period close:**
* P\&L accounts (Income/Expense) reset to zero
* Net Income transferred to Retained Earnings on Balance Sheet
**Example:**
**Before period close:**
```
P&L (Jan-Jun 2026):
Net Profit: 900,000 RWF
Balance Sheet (Jun 30, 2026):
Current Period Net Income: 900,000 RWF (part of equity)
```
**After period close:**
```
P&L (Jan-Jun 2026):
[Closed - accounts zeroed]
Balance Sheet (Jun 30, 2026):
Retained Earnings: +900,000 RWF (increased by net profit)
Current Period Net Income: 0 RWF (transferred)
```
***
### Combined Analysis
**Use both reports together:**
| Metric | Source | Formula |
| -------------------- | -------------------- | ------------------------- |
| **Profit Margin** | P\&L only | Net Profit / Revenue |
| **Return on Assets** | P\&L + Balance Sheet | Net Profit / Total Assets |
| **Return on Equity** | P\&L + Balance Sheet | Net Profit / Total Equity |
| **Asset Turnover** | P\&L + Balance Sheet | Revenue / Total Assets |
***
## Related Topics
View financial position at a point in time
Distribute profits to members
Allocate profits to reserves
Accounting foundation for P\&L
Period closing and income transfer