by CA Umang Mehta · @mehtaknowstech

Practical tools for Chartered Accountants

Free, offline and private. Built inside a working CA practice to save hours on the everyday document work of audits, filings and client files.

No sign-upNothing uploadedWorks offlineOpen source
Tool 01 · HTML

PDF Suite

Fifteen PDF tools in a single file. Every page is processed inside your browser, so client documents never leave your computer.

  • Merge with annexure dividers
  • Split, extract and reorder pages
  • AES-256 password protection
  • Redact PAN, Aadhaar and GSTIN
  • Compress for e-mail and portals
  • Bates and section page numbers
  • Watermarks, stamps and signatures
  • PDF ↔ images, PDF → Word
Open PDF Suite → Download for offline use
PDF Suite merging three financial statements into one file
Auto-detecting PAN, GSTIN and mobile numbers for redaction
Auto-detect and permanently redact Indian identifiers
Visual page organiser with thumbnails
Drag-and-drop page organiser
Batch AES-256 password protection
Batch AES-256 protection before e-mailing clients
Tool 02 · Excel VBA

Encrypt / Decrypt Data

Select cells, run one macro, and client names, PANs and other text turn into unreadable symbols. Run the second macro to bring them back.

  • Masks every letter in the selection
  • Restores the text exactly
  • Leaves numbers and dates alone
  • Formulas are never touched
  • Works on any selection or sheet
  • Plain .bas file, easy to review

Masking hides text from casual view, for example in screenshots or demo files. It is not password security: anyone with this macro can reverse it.

Download macro (.bas) → Install guide
Client list before and after running Encrypt_Data: letters become Greek symbols, numbers and totals stay the same
Tool 03 · HTML

Ledger Lens

Bank statement PDFs to Excel or CSV, without uploading them anywhere. Every row is checked against the running balance, so you know the output is right before you use it.

  • Reads columns, not guesswork
  • ✓ / ⚠ balance check on every row
  • Opens password-protected PDFs
  • Dr/Cr, overdraft and newest-first layouts
  • Excel ledger with live balance formulas
  • Search, filter, de-duplicate, edit
Open Ledger Lens → Download for offline use
Ledger Lens: a sample bank statement converted, with every row ticked by the balance check
A mis-keyed amount flagged by the balance check
A wrong amount is flagged straight away
Upload screen with a built-in sample statement
Try it with the built-in sample statement
Ledger Lens in dark mode
Dark mode
Coming soon

More Excel macros

Automation for reconciliations, ledgers and reporting, with step-by-step install guides.

Coming soon

More HTML tools

Single-file utilities you can open from your desktop, with no installs and no IT tickets.

Connect

Questions, ideas, or a statement that won't convert?

All my links in one place: Instagram, LinkedIn and email. Scan the code or tap the button.

allmylinks.com/imumehta → umang.mehta@mail.ca.in
QR code card for Umang Mehta, allmylinks.com/imumehta

Private by design

No servers, no tracking and no uploads. Safe for confidential client data.

Zero setup

One HTML file or one macro. No installs, no accounts, and it works without internet.

Made by a practitioner

Each tool solves a real problem from a CA practice in Jamnagar, Gujarat.