Reports and exports

Attendance lists every shift in the dates you pick: who came in, when, and how the shift counted. Export turns the same records into a file for your accountant or payroll tool.

The attendance list

Open Attendance.

1. Date Range. It opens on the last 30 days.
2. Employee. One person, or everyone.
3. Search by name.
4. Export. See Export.
5. Present, Late, Absent and Overtime count the rows. Click one to show only those rows. Click it again to show all.
6. Shift Status says how the shift counted: On Time, Late, Early Out, Absent, Rest Day OT, a holiday, or a leave.
7. The row's menu. See below.

Pick All Locations in the sidebar to see every location at once. A Location column is added.

Managers can open Attendance too. See Sharing a Location.

Fix a row

1. The amber mark means this overtime is not approved yet. It is not paid.
2. Review overtime opens the request so you can approve it. It shows only on rows with overtime that is not approved.
3. Change shift sets the shift the employee actually worked that day. The status and overtime are counted again. When the hours look far off, the same button sits next to the menu.
4. Edit attendance changes the clock-in and clock-out. On an absent row, it reads Add attendance.
5. Delete attendance removes the row. You type the name and date to confirm.

Export

Click Export and pick a format. The file uses the dates, the employee, and the count you picked, for the location in the sidebar. The search box does not change it.

• Standard Excel — one sheet per employee, day by day, with pay totals.
• Payslip Spreadsheet — one payslip per employee. Deductions are blank for you to fill.
• Accountant Spreadsheet (PH) — one row per employee, grouped the way a Philippine bookkeeper expects.
• Generic CSV — one row per employee per day, with every field.
• QuickBooks Time CSV — for a QuickBooks timesheet import. Regular and overtime hours are on separate lines.
• Sprout-compatible CSV — for a Sprout import. Each employee needs an employee code. Check the columns against your Sprout template first.

The Payroll page has the same menu. See Payslip and export.

A manager's file has the hours and no pay.

The Standard Excel file

Each sheet covers the dates you picked, up to today. It has a row for every clocked shift and every scheduled day.

Holiday rows are yellow. Leave rows are violet. Rest days are blue. Absent days are red.

Columns that need a word:

• Approved Hours — the hours that count for pay, after late, undertime, approved leave and approved overtime.
• Day Type — Ordinary, Rest Day, a holiday type, or a mix such as Regular Holiday + Rest Day.
• Late (hrs) — late arrival plus undertime.
• Overtime Status — approved, pending, or rejected. Only approved overtime is paid.
• Night (hrs) and Night OT (hrs) — hours inside the night window. Set it in Location Settings → Payroll → Night pay.

Under the rows come Total Working Hours, Total Statutory OT, Total Paid Leave when there is any, then Pay Rate and Total Gross Pay. Pay Categories groups the hours by day type. Pay Breakdown shows each pay line as hours × multiplier × rate.

If you need another format, tell us. See How do I contact support?.