Bills Register in Tally
Bills Register in Tally
Bill Registers represent a set of subsidiary Journal Books of Sales & Purchase and Debit & Credit Note Vouchers (Voucher Registers) showing transactions of Sales / Purchase and the Debit & Credit Notes with Customers & Suppliers. Normally, separate Bill Register is printed for each type of Voucher. Bill registers are just like Account Voucher Lists and most of the options are similar.
Bill Registers Display in Tally
At Gateway of Tally, select Display> Accounts Book to get Account Book Menu.
At Accounts Book Menu
- Purchase Register : Select Purchase Register to get Purchase Register
- Sales Register : Select Sales Register to get Sales Register
- Journal Register : Select Journal Register to get Journal Register Menu
Account Books Display menu in Tally
At Journal Register Menu
- Debit Note Register : Select Debit Note to get Debit Note Register.
- Credit Note Register : Select Credit Note to get Credit Note Register
Journal Books Display Menu in Tally
Initially, you get Monthly total figures. Select a month to get Bill Register (Voucher Register) for the month. Click F2: Period and enter the period (Date From & Date To) to get Bill Register for specified Period.
There are 2 types of Bill Register Reports
- Bill Register (Voucher Register) : This shows the details of each Voucher for the specified Voucher type for a specified period.
- Bill Register Extract : This shows Summary as per Accounts Group / Accounts Ledger (or Stock Group / Stock Ledger). In fact, Bill Register Extract is Summary of Bill Register.
Bill Register Display Configuration in Tally
The contents of Bill Registers may be configured trough Configuration options for each Voucher type. Most of the Bill Register Display Configuration options of Sales / Purchase & Debit / Credit Note are similar .
Bill Register Display Configuration in Tally
Bill Register Display Configuration Options in Tally
At the respective Bill Register screen, click F12:Configure to get the Bill Register Configuration screen and set the Configuration options
- Extract / Register : At Show Extract of Register , set No to get the Register with each voucher details. Set Yes to get Bill Register Extract, showing Ledger Account wise Summary of vouchers for the selected period, You may also click F6: Extract / Voucher toggle button
- Columnar / Regular Register : At Show Columnar Register, set Yes To define Columns and get Sales Register in Columnar format. Set Noto get Regular Register. You may also click F5: Columnar button.
- Format : At Format, Select ‘Detailed’ to view all ledger accounts of each voucher. Select ‘Condensed’ to get only the first ledger account (Party / Cash bank) and the net amount of the voucher. You may also set the Format using F1 : Detailed / Condensed toggle button at Button Bar
- Voucher Narration : At Show Narrations Also, Set Yes to show Voucher Narration for each Voucher (if entered). Set No to suppress Narration (Narration is not shown)
- Billwise details : This is relevant only when the Bill Ref is activated for the Company (you have Yes at Maintain Billwise Details at F11:Features>Accounting Features. At Show Billwise details also, set Yes to show the Bill Reference Details. Set No. Bill Reference is not shown (If Voucher Number & Bill Ref is same, you may suppress it)
Cost Centre Details : At Show Cost Centre Details also, set Yes to show Cost Centre Details also. This is relevant only when Cost Centre is activated.
Inventory Details : At Show Inventory Details also, to show Inventory Details also. This is relevant only when Inventory System is also activated
- Bank Details : This is relevant when Banking System is activated and for Cash Sales Purchase, where payment is made or received by Cheque. At Show Bank Details also, set Yes, to show Cheque Particulars, else set No.
- User Name : At Show Entered / Altered By Set Yes to show user name of voucher writer, else set No.
- Sales Contribution (Gross Profit) : To get the Sales contribution (Sales Value – Cost of Sales) for each Sales Voucher (this option is not available for other Voucher Types) with Profit % in respect of each sales voucher. This is relevant only when you maintain Inventory system also, where the Item wise Data of Cost (Purchase & Purchase expenses) & Sale Value is available.
At Show Gross Profit Estimates, set Yes to get a new column showing the Gross Profit % of each Voucher. Set No. The Cost & Gross Profit % columns are not shown
Bill Register Display Buttons in Tally
Bill Regsiter Button Bar in Tally
Bill Register button bar shows Buttons shows buttons as described below :
- F1 : Detailed / Condensed : Click F1:Detailed button to show all subordinate groups / ledger accounts. Click Condensed to show only top level groups / ledger accounts. You may also set Condensed / Detailed at Format option at Configuration screen
- F4: Chg Vch, : Click F4: Chg Vch button to select desired Voucher Type.to show the list of voucher of selected Voucher Type
- F5:Columnar : Click F5:Columnar button to get the Column definition screen to define Columnar Register
- F6 Extract / Vouchers: Click F6 Extract / Vouchers Toggle button to get voucher register Extract / Voucher Register. You may also set Yes / No at Show Extract of Register option at Configuration screen
- F7 : Show Profit / Hide Profit : Click F7 : Show Profit / Hide Profit Toggle Button to show the figures of Gross Revenue, Cost & Gross Profit / Loss (based on Cost) in respect of each Sales Voucher (Show Profit). You may also set Yes / No at Show Gross Profit Estimates, option at Configuration screen
Bill Register Display Format
The Bill Register Display in normal format, shows the Net Amount, in Debit columns for Sales & Debit Note, debiting the party Account, in Credit column for Purchase & Credit Note, crediting the party Account. All other accounts are shown in inner column, with Dr Cr indicator.
The total of only the net amount related to Party / Cash Bank Account is shown in Debit columns for Sales, in Credit column for Purchase. So, you do not get Accountwise total of each ledger account, in Bill registers. The Bill register extract report, shows the Accountwise totals for each Ledger Account
Debit & Credit Note Registers do not show any Grand Total figures.
Sales Register Display in Tally
The Sales Register is a subsidiary Journal book, which shows the Sales Vouchers in chronological order.
At Gateway of Tally, select Display> Accounts Book > Sales Register to get Sales Register (Monthly Summary), Select a month to get Voucher Register (of all Sales Vouchers) for the specified month. You may set the desired Period through F2: Period button to get the list of all Sales Voucher for the specified period
Sales Register Display in Tally
Purchase Register Display in Tally
The Purchase Register is a subsidiary Journal book, showing the Purchase Vouchers
At Gateway of Tally, select Display> Accounts Book > Purchase Register to get Purchase Register (Monthly Summary), Select a month to get the Voucher Register (of Purchase Vouchers) for the specified month. You may set the desired Period through F12: Period button to get the list of all Purchase Voucher for the specified period
Sales Register Display in Tally
Debit Note Register Display in Tally
Debit Note Register is a subsidiary Journal book, showing the Debit Notes.
At Gateway of Tally, select Display> Accounts Book> Journal Register >Debit Note Register to get Debit Note Register, showing monthly counts of Debit Note Vouchers.
Select a month to get the Voucher Register of Debit Note Vouchers for the month. Click F2: Period and set the period to get the list of Debit Note Vouchers for the specified period
Debit Note Register Display in Tally
Credit Note Register Display in Tally
Credit Note Register is a subsidiary Journal book, showing the Credit Notes.
At Gateway of Tally, select Display> Accounts Book> Journal Register >Credit Note Register to get Credit Note Register, showing monthly counts of Credit Note Vouchers. Select a month to get the Voucher Register of Credit Note Vouchers for the month. Click F2: Period and set the period to get the list of Credit Note Vouchers for the specified period.
Credit Note Register Display in Tally
Bill Register Printing in Tally
Bill Register Printing in Tally
At Bill Register display, Click P:Print button to get Bill Register in Print , showing the amount for each ledger account is shown in respective Debit / Credit column.
However, in Grand Total, the total of net Bill amount only is shown in Debit Column, for Sales & in Credit Column in Purchase. So, if there is any deduction amount, the column total may not correspond to the total of the individual amounts in the respective column
In Debit / Credit Note Register, the Report Grand Total is not shown.
Sales Register printed from Display screen
Sales Regsiter in Print in Tally
Credit Note Register printed from Display screen
Credit Note Regsiter in Print
Bill Register Printing Options in Tally
At respective Bill register display screen, Click P:Print button to get Bill Register printing screen, with options similar to Bill register Display .
Register Printing Configuration in Tally
Type Y to print the Bill Register as per default options set, as shown. Type N to re-set the options as required and type Y to print the Bill Register as per options re-set
Multi Account Bill Register Printing Menu
Multi Account Printing is available only in licensed version. It is not available in Education version. It is useful for printing bulk reports in Printer.
Multi Account Printing option at main Menu
Apart from printing Bill Register from Display screen (click P:Print button at Display screen),
you may print Sales, Purchase, Debit & Credit Note Register from Multi Account Printing menu. This method is more convenient for regular bulk printing.
At Gateway, select Multi Account Printing >Account Books to get Multi-Account Account Books Printing Menu.
Multi Account Books Printing Menu
At Multi-Account Printing Menu, select Purchase / Sales Register
Multi-Account Account Books Printing Menu
Multi Account Bill Register printing in Tally
At Muti Account Bill register printing screen, Set the period and other printing options, to print respective Bill Register for the specified period.
Multi Account Sales Register Printing Options in Tally
The Register printed from Multi-Account printing is similar to Registers printed by Print option for Display. The figures are shown in respective Debit / Credit columns separately, and the report Grand Total of Net Bill Amount only is shown in Debit / credit Column (which may not be the total of respective Column if there is any deduction amount in the Bill)
Multi Account Purchase Register Printing Options in Tally
Multi Account Debit / Credit Note Register in Tally
At Multi-Account Account Printing Menu, select Journal Register to get Journal Register Menu which also contains the option to print Debit / Credit Note Register. Select Debit / Credit Note register to get the respective Register printing screen.
Multi Account Debit Note Register Printing Options in Tally
At Muti Account Debit / Credit Note register printing screen, set the Period and other options, similar to Debit Credit Note Register Display Configuration screen.
Multi Account Debit Note Register Printing Options in Tally
The Register printed from Multi-Account printing is similar to Registers printed by Print option from Display. The figures are shown in respective Debit / Credit columns separately. Report Grand Total is not shown in Debit / Credit Note Register.
Group Vouchers Report in Tally
Group Vouchers Report shows all the Vouchers (of any Voucher Type) in which any ledger subordinate to the selected Account Group is transacted. This Report does is not specifically related to Sales / Purchase, but selecting Sales / Purchase Group, you may get the list of all Vouchers related to Sales / Purchase Accounts . Hence, Group Vouchers are also considered as a type of Bill Register.
If Cash Sales & Purchases transactions are entered through Receipt / Payment Vouchers or Credit Sales / Purchase are entered through Journal Vouchers, then such Vouchers will not be listed in Sales / Purchase Register, but will be listed in Group Voucher Report of Sales / Purchase Group. So, Group Voucher list of Sales / Purchase Group is more comprehensive and covers all sorts of Vouchers in respect of any ledger account transacted (in any voucher type), under a specified Account Group (e.g Sales or Purchase Group).
Group Vouchers report Display in Tally
Group Voucher Report Display in Tally
At Gateway of Tally, select Display >Account Books > Group Vouchers and then select Sales Accounts / Purchase Accounts to get respective Group Vouchers list
Like Ledger Accounts display, the Group Vouchers list display shows
- Opening Balance : Total Opening Balance of all ledger Accounts under the selected Group, for the start date of the Report period
- Transaction Totals : Total of all Debits & Credits of all transactions ofall ledger Accounts under the selected Group, for the Report period
- Closing Balance : Total Closing Balance of all ledger Accounts under the selected Group, for the end date of the Report period
Group Voucher Report Display Configuration in Tally
At Group Voucher Display, click F12:Configure to get Group Voucher Display Configuration screen.
Group Voucher Display Configfuration in Tally
Group Voucher Report Display Configuration in Tally
At Group Voucher Display Configuration screen, you may set the following options :
Transaction Types : At Select Vouchers to Show, select All Vouchers, to list both having either Debit or Credit transactions for the selected Account Group, Debit Entries only, to list only Debit transactions for the selected Account Group, Credit Entries only, to list only Credit transactions for the selected Account Group
Ledger Details :Set Yes at Show All Ledger details to show details of each Ledger Account transacted in the Voucher, else set No to show the transaction of ledger Accounts under the selected Group only.
Having set Yes at Show All Ledger details, you may further set:
- Bank Details : At Show Bank Details also, set Yes to show the details of Bank Transaction (Cheque details etc) in the voucher also, if any, else set No (Bank details are not shown)
- Other Ledger Details : Having set Yes at Show Bank Details also, you may further set Yes at Show Additional Details, to show the details of all other complementary Ledger Accounts transacted in the Voucher (in inner column), else set No (Other Ledger Accounts transactions are not shown)
Group Voucher Report Display Buttons in Tally
At Group Voucher Display, you get the following Buttons
- F1: Detailed / Condensed : Toggle button to get Top Level Groups only (Summary) / Next Level Group / Ledger details also (Detailed).
You may also set Detailed / Condensed at Format option of Configuration screen
- F4: Group : To select a Group to display Group Vouchers for the selected Group
- F6: Monthly / Quarterly : Toggle button to select the periodicity of Group Vouchers Summary
- F7:Summary / Vouchers : Toggle button to get Accountwise Summary / detail list of Vouchers
Group Voucher Display Button Bar in Tally
Group Voucher Report Printing in Tally
At Group Voucher Display, click P:Print Button to get Group Voucher Printing screen, showing printing options similar to Group Voucher Display Configuration options. Set the options and Type Y for Group Voucher Report Printing, similar to Group Voucher Display.
Group Vouchers report in print in Tally
In print format, the Opening balance is shown at the beginning, followed by transactions and the Closing Balance is printed at last line.
Click here to see PDF
