Profit and Loss Statement — Complete User Guide — Two Accounts Web

Comprehensive guide for generating, analysing, and understanding the Profit and Loss Statement — measuring your business's financial performance over a period

Table of Contents

1. What Is the Profit and Loss Statement?
   • Income vs Expenses
   • Accrual Basis vs Cash Basis
   • The Profit and Loss Statement Hierarchy
2. Enabling from the Customize Menu
3. Field-by-Field Guide
   • Report Header Fields
   • Report Columns (Periods)
   • Report Footer
4. Settings Configuration
   • Profit and Loss Statement Groups
   • Profit and Loss Accounts
   • System Accounts
5. Creating a Profit and Loss Statement Report
6. How the Profit and Loss Statement Is Calculated
   • Transaction Loading and Pre-Processing
   • Balance Calculation Per Period
   • How the Chart of Accounts Tree Shapes the Report
   • Sign Convention
7. Drill-Down Capabilities
8. Sample Data and Report Output
   • Sample Setup
   • Income Statement Output
   • Verification of Calculation
9. Common Issues and Solutions
10. Accounting Regulation Compliance

1. What Is the Profit and Loss Statement?

The Profit and Loss Statement (also called the Income Statement) is a financial report that measures a business's financial performance over a specific period. It shows how much revenue was earned, what costs were incurred, and whether the business generated a profit or loss.

Unlike the Balance Sheet (which is a point-in-time snapshot), the P&L covers a range of dates — a month, quarter, or year.

1.1 Income vs Expenses

The fundamental equation:

Net Profit (or Loss) = Total Income − Total Expenses

1.2 Accrual Basis vs Cash Basis

1.3 The Profit and Loss Statement Hierarchy

The P&L report is organised using a hierarchical tree structure:

Income (Revenue)
  ├── Sales Revenue
  ├── Service Revenue
  ├── Late Payment Fees
  ├── Realised Investment Gains
  └── Unrealised Investment Gains
        └── [Subtotal: Total Income]

Expenses
  ├── Cost of Goods Sold
  ├── Salaries and Wages
  ├── Depreciation
  ├── Amortisation
  ├── Rent and Utilities
  ├── Bank Charges
  ├── Interest Expense
  ├── Currency Losses
  └── Loss on Disposal of Assets
        └── [Subtotal: Total Expenses]

                         ─────────────────
        [Total: Net Profit / (Loss)]

Each group can be expanded or collapsed. The final row is always the Net Profit or Loss, calculated as Total Income minus Total Expenses.

2. Enabling from the Customize Menu

The Profit and Loss Statement report is a standard report — it is always available under:

• Reports → Financial Statements → Profit & Loss Statement

Related variations are also always available:

• Reports → Financial Statements → Profit & Loss Statement (Actual vs Budget) — compares actual performance against budgeted figures

The Profit and Loss Account settings are also always accessible:

• Settings → Chart of Accounts → Profit and Loss — manage P&L groups and accounts

3. Field-by-Field Guide

3.1 Report Header Fields

Location: Reports → Financial Statements → Profit & Loss Statement → New Report

3.2 Report Columns (Periods)

Each report can contain one or more period columns for comparative analysis — for example, showing Q1 vs Q2 side by side.

3.3 Report Footer

The Footer field accepts multi-line text. Common uses include:

• Accounting policy notes (e.g. "Prepared under the accrual basis of accounting")
• Disclosure of significant estimates or judgments
• Date of authorisation
• Rounding conventions

4. Settings Configuration

4.1 Profit and Loss Statement Groups

Location: Settings → Chart of Accounts → Profit and Loss → New Group

P&L Groups organise accounts into meaningful categories on the Income Statement. There are three group types:

4.2 Profit and Loss Accounts

Location: Settings → Chart of Accounts → Profit and Loss → New Account

Custom P&L Accounts allow you to add new income or expense line items to the Profit and Loss Statement. For example, "Commission Income", "Consulting Fees", "Marketing Expense", or "Travel Expense".

