Columnar Accounts Register in Tally

Columnar Accounts Voucher Register in Tally

We have seen various types of Accounts Voucher Lists in which each Ledger Account transaction is printed in separate line, showing debit or credit figures, as applicable, in a common column. To get the account wise details, you have to look into Ledger Book, a separate report.

However, businessmen sometimes prefer these reports (listing like Journal & Account wise figure like a Ledger) in a compact tabular report. The columnar Voucher register shows the voucher details like any Account Voucher List, and simultaneously it shows the amount in separate columns for Ledger Accounts / Account Group, to give the figures like a Ledger. So, it is combination of a Journal & Ledger.

Columnar Voucher Register gives detailed (each voucher detail) as well as summary figures (column totals for each ledger / group), provide more information at a glance, are compact in format conserving space and simpler to apprehend.

Further, the Ledger Account columns and Report contents may be defined by the user to print various types of columnar reports. Such facility makes the columnar report a great tool to get customized reports.

Accounts Voucher Register Column Definitions in Tally

You get Column Definition screen through the following reports

Columnar Reports are defined and viewed through a set of buttons, available in some reports

Columnar Voucher Register : Select GoT>Display > Account Books)
Sales / Purchase columnar Register : At Accounts Books, select Sales Register or Purchase to get Monthly summary report. Select a month and set the period to get Voucher Register of Sales / Purchase Register
Columnar Journal Register : At Accounts Books, select Journal Register>Journal Register to get Monthly statistics of Journal Voucher Select a month and set the period to get Journal Register
Columnar Debit / Credit Note Register : At Accounts Books, select Journal Register>Debit Note Register or Credit Note Register to get Monthly statistics of Debit / Credit Note Voucher Select a month and set the period to get Debit Note / Credit Note Voucher Register
Columnar Day Book : At GoT>Display > Day Book Click F4:Chg Vch and select a Voucher Type, Click F5: Columnar button or set Yes at Show Columnar Register at List of Voucher Configuration option.
Columnar Ledger Vouchers : At Display > Account Books > Ledger -> select a Ledger,

Column Definition screen : At Day Book / respective Voucher Register, click F5: Columnar button or set Yes at Show Columnar Register at Voucher Register configuration option. At Ledger Voucher, click F8: Columnar button (or press Alt+F8), to get Columnar Register Alteration screen

Column Set Up : The Columnar Register Alteration screen contains 2 parts to set column definitions :

Voucher Particulars : In the first part (Voucher Particulars), you specify the Voucher Particulars (particulars of the entire voucher).
Ledger Accounts : In the second part (Ledger Amount), you specify the Ledger / Groups (Ledger / Groups for which the amount is shown in the column ).

Columnar Register column definition in Tally

Columnar Accounts Voucher Register Column Definition in Tally

At Columnar Register Alteration screen , at upper part of the Columnar Register Alteration screen, set Yes / No to create the columns to show the respective data in each column. These columns appear first in the report.

Voucher Type : At Show Voucher Type, set Yes to show the Voucher Type. This column is useful when you print the Report for all types of Voucher, else set No to omit this column
Voucher Number : At Show Voucher Number set Yes to show the Voucher No. else set No to omit this column (when Voucher Number is not maintained)
Voucher Ref : At Show Voucher Ref set Yes to show the Voucher Ref No. else set No to omit this column
Party’s Tax Regn No : At Show Party’s Tax Regn No, set Yes to show the Party’s Tax Regn Number (GST), Useful when GST is also implemented in the system, else set No to omit this column
Service Tax Regn No : At Show Service Tax Regn No, set Yes to show the Party’s Service Tax Regn Number Useful when Service Tax is also implemented in the system, else set No to omit this column
IT PAN : At Show PAN No, set Yes to show the Party’s Income Tax PAN, else set No to omit the column.
CST No : At Show CST No, set Yes to show the Party’s Central Sales Tax Regn Number Useful when CST is also implemented in the system, else set No to omit this column
Voucher Narration : At Show Voucher Narration, set Yes to show the Voucher Narration. else set No to omit this column (to conserve space)
Quantity Details : At Show Quantity Details,Set Yes to show Quantity details of the Item. This is useful when Inventory System is also implemented, else set No to omit this column
- Rate details : If you have set Yes at show Quantity details , you may further Set Yes to at Show Rate details, to show Rate details of the Item, else set No to omit this column. Item Rate column useful when Inventory System is also implemented,
Item Value : At Show Item Value, set Yes to show Value of the Item. This is useful when Inventory System is also implemented, else set No to omit this column

Columnar Voucher Register Account Columns in Tally

At the lower part of the Columnar Register Alteration screen, define the Amount columns, where the amount of respective Account Group / Ledger Accounts are shown

For versatility, several sets of definition scheme, to show columns for Ledger Amounts, Group Amounts or a combination of them are provided,

At Type of Columns field, select the Column Type :

Columnar Register Column Type List in Tally

Columnar Accounts Voucher Register Auto Column Set Up in Tally

At Type of Column, select All Items (Automatic Columns), from the Column type list to automatically create individual column for each Ledger Account transacted in the Vouchers for the period, to produce the Columnar Register.

Columnar Register in Print in Tally

Account Group / Ledger Account Column set up in Tally

