Tired of manually computing Form 7 after downloading from the biometric?
(27,000 + 2,000) Γ· 22 Γ· 8 Γ· 60 Γ 47 = ?
β
β±129.07 β
The answer Β· with schooldtr
The same biometric download fills Form 7. Absences are grouped into date ranges, undertime is shown in hours and minutes, and each deduction is computed from Basic Salary + PERA Γ· 22 days Γ· 8 hours Γ· 60 minutes.
See it in motion
Still re-typing every employee's DTR at the end of the month?
Retype DTR #37 of 48
β
48 DTRs ready β
The answer Β· with schooldtr
Print CS Form 48 for one employee or the whole school in one go , with official hours, holidays, leave, travel and undertime already written in.
See it in motion
Copying punches from the biometric printout one by one?
Copy 7:27, 12:01, 12:58β¦
β
Imported β
The answer Β· with schooldtr
Upload the Excel file your biometric device already gives you. Every employee's time-in and time-out is read in , matched by Biometric ID.
See it in motion
Still counting minutes late with a calculator?
8:20 β 7:20 = ?
β
Late 1 h β
The answer Β· with schooldtr
Every punch is checked against the position's schedule, and the same minutes go on the DTR and Form 7 .
See it in motion
Double taps messing up the A.M. arrival and departure?
07:27, 07:27, 07:28
β
AM In 7:27 β
The answer Β· with schooldtr
Repeated taps are dropped , and every punch lands in the right slot using fixed time windows.
See it in motion
Counting leave days by hand, and forgetting to skip the weekend?
Oct 1β6 = 6 days
β
4 working days β
The answer Β· with schooldtr
Saturdays, Sundays and holidays are skipped , a half-day holiday counts as half, and the inclusive dates are written on CS Form 6 for you.
See it in motion
Official travel and trainings showing up as absences?
Absent
β
Travel at Division Office β
The answer Β· with schooldtr
The day reads as travel or training on the DTR, counted as present, not absent , and Form 7 leaves it out.
See it in motion
Writing the monthly Certification of Submission from scratch?
Typing the listβ¦
β
Ready to sign β
The answer Β· with schooldtr
Pick a department and untick whoever hasn't submitted. The Certification of Submission and Non-Submission come out ready to sign .
See it in motion
Finding out who's always late only when the year is over?
Year-end tally
β
Any month β
The answer Β· with schooldtr
See absences, late arrivals and leave use for any month , and print a report with the findings already written.
See it in motion
Imported the wrong file or the wrong month?
wrong-file.xlsx
β
Erased β
The answer Β· with schooldtr
Reset Upload erases it in two steps , then you import the right file. Every erased time stays in the change log.
See it in motion