Domain billing and reconciliation
Openprovider: Invoice reconciliation
Cross-source invoice reconciliation for supplier billing, customer invoices, WHMCS data, and domain events
Context
Supplier invoices, customer invoices, WHMCS records and domain provisioning events describe the same business activity in different ways. Finance needs to reconcile those records despite inconsistent line descriptions, currencies and billing periods. Unmatched items need enough source context for someone to investigate them.
System and approach
CrossCheck brings parsed invoices and domain events into a common reconciliation flow. Matching proceeds through exact, fuzzy and context-aware stages, with confidence determining which records need human review. Domain billing rules, currency normalization and pro-rata charges are handled alongside the matching logic.
- Ingest supplier and customer invoices with WHMCS, MySQL, and domain events.
- Apply exact, fuzzy, and context-aware matching in deliberate stages.
- Carry confidence, currency conversion, and pro-rata handling through reconciliation.
- Present finance exceptions with source records and matching context.
Delivered scope
The work covers data ingestion, matching logic and a finance exception dashboard. Source records remain available when a match needs investigation.
Technology
- Python
- FastAPI
- MySQL
- Pandas
- Celery
- Redis