Adjusted Trial Balance Fields
The Adjustment Trial Balance report displays the debit and credit amounts, including the adjustments, of all the accounts in the general ledger.
Adjusted Trial Balance Fields
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.
Adjusted Trial Balance-Account Details
The Adjusted Trial Balance report allows you to further see the details of the transactions for each bank account. You can click on any of the amount under the "Debit" or "Credit" section to view the detailed breakdown of the transactions and balances for that particular account.
Adjusted Trial Balance-Account Details Fields
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 Adjusted Trial Balance-Account Details report
The Adjusted 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.
Last updated
Was this helpful?