Move beyond manual auditing
to autonomous reconciliation

IQ4U8 helps finance teams and auditors do their best work: turn raw accounting ledgers into balanced statutory statements, auto-detect transposition errors with Rule-of-9, and audit side-by-side with 100% in-browser air-gapped privacy.

Local • DevBox1 • IQ4U8 Engine

36K — Search ledger entries, rules, vouchers...

⚡ Reconcile Core ✓ 100% In-Browser

Sessions + New

Search sessions...

IN REVIEW

3 default 03:28 PM

Q3 Commercial BRS Audit

● Reconciled 128 / 128 rows

default 01:14 PM

Tech Corp vs HDFC Bank

● 0–10d Delay 48 matches

LOADED DATA SOURCES

📗 CashBook_Sept.xlsx ✓

🏛️ HDFC_Passbook.csv ✓

📊 Dual-Ledger Alignment

⚖️ Rule-of-9 Checker

🛡️ Statutory BRS Schedule

COMPANY CASH BOOK (INTERNAL)

STATUS & ALIGNMENT

BANK STATEMENT (PASSBOOK FEED)

INV-9042 Client Receipts (Apex Global) +₹85,000.00

MATCHED ✓

NEFT-CR Direct Client Deposit +₹85,000.00

CHQ-1049 Office Rent (DLF Cybercity) -₹12,400.00

IN TRANSIT ⏳

— Unpresented Cheque (within 10d tolerance) Awaiting Bank

— Passbook Direct Debit (Unentered in Cash Book) Auto-Classified

BANK CHG 🏦

SMS-CHG Quarterly SMS & Ledger Fee -₹17.70

VOUCH-88 Advisory Retainer Fee +₹45,000.00

MATCHED ✓

RTGS-CR Client Retainer Clearing +₹45,000.00

CHQ-1050 Hardware Vendor Settlement -₹28,500.00

MATCHED ✓

CMS-DR Vendor Clearing (HP India) -₹28,500.00

🛡️

Statutory Bank Reconciliation Statement (BRS) — Audit Certified

Cash Book: ₹89,100.00 + Unpresented Cheques: ₹12,400.00 - Bank Charges: ₹17.70 = Passbook: ₹1,01,482.30

AUDIT VARIANCE ₹0.00 ✓ Settled

COMPATIBLE WITH ALL CORE BANKING NETWORKS & ACCOUNTING SOFTWARE

Microsoft Excel

TallyPrime

HDFC Bank

State Bank (SBI)

ICICI Bank

Axis Bank

Kotak Bank

Support & Documentation

Need assistance with Indian banking formats, reconciliation rules, or ERP integration? Reach out through our official support channel.

✉️

EMAIL ID priyanshupandey8301@gmail.com

Email Me ↗

✈️

TELEGRAM USERNAME @iq4u8

Chat @iq4u8 ↗

⭐

OPEN SOURCE REPOSITORY github.com/iq4u8

Visit GitHub ↗

Engineering & CA Capabilities

🇮🇳

Indian Banking Formats Multi-Bank Normalization

Automatic regex & column detection for HDFC, SBI, ICICI, Axis, PNB, Bank of Baroda, Kotak, and Canara Bank statements. Supports credit/debit inversion, unified narration, and reference extraction.

⚖️

Rule-of-9 Diagnostic Automated Transposition Audit

Mathematical transposition verification: whenever ledger variance divides by 9, algorithmic pattern matching inspects transposed digits (e.g. ₹270 vs ₹450) and flags them for rapid auditor review.

📑

ICAI Statutory BRS Auditor-Ready Print & PDF

Generates formal Bank Reconciliation Statement starting from Cash Book closing balance, adding cheques issued not presented, and deducting uncredited deposits to precisely balance Passbook.

🔒

Air-Gapped Execution 100% In-Browser Privacy

No server ingestion, no cloud databases, zero telemetric logging. All ledger parsing and matching occurs strictly in local browser JavaScript memory.

Frequently Asked Questions

📁 Supported Ingestion File Formats

Directly accepts Excel (.xlsx, .xls), CSV, TSV, and plain text files. Multi-sheet Excel files automatically process the primary ledger sheet.

⏱️ Configurable Clearing Tolerance

Adjust the date window slider (0 to 10 days) to match uncleared cheques deposited or issued across weekends and statutory banking holidays.

📋 Copy-Paste Raw Ledgers

Use 'Paste Data' inside the Dashboard to paste rows directly from Microsoft Excel or Google Sheets without saving to a disk file.

🏢 Corporate ERP Integration

Compatible with TallyPrime, SAP, Zoho Books, and QuickBooks ledger dumps without requiring pre-formatting or column restructuring.

Source Code & 100% Private Offline Run

Air-gapped execution for total financial privacy

All calculations, parsing, and ledger alignments execute strictly in your local browser sandbox. Zero data leaves your computer. If your company policy prohibits uploading ledgers to the cloud, you can run this entire application locally on your workstation:

bash / powershell workstation setup

● ZERO-DEPENDENCY

1. Download or clone this project repository

git clone https://github.com/iq4u8/smart-recon.git

2. Run any zero-dependency local HTTP server (e.g., python -m http.server 3088)

python -m http.server 3088

3. Open http://localhost:3088 — 100% offline & zero cloud transmission.

http://localhost:3088

Alternative Local Web Servers (No Python Required)

NODE / NPX

npx serve . -p 3088

PHP BUILT-IN

php -S localhost:3088

🔒

Zero Cloud Telemetry No Server Ingestion

No remote analytics, no tracking cookies, no server database. All transaction matching computes in your browser's private V8 memory.

⚡

Zero Network Latency Instant Local RAM Engine

Process 10,000+ ledger rows in milliseconds. Works completely offline even with network disconnected or in secure air-gapped auditor rooms.

💡 Upload your Cash Book & Bank Statement (Excel or CSV), or click 'Paste Data' to begin.

Excel (.xlsx, .xls) · CSV · TSV · TXT

Cash Book Balance

₹0.00

Company Closing Balance

Bank Statement Balance

₹0.00

Passbook Closing Balance

BRS Variance

₹0.00

Settled & Balanced ✓

Reconciled Rate

Automatic Match Engine

Company Cash Book

Upload Excel (.xlsx, .xls), CSV, or Tally export (.txt)

Click or drag Cash Book file

Bank Statement

Upload bank passbook Excel (.xlsx, .xls) or CSV

Click or drag Bank Statement file

Comparative Reconciliation Ledger (Side-by-Side Matched Alignment)

0 rows

Status	Book Date	Book Ref	Cash Book Particulars	Book Amt	⇄	Bank Amt	Bank Statement Narration	Bank Date	Audit Notes

Move beyond manual auditing to autonomous reconciliation

Support & Documentation

Engineering & CA Capabilities

Frequently Asked Questions

Source Code & 100% Private Offline Run

Alternative Local Web Servers (No Python Required)

Apex Cloud Technologies Pvt Ltd

Company Cash Book

Bank Statement

Move beyond manual auditing
to autonomous reconciliation