Dashboard
Overview of your bank statement processing activity
Total Transactions
0
Upload a statement to begin
Auto-Matched
0
—
Pending Mapping
0
—
Saved Batches
0
Firestore synced
Recent Uploads
No statements uploaded yet.
Quick Actions
⬆
Upload New Statement
HDFC Bank Excel format
🗂
View Saved Batches
Re-export from saved data
⚡
Manage Rules
Auto-assign ledgers
⬇
Export Tally XML
Period-wise or all transactions
Upload Statement
Step 1 — Select bank · Step 2 — Upload Excel/XLS file
Step 1 — Select Your Bank
HDFC Bank selected
Loading banks…
Step 2 — Upload Excel File
Drag & drop your HDFC Bank statement
Accepts .xls and .xlsx files (HDFC Net Banking export)
—
—
✓ Statement parsed successfully
HDFC Bank — Expected Format
- Download from HDFC Net Banking → Account Statement → Excel
- Required columns: Date · Narration · Chq./Ref.No. · Value Dt · Withdrawal Amt. · Deposit Amt. · Closing Balance
- File format: .xls (old) or .xlsx (new)
- Duplicate transactions (same date+amount+narration) are detected automatically
Transactions
Upload a statement to view transactions
| Date | Narration | Bill Ref / UTR | Type | Amount (₹) | Balance (₹) | Ledger | Status | |
|---|---|---|---|---|---|---|---|---|
| No transactions loaded. Upload a statement first. | ||||||||
Rules Engine
Auto-assign ledgers · Rules saved to Supabase per company
Active Rules
+ Create New Rule
Rule Name
IF Narration Contains
THEN Assign Ledger
Ledger Manager
Ledgers saved to Supabase · Synced across team
Bill Payable & Receivable
Ledger-wise outstanding bills — track what you owe and what's owed to you
Total Payable (Open)
₹0
Bills you owe
Total Receivable (Open)
₹0
Bills owed to you
Net Position
₹0
Receivable − Payable
| Date | Ledger | Bill Ref | Type | Amount (₹) | Status | Notes | Actions |
|---|---|---|---|---|---|---|---|
| Go to Bill Statements to load. | |||||||
All Bills — Admin View
Bill entries across all companies
Saved Batches
Statements with ledger mappings saved to Supabase — re-export anytime
Export Tally XML
Generate XML for Tally Prime / ERP 9 import
Export Source
Export From
📅 Period Filter (Optional)
FROM date (DD/MM/YY)
TO date (DD/MM/YY)
Leave blank to export all transactions
Export Configuration
Company Name
Voucher Type
Bank Ledger
Transactions to Export
Settings
Configure app preferences
Auto-Processing
Apply rules on upload
Auto-run rules when statement is parsed
Auto-extract UTR as Bill Reference
Extract UTR/transaction numbers from narration
Check duplicates on upload
Flag transactions already saved in Supabase
Supabase Database
Company ID:
User Role: —
Data path:
—User Role: —
Data path:
companies/{companyId}/ledgers, rules, batches
Tally Export Defaults
Default Voucher Type
Companies Admin
Create and manage companies — stored in Supabase
Bank Manager Admin
Add banks, upload sample file, map columns — users see active banks instantly
Team Members Admin
Create Supabase Auth accounts for team members
| # | Name | Company | Role | Created | Actions |
|---|