Payment Reports

Overview

The Payments module tracks all payment transactions in Zal Ultra. It records payments from subscribers, balance topups for resellers, and provides comprehensive reporting for financial management.

---

Payment Methods

ID	Method	Description	Balance Change
1	Cash	Physical cash payment	Tracking only
2	Bank Transfer	Bank deposit/transfer	Tracking only
3	Cheque	Payment by cheque	Tracking only
4	Balance	Deduct from account balance	Yes
11	bKash	Mobile payment (Bangladesh)	Yes
12	Nagad	Mobile payment (Bangladesh)	Yes
13	SSLCommerz	Online gateway	Yes
14	Razorpay	Online gateway (India)	Yes
15	JazzCash	Mobile payment (Pakistan)	Yes
16	EasyPaisa	Mobile payment (Pakistan)	Yes

---

Payment Types

1. Subscriber Payments

Payments made by subscribers for services:

• Activation Payment - Payment during package activation
• Balance Topup - Adding balance to subscriber account
• Invoice Payment - Paying existing invoices

2. User/Reseller Payments

Payments involving resellers:

• Balance Topup - Admin adding balance to reseller
• Balance Transfer - Between reseller accounts

---

Payment Status

Status	ID	Description
Paid	1	Payment completed
Reverted	2	Payment reversed/refunded

---

How Payments Work

Subscriber Activation Payment

1. Subscriber Activation Request
   ↓
2. Calculate Total Amount
   ├── Package Price
   ├── Extra Fees
   └── Minus Discounts
   ↓
3. Payment Method Selected
   ├── Cash (1-3) → Track only, no balance change
   └── Balance/Online (4+) → Deduct from balance
   ↓
4. Payment Record Created
   ↓
5. Ledger Entry Created
   ↓
6. Cashflow Entry Created

Reseller Balance Topup

1. Admin Selects Reseller
   ↓
2. Enter Amount & Method
   ↓
3. Validate Balance Limits
   ↓
4. Payment Record Created
   ↓
5. Ledger Entry Created
   ├── Reseller: +Amount
   └── Admin: -Amount (if not admin)
   ↓
6. Cashflow Entry Created

---

Payment Reports

View all payment transactions in the system.

Report Columns

Column	Description
ID	Unique payment identifier
Payer	Who made the payment
Receiver	Who received the payment
Amount	Payment amount
Method	Payment method used
Status	Paid or Reverted
Date	Payment date/time
Action By	Staff who processed

---

Filter Options

Filter	Description
Search	Find by ID, username, or amount
Date Range	Filter by time period
Profile Type	Users or Subscribers
Select User/Subscriber	Specific account
Along With Subscribers	Include subscriber payments
Payment Method	Filter by method type
Action By	Who processed the payment

---

Export Options

Excel Export

1. Apply desired filters
2. Click Excel Export
3. Wait for file generation
4. Download .xlsx file

CSV Export

1. Apply desired filters
2. Click CSV Export
3. Wait for file generation
4. Download .csv file

---

Payment Receipt

View detailed payment information:

Receipt Information

Field	Description
Receipt ID	Unique receipt number
Payment Date	When payment was made
Payer Details	Name and account info
Amount	Payment amount
Method	How payment was made
Note	Additional information

---

Print Options

Standard Print

Full-size receipt for formal records.

Small Print

Compact receipt for quick reference.

---

Duplicate Payment Prevention

The system prevents duplicate payments:

• Time Interval Check - Same amount within 60 seconds is blocked
• Error Message - "Too Frequent Payments! Please Wait 1 Minute & Try Again."

---

Balance Limit Validation

Before processing payments:

1. Check Receiver Limit - Ensure balance limit not exceeded
2. Check Payer Balance - Ensure sufficient funds (for transfers)
3. Validate Amount - Negative amounts require notes

---

Online Payment Gateways

Supported Gateways

Gateway	Region	Features
bKash	Bangladesh	Mobile wallet
Nagad	Bangladesh	Mobile wallet
SSLCommerz	Bangladesh	Cards, Mobile
Razorpay	India	Cards, UPI, Wallets
JazzCash	Pakistan	Mobile wallet
EasyPaisa	Pakistan	Mobile wallet

Gateway Flow

1. Select Online Payment
   ↓
2. Redirect to Gateway
   ↓
3. Customer Completes Payment
   ↓
4. Gateway Callback
   ↓
5. Verify Transaction
   ↓
6. Create Payment Record
   ↓
7. Update Balance

---

Related Features

• Billing Overview - Understanding the billing system
• Invoice - Invoice management
• Ledger - Transaction history
• Cashflow - Income and expense tracking