Skip to main content
See the balances, debits and credits of your general ledger accounts at a glance.

​
Business Value

  • See everything: Check balances and movements across the whole chart of accounts.
  • Ready for audit: Opening and closing balances support reconciliation and closing.
  • Find problems fast: Spot odd balances, missing postings or entries in the wrong account.
  • Better decisions: Give finance teams daily or period-end figures.

​
Use Cases

  • Confirm that debits equal credits for the period.
  • Find accounts with odd or unexpected balances and check them.
  • Reconcile with other reports, such as detailed journal vouchers or subledger reports.
  • Prepare for audit with opening and closing balances and all movements.

​
Main Groupings:

  • Account Number / Account Type

​
Report Columns Explanation

  1. Account number: The account’s code in the chart of accounts.
  2. Description: The account’s name.
  3. Opening debit / Opening credit: The debit and credit balances at the start of the period.
  4. Debit: Total debits in the period.
  5. Credit: Total credits in the period.
  6. Closing debit / Closing credit: The debit and credit balances at the end of the period.
  7. Closing: The net closing balance. Positive values are debit balances. Negative values are credit balances.

​
Formula

Closing = (Opening debit + Debit) - (Opening credit + Credit)
  • If positive, it shows in Closing debit.
  • If negative, it shows in Closing credit.
  • The “Closing” column always shows the net value: debit positive, credit negative.

​
Real Examples

​
Example 1: City Ledger Shops (Debit Closing Balance)

Calculation: (406,528.08 + 745,580.01) - (0 + 349,995.85) = 1,152,108.09 - 349,995.85 = 802,112.24 → Shows in “Closing debit”

​
Example 2: City Ledger Individual (Credit Closing Balance)

Calculation: (0 + 16,418,223.85) - (127,090.76 + 16,403,370.52) = 16,418,223.85 - 16,530,461.28 = -112,237.43 → Shows in “Closing credit”, and as a negative in “Closing”.

​
Summary

  • Each line sums up one account’s activity for the period.
  • Opening balance plus movements on one side, minus the other side, gives the closing balance.
  • The sign and the column show at once whether the account is in debit or credit.

​
Update: 15 Apr 2026

​
Run the GL trial balance for any date range, now grouped by account type, account group, or both.

The Group by parameter now has four options instead of two. These are the options:
  • None — all accounts in one list, with one grand total.
  • Account Type — rows grouped by account type (Asset, Liability, Revenue, Expense), with a sub-total for each.
  • Account Group (NEW) — rows grouped by the account group from your chart of accounts. Each has a sub-total.
  • Account Type and Account Group (NEW) — rows grouped by account type, then by account group inside each type. Each level has sub-totals.
With Account Group, each section header shows the account group description. The rows under it have a sub-total. The grand total is always at the bottom. Report Columns Each row is one GL account. The example values come from a sample report. With a Group By option, each group has its own sub-total row before the next group. A grand total row ends the report.