Batch Vouchers provides a list of all vouchers for a stock item of the same batch for a specific period. The report comprises of both inwards and outwards transactions along with quantity, rate and closing value details for the selected batch.
The Batch Vouchers report will be available when the option Maintain Batch-wise Details is enabled in F11: Inventory Features (F2).
To enable batch-wise details refer Using Batch-wise details.
To view Batch Vouchers report,
Go to Gateway of Tally > Display > Inventory Books
Select the Batch menu.
Select the required stock item and select the Batch from the List of Batches.
The Batch Vouchers report appears as shown below:
Note : The Batch Vouchers report is available if the option Maintain Batch-wise Details is enabled in F11: Inventory Features (F2).
Alternatively, Batch Vouchers report can also be viewed from the Stock Vouchers screen. To view Batch Vouchers report,
Go to Gateway of Tally > Stock Summary
Press Enter and drill down to the Stock Voucher screen.
Press F5: Batch and select the required batch for the selected item, as shown below:
The Batch Vouchers Report appears as shown below:
To view Profitability and Consumption details, press F7: Show Profit button from Batch Vouchers screen. The report will display quantity and value of the opening stock, inward goods, outward goods, closing stock and the value of consumption (using the cost method.
Show Narrations also
Set this option to ‘Yes’ to view the report with narration for all transactions.
Select vouchers to show
By default All Vouchers will be displayed for the selected batches. If you like to view only ‘Inwards’ or only ‘Outwards’ entries, the same can be selected here.
Show goods inwards
Set this option to Yes to display all Inward details, like inward quantities, inward rate and inward value.
Show goods outwards
Set this option to Yes to display all Outward details, like outward quantities, outward rate and outward value.
Show Closing Balance
Set this option to Yes to display closing quantity, rate and value.
Closing Quantity = Opening quantity + Inward Quantity – Outward Quantity
Closing Rate = Closing Value / Closing Quantity
Closing Value = The Closing Stock Value will be based on the Costing Method adopted for each item.
Show using Alternate Units
Set this option to Yes, to display information about alternate units, if stock item is created with alternate units.
Show Tail Units of Compound Units
Set this option to Yes to display information about compound units, if stock item is created with the compound units.
Use default valuation for Closing Values?
(else uses ‘outwards’ value – ‘Inward’ values)
Set this option to No to display the closing value using the formula 'Closing value = Opening value + Inward value – Outward Value'. Transaction value is only for reporting purpose to compare with default valuation. It will not show it in Profit and Loss account.
Show Gross Value for Outwards
Gross value of Outwards refers to that value which is inclusive of the values of VAT/any other allowed ledger under accounting allocation screen of the stock item. By default this option will be set to ‘No’, when it is set ‘Yes’, it will display the gross value of the outwards.
Show Consumption & Gross Profit for ‘Outwards’?
By default this option will be set to No. Pressing F7: Show Profit in the button bar or enabling this option in F12: Configuration will display gross profit / loss of batch selected.
For detailed explanation on each column click here.
Show Gross Profits on Gross Value
By default this option will be set to ‘No’. When this option is set to Yes, the gross profit will be calculated on the Gross Value which is inclusive of the values of VAT/any other allowed ledger under accounting allocation screen of the stock item.
Sorting Method
This will help the user to sort the report Alphabetical wise increasing / decreasing.
F5: Batch
Navigation to other stock item and batches from the same report is possible.
F6: Batch Summary
Displays the Batch Summary of all the batches for the selected Stock Item. Click here for more details.
F7: Hide Profit
By default, this report displays Batch-wise stock item profitability. Click F7: Hide Profit to hide the same.
Note: This button toggles between Show Profit / Hide Profit.
You can alter the details in the Stock Item Masters, by pressing S: Stock Alter.
Explanation for each column is displayed as below:
|
Columns |
Details |
|
Inwards |
All the goods Inward item are captured here. |
|
Outwards |
All the goods Outward item are captured here. |
|
Consumption |
Cost of Goods Sold of respective outward entry. Cost of Goods Sold derived as per valuation method specified in item master. |
|
Gross Profit |
Outward Value – Cost of Goods Sold. |
|
Perc % |
Gross Profit / Outward Value x 100 |
|
Closing Quantity |
Outward Quantity – Inward Quantity |
|
Closing Rate |
Closing Value / Closing Rate |
|
Closing Value |
Stock item closing value. This value is derived as per valuation method specified in item master. If Transaction value is enabled in F12 then Closing value = Opening value + Inward Value – Outward Value. This transaction value is only for reporting purpose to compare with default valuation. It will not show it in Profit and Loss account. |
|
Total Inward |
Opening + Total Inward entries |
|
Total Outward |
Total Outward entries |
|
Total Consumption |
Total Inward Value – Total Closing Value |
|
Total Gross profit |
Total consumption – Total Outward Value |
|
Total Closing |
Closing value derived as per valuation method specified in item master. If Transaction value is enabled in F12 then Closing value = Opening value + Inward Value – Outward Value. |
Batch Summary is a summary of all the batches of a particular Stock Item for the given period. You can select the required batch and further drill down to view the Batch Monthly Summary and then further to Batch Voucher Report of the selected batch of an item.
The Batch Summary will be available when Maintain Batch-wise Details is enabled in F11: Inventory Features (F2.
To enable Batch-wise Details refer Using Batch-wise details.
To view Batch Summary,
Go to Gateway of Tally > Display > Inventory Books > Batch.
Select the required Stock Item and select the Batch from the List of Batches.
The Batch Vouchers report appears as shown:
Click F6: Batch Summary or press F6.
The Batch Summary of the selected item appears as shown:
Select the required batch and press Enter to view the Item Batch Monthly Summary as shown:
Drill down further to view the Batch Vouchers Report.
Note: The Batch summary displays the report of the month on which the last transaction entry was passed for the selected item. Press F2:Period to change the period.
The Configuration settings Show Quantities, Show Rates, Show Values, are self explanatory.
The Configuration settings Show Opening Balance, Show goods inwards and Show goods outwards are by default set to No. Set Yes to the required options to view them as separate column(s) in the Batch Summary Report.
Show All items (incl. zero balance)?
By default, this option will be set to No, when it is set Yes, it will display the zero balance items also.
Show Consumption & Gross Profit?
By default, this option will be set to No. Pressing F7: Show Profit in the button bar or enabling this option in F12: Configuration will display gross profit / loss of batch selected.
For detailed explanation on each column click here.
Show using Alternate Units?
By default, this option will be set to No. By setting this option to Yes, it will display the Alternate Units information, if stock item is created with the Alternate units.
Show Tail Units of Compound Units?
By default this option will be set to No. By setting this option to Yes, it will display the Compound Units information, if stock item is created with the Compound units.
Show Expired Batches only?
By default, this option is set to No. Set this option to Yes to view only the expired batches.
Show Mfg Date?
By default, this option is set to No. Set this option to Yes to view the Manufacturing date(s) of the batch(es) of a selected stock item.
Show Exp Date?
By default, this option is set to No. Set this option to Yes to view the Expiry date(s) of the batch(es) of a selected stock item.
Show Batch Manufacture Details From, To:
By default, the From and To fields will be blank. You may filter to view the Manufacturing dates of the batches based on the date range mentioned in these fields. E.g. From: 1-4-2009 To: 31-3-2010 will display only those batches which were manufactured during this period.
Show Batch Expiry Details From, To:
By default, the From and To fields will be blank. You may filter to view the Expiry dates of the batches based on the date range mentioned in these fields. E.g. From: 1-4-2010 To: 31-3-2011 will display only those batches which expire during this period.
Show No. of days for expiry?
By default, this option is set to No. Set this option to Yes to view the number of days to expire against each batch for a selected stock item.
Example:
The default Batch Summary report:
The configuration settings for the manufacturing and expiry of batches are shown below:
The Batch Summary for the above configuration settings appears as shown:
Scale Factor for Values:
You can select the required scale factor from the list namely, Hundreds, Thousands, Lakhs, etc. to view the report based on the same.
Sorting Method:
This will help the user to sort the report based on the Sorting Methods listed, namely, Alphabetical, Amount-wise, Expiry date, Mfg date, Quantity-wise and Rate-wise all in increasing and decreasing.
F4: Item
Navigation to other Stock Item to view the Batch Summary of the same.
F7: Show Profit
Displays Batch wise stock item profitability.