Which checks does it run?

Cash payments above ₹10,000 to one party in a day (section 40A(3)), cash receipts of ₹2 lakh or more (section 269ST), days with negative cash, possible duplicate vouchers, large year-end journals, large round figures, material entries without narration, Sunday entries and gaps in voucher numbers.

Does it need Tally to be open or any add-on installed?

No. It only reads the exported file, in your browser. Nothing is installed and nothing is uploaded.

Does it decide that something is disallowed?

No. Every point is a prompt for the auditor. Rule 6DD exceptions and genuine business reasons are yours to judge.

toolstally-scrutinyfree · runs in your browser

Tally Day Book XML to Excel, with audit scrutiny checks

Drop the Day Book XML. Get ledger scrutiny flags, a ledger summary and the full register in Excel.

YOU BRING: The Tally Day Book for the full year, exported as XML
YOU GET: An Excel audit pack: flagged vouchers, ledger summary and the full voucher register
YOUR DATA: Read in your browser. The file is never uploaded.

Add your file(you are here)
Check the result(next)
Download(next)

Drop the Day Book XML here, or click to choose

In Tally: Display → Day Book → set the full year with Alt+F2 → Export (Alt+E) → format XML. The file is read in your browser and never uploaded.

Did this help?

IN SHORT

What the Tally Day Book → audit pack does

This free tool reads a Tally Day Book exported as XML and produces an audit pack in Excel: ledger scrutiny flags, a ledger summary and the full voucher register. It checks cash payments above ₹10,000 (section 40A(3)), cash receipts of ₹2 lakh or more (section 269ST), negative cash days, duplicate vouchers, year-end journals and more. Nothing is installed in Tally and the file never leaves the browser.

Share on WhatsApp Track every client's filings on Firm Desk →

Updated 18 Sep 2026

Tally Day Book XML to Excel: a worked example with audit checks

In Tally open Display, Day Book, set the full year with Alt+F2, then Export with Alt+E and choose XML. The tool reads each voucher and runs the checks on it. Every finding is a prompt to look, not a conclusion.

Vouchers in the file: 7
Period: 12/08/2025 to 28/03/2026
Cash ledger: Cash
Opening cash: ₹20,000

Debits are the negative amounts in the XML and credits the positive ones. The tool reads 7 vouchers and 0 of them are unbalanced.
Payment 1 is ₹35,000 in cash on 12/08/2025. That is above the ₹10,000 limit and it takes the cash balance below zero.
The two printing payments on the same day have the same ledgers and amount, so they are flagged as possible duplicates.
The year-end journal of ₹5,00,000 has no narration, is a round figure and falls in the last days of March, so it appears under three checks.

9 findings under 9 checks, from 7 vouchers.

Findings the tool raises on the example Day Book
CHECK	DATE	VOUCHER	LEDGER	AMOUNT	DETAIL
Cash payments above the limit	12/08/2025	Payment 1	Repairs and maintenance	₹35,000	cash paid to "Repairs and maintenance" on one day exceeds ₹10,000
Cash receipts of ₹2 lakh or more	20/08/2025	Receipt 1	Gupta Traders	₹2,50,000	cash received from "Gupta Traders" on one day
Days with negative cash balance	12/08/2025	-	Cash	-₹15,000	Closing cash balance for the day is negative (opening balance used: ₹20,000)
Entries dated on a Sunday	07/09/2025	Payment 2	Office rent	₹25,000	Dated on a Sunday
Large round-figure entries	28/03/2026	Journal 1	Consultancy charges	₹5,00,000	Round figure
Large entries without narration	28/03/2026	Journal 1	Consultancy charges	₹5,00,000	No narration
Large journals in the last days of the year	28/03/2026	Journal 1	Consultancy charges	₹5,00,000	Journal in the last six days of March
Possible duplicate vouchers	14/10/2025	Payment 3	Printing and stationery	₹18,000	2 vouchers look identical: nos. 3, 4
Gaps in voucher numbers	-	Payment	-	2 missing	Missing Payment numbers: 5–6

Tally Day Book audit checks

These are the ten checks and what each is for. The limits can be changed in the tool.

Ledger scrutiny checks, the default limit and the reason for each
CHECK	DEFAULT LIMIT	WHY IT IS LOOKED AT
Cash payments above the limit	₹10,000	Section 40A(3): expenditure paid in cash above ₹10,000 to a person in a day is disallowed, subject to rule 6DD.
Cash receipts of ₹2 lakh or more	₹2,00,000	Section 269ST: no person shall receive ₹2,00,000 or more in cash from a person in a day, per transaction, or per event.
Days with negative cash balance	None	Cash cannot be negative. It points to unrecorded receipts or back-dated payments.
Possible duplicate vouchers	None	Same date, type, ledgers and amount recorded more than once.
Large journals in the last days of the year	₹50,000	Year-end adjustments deserve a look at the supporting papers.
Large round-figure entries	₹50,000	Round sums in journals and payments often mark estimates, adjustments or related-party transfers.
Large entries without narration	₹50,000	No explanation on record for a material entry.
Entries dated on a Sunday	None	Unusual for most businesses. Often a sign of back-dating.
Gaps in voucher numbers	None	Missing numbers may be deleted vouchers.
Vouchers where debit and credit differ	None	The export may be incomplete, or the file has entries this reader does not recognise.

What the Day Book XML gives for each voucher

The register keeps these fields for every voucher. Cancelled and optional vouchers are skipped, and so are vouchers with no ledger entries.

Vouchers as read from the example Day Book XML
DATE	TYPE	NO	NARRATION	LEDGERS	TOTAL
12/08/2025	Payment	1	Repairs at the godown	Repairs and maintenance Dr, Cash Cr	₹35,000
20/08/2025	Receipt	1	Sale proceeds	Cash Dr, Gupta Traders Cr	₹2,50,000
07/09/2025	Payment	2	Office rent for August	Office rent Dr, Example Bank Cr	₹25,000
14/10/2025	Payment	3	Printing	Printing and stationery Dr, Example Bank Cr	₹18,000
14/10/2025	Payment	4	Printing	Printing and stationery Dr, Example Bank Cr	₹18,000
03/11/2025	Payment	7	Telephone	Telephone expenses Dr, Example Bank Cr	₹5,000
28/03/2026	Journal	1	-	Consultancy charges Dr, Provision for expenses Cr	₹5,00,000

STEP BY STEP

How it works

In Tally open Display → Day Book, set the full year with Alt+F2, then Export with Alt+E and choose XML.
Drop the file here. Confirm which ledgers are cash and enter the opening cash balance.
Open each check to see the vouchers, then download the audit pack: findings with a remark column, ledger summary and the full voucher register.

GOOD TO KNOW

Common questions

Which checks does it run?: Cash payments above ₹10,000 to one party in a day (section 40A(3)), cash receipts of ₹2 lakh or more (section 269ST), days with negative cash, possible duplicate vouchers, large year-end journals, large round figures, material entries without narration, Sunday entries and gaps in voucher numbers.
Does it need Tally to be open or any add-on installed?: No. It only reads the exported file, in your browser. Nothing is installed and nothing is uploaded.
Does it decide that something is disallowed?: No. Every point is a prompt for the auditor. Rule 6DD exceptions and genuine business reasons are yours to judge.