Montron PM-Tool — Office & controlling platform for working time, time-and-material and fleet

End-to-end designed, developed and operated web platform that acts as the office counterpart to the Montron Solutions mobile app: it takes the data captured in the field, reconciles it with GPS trip data, lets the office review and correct it, and produces approved, billable records from it.

🌐 Live at: www.montronpmtool.at

Starting situation

With mobile capture the raw data is digital — but the real work begins in the office: hours have to be checked, reconciled with the actual trips, corrected, approved and turned into records for payroll and customer billing. Usually this happens in Excel: manual, error-prone, without an audit trail and without an overview of what is really open, faulty or already approved.

Solution

A multi-tenant web platform that covers exactly this office process — from automatic import of field data through plausibility checks against GPS trip data, a traceable correction and approval workflow, to audit-proof PDF generation and a controlling dashboard for management.

Core building blocks

1. 3-column day detail (site report + time-and-material slip + GPS Streetwatch)

Per employee and day, the site report (times, vehicle plate, comment), the time-and-material slip (customer assignment, service items) and the GPS trip data are shown side by side. Editing happens inline with auto-save; corrected values are clearly marked (the original stays visible, struck through).

2. Immutable correction layer

The original data from the mobile app stays untouched. Every correction is stored separately with a full audit trail (who, when, original vs. corrected value) — traceable and audit-proof.

3. GPS / fleet integration (Streetwatch)

Vehicle GPS data is imported, condensed into trips and analysed for business use: automatic derivation of work start/end (company address vs. construction-site logic), kilometres driven, driving times and overnight stays — as a reconciliation basis for the captured hours.

4. Backend & cloud

Connects everything in the background: data import, validation, PDF generation, audit-proof storage and security. Scales automatically and is continuously developed further.

What the platform delivers

Automatic data reconciliation & validation

• Import of mobile-captured site reports and time-and-material slips via a secured service interface to the Montron Solutions platform
• Reconciliation of site report ↔ GPS trips ↔ time-and-material slip (times, plausibility)
• Background checks automatically mark days as "OK", "Notice" or "Error"
• Austrian public holidays taken into account in the working-time logic

Review, correction & approval workflow

• Inline correction with auto-save and visible change history
• PIN-secured approval (4-digit, hashed PIN, lockout after failed attempts, audit trail)
• On approval an immutable snapshot is created — the approved state remains audit-proof

Records & PDF generation

• Monthly employee reports aggregating hours, days and key figures
• Hour record (for payroll) and customer record (services per client)
• Manager report as a compact management PDF
• Automatic, server-side PDF generation; storage in the cloud

Controlling dashboard

• KPIs at a glance: approved days, captured hours, overtime (50 % / 100 %), days with errors, open/under review
• Monthly development, division and client distribution, monthly heatmap
• Fleet metrics: total km, driving time, overnight stays, vehicles in use
• "Needs attention" list with a direct jump into the day detail

Employee, customer & multi-tenant management

• Multiple companies on one platform — strict data separation per tenant
• Employee and customer management, CSV import, roles (admin / user / viewer)
• Firebase login with email verification and multi-factor authentication (TOTP) for admin accounts

Operations & integration

• Separate test and production environments (backend & web)
• Guided setup wizard: connection to the mobile backend via service token, takeover of existing admin accounts
• API interfaces and audit-proof storage in the cloud

Outcome

• Field data is validated automatically in the office instead of being reworked manually in Excel
• Hours are plausibility-checked against real GPS trips — fewer errors, higher billing accuracy
• Audit-proof approval with an immutable snapshot and a complete correction history
• Ready-made records at a click: hour record, customer record, management report
• Live controlling for management instead of month-end surprises
• Multi-tenant, automatically scaling and continuously developed further

Tech stack

This project shows Monadion's ability to deliver a complete office and controlling platform end-to-end from existing field data: data integration, validation logic, correction and approval workflow, reporting and PDF pipeline, cloud infrastructure and ongoing operations — from a single source.