MLM Commission Audit Tool

🎯 Welcome to MLM Commission Audit Tool developed by WebGTR

This professional-grade tool helps you test and verify MLM commission calculations to detect bugs, discrepancies, and system errors before they cost you money.

📋 How to Use This Tool:

Select Income Type: Choose the tab for the income you want to test (Direct, Level, ROI, or Binary)
Follow Testing Steps: Each calculator includes step-by-step instructions to properly set up your test scenario
Complete Criteria Checklist: Check all boxes to confirm you've met the prerequisites before calculating
Enter Test Data: Fill in the input fields (yellow background) with your actual system values
Calculate Expected Result: Click the calculate button to see what the commission SHOULD be
Verify Actual Output: Enter what your system actually paid in the verification section
Identify Issues: If there's a discrepancy, review the detailed debugging reasons provided
Fix & Re-test: Fix the bug in your system and run the test again to verify

📊 What Each Calculator Tests:

🎯 Direct Income: Tests commission from direct referrals/sponsorships. Verifies sponsor tracking, commission percentages, and eligibility criteria.
📊 Level Income: Tests multi-level/generation commissions (3 levels deep). Validates genealogy tree structure, level counting, and percentage distribution.
💰 ROI Income: Tests investment return payouts. Checks period calculations (daily/weekly/monthly), cron jobs, and activation logic.
⚖️ Binary Income: Tests binary pairing income using weaker leg logic. Validates tree structure, pair matching, capping, and carry forward.
🏆 Rank & Rewards: Tests rank qualification and achievement rewards based on team performance.

🐛 Common Bugs This Tool Detects:

❌ Wrong Commission Percentages: Database or config file has incorrect percentage values
❌ Incorrect Genealogy Level Counting: Level 2 users being counted as Level 1
❌ Binary Weaker Leg Not Used: System using stronger leg instead of weaker (critical bug!)
❌ ROI Period Confusion: Daily ROI being calculated as monthly or vice versa
❌ Missing Carry Forward: Binary carry forward points not tracked to next cycle
❌ Sponsor Tracking Failed: Referral links not properly assigning sponsor_id
❌ Commission Not Propagating: Upline not receiving commissions from downline activities
❌ Cron Job Not Running: ROI scheduler not executing or timing wrong
❌ Duplicate Payment Prevention: Logic blocking legitimate payouts
❌ Wallet Balance Update Failed: Commission calculated but not credited to wallet

✅ New Features in This Version:

🧪 Step-by-Step Testing Guides: Detailed instructions for testing each income type
☑️ Criteria Checklists: Ensure all prerequisites are met before testing
🐛 Enhanced Debugging: Comprehensive list of possible reasons for discrepancies
💻 SQL Query Helpers: Sample queries to help you debug your database
🎯 User-Focused Scenarios: Test with User A, B, C scenarios for clarity
📝 Better Input Labels: More descriptive field names that make sense

💡 Tips for Best Results:

Create Test Users: Don't test with production data. Create User A, B, C, etc. specifically for testing
Start Simple: Begin with Direct Income (easiest to test) before moving to complex Binary Income
Document Everything: Take screenshots of expected vs actual results for developer reference
Test Edge Cases: Try zero values, very large numbers, decimal amounts, negative scenarios
Run Regular Audits: Test before major commission payouts or after code changes
Check Database Directly: Use provided SQL queries to verify data at database level
Verify Prerequisites: Always complete the criteria checklist - most bugs are due to unmet prerequisites

🚀 Who Should Use This Tool:

MLM Company Owners: Audit your system before going live or making payouts
MLM Software Developers: Test your commission logic during development
Quality Assurance Teams: Comprehensive testing of commission modules
System Administrators: Troubleshoot commission discrepancies reported by users
Independent Auditors: Verify MLM system accuracy for compliance

⚠️ Important Note: This tool calculates what commissions SHOULD be based on standard MLM formulas. Your system might have custom business rules, caps, or conditions. Always cross-reference with your system's specific logic and requirements.

💼 Professional Assistance: If you find bugs in your MLM system and need expert help to fix them, or if you need a custom MLM platform built from scratch, contact a professional MLM software developer with 9+ years of experience in MLM systems.

Direct Referral Income Calculator

Test direct sponsorship commission calculations

🧪 Step-by-Step Testing Process

