# When Does an Excel Timesheet Stop Working? Common Errors and a Guide to Reliable Attendance Records

> An Excel timesheet works for a small team, but shifts, overtime and missed clock-outs soon create errors. How to build a sound sheet and when to move on.

Source: https://digitalbridge.com.tr/en/blog/excel-timesheet-limits.html
Publisher: Digital Bridge Teknoloji (https://digitalbridge.com.tr)
Topic: Access Control & Attendance
Published: 2026-10-23 · Updated: 2026-10-23

An Excel timesheet is a manually maintained spreadsheet that records each employee's working days, leave, absence and overtime for the month in rows and columns. It is perfectly adequate for a small team on a single shift. Once shifts, night work, contractors and several entrances are involved, entries turn into guesswork and formulas become fragile; at that point the timesheet should be generated automatically from card reads.

## Key takeaways

- A well-built Excel timesheet works reliably for a small team with one shift and one entrance.
- The problem is not Excel itself but hand-copied reads, formulas that break silently and closed months that can still be edited.
- Spreadsheet researcher Ray Panko argues that a large spreadsheet is very likely to contain at least one incorrect bottom-line value.
- Consider attendance-system-based timesheets once shift rotation, night shifts, contractors or a second entrance appear.
- Moving on does not mean abandoning Excel: you still export the locked timesheet as Excel or CSV.

## Why are Excel timesheets so common?

A [timesheet](https://digitalbridge.com.tr/en/glossary.html#timesheet) is the core input to payroll, and in most small and mid-sized firms the first one is born in Excel. Templates are free, everyone knows the software and the first month looks tidy. Someone in HR or accounts merges door logs, leave forms and the supervisor's notes into one workbook at month end.

That works as long as headcount is low, there is one shift and one entrance. We cover how overtime itself is calculated under Turkish law in our guide to [timesheet and overtime calculation](https://digitalbridge.com.tr/en/blog/timesheet-overtime-calculation-turkey.html). This article focuses on when the spreadsheet behind that calculation stops being trustworthy.

## Where do Excel timesheet errors come from, and what do they cost?

Most errors are not carelessness; they come from the shape of the process. Reads are pasted from one system, leave is typed in from another file, a formula is overwritten by hand in one row, and nobody notices.

Ray Panko, who has studied spreadsheet errors for many years, argues in [What We Don't Know About Spreadsheet Errors Today](https://arxiv.org/abs/1602.02601) that errors are rare per cell, yet a large spreadsheet is very likely to contain at least one incorrect bottom-line value, and that companies are highly overconfident in their spreadsheets. On a timesheet, that one wrong value lands directly in someone's pay.

> Data quality expert Thomas C. Redman estimates the cost of bad data at **15% to 25% of revenue** for most companies. ([MIT Sloan Management Review, "Seizing Opportunity in Data Quality", 2017](https://sloanreview.mit.edu/article/seizing-opportunity-in-data-quality/))

A timesheet error has three costs: over- or under-payment, lost trust with staff and weak evidence in a dispute. Türkiye's [Labour Law No. 4857](https://www.mevzuat.gov.tr/mevzuat?MevzuatNo=4857&MevzuatTur=1&MevzuatTertip=5) generally caps the working week at 45 hours and regulates overtime separately; a file that can be edited after the fact struggles to show those hours were recorded correctly.

## What are the typical Excel timesheet mistakes?

The table below summarises the mistakes we see most often and how each one affects payroll.

| Mistake | How it happens | Effect on payroll |
|---|---|---|
| Missing read filled in by guess | No clock-out, so "the usual time" is typed | Fictional hours, open to challenge |
| Double read counted twice | Card presented twice in a row, both imported | Inflated or broken hours |
| Night shift lands on the wrong day | A 22:00–06:00 shift is split across two dates | Missing day, wrong overtime |
| Leave counted as absence | Sick or administrative leave never entered | Unfair deduction |
| Formula overwritten | A number typed over a formula cell | Silently wrong total |
| Closed month edited | Workbook changed after payroll has run | Payroll and timesheet disagree |
| Versions multiply | "timesheet_final_v3.xlsx" circulates by email | Nobody knows which file is current |

What these share is a gap between the source of the record (the read at the door) and the calculation (Excel). We look at the same gap in general work tracking in [when to replace spreadsheets with software](https://digitalbridge.com.tr/en/blog/outgrowing-spreadsheets.html).

## How do you build a sound Excel timesheet?

If it is not yet time to move on, harden your workbook like this:

1. **Keep raw data on its own sheet.** Paste door or card reads unchanged into a "Reads" sheet and calculate elsewhere.
2. **Write the rules in one place.** Shift start, breaks, lateness tolerance and overtime threshold belong on a single "Rules" sheet that formulas refer to.
3. **Lock formula cells.** Use sheet protection so only input cells are editable.
4. **Never guess a missing read.** Mark an empty clock-out as "missing" and record the correction, with its reason, in a separate column.
5. **Code your leave types.** Enter annual, sick, compassionate, unpaid and administrative leave with distinct codes so none counts as absence.
6. **Close the month.** When payroll goes out, archive the sheet as a PDF and make the editable copy read-only.
7. **Watch the 45-hour week.** Show a weekly total in its own column and use conditional formatting to flag anyone over the threshold.

These steps reduce the risk but do not remove it: reads are still copied by hand, and anyone with edit rights can rewrite history. Remember too that attendance data is employee personal data; for workbooks travelling by email, see our guide to [employee personal data under KVKK](https://digitalbridge.com.tr/en/blog/employee-personal-data-kvkk.html).

## When should you move from Excel to a time and attendance system?

If two or more of these apply to you, the Excel timesheet is no longer carrying the load:

- You run shift rotation or night shifts.
- You have several doors, sites or construction entrances.
- Contractor staff use the same entrance.
- Month-end close takes several days.
- Employees regularly dispute their timesheet.
- Data is re-keyed into payroll software by hand.

At that point a [time and attendance system (PDKS)](https://digitalbridge.com.tr/en/glossary.html#pdks) compares reads with the shift plan and produces the timesheet itself. We explain the concept in our [time and attendance system guide](https://digitalbridge.com.tr/en/blog/time-attendance-system-guide.html) and cover shift-specific cases in [shift attendance tracking](https://digitalbridge.com.tr/en/blog/shift-attendance-tracking.html).

We gather the selection criteria in [choosing time and attendance software](https://digitalbridge.com.tr/en/blog/choosing-time-attendance-software.html); setting the warning signs above against those criteria makes the decision easier.

## How does SmartPass make this easier?

[SmartPass](https://digitalbridge.com.tr/en/smartpass.html) is the card access control and time and attendance product in Digital Bridge's Smart360 family. When a card is presented, the server decides whether to grant access; reads become a timesheet according to the shift plan, and the closed month is exported to ERP. The merging you do by hand in Excel happens at the source.

Take a concrete case: a 180-person plant on three shifts, with two contractor firms using the same gate. In the Excel days, HR spends the first week of every month moving door logs into a workbook. With SmartPass:

- **Double reads are filtered out.** Repeat reads within three seconds never reach the timesheet, and the same input always produces the same result.
- **Night shifts roll into the next day.** A 22:00–06:00 shift is calculated as one shift rather than split across two calendar dates.
- **Missing reads are never guessed.** The day is flagged "missing read"; an authorised person adds a correction with a reason, which does not delete the original read and can be undone.
- **Leave is not counted as absence.** Annual, sick, compassionate, unpaid and administrative leave are kept separate, and there is a 45-hour weekly warning threshold.
- **The month is locked.** No correction can be written to a closed month; the lock opens only with a stated reason, which is itself recorded in the audit log.
- **Exports come from the locked month.** A monthly per-person summary (employee number, department, cost centre and durations in minutes) is downloaded from the panel as CSV or pulled as JSON via the API; every download appears in the export history.

Your Excel habits are not wasted either. The staff list can be uploaded from an Excel or CSV file with a preview, and timesheet summaries, day-by-day breakdowns and absence reports export to Excel, PDF and CSV. See the details on the [SmartPass product page](https://digitalbridge.com.tr/en/smartpass.html), and the payroll hand-off steps in [time and attendance payroll integration](https://digitalbridge.com.tr/en/blog/time-attendance-payroll-integration.html).

## How does Digital Bridge help?

Moving from Excel to a time and attendance system is more than installing software. Digital Bridge first surveys your existing doors, turnstiles and readers on site; SmartPass's fixed terminal is brand-independent and works with relay-triggered hardware, so existing equipment can often be reused. We cover the hardware side on our [card access control](https://digitalbridge.com.tr/en/industrial-products/card-access-control.html) page.

We then define your shift rules, leave types and staff and card lists together, and run the first month-end close with you, so your last Excel month and first SmartPass month can be compared side by side. For HR and payroll processes more broadly, see our [HR, payroll and personnel management](https://digitalbridge.com.tr/en/software-solutions/hr-payroll-personnel-management.html) service.

## What is the next step after an Excel timesheet?

Start by applying the seven-step structure above to your current workbook and counting how many of the warning signs apply. If it is more than two, note the last three months' timesheet disputes and how long month-end close took, and use them to prepare for a quotation meeting. For sites without fixed gates, our guide to [construction site access and attendance](https://digitalbridge.com.tr/en/blog/construction-site-access-attendance.html) will help; every access control and attendance article is gathered in our [Access Control and Time Attendance hub](https://digitalbridge.com.tr/en/blog/topic/gecis-kontrol.html).

SmartPass is priced by quotation, based on the number of access points, the number of people and the hardware required. To buy, complete the [SmartPass sales form](https://smart360.com.tr/teklif-iste?urun=smartpass); explore every feature on the [SmartPass page](https://digitalbridge.com.tr/en/smartpass.html), or reach us through our [contact page](https://digitalbridge.com.tr/en/contact.html).

## Frequently Asked Questions

### Is an Excel timesheet legally valid in Türkiye?

There is no requirement to keep a timesheet in any particular tool, so an Excel timesheet can be used. What matters is that the record is accurate, consistent and has not been altered afterwards. In a dispute, records signed by the employee or with a visible change history carry more weight. Freely editable files can be weaker in that respect, so take legal advice if you are unsure.

### How do you calculate a night shift in an Excel timesheet?

Record a night shift as one entry belonging to the day it started. For a 22:00–06:00 shift, for example, use a formula that adds one day to the clock-out time when it is earlier than the clock-in, or simply =MOD(out-in,1). The real risk is reads being split by calendar date, which makes one day look short and the next look like overtime. Keeping shift definitions on a separate sheet reduces that error.

### At what headcount does an Excel timesheet become inadequate?

There is no fixed number; complexity matters more than headcount. A small team with one shift and one entrance can be run comfortably in Excel. With shift rotation, night work, contractor staff or several entrances, errors multiply even in smaller teams. A month-end close that takes several days is another reliable warning sign that the spreadsheet has reached its limits.

### What should go on the timesheet when a card read is missing?

Not an estimated time. Flag the day as a "missing read", and have the employee's manager or another authorised person add the actual time as a separate correction with a reason. The original read should never be deleted, and it should be clear who made the correction and why. That way, if the record is challenged later, it is obvious exactly what changed.

### Do we have to give up Excel completely when moving to SmartPass?

No. SmartPass generates the timesheet from card reads itself, but reports still export as Excel, PDF or CSV, and the CSV file is formatted so that Turkish Excel opens it directly. The staff list can also be bulk-uploaded from Excel or CSV. The difference is that Excel stops being where the calculation happens and becomes the output format of a locked timesheet.

### How does SmartPass send the timesheet to payroll software?

Once a month is locked, SmartPass produces a monthly per-person summary file from the locked timesheet. It contains employee number, department, cost centre and durations in minutes. The file is downloaded from the panel as CSV or retrieved as JSON through the API. Every download is shown in the export history together with the time and the user who made it.