# Timesheets can now be generated automatically - Canonical: https://qrgate.az/en/whats-new/timesheets-can-now-be-generated-automatically - Markdown: https://qrgate.az/en/whats-new/timesheets-can-now-be-generated-automatically.md - Language: en - Date: 2026-07-18 Attendance data can now be used to prepare timesheets by month, year and branch, with Excel and PDF export options. The update moves the longest part of month-end - collecting the data - to the beginning of the process instead of the end. ## What changed Previously the timesheet started from an empty template at month-end: working days were laid out, attendance records were copied across, and leave and time off were checked separately. QRGate now forms the timesheet from the attendance records that already exist. The generation works across three dimensions: - **Month** - the reporting period. - **Year** - for returning to earlier periods. - **Branch** - a separate view where relevant. The result can be exported as Excel or PDF: Excel for finance to move into their own template, PDF for signature and archiving. ## What it gives you The change felt most is in the human role. The HR administrator no longer fills in a blank document - they review a draft. That produces three practical outcomes at month-end. Preparation time shortens, because the data is already collected. Attention shifts to the exceptions - a half day off, a swapped shift, a schedule changed mid-month - which is where most errors actually sit. And returning to an earlier period becomes easy: month, year and branch are selections rather than parts of a file name. We break the timesheet into its component blocks on the [how to prepare a timesheet](https://qrgate.az/en/how-to-prepare-a-timesheet) page, and explain the general logic of electronic records on the [electronic timesheet system](https://qrgate.az/en/electronic-timesheet-system) page. ## What it does not replace Reviewing and approving the timesheet stays with the responsible member of staff, exactly as before. The system prepares the document; the decision remains with a person, and that split is deliberate. Excel does not disappear either. It remains an output format for sharing, additional calculation and transfer into other software. Only the source changes: the master record stays in the system and the file becomes a snapshot of that moment. The internal calculation rules behind the timesheet are not disclosed in public content. ## Who benefits most The update is aimed first at teams that assemble month-end data from several sources: companies with more than one branch, sites running shift patterns, and mid-sized companies where one or two people carry the HR workload. In a single office on a fixed schedule the difference is smaller, because the data already lives in one place. We describe the wider picture on the [timesheet automation](https://qrgate.az/en/timesheet-automation) page. ## How the month-end sequence changes In practice the order becomes: records accumulate during the month, open items - pending time-off requests and correction requests - are closed in the final week, and a first draft of the timesheet is ready on the last working day. One or two days then remain for review and approval. With that sequence in place month-end stops being a rush, because the work is no longer compressed into a single day. ## Where to start One number is enough to judge the benefit: how many hours went into preparing last month's timesheet, and how many of those went into collecting the data rather than checking it? If the second number is the larger one, this update applies directly to your process. [See what QRGate can do](https://qrgate.az/en/advantages) or [calculate the price](https://qrgate.az/en). ## FAQ ### Which periods can a timesheet cover? By month and by year, with a branch selection where relevant. ### Which export formats are available? Excel and PDF. ### How is the timesheet calculated? It draws on existing attendance and work schedule data inside QRGate. The internal calculation rules are not disclosed in public content. ### Does the final check still sit with a person? Yes. The system forms the timesheet from existing records; review and approval remain with the responsible member of staff. ## Related pages - Shift worker attendance - [Markdown](https://qrgate.az/en/attendance-tracking-for-shift-workers.md) | [HTML](https://qrgate.az/en/attendance-tracking-for-shift-workers) - Electronic timesheet system - [Markdown](https://qrgate.az/en/electronic-timesheet-system.md) | [HTML](https://qrgate.az/en/electronic-timesheet-system) - Fingerprint pros and cons - [Markdown](https://qrgate.az/en/fingerprint-attendance-pros-and-cons.md) | [HTML](https://qrgate.az/en/fingerprint-attendance-pros-and-cons) - Cloud or on-premise - [Markdown](https://qrgate.az/en/cloud-or-on-premise-attendance-system.md) | [HTML](https://qrgate.az/en/cloud-or-on-premise-attendance-system) - Preparing a timesheet - [Markdown](https://qrgate.az/en/how-to-prepare-a-timesheet.md) | [HTML](https://qrgate.az/en/how-to-prepare-a-timesheet) - Timesheet automation - [Markdown](https://qrgate.az/en/timesheet-automation.md) | [HTML](https://qrgate.az/en/timesheet-automation)