Trial Balance — Complete User Guide — Two Accounts Web

Comprehensive guide for generating, analysing, and understanding the Trial Balance — verifying that total debits equal total credits across all accounts

Table of Contents

1. What Is the Trial Balance?
   • Structure
2. Enabling from the Customize Menu
3. Field-by-Field Guide
   • Report Header Fields
   • Report Columns (Periods)
4. Settings Configuration
   • Chart of Accounts
   • Suspense Account
5. Creating a Trial Balance Report
6. How the Trial Balance Is Calculated
   • P&L vs BS Accounts
   • Debit and Credit Columns
   • Net Profit/Loss Row
   • Suspense Account Handling
   • Interdivisional Balancing
7. Drill-Down Capabilities
8. Sample Data and Report Output
   • Sample Setup
   • Trial Balance Output
   • Verification of Calculation
9. Common Issues and Solutions
10. Accounting Regulation Compliance

1. What Is the Trial Balance?

The Trial Balance is a fundamental accounting report that lists every account in the Chart of Accounts alongside its total debit and credit balances. Its primary purpose is to verify that the fundamental accounting equation is satisfied: Total Debits = Total Credits.

Unlike the General Ledger Summary (which shows opening balance, period movement, and closing balance), the Trial Balance is a point-in-time snapshot showing the net balance of each account. For Balance Sheet accounts, it shows the cumulative balance from the beginning of time. For Profit and Loss accounts, it shows the period activity only.

Structure

The Trial Balance serves several critical purposes:

• Verification — confirms that every debit has a corresponding credit (Double-entry bookkeeping check)
• Foundation — provides the underlying data for the Balance Sheet and Profit and Loss Statement
• Audit — identifies accounts with unexpected balances that may indicate errors
• Suspense detection — a non-zero Suspense account highlights transactions that could not be properly allocated

The report structure:

PROFIT AND LOSS SECTION (period activity only)
  Account Name             Debit      Credit      Debit      Credit
  Sales Revenue                        300,000                300,000
  Salary Expense            60,000                 60,000
  Net Profit/Loss                                               218,000 (in Debit column)
                                                          or    60,000 (in Debit column for loss)

BALANCE SHEET SECTION (cumulative balances)
  Cash at Bank             93,000                 93,000
  Accounts Payable                    190,000                190,000
  Total Debits = Total Credits ✓

2. Enabling from the Customize Menu

The Trial Balance report is a standard report — it is always available under:

• Reports → General Ledger → Trial Balance

No toggle in Customize Menu is needed to enable it.

3. Field-by-Field Guide

3.1 Report Header Fields

Location: Reports → General Ledger → Trial Balance → New Report

3.2 Report Columns (Periods)

Each report can contain one or more period columns for comparative analysis. Unlike the Balance Sheet and P&L reports which have one column per period, the Trial Balance has two sub-columns per period: Debit and Credit.

4. Settings Configuration

4.1 Chart of Accounts

Location: Settings → Chart of Accounts

The Trial Balance uses the same Chart of Accounts structure as the Balance Sheet and Profit and Loss Statement. Accounts are organised into two hierarchies:

• Profit and Loss Statement accounts — income and expense accounts (appear first in the report)
• Balance Sheet accounts — assets, liabilities, and equity accounts (appear second)

Each account belongs to one hierarchy based on its type. Custom accounts created under Settings → Chart of Accounts → Profit and Loss appear in the P&L section. Custom accounts under Settings → Chart of Accounts → Balance Sheet appear in the BS section.

4.2 Suspense Account

Location: The Suspense account is a built-in system account that appears under the Uncategorised group.

The Suspense account holds transactions that could not be properly assigned to a valid account. In the Trial Balance:

• If the Suspense account balance is zero, the row is automatically hidden
• If the Suspense account balance is non-zero, the row appears and must be investigated
• A non-zero Suspense balance means Total Debits ≠ Total Credits — the Trial Balance is out of balance

5. Creating a Trial Balance Report

1. Go to Reports → General Ledger → Trial Balance
2. Click New Report
3. Enter a Title (optional)
4. Enter a Description (optional)
5. Choose the Accounting Method — Accrual or Cash Basis
6. Optionally check Account Codes and Exclude Zero Balances
7. Add Periods:
   • Click Add to add a period (produces Debit + Credit sub-columns)
   • Enter the From Date and To Date
   • Optionally select a Division
   • Optionally enter a custom Column Name
   • Add additional periods for comparative analysis
8. Click Save
9. The report generates with P&L section, Net Profit/Loss row, and BS section

6. How the Trial Balance Is Calculated

6.1 P&L vs BS Accounts

The Trial Balance treats Profit and Loss accounts and Balance Sheet accounts differently:

