1
Upload the attendance sheet
Column A is the serial number, column B is the worker's name, and columns C onward are dates with D, N or O. Put the month and year in the first row (for example, January 2026) so dates are written as dd/mm/yy. The result puts each worker on a single row.
Drop your Excel file here
or click to browse · .xlsx, .xls or .csv
Just testing? Download a sample attendance sheet.
Workers
0
Day shifts
0
Night shifts
0
Total payout
?0
Payroll ledger
One row for each worker.
| Worker name | Dates worked | No. of days / nights | Amount |
|---|
No day or night shifts were found. Every attendance cell is either blank, O, or an unrecognised code.
Per-worker summary
Also included as a second sheet in the downloaded Excel file.
| Worker name | Days | Nights | Absent | Total days / nights | Amount |
|---|
2
How each code is paid
Codes are read without caring about upper or lower case. Blank cells and any other code are ignored.
D
Day shift?483 per day
N
Night shift?755 per night