Trial Balance

The Trial Balance page provides a summarized report showing the financial balances of all ledger accounts at a particular point in time. This report helps users verify that the total debits equal the total credits, ensuring the accounts are balanced.

📋 Features

1. Trial Balance Table

The table contains detailed financial information for each account, organized into the following columns:

• Account: The name of the account (e.g., NET TAX PAYABLE, ACCOUNTS RECEIVABLE).
• Init Debit: The initial debit balance of the account.
• Init Credit: The initial credit balance of the account.
• Debit: The total debit amount recorded in the account during the period.
• Credit: The total credit amount recorded in the account during the period.
• Total Debit: The cumulative debit balance for the account (Init Debit + Debit).
• Total Credit: The cumulative credit balance for the account (Init Credit + Credit).

2. Summary Totals

At the bottom of the table, the system displays:

• Total Debit: The sum of all debit entries across accounts.
• Total Credit: The sum of all credit entries across accounts.
• This ensures the trial balance is accurate (i.e., Total Debit = Total Credit).

3. How to Export the Report

1. Export Data: Click Export to Excel to download the trial balance as an Excel file.
2. Open the File: Use Excel to analyze or share the report offline.

4. How to Use Filters

1. Apply Filters: Use the filter option to locate specific accounts or data quickly.
2. Clear Filters: Clear the filters to display the full trial balance.

❓ Frequently Asked Questions

Q: What should I do if the Total Debit doesn’t match the Total Credit?

A: This indicates errors in ledger postings. Review individual accounts to identify and correct discrepancies.

Q: Can I edit accounts directly from this page?

A: No, the Trial Balance Page is for viewing and exporting data only. Account details must be edited in the ledger.

Q: Why would I use the Export to Excel feature?

A: Exporting allows offline analysis, detailed reporting, and record-keeping for audits.

🛠️ Troubleshooting and Support

Problem: Exporting fails.

Solution: Ensure your browser settings allow downloads. Contact system support if the issue persists.

Problem: Filter returns no results.

Solution: Check the entered criteria and ensure it matches existing account data. Clear the filter and reapply if necessary.