Free tool · Runs in your browser
Duplicate Invoice & GL Variance Analyzer
Drop in an AP ledger, GL dump or Tally export to flag duplicate invoices, the same invoice under two vendor names, round amounts, entries just below an approval limit, weekend postings, unusual amounts and month-on-month swings by account.
Your ledger stays on your computer
The file is read inside this browser tab and is never uploaded. The page is technically blocked from sending data anywhere. Refreshing or closing the tab clears it.
1. Ledger or ERP export
Excel or CSV with one row per entry. A vendor, document number, date and amount column give the best results; only the amount is required.
or drag and drop it here
2. What to check
Add a file to begin, or try the sample data.
Findings
Download Excel report| Finding | Severity | Count |
|---|
Detail
| Finding | Severity | Row | Party | Document | Date | Amount | Why |
|---|
Month-on-month variance (flagged)
| Account | Month | Previous | This month | Change | Change % |
|---|
First-digit (Benford) test
| First digit | Expected | Actual |
|---|
What each check means
- Exact duplicate: same party, document number and amount. Document numbers are compared ignoring spaces, punctuation and leading zeros; party names ignore Pvt, Ltd, LLP and similar.
- Possible duplicate: same party and amount within the chosen number of days but a different document number, a common sign of an invoice keyed twice.
- Same invoice, different party: one document number and amount booked against two vendor names, which can point to duplicate vendor masters.
- Just below approval limit, round amounts, weekend dates, negatives, unusual amounts: red flags used in audit sampling. They are prompts to look, not proof of error.
- Variance: monthly totals by account compared with the previous month, flagged when both the % and ₹ thresholds are crossed.
For review and computation assistance only; not a substitute for formal statutory audit or professional advice. Every flag needs human judgement.