6.2 Debit and Credit Columns

For each account, the net balance is computed and then placed into either the Debit or Credit column based on its sign:

For each account:
    Net Balance = Sum of (base currency amount) for all qualifying transactions

    If Net Balance > 0 (positive — net debit):
        → Placed in the DEBIT column
        → Credit column shows blank

    If Net Balance < 0 (negative — net credit):
        → Placed in the CREDIT column after multiplying by −1 (shown as positive)
        → Debit column shows blank

    If Net Balance == 0:
        → Both columns show blank

Qualifying transactions:
    For P&L accounts: Date >= FromDate AND Date <= ToDate
    For BS accounts:   Date <= ToDate (cumulative)

Examples:

6.3 Net Profit/Loss Row

Between the P&L section and the BS section, a Net Profit/Loss row is added:

Net Profit/(Loss) = Sum of all P&L account balances × (−1)

    If the result is POSITIVE (profit):
        → Placed in the CREDIT column (profit increases equity — a credit)
        → Debit column shows blank

    If the result is NEGATIVE (loss):
        → Placed in the DEBIT column after multiplying by −1 (shown as positive)
        → Credit column shows blank

This row ensures the P&L section's net result flows through to the Balance Sheet section, where the Retained Earnings account (which includes accumulated profits) balances the equation.

6.4 Suspense Account Handling

The Suspense account is treated specially:

• If the Suspense balance is zero, the row is completely suppressed (returns null — not even shown with zero values)
• If the Suspense balance is non-zero, it appears like any other account
• A non-zero Suspense indicates that total debits do not equal total credits when the GL was constructed — this should be investigated immediately

6.5 Interdivisional Balancing

When filtering by Division, the system checks if the sum of all balance sheet accounts for that division equals zero. If not, it adds a balancing figure to the Interdivisional Loan account (same mechanism as the Consolidated Balance Sheet).

7. Drill-Down Capabilities

Each amount in the Debit and Credit columns is clickable. Clicking opens a detailed General Ledger account view showing the individual transactions behind that balance.

The drill-down view shows:

• Date — the transaction date
• Transaction — the document type and reference
• Account — the GL account name (useful when viewing sub-account breakdowns)
• Customer/Supplier/Employee — counterparty information
• Description — transaction narrative
• Debit — individual debit amounts
• Credit — individual credit amounts
• Balance — running balance after each transaction

8. Sample Data and Report Output

8.1 Sample Setup

A trading company with the following transactions during January 2026:

Opening Balances (1 January 2026)

Each opening balance entry creates a contra entry to Retained Earnings, ensuring the Trial Balance balances from day one.

Transactions During January 2026

8.2 Trial Balance Output

Trial Balance — ABC Trading
For the period: 1-Jan-2026 to 31-Jan-2026
                                        31-Jan-2026
                                      Debit      Credit
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
PROFIT AND LOSS

INCOME
  Sales Revenue                                300,000

EXPENSES
  Salary Expense                   60,000
  Rent Expense                     15,000
  Depreciation Expense              5,000
  Bank Charges Expense               2,000
                                   82,000

Net profit/loss                               218,000

BALANCE SHEET

ASSETS
  Cash at Bank                      93,000           
  Accounts Receivable              350,000           
  Inventory                        120,000             

LIABILITIES
  Accounts Payable                           190,000  

EQUITY
  Capital Account                              500,000 
  Retained Earnings                132,000             
                                    995,000    995,000 

8.3 Verification of Calculation

P&L ACCOUNTS (period activity: 1-Jan to 31-Jan):

  Sales Revenue (Cr −300,000) → Credit column: 300,000 ✓
  Salary Expense (Dr +60,000) → Debit column: 60,000 ✓
  Rent Expense (Dr +15,000)   → Debit column: 15,000 ✓
  Depreciation Exp (Dr +5,000) → Debit column: 5,000 ✓
  Bank Charges Exp (Dr +2,000) → Debit column: 2,000 ✓

  Net Profit: (−300,000 + 60,000 + 15,000 + 5,000 + 2,000) × −1 = 218,000 ✓
    (Shown in Debit column per TB convention — profit makes P&L section balance)