Step 1: Register User A in your MLM system (this will be the sponsor)
Step 2: Copy User A's referral/sponsor link from their dashboard
Step 3: Open the referral link and register User B (new member)
Step 4: Login as User B and purchase a package (e.g., $10,000)
Step 5: Verify User A meets all eligibility criteria (check boxes below)
Step 6: Check User A's wallet/commission section for direct income
Step 7: Compare actual amount with calculated amount below

✅ Pre-Calculation Criteria (Check all that apply)

User A has an active package/subscription

User A is eligible for direct income (not blocked/suspended)

User B successfully purchased and payment confirmed

Referral link properly tracked User A as sponsor of User B

📊 Commission Calculator

Package Amount Purchased by User B ($) *

Direct Commission Percentage (%) *

Number of Direct Referrals by User A *

📊 Calculation Results

Commission Per Referral

$0.00

Expected Commission for User A

$0.00

🔍 Actual System Output Verification

What User A Actually Received in Your System ($)

Difference (System - Expected)

$0.00

💡 Debugging Tips:

Check your database's `commission_transactions` or `income_history` table for the entry
Look at backend logs during User B's package purchase
Verify the direct income percentage in admin settings
Test with a simple package amount like $1000 for easier debugging

Level/Generation Income Calculator

Test multi-level commission calculations

🧪 Step-by-Step Testing Process

Step 1: Register User A (Root user for testing)
Step 2: Use A's referral link to register Users B, C, D (Level 1 - Direct to A)
Step 3: Use B's link to register Users E, F (Level 2 - Grandchildren of A)
Step 4: Use C's link to register Users G, H (Also Level 2 to A)
Step 5: Use E's link to register Users I, J (Level 3 - Great-grandchildren of A)
Step 6: Purchase packages from Level 1, 2, and 3 users
Step 7: Check User A's level income breakdown in system
Step 8: Verify genealogy tree shows correct parent-child relationships

✅ Pre-Calculation Criteria (Check all that apply)

Genealogy tree structure is correct (verified parent-child IDs)

Level counting logic working (Level 1, 2, 3 properly identified)

All users have purchased packages and payments confirmed

User A is active and eligible for level income

📊 Commission Calculator

Package Amount ($) - Use same amount for all levels *

📍 Level 1 (Direct Referrals of User A)

Number of Members Who Purchased

Commission Percentage (%)

📍 Level 2 (Referrals of Level 1 Users)

Number of Members Who Purchased

Commission Percentage (%)

📍 Level 3 (Referrals of Level 2 Users)

Number of Members Who Purchased

Commission Percentage (%)

📊 Calculation Results

Level 1 Income

$0.00

Level 2 Income

$0.00

Level 3 Income

$0.00

Total Expected Level Income for User A

$0.00

🔍 Actual System Output Verification

What User A Actually Received in Your System ($)

Difference (System - Expected)

$0.00

💡 Debugging SQL Query:

To verify level counting, run this query (adjust table names):


                            SELECT u.id, u.name, u.sponsor_id, 

                            (SELECT COUNT(*) FROM users WHERE sponsor_id = [USER_A_ID]) as level1_count,

                            (SELECT COUNT(*) FROM users WHERE sponsor_id IN (SELECT id FROM users WHERE sponsor_id = [USER_A_ID])) as level2_count

ROI Income Calculator

Test return on investment payout calculations

🧪 Step-by-Step Testing Process

Step 1: Register User A and login
Step 2: Purchase an ROI/Investment package (e.g., $50,000)
Step 3: Note the purchase date and time (ROI start date)
Step 4: Check admin panel for ROI settings (percentage, period, duration)
Step 5: Wait for first payout cycle OR manually run cron job/scheduler
Step 6: Check User A's ROI income history for credited amount
Step 7: Verify ROI is being credited at correct intervals (daily/weekly/monthly)
Step 8: Test for 2-3 cycles to ensure consistency

✅ Pre-Calculation Criteria (Check all that apply)

ROI package purchased and payment confirmed

ROI start date/activation date is set in database

Cron job or scheduler for ROI distribution is running

No duplicate ROI payout for same period already processed

📊 ROI Calculator

Investment/Package Amount ($) *

ROI Percentage Per Period (%) *

Payout Period *

Total Contract Duration (Months) *

📊 Calculation Results

Per-Period ROI Payout

$0.00

Total Periods

0

Total ROI Over Duration

$0.00

Total Return %

0.00%

🔍 Actual System Output Verification

What User A Received This Period ($) - For single period test

Difference (System - Expected Per Period)

$0.00

⚠️ Legal Warning: High ROI schemes may be illegal in many jurisdictions. Ensure compliance with local laws and regulations.

