A good teacher salary sheet lists each employee's basic pay, allowances, deductions, advances, net pay and a signature column. EDUBase Payroll & Salaries builds it from salary plans and attendance, then posts payments to finance.
What should a teacher salary sheet contain?
A salary sheet is the month-end record that shows what each employee earns, what is taken off and what is finally paid. Most private schools in Pakistan still keep it in Excel, which works until staff numbers, campuses and adjustments grow.
A usable format has one row per employee and the same columns every month, so that the trustees, the accountant and the teacher can all read it the same way.
- Employee name, designation and department, and campus for multi-campus schools
- Basic pay, plus each allowance as its own column
- Deductions for absence, late arrival and short leave
- Advance salary recovered this month
- Increment or arrears, if any
- Net pay payable
- Payment method or bank details
- Signature column for the employee and a line for the approver
Why do Excel salary sheets cause problems?
The sheet itself is rarely the issue. The trouble is the data feeding it: attendance counted by hand, advances remembered rather than recorded, and rate changes made without approval.
Once the month is paid, the sheet is also a separate file from the school's books, so someone has to enter the same totals again in the accounts.
- Attendance deductions are calculated manually and disputed later
- Advances are forgotten or recovered twice
- Salary changes are made without a second person checking
- Visiting faculty paid per lecture need a separate calculation
- Payments are re-keyed into the accounts
How does EDUBase Payroll & Salaries produce the salary sheet?
You create a salary plan for each employee: basic pay plus your own allowances and deductions, with an update history. At month end you run the calculation, which applies attendance, leave, late and lecture-based adjustments.
You then pay and print payslips, the salary report and the signature sheet. If a salary was paid by mistake, it can be reversed. Salary payments post to the finance module automatically.
- Salary plans with your own allowances and deductions
- Advance salary recorded and recovered from the next salary
- Increment and salary plan changes wait for a manager's approval, on the web or in the Owners App
- Employee salary report shows one person's salary history and net pay over time
How do attendance and lecture-wise pay feed the calculation?
Employee Attendance can be marked daily, or entered as a whole month in one grid. Late arrival, short leave and absence feed the salary calculation automatically. Once salaries are done, the month can be locked so nothing changes afterwards.
Staff attendance can also come from QR cards, biometric or face devices, or the Teachers App inside the campus map radius.
Colleges and academies paying visiting faculty can use Lecture-Wise Salary: a rate card by class, section or subject, a lecture register, and approval before payment. The payslip shows the lectures and rate behind the amount.
- Month lock after salaries are processed
- Automatic Short Leave for early clock-out
- Separate rights to record and to approve lectures
- Lecture-Wise Salary Report labels each teacher Paid or Not calculated yet
What controls should a school look for in payroll software?
Payroll holds sensitive data and moves money, so access and traceability matter as much as the calculation. Ask any vendor how it handles the points below.
In EDUBase, per-user, per-screen and per-action privileges with campus scope control who sees salaries. Salary changes can require a second person, and User Logging shows who created, changed or deleted a record.
- Role-based access to salary screens
- Approval for salary plans, increments and advances
- An activity log with the changed fields
- Automatic posting to the ledger
- Teachers can see their own payslip in the Teachers App
How do manual and software-based salary sheets compare?
The table below compares the usual approaches on the points that decide whether a school can trust its monthly payroll.
Excel salary sheet versus payroll software for a private school
| Criterion | Excel or paper sheet | EDUBase Payroll & Salaries |
|---|---|---|
| Attendance deductions | Counted by hand each month | Calculated from attendance, leave and late marks |
| Advances | Tracked in notes or memory | Recorded and recovered from the next salary |
| Salary changes | Edited in the file | Wait for a manager's approval |
| Visiting faculty | Separate calculation | Lecture-Wise Salary with rate card and approval |
| Payslips and signature sheet | Built manually | Printed after pay |
| Accounts | Totals re-entered | Posted to the finance module |
| Audit trail | Usually none | User Logging records changes |
| Mistaken payment | Overwrite the cell | Reverse the salary paid by mistake |
Related modules
- Payroll & Salaries — Salary plans, allowances, deductions, approvals, payslips and salary sheets, posted to the ledger.
- Employee Attendance — Daily or monthly staff attendance from the register, the app, QR or a device, locked once payroll runs.
- Lecture-Wise Salary — Pay visiting faculty per lecture with a rate card, a lecture register and approval.
- Staff Management (HRM) — Employee records, shifts, documents, letters, leave and the Teacher App login, in one place.
- Finance & Accounting — Chart of accounts, journals, ledgers, trial balance, P&L and balance sheet, fed by fees and payroll.
- Users, Privileges & Activity Log — Give each staff member exactly the screens and actions they need, and see who changed what.