Company: FPC•12-Hour AM/PM•Currency: BDT (৳)

Biometric XLS / CSV Overtime Calculator & A4 Report

Upload attendance (.xls, .xlsx, or .csv) or paste punch lines directly. Computes daily duty hours, negative/positive overtime, and prints or exports an A4 PDF report.

Upload XLSUpload CSV

Employee & Overtime Configuration

Set employee profile details, standard duty time, hourly rate, and short-duty deduction rules.

Company Name

Employee Name

Employee No. / ID

Designation

Report Month

Standard Duty Time9h 10m (550 min)

Hours

Minutes

Presets:

Overtime Rate (BDT)BDT 100 / hr

Hourly Rate

৳BDT

Presets:

Short Duty Deduction0 / 0 active

When working time is less than standard duty (9h 10m), deduct shortfall from total overtime.

FPC

OVERTIME REPORT

Monthly Attendance & Overtime Calculation Sheet — November 2026

Standard Duty: 9h 10m

OT Rate: BDT 100 / hr

Print Date: 03/11/2026

Employee Name: —

Employee No/ID: —

Designation: —

Card No: —

Present / Off Days

0 Days / 0 Off

Gross Overtime (+)

+0h 00m

Short Duty Minus (-)

0h 00m

Net Total Overtime

0h 00m(0.00 hrs × ৳100)

Total Payable (BDT)

BDT 0.00

Date	Day	In Time (12h)	Out Time (12h)	Duty Time	Overtime / Short	Minus / Edit Action
Monthly Total (0 Working Days, 0 Off Days):				0h 00m	0h 00m	BDT 0.00

Calculation Formula: Gross Overtime (0h 00m) = Net Overtime (0h 00m / 0.00 hrs) × Rate (BDT 100)

Net Overtime Payable: BDT 0.00

Employee Signature

Prepared / Checked By

Approved By