You want to know at month-end how many visitors came through the gate and why, who is still inside, which work permits have expired, and which guard worked the most night shifts, without leafing through the gate book. The free gate and security sheet does that: you log visits, permits and shifts and the counts and alerts appear on their own. The template and its page are in Arabic.
The problem it solves
A paper gate book records visits but cannot tell you who has not left, how long a contractor stayed, whether a maintenance worker's permit is still valid, or who has too many night shifts.
How the sheet works
- In Units write each unit code, resident name and phone.
- In Visitors log date, time in, name, unit code, purpose (visit, delivery, maintenance, contractor, other), plate and guard. On exit just add the time out.
- In Permits log worker, contractor and permanent-delivery permits with start and end dates.
- In Shifts write the guards and pick a code per day: M morning, E evening, N night, R rest.
- In Settings set today's date and the first day of the month, then open Summary.
How the numbers are worked out
- Resident name is looked up from the unit code; an unknown code shows "unit not registered".
- Visit duration = time out - time in, in minutes, blank until the exit is written.
- Inside shows on every row with no time out.
- Permit status: valid if today falls between start and end, expired if past the end, not started if before the start.
- A guard's working days = morning + evening + night; rest days do not count.
Example from the sample data
Names are invented; October 2026, as-of date 2026-11-01:
- Visitors in the month: 13: 4 visits, 4 deliveries, 2 maintenance, 2 contractor, 1 other.
- Average duration: 132.9 minutes over 12 completed visits; the longest was a finishing contractor, 08:15 to 16:45, 510 minutes.
- Still inside: two: a visitor logged in on 30 October with no exit, and one who arrived today.
- Visitors today: 2 (maintenance and a visit).
- Permits: 5: 3 valid, 1 expired (water delivery, ended 2026-10-15), 1 not started (begins 2026-11-10).
- Shifts: the top night guard has 19 night shifts and 25 working days, then 13, then 5.
Using the online version
The sheet page opens on this example. Type in the white cells and the numbers update instantly; import your own xlsx, export your work, or download the original Excel file. Your data stays in your browser. More templates are in the templates list.
When it is not enough
It holds 2000 visits, 300 units, 200 permits and 30 guards, one person edits at a time, and it cannot notify a resident of a visitor. To tie units to cars and stickers use the residents and vehicles register. If you need a gate app with a login per guard and resident alerts, Softwiro can build one your way.
FAQ
How is visit duration worked out? Time out minus time in, in minutes, blank until the exit is written.
How is permit status decided? By comparing the as-of date in Settings with the permit's start and end.
Should I record national ID numbers? No. The log does not need them; write name, purpose and plate only.