Skip to main content

Trial Balance

Validate Your Financial Integrity with PrismERP’s Automated Trial Balance Report

The Trial Balance in PrismERP is an essential financial report that displays the debit and credit balances of all general ledger accounts at a specific point in time. It is used to verify the accuracy of the company's accounting records by ensuring the sum of debits equals the sum of credits, maintaining the integrity of the double-entry bookkeeping system.

This report acts as a checkpoint before finalizing the Income Statement or Balance Sheet, helping finance teams detect errors and discrepancies in journal entries or ledger postings.


Key Features

  • Real-Time Account Balancing – Reflects updated balances from all integrated financial modules (GL, AR, AP, Inventory, etc.).
  • Account Categorization – Lists accounts under major groups: Assets, Liabilities, Equity, Income, and Expenses.
  • Multi-Period & Multi-Year Support – Generate comparative reports across fiscal periods or years.
  • Detailed & Summary Versions – Includes a standard Trial Balance and a detailed version with opening balances, movements, and closing balances.
  • Drill-Down Functionality – Navigate from summary to transaction-level detail.
  • Export Options – Available in PDF, Excel, and CSV formats for audit, review, and internal analysis.
  • Access Control – Role-based visibility ensures sensitive account data is restricted to authorized users only.

Step-by-Step Usage

1. Go to Print Panel:

From the main menu, select Print Accounting

2. Open Financial Statement Reports:

Click on Financial Statement, then select Trial Balance

3. Set Parameters:
  • Year/Period – Select the desired date range
  • Report Type – Choose between:
    • Summary: Basic Trial Balance
    • Detailed: Includes opening, transaction, and closing balances
  • Include Zero Balances – Optionally toggle to include/exclude accounts with zero balance
4. Generate Report:

Click on View or Generate Report to see the result

5. Export or Print:

Use Download to export in Excel, PDF, or CSV formats for sharing or filing