💡 Testing Tip:

For testing, manually change `roi_start_date` to yesterday in database to trigger immediate payout
Check Laravel scheduler: php artisan schedule:list
Manually run ROI cron: php artisan roi:distribute (if command exists)
Look in database table: roi_transactions or roi_history for records

Binary Income Calculator

Test binary pairing commission calculations

🧪 Step-by-Step Testing Process

Step 1: Register User A (will be root of binary tree)
Step 2: Place User B on LEFT position under User A
Step 3: Place User C on RIGHT position under User A
Step 4: Continue building tree by placing more users under B and C
Step 5: Purchase packages from left leg users (this creates points/volume)
Step 6: Purchase packages from right leg users
Step 7: Check User A's binary income and leg volumes
Step 8: Verify system shows correct left volume, right volume, and pairs matched
Step 9: Verify carry forward points (stronger leg excess) is tracked for next cycle

🔑 Binary Concept: Income is calculated based on the weaker leg. If left leg = 1000 points and right leg = 800 points, you earn on 800 pairs only. The extra 200 points from left leg carry forward to next cycle.

✅ Pre-Calculation Criteria (Check all that apply)

Binary tree structure correctly built (left/right positions verified)

Points/volume correctly calculated from package purchases

User A is active and eligible for binary income

Capping rules (if any) are clear and documented

📊 Binary Income Calculator

User A's Left Leg Total Points/Volume *

User A's Right Leg Total Points/Volume *

Income Per Pair ($) *

Max Pairs Per Day (0 = Unlimited)

Days in Cycle/Month *

📊 Calculation Results

Weaker Leg Volume

0 points

Income calculated on this

Total Pairs Matched

0 pairs

Avg Pairs Per Day

0.00

Carry Forward Points

0 points

Moved to next cycle

Expected Total Binary Income

$0.00

🔍 Actual System Output Verification

What User A Actually Received in Your System ($)

Difference (System - Expected)

$0.00

💡 Debugging SQL Queries:

Check left/right leg volumes:


                            SELECT position, SUM(points) as total_points

                            FROM binary_tree

                            WHERE parent_id = [USER_A_ID]

                            GROUP BY position

Rank & Rewards Calculator

Determine current rank and next rank requirements

Note: This uses example rank criteria. Results will vary based on your actual MLM plan.

Direct Referrals (Personal) *

Total Team Size *

Total Team Sales ($) *

🏆 Your Rank Analysis

👤

Current Rank

MEMBER

Achievement Reward

$0

Next Rank Target

BRONZE

📊 Requirements for Next Rank:

3 direct, 10 team, $1L sales

📋 Rank Criteria Reference Table

Rank	Direct Refs	Team Size	Team Sales	Reward
👤 MEMBER	0-2	0-9	<$1L	$0
🥉 BRONZE	3+	10+	$1L+	$5,000
🥈 SILVER	5+	25+	$2.5L+	$10,000
🥇 GOLD	7+	50+	$5L+	$25,000
💎 DIAMOND	10+	100+	$10L+	$50,000

📊 MLM Commission Testing & Audit Tool

🎯 Welcome to MLM Commission Audit Tool developed by WebGTR

📋 How to Use This Tool:

📊 What Each Calculator Tests:

🐛 Common Bugs This Tool Detects:

✅ New Features in This Version:

💡 Tips for Best Results:

🚀 Who Should Use This Tool:

Direct Referral Income Calculator

🧪 Step-by-Step Testing Process

✅ Pre-Calculation Criteria (Check all that apply)

📊 Commission Calculator

📊 Calculation Results

🐛 Possible Reasons for Discrepancy

Level/Generation Income Calculator

🧪 Step-by-Step Testing Process

✅ Pre-Calculation Criteria (Check all that apply)

📊 Commission Calculator

📊 Calculation Results

🐛 Possible Reasons for Discrepancy

ROI Income Calculator

🧪 Step-by-Step Testing Process

✅ Pre-Calculation Criteria (Check all that apply)

📊 ROI Calculator

📊 Calculation Results

🐛 Possible Reasons for Discrepancy

Binary Income Calculator

🧪 Step-by-Step Testing Process

✅ Pre-Calculation Criteria (Check all that apply)

📊 Binary Income Calculator

📊 Calculation Results

🐛 Possible Reasons for Discrepancy

Rank & Rewards Calculator

🏆 Your Rank Analysis

📋 Rank Criteria Reference Table