---

# 📊 Transaction & Merchant Monitoring Reports  
**Version 1.54 – Batch Processing**

---

## 🔎 Filters
Before generating reports, apply filters such as:
- **Date Range** (Daily, Weekly, Monthly, Custom)
- **Merchant ID / Name**
- **Issuer BIN**
- **PAN (Card Number)**
- **Transaction Type** (Sale, Refund, Chargeback, Authorisation)
- **Channel** (POS, E‑commerce, Keyed Entry)

---

## 📑 Reports

### 1. Gross Daily Sales Volume
- **Description:** Total value of all sales processed in a day.  
- **Format:** Table
```markdown
| Date       | Merchant ID | Gross Sales Volume |
|------------|-------------|--------------------|
| 2026-08-23 | M12345      | ₹12,45,000         |
| 2026-08-24 | M67890      | ₹9,80,000          |
```

---

### 2. Average Daily Deposit Volume
- **Description:** Mean value of deposits made per day.  
- **Format:** Chart (Bar)
```markdown
Date Range: Aug 2026
Deposits (₹ in Lakhs)

| Date       | Avg Deposit Volume |
|------------|--------------------|
| 2026-08-20 | ₹8.75              |
| 2026-08-21 | ₹9.10              |
```

---

### 3. Average Ticket Size
- **Description:** Average value per transaction.  
- **Format:** Table
```markdown
| Date       | Transactions | Total Value | Avg Ticket Size |
|------------|--------------|-------------|-----------------|
| 2026-08-23 | 1,250        | ₹12,45,000  | ₹996            |
```

---

### 4. Average Number of Transactions per batch
- **Description:** Number of transactions grouped in each  batch.  
- **Format:** Table
```markdown
|  Batch | Transactions | Avg per batch |
|---------------|--------------|-----------------|
| Batch #101    | 250          | 250             |
```

---

### 5. Average Frequency of batch
- **Description:** How often batch occur daily.  
- **Format:** Chart (Line)
```markdown
Deposits per Day: 3
Average Frequency: Every 8 hours
```

---

### 6. Transactions in One Day with the Same PAN
- **Description:** Count of transactions linked to the same card PAN in a day.  
- **Format:** Table
```markdown
| PAN (Masked) | Date       | Transactions |
|--------------|------------|--------------|
| XXXX-XXXX-1234 | 2026-08-23 | 12           |
```

---

### 7. Time Between Transaction and Settlement Date
- **Description:** Lag between transaction date and settlement.  
- **Format:** Table
```markdown
| Txn ID | Txn Date   | Settlement Date | Lag (Days) |
|--------|------------|-----------------|------------|
| T12345 | 2026-08-20 | 2026-08-22      | 2          |
```

---

### 8. Individual Transaction Value
- **Description:** Value of each transaction.  
- **Format:** Table
```markdown
| Txn ID | Merchant ID | Value   |
|--------|-------------|---------|
| T12345 | M12345      | ₹1,250  |
```

---

### 9. Number and Value of Key-Entered Transactions
- **Description:** Transactions manually keyed instead of swiped/inserted.  
- **Format:** Table
```markdown
| Date       | Count | Total Value |
|------------|-------|-------------|
| 2026-08-23 | 15    | ₹45,000     |
```

---

### 10. Transactions Below Floor Limit
- **Description:** Transactions processed below the merchant’s floor limit.  
- **Format:** Table
```markdown
| Txn ID | Value | Floor Limit | Status |
|--------|-------|-------------|--------|
| T56789 | ₹450  | ₹500        | Below  |
```

---

### 11. Transaction on Same Issuer BIN
- **Description:** Transactions grouped by issuer BIN.  
- **Format:** Chart (Pie)
```markdown
Issuer BIN Distribution:
- BIN 123456 → 45%
- BIN 654321 → 30%
- Others → 25%
```

---

### 12. Total Number and Value of Credit Refunds Deposited
- **Description:** Refund transactions processed.  
- **Format:** Table
```markdown
| Date       | Refund Count | Refund Value |
|------------|--------------|--------------|
| 2026-08-23 | 12           | ₹1,20,000    |
```

---

### 13. Inactive Merchant Transactions
- **Description:** Transactions from merchants marked inactive.  
- **Format:** Table
```markdown
| Merchant ID | Status   | Txn Count | Value   |
|-------------|----------|-----------|---------|
| M99999      | Inactive | 5         | ₹25,000 |
```

---

### 14. Terminated Merchant Transactions
- **Description:** Transactions attempted by terminated merchants.  
- **Format:** Table
```markdown
| Merchant ID | Status     | Txn Count | Value   |
|-------------|------------|-----------|---------|
| M88888      | Terminated | 2         | ₹10,000 |
```

---

### 15. Retrieval Requests & Chargebacks
- **Description:** Number and value of retrieval requests and chargebacks.  
- **Format:** Table
```markdown
| Month | Retrieval Requests | Chargebacks | Value   |
|-------|--------------------|-------------|---------|
| Aug   | 25                 | 10          | ₹1,50,000 |
```

---

### 16. Authorisation Requests
- **Description:** Value and count of authorisation requests.  
- **Format:** Table
```markdown
| Date       | Auth Count | Total Value | Avg Value |
|------------|------------|-------------|-----------|
| 2026-08-23 | 320        | ₹32,00,000  | ₹10,000   |
```

---

### 17. Keyed Authorisations
- **Description:** Authorisations manually keyed.  
- **Format:** Table
```markdown
| Date       | Count | Value   |
|------------|-------|---------|
| 2026-08-23 | 8     | ₹80,000 |
```

---

### 18. Repeat Authorisations with Same Amount or PAN
- **Description:** Duplicate authorisation attempts.  
- **Format:** Table
```markdown
| PAN (Masked) | Amount | Repeat Count |
|--------------|--------|--------------|
| XXXX-XXXX-1234 | ₹5,000 | 3            |
```

---

### 19. Declined Authorisation Requests
- **Description:** Authorisation requests declined by issuer.  
- **Format:** Table
```markdown
| Date       | Declined Count | Declined Value |
|------------|----------------|----------------|
| 2026-08-23 | 25             | ₹2,50,000      |
```

--