Missing Data report

Missing Data report

Use Missing Data to find employees with incomplete profiles, such as which employees have no bank details, TIN, SSS number or basic wage, and get the gaps filled. It shows how complete your records are, what is missing and from whom. You can fill in a field yourself or remind employees by email to add their own details.

Where: My Team › Tools & Reports, under Reports, select Missing Data

You need:

  • The My Team Reports right to open it. You see the people your access covers
  • The Missing Data Reminders right to send reminders or change reminder settings

How to find missing employee data

  1. Open the report. The score at the top shows how complete your records are, with employees with gaps and Payroll at risk.
  2. To narrow it, select Filters and choose a Subsidiary, Department, Branch or Position. Each filter shows as a chip you can remove, and Clear all removes them all.
  3. On By field, read down the groups, most serious first. Each group shows how many employees are affected and how many fields are missing. Each row shows how complete that field is, how many of how many are filled, the change since last month and how many are missing.
  4. Select a field to see exactly who is missing it, or select By employee to see every gap per person.

The By field view: the Blocks payroll group, with how complete each field is and how many are missing

By employee lists Employee, Gaps, Missing fields, Department, Branch, Employment type and Line manager. Sort by name, gaps or department. When you came from one field, the list says so, and Clear shows everyone with any gap again.

How to fix a gap yourself

  1. On By employee, find the person. You can search by name.
  2. Select Fill in. Their profile opens on the tab with their most serious gap.
  3. Enter the details and save.

For many people at once, use Profile Manager.

How to remind employees

  1. On By employee, select Remind on one row, or tick several people and select Send reminder.
  2. If you opened this list from one field, the reminder covers that field only.

Each person gets one email listing only what is missing from their own profile.

How to send reminders automatically

  1. Select Reminders. The button shows how often reminders go out, or Off.
  2. Turn on Send automated reminders.
  3. Under Frequency, choose Weekly, Fortnightly or Monthly.
  4. Under Fields to include, tick the fields. Each shows how many are missing it, and the window shows how many employees will be emailed.
  5. Select Save.

Reminder settings: turn on automated reminders, choose how often and which fields to include

⚠️ Reminders start going out once you save, to everyone missing a chosen field. Check the number first.

Without the Missing Data Reminders right you can open the settings but not change them.

How to export it

Select Export. An XLSX file downloads straight away, with one sheet per group, matching the filters, search and any field you drilled into on screen.

How the figures are worked out

Only active employees are counted. Invited and uninvited people are left out until they activate.

A field only counts where it applies. A regular employee with no contract end date is not a gap. Completeness is every applicable field filled in, divided by every applicable field across those people.

GroupPhilippinesIndonesiaOther countries
Blocks payrollTIN, SSS, PhilHealth, HDMF, RDO Code, bank account number, basic wageNPWP, BPJS Labour, BPJS Kesehatan, Family Card (KK), bank account number, basic wageBank account number, basic wage
Blocks complianceIdentification number, contract expiry date (fixed-term, project-based, seasonal, casual and contractual only), probation end date (probationary only)Identification number, contract expiry date (non-permanent only)Identification number
Blocks day-to-dayMobile phone, emergency contactMobile phone, emergency contactMobile phone, emergency contact
Nice to haveBirth date, hire dateBirth date, hire dateBirth date, hire date

Your own custom fields appear under Nice to have if they are profile fields marked required. An emergency contact counts as filled only once it has a name. A wage of 0 counts as missing.

  • Payroll at risk: people missing at least one Blocks payroll field.
  • Trend: the change since the snapshot taken on the 1st of a month. Until a second snapshot exists, it says the trend starts next month.
💡 Hire date is listed as Nice to have, but other things read it. Key dates, tenure and turnover all use it, so do not leave it until last.

What Happens Next

The report is live. A field drops off as soon as it is filled in. It only reports the gaps, and it does not stop anyone working.

Tips

  • Run it monthly. It stops a payroll run surfacing a dozen problems at once.
  • Run it before a payroll go-live, a bulk import or a first attendance period.
  • Fix by department. One group onboarded without a step usually shares the same gap.
  • Chase employees for what only they know, such as an emergency contact or a statutory number. Fill in pay details yourself.

Troubleshooting / FAQ

Q: Who is missing a bank account or TIN? On By field, select that field to see the list.

Q: Someone shows as missing data but their profile looks complete. Check which field. Statutory numbers and the bank account are on the Personal tab, not Payroll. Basic wage is on Payroll. Dates such as hire date are on Employment.

Q: A new joiner is not on the report. They are not active yet. See Invites & Activation.

Q: Send reminder is greyed out. You need the Missing Data Reminders right. An admin can grant it in My Team › User Rights.

Related articles