Four records an HR head is asked to explain
Each one ends in a count someone asks for: leavers by line, hours by worker, the payroll total, grievances closed. The answers sit in a biometric export, an OT register, an Excel payroll and a grievance box log.
Operators leave, and the average hides the supervisor they left
Every month the lines lose trained operators. HR screens and inducts walk-ins, and the line runs below target while the new hands learn their machines. The leaver list, the exit-interview forms and headcount against sanctioned strength sit in three places, so attrition gets reported by department. The one supervisor who drives people out is lost in the average. The playbook says to read attrition by supervisor.
About 4–7% a month
Attrition among garment workers in India, high against other South Asian sourcing countries, from Technopak’s research with Indian factories for a 2018 Ministry of Textiles study.
Source: Ministry of Textiles, Government of India (study by Technopak), Study on Garment Sector to understand their requirement for Capacity building (opens in a new tab), 2018.
Attendance and overtime that do not match the hours worked
Biometric punches, a paper OT register, gate passes and a separate Sunday log each tell a slightly different story. Punch times edited in the attendance software, and OT kept in a separate book, make the daily record hard to trust. Hours above the legal or buyer cap stay hidden until an auditor sets the records beside worker interviews. The timekeeper, the HR head and the compliance head all answer for the gap.
16%
Share of Cambodian garment factories assessed in 2024 whose working-time records did not reflect the hours actually worked. Sunday work was often logged apart from the main time log.
Source: Better Factories Cambodia (ILO and IFC), Annual Report 2024: An Industry and Compliance Overview (opens in a new tab), 2025.
Payroll for thousands, built in Excel, and a total that moved
The payroll officer builds each month’s sheet from attendance, OT, leave pay, piece rates, incentives, attendance bonus, loan recoveries and EOBI, PESSI, SESSI or EPF deductions. When the total moves from last month, the HR head must say why before Finance books it. Paying an operator into a same-name colleague’s account is a process gap. The playbook says a first-month pay error loses trust that is hard to win back.
37%
Share of Cambodian garment factories assessed in 2024 found not paying correctly for annual leave. 35% did not pay correctly for special leave periods.
Source: Better Factories Cambodia (ILO and IFC), Annual Report 2024: An Industry and Compliance Overview (opens in a new tab), 2025.
Grievances, training and statutory status, wanted on audit day
A buyer’s auditor asks for the grievance register with closure dates, training records by worker and topic, and who is registered with EOBI, SESSI or PESSI, EPF or ESIC. These sit in a box log, binders and a tracker one officer keeps. When that officer is on leave, nobody can say what is filed and what is pending. The playbook reads an unused grievance box as no trust, not as no problems.
6%
Share of Better Work Bangladesh factories with an effective grievance handling mechanism in 2022, as Better Work judged it. One in four was non-compliant with grievance requirements.
Source: Better Work Bangladesh (ILO and IFC), The Impact of Better Work Bangladesh: Legacy through a decade (2014–2023) (opens in a new tab), 2024.
From the biometric export to the grievance register
The agent works from the attendance exports, payroll sheets, trackers and forms HR uploads or connects, and names the rows or files behind each answer. Messages and tracker updates wait as drafts until an admin approves or declines them.
Absenteeism and OT hours, counted from the attendance export
Answers with sources
Upload the attendance export for a section or a week as an Excel or CSV file; a table holds up to 5,000 rows. Name a line and a date or week label as the export writes it, and the agent counts rows marked absent or late, or sums the line’s OT hours. From an uploaded weekly hours sheet, it finds a line’s highest weekly hours. The absenteeism rate is two counts from the same rows, and every figure points back to them.
Ask“How many absent marks did sewing line 4 have in week 44, out of how many attendance rows for that line and week? Cite the rows.”
A payroll variance, split into the inputs that moved
Answers with sources
Upload this month’s and last month’s payroll sheets. The agent sums overtime, incentives, attendance bonus, loan recoveries and statutory deductions for each month from the rows. It counts the workers on each sheet and sets the two months side by side, so you see which input moved the total. It does not run payroll or work out anyone’s pay.
Ask“Payroll for the knitting unit rose in October. Sum OT, incentives and deductions for September and October, and count heads in each.”
Exit interviews and HR SOPs, quoted with the file
Reads your documents
Upload exit-interview forms, your HR SOPs and the buyer codes of conduct you work to. Ask what leavers from finishing said about their supervisor, or what a buyer’s code says about weekly hours, and the agent quotes the passages and names each file. A typed form can be searched; a photo of a filled-in form has no text to read.
Ask“What did leavers from the finishing section say about their supervisor in their exit interviews this quarter?”
The HR pages of the audit pack, built as real sheets
Creates files
Before a buyer audit, ask for training completion by section and topic, or an extract of the grievance register with received and closed dates. The agent counts completions from the training records sheet you upload, lists each grievance as recorded, and builds the spreadsheet. Ask it to add a column for this month’s joiners and it edits that part of the sheet it made, with each revision kept and attributed.
Ask“Make a sheet of fire drill, COC and anti-harassment training for the sewing section, with who is still outstanding.”
Statutory tracker updates and the CFO email, run only if approved
Acts in your tools
Upload this month’s EOBI or ESIC challan as a text PDF and ask for the matching update to your statutory tracker in Google Sheets. The agent drafts the filing date and status as the challan shows them. The playbook says a filing at risk goes to the HR head and the CFO the same day. Ask, and it drafts that email, to go from Gmail or Outlook. An admin approves or declines each draft, and each runs only if approved.
Ask“Mark the September EOBI filing as done in the tracker from this challan, and draft a note to the CFO on the SESSI filing still pending.”
Payroll day, a long-hours month and the attrition review
The payroll total moved before Finance books it
Payroll officer
It is Day 28 and payroll is calculated. The knitting unit’s October total is higher than September’s.
Asks
“October payroll for the knitting unit is up on September. Sum OT pay, incentives, attendance bonus and deductions for both months, and count heads in each.”
The agent
Reads the September and October payroll sheets uploaded to HR, using the first sheet of each workbook. Sums each component for each month from the rows and counts the workers on each sheet. Sets the two months side by side and names the table and rows behind every figure. Where a component has no column, it says so. It never recomputes anyone’s pay or supplies a wage rate.
Result
The payroll officer sees which input moved the total, with the rows to check, and explains it to the HR head before the sheet goes to Finance for booking and payment.
Sewing lines run past the weekly hours cap
HR officer
Sewing lines 4 and 6 have worked Sunday shifts for three weeks, and the buyer’s social audit is next month.
Asks
“From the weekly hours sheet, show the highest weekly hours on sewing lines 4 and 6 in weeks 42, 43 and 44, then draft a note to the compliance head with the figures.”
The agent
Reads the weekly hours sheet uploaded to HR. If one column holds weekly hours with OT included, it finds that column’s highest figure for each line and week, citing the rows; if OT has its own column, it says so, as it cannot add columns row by row. It sets the figures against the playbook’s 60-hour cap, or a stricter buyer-code limit uploaded to HR, and drafts the Outlook email to the compliance head, as the playbook’s 48-hour escalation asks.
Approval
The HR head, as department admin, approves or declines the email. The email is sent only if approved, and the decision is kept in the audit trail under the HR head’s name.
Result
Weekly hours line by line with the rows behind them, and an email to the compliance head naming the long-hours lines in writing, which goes out from Outlook only if the HR head approves it.
Attrition read by supervisor, not by department
HR head
The monthly review is tomorrow, and sewing lines 3, 4 and 7 lost more operators in October than in any month this year.
Asks
“For the supervisors on sewing lines 3, 4 and 7, count each one’s October leavers, with their exit reasons, beside their headcount. Make it a sheet for the review.”
The agent
Reads the joiner and leaver register and the headcount sheet uploaded to HR. If the register has a month column holding October, it counts each named supervisor’s October leavers, citing the rows; with only leaving dates, it lists the October rows. Beside each go the exit reasons as recorded and the headcount figure. The sheet notes the playbook’s bands for the HR head to apply. Above 5% a month sustained, investigate; above 8%, crisis-level intervention.
Result
The review sets the three supervisors side by side and starts from the one whose line is losing the most people, with the exit reasons as recorded rather than management’s impression.
Published figures on turnover, overtime and absence
These figures come from ILO and Better Work reports on garment factories in Myanmar and Cambodia, each cited at the source. None is a Mavick result. A pilot baselines your own attrition, absenteeism and hours, then reads them again.
Fewer trained operators to replace
US$759,983 a year
Estimated yearly cost to recruit and train 6,060 replacement workers in 14 surveyed garment factories in Myanmar, where turnover averaged 54.17% over the past 12 months.
How the agent helps
The agent does not predict who will leave. When you ask, it counts leavers and exit reasons for the supervisors you name from your joiner and leaver register, with each supervisor’s headcount beside them as your headcount sheet records it; HR works out the rate. It quotes what leavers said in typed exit forms, so the review starts at the line where people are leaving.
Track: Blue-collar attrition % a month, by supervisor
Source: International Labour Organization (ILO), Skilled Workers Matter: The business case for addressing absenteeism and turnover in Myanmar’s garment sector (opens in a new tab), 2020.
Weekly hours checked line by line against the cap
59%
Share of Cambodian garment factories assessed in 2024 found non-compliant with keeping overtime within the national legal limit of two hours a day. That is a daily limit; the playbook’s cap is weekly, 60 hours including OT.
How the agent helps
The agent reads the hours you record; it is not connected to the gate or the biometric machine. When you ask, it sums OT by line and finds the highest weekly hours in your uploaded sheet, citing the rows, then drafts the escalation the playbook asks for. A department admin approves or declines that note, and it is sent only if approved.
Track: Weekly working hours including OT, against the 60-hour cap
Source: Better Factories Cambodia (ILO and IFC), Annual Report 2024: An Industry and Compliance Overview (opens in a new tab), 2025.
Absence counted by line, from the attendance export
US$10,710 a year per factory
Estimated yearly cost of unplanned absence and sick leave per factory, across 14 surveyed garment factories in Myanmar where workers averaged 3.68 days of absence a year.
How the agent helps
When you ask, the agent counts present and absent by line and by date from the attendance export you upload, citing the rows. Ask for absence by date and a religious or cultural day missing from the holiday list stands out; the playbook says to adjust the calendar with the worker council, and never to confuse attendance with productivity.
Track: Absenteeism %, by line (playbook target 6% or less)
Source: International Labour Organization (ILO), Skilled Workers Matter: The business case for addressing absenteeism and turnover in Myanmar’s garment sector (opens in a new tab), 2020.
What to baseline before a pilot
Measure each one before the pilot starts, then again at its end.
| KPI to baseline | Why it matters |
|---|---|
| Blue-collar attrition % a month | The playbook reads it by supervisor, not by department. A sustained rate above 5% means investigate; above 8% calls for crisis-level intervention. |
| Absenteeism % | The playbook’s target is 6% or less, reported daily by line. It is two counts from the attendance rows, so a pilot can baseline it from the first week’s export. |
| Weekly working hours including OT | The playbook caps the week at 60 hours, or the stricter of local law and the buyer’s code, with OT paid at twice the ordinary rate under the Factories Act. Its target is 100% conformance. |
| Statutory-compliance % | The playbook’s target is every filing deadline met. A deadline at risk goes to the HR head and the CFO the same day, because one missed filing damages trust with regulators for years. |
| Grievance closure within SLA | The playbook’s target is 95% or more: a first response within 3 working days, resolution in 14 days and root-cause closure in 30. |
| Payroll accuracy % | The playbook’s target is 99.8% or better. For an error in a worker’s first month, its rule is to apologise, correct it, and apply your over-payment policy if you have one. |
What the agent works from
Records it reads
- Employment contract
- Attendance register
- Payroll sheet
- Training plan
- Statutory filings and challans
- Grievance register
- Joiner and leaver register
- Exit-interview form
In your ERP
The factory’s ERP connection gives the HR agent no records: no attendance, no payroll, no headcount. Its records come from the attendance and payroll exports you upload as Excel or CSV, the trackers you keep in connected Google Sheets, and the emails it reads in Gmail or Outlook when asked.
One ERP connection serves the whole factory: SAP Business One, SAP S/4HANA, Odoo, Oracle NetSuite, Microsoft Dynamics 365, WFX Cloud ERP or Datatex NOW. This agent reads only the records named above; we check yours on the call.
In your tools
When asked, reads your statutory tracker or hours log in Google Sheets, finds your labour consultant’s emails in Gmail and reads recent Outlook mail. Drafts tracker updates, emails to the CFO or consultant, and WhatsApp Business or Slack notes to supervisors. Each draft waits for an admin to approve or decline it; nothing is written or sent unless approved.
Tools named today: Gmail, Outlook, Google Sheets, Slack and WhatsApp Business.
Never made up
- Salary figures, wage rates or payroll amounts
- Attendance records, leave balances or overtime hours
- Disciplinary outcomes or grievance conclusions
- Statutory contribution amounts or registration numbers
If it is not in your connected data, the agent says so.
Belongs to another department
- Incentive scheme design and the SMV basis behind itIndustrial Engineering
- Payroll booking and payment releaseFinance & Accounts
- Social-compliance audit findingsCompliance & Sustainability
- Site safety incidentsHealth, Safety & Environment
What the Human Resources playbook covers
SOP: a grievance from the box to closure
The playbook puts a grievance box on every floor, reviewed weekly, with an anonymity option. It sets a first response within 3 working days, resolution within 14 days and root-cause closure within 30. The grievance register records the date, the complaint, its owner and the closure.
Decision rule: an attrition spike in one department
Break it down by supervisor, not by department: the playbook says most spikes trace to one supervisor’s behaviour. Exit-interview data is the source of truth, not management’s impression. Pareto the exit reasons by supervisor.
KPI: weekly hours including overtime
No more than 60 hours a week including OT, or the stricter of local law and the buyer’s code of conduct, with OT paid at twice the ordinary rate under the Factories Act. The target is 100% conformance. A sustained breach on any line goes to the HR head and Compliance within 48 hours.
Edge case: two operators with one name
Two operators share a name but have different IDs, and one is paid into the other’s account. The playbook treats it as a gap in the payroll process and adds a check at issuance: the bank account is matched to the worker ID before pay goes out.
Written as general textile practice and reviewed by four independent AI models. Not yet signed off by a human subject-matter expert. Upload your own SOPs and standards, and every answer shows which source it used.
Ten questions it ships with
The template’s starter questions. Your team can edit them, or ask in its own words.
Attendance for a section
Show attendance for this section over the last week — present, absent, and late — and the absenteeism rate.
Open hiring requisitions
Which hiring requisitions are open, what does each role require, and how long has each been open?
What drove a payroll variance
Payroll moved this month against last. Show which inputs drove the variance — headcount, overtime, incentives, or deductions.
Statutory compliance status
What is the current status of our EOBI, SESSI and provident fund registrations and contributions? Show what is filed and what is pending.
Training due or completed
Which training is due or completed for this section, and who is still outstanding?
Attrition by department
Show attrition by department for this quarter, and tell me where it is highest and how it has moved.
Overtime hours this month
How many overtime hours were recorded this month, by section, and how does that compare with last month?
Grievance status
What does the record show for this grievance, what steps have been taken, and where does the process stand?
Headcount against sanctioned
Show current headcount against sanctioned strength by department, and where the gaps are.
Contracts expiring soon
Which employment contracts are due to expire in the next few months, and in which departments?
Human Resources: questions before a demo
Our attendance comes off a biometric machine, and the OT register is on paper. Can the agent use them?
It uses what is exported or typed. Mavick does not connect to biometric or time-attendance machines. Export the punches to Excel or CSV and upload them, or keep attendance in a connected Google Sheet, and the agent answers from those rows; from an upload it also counts and sums. A hand-written OT register, or a photo of one, has no text to read. Once the register is typed into a sheet, the agent can answer from it.
Does it read the HR or payroll module in our ERP, and who else sees our payroll sheets?
No. The factory’s ERP connection gives the HR agent no records at all, from an HR module or any other, so it works from the payroll sheets and attendance exports you upload and the trackers you keep in connected Google Sheets. Salaries and bank details reach it only in a sheet HR uploads or connects. Payroll sheets, exit forms and the grievance register uploaded to HR stay inside HR; the sewing or finance agent cannot open them, and people invited to other departments never see HR’s workspace.
Can it screen walk-in candidates or rank CVs?
No. It does not screen, score or rank candidates, and the hiring decision stays with your team. From your requisition sheet it answers which requisitions are open, what each role needs and the date each was opened, as the sheet records it. From a typed skill-test sheet you upload, it counts who passed on each machine type, citing the rows. From the joiner register, it can build the induction list for the week’s joiners as a sheet.
We pay 6,000 workers. Can it take a whole month’s payroll at once?
Not as one table. The agent calculates from an uploaded table of up to 5,000 rows, and each file can be up to 10 MB. Upload payroll by unit, section or payroll group, with the data on the first sheet of each workbook, because that is the sheet used for sums and counts. The agent then totals each part from its own rows. It does not run payroll or release payments: booking and payment release belong to Finance & Accounts.
Can workers ask the agent about their leave, or raise a grievance on WhatsApp?
No. The agent is for the HR team you invite by email, who ask in their own Mavick workspace. It is not a worker helpline or a grievance channel, and nobody chats with it over WhatsApp. It can draft a WhatsApp Business message, such as a note to a line supervisor, which is sent only if an admin approves it. Your grievance box, register and anonymity rules stay as they are.
Can it file our EOBI, PESSI, SESSI or ESIC contributions?
No. It does not log in to the EOBI, PESSI, SESSI, EPFO or ESIC portals or pay a challan. It reads the challans and filing receipts you upload as text PDFs, and the statutory tracker you keep. From them it tells you what is filed and what is pending, citing each record. It can draft the tracker update or an email to your labour consultant, which runs only if an admin approves it. It never makes up a contribution amount or a registration number, and it knows current rates only from a document you upload.
Bring Human Resources. We’ll build it on the call.
Book a 30-minute demo (opens in a new tab)- support@mavick.si
- Demo calendar
- calendly.com/safock/30min (opens in a new tab)