# Montron PM-Tool

> Office and controlling platform that brings mobile-captured site reports, time-and-material slips and GPS trip data together in the office, validates them automatically, allows corrections and processes them into audit-proof, approved hour and service records — including a controlling dashboard and PDF generation.

Client / context: Montron GmbH
Role: Concept, architecture, development & operations (backend, web app, cloud infrastructure)
Status: Live

## Outcome

Field data turns into automatically validated, audit-proof approved hour and customer records in the office — with live controlling instead of manual Excel analysis and days of rework.

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](https://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

| Area | Technologies |
|---|---|
| Backend | Java, Spring Boot, Spring Security, Spring Data JPA, Spring WebFlux, Flyway |
| Database | PostgreSQL (AWS RDS) |
| Cloud storage | AWS S3 |
| PDF generation | openhtmltopdf, PDFBox, jsoup (HTML-to-PDF pipeline) |
| Authentication | Firebase Authentication, Multi-Factor Authentication (TOTP), OAuth2 Resource Server |
| Web app | Next.js, React, TypeScript, Tailwind CSS, shadcn/ui, TanStack Query, React Hook Form, Zod, Recharts |
| API documentation | OpenAPI / Swagger (springdoc) |
| CI/CD | GitHub Actions, AWS App Runner (backend), AWS Amplify (web, SSR) |
| Cloud platform | AWS (App Runner, RDS, S3, ECR, CloudWatch), Firebase (Auth) |

---

*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.*

## Technologies

- Java
- Spring Boot
- Next.js
- TypeScript
- PostgreSQL
- AWS S3
- AWS App Runner
- AWS Amplify
- Firebase Auth
- Recharts

## Relevant links

- [HTML version](https://monadion.com/en/work/montron-pm-tool)
- [English overview (llms.txt)](https://monadion.com/en/llms.txt)
- [Full AI context](https://monadion.com/en/llms-full.txt)
- [Book an analysis call](https://monadion.com/en/booking)
- [Contact](https://monadion.com/en/contact)

## Related

- [All projects](https://monadion.com/en/work.md)