Launch offer — 50% off · ₹25,000 ₹12,500/yr · free demo on your own books
Powerful · Accurate · Insightful

Audit reports,
straight from Tally.

A TDL add-on plus an Excel ribbon toolkit for chartered accountants — reads your books directly, flags what needs a second look, and exports everything in one pass. No re-typing figures into a spreadsheet.

Schedule a demo See what's inside Watch the videos
17+reports in Tally
18risk-detection rules
21Excel ribbon tools
5 minto install
Gateway of Tally
Gateway of Tally ● live session
MASTERS
Create
Alter
CHart of Accounts
TRANSACTIONS
Vouchers
Day BooK
REPORTS
Balance Sheet
Profit & Loss A/c
Stock Summary
Ratio Analysis
Display More Reports
DashbOard
Quit
X TaX Audit 5 Pct Cash Test
TALLY SCRUTINY BY KTS & CO.
Press U from Gateway to open · this is our actual product entry, not a mock-up
100% free · no catch

Tax Audit 5% Cash Test

Checks Sec 44AB tax audit applicability straight from your Tally books — bank and cash receipts/payments, the 5% cash ratio test, the ₹10 Cr turnover rule, and Net Profit %, in one report.

  • Runs inside TallyPrime — no Excel needed
  • Auto or manual Bank/Cash ledger selection (F5)
  • ₹10 Cr turnover rule and Net Profit % built in
  • Completely free — always will be
TAX AUDIT — 5% CASH TEST
Cash Receipts / Total Receipts0.04%
Cash Payments / Total Payments0.27%
Net Turnover₹5,72,94,341
NOT APPLICABLE
Free download

Get the 5% Cash Test TDL

Enter your details and the download starts immediately.

Used only to send you updates on new free tools. Unsubscribe anytime.
Inside the Gateway of Tally menu

Every report, grouped the way you'll actually find it

This isn't a marketing diagram — it's the real sub-menu structure. Four sub-menus hang off the main Tally Scrutiny screen; everything else sits at the top level.

Gateway of Tally
TALLY SCRUTINY BY KTS & CO.
Creditor / Debtor Queries
Creditor Queries
Debtor Queries
Top 10 Debtors and Creditors
High Risk Ledger Analysis
Quit
Gateway of Tally
TALLY SCRUTINY BY KTS & CO.
Loans Taken Repayment Reporting 3CD
PArt A - Sec 269SS (Loans Accepted)
Part B - Sec 269T (Repayments)
Part C - Sec 269ST (Cash Receipts)
Quit
Gateway of Tally
TALLY SCRUTINY BY KTS & CO.
Analytical Reports
Month WisE Expenses Report
Monthly Sales and Receipt
Party-wise Sales & Collection
GST Compliance - Sales/Purchase
Quit
Gateway of Tally
TALLY SCRUTINY BY KTS & CO.
Inventory Reports
Item-wiSe Sales Min/Max Rate
Item-wise In-Out Breakup
StOck Movement Report
Quit
Also at the top level
Gateway of Tally
TALLY SCRUTINY BY KTS & CO.
Top-Level Reports
All Voucher EntriesEvery voucher with column search
Trial BalanceWith PAN, GSTIN & contact columns
Bank and LoansBook vs statement reconciliation
Write Off ReportCandidates within a set tolerance
Cash QueriesSec 40A(3) & 269ST violations
Cash NegativeEvery date the balance went negative
Clause 44 — GST Exp BreakupExpense split for the 3CD clause
DePreciation Chart (IT)Per IT Act, 1st / 2nd half split
Audit Query ReportPending / resolved UDF tracking
Partner Remuneration Calcu/s 40(b) with 194T TDS
MSME Reports ›43B(h) outstanding & status
Export All to Excel ›Every report as .xlsx in one pass
About / UtilityVersion, licence & settings
Quit
Thirteen more reports sit directly on the main menu — one keystroke each, no digging through sub-menus

High Risk Ledger Analysis — 18 rules

The flagship report. Applies pattern rules across four ledger groups to surface loan routing and cash cycling that's easy to miss scrolling through vouchers by hand.

RulesLedger groupPattern flagged
HR-01–03Sundry CreditorsPayment-only, receipt-only, or payment+receipt with zero business activity
HR-04–06Sundry DebtorsReceipt-only, payment-only, or payment+receipt with zero business activity
HR-07–09Loans & Advances (Asset)Disbursed or recovered without a matching journal entry
HR-10–12Unsecured / Secured LoansBorrowed or repaid with no supporting documentation — Sec 269SS risk

Auto-excluded: GST · TDS · TCS · VAT · Income Tax · Insurance · Salary · Wages · Round Off · Discount · Depreciation — so routine ledgers don't clutter the list. Filter by rule with F5.

For when the data's already left Tally

Advanced reports in Excel

