PrivacySecure

Features โ€” TallyStockJournal ExcelToTool

Complete feature breakdown for v1.x

Core journal functions

๐Ÿ“‹

Bulk stock journal posting

Enter any number of stock journal entries in the Excel sheet and post them all in a single click. No per-voucher limit.

๐Ÿญ

Multi-godown support

Each entry line can specify a source and destination godown. Works with any number of configured godowns in Tally.

๐Ÿท๏ธ

Batch / lot tracking

Specify batch number, manufacturing date, and expiry date per entry line for full batch-level traceability inside Tally.

๐Ÿ’ฐ

Additional cost of manufacture

Allocate additional costs (labour, processing, freight) against specific items within the same journal entry.

๐Ÿ—ƒ๏ธ

All Tally journal sub-types

Supports Material In, Material Out, and Transfer journal sub-types โ€” post the correct Tally voucher type every time.

๐Ÿ“…

Backdated vouchers

Set any voucher date within the active Tally period. Bulk-post historical entries from imports and audits.

Data quality & validation

โœ…

Pre-post row validation

Every row is checked for blank item names, zero quantities, mismatched units, and missing godowns before anything is sent to Tally.

๐Ÿ”ด

In-sheet error highlighting

Invalid rows are colour-highlighted directly in Excel with a tooltip explaining the issue โ€” no cryptic error codes.

๐Ÿ“Š

Post summary report

After posting, a summary panel shows how many vouchers were accepted, how many failed, and the specific Tally error message for each failure.

๐Ÿ”

Duplicate voucher detection

The tool warns if you attempt to re-post an entry with the same date and narration that was already sent, preventing accidental duplicates.

Excel user experience

๐ŸŽ›๏ธ

Clean, locked template

The input sheet has clearly labelled columns, frozen headers, and protected formula cells so accidental edits can't break the layout.

โšก

Keyboard-friendly data entry

Tab / Enter navigation down the data columns, auto-fill for repeating values, and paste-from-clipboard support for importing from other spreadsheets.

๐Ÿ’พ

Save & reuse templates

Save your commonly used entry templates as named sheets inside the workbook. Load any template with one click to pre-fill standard entries.

๐ŸŒ

Configurable Tally host

Default is localhost:9000. Change the host and port in the Settings sheet if Tally runs on a different machine on your LAN.

Licensing & security

๐Ÿ”‘

Single-device VBA licence

Licence key is bound to your Windows installation via a UUID stored in the Registry. Transfer is free; contact support by email.

โฐ

24-hour cached validation

The tool validates your licence online once per 24 hours. It keeps working during the interval even without internet access.

๐Ÿ”’

VBA code protection

The workbook's VBA project is password-protected to prevent casual inspection or modification of the licensing logic.

๐Ÿ“ต

Zero data upload

Your Tally data, stock items, and ledger names never leave your computer. The only server call is the licence validation ping.

Compatibility

SoftwareRequirementStatus
Microsoft Excel2016 / 2019 / 2021 / 365 (Windows)โœ“ Supported
Tally Prime3.x or above with HTTP XML enabledโœ“ Supported
Operating systemWindows 10 / 11 (64-bit)โœ“ Supported
Tally ERP 9Older XML formatโœ— Not supported
Excel for MacmacOS (VBA limitation)โœ— Not supported
LibreOffice CalcNo VBA engineโœ— Not supported
Ready to try it?

1-year licence ยท Single device ยท GST invoice included ยท โ‚น8,000 + 18% GST = โ‚น9,440

Buy now โ†’