CodePex Campus Logo
Multi-Branch & Franchise Management6 min read

Using centralized audit logs to track manual fee edits or deletions at remote centers

A franchise partner "adjusts" a fee entry. A remote center manager deletes a pending payment. Without logs, you'd never know. Here's how to see every change, everywhere.

It's month-end. Your North Branch shows ₹4.2L in collections. Your records show ₹4.5L. ₹30,000 is missing. The branch manager says "must be a system error." But was it? With multiple remote centers and franchise partners, manual fee edits and deletions are a constant risk—sometimes innocent mistakes, sometimes deliberate manipulation.

⚠️ The Problem:

Remote centers have their own staff, their own pressures, and sometimes their own incentives to "adjust" numbers. Without a centralized audit trail, you're blind to what's really happening.

CodePex Campus maintains a complete, immutable audit log of every fee edit, deletion, or adjustment—across all branches, in one place.

📋 Centralized Audit Log Viewer

root@codepex:~$ tail -f /var/log/fee_audit.log

Timestamp Branch User Action Student Original Value New Value IP Address Device
2025-03-15 09:23:45 North anita.north EDIT Rahul Sharma ₹85,000 ₹75,000 192.168.1.45 Chrome/Win
2025-03-15 14:12:22 South rajesh.south DELETE Priya Patel ₹12,000 [DELETED] 10.0.0.78 Android App
2025-03-16 10:05:33 East vikram.east EDIT Amit Kumar ₹45,000 ₹40,000 172.16.0.23 Firefox/Mac
2025-03-16 11:47:12 West meera.west DELETE Neha Gupta ₹8,500 [DELETED] 192.168.0.156 Safari/iPad
2025-03-17 08:52:01 Central suresh.central EDIT Rohan Mehta ₹95,000 ₹90,000 10.10.0.45 Edge/Win

🔍 Search:

📊 Branch-wise Edit/Delete Activity (Last 30 Days)

North

24

edits

3

deletes

South

18

edits

5

deletes

East

31

edits

8

deletes

West

15

edits

2

deletes

Central

42

edits

12

deletes

🚨 Central Branch has unusually high edit/delete activity — 3x network average. Investigate immediately.

👤 User-wise Edit/Delete Analysis

User Branch Role Edits Deletes Total Last Activity
suresh.central Central Manager 28 8 36 Today
anita.north North Accountant 18 2 20 Yesterday
vikram.east East Manager 22 5 27 2 days ago
meera.west West Accountant 12 1 13 Today

📝 Edit Reason Tracking

Recent Edits with Reasons

North Branch - Anita 15 Mar 2025

Edited fee for Rahul Sharma: ₹85,000 → ₹75,000

Reason: "Student opted out of transport service"

Central Branch - Suresh 16 Mar 2025

Edited fee for Rohan Mehta: ₹95,000 → ₹90,000

Reason: "Scholarship adjustment (approved by HO)"

⚠️ No supporting document attached

South Branch - Rajesh 14 Mar 2025

Deleted fee entry for Priya Patel: ₹12,000

Reason: "Duplicate entry"

Reason Analysis

Scholarship adjustment

45%

Duplicate entry

30%

Service cancellation

15%

No reason provided

10%

🔑 Edit/Delete Permission Matrix

Role
Edit Fee
Delete Fee
Reason Required
Approval Needed
Branch Manager
✅
❌
✅
❌
Accountant
✅
❌
✅
❌
Regional Manager
✅
⭕
✅
✅ (HO)
Head Office Admin
✅
✅
✅
❌

🚨 Automated Alert Rules

High Delete Count

>5 deletions/day in any branch

Alert: Director + Regional Manager

Unusual Edit Patterns

>20 edits/day by single user

Alert: Regional Manager

Missing Reasons

Edits without reason provided

Alert: Branch Manager

⚡ 3 alerts triggered today — all from Central Branch

🔍 How Audit Logs Caught a Fraud Case

1

Audit log shows 12 fee deletions at Central Branch in one week — 4x normal rate

System alert triggered

2

Investigation reveals all deletions by same user (suresh.central)

Pattern: Small amounts (₹2,000-5,000), always cash payments

3

Cross-reference with bank deposits shows ₹38,000 in cash never deposited

Manager was deleting entries and pocketing cash

4

Immediate action: User account suspended, police complaint filed, ₹38,000 recovered

Without audit logs, this would have gone undetected

💬 Success Story

"We have 12 franchise partners across 4 states. Last year, we noticed one franchise's collections were consistently 8-10% below similar centers. The franchise owner kept blaming local economic conditions. Then we checked the audit logs. A pattern emerged—every month, around the 25th, someone would make 5-6 small fee deletions. Total: ₹45,000-50,000 per month. It was an inside job by their accountant. We recovered ₹2.7 lakhs over 6 months. Now every franchise knows we have complete visibility. The fraud stopped overnight."

AK

Amit K.

Director, national coaching chain

✅ Audit Log Best Practices

📊 Review audit logs weekly 🚨 Set alerts for unusual activity 🔒 Restrict delete permissions 📝 Require reasons for all edits 📈 Track trends by branch 👥 Educate staff on tracking

🇮🇳 India-Specific Financial Controls

• Cash handling risks

Higher in Tier-2 cities where digital payments are lower

• Franchise relationships

Clear edit/delete policies in franchise agreements

• Audit requirements

Income tax department may request edit logs during scrutiny

• Employee turnover

High risk period when staff resign — monitor logs closely

Every edit, every delete, every adjustment—logged forever. You'll never wonder what happened again.

Related Articles

Multi-Branch & Franchise Management

The Master Dashboard: Monitoring 10+ branches from a single screen.

6 min read

Multi-Branch & Franchise Management

Franchise Royalty Tracking: Automating revenue-share calculations for branch partners.

7 min read

Multi-Branch & Franchise Management

Consolidated Cash Flow: Viewing daily collections across 10+ branches on one screen.

6 min read

Multi-Branch & Franchise Management

The Master Lesson Plan: Syncing study schedules across all branches to ensure uniform teaching.

6 min read

Multi-Branch & Franchise Management

Comparative Faculty Analytics: Identifying which branch's teachers are producing the best results.

7 min read

Multi-Branch & Franchise Management

Comparing branches based on lead conversion, student attendance, and fee collection.

7 min read