🗺️ How to Use — 4 Steps
1
Upload Bank Statement
Upload your Bank Excel file. All column headers will auto-load into dropdowns.
2
Upload ERP Sheet
Upload ERP Excel file. UPI/Cheq column, Receipt column, Clearing Date column are auto-detected.
3
Check Column Config
Config panel opens automatically. Verify dropdowns. If column order changed, select the correct one.
4
Match & Download
Click Match button → Preview results → Download all 3 files: Bank, ERP, Tally Sheet.
🏦 Bank Statement — Column Guide
| Col | Header | Role |
|---|
| B | Transaction Date | → Fills ERP Cheq.Clr.Dt. |
| D | Transaction Remarks | UPI / CHQ match source |
| F | Deposit Amt (INR) | Tally Sheet → Ledger Amount |
| L | Tally Narration | ← OUTPUT filled here |
⚠️ If column order is different in your file — use the Config dropdowns to select correct column.
📊 ERP Sheet — Column Guide
| Col | Header | Role |
|---|
| H | Cheq / UPI No. | Match key — compared with bank |
| I | Cheq. Clr. Dt. | ← Bank date fills this column |
| J | Online Cmp. Dt. | Online payment date |
| K | Receipt No. | → Used in narration: Recpt No. |
📋 Output Narration Format (Col L)
UPIUPI/121253998094/UPI/name/HDFC BANK...→UPI - 121253998094 Recpt No. 499
CHQ/TRFTRF/NAME/017015/ICI/30.03.2026→CHQ NO : 017015 - ICI - 30.03.2026 Recpt No. 86
📄 Tally Import Sheet — Column Mapping
| Col | Header | Source |
|---|
| A | VCH No. | Blank |
| B | VCH Date | Bank → Transaction Date |
| C | Cr. Ledger Name | Class Prefix from ERP (e.g. 001_Primary_) |
| D | Dr. Ledger Name | Blank |
| E | Ledger Amt. | Bank → Deposit Amount |
| F | CR. | Cr. (Fixed) |
| G | DR. | Dr. (Fixed) |
| H | VCH Narration | Generated Narration |
🎨 Class-wise Row Colour (Only for School / Tuition)
🔵 STD 1 to 8
🟠 STD 9 to 10
🟢 STD 11–12 Science
🩷 STD 11–12 Commerce
Row background colour is applied automatically in ERP Sheet + Bank Statement downloads based on student class.
🔗 Sheet 1 × Sheet 2 Matcher
1
Upload 2 Sheets
Upload any two Excel files. They can be from any system.
2
Select Key Columns
Pick which column from each sheet to match on (e.g. UPI number, receipt, student ID).
3
Choose Output Columns
Check which columns from Sheet 1 and Sheet 2 you want in the output file.
4
Download
A new custom Excel sheet is generated with only your selected columns.
💳 Subscription Plans
| Plan | Price | Rows | Uses |
|---|
| Free Trial | Free | Max 100 rows | 3 times only |
| Monthly | ₹150/month | Unlimited | Unlimited |
| Yearly | ₹1500/year | Unlimited | Unlimited |
