Client
RS Brawijaya
Healthcare — Hospital Finance Operations
Challenge
What needed to change
RS Brawijaya's hospital information system records patient billing independently from the Odoo back-office that posts the financial entries a day later. The two systems occasionally drifted apart, especially around bill closing — mismatched line counts, missing postings, or figures that didn't add up — and catching these discrepancies meant someone manually cross-checking spreadsheets.
Solution
What Tijari delivered
Tijari built a dedicated reconciliation bot that normalizes records from both systems into a common structure and matches them two ways: billing records with no matching Odoo entry, and Odoo entries with no matching source record, catching both missed postings and potential double-postings. Matching runs on a composite key of visit reference, item, and amount, so duplicate line items within the same bill are still handled correctly. The bot runs every night at midnight and sends a discrepancy report directly to the finance team's Telegram.