Leading business applications — from ERPs & CRMs to Payroll engines — suffer from a critical operational blindspot: they do not trace time at the point of work. MS Hour bridges this gap with field-level time tracking, Certified Payroll (CA DIR eCPR, LCPtracker, eMars), Project & Job Costing, Activity-Based Costing (ABC), Multi-Tenancy, and offline-ready PWA Web Clock Kiosks.
Missing Attendance for Business Applications Certified Payroll (CA DIR eCPR, LCPtracker, eMars) Project & Job Costing Activity-Based Costing (ABC) Multi-Tenancy (Corporate → Company → Projects → Trades) Progressive Web App (PWA) & Web Clock Kiosks Dynamics 365 Business Central API v2.0 & Dataverse Microsoft 365 & Entra ID SSO Oracle Fusion Cloud & Salesforce Field Service Paychex Flex & Embedded Payroll QuickBooks Online & Xero Accounting Real-Time Attendance Monthly Board
Missing Attendance for Business Applications Certified Payroll (CA DIR eCPR, LCPtracker, eMars) Project & Job Costing Activity-Based Costing (ABC) Multi-Tenancy (Corporate → Company → Projects → Trades) Progressive Web App (PWA) & Web Clock Kiosks Dynamics 365 Business Central API v2.0 & Dataverse Microsoft 365 & Entra ID SSO Oracle Fusion Cloud & Salesforce Field Service Paychex Flex & Embedded Payroll QuickBooks Online & Xero Accounting Real-Time Attendance Monthly Board
Enterprise business systems are built for general ledgers, CRM pipelines, and retrospective pay calculations. None of them were engineered to capture real-time punches, field job costing, or prevailing wage compliance where work actually happens.
ERPs manage jobs and budgets, but employees cannot easily clock in from a job site. Managers get timesheets days or weeks late, leaving project cost overruns completely undetected until month-end.
Field technicians complete tickets, but work orders don't track apprentice ratios, overtime curves, or split hours across distinct trade classifications for certified payroll.
Without point-of-work geofencing, buddy-punching and time padding inflate payroll costs. Payroll engines cannot audit whether an hour was spent on high-margin trade work or idle time.
Small-to-mid enterprise accounting platforms leave contractors stranded when bidding on municipal contracts requiring eCPR XML filings or multi-tenant branch partitioning.
Where traditional business applications fall short, MS Hour delivers enterprise-grade depth in certified payroll, job costing, activity allocation, multi-tenancy, and field-ready PWA access.
Automate certified payroll filings for government, public works, and union projects. Complies with state and federal prevailing wage requirements without manual double entry.
Distribute every minute of clocked labor directly to contracted jobs, phases, tasks, and work breakdown structures (WBS) with real-time budget burn monitoring.
Go beyond crude overhead allocations. MS Hour assigns labor, machine, and supervisory costs to exact activities and production trades to uncover true profitability.
Architected for multi-subsidiary corporations, international conglomerates, and holding companies requiring strict entity data isolation with unified executive rollups.
A centralized attendance board (as shown in our live portal) that visualizes complete monthly attendance matrices, shift patterns, exceptions, and approval workflows.
Deploy anywhere in seconds without App Store gatekeepers. Installable on iOS, Android, macOS, Windows, wall-mounted tablets, or rugged jobsite kiosks.
A complete time-tracking, certified payroll, ABC costing, and workforce attendance fabric purpose-built to integrate with all your enterprise applications.
Zero-install PWA for mobile, tablet, and shared jobsite kiosks. Features 4-digit PIN security, offline punch queuing, GPS geofencing, QR codes, and NFC badges.
Built-in prevailing wage determination, craft classification, fringe credit accounting, and 1-click electronic filing exports for CA DIR eCPR, LCPtracker, and eMars.
Distribute labor down to specific project phases, tasks, and cost codes. Monitor live labor burn against contracted budgets to prevent overrun in real-time.
Allocate direct labor, machine hours, and operational overhead to precise activities and trades rather than blunt averages. Pinpoint true contract profitability.
Hierarchical corporate grouping (Corporate → Operating Subsidiary → Projects → Trades). Strictly isolated tenant workspaces with intercompany cross-charging.
Centralized day-by-day attendance board (as shown in our app preview) tracking daily punch states, late arrivals, early departures, overtime, and leave.
Automate rotating shifts, 24/7 coverage, split shifts, and night schedules spanning midnight. Auto-computes daily, weekly, and California overtime rules.
Multi-tier approval workflows for annual, sick, and statutory leaves. Live accrual tracking, balance forecasting, and two-way calendar sync with Outlook and Teams.
Connect seamlessly to Microsoft Dynamics 365, Microsoft 365 / Entra ID, Oracle Fusion, Salesforce Field Service, Paychex Flex, QuickBooks, Xero, and Power Automate.
Explore the authentic Monthly Board, PWA Web Clock Kiosk, Certified Payroll generator, and Business Integrations.
View and manage monthly attendance records across all employees and trades.
| EMPLOYEE | 1TUE | 2WED | 3THU | 4FRI | 5SAT | 6SUN | 7MON | 8TUE | 9WED | 10THU | 11FRI | 12SAT | 13SUN | 14MON | 15TUE | 16WED | 17THU | 18FRI | 19SAT | 20SUN | 21MON | 22TUE | 23WED | 24THU | 25FRI | 26SAT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A
Alexander Wright
Site Operations
|
||||||||||||||||||||||||||
|
A
Avery Chen
Operations Manager
|
||||||||||||||||||||||||||
|
C
Caleb Johnson
Equipment Operator
|
||||||||||||||||||||||||||
|
D
Daniel Okafor
Electrician (Prevailing)
|
||||||||||||||||||||||||||
|
D
Derek Simmons
General Labor
|
||||||||||||||||||||||||||
|
E
Emily Rodriguez
Field Inspector
|
||||||||||||||||||||||||||
|
E
Ethan Brooks
Plumber (Prevailing)
|
||||||||||||||||||||||||||
|
G
Grace Nakamura
HR Coordinator
|
||||||||||||||||||||||||||
|
H
Hannah Leclerc
Site Supervisor
|
||||||||||||||||||||||||||
|
I
Isabella Rossi
Site Supervisor
|
State & Federal Prevailing Wage Electronic Filing
Activity-Based Overhead Allocation
| Craft Classification | Trade Code | Basic Hourly Rate | Health & Welfare | Pension Credit | Training / Apprentice | Total Hourly Package | Overtime (1.5x) |
|---|---|---|---|---|---|---|---|
| Journeyman Electrician | ELEC-01 |
$64.50 | $11.20 | $8.90 | $2.00 | $86.60/hr | $118.85/hr |
| Journeyman Plumber | PLUM-02 |
$62.00 | $10.80 | $8.70 | $2.00 | $83.50/hr | $114.50/hr |
| Equipment Operator (Group 3) | OPER-03 |
$58.20 | $10.50 | $9.10 | $1.80 | $79.60/hr | $108.70/hr |
| Construction Laborer | LABR-01 |
$42.00 | $9.40 | $6.80 | $1.50 | $59.70/hr | $80.70/hr |
| Employee | Dept | Check In | Check Out | Hours | BC Project | Status | GPS | Actions |
|---|
| Employee | Regular Hrs | OT Hours | Leave Days | Absences | Project Hrs | BC Job | Approval | Action |
|---|---|---|---|---|---|---|---|---|
| Sarah Ahmad | 168.0h | 12.5h | 2 | 0 | 45.0h | J-0021 | ✓ Approved | |
| John Davis | 156.0h | 0.0h | 4 | 1 | 32.5h | J-0018 | Pending | |
| Mohammed K. | 172.5h | 20.0h | 0 | 0 | 88.0h | J-0021 | ✓ Approved | |
| Linda Park | 144.0h | 0.0h | 8 | 0 | 12.0h | J-0019 | Rejected | |
| Carlos M. | 168.0h | 8.0h | 2 | 0 | 56.5h | J-0022 | ✓ Approved | |
| Aisha R. | 160.0h | 4.0h | 3 | 1 | 28.0h | J-0020 | Pending |
| BC Job No. | Project Name | Task | Assigned To | Budget Hrs | Logged Hrs | Remaining | Status | BC Sync |
|---|---|---|---|---|---|---|---|---|
| J-0018 | Azure Migration | Task 1000 — Discovery | John Davis | 120h | 82.5h | 37.5h | In Progress | ✓ Synced |
| J-0019 | BC Implementation | Task 2000 — Setup | Linda Park | 200h | 168.0h | 32.0h | Review | ✓ Synced |
| J-0020 | Payroll Rollout | Task 1000 — Config | Aisha R. | 80h | 28.0h | 52.0h | In Progress | ✓ Synced |
| J-0021 | MS Hour Integration | Task 3000 — API Dev | Sarah Ahmad | 150h | 133.0h | 17.0h | Testing | ✓ Synced |
| J-0022 | CRM Extension | Task 1000 — Analysis | Carlos M. | 100h | 56.5h | 43.5h | In Progress | ✓ Synced |
| J-0023 | D365 FO Upgrade | Task 1000 — Planning | Mohammed K. | 300h | 88.0h | 212.0h | Planning | Pending |
| Employee | Leave Type | From | To | Days | BC Absence Code | Approver | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| Sarah Ahmad | Annual Leave | Jun 10 | Jun 11 | 2 | VACATION | HR Manager | ✓ Approved | |
| John Davis | Sick Leave | Jun 16 | Jun 19 | 4 | SICK | Sarah Ahmad | Pending | |
| Linda Park | Emergency Leave | Jun 5 | Jun 12 | 8 | EMERGENCY | HR Director | Rejected | |
| Carlos M. | Annual Leave | Jun 24 | Jun 25 | 2 | VACATION | Sarah Ahmad | ✓ Approved | |
| Aisha R. | Unpaid Leave | Jun 20 | Jun 20 | 1 | UNPAID | HR Manager | Pending |
Real-time check-in log
Payroll-ready export
OT hours & cost
BC job time analysis
Balance & usage
Location verification
Instant clock-in/out directly within Microsoft Teams, shift notifications, and manager approvals via Teams Adaptive Cards.
Automatically schedules approved leave, remote work days, and shifts straight into employees' Outlook calendars.
Unified Single Sign-On (SSO) with Microsoft credentials. Auto-sync user departments, managers, and job titles seamlessly.
Explore the actual mobile and web screens of MS Hour in action.
View and manage monthly attendance records across multi-tenant subsidiaries & trade cost centers.
| EMPLOYEE | 1 TUE |
2 WED |
3 THU |
4 FRI |
5 SAT |
6 SUN |
7 MON |
8 TUE |
9 WED |
10 THU |
11 FRI |
12 SAT |
13 SUN |
14 MON |
15 TUE |
16 WED |
17 THU |
18 FRI |
19 SAT |
20 SUN |
21 MON |
22 TUE |
23 WED |
24 THU |
25 FRI |
26 SAT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A
Alexander Wright Vancouver HQ |
✓ ↺ |
✓ ← |
✓ ↻ |
✕ | ⊘ | ⊘ | ★ | ✓ ← |
✓ ↻ |
🚩 | ½ | ⊘ | ⊘ | ✓ ← |
✓ | ✕ | ✕ | ✕ | ⊘ | ⊘ | ✕ | ○ | — | — | — | — |
|
A
Avery Chen Operations Manager |
✓ ↻ |
✓ ↺ |
✓ ↻ |
✓ ↻ |
⊘ | ⊘ | ★ | ✓ ↻ |
✓ ↻ |
✓ ↺ |
✓ ↻ |
⊘ | ⊘ | ✓ ↻ |
✓ ↺ |
✓ ↻ |
✓ ↺ |
✓ ↻ |
⊘ | ⊘ | ✓ ↻ |
✓ ↺ |
— | — | — | — |
|
C
Caleb Johnson Equipment Operator |
✓ ↺ |
✓ ← |
✓ ↻ |
✓ ↻ |
⊘ | ⊘ | ★ | ✓ ↻ |
✓ ↻ |
✓ ↻ |
✓ ↻ |
⊘ | ⊘ | ✓ ↻ |
✓ ↻ |
✓ ← |
✓ ↻ |
✓ ↻ |
⊘ | ⊘ | ✓ ↻ |
✓ | — | — | — | — |
|
D
Daniel Okafor Electrician |
✕ | ✓ ↻ |
✓ ↻ |
✓ ↻ |
⊘ | ⊘ | ★ | ✓ ↻ |
✓ ← |
✓ ↻ |
✓ ↻ |
⊘ | ⊘ | ✓ ← |
✓ ↻ |
✓ ↻ |
✓ ↻ |
✓ ↻ |
⊘ | ⊘ | ✓ ← |
✓ ↺ |
— | — | — | — |
|
D
Derek Simmons Vancouver HQ |
✓ ↺ |
✓ ← |
✓ ↻ |
✕ | ⊘ | ⊘ | ★ | ✓ ← |
✓ ↻ |
✕ | ½ | ⊘ | ⊘ | ✓ ← |
✓ ↻ |
🚩 | ✕ | ✕ | ⊘ | ⊘ | ✕ | ○ | — | — | — | — |
|
E
Ethan Brooks Plumber |
✓ ↻ |
✓ ← |
✓ ↻ |
✓ ← |
⊘ | ⊘ | ★ | ✓ ↻ |
✓ ← |
✓ ↻ |
✕ | ⊘ | ⊘ | ✓ ← |
✓ ↻ |
✓ ← |
✓ ↻ |
✓ ↻ |
⊘ | ⊘ | ✓ ↻ |
○ | — | — | — | — |
|
G
Grace Nakamura HR Coordinator |
✓ ↺ |
✓ ← |
✕ | ✓ ↻ |
⊘ | ⊘ | ★ | ✓ ↻ |
✓ ↺ |
✓ ↻ |
✓ ↻ |
⊘ | ⊘ | ✓ ↻ |
✓ ↻ |
✓ ↻ |
✓ ↻ |
✓ ↻ |
⊘ | ⊘ | ✓ ↻ |
○ | — | — | — | — |
|
H
Hannah Leclerc Site Supervisor |
✓ ↻ |
✓ ↻ |
✓ ↻ |
✓ ← |
⊘ | ⊘ | ★ | ✓ ↻ |
✓ ← |
✓ ↻ |
✓ ↻ |
⊘ | ⊘ | ✓ ↺ |
✓ ↻ |
✓ ↻ |
✓ ↻ |
✓ ↻ |
⊘ | ⊘ | ✓ ↻ |
✓ ↺ |
— | — | — | — |
|
I
Isabella Rossi Site Supervisor |
✓ ↻ |
✓ ← |
✓ ↻ |
✓ ↻ |
⊘ | ⊘ | ★ | ✓ ↺ |
✓ ← |
✓ ↻ |
✓ ↻ |
⊘ | ⊘ | ✓ ← |
✓ ↻ |
✓ ↻ |
✓ ↻ |
✕ | ⊘ | ⊘ | ✓ ← |
✓ ↻ |
— | — | — | — |
| Employee | Check In | Status |
|---|---|---|
| Sarah Ahmad | 08:55 AM | ✓ In |
| Mohammed K. | 08:48 AM | ✓ In |
| John Davis | 09:18 AM | Late |
| Linda Park | — | Leave |
| Employee | ID | Department | Shift | Check In | Check Out | Hours | BC Project | GPS | Status |
|---|---|---|---|---|---|---|---|---|---|
| Sarah Ahmad | EMP-001 | Engineering | 08:00–17:00 | 08:55 AM | — | — | J-0021 | 📍 Verified | Present |
| Mohammed K. | EMP-002 | Engineering | 08:00–17:00 | 08:48 AM | — | — | J-0021 | 📍 Verified | Present |
| John Davis | EMP-003 | Finance | 08:00–17:00 | 09:18 AM | — | — | J-0018 | 📍 Verified | Late |
| Linda Park | EMP-004 | HR | 08:00–17:00 | — | — | — | — | — | On Leave |
| Carlos M. | EMP-005 | Sales | 09:00–18:00 | 08:52 AM | — | — | J-0022 | 📍 Verified | Present |
| Aisha R. | EMP-006 | Operations | 08:00–17:00 | 09:01 AM | — | — | J-0020 | 📍 Verified | Present |
MS Hour acts as the missing real-time time & attendance bridge, feeding verified field hours, certified payroll rates, and job costing into your enterprise business applications.
Every MS Hour module maps to certified REST API endpoints, with Dataverse as the unified data layer.
| MS Hour Module | BC API Endpoint (v2.0) | Method | Dataverse Table | Sync Type | Azure Service | Status |
|---|---|---|---|---|---|---|
| 👤 Employee Master | /companies({id})/employees | GET | cdm_worker | Batch Daily | Azure Data Factory | ✓ Live |
| ⏱ Attendance / Time Reg. | /employees({id})/timeRegistrationEntries | POST/GET | ms_attendance | Real-time | Azure Functions | ✓ Live |
| 🏗 BC Projects (Jobs) | /companies({id})/projects | GET | cdm_project | Hourly Sync | Logic Apps | ✓ Live |
| 📋 Project Task Lines | /projects({id})/projectTaskLines | GET | cdm_task | Hourly Sync | Logic Apps | ✓ Live |
| 🏖 Leave / Absence | /employees({id})/employeeAbsences | POST/GET | ms_leave | Event-driven | Service Bus + Fn | ✓ Live |
| 💰 Payroll Journal | /companies({id})/journalLines | POST | ms_payrollentry | On-demand | Azure Functions | Beta |
| 🏢 Companies / Branches | /companies | GET | cdm_company | Batch Daily | API Management | ✓ Live |
| 📊 Dimensions (Cost Centers) | /companies({id})/dimensions | GET | ms_dimension | Batch Daily | Data Factory | Planned |
| 📦 Custom MS Hour API (AL) | /api/mshour/hr/v1.0/.../msAttendance | GET/POST | ms_attendance | Real-time | BC AL Extension | ✓ Live |
Built on Microsoft Azure — fully managed, secure, scalable middleware connecting MS Hour to D365 BC and Dataverse.
All API calls authenticated via Microsoft Entra ID (Azure AD) with OAuth 2.0 Client Credentials flow. JWT validation at APIM gateway.
Azure Functions (.NET 8 Isolated) handle transformation, business rules, BC webhook processing, and async queuing via Service Bus.
Dataverse as unified HR data store with custom ms_attendance, ms_leave, ms_shift, ms_timesheet tables. BC data via Virtual Tables.
Power BI Embedded for real-time dashboards. Application Insights for API telemetry. Azure Monitor for alerts and SLA tracking.
Register app in Microsoft Entra ID. Configure BC API access. Validate OAuth 2.0 token flow.
Create custom Dataverse tables: ms_attendance, ms_shift, ms_leave, ms_timesheet, ms_overtime.
Azure Functions for BC↔Dataverse transformation. Service Bus for async. Durable Functions for approvals.
Configure real-time, batch, and event-driven sync. Full integration testing with BC sandbox.
Deploy to production Azure with App Insights, Power BI dashboards, and 24/7 alert monitoring.
Predictable per-workspace and user pricing with full access to PWA kiosks, certified payroll, ABC costing, and business application connectors.
"MS Hour filled the biggest operational hole in our enterprise software. Attendance was completely untraced in the field. Now our certified payroll filings for CA DIR and LCPtracker are 100% automated with zero manual re-entry."
"The job costing and ABC costing tools gave us visibility we never had in our ERP. Seeing labor burn rates updated in real-time as workers punch the PWA kiosk stopped job cost overruns in their tracks."
"We manage 6 subsidiaries under one corporate entity. MS Hour's multi-tenancy and shared kiosk PIN mode made field check-in effortless for our electricians, plumbers, and operators."
Deploy MS Hour across your job sites and business applications in under 2 hours. Full multi-tenancy, PWA kiosks, and certified payroll ready.
Have questions about connecting MS Hour to your business apps, prevailing wage compliance, or multi-subsidiary setup? We're here to help.
Online · Avg reply < 1 min
Instantly deploy MS Hour with multi-tenancy, PWA clock kiosks, and certified payroll — directly connected to your business applications.