Skip to content
MYG / Practical guides

Attendance & payroll

Can you automate attendance without replacing Excel?

Keep the workbook. Connect the attendance work around it.

Concept illustration of biometric records passing through exception review into a spreadsheet.
Concept illustration · Records → review → workbook

By MYG Tech Solutions · Practical buying guide

Yes—when your attendance rules and workbook can be mapped reliably. A focused processor prepares the records while your team reviews exceptions.

  1. Import records

    Start with your biometric export.

  2. Review exceptions

    Keep missing punches visible.

  3. Prepare Excel

    Export into your existing format.

See the Ocean Deli walkthrough

Your spreadsheet can stay.

For Ocean Deli, MYG built a processor that pairs punches, calculates hours and flags exceptions. The output fits the existing Excel workbook, preserving its formulas and formatting.

A missing punch still needs a person.

An incomplete record stays incomplete until it is reviewed. Agree on rules for overnight shifts and cutoff boundaries, then test ordinary and unusual records before relying on the export.

What to bring to a first discussion

Use anonymized examples so we can understand the workflow without exposing employee or pay details.

  • A sample biometric export and a blank payroll workbook.
  • Your shift, break and cutoff rules.
  • Examples of missing or duplicate punches.
  • Who reviews exceptions before export.