4.3 System Accounts

The following P&L accounts are built into the system and appear automatically when relevant transactions exist:

5. Creating a Profit and Loss Statement Report

1. Go to Reports → Financial Statements → Profit & Loss Statement
2. Click New Report
3. Enter a Title (optional)
4. Enter a Description (optional)
5. Choose the Accounting Method — Accrual (default) or Cash Basis
6. Add one or more Periods:
   • Click Add to add a period column
   • Enter the From Date and To Date
   • Optionally select a Division for segmented reporting
   • Optionally enter a Column Name (e.g. "Q1 2026")
   • Add additional periods for comparative analysis
7. Optionally adjust Rounding, Exclude Zero Balances, Show Account Codes
8. Optionally select Groups to Collapse for compact presentation
9. Optionally enter a Footer note
10. Click Save
11. The report will generate with Income, Expenses, and Net Profit sections

6. How the Profit and Loss Statement Is Calculated

This section explains the calculation logic behind the P&L Statement. Understanding these concepts helps you interpret the numbers and troubleshoot unexpected results.

6.1 Transaction Loading and Pre-Processing

When the P&L is generated, the system first loads all General Ledger transactions and applies several pre-processing steps:

1. Cost of Goods Sold Calculation — determines COGS based on inventory valuation method (FIFO, moving average, or periodic average). This creates the COGS expense entry that appears on the P&L.
2. Fixed Asset Disposal Entries — when a fixed asset is disposed, its cost and accumulated depreciation are removed from the balance sheet, and any gain or loss is recorded in the P&L.
3. Intangible Asset Disposal Entries — same treatment as fixed assets for disposed intangible assets.
4. Realised Investment Gains/Losses — calculates gains or losses on disposal of investments using the average cost method.

If Cash Basis is selected, additional conversion steps are applied:

• Sales invoices are matched to receipts and converted to cash basis — revenue is recognised when cash is received, not when the invoice was created
• Purchase invoices are matched to payments and converted to cash basis — expenses are recognised when cash is paid, not when the invoice was created

6.2 Balance Calculation Per Period

For each period column in the report, the following calculation is performed:

Step 1 — Revalue foreign currency accounts for the period date range
Step 2 — Filter transactions to only P&L (Profit and Loss) accounts
Step 3 — Filter transactions within the period (FromDate to ToDate)
Step 4 — Optionally filter by Division (if selected)
Step 5 — Group by P&L account
Step 6 — Sum the base currency amount for each account
Step 7 — Negate the result (see Sign Convention below)

Formula for each account balance:

Account Amount = −(Sum of base currency amount for all transactions
    where the account is this P&L account
    and the transaction date is within the period
    and the transaction is after foreign currency revaluation)

6.3 How the Chart of Accounts Tree Shapes the Report

The P&L report does NOT use hard-coded formulas like "Revenue − COGS − Expenses = Profit." Instead, it dynamically builds the report from the Chart of Accounts tree structure:

1. Income Groups — all income accounts (sales revenue, service fees, late payment fees, investment gains) are grouped under Income Groups. Their balances are displayed as positive numbers.
2. Expense Groups — all expense accounts (COGS, salaries, depreciation, rent, bank charges) are grouped under Expense Groups. Their balances are displayed with a "Less:" prefix, indicating they subtract from income.
3. Subtotal rows — automatically calculated at key points: "Total Income," "Total Expenses," and "Net Profit/(Loss)."
4. Net Profit — the final row is always the Net Profit or Loss, calculated as the running total of all preceding rows.

If an account has no group assigned, it falls into an "Uncategorised" bucket under Income. This ensures no account is ever lost, but it is best practice to assign each account to the correct group.

6.4 Sign Convention

The sign convention requires careful handling:

In the General Ledger:
  Income accounts have a CREDIT (negative) balance
  Expense accounts have a DEBIT (positive) balance

On the P&L Statement:
  Income amounts are DISPLAYED as positive (profit-addings)
  Expense amounts are DISPLAYED as positive (cost-incurred)
  BUT they are SUBTRACTED in the total (via "Less:" groups)