Twenty-one report tools, grouped across one ribbon tab exactly as they appear in Excel. Clean a raw Tally export, tie your opening balances, reconcile 26AS, age MSME creditors — each report runs on its own, without leaving the spreadsheet.

KTS_TALLY_UTILITIES.xlam
File
Home
Insert
Tally Utilities
Review
View
Clean Tally Data
Trial Balance
NEW
Prev Year TB
NEW
Opening Bal Reco
Data Preparation
TDS Ledger Scrutiny
26AS
26AS RECO
TDS
MSME Outstanding
Debtors Ageing
NEW
Fixed Asset Addition
Outstanding & Assets
Expense Analysis
Sales Analysis
Sales Party Analysis
Purchase Analysis
Purchase Party Analysis
Audit Sampling
NEW
Ledger Scrutiny
Analysis
Variance Analysis
NEW
PL Variance (YoY)
Ratio Analysis
Year on Year
NEW
INDEX
License Info
Activate
Settings
NEW marks the six tools added in the latest build — every other button has been there since launch.

What the six new tools do

Prior year chain 3 tools
  • Prev Year TB — cleans last year's Trial Balance into the same shape as this year's, so the two can be compared. Run it before the other two.
  • Opening Bal Reco — matches opening balances against last year's closing figures and lists every ledger that doesn't tie.
  • PL Variance (YoY) — current year's P&L against prior year, head by head, with absolute and percentage movement.
Scrutiny & assets 2 tools
  • Ledger Scrutiny — scans ledgers for anomaly entries against a query library you can edit, disable or extend with your own conditions.
  • Fixed Asset Addition — every addition in the year with date, voucher, party and amount, split at the half-year mark for the depreciation working.
Workbook 1 tool
  • INDEX — builds a hyperlinked contents sheet at the front of the workbook listing every report generated. Run it last, once everything else is in the file.
  • Where it helps — a bulk export can leave twenty-plus sheets in one file; the index turns hunting through tabs into a single click.

Every button above matches what's in the add-in today — this is the actual ribbon, not a mock-up.

Setup · about 5 minutes

Installation, start to finish

Three separate installs, none of which depend on each other. Load the file into Tally, add the ribbon to Excel, and set the export configuration once per machine. Every step below has a video alongside it.

Loading the file into TallyPrime

Works the same for a .tdl or a compiled .tcp. Five minutes, and the menu appears at Gateway of Tally.

  1. Save the file somewhere permanentPut it in a folder you won't move or rename — C:\TallyScrutiny\ works well. Tally reads this path every time it starts, so a moved file means a missing menu.
  2. Open the TDL screenFrom Gateway of Tally press F1 (Help), then choose TDL & Add-On.
  3. Manage local TDLsPress F4 for Manage Local TDLs, then set Load TDL files on startup to Yes.
  4. Point Tally at the fileUnder List of TDL Files to Preload, type the full path to the file you saved in step 1, including the extension. Accept to save.
    Red syntax error? The file was almost certainly copied incompletely, or the path has a typo. Re-copy the whole file and check the path character by character.
  5. ReloadRestart TallyPrime, or press Ctrl+Alt+R to reload TDLs without closing the company.
  6. Check it loadedBack at Gateway of Tally you'll see TALLY SCRUTINY BY KTS & CO. at the bottom of the menu. Press U to open it.
    Licence key: we send yours over WhatsApp after the demo — enter it and run your first report in the same session.
Watch this section
Master data some reports expect
  • MSME reportsBill-wise Details set to Yes on creditor ledgers
  • Depreciation ChartDepRate field assigned on fixed asset ledgers
  • Cash QueriesParty ledger filled on payment and receipt vouchers
  • 3CD Clause 31Loan ledgers under the group you intend to select

Adding the ribbon to Excel

The add-in is a macro file, so Windows and Excel will both try to block it the first time. These two steps get past that for good.

  1. Unblock the file firstRight-click the .xlam file, choose Properties, and if there's an Unblock tick box at the bottom, tick it and click OK.
    Don't skip this. Without it Windows silently disables every macro in the add-in — the ribbon appears but no button does anything.
  2. Open add-in settingsIn Excel go to File → Options → Add-ins. At the bottom set Manage: Excel Add-ins and click Go…
  3. Browse and enableClick Browse, select the .xlam, click OK, then tick its box in the list and OK again.
  4. Allow the macrosIf a yellow security bar appears at the top of the sheet, click Enable Content. Every tool on the ribbon runs on VBA.
    Permanent fix: File → Options → Trust Center → Trust Center Settings → Trusted Locations, then add the folder the add-in sits in. You'll never see the prompt again.
  5. Find the tabA Tally Utilities tab appears on the ribbon, with all twenty-one report tools grouped across it.
  6. ActivateClick Activate and enter the licence key we send you. License Info shows status any time.
