Hidroteknik Software

Automated Collections Tracking

In internal use

Reconciliation, payment requests, and delay tracking

Web

A collections system that watches open receivables in the ERP every day, finds late payers by itself, and sends reconciliations by e-mail and payment requests over WhatsApp automatically.

Screenshots

Automated Collections Tracking - screenshots 1Automated Collections Tracking - screenshots 2Automated Collections Tracking - screenshots 3Automated Collections Tracking - screenshots 4

At most companies, collections tracking is an Excel file and someone’s memory: who pays late, when was the last reminder sent, has the balance been reconciled? This system takes the job over end to end. Account movements are pulled from Mikro ERP every day; for each customer it computes open invoices, maturity aging, and the weighted average days of delay.

Reconciliation takes one click: the customer receives an e-mail with their balance and a signed, time-limited link, and presses Approve or Dispute; a dispute can carry a note and a screenshot. The system counts the 8-business-day statutory period itself, skipping public holidays, and collects the replies in a separate panel.

Payment requests go out through WhatsApp’s official business API and/or e-mail, with a PDF account statement and a short link. Payments made afterwards are matched document by document.

The real power is the automation: thresholds decide who gets a message and when - minimum balance, minimum average delay, and minimum overdue amount. You pick the channel (e-mail, WhatsApp, or both), the frequency (daily, weekly, monthly), the hour, and business days only. A new rule can first run in trial mode so you see what it would send; every run is logged with a summary.

Because this is financial data, security was designed in from day one: two-factor authentication, login history, and per-user and per-IP lockouts against brute-force attempts.

Highlights

  • Daily account and invoice data from Mikro ERP
  • Maturity aging and average days of delay
  • E-mail reconciliation: Approve / Dispute link, 8-business-day tracking
  • Payment requests over WhatsApp (official API) and e-mail + PDF statement
  • Threshold-based automation: balance, delay, overdue amount
  • Trial mode and run logs
  • Automatic document-level payment matching
  • Two-factor authentication and login lockout