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 →