Unadjusted Trial Balance

What is Unadjusted Trial Balance?

The Unadjusted Trial Balance report in XoroERP serves as a critical tool for evaluating the financial standing of a business at the close of an accounting period, just before any adjustments are implemented. This report acts as a snapshot that captures the balances of all business accounts within the general ledger, offering stakeholders a clear insight into the company's financial health before any modifications or corrections are made.

To access the Unadjusted Trial Balance, go to Menu > Reports > Accounting > Unadjusted Trial Balance

Selecting Reporting Template

When you opt for the Adjusted Trial Balance, the system will prompt you to select a document template. Navigate to the "Select Document Template" dropdown menu and choose the desired report template to access the report.

Key Features:

1. Error Identification: One significant aspect of the Unadjusted Trial Balance report is its ability to flag potential errors or discrepancies in the accounting records. By comparing the balances in this report to expected values or industry standards, users can swiftly pinpoint any irregularities that may necessitate further investigation or adjustment.

2. Baseline for Assessment: Unlike the Adjusted Trial Balance, which reflects balances post adjusting entries, the Unadjusted Trial Balance provides a foundational basis for financial assessment. It offers a starting point for analyzing financial performance, identifying trends, and making strategic decisions based on accurate financial data.

3. Interactive Functionality: A notable feature of the Unadjusted Trial Balance report is its interactive nature. Users can click on the amounts listed under the "Debit" or "Credit" sections to delve into detailed transaction information for each bank account. This feature enables a granular breakdown of transactions and balances specific to each account, empowering users to track transactions accurately and identify potential errors or discrepancies with ease.

In summary, the Unadjusted Trial Balance report in XoroERP enhances transparency, aids in error identification, and facilitates informed decision-making by providing users with a comprehensive view of financial data and robust tools to analyze transaction details effectively.

Detailed Features and Interactive Elements

The Unadjusted Trial Balance report provides a detailed breakdown of debit and credit amounts for all accounts within the general ledger, presenting this information prior to any adjustments being made

Field	Description
Account Type	This field displays the type of account of the respective accounts, such as Bank, Undeposited Funds, AccountsReceivable, AccountsPayable, etc.
Accounts	This field shows the name of the account.
Debit	This column shows the total debit balance for the respective account. Debits increase asset or expense accounts and decrease liability, equity, or revenue accounts.
Credit	This column displays the total credit balance for the respective account. Credits increase liability, equity, or revenue accounts and decrease asset or expense accounts.

Interactive Elements

By utilizing the drill-down feature in XoroERP's Unadjusted Trial Balance Report, users can access detailed information about specific accounts. When you click on the amount field of any Account Type in the report, it leads you to the Unadjusted Trial Balance-Account Details within the same window. In this section, you can delve into the specifics of the unadjusted trial balance for the chosen record. The information available includes transaction number (Txn Number), type, date, account name, entity name, reference number (Ref Number), store, amount, and ending balance. Further interaction is possible by clicking on any of these values, which then opens up the Journal Detail of the selected record, providing a more granular view of the transactions associated with that account. This drill-down functionality enhances the user's ability to explore and analyze financial data efficiently within the XoroERP system.

Unadjusted Trial Balance Account Details

Field	Description
Txn Number	This field lists the unique identifier assigned to each transaction.
Type	This field specifies the type of transaction (Invoice Payment, Journal Entry, Bank Deposit, etc.).
Date	This field captures the date of the transaction.
Account Name	This field displays the name of the account as recorded in the system.
Entity Name	This field specifies the name of the entity (customer or vendor) for which the transaction was recorded.
Ref Number	This field displays the reference number associated with the transaction. This could include invoice numbers, check numbers, receipt numbers, or any other reference number used to track the transaction.
Store	This field displays the store associated with the transaction.
Amount	This field shows the amount of the transaction.
Ending Balance	This field shows the final balance of the account after the transaction has been recorded. For each transaction, the ending balance is calculated by adding or subtracting the transaction amount from the previous balance.

Filtering the Unadjusted Trial Balance-Account Details report

The Unadjusted Trial Balance-Account Details report offers a vital feature that allows users to filter transactions within a specific period.

To filter the data, enter a desired date range in the "From" and "To" fields on the right side of the screen. After entering the desired date range, click on "Preview" to display only the transactions that fall within the selected date range.

This functionality is particularly useful for financial analysis over specified periods, enabling users to focus on the data that is most relevant to their needs.