Tally Inventory Automation tool, Automate Tally Prime stock items, raw material consumption, manufacturing production, and stock journals directly..
Tally Inventory Automation tool: Bulk Stock Items, Consumption & Production from Excel
Managing inventory, logging bill-of-materials production, and entering multi-item stock journals in Tally Prime is often one of the slowest workflows in industrial accounting. If your business handles raw material consumption or frequent item master additions, the SaralTax Tally Prime Inventory & Stock Automation Utility automates the entire pipeline directly from Microsoft Excel.
Why Automate Tally Inventory Vouchers?
Standard inventory entries in Tally require selecting items one by one, picking units, assigning godowns, and verifying rates for both source (consumption) and destination (production). A single manufacturing batch with 20 components can easily take 10 to 15 minutes to record manually.
This utility allows storekeepers, factory accountants, and tax professionals to prepare structured Excel registers and post hundreds of inventory lines into Tally Prime in seconds.
⚡ 4 Dedicated Inventory Modules
- 1. Bulk Stock Item Creation: Create hundreds of new inventory masters in Tally in one run—complete with Stock Group, Stock Category, Base Units (UOM), alternate units, HSN/SAC code, and GST tax rate slabs.
- 2. Stock Consumption (Raw Material Issue): Post internal issues, wastage logs, and job-work material transfers directly as Stock Journal consumption entries.
- 3. Manufacturing & Production Vouchers: Log multi-item consumption (Source) alongside finished goods / co-products (Destination) in a single balanced Stock Journal voucher.
- 4. Stock Adjustment & Physical Stock Entry: Import opening inventory balances, stock counts, and godown-to-godown transfers with zero manual retyping.
How It Works: 4 Simple Steps
- Prepare Data: Fill in your item codes, godowns, quantities, and rates in the designated Excel stock template.
- Run Built-In Validation: When clicking Post Item/Post Entries, it will automatically Validate Stock to detect errors and enter them in the last column.
- Sync with Tally: Make sure Tally Prime is open, and your company is loaded.
- Post Vouchers: Click "Push Stock Journal" or export ready-to-import Tally XML—vouchers post instantly.
- For posting entries, Tally should be open in the background.
Frequently Asked Questions (FAQs)
Q: Does this utility handle Godown/Location allocations?
A: Yes. You can allocate individual stock items to specific godowns/warehouses for both consumption and destination production entries.
Q: Can I create stock items with HSN and GST details in bulk?
A: Yes. The Master Creation tab allows you to define the item description, HSN code, GST rate (exempt, 5%, 12%, 18%, 28%), and unit of measurement before pushing them into Tally Prime.
Q: How is the software licensed?
A: Each license is valid for 1 full year and binds automatically to your PC's motherboard BIOS UUID upon first activation. Single-machine protection ensures stability and keeps your license secure.
Q: Does it work with multi-company setups in Tally?
A: Yes. The tool dynamically communicates with whichever company is currently open and active in Tally Prime.
Home Screen
COMMENTS