To create column for Account Group / Account Ledger, at Type of Column , select the respective option from the column type list , as follows:

Select Group to create column for the summed up figures of all subordinate ledgers of an Account Group
Select Ledger to create column for specific Ledger Accounts
Select All Items (in One column) to combine the remaining Ledgers (Items which are not selected individually) in one Column only.
Specific Group / Ledger Column definition : Now specify the column definition for Group / Ledger columns

Select Related Items (Automatic Columns). Related Item means the Complementary / Left out transacted Accounts, other than specifically selected Accounts.

Specific Ledger : When you select Ledger, a column will be auto created for each selected ledger account transacted in the Vouchers
Specific Group : When you select Group, a column will be created for each Account Group in which the figures of all subordinate ledgers accounts transacted in the voucher, falling under the selected Account Group
Related Accounts : When you select Related Items (in One Column), figures of related Ledgers will be clubbed together into one column named Others

Group/Ledger Column Selection list in Tally

Multi Accounts Voucher Columnar Register in Tally

You may print Multi Account Columnar Register for various Account Books.

At Gateway of Tally, select Multi Account Printing > Account Books to get Multi-Accounts Accounts Books printing menu , and then select the respective option the Account Books

At the respective Multi Account Register printing screen , set Yes at Show Columnar Register to get the Column Definition screen . At Column Definition screen , set the column definition as described .

Having set the Column definitions, you get the Multi Account Columnar Register printing screen. Set the printing options and type Y to print the Columnar Register ,as per options set at Multi Account Columnar Register printing screen .

Multi Account Columnar Register printing in Tally

Columnar Multi Account Sales Register in Tally

Select GoT> Multi Account Printing > Account Books > Sales Register . At Multi Account printing screen set Yes at Show Columnar Register and then set the columns definitions to print Columnar Multi Account Sales Register .

Multi Account Columnar Sales Register in Tally

Columnar Multi Account Purchase Register in Tally

Select GoT> Multi Account Printing > Account Books > Purchase Register . At Multi Account printing screen set Yes at Show Columnar Register and then set the columns definitions to print Columnar Multi Account Purchase Register .

Date	Particulars	Voucher Type	Vch No.	Sales Tax No.	PAN No.	Narration	Gross Total	Purchase	Freight	Discount on Purchase
01/06/2009	B M Suppliers	Purchase	1	WB 3790	ACFBT 3457D	Purchases from B M Supplier a s per their Bill # 12 Dt 31.5.09	2200.00	2100.00	300.00	-200.00

01/11/2009	B M Suppliers	Purchase	2	WB 3790	ACFBT 3457D	Materials purchased ag party’s Inv No 12 dt 3110.11	3040.00	3000.00	40.00

01/11/2009	B M Suppliers	Purchase	3	WB 3790	ACFBT 3457D	Materials purchased ag party’s Inv No 14 dt 3110.11	3040.00	3000.00	40.00

01/12/2009	B M Suppliers	Purchase	4		ACFBT 3457D	Materials purchased ag party’s Inv No 12 dt 3110.11	3040.00	3000.00	40.00

	Grand Total						11320.00	11100.00	420.00	-200.00
F-7A:Multi Account Columnar Purchase Register in Tally

Multi Account Columnar Debit & Credit Note Register in Tally

Like Columnar Sales & Purchase Register, you may set up columns for Debit Note Register & Credit Note Register also, and print the Register as per columns options set, as described.

Multi Account Columnar Debit Note Register in Tally

Select GoT> Multi Account Printing > Account Books > Journal Register > Journal Register . Now select Debit Note Register or Credit Note Register . At Multi Account printing screen, set Yes at Show Columnar Register and then set the columns definitions to print Columnar Multi Account Debit Note Register , or Columnar Multi Account Credit Note Register

Multi Account Columnar Credit Note Register in Tally

Multi Account Columnar Journal Register

Select GoT> Multi Account Printing > Account Books > Journal Register > Journal Register . At Multi Account printing screen, set Yes at Show Columnar Register and then set the columns definitions to print Columnar Multi Account Journal Register .

Multi Account Columnar Journal Register in Tally

Columnar Petty Cash Book in Tally

Using the columnar feature of Ledger, you may print Petty Cash Book in columnar format. To maintain Petty Cash:

Create a Petty Cash Ledger Account and Main Cash Account (under Cash -in -Hand).
To transfer money from Main cash to Petty Cash, create a Contra voucher as usual.
In all payments from Petty Cash, create payment voucher. Select Petty Cash Account.

To print Columnar Petty Cash Book, select Display > Account Book > Ledger, select Petty cash Account. Click columnar button and set the columns.

All the vouchers having a transaction with Petty Cash Ledger account are listed

Multipart Columnar Register Printing

When you select too many columns during Display, you may pan the report (left & right) to see the columns.

When you print such wide report, the report is broken into multiple parts and you may print the specific part, specifying the page range, as explained under Multi part Reports You may view the specific Part in Print Preview. In the first few columns the specified voucher info are shown, followed by the defined amount columns are shown. Such reports are useful to paste the parts together, to get a wider report than what the printer allows to print. The 2^nd part onwards, the Voucher info columns are not printed. So, you need to paste the parts together to make use of the report.

Multi Part Register in Tally

Click here to see PDF