Restaurant Payroll Sheet Template Bangladesh: Attendance to Net Pay Control
A payroll-control sheet that traces every employee's approved terms, attendance, overtime, additions, deductions, advances and payment to source evidence.
Last verified: 2026-08-30
A restaurant payroll sheet template in Bangladesh should let an employee and reviewer trace every amount from an approved source. It connects the employee master and employment terms to attendance, scheduled shifts, approved leave, overtime authorisation, salary additions, lawful deductions, salary advances, net pay, payment reference and acknowledgement.
The Bangladesh Labour Act covers worker records, wages, working time and leave, while the Labour Rules contain prescribed procedures and forms. Applicability depends on the establishment and employee classification, so the sheet below does not invent one formula for every chef, waiter, manager or temporary worker. It creates the evidence chain that a qualified adviser can configure correctly.
Copy-ready payroll summary columns
| Employee | Pay terms | Attendance/leave | Overtime source | Gross additions | Authorised deductions | Advance recovery | Net pay | Payment/acknowledgement |
|---|---|---|---|---|---|---|---|---|
| ID, name, role, branch | Approved wage/salary and period | Source summary with exceptions | Approved hours and rule reference | Each component separately | Each deduction and authority | Advance ledger reference | Calculated and reviewed | Method, reference, date and receipt |
| Second employee | Current effective terms | Present, absent and leave status | No overtime unless supported | Allowance/bonus as approved | Not a negative unexplained amount | Opening, recovery, closing | Gross minus authorised deductions | Employee access to statement |
Lock the employee and pay master
Maintain employee ID, full name, role, branch, joining status, worker or employee classification as advised, pay basis, approved components, payment method, bank or MFS identity where used, tax or statutory identifiers where applicable, and effective dates. Do not type a new base salary directly into the monthly sheet without a signed and authorised master change.
The Labour Act includes service-book and worker-register information. Confirm the current required records and prescribed forms from the official Act, Rules and DIFE. The payroll master can support those records, but a custom spreadsheet does not automatically replace a legally prescribed form.
Sources for this section: Bangladesh Labour Act 2006 on Bangladesh Laws · Ministry of Labour and Employment: Bangladesh Labour Rules 2015
Reconcile the payroll period and cut-off
State the payroll start, end, attendance cut-off, adjustment cut-off, approval date and payment date. New joiners, exits, transfers and salary changes need exact effective dates. A late attendance correction should appear as a controlled current or next-period adjustment, not overwrite an already approved payroll without history.
Lock the first payroll version before review and assign a revision number to every change. Keep the original, reason, source evidence, preparer and approver. A final file named payroll-final-new-2 cannot show which amount the employee was actually paid.
Import attendance with exception control
Bring employee ID, date, scheduled shift, check-in, check-out, break, approved leave, authorised absence, missing punch, late/early flag and attendance approver from the controlled attendance record. Summarise only after exceptions are resolved or visibly carried as pending. Do not convert a missing punch directly into an unpaid absence without the approved process.
Compare rostered and actual hours by branch and role. Duplicate IDs, overlapping shifts, work on leave, attendance after exit and impossible hours should produce an exception list. The person who edits attendance should not be the only person approving the resulting payroll change where staffing allows.
Calculate overtime only from approved evidence
Keep scheduled hours, actual eligible hours, authorised overtime, applicable rule or contract reference, calculation basis and approving manager. Do not use a universal multiplier copied from a blog. The employee's coverage, wage components and current Bangladesh law need qualified review.
Separate overtime worked from overtime approved for payment only through a lawful and fair process. If the records show work but prior authorisation is missing, investigate management scheduling and legal obligations rather than deleting the hours. Link every payroll overtime amount to the underlying dates and approvals.
Sources for this section: Bangladesh Labour Act 2006 on Bangladesh Laws · DIFE frequently asked questions based on Bangladesh Labour Act
Show every earning component separately
Avoid one Other addition column that combines several rules. Employees should see why gross pay changed. Keep discretionary and contractual components distinct, and preserve the version of the policy used for the period.
| Component | Required source |
|---|---|
| Base wage or salary | Current approved employment/pay master |
| Overtime | Eligible hours, calculation rule and approval |
| Attendance or shift allowance | Policy, eligibility and source record |
| Service-charge distribution | Approved scheme and period calculation if used |
| Bonus or incentive | Approved policy, target result and approver |
| Arrears or correction | Original period, reason and revision evidence |
| Other earning | Named component, authority and non-duplication check |
Control deductions and salary advances
List each deduction with type, amount, legal or employee-authorisation basis, source reference and approver. Do not use cash shortage, breakage, meal, uniform, absence or penalty deductions without confirming current legal authority and procedure. A negative number labelled adjustment is not sufficient evidence.
For salary advances, bring opening balance, new approved advance, scheduled recovery, actual recovery and closing balance from a separate employee ledger. Prevent duplicate recovery and preserve employee acknowledgement. An advance payment and a payroll deduction are two connected events, not a free-text note.
Sources for this section: Bangladesh Labour Act 2006 on Bangladesh Laws
Net pay and control totals
Round only under the accountant-approved policy and show any rounding difference. Review unusually high, low, zero or negative pay before the batch is released. Compare current period to prior period by employee and component, but investigate legitimate joins, exits, leave and schedule changes before treating movement as an error.
| Control | Formula or test |
|---|---|
| Employee net pay | Approved gross earnings minus authorised deductions |
| Payroll headcount | Paid, held, zero-pay, joined and exited employees reconciled |
| Gross total | Sum of separately approved earning components |
| Deduction total | Sum by type and destination |
| Advance closing total | Employee ledger balances after recovery |
| Payment batch | Net payroll equals bank/MFS/cash instruction plus held items |
| Revision control | Current approved version equals the paid version |
Approval and segregation workflow
A practical workflow is HR or operations prepares attendance exceptions, branch management confirms work and leave, payroll prepares calculations, finance reviews totals and source documents, and an authorised person releases payment. Configure roles to fit the restaurant without giving one user the ability to create an employee, change pay, approve payroll and release money alone.
Use a final checklist: employee master changes approved, attendance locked, leave approved, overtime supported, advances reconciled, deductions reviewed, new bank/MFS details independently confirmed, totals matched and revision signed. Record who completed each control and when.
Payment, payslip and acknowledgement
Record payment method, destination identity, batch or transaction reference, payment date, failed or returned payment and reissue reference. For cash, use a controlled disbursement and signed acknowledgement. Do not mark the employee paid when the batch was created but the transfer failed.
Give the employee a statement that separates earnings, deductions, advance recovery, net pay and relevant period. Protect payroll privacy and restrict access by role. A manager does not need every employee's bank details merely to approve a shift.
Monthly payroll review pack
Retain records under current legal, accounting and internal requirements. Review official Labour Act, Rules and DIFE updates regularly. A payroll template is strongest when the restaurant can update one master rule and identify every period affected by a change.
- Approved employee and pay-master changes
- Attendance and leave exception report
- Overtime detail with dates and approvals
- Earning components and policy references
- Deduction register and authority
- Salary-advance reconciliation
- Payroll summary and control totals
- Payment batch, failures and reissues
- Employee statements or acknowledgements
- Revision history and final approval
- Required prescribed forms confirmed by adviser
Sources for this section: DIFE rules page including 2022 amendment and 2015 Rules
How we calculated and verified this
The payroll sheet is a control template built around employee identity, approved terms, attendance, leave, overtime source records, additions, deductions, advances, payment and acknowledgement. The linked Bangladesh Labour Act, Labour Rules and DIFE pages are the legal sources. This article deliberately does not hard-code a wage rate, overtime multiplier, deduction limit or payment deadline.
Restaurant classifications and employee coverage can differ, and labour rules can be amended. The employer should have a qualified Bangladesh HR/legal adviser and accountant map each payroll field to the current law, prescribed form and employment terms before using the calculation.
A restaurant payroll sheet is the final summary of controlled employee, attendance, leave, overtime, advance and payment records. Every amount should trace to an effective term or approved event, and every revision should remain visible.
Copy the fields, then have a Bangladesh labour adviser and accountant configure applicability, formulas, prescribed forms, deductions and deadlines. Test joins, exits, leave, overtime, advance recovery and failed payment before using the sheet for a live payroll.
Related guides
- Restaurant Staff Attendance Sheet Template
- Restaurant Overtime Calculation Bangladesh
- Restaurant Salary Advance Management
- Restaurant Payroll Management
See this workflow in Rosuii: Connect restaurant attendance, shifts, salary advances and payroll in Rosuii
Sources checked
Frequently asked questions
What columns should a restaurant payroll sheet include?
Can one payroll formula apply to every restaurant employee?
Should missing attendance automatically reduce salary?
How should salary advances appear in payroll?
What should be checked before releasing payroll?
Run your restaurant on Rosuii
POS, menu, inventory, payroll and more — built for Bangladeshi restaurants.
Start free
