Check stock on any past date in TallyPrime

Short answer: In TallyPrime, open the Stock Summary and change the period (Alt+F2) so it ends on the date you want; the closing quantity and value are your stock on that date. For one location, use the godown view of the same figures. TallyNexa shows stock on hand by godown on any date, walked from Tally’s own last month-end valuation so it agrees with Tally.

Stock Summary for a date

1. Open the company in TallyPrime.
2. Open Stock Summary from the reports.
3. Change the period (Alt+F2) so it ends on the date you want, for example 1-4-2026 to 30-9-2026.
4. Read the closing quantity, rate and value. Drill into a stock group or item for detail.

Choose the start of the period with care. With some costing methods, such as average cost, the closing value can change with the start of the period you choose. Use the same period your accounts use, usually from the start of the financial year.

Stock by godown

If you keep stock in more than one location, open the godown (location) summary in TallyPrime’s inventory reports, set the same period, and pick the godown. You see each item’s quantity in that location on that date.

Physical stock entries in TallyPrime are made per godown. A count entered for one godown resets that godown only.

Ageing

TallyPrime’s stock ageing analysis shows how long items have been lying, in age bands you set. Run it to the same date to see slow and dead stock, which is often what the auditor or banker really wants to know.

Why opening plus entries can differ from Tally

A quick way to get stock on a date is to take the opening stock, add purchases and take away sales up to that date. For quantity it often works. For value it often does not, because:

• Costing method. Average cost, FIFO and other methods value outward entries at a computed rate, not the rate on the bill.
• Physical stock entries. A count posted on a date resets the quantity on that date, whatever the entries before it said.
• Negative stock. If an item went below zero for a few days, its rate is worked out differently while it was negative.
• Stock journals and manufacturing. Transfers and consumption move value between items and godowns.
• Later entries. A back-dated purchase entered after you took your figure changes the past.

If you need a value that matches Tally, take it from Tally, or start from a value Tally has already calculated.

Stock on a date in TallyNexa

TallyNexa reads your stock from TallyPrime through its connector and shows stock on hand by godown for any date you pick.

1. Open stock on hand.
2. Pick the date.
3. Pick a godown, or see all of them.
4. Download it to Excel for the auditor or the bank.

To agree with Tally, TallyNexa walks from Tally’s own last month-end valuation before that date and adds the entries since, instead of starting from the opening stock.

The same screens show reorder alerts, items in negative stock and stock ageing, so slow items and shortfalls stand out without running separate reports.

A quick check before you hand it over

• Make sure all entries up to the date are posted, including transfers between godowns.
• Look for negative stock on the date; it means an entry is missing or late.
• Compare the total with the closing stock in the balance sheet for a nearby month-end.
• Note the costing method and the period you used on the sheet you hand over.

For the bank’s stock statement

Banks that lend against stock usually ask for a monthly statement of stock and debtors. Take stock from the same report each month, with the same period start, so the figures are comparable. If you value some items differently for the bank, keep that working separate and note it on the statement.

Keep a copy of each month’s statement with the report it came from. When the bank’s auditor visits, you can show how each figure was taken, and later entries in Tally will not leave you unable to explain an old number.