Good morning, Admin 👋
Here's what's happening with BNET KADAMTALA today.
Total Clients
0
Active connections
This Month Revenue
৳0
Bill collections
Total Dues
৳0
Pending payments
Open Tickets
0
Support requests
Duplicate Clients
0
Click to review
ONU Devices
0
Network devices
Staff Members
0
Active employees
📊 Monthly Revenue vs Expense
🥧 Income Breakdown
⚡ Recent Activity
No recent activity
🔥 এই মাসে Unpaid Clients
No overdue clients
📒 Accounting
Daily income & expense tracking with full audit trail.
Total Income
৳0
Total Expense
৳0
Net Profit
৳0
Closing Cash
৳0
Total Loan
৳0
0 active
➕ Add Entry
📋 Transactions
| # | Date | Type | Category | Collector | Zone | Amount | Note | Actions |
|---|
🏦 Loan Management
মোট Loan নেওয়া
৳0
বাকি পরিশোধ
৳0
পরিশোধিত
৳0
Active Loans
0
| # | Loan Date | Collect From | Amount (৳) | Return Date | Paid (৳) | Remaining | Status | Note | Actions |
|---|
💳 Bill Collection
Manage monthly bill collection for all clients.
Total Records
0
Paid Amount
৳0
Unpaid Amount
৳0
Paid Clients
0
Unpaid Clients
0
This Month
৳0
➕ Add Bill Record
📋 Billing Records
| # | Date | Client | Conn ID | Package | Amount | Discount | Method | Status | Collector | Zone | Actions |
|---|
⚠️ Due Management
মাস অনুযায়ী Paid / Unpaid client summary এবং due tracking।
📅 Month:
Paid Clients
0
৳0 collected
Unpaid Clients
0
৳0 pending
Partial Paid
0
৳0 partial
Total Active Clients
0
0% collected
Total Receivable
৳0
Active clients × bill
Total Dues
৳0
Not yet paid
Collection Progress
0%
Paid: ৳0
Unpaid: ৳0
📋 Client Summary — এই মাস
| # | Client Name | Conn ID | Package | Monthly Bill | Paid Amount | Due Amount | Status | Payment Method | Collector | Actions |
|---|
📊 সব মাসের Summary
| Month | Total Clients | Paid | Unpaid | Partial | Collected (৳) | Dues (৳) | Collection % |
|---|
💸 Expense Management
Track all business expenses by category.
Total Expenses
৳0
This Month
৳0
Largest Category
—
Transactions
0
👤 Personal & Special Expense — এই মাস
📊 Category-wise Monthly Expense
➕ Add Expense
📊 By Category (Total)
📊 Monthly Trend
📋 Expense Records by Category
| # | Date | Category | Amount (৳) | Paid To / By | Method | Description | Actions |
|---|
0 records
👥 Client CRM
Manage all your ISP clients and their connection details.
Total Clients
0
Active
0
Disconnected
0
Suspended
0
⚠️ Duplicates
0
➕ Add Client
📸 Photos & Documents
👤
Client Photo
Client Photo
🪪
NID Front
NID — সামনের পাশ
🪪
NID Back
NID — পেছনের পাশ
📋 Client List
| # | Name | Conn ID | Phone | NID No | Package | Bill | Status | 📡 Live Status | Actions |
|---|
📦 Packages & Plans
BNET-এর সব internet package এখানে manage করুন। সব dropdown-এ automatically আসবে।
Total Packages
0
Cheapest Plan
—
Most Expensive
—
Total Subscribers
0
➕ Add New Package
📋 Package List
📌 Live Dropdown Preview (Billing & Client form-এ এটাই দেখায়)
| # | Package Name | Speed (Mbps) | Monthly Bill | Type | Subscribers | Description | Actions |
|---|
🤝 Resellers
Manage reseller partners, their clients, invoices and billing.
Total Resellers
0
Active Resellers
0
Total Reseller Clients
0
Total Monthly Revenue
৳0
➕ Add Reseller
📋 Reseller List
| # | Name | Phone | Zone | Commission | Total Clients | Monthly Revenue | Status | Actions |
|---|
🔌 Network Inventory
Track all network equipment — ONU, splitter, cable, routers.
Total Items
0
Active Devices
0
Faulty Devices
0
Total Value (৳)
৳0
➕ Add Equipment
📋 Network Inventory
| # | Type | Brand/Model | Serial/MAC | Qty | Price | Location | Client | Status | Date | Actions |
|---|
⚙️ MikroTik Live Sync
Router connect করে live PPPoE client sync করুন।
Total Routers
0
Connected
0
Active PPPoE
0
Total Secrets
0
Offline
0
📡 Connection Methods — কোনটা আপনার জন্য?
✅ Method 1 — Proxy (সবচেয়ে ভালো)
Step 1: Node.js install করুন (nodejs.org)
Step 2: ZIP থেকে
Step 3:
Step 4: নিচে Proxy Enable করুন ✅
RouterOS 6.x ও 7.x উভয়ে কাজ করে
Step 2: ZIP থেকে
proxy/bnet-proxy.js নিনStep 3:
node bnet-proxy.js চালানStep 4: নিচে Proxy Enable করুন ✅
RouterOS 6.x ও 7.x উভয়ে কাজ করে
⚡ Method 2 — Direct (RouterOS 7.x)
Router terminal:
ERP এবং Router same network-এ থাকতে হবে
CORS header আলাদা set করতে হবে না
/ip service set www address=0.0.0.0/0ERP এবং Router same network-এ থাকতে হবে
CORS header আলাদা set করতে হবে না
📥 Method 3 — RSC Import (Offline)
MikroTik Winbox/Terminal থেকে
তারপর Data Importer page-এ .rsc file upload করুন
Internet ছাড়াও কাজ করে
/export file=secretsতারপর Data Importer page-এ .rsc file upload করুন
Internet ছাড়াও কাজ করে
⚙️ Router Connection Settings
📡 Saved Routers
| # | Name | IP:Port | Model | Location | Last Sync | Secrets | Active | Status | Actions |
|---|
🔄 Live Client Sync
Router select করুন এবং Sync করুন
Router না থাকলে আগে উপরে Add করুন
🟢 Active PPPoE Sessions
| # | Name | IP Address | MAC (Caller) | Uptime | RX / TX | Service |
|---|---|---|---|---|---|---|
Sync করলে active sessions দেখাবে | ||||||
📡 Live Traffic Monitor
MikroTik Router-এর real-time PPPoE client traffic দেখুন।
Online Clients
0
Active PPPoE sessions
Total Download
0 Mbps
Current aggregate RX
Total Upload
0 Mbps
Current aggregate TX
Peak User
—
Highest bandwidth
Last Update
—
Not connected
📊 Bandwidth History (last 60s)
🏆 Top 5 Heavy Users
👥 Live PPPoE Sessions
| # | Client (PPPoE) | IP Address | ⬇ Download | ⬆ Upload | Total RX | Total TX | Uptime | MAC (Caller) | Signal |
|---|---|---|---|---|---|---|---|---|---|
|
Router select করে Monitor চালু করুন
Real-time PPPoE traffic দেখাবে
| |||||||||
🎫 Support Tickets
Track and resolve client support requests.
Total Tickets
0
Open
0
In Progress
0
Resolved
0
➕ New Ticket
📋 Ticket List
| # | Date | Client | Phone | Issue | Zone | Priority | Assigned | Status | Actions |
|---|
👤 Staff / HR Management
Manage all employees of BNET KADAMTALA.
Total Staff
0
Active
0
Total Monthly Salary
৳0
➕ Add Employee
📋 Employee List
| # | Name | ID | Role | Phone | Salary | Join Date | Status | Actions |
|---|
💰 Salary Management
Track monthly salary payments for all staff.
This Month Paid
৳0
Pending
৳0
Total Records
0
➕ Add Salary Record
📋 Salary Records
| # | Staff | Month | Basic | Bonus | Deduction | Net Pay | Method | Status | Actions |
|---|
📊 Reports & Analytics
Comprehensive business intelligence for BNET KADAMTALA.
📈 Monthly Income vs Expense
🥧 Revenue by Category
👥 Client Growth
💸 Expense Breakdown
📅 Monthly Summary Report
| Month | Income | Expense | Net Profit | New Clients | Bills Collected | Due Collected |
|---|
💚 Income Category Report
| Category | Transactions | Total Amount | % of Income |
|---|
🔴 Expense Breakdown Report
| Category | Transactions | Total Amount | % of Expense | Actions |
|---|
📒 Full Accounting Report
| # | Date | Type | Category | Collector | Zone | Amount | Note | Actions |
|---|
🔍 Audit Log
Full history of all data changes.
Change History
| Time | Module | Action | Details | By |
|---|
📥 Data Importer
আপনার existing XLSX ফাইল থেকে সরাসরি ERP-তে data import করুন।
📒 Accounting Import bnet_erp_XXXX-XX-XX.xlsx
📋 Expected columns: date, type, category, collector, zone, amount
SAMPLE FORMAT:
| date | type | category | collector | zone | amount |
|---|---|---|---|---|---|
| 2026-03-01 | income | Bill Collection | Rony | Kadamtala | 12000 |
| 2026-03-01 | expense | Mobile Bill | 3 NUMBER | — | 700 |
💳 Billing Import bnet-billing-XXXX-XX-XX.xlsx
📋 Expected columns: Date, Name, Bill, Status
SAMPLE FORMAT:
| Date | Name | Bill | Status |
|---|---|---|---|
| 01-03-2026 | Iqbal-684 | 500 | Paid |
| 01-03-2026 | Shahalalam-685 | 500 | Paid |
🔄 Universal Import — যেকোনো XLSX/CSV
⚙️ এই importer auto-detect করে কোন module-এ data যাবে — column name দেখে।
Multiple files select করা যাবে।
🔄 Universal Import — যেকোনো XLSX/CSV
⚙️ এই importer auto-detect করে কোন module-এ data যাবে — column name দেখে।
Multiple files select করা যাবে।
⚙️ MikroTik RSC — Client Import secret.rsc / ppp.rsc
📋 MikroTik RouterOS export থেকে PPPoE secret data import করুন।
Fields: name (Connection ID) · profile (Package) · caller-id (ONU MAC) · comment · disabled (status)
Fields: name (Connection ID) · profile (Package) · caller-id (ONU MAC) · comment · disabled (status)
RSC FORMAT EXAMPLE:
/ppp secret
add caller-id=40:AE:30:54:29:07 comment="Paid till 2026-04-08" name=monir5 password=1234 profile=15-MBPS-500TK service=pppoe
add caller-id=10:62:EB:9C:FF:97 name=Shimanto password=1234 profile=20-MBPS-700TK service=pppoe
add disabled=yes name=babu password=1234 profile=DISCONNECTED-USER service=pppoe
add caller-id=40:AE:30:54:29:07 comment="Paid till 2026-04-08" name=monir5 password=1234 profile=15-MBPS-500TK service=pppoe
add caller-id=10:62:EB:9C:FF:97 name=Shimanto password=1234 profile=20-MBPS-700TK service=pppoe
add disabled=yes name=babu password=1234 profile=DISCONNECTED-USER service=pppoe
👥 Client Import — XLSX/CSV
📋 Expected columns: Name · Phone · Conn ID · NID · Address · Package · Bill · ONU · Reseller · Status
📋 Import History
| Time | File / Type | New Records | Updated | Skipped | Total Rows |
|---|
⚙️ Settings
Configure your ERP system preferences.
🏢 Business Info
💾 Data Management
⚠️ Importing data will MERGE with existing data.
📊 Storage Usage
🔄 Multi-Device Sync
Hosting দিয়ে
📱 একাধিক device (PC + Mobile + APK) থেকে একই data access করতে hosting-এ একটি সহজ PHP script রাখুন।
নিচে config করুন — তারপর Push/Pull দিয়ে sync করুন।
📁 Offline Transfer (Internet ছাড়া)
💡 Export করে USB/WhatsApp দিয়ে অন্য device-এ Import করুন।
🔧 Server Setup (একবার করতে হবে)
1. নিচের Download PHP Script বাটনে ক্লিক করুন
2.
3. Sync URL:
4. Secret Key: যেকোনো password দিন (উপরে ও PHP file-এ একই রাখুন)
2.
sync.php ফাইলটা cPanel → public_html → sync/ ফোল্ডারে upload করুন3. Sync URL:
https://billing.sminternetbd.com/sync4. Secret Key: যেকোনো password দিন (উপরে ও PHP file-এ একই রাখুন)
💾 Auto Backup Settings
💡 নির্দিষ্ট সময় পর পর স্বয়ংক্রিয়ভাবে data backup নেবে। Backup ফাইল browser-এ download হবে অথবা sync server-এ push হবে।
📋 Recent Backups (localStorage)
📡 Device Sync Status
Sync config সেট করলে এখানে দেখাবে।
🧾 Invoice Manager
Client ও Reseller-দের জন্য মাসিক Invoice তৈরি করুন — Print/PDF ও Excel export করুন।
🖼️ Invoice Logo সেটিংস
Invoice PDF-এ যে logo দেখাবে তা এখানে পরিবর্তন করুন
No logo
PNG, JPG বা SVG • Max 2MB
Recommended: 400×150px
Recommended: 400×150px
Company Info পরিবর্তন:
👤 Client Invoice তৈরি করুন
Home User দের জন্য মাসিক Internet Bill Invoice