The system handles this by:
  1. Negating all account balances (× −1) during calculation
  2. Income groups display the result as-is (positive)
  3. Expense groups use "Less:" prefix and the rendering engine
     re-negates them so they subtract from total income

Example:

Raw GL balances:
  Sales Revenue:         −300,000 (credit)
  Salary Expense:         +60,000 (debit)
  Depreciation Expense:   +5,000 (debit)
  Rent Expense:          +15,000 (debit)

After sign reversal (× −1):
  Sales Revenue:         +300,000 (displayed as income)
  Salary Expense:         −60,000
  Depreciation Expense:   −5,000
  Rent Expense:          −15,000

After "Less:" re-negation:
  Sales Revenue:         +300,000
  Less: Salary Expense:  −60,000
  Less: Depreciation:    −5,000
  Less: Rent:           −15,000
  Net Profit:           +220,000 ✓

7. Drill-Down Capabilities

Every amount shown on the Profit and Loss Statement is clickable. Clicking any account balance opens a detailed transaction viewer showing the individual General Ledger transactions that make up that amount.

Each drill-down view displays:

• Date — the transaction date
• Transaction — the document type and reference (e.g. "Sales Invoice #1001")
• Counterparty — customer, supplier, or employee name
• Description — transaction narrative
• Debit — debit amount
• Credit — credit amount
• Running Balance — cumulative balance after each transaction

8. Sample Data and Report Output

8.1 Sample Setup

To demonstrate the P&L calculation, we use the same trading business from the Balance Sheet guide with the following transactions during January 2026:

Note: The purchase of inventory (120,000) does NOT appear as an expense on the P&L — it is recorded as an asset (Inventory on Hand). The expense (COGS) is recognised when the inventory is sold, which has not happened yet in this example.

P&L Account Balances for January 2026

8.2 Income Statement Output

Profit and Loss Statement — ABC Trading
For the period: 1-Jan-2026 to 31-Jan-2026
                                                    Amount (BDT)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
INCOME

  Sales Revenue                                           300,000
                                                            ───────
Total Income                                              300,000

EXPENSES

  Less: Salary Expense                    60,000
  Less: Depreciation Expense               5,000
  Less: Rent Expense                      15,000
                                            80,000
                                           ───────
Total Expenses                                              80,000
                                                            ───────

NET PROFIT                                                 220,000
                                                            ═══════

8.3 Verification of Calculation

INCOME:
  Sales Revenue:                300,000 ✓

EXPENSES:
  Salary Expense:                60,000 ✓
  Depreciation Expense:           5,000 ✓
  Rent Expense:                  15,000 ✓
  Total Expenses:                80,000 ✓

NET PROFIT:
  300,000 − 80,000 = 220,000 ✓

RAW GL BALANCES (before sign reversal):
  Sales Revenue:                −300,000 (Cr)
  Salary Expense:                +60,000 (Dr)
  Depreciation Expense:           +5,000 (Dr)
  Rent Expense:                  +15,000 (Dr)

  Sum = −300,000 + 60,000 + 5,000 + 15,000 = −220,000

SIGN REVERSAL (× −1):
  −220,000 × −1 = +220,000 ✓

DOUBLE-ENTRY VERIFICATION:
  Every P&L entry has a corresponding BS entry:
    Sales Revenue: Cr 300,000 ↔ Dr Accounts Receivable 300,000 ✓
    Salary Expense: Dr 60,000 ↔ Cr Cash at Bank 60,000 ✓
    Depreciation:   Dr 5,000  ↔ Cr Accum. Depreciation 5,000 ✓
    Rent Expense:   Dr 15,000 ↔ Cr Cash at Bank 15,000 ✓

NET PROFIT FLOWS TO BALANCE SHEET:
  Retained Earnings Opening:     80,000
  Net Profit for January:       220,000
  Retained Earnings Closing:    300,000 ✓

  Balance Sheet check:
    Total Equity = Capital 500,000 + Retained Earnings 300,000 = 800,000 ✓

