Add Account
All Accounts
| Account No | Name | Bank | Txns | Notes | |
|---|---|---|---|---|---|
Statement File Format
PDF upload: Upload an Islami Bank MTDR PDF statement directly β no conversion needed.
CSV upload: Your statement CSV must have these column headers (exact names or variants):
| Required | Accepted column names | Example |
|---|---|---|
| Date | date, transaction_date, value_date, posting_date, txn_date | 28/04/2022 |
| Description | description, narration, particulars, details, remarks | MTDR Profit Credit 3M @5.25% |
| Profit/Credit | profit_amount, profit, credit, interest, amount | 9675.34 |
| Balance | balance, principal, closing_balance | 909675.34 |
Rate is auto-extracted from description (e.g. @5.25% or 5.25% p.a.) and term from keywords like 3M, 6 Month, 1 Year.
Upload Rate Sheet
π
Click or drag CSV / PDF here
Columns: term Β· starting_date Β· ending_date Β· rate
Required CSV columns:
term β 1M, 3M, 6M, 1Y, 2Y, 3Y, 100D, 200D, 300D
starting_date β 01/01/2023 or 2023-01-01
ending_date β 31/03/2023 or 2023-03-31
rate β 5.25 (percent, no % sign needed)
term β 1M, 3M, 6M, 1Y, 2Y, 3Y, 100D, 200D, 300D
starting_date β 01/01/2023 or 2023-01-01
ending_date β 31/03/2023 or 2023-03-31
rate β 5.25 (percent, no % sign needed)
Uploaded Rate Sheets
| Label | Uploaded | Entries | |
|---|---|---|---|
Rate Entries
| Term | Start Date | End Date | Rate % |
|---|
Upload Statement (CSV or PDF)
π
Click or drag CSV / PDF here
Bank statement as CSV or Islami Bank PDF
Each upload is stored separately. You can add new months/periods later without re-uploading old data. Duplicate entries are not automatically detected β upload new date ranges only.
Upload History
Select an account to see upload history.
Analysis Settings
How it works:
1. Detects renewal cycles from profit credit entries
2. Identifies the term (1M, 3M, 6M, 1Y, etc.)
3. Looks up the applicable rate from the rate sheet
4. Compares applied rate vs sheet rate
5. Calculates shortfall/surplus per cycle
6. Flags UNDERPAID cycles for bank dispute
1. Detects renewal cycles from profit credit entries
2. Identifies the term (1M, 3M, 6M, 1Y, etc.)
3. Looks up the applicable rate from the rate sheet
4. Compares applied rate vs sheet rate
5. Calculates shortfall/surplus per cycle
6. Flags UNDERPAID cycles for bank dispute
Analysis Tips
Rate Sheet: Upload the official rate sheet from your bank (or Bangladesh Bank circular). Each row covers one term for one date range.
Statements: Upload each account's statement as a CSV from your bank's internet banking portal. You can upload multiple periods β the engine merges all uploaded data per account.
Re-analysis: Running analysis again replaces previous results. Add new statement data first, then re-run.
Export: The results CSV can be used as evidence when disputing profit discrepancies with your bank.
| Renewal Date | Account | Principal | Bank's Applied Rate | Sheet Rate Prov / Final |
Bank Paid | Expected (৳) | Difference (৳) | Tax / Excise | Status |
|---|---|---|---|---|---|---|---|---|---|
π΄ Red = Underpaid
π΅ Blue = Overpaid
π© Green = OK
π Orange = Enhancement Owed
β« Grey = Partial/No Rate