Payroll Preview
See what payroll will look like before you run it. Payroll Preview turns real clock-in/out data into per-employee pay estimates, flags problems early, and exports clean reports for your finance team. This is the first phase of TalentHR Payroll—full payroll runs and payslips are on the way.
What this feature does
Payroll Preview calculates estimated pay from actual attendance, so you stop rebuilding payroll in spreadsheets every month.
Set each employee's pay type—hourly, daily, or monthly—and rate, in VND or USD
Bulk-edit compensation across many employees at once, with company-wide defaults for new hires
Preview estimated pay for any period: this month, last month, or a custom date range
Calculate pay automatically from real worked hours and worked days
Prorate monthly salaries when employees take unpaid leave or join mid-period
Flag issues before payday—missing checkouts, zero-hour days, unpaid leave, and anomalies
Expand any employee to see a day-by-day breakdown of hours and pay
Export a two-sheet Excel report (summary plus a full audit log) for finance
When should you use this feature?
You rebuild payroll in Excel every month from attendance exports and chat messages
You only discover missing checkouts or unpaid leave after payslips go out
You manage a mix of hourly, daily, and monthly staff and the math gets messy
You pay teams in more than one currency and conversions cause errors
You want finance to review estimated pay before any money moves
You need a clean, auditable payroll report to hand to an accountant
Problems this feature helps solve
Payroll is rebuilt by hand in spreadsheets every cycle
Pay is calculated automatically from the attendance you already track
Pay errors are only caught after payday
Issues like missing checkouts and unpaid leave are flagged in the preview, before payout
Hourly, daily, and monthly staff need different formulas
One screen handles all three pay types, with proration for monthly salaries
Mixed-currency teams cause conversion mistakes
VND and USD are kept separate with correct rounding—totals never mix currencies
No way to verify pay before committing to it
Finance reviews a full estimate, employee by employee, before anything is finalized
Handing payroll to an accountant means re-entering data
Export a summary and audit log to Excel in one click—no re-typing
How this fits into TalentHR
Payroll Preview is powered by the data you already capture in TalentHR:
Attendance Tracking
Real check-in/out records and worked hours feed every pay estimate—no manual timesheets
Request Management
Approved leave is reflected in pay; unpaid and pending leave are flagged so estimates stay accurate
Employee Records
Compensation is stored per employee, linked to their profile and department
Calendar
Working days and holidays shape expected hours used to prorate monthly salaries
Frequently Asked Questions
Does Payroll Preview actually pay my employees?
Not yet. This first phase produces accurate pay estimates and exportable reports so you can review and process payroll with confidence. Locked payroll runs, payslips, and payment processing are planned for upcoming phases.
How is estimated pay calculated?
It depends on the pay type. Hourly = worked hours × rate. Daily = worked days × rate. Monthly = the flat salary, optionally prorated by credited days ÷ expected days when an employee misses time.
Which currencies are supported?
VND and USD, each with correct rounding rules. Totals are grouped per currency and never mixed together.
What kinds of issues does it flag?
Errors that block accurate pay (no compensation set, more than 24 hours in a day), warnings to review (missing checkout, zero hours, unpaid leave pending review), and informational notes (paid leave, auto-checkout applied).
Can I preview a future period?
Yes, but future days are shown as projections only and export is disabled, since those hours have not happened yet.
What's in the Excel export?
Two sheets: a Summary with one row per employee (with working SUM formulas) and an Audit log with one row per issue per day, color-coded by severity for easy review.