BS ACCOUNTS (cumulative balances up to 31-Jan):

  Cash at Bank:        Opening 100,000 + 150,000 − 80,000 − 60,000 − 15,000 − 2,000
                     = 93,000 Dr → Debit column: 93,000 ✓

  Accounts Receivable: Opening 200,000 + 300,000 − 150,000
                     = 350,000 Dr → Debit column: 350,000 ✓

  Inventory:           Opening 0 + 120,000
                     = 120,000 Dr → Debit column: 120,000 ✓

  Accumulated Depreciation: Opening 0 + (−5,000) = −5,000 Cr → Credit column: 5,000 ✓

  Accounts Payable:   Opening 150,000 + 120,000 − 80,000
                     = 190,000 Cr → Credit column: 190,000 ✓

  Capital Account:    Opening 500,000 + no activity
                     = 500,000 Cr → Credit column: 500,000 ✓

  Retained Earnings:  See trace below → Debit column: 132,000 ✓
                     (RE cumulative net = −80,000 OB + −100,000 Cash contra + −200,000 AR contra
                      + 150,000 AP contra + 500,000 Capital contra + 80,000 self-contra
                      + −300,000 revenue + 60,000 salary + 15,000 rent + 5,000 depn + 2,000 bank
                      = +132,000 Dr)

9. Common Issues and Solutions

9.1 Trial Balance Shows Unequal Debits and Credits

Cause: The Trial Balance combines P&L accounts (period-only activity) and BS accounts (cumulative balances) in the same columns. If all transactions are properly recorded and the Suspense account is zero, the column totals should balance.

Solution: Check the Suspense account. If Suspense is zero, the general ledger is in balance. The Trial Balance's unequal totals are expected when P&L period activity and BS cumulative balances are mixed. To verify DR = CR, compare the Total Debits and Total Credits within each section separately, or use the General Ledger Summary report.

9.2 Suspense Account Shows a Balance

Cause: Transactions that could not be assigned to a valid account have fallen into Suspense. This typically happens when a required field (Employee, Customer, Supplier) is missing on a transaction.

Solution: Drill into the Suspense account to see the underlying transactions. Edit each transaction and fill in the missing field. The Suspense row is automatically hidden when its balance is zero.

9.3 Retained Earnings Balance Is Unexpected

Cause: Retained Earnings accumulates opening balances (via contra entries from all BS opening balance entries) plus all period profit/loss. The balance shown is the cumulative total from the beginning of the business.

Solution: Drill into Retained Earnings to see the breakdown: opening balance entries (contra from other accounts), prior period retained earnings, and the current period's net profit.

9.4 Account Shows Balance in the Wrong Column

Cause: The Trial Balance places positive balances in the Debit column and negative balances in the Credit column. An asset account (normally debit) may show in the Credit column if its cumulative balance is negative (credit) — this can happen if payments exceed receipts for a Cash account, or if a liability account has been overpaid.

Solution: Drill into the account to see the individual transactions. A normally debit account showing a credit balance indicates an abnormal situation that should be investigated.

9.5 P&L Section Shows Empty

Cause: The Trial Balance's P&L section only shows transactions between FromDate and ToDate. If no P&L transactions occurred in that period, the section may be empty.

Solution: Broaden the date range. Verify that transactions exist in the period. The BS section will show data even if the P&L section is empty because BS balances are cumulative.

9.6 Comparative Periods Show Different Structures

Cause: Each period column in the Trial Balance may show different account balances because BS accounts accumulate over time while P&L accounts reset each period.

Solution: This is expected. A BS account like Cash at Bank will show a larger cumulative balance in later periods (as more transactions accumulate). A P&L account like Salary Expense will show the expense for each specific period only.

10. Accounting Regulation Compliance

10.1 Double-Entry Bookkeeping

10.2 IAS 1 — Presentation of Financial Statements

10.3 IAS 8 — Accounting Policies, Changes in Accounting Estimates and Errors

10.4 DR = CR Verification

EACH ACCOUNT BALANCE VERIFIED:
  Cash at Bank:        93,000 Dr ✓
  Accounts Receivable: 350,000 Dr ✓
  Inventory:          120,000 Dr ✓
  Accum. Depreciation:  5,000 Cr ✓
  Accounts Payable:   190,000 Cr ✓
  Capital Account:    500,000 Cr ✓
  Retained Earnings:  132,000 Dr ✓
  Sales Revenue:      300,000 Cr (period) ✓
  Salary Expense:      60,000 Dr (period) ✓
  Rent Expense:        15,000 Dr (period) ✓
  Depreciation Exp:     5,000 Dr (period) ✓
  Bank Charges Exp:     2,000 Dr (period) ✓

  Net Profit/Loss:    218,000 Dr (balancing P&L section) ✓

  P&L SECTION BALANCES:  82,000 + 218,000 = 300,000 ✓
  BS SECTION BALANCES:  563,000 + 132,000 = 190,000 + 500,000 + 5,000 = 695,000 ✓
  COMBINED TB TOTALS:   995,000 Dr = 995,000 Cr ✓
  Suspense account: 0 (hidden) ✓
  General Ledger is in balance ✓

End of Trial Balance Guide