Trial Balance Report
What is a Trial Balance?
A Trial Balance is a fundamental accounting report that lists all general ledger accounts and their balances at a specific point in time or for a specific period. It's called a "trial" balance because it's used to verify that the total of all debit balances equals the total of all credit balances, proving the fundamental accounting equation remains in balance.
The Fundamental Accounting Equation
Assets = Liabilities + Equity
Or in debit/credit terms:
Total Debits = Total Credits
A trial balance is the primary tool accountants use to verify this equation holds true after all transactions have been recorded.
Why is the Trial Balance Important?
1. Verification of Accounting Records
The trial balance ensures that for every debit entry, there's a corresponding credit entry. If debits don't equal credits, there's an error in the books that must be corrected.
2. Foundation for Financial Statements
The trial balance is the starting point for preparing:
- Balance Sheet (from asset, liability, and equity accounts)
- Income Statement (from revenue and expense accounts)
- Cash Flow Statement (derived from changes in balances)
3. Error Detection
While not all errors are caught by a trial balance, it will identify:
- Mathematical errors in posting
- Missing entries (if one side of a transaction wasn't recorded)
- Incorrect account classifications
4. Period-End Closing
At the end of each accounting period (month, quarter, year), the trial balance is the first step in the closing process before financial statements are prepared.
Key Concepts
Account Types and Normal Balances
Different account types have different "normal" balances:
| Account Type | Normal Balance | Increases With | Decreases With |
|---|---|---|---|
| Asset | Debit | Debit | Credit |
| Liability | Credit | Credit | Debit |
| Equity | Credit | Credit | Debit |
| Revenue | Credit | Credit | Debit |
| Expense | Debit | Debit | Credit |
Opening Balance
The opening balance is the cumulative balance in an account at the beginning of the reporting period.
Example:
- Period: January 1 - December 31, 2025
- Opening Balance: The balance on December 31, 2024 (or the sum of all transactions before January 1, 2025)
Closing Balance
The closing balance is the cumulative balance in an account at the end of the reporting period.
Formula:
Closing Balance = Opening Balance + Period Activity
For debit accounts (Assets, Expenses):
Closing Balance = Opening Balance + Period Debits - Period Credits
For credit accounts (Liabilities, Equity, Revenue):
Closing Balance = Opening Balance + Period Credits - Period Debits
Period Activity
Period activity represents all the debits and credits that occurred during the reporting period:
- Period Debits: Total debit entries during the period
- Period Credits: Total credit entries during the period
How to Read a Trial Balance
Standard Trial Balance Format
A typical trial balance shows:
Lyon Scent Company
Trial Balance
For the Period: January 1, 2025 - October 29, 2025
Account Number | Account Name | Opening Balance | Period Debit | Period Credit | Closing Balance
---------------|---------------------------|-----------------|--------------|---------------|----------------
1100 | Cash | 50,000 | 100,000 | 80,000 | 70,000
1200 | Accounts Receivable | 30,000 | 60,000 | 50,000 | 40,000
2100 | Accounts Payable | (20,000) | 15,000 | 25,000 | (30,000)
3100 | Owner's Equity | (50,000) | 0 | 0 | (50,000)
4100 | Sales Revenue | (100,000) | 5,000 | 120,000 | (215,000)
6100 | Cost of Goods Sold | 60,000 | 70,000 | 5,000 | 125,000
6200 | Operating Expenses | 25,000 | 30,000 | 2,000 | 53,000
---------------|---------------------------|-----------------|--------------|---------------|----------------
| TOTALS | 0 | 280,000 | 280,000 | 0
Note: Credit balances are often shown in parentheses or as negative numbers.
Key Things to Look For
-
Do Period Debits = Period Credits?
- If yes: Your books are in balance ✓
- If no: There's an error that must be investigated ✗
-
Is the Net Closing Balance Zero?
- Sum of all debit account closing balances should equal sum of all credit account closing balances
- Net result should be zero
-
Unusual Account Balances
- Asset accounts with credit balances (unusual - might indicate overpayment)
- Liability accounts with debit balances (might indicate overpayment to vendor)
- Large unexpected changes from opening to closing
Dimensional Trial Balance
What is a Dimensional Trial Balance?
A dimensional trial balance breaks down account balances by additional business dimensions beyond just the account number. This provides deeper insights into where money is coming from and going to.
Common Dimensions
Financial Dimensions are additional attributes that classify transactions:
| Dimension | Description | Example Values |
|---|---|---|
| Main Account | The GL account number | 1100 (Cash), 4100 (Sales Revenue) |
| Department | Business unit or division | SALES, MKTG, HR, IT, FINANCE |
| Cost Center | Cost tracking unit | CC_100, CC_200, CC_SALES_OPS |
| Project | Project identifier | PROJ_ALPHA, PROJ_BETA |
| Customer | Customer account | Specific customer IDs |
| Region | Geographic location | UAE_DXB, UAE_ABD, GCC_KSA |
Example: Departmental Trial Balance
Using dimension set "MA+DEPT" (Main Account + Department):
Lyon Scent Company
Dimensional Trial Balance - Main Account + Department
For the Period: January 1, 2025 - October 29, 2025
Account | Department | Opening Balance | Period Debit | Period Credit | Closing Balance
--------|------------|-----------------|--------------|---------------|----------------
1100 | SALES | 20,000 | 50,000 | 30,000 | 40,000
1100 | MKTG | 15,000 | 30,000 | 25,000 | 20,000
1100 | HR | 10,000 | 15,000 | 20,000 | 5,000
4100 | SALES | (80,000) | 3,000 | 100,000 | (177,000)
4100 | MKTG | (20,000) | 2,000 | 20,000 | (38,000)
6100 | SALES | 35,000 | 40,000 | 3,000 | 72,000
6100 | MKTG | 25,000 | 30,000 | 2,000 | 53,000
Benefits:
- See which departments are generating revenue vs. consuming resources
- Identify which departments have the most expenses
- Track departmental profitability
- Support budgeting and cost allocation decisions
Common Use Cases
1. Month-End Close
Scenario: At the end of each month, the accounting team needs to verify all transactions are properly recorded before preparing financial statements.
Process:
- Run trial balance for the month (e.g., October 1-31, 2025)
- Verify total debits = total credits
- Review unusual balances or unexpected changes
- Make adjusting entries if necessary
- Re-run trial balance to confirm balance
- Proceed with financial statement preparation
2. Departmental Performance Review
Scenario: Management wants to understand which departments are generating revenue and which are costing the company money.
Process:
- Run dimensional trial balance with "MA+DEPT" dimension set
- Filter for revenue accounts (4000-4999) and expense accounts (6000-6999)
- Group by department
- Calculate: Revenue - Expenses = Departmental Contribution
- Identify high-performing and underperforming departments
Example Result:
Department | Revenue | Expenses | Net Contribution
-----------|-----------|-----------|------------------
SALES | 177,000 | 72,000 | 105,000 (Profit)
MKTG | 38,000 | 53,000 | (15,000) (Loss)
HR | 0 | 30,000 | (30,000) (Cost Center)
3. Project Cost Tracking
Scenario: A construction company needs to track costs and revenue for multiple active projects.
Process:
- Run dimensional trial balance with "MA+PROJECT" dimension set
- Filter for specific project (e.g., PROJ_ALPHA)
- Review all expenses charged to the project
- Compare against project budget
- Calculate project profitability
4. Year-End Audit Preparation
Scenario: External auditors are coming to review the company's financial records.
Process:
- Run year-to-date trial balance (January 1 - December 31)
- Provide opening balances (last year's closing balances)
- Show all period activity
- Verify closing balances match the general ledger
- Provide detailed dimensional breakdowns for material accounts
- Document any adjusting entries made
5. Budget vs. Actual Analysis
Scenario: Management wants to compare actual spending against budget by department and cost center.
Process:
- Run dimensional trial balance with "MA+DEPT+CC" for actual figures
- Compare closing balances against budgeted amounts
- Calculate variances (Actual - Budget)
- Investigate significant unfavorable variances
- Adjust future budget forecasts based on trends
Dimension Sets Available
The system provides several pre-configured dimension sets for different reporting needs:
Default Dimension Sets
| Dimension Set Name | Dimensions | Best Used For |
|---|---|---|
| MainAccount | Main Account only | Standard trial balance, basic reporting |
| MA+DEPT | Main Account + Department | Departmental reporting, cost allocation |
| MA+DEPT+CC | Main Account + Department + Cost Center | Detailed cost center analysis |
| MA+PROJECT | Main Account + Project | Project-based accounting, construction |
| MA+DEPT+PROJECT | Main Account + Department + Project | Comprehensive project and department tracking |
| MA+REGION | Main Account + Region | Regional financial analysis, multi-location businesses |
| DEPT+CC | Department + Cost Center (no GL account) | Internal operational reporting |
How to Generate a Trial Balance
Basic Trial Balance (Account Level Only)
Input:
- Start Date: Beginning of the reporting period (e.g., January 1, 2025)
- End Date: End of the reporting period (e.g., October 29, 2025)
Output:
- List of all accounts with balances
- Opening balance, period debits/credits, closing balance
- Total debits and total credits
- Balance verification (Debits = Credits?)
When to Use:
- Monthly financial close
- Quick balance verification
- Preparing for financial statement generation
- When dimensional detail is not needed
Dimensional Trial Balance
Input:
- Start Date: Beginning of the reporting period
- End Date: End of the reporting period
- Dimension Set: Select from available dimension sets (e.g., MA+DEPT)
Output:
- Account balances broken down by selected dimensions
- Each unique combination of account + dimensions shown separately
- Same financial totals as basic trial balance, just more detailed
When to Use:
- Departmental performance analysis
- Project cost tracking
- Regional profitability analysis
- Detailed cost allocation
- Management reporting
- Budget variance analysis
Reading the Report Results
Understanding the Columns
Account Information:
- Account Number: The general ledger account code (e.g., 1100, 4100, 6100)
- Account Name: Descriptive name of the account (e.g., Cash, Sales Revenue)
- Account Type: Classification (Asset, Liability, Equity, Revenue, Expense)
Dimension Values:
- MainAccount: The account number dimension value
- Department: Department code (e.g., SALES, MKTG, HR)
- Cost Center: Cost center code (e.g., CC_100, CC_200)
- Additional dimensions depending on selected dimension set
Financial Figures:
- Opening Balance: Balance at the start of the period
- Period Debit: Total debits posted during the period
- Period Credit: Total credits posted during the period
- Closing Balance: Balance at the end of the period
Report Totals
At the bottom of the report:
- Total Debits: Sum of all period debits
- Total Credits: Sum of all period credits
- Total Opening Balance: Should be zero (debits - credits)
- Total Closing Balance: Should be zero (debits - credits)
- Is Balanced: Yes/No indicator
Common Questions
Why are some balances negative?
Negative balances (or values in parentheses) indicate credit balances:
- Normal: Liabilities, Equity, Revenue accounts
- Investigate: Assets or Expense accounts with credit balances (might indicate errors or unusual transactions like refunds)
What if debits don't equal credits?
This indicates an error in your accounting records. Common causes:
- Single-sided entry: Only one side of a journal entry was posted
- Mathematical error: Addition or subtraction error in posting
- Account misclassification: Using wrong account type
- System error: Technical issue during transaction recording
Action: Review recent transactions, identify the discrepancy, make correcting entries.
Why is my opening balance different from last period's closing balance?
This can happen due to:
- Adjusting entries: Entries made after the prior period closed
- Prior period adjustments: Corrections to prior periods
- Different date range: Not comparing same periods
- Account reclassification: Accounts were renamed or restructured
How often should I run a trial balance?
Recommended frequency:
- Monthly: At minimum, during monthly close process
- Weekly: For businesses with high transaction volumes
- Daily: For cash-intensive businesses or during busy periods
- As needed: Before preparing financial statements, before audits, when investigating discrepancies
Best Practices
1. Regular Reconciliation
Run trial balances regularly and investigate any imbalances immediately. Don't let errors accumulate.
2. Use Appropriate Dimension Sets
Choose dimension sets that match your reporting needs:
- Management reports: Use detailed dimension sets (MA+DEPT+CC)
- External reporting: Use simple dimension sets (MainAccount only)
- Specific analysis: Use targeted dimension sets (MA+PROJECT for project review)
3. Verify Opening Balances
Always verify that opening balances match the prior period's closing balances. Any discrepancies should be investigated and documented.
4. Document Adjustments
If you make adjusting entries after running a trial balance, document:
- Why the adjustment was necessary
- What accounts were affected
- The amount and nature of the adjustment
- Authorization for the adjustment
5. Archive Reports
Keep copies of trial balances for:
- Audit purposes: External and internal audits
- Historical comparison: Trend analysis over time
- Compliance: Regulatory requirements
- Dispute resolution: If questions arise about past balances
Integration with Other Reports
Trial Balance → Balance Sheet
The trial balance provides the data for the balance sheet:
- Assets (accounts 1000-1999): Debit balances → Asset section
- Liabilities (accounts 2000-2999): Credit balances → Liability section
- Equity (accounts 3000-3999): Credit balances → Equity section
Trial Balance → Income Statement
The trial balance provides the data for the income statement:
- Revenue (accounts 4000-4999): Credit balances → Revenue section
- Expenses (accounts 6000-6999): Debit balances → Expense section
- Net Income = Total Revenue - Total Expenses
Trial Balance → Cash Flow Statement
Changes in account balances from the trial balance help calculate cash flows:
- Increase in Assets: Use of cash (negative cash flow)
- Decrease in Assets: Source of cash (positive cash flow)
- Increase in Liabilities: Source of cash (positive cash flow)
- Decrease in Liabilities: Use of cash (negative cash flow)
Glossary
Debit: An entry on the left side of an account; increases assets and expenses, decreases liabilities, equity, and revenue.
Credit: An entry on the right side of an account; increases liabilities, equity, and revenue, decreases assets and expenses.
Normal Balance: The side (debit or credit) that increases an account type.
Chart of Accounts: The complete list of all accounts used by an organization.
Dimension: An additional attribute used to classify transactions beyond the account number (e.g., Department, Project, Region).
Dimension Set: A predefined combination of dimensions used for reporting purposes.
General Ledger: The complete record of all financial transactions for an organization.
Posting: The process of transferring journal entries to the general ledger.
Fiscal Period: A time period for which financial statements are prepared (month, quarter, year).
Support and Additional Resources
For more information:
- Technical Documentation: See
/docs/api/general-ledger/trial-balance.api.mdfor API details - Dimension Sets: See
/docs/api/general-ledger/dimension-sets.api.mdfor dimension set configuration - Financial Dimensions: See
/docs/concepts/financial-dimensions.mdfor dimension architecture
Document Version: 1.0 Last Updated: October 29, 2025