Watch this section
Before the tools will read your data
  • Voucher dataPaste at cell A1 of a sheet, then click Clean Tally Data
  • Trial BalancePaste at A1 of a second blank sheet, then click Trial Balance
  • TDS ScrutinySelect the TDS Payable ledgers before running
  • 26AS RecoSelect TDS Receivable and Income ledgers together

Configuring bulk export

Tally can't export several reports in one go on its own. Export All to Excel works around it — but only once three settings are right. This is a one-time setup per machine.

  1. Open the export screenFrom Gateway of Tally press Alt+E, then open Configuration. These defaults apply to every report exported afterwards.
  2. Set a default export folderEvery report in a batch lands here. Use a dedicated empty folder per client per year — D:\Audit\Client\FY25-26\ — because one run can produce twenty-plus files.
  3. Turn "Open file after export" to NoLeave it on and Tally launches Excel after every single report. Twenty reports means twenty windows fighting for focus, and the batch stalls partway.
    This is the one people miss. It's the single most common reason a bulk export dies halfway through.
  4. Turn "Update in existing file" to YesThis lets Tally write into the existing file rather than erroring or spawning clashing duplicates, so repeat runs behave predictably.
  5. Accept and saveConfirm so the configuration persists. Steps 1–5 are needed only once on each machine.
  6. Run the batchOpen Export All to Excel, tick the reports you want before any data loads, and let it run unattended. Then open each file and click Clean Tally Data.
Watch this section
Settings at a glance
  • Default export folderOne dedicated folder per client, per year
  • Open file after exportNo
  • Update in existing fileYes
Menu not appearing? Reload with Ctrl+Alt+R Ribbon buttons dead? The file wasn't unblocked Export opening Excel each time? Setting 3 above Still stuck? WhatsApp us →
Free download · offline guide

Android App Development Setup Guide

A click-by-click guide to setting up a Windows 11 PC for Android app development with Flutter and Firebase. It's one HTML file: download it, double-click it, and it opens in any browser, even without internet.

  • Seven steps, from Developer Mode to a live Firebase project
  • Copy button on every PowerShell command
  • Drawn screens for the tricky PATH step
  • "You should see" and "if it goes wrong" boxes
  • Tick-off progress tracker
  • Light and dark mode, works on a phone
Download guide (.html) ↓ Open in browser
Single HTML file · about 60 KB · Windows 11 · Flutter + Firebase · by CA Tirth Shah
Watch it done

Video guides

Every walkthrough we've recorded — installation, bulk export configuration, and the new Ledger Scrutiny. Pick one from the list and it plays right here.

Playlist
▶

All videos on YouTube

Every guide above, plus anything published since — new features are demonstrated on the channel first.

Open the channel →
Why practices switch

Five reasons it sticks after the demo

Per Tally serial number · 1 year

One price. Everything included.

Currently half price — ₹25,000 down to ₹12,500 for the year. Book a free demo first and we'll walk you through every report on a live company before you pay a rupee.

Tally Scrutiny — full toolkit
₹25,00050% off
₹12,500/ year
TDL engine + Excel add-in, one licence, per Tally serial number — you save ₹12,500
Get started — ₹12,500/yr Schedule a demo
  • 17+ reports inside Tally, no Excel needed
  • High Risk Ledger Analysis, 18 rules
  • 43B(h), Clause 31, Clause 44, GST flagging
  • 21 Excel ribbon tools — cleaning, TB, TDS, 26AS, YoY
  • MSME & debtor ageing on LIFO allocation
  • Audit sampling module
  • Batch export to Excel in one pass
  • Priority WhatsApp & email support, all updates for 12 months
Want to see it on your own books first? Schedule a free demo on WhatsApp
From practitioners using it

Built by a CA. Used by CAs.

"The High Risk Ledger report alone saved me hours on a complex partnership audit — it surfaced loan routing I'd have missed reviewing vouchers manually."

CA Stuti Shah
MAAK & Associates

"43B(h) compliance used to take half a day. Now it runs inside Tally in seconds, and the batch export is something I didn't know I needed."

CA Vishwa Shah
A J Jain & Co.

"The demo convinced me. The Excel add-in's TDS checking catches misclassifications I'd otherwise only find during scrutiny."

CA Prasiddh Mangarolia
B.H. Mangarolia & Co.
Trusted by leading firms

Firms using our audit tool

MAAK & Associates, Chartered Accountants
B. H. Mangarolia & Co., Chartered Accountants
Bansi S. Mehta & Co.
Rajni Shah & Associates, Chartered Accountants
Sweta Patel & Associates, Chartered Accountants
D. R. Thakkar & Co., Chartered Accountants
VSSB & Associates, Chartered Accountants
Kaushal Shah & Associates, Chartered Accountant
Ambalal Patel & Co LLP, Chartered Accountants
Hover to pause
Start today

Book a demo, install in 5 minutes

Message us on WhatsApp and we'll set up a time. We run through the reports on a live company, answer your questions, and get you installed in the same session.

Schedule a demo on WhatsApp Email us