SE Master Summary & Target Performance Report
Excel DMS 2025 Master Sheet Format: Territory (DH), Daily Ledger, Target, Payment Recovery & Payment% Color Coding
| Territory | Opening Due | Total Sales | PAYMENT | RETURN | SPECIAL DISCOUNT | Total Due | Payment% |
|---|---|---|---|---|---|---|---|
| DH (Dhaka / All) | ৳150,000.00 | ৳62,700.00 | ৳50,000.00 | ৳0.00 | ৳1,000.00 | ৳161,700.00 | 24% |
রেশিও ইনডিকেটর:
🟢 চমৎকার: (≥70%)
🟡 মধ্যম: (50%-69.99%)
🔴 কম: (<50%)
| SE CODE & NAME (ক্লিক করুন) | Daily Transactions (দৈনিক লেনদেন) | Target & Recovery (টার্গেট ও কালেকশন) | Monthly Summary (মাসিক খতিয়ান) | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Sales | Payment | Return | Discount | TARGET | PAYMENT | Achi % | Remaining | Sales | Total Due | Payment% | |
|
Md. Rahman
E0010
|
- | - | - | - | ৳0.00 | ৳50,000.00 | 0% | ৳0.00 | ৳62,700.00 | ৳56,700.00 | 46% |
|
Tanvir Islam
E0011
|
- | - | - | - | ৳0.00 | ৳0.00 | 0% | ৳0.00 | ৳0.00 | ৳85,000.00 | 0% |
|
Hasan Mahmud
E0012
|
- | - | - | - | ৳0.00 | ৳0.00 | 0% | ৳0.00 | ৳0.00 | ৳20,000.00 | 0% |
| SE Total (এস.ই মোট) | - | - | - | - | ৳0.00 | ৳50,000.00 | 0% | ৳0.00 | ৳62,700.00 | ৳161,700.00 | 24% |
| Mr. Enayet | - | - | ৳3,092,183.00 | - | |||||||
| Manager / Office | - | ৳90,213.00 | ৳203,165.00 | - | |||||||
Total Collection (সর্বমোট ক্যাশ কালেকশন):
৳50,000.00
Total Due (সর্বমোট বকেয়া পাওনা):
৳161,700.00