Payroll Layouts: Understanding each of the Events – Day.io

Payroll layouts in Day.io allow exporting time records in a format required by payroll systems such as TOTVS, SAP or FPW.

For each layout you select which events will be included in the export file.

Events represent categories of hours, deductions or requests and map your time‑tracking data to specific fields in your payroll system.

Below is a comprehensive list of all events available, with their meaning and when to use them.

The list below explains each event and their meaning.

Accumulated bank – Negative – Total negative hour‑bank balance accumulated up to the final date.
Accumulated bank – Positive – Total positive hour‑bank balance accumulated up to the final date.
Total accumulated bank – Total hour‑bank balance (positive + negative) up to the final date.
Positive bank (period) – Positive hours generated only within the selected period.
Negative bank (period) – Negative hours generated only within the selected period.

Overtime – Total overtime hours worked within the period.
Missing hours after compensation – Hours missing after applying hour‑bank compensation and approved absences.
Absences (days) – Total days of absence taken within the period.
Missing hours before compensation – Hours missing before applying hour‑bank compensation.
Missing days in hours – Converts missing full days into hours.
Missing hours for incomplete shifts – Hours missing in days with at least two clock‑ins (entry and exit).
Total worked hours – Actual hours worked, independent of scheduled hours.
Total days worked – Sum of days with both entry and exit punches

Total delay hours – Duration of delays (entry or return from break).
Entry delays (no break) – Delays on clocking in, ignoring breaks.
Total number of delays – Number of delay occurrences for entry and return from breaks.
Unused breaks – Hours of scheduled breaks that were not taken.

Early departures (no break) – Difference between scheduled exit time and actual early exit.
Total early departures – Number of early departures (start of break counts as an exit).
Total hours of early departures – Total hours the employee left before the scheduled time.
Total deduction – Deduction applied to rigid schedules due to delays or early departures.

Total DSR – Number of weekly rest days earned (one per full week without absence).
DSR deduction – Deduction of weekly rest day when there is an absence in the week.

Medical absences (hours) – Hours of absence due to health reasons.
Total days of medical absence – Days of absence due to health reasons.
Vacation – days – Days of vacation taken.
Health requests – days – Days of health requests.
Health requests – hours – Hours of health requests.
Other requests – days – Days of requests in the Other category.
Other requests – hours – Hours of requests in the Other category.
Custom requests – days – Days of requests from customized categories created in the Request Tool.
Custom requests – hours – Hours of requests from customized categories.

Cross shift interval – Total rest hours between shifts; Brazil's labor requires a minimum of 11 hours.
Night shift X% (reduced) overtime – Overtime hours worked at night using reduced hours and applying the night premium percentage.
Night shift X% (reduced) no overtime – Hours worked at night using reduced hours, not counting overtime.
Night shift (hours) – Total night hours for calculating the night premium (e.g., 22h–05h).
Night shift (reduced hours) – Night hours calculated using the reduced‑hour formula (1h = 52m30s).
Night shift (Holidays) – Hours worked at night on holidays.
Night shift (Reduced minus regular) – Difference between reduced hour and regular hour; can be exported as sexagesimal or decimal.
Night shift without overtime – Night hours worked without counting overtime.
Night shift (Overtime) – Overtime performed during the night period.
Night shift X% – Hours worked at night according to the configured night premium percentage.
Holidays worked – days – Days of holidays worked.
Holidays worked – hours – Hours of holidays worked.

On‑call – Total hours on call (standby).
On‑call activation (hours) – Hours actually worked after being called while on call.
On‑call (no activation) – Hours on call without being called to work.

Select only the events that apply to your company to avoid generating unnecessarily large files.
Coordinate with your payroll team to map the event codes correctly to the payroll system.
Test the layout with a small sample of employees before using it company‑wide, ensuring the events are mapped correctly.

Keep an internal spreadsheet listing all events used by your company and their corresponding payroll codes.
Review the event list periodically, especially after changes in labor laws or internal policies.
Create different layouts for distinct scenarios (e.g., termination, monthly payroll) and document each configuration.

Do I need to include every event? No. Include only events that represent data used by your payroll; unnecessary events may be omitted.
Can I rename events? No. Event names are fixed to ensure correct integration with the payroll system.
How do I know each event’s code? Codes are defined by your company’s payroll system. Contact your payroll department to obtain each code.
What are “reduced hours”? In Brazil, night work is calculated using reduced hours where 1 hour equals 52 minutes 30 seconds. Day.io converts this automatically when you select reduced‑hour events.

Related articles