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