Last Updated on: 5th July 2024, 01:47 pm
Accounts Trial Balance in Tally
Accounts Trial Balance in Tally
You have learned about Account Summaries of Account Groups & Account Ledgers. Trial Balance is the comprehensive topmost level Summary report of Account Groups & Account Ledgers
Here, we explain various configuration options of Trial Balance to configure the format & contents of Trial Balance.
Accounts Trial Balance in Tally
Closing Stock Value in Trial Balance in Tally
As explained, the closing stock value is entered in the Stock Ledger Master, on the fly (not recorded through Journal). So, the Closing Stock Value will not appear in Trial Balance at Closing Balance column. For Stock Account, Closing Balance column would also show the value of Opening Stock.
Closing Stock Value entry in Tally
In Extended Trial Balance (with columns for Opening & Transaction figures), the Opening Stock value would be shown at Opening Balance column & Closing Balance. The difference of Opening & Closing balance will be back calculated and shown in Transaction columns (depicting Increase / Decrease in Stock), just for info, but not reflected in Closing Balance column, nor in the Group totals / Grand Totals.
Accounts Trial Balance Configuration in Tally
The Configuration of Trial Balance is similar to Group Summary. In fact, Trial Balance is Group Summary of all Accounts Groups.
Accounts Trial Balance Display Configuration
At Trial Balance Display, click F12: Configure to get configuration screen. Set up the following options as required.
| Opening Balance | At Show Opening Balances : Set Yes to include Opening Balance in the report Set No to exclude the Opening balance (only the transaction figures for the selected period are considered) |
| Transaction Details | At Show Transactions : Set Yes to show transaction figures (Debit & Credit amounts) for the selected period Set No to suppress the Transaction columns |
| – Net Transactions | Having set Yes at Show Transactions, At Show Net Transactions only Set Yes to show the Net Transactions (Net debit or credit),Set No to show both Debit & Credit figures in separate columns |
| Closing balance | At Show Closing Balance Set Yes to show closing balance for each account group / ledger Set No to suppress Closing Balance column Note: You must set Yes in at least one of the above 3 options (Opening Balance, Transaction, Closing Balance).When all the Amount Columns are selected (Opening, Transaction & Closing Balance), the Opening & Closing balances are shown in one columns (Dr/Cr), instead of separate columns (F-2B) |
| Details Levels | Having set F1:Detailed button, at Expand all Level in detail Format Set Yes to show all subordinate groups ledger accounts to the lowest levelSet No to show only the next level Groups/ Ledgers |
Trial balance Buttons in Tally
The Buttons at Trial Balance screen are similar to Group Summary
- F1 : Detail / Condensed : Normally the Trial Balance shows the top level groups figures only. Click F1:Detail button to show the next level details
- F4 : Group : To get the Trial Balance for a selected Group, click F4; group and select the desired Group. Select Primary to get the report of complete Trail Balance of all Primary Groups.
- F5: Led-wise / Grouped :Toggle button to get Ledgerwise Trial Balance in alphabetical order of Ledger Names / Groupwise with next level ledger Accounts.
- F7 :Vouchers : To get Group Vouchers report showing the vouchers of selected Group / Ledger
- Column Definition Buttons : To set column definition to get Columnar Report with other periods / Companies
Buttons
Click here to see PDF
