Export Loyverse Employee Shift Logs to an Excel workbook for Payroll

The Scenario

HR sent a message this morning: they need the March 2024 shift export from Loyverse for payroll processing. Formatted. Hours as decimals. Both locations combined. By 3 PM.

The store manager has Loyverse access. She knows the shift data is there. She's never exported it.

The bad version:

• Log into Loyverse. Find the shifts report. Filter to March 2024. Export.
• Open the CSV in Excel. Duration is in seconds. Convert to hours: divide by 3600. Apply to 200+ rows.
• The export has separate files for each location. Combine them manually. Reconcile the column headers, which differ slightly between the two exports.
• It's 2:50 PM. The combined file is done but the decimal hours formula broke on 6 rows that had overnight shifts crossing midnight.

Payroll runs on schedule regardless. The data needs to be right.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It fetches shift records from Loyverse for any date range and writes them in whatever format payroll needs — hours as decimals, both locations combined, no manual conversion.

Open the SheetXAI sidebar and paste this prompt:

Export all Loyverse shift records for March 2024 into Excel 'Payroll' sheet — include employee_id, employee_name, clock_in, clock_out, and hours_worked

What You Get

• Every shift record from March 2024 written to the 'Payroll' worksheet, one row per shift.
• hours_worked calculated as a decimal (e.g., 7.5 for a 7.5-hour shift), not in seconds.
• Both locations included — no separate exports to combine.
• clock_in and clock_out formatted as readable timestamps.

What If the Data Is Not Quite Ready

Payroll needs the data summarized by employee

Export all Loyverse shifts for March 2024 — write to 'Payroll Summary' with one row per employee: employee_id, employee_name, total_shifts, total_hours_worked — sort by employee_name

You need the store split into separate worksheets

Export all Loyverse shifts for March 2024 — write to two worksheets: 'Main St Payroll' for the Main Street location and 'Westside Payroll' for Westside — each with employee_id, employee_name, clock_in, clock_out, hours_worked

You want anomalous shifts flagged for HR review

Export all Loyverse shifts for March 2024 into Excel 'Payroll' — flag any rows where hours_worked is greater than 12 or less than 0.5 in column F with 'Needs review'

Full payroll-ready export in one shot

Export all Loyverse shifts for March 2024 into Excel 'Payroll' with employee_id, employee_name, clock_in, clock_out, hours_worked (decimal), store — sort by employee_name then clock_in — add a totals row at the bottom with total hours for all employees

Try It

Get the 7-day free trial of SheetXAI and open a blank Excel workbook at 9 AM, then ask SheetXAI to pull the March shift records from Loyverse in the format payroll needs — done before lunch. See also export customers for CRM and the Loyverse integration overview.