Daily stock register format that is in excel is used by the stock holders or may be the warehouse maintainers to manage the inventory in ware house. Every day Stock Register is a record of completed merchandise kept up once a day. Daily Stock Register must be kept up by each assessor under Rule 10 of Central Excise Rules, 2002.
This report contains subtle elements of depiction of products made/created, opening equalization, amount made or delivered, Total amount, amount evacuated, Assessable esteem, Amount of obligation payable, measure of Duty paid, and adjust amount of completed merchandise.
The One Item report can be seen in either in Summary mode or in Day Wise mode.
To see in Summary mode in this template do the following steps as mentioned below:
- Select One Item under Summary from the Daily stock Register menu to see Select Excise Unit screen
- In Select Excise Unit screen the Name of Excise Unit By default is set automatically as Tally ERP 9 shows ABC Company.
- In the event that you have more than one assembling unit select the suitable Excise Unit from the List of Excise Units for which you need to see the Daily Stock Register
- Name of Tariff: In this field select the Tariff to see the stock things/thing gathered under the chose tax. Select Water as Tariff. Which is you want to review select it in tariff section.
- Name of Item Select the item or commodity of which you want to see the availability and sales as shown AquaPure – 1Ltr in the template. It is selected from the List of Excise Stock Items.
- Enter From and To date: you can see the date wise sales that how much we sold in between these dates that mentioned to check for.
- You can also choose fitting Stock thing from the List of Excise Stock things to see the Daily Stock Register.
Daily Stock Register Format in Excel (How to Use)?
Unit Name: Displays the Unit Name for Which the Daily Stock Register is shown.
Stock Item: Displays the Stock Item – AquaPure – 1Ltr chose to see the Daily Stock Register
Units: Displays the Reporting UOM of the stock thing
Extract Tariff Classification: Displays the Excise Tariff Classification Name and Tariff Code of the Stock Item
Date: Displays the date of creation, deals, sent for encourage generation and so on.
Record Reference: Displays the reference to generation slip, deals receipt and so forth.
Opening Balance: Opening supply of the Item chose. The esteem will be caught from the Stock Item ace. In Tariff, Wise Daily Stock Register report, opening parity esteem indicated in the bosses of every single Stock Item under the Tariff chose will be caught.
Amount Manufactured: Displays the amount fabricated. Exchanges recorded utilizing Excise Manufacturing Journal (Production side) and Stock Journal for which the choice Use as Manufacturing Journal is empowered, will be caught here.
Add up to Quantity: Displays the aggregate amount (opening parity + amount fabricated) of stock thing.
Issued for Further generation u/n 67/95: Displays the amount of stock thing issued for advance creation under notice number 67/95. Exchanges which have been recorded utilizing Excise Manufacturing Journal (Consumption side) and Excise Sales exchanges recorded with Nature of Removal is set to Captive Consumption, will be caught here.
Issued for Repacking: Displays the Quantity of Item which are issued for repacking.
Issues for Home Clearance: This field shows the amount issued for local deals. The estimations of exchanges recorded with the Nature of Removal set to Domestic, Special Rate, or Removal As Such, this must be include in Daily Stock Register Format in Excel.
Issued for Export/SEZ under Bond: This field shows the amount of Item which is issued for trade deals under Bond. The qualities are caught from exchanges that have been recorded with the Nature of Removal set to Export and SEZ/Bond.
Issued for Export/SEZ under LUT: This field shows the amount of Item which is issued for send out deals under LUT. The qualities are caught from exchanges that have been recorded with the Nature of Removal set to Export/LUT and SEZ/LUT.
Issued for Export/SEZ under Rebate: This field shows the amount of Item which is issued for trade deals under Rebate. The qualities are caught from exchanges that have been recorded with the Nature of Removal set to SEZ/Rebate.
Issued for Exempt (To 100% EOU or Others): This field shows the amount of Item which is issued for Exempt deals. The qualities are caught from exchanges that have been recorded with the Nature of Removal set to Exempt.
To Other industrial facilities or Warehouses under Bond: This field shows the amount of things issues for deals to a Warehouse with CT2 shape issues by the distribution center.
Assessable esteem: This field shows the assessable incentive on which the obligation is figured
Extract Duty: This field shows the Excise obligation sum
Instruction Cess: Displays the Education Cess sum
Optional Education Cess: Displays the Secondary Education Cess sum
Parity Quantity: This field shows the Balance Quantity of stock Item. This adjust showed will consider the real amount indicated in each receipt for the chose Stock Item/Items.
Extract Notification: Displays the Excise Notification Number entered in the event of Exempt, Export exchanges or any notice issued by the Central Board of Excise and Customs.
All things considered this Daily Stock Register Format in Excel helps you to manage your inventory wisely and with full control.