Restaurant Payroll Sheet Template Bangladesh: Attendance থেকে Net Pay Control
Approved term, attendance, overtime, addition, deduction, advance ও payment source evidence-এ trace করা payroll-control sheet।
সর্বশেষ যাচাই: 2026-08-30
Restaurant payroll sheet template Bangladesh employee ও reviewer-কে প্রতিটি amount approved source থেকে trace করতে দেবে। Employee master ও employment term-কে attendance, scheduled shift, approved leave, overtime authorisation, salary addition, lawful deduction, salary advance, net pay, payment reference ও acknowledgement-এর সঙ্গে connect করে।
Bangladesh Labour Act worker record, wage, working time ও leave cover করে; Labour Rules prescribed procedure/form দেয়। Applicability establishment ও employee classification-এর ওপর নির্ভর করে, তাই sheet every chef, waiter, manager বা temporary worker-এর জন্য one formula invent করে না। Qualified adviser correctভাবে configure করতে পারে এমন evidence chain তৈরি করে।
Copy-ready payroll summary column
| Employee | Pay terms | Attendance/leave | Overtime source | Gross additions | Deductions | Advance recovery | Net pay | Payment/acknowledgement |
|---|---|---|---|---|---|---|---|---|
| ID, name, role, branch | Approved wage/salary ও period | Exceptionসহ source summary | Approved hours ও rule ref | Each component separate | Each authority | Advance ledger ref | Calculated/reviewed | Method, ref, date ও receipt |
| Second employee | Current effective term | Present/absent/leave | Support ছাড়া overtime নয় | Approved allowance/bonus | Unexplained negative নয় | Opening/recovery/closing | Gross minus authorised | Statement access |
Employee ও pay master lock করুন
Employee ID, full name, role, branch, joining status, adviser-defined worker/employee classification, pay basis, approved component, payment method, used bank/MFS identity, applicable tax/statutory ID ও effective date রাখুন। Signed/authorised master change ছাড়া monthly sheet-এ new base salary type করবেন না।
Labour Act service-book ও worker-register information রাখে। Official Act, Rules ও DIFE থেকে current required record/prescribed form confirm করুন। Payroll master support করতে পারে, কিন্তু custom spreadsheet automatically legally prescribed form replace করে না।
এই অংশের উৎস: Bangladesh Labour Act 2006 on Bangladesh Laws · Ministry of Labour and Employment: Bangladesh Labour Rules 2015
Payroll period ও cut-off reconcile করুন
Payroll start/end, attendance cut-off, adjustment cut-off, approval date ও payment date লিখুন। New joiner, exit, transfer ও salary change exact effective date চাই। Late attendance correction controlled current/next-period adjustment হবে; history ছাড়া approved payroll overwrite নয়।
Review-এর আগে first payroll version lock ও every change-এ revision number দিন। Original, reason, evidence, preparer ও approver রাখুন। Payroll-final-new-2 filename employee actually কত paid তা দেখায় না।
Exception controlসহ attendance import করুন
Controlled attendance থেকে employee ID, date, scheduled shift, check-in/out, break, approved leave, authorised absence, missing punch, late/early flag ও approver আনুন। Exception resolved বা visibly pending না করা পর্যন্ত summary final করবেন না। Missing punch-কে directly unpaid absence করবেন না।
Branch ও role অনুযায়ী rostered/actual hour compare করুন। Duplicate ID, overlapping shift, leave-এ work, exit-এর পর attendance ও impossible hour exception list তৈরি করবে। Staffing allow করলে attendance editor একমাত্র payroll change approver হবেন না।
Approved evidence থেকে overtime calculate করুন
Scheduled hour, actual eligible hour, authorised overtime, applicable rule/contract reference, calculation basis ও manager approval রাখুন। Blog থেকে copied universal multiplier ব্যবহার করবেন না। Employee coverage, wage component ও current Bangladesh law qualified review চাই।
Overtime worked এবং lawful/fair process-এ payment approved status আলাদা রাখুন। Record work দেখালে prior authorisation missing বলে hour delete না করে management scheduling ও legal obligation investigate করুন। Payroll overtime amount underlying date/approval-এ link করুন।
এই অংশের উৎস: Bangladesh Labour Act 2006 on Bangladesh Laws · DIFE frequently asked questions based on Bangladesh Labour Act
প্রতিটি earning component আলাদা দেখান
Several rule combine করা one Other addition column এড়ান। Employee gross pay কেন changed বুঝবে। Discretionary ও contractual component distinct রাখুন এবং period-এ used policy version preserve করুন।
| Component | Required source |
|---|---|
| Base wage/salary | Current approved employment/pay master |
| Overtime | Eligible hour, rule ও approval |
| Attendance/shift allowance | Policy, eligibility ও source |
| Service-charge distribution | Used হলে approved scheme/period |
| Bonus/incentive | Policy, target result ও approver |
| Arrears/correction | Original period, reason ও revision |
| Other earning | Named component, authority ও duplicate check |
Deduction ও salary advance control করুন
প্রতিটি deduction type, amount, legal/employee-authorisation basis, source reference ও approverসহ list করুন। Current legal authority/procedure confirm ছাড়া cash shortage, breakage, meal, uniform, absence বা penalty deduction ব্যবহার করবেন না। Adjustment-labelled negative number sufficient evidence নয়।
Salary advance-এর জন্য separate ledger থেকে opening balance, new approved advance, scheduled recovery, actual recovery ও closing balance আনুন। Duplicate recovery prevent ও employee acknowledgement রাখুন। Advance payment ও payroll deduction connected event।
এই অংশের উৎস: Bangladesh Labour Act 2006 on Bangladesh Laws
Net pay ও control total
Accountant-approved policy অনুযায়ী round করুন এবং difference দেখান। Release-এর আগে unusually high, low, zero বা negative pay review করুন। Prior period compare করুন, কিন্তু legitimate join, exit, leave ও schedule change error ভাবার আগে investigate করুন।
| Control | Formula/test |
|---|---|
| Employee net pay | Approved gross minus authorised deduction |
| Payroll headcount | Paid, held, zero-pay, join/exit reconcile |
| Gross total | Approved earning component sum |
| Deduction total | Type/destination sum |
| Advance closing | Recovery-এর পর ledger balance |
| Payment batch | Net payroll equals instruction + held item |
| Revision | Current approved version equals paid version |
Approval ও segregation workflow
Practical flow: HR/operations attendance exception prepare, branch manager work/leave confirm, payroll calculation, finance total/source review, authorised person payment release। Restaurant size অনুযায়ী role configure করুন, কিন্তু one user employee create, pay change, payroll approve ও money release সব করবেন না।
Final checklist: master change approved, attendance locked, leave approved, overtime supported, advance reconciled, deduction reviewed, new bank/MFS detail independently confirmed, total matched ও revision signed। Control completer ও time record করুন।
Payment, payslip ও acknowledgement
Payment method, destination identity, batch/transaction reference, date, failed/returned payment ও reissue reference record করুন। Cash হলে controlled disbursement ও signed acknowledgement। Batch create কিন্তু transfer fail হলে paid mark করবেন না।
Employee-কে earning, deduction, advance recovery, net pay ও period separate statement দিন। Payroll privacy protect ও role-based access restrict করুন। Shift approve করতে manager-এর every employee bank detail দরকার নেই।
Monthly payroll review pack
Current legal, accounting ও internal requirement অনুযায়ী retain করুন। Official Labour Act, Rules ও DIFE update regularly review করুন। One master rule update করে affected period identify করতে পারলে payroll template strongest।
- Approved employee/pay-master change
- Attendance ও leave exception report
- Date/approvalসহ overtime detail
- Earning component ও policy ref
- Deduction register ও authority
- Salary-advance reconciliation
- Payroll summary ও control total
- Payment batch, failure ও reissue
- Employee statement/acknowledgement
- Revision history ও final approval
- Adviser-confirmed required prescribed form
এই অংশের উৎস: DIFE rules page including 2022 amendment and 2015 Rules
এই তথ্য কীভাবে হিসাব ও যাচাই করা হয়েছে
Payroll sheet employee identity, approved term, attendance, leave, overtime source record, addition, deduction, advance, payment ও acknowledgement-এর control template। Linked Bangladesh Labour Act, Labour Rules ও DIFE page legal source। Article wage rate, overtime multiplier, deduction limit বা payment deadline hard-code করে না।
Restaurant classification ও employee coverage different হতে পারে এবং labour rule amend হতে পারে। Calculation ব্যবহারের আগে qualified Bangladesh HR/legal adviser ও accountant প্রতিটি field current law, prescribed form ও employment term-এর সঙ্গে map করবেন।
Restaurant payroll sheet controlled employee, attendance, leave, overtime, advance ও payment record-এর final summary। Every amount effective term/approved event-এ trace করবে এবং revision visible থাকবে।
Field copy করে Bangladesh labour adviser/accountant applicability, formula, prescribed form, deduction ও deadline configure করবেন। Live payroll-এর আগে join, exit, leave, overtime, advance recovery ও failed payment test করুন।
সম্পর্কিত গাইড
- Restaurant staff attendance sheet template
- Restaurant overtime calculation Bangladesh
- Restaurant salary advance management
- Restaurant payroll management
রসুইয়ে এই ফিচারটি দেখুন: Rosuii-তে restaurant attendance, shift, salary advance ও payroll connect করুন
যাচাই করা উৎস
সাধারণ প্রশ্ন
Restaurant payroll sheet-এ কী column থাকবে?
এক formula সব restaurant employee-তে apply হয়?
Missing attendance automatically salary কমাবে?
Salary advance payroll-এ কীভাবে আসবে?
Payroll release-এর আগে কী check হবে?
রসুই দিয়ে আপনার রেস্টুরেন্ট চালান
পিওএস, মেনু, ইনভেন্টরি, পে-রোল এবং আরও অনেক কিছু — বাংলাদেশের রেস্টুরেন্টের জন্য তৈরি।
শুরু করুন
