Instructions — TallyStockJournal ExcelToTool

ABefore you start — prerequisites

1

Excel 2016 or later on Windows

The tool is a .xlsm (macro-enabled workbook). You need Microsoft Excel 2016, 2019, 2021, or Microsoft 365 on a Windows 10 or 11 PC. Excel for Mac and LibreOffice are not supported.

2

Tally Prime 3.x with XML access enabled

In Tally Prime, go to F12 (Configure) → Advanced Configuration → Enable ODBC Server and set it to Yes. The default port is 9000. Tally must be running and the correct company must be open when you post.

⚠️ If Tally Prime is not open when you click Post, the tool will show a connection error. Open Tally and try again.

3

Macros must be enabled in Excel

Go to File → Options → Trust Center → Trust Center Settings → Macro Settings and choose "Enable all macros", or at minimum "Disable all macros with notification" and allow the workbook when prompted.

💡 Alternatively, place the XLSM file in a Trusted Location (File → Options → Trust Center → Trusted Locations) and macros run without a prompt every time.

BPurchase & licence activation

1

Purchase on the buy page

Go to buy.html, select TallyStock ExcelToTool, fill in your details, pay via UPI, and submit the payment screenshot.

2

Receive your licence key by email

After the admin verifies your payment (typically within 12 working hours), you'll receive an email containing:

• Your licence key in the format TSXL-XXXX-XXXX-XXXX
• A download link for TallyStockJournal_ExcelToTool.xlsm
• Your GST invoice PDF

3

Download and open the workbook

Click the download link in the email (or download from here if already logged in). Save the .xlsm file to a permanent folder on your PC (not a temp folder).

Double-click to open in Excel. Click Enable Content when prompted for macros.

4

Enter your licence key

On first open, a dialogue box asks for your licence key. Paste the TSXL-XXXX-XXXX-XXXX key from the email and click Activate.

The tool contacts our server, binds the key to your Windows computer, and stores the key in the Windows Registry under HKCU\SOFTWARE\AuthenticTech\TallyStockJournal\. You won't be asked again on this PC.

⚠️ You need an internet connection for the one-time activation. After that, the tool works offline and only needs the internet once every 24 hours for a background validation ping.

CEntering stock journal data

All data entry happens on the Journal Entry sheet. Each row is one stock item line within a journal voucher. Use the Voucher No. column to group multiple item lines into the same voucher.

Column	Description	Required
Date	Voucher date (DD-MM-YYYY). All rows with the same Voucher No. must share the same date.	*
Voucher No.	Group identifier. Rows sharing the same Voucher No. are posted as a single voucher in Tally. Leave blank to auto-number.
Journal Type	Material In, Material Out, or Transfer	*
Stock Item	Exact name as it appears in Tally (case-sensitive)	*
Quantity	Numeric quantity (must be > 0)	*
Unit	Unit of measurement (e.g., NOS, KG). Must match the Tally stock item's unit.	*
Rate	Rate per unit in ₹. Leave blank to use Tally's last purchase rate.
Source Godown	Source godown name (for Transfer type or Material Out)
Dest. Godown	Destination godown name (for Transfer type or Material In)
Batch No.	Batch or lot number (if batch tracking is enabled in Tally)
Mfg. Date	Manufacturing date for batch (DD-MM-YYYY)
Expiry Date	Expiry date for batch (DD-MM-YYYY)
Narration	Free-text narration for this voucher line

⚠️ Item names, unit names, and godown names must exactly match what is configured in Tally Prime. A mismatch will cause that row to fail with a "master not found" error.

DPosting to Tally Prime

1

Ensure Tally is running

Open Tally Prime and select the company you want to post into. Verify the XML server is enabled (F12 → Advanced Configuration → Enable ODBC Server = Yes).

2

Click "Validate Entries"

Press the Validate Entries button in the tool's ribbon or on the control sheet. Any rows with issues are highlighted red with an explanation. Fix them before proceeding.

3

Click "Post to Tally"

Press Post to Tally. The tool generates the XML payload and sends it to http://localhost:9000 (or your configured host). A progress bar shows the posting status.

4

Review the summary report

After posting, the tool shows a summary: how many vouchers succeeded, how many failed, and the Tally error message for each failure. Successful rows are marked green; failed rows are marked red.

💡 Failed rows are not removed from the sheet. Fix the issue and click Post again — only the failed rows will be re-sent (already-confirmed rows are skipped).

5

Verify in Tally

In Tally Prime, go to Vouchers → Stock Journal and verify the newly created entries. Always spot-check a few rows after the first batch post on a new configuration.

ETroubleshooting

?

"Connection refused" or "Tally not responding"

Tally Prime is not running, or the XML server port is disabled or set to a different port. Open Tally, enable the ODBC server, and confirm the port in Tally's Advanced Configuration. Update the port in the tool's Settings sheet if needed.

?

"Licence key not found" or "Device mismatch"

The key is either invalid or bound to a different computer. If you changed machines, email autech1402@gmail.com with your order reference to request a device transfer — it's free.

?

"Master not found" for a stock item or godown

The name in your Excel sheet doesn't exactly match the master in Tally (check capitalisation, trailing spaces, and special characters). Open Tally, confirm the exact name, and update the Excel cell.

?

Macros disabled / "Security Warning"

Click Enable Content in the yellow bar at the top of Excel. If the bar doesn't appear, check your Excel Trust Center settings (Macro Settings) and ensure the file isn't in a restricted folder like Downloads.

?

Still stuck?

Email autech1402@gmail.com with your order reference number and a screenshot of the error. We typically respond within one business day.