Blog · Social Media Care

School Fee Management System in Bangladesh: A Chattogram Case Study

How Social Media Care is building a school fee management system for a Chattogram school: Excel import, PDF receipts, Day Close and role-based logins.

Ask any school accountant in Bangladesh what the last week of the month feels like and you will usually hear the same story: stacks of receipt books, a few Excel files that don't quite agree, and a long evening trying to make cash in hand match what the ledger says.

At Social Media Care, we are currently building a school fee management system for a school in Chattogram to replace exactly that routine.

This case study walks through the problem, the system we are building, what we have learned so far, and practical tips for any school considering school management software in Bangladesh .

(To protect client confidentiality, we are not naming the school.

The system is still in development, so the outcomes below are described as goals and early observations, not final numbers.) The Problem: Paper Ledgers, Scattered Excel and Month-End Pain Before this project, the school's fee and accounts work ran on a familiar mix: Paper ledgers and receipt books.

Every payment was written by hand, then copied again into a register.

Two writes means two chances for a mistake.

Scattered Excel files.

Different staff kept their own sheets for admissions, fees and expenses.

Nobody was fully sure which file was the latest version.

Three money channels, no single view.

Parents paid in cash at the counter, by bank deposit and through mobile banking such as bKash or Nagad.

Each channel had its own record, and matching them was manual.

Month-end reconciliation.

Small daily gaps piled up silently until the end of the month, when the accounts team had to trace them back through pages of entries.

Informal expense approvals.

Spending was often approved verbally, which made it hard to answer later "who approved this, and why?" Limited visibility for parents and leadership.

Parents had to call or visit to check dues.

The principal had to ask for a report instead of seeing the numbers directly.

None of this is unusual.

Many schools start with a school fee management system in Excel , and it works until the student count, the number of fee heads and the number of payment channels grow.

Then the spreadsheet becomes the bottleneck.

The Solution: A School Fee Management System Built Around Daily Work Rather than offering a giant all-in-one ERP, we focused on the money workflow the accounts office actually lives with every day.

Here are the core modules.

1.

Excel Bulk Import of Students The school already had student data in Excel, so we started there.

Staff upload their existing sheet, the system checks it for missing or duplicate entries (class, section, roll, guardian contact), and imports hundreds of students at once.

Nobody has to retype a whole school, and the data that people already trust becomes the foundation of the new system.

2.

Fee Invoices and Instant PDF Receipts Fee heads such as tuition, admission, exam and session fees are set up once.

The system then generates invoices for each student.

When a payment is collected, a clean PDF receipt is produced instantly with a unique number.

The parent gets a proper receipt, and the school no longer depends on carbon-copy books.

3.

Daily Day Close: Cash, Bank and Mobile Banking Reconciled This is the feature we are most excited about.

At the end of each working day, the accounts team runs a Day Close .

The system totals what was collected through cash, bank and mobile banking, and staff confirm it against cash in hand, bank deposits and mobile wallet statements.

Any difference is flagged that same day, when it is still easy to explain.

Once a day is closed, its entries are locked.

The aim is simple: no more month-end surprises, because every day has already been checked.