The key verification is that the net profit of 220,000 on the P&L matches the increase in Retained Earnings on the Balance Sheet from 80,000 to 300,000 (an increase of 220,000). This confirms that the P&L and Balance Sheet are properly linked.

9. Common Issues and Solutions

9.1 Net Profit Shows as Zero

Cause: No P&L transactions occurred in the selected period, or no P&L accounts have been created.

Solution: Verify that transactions affecting P&L accounts (sales invoices, expense payments, journal entries to expense accounts) exist within the date range. Check that P&L accounts are set up in Settings → Chart of Accounts → Profit and Loss.

9.2 Expected Accounts Do Not Appear

Cause: The account may be assigned to a group that is collapsed, or the account has a zero balance and "Exclude Zero Balances" is enabled.

Solution: Check if "Exclude Zero Balances" is enabled. Disable it to see all accounts. Check if the account's group is collapsed in "Groups to Collapse" — expand it to see individual accounts.

9.3 Account Appears in the Wrong Section

Cause: The account's Group assignment is incorrect. An income account assigned to an Expense group will appear under Expenses.

Solution: Go to Settings → Chart of Accounts → Profit and Loss. Find the account and change its Group to the correct Income or Expense group.

9.4 Amounts Look Incorrect or Reversed

Cause: The sign convention may appear counter-intuitive. Revenue should show as positive, expenses as positive (with "Less:" prefix). If an expense shows as negative, or income shows as negative, there may be a reversing journal entry or credit note affecting the account.

Solution: Drill into the account to see individual transactions. Check for credit notes (which reduce revenue) or reversing journal entries (which may temporarily flip the balance).

9.5 Cost of Goods Sold Is Missing

Cause: COGS is calculated automatically from inventory layers. If no inventory items have been sold (no sales invoices with inventory items), there is no COGS to recognise.

Solution: Verify that sales invoices were created using inventory items. Review the Inventory module to check item quantities and sales.

9.6 Profit Shown but Bank Balance Decreased

Cause: This is normal — it is the difference between accrual and cash accounting. Sales made on credit increase profit (revenue recognised) but do not increase cash until the customer pays. Similarly, asset purchases decrease cash but are capitalised on the Balance Sheet, not expensed on the P&L.

Solution: Review the Cash Flow Statement to understand the difference between profit and cash flow. A profitable business can have negative cash flow if it is investing in working capital or fixed assets.

10. Accounting Regulation Compliance

10.1 IAS 1 — Presentation of Financial Statements

10.2 IFRS 15 — Revenue from Contracts with Customers

10.3 IAS 2 — Inventories

10.4 IAS 16 — Property, Plant and Equipment

10.5 IAS 38 — Intangible Assets

10.6 IFRS 9 — Financial Instruments

10.7 IAS 21 — Foreign Exchange

10.8 IAS 37 — Provisions, Contingent Liabilities and Contingent Assets

10.9 IAS 8 — Accounting Policies and Estimates

10.10 DR = CR Verification

Sample Data Verification:
  Sales Revenue (Cr):          300,000
  ↔ Accounts Receivable (Dr):  300,000 ✓

  Salary Expense (Dr):          60,000
  ↔ Cash at Bank (Cr):          60,000 ✓

  Depreciation Expense (Dr):     5,000
  ↔ Accum. Depreciation (Cr):    5,000 ✓

  Rent Expense (Dr):            15,000
  ↔ Cash at Bank (Cr):          15,000 ✓

  Total Debits:  300,000 + 60,000 + 5,000 + 15,000 = 380,000
  Total Credits: 300,000 + 60,000 + 5,000 + 15,000 = 380,000
  DR = CR ✓

  P&L Links to Balance Sheet:
  Net Profit: 220,000
  Retained Earnings Increase: 300,000 − 80,000 = 220,000 ✓
  Assets = Liabilities + Equity: 1,080,000 = 280,000 + 800,000 ✓

End of Profit and Loss Statement Guide