Success Story

Automated Nightly Reconciliation Between Hospital and Finance Systems for RS Brawijaya

Tijari built a nightly reconciliation bot that compares hospital billing records against Odoo finance postings and flags mismatches from both directions, replacing a manual spreadsheet cross-check with an automatic report delivered straight to Telegram.

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.