Trial Balance-Report

The Trial Balance is a key financial tool used to verify that total debits and credits are balanced and to assess overall financial accuracy. To support different levels of analysis, the system provides four types of Trial Balance reports: Level Up To Date, Date Wise, Month Wise, and Sub-Ledger.

What is a Trial Balance (Level Up To Date) ?

The Trial Balance (Level Up To Date) ensures your accounts are mathematically balanced by comparing total debits and credits. It provides a high-level view of assets, liabilities, equity, revenue, and expenses.

How to Use:

Step 1: Select Level
Choose the report level (e.g., Level 1 for summary, higher levels for detailed view).

Step 2: Set Filters
Select currency and apply options like Without Zero or Without Opening if needed.

Step 3: Refresh & Expand
Click refresh to load data and expand accounts for detailed breakdown.

Step 4: Verify Balance
Check that total debits and credits match, then export if required.

What is a Trial Balance (Date Wise) ?

This report shows the movement of accounts over time by displaying Opening, Period Activity (Debit/Credit), and Closing balances. It helps track how balances change within a selected period.

How to Use:

Step 1: Set Date Range
Enter Date From and Date To to define the period.

Step 2: Select Level
Choose the level (e.g., Level 1 for summary, higher for details).

Step 3: Apply Filters
Use options like Without Zero, select currency, and filter by business unit if needed.

Step 4: Analyze Data
Click refresh and review:

What is a Trial Balance (Month Wise) ?

This report compares account movements across multiple months, helping you identify trends, variations, and monthly performance at a glance.

How to Use:

Step 1: Set Period
Select Month From and Month To to define the comparison range.

Step 2: Filter Data
Search by account code or filter by business unit/branch if needed.

Step 3: Refresh & Review
Click refresh to view monthly debit and credit columns.

Step 4: Analyze Trends
Compare months to spot changes and export the report if required.

What is a Sub-Ledger Trial Balance ?

This report provides a detailed breakdown of a single GL account by showing individual customers, vendors, or sub-accounts that make up the total balance.

How to Use:

1. Sub-Ledger Wise (Trial Balance)

• Select Subledger Type and Account Code
• Apply filter (e.g., Without Zero)
• Click Refresh
• View current balances for each subledger

2. Date to Date (Trial Balance)

• Select Date From and Date To
• Click Refresh
• View Opening, Debit, Credit, and Closing balances
• Analyze transaction activity within the period