Glossary:
Account receivable : JLN term JLN Process - Accounts receivable
Account payable: JLN term Accounts payable
outbound invoice, aka invoice: invoice that openIMIS send to some other third parties
inbound invoice, aka bill: invoice that openIMIS recieves from some other third parties
outbound payment, aka bill payment: payment that openIMIS send to some other third parties Payment to providers
inbound payment aka invoice payment: payment that openIMIS recieves from some other third parties like Premium collection and Funding
Models
The concept is to use a widely use format as base. inspiration can form FHIR invoice and SAGE API Invoices. openIMIS is not an accounting system therefore generating book and ledger is not in the project scope but invoice are a good representation for the payable mentioned above. To bring flexibility, a JSON fields was added to the invoice line in case a structured details is required.
The link with the Source and actor won’t be in a form a database foreign keys because those could be from different table.
bills
field | type | comment |
HistoryBusinessModel fields | ||
subject | json | referenceActor { "label":"", "code":"", "type": "batchRun/commissionOverview/capitationReport", "id":"UUID", "address":{"text":"",...} } |
sender | json | referenceSource { "label":"", "code":"", "type": "HF/Insuree/PH/payer/user", "id":"UUID", "address":{"text":"",...} } |
code | str | or reference for the insurance |
code_rcp | str | or reference for the recipient |
code_ext | str | if required for external system integration such as payment systems |
date_due | date | date on which the payment is due |
date_invoice | date | Date of the “invoice“ |
validFrom* | date | invoice covering service/item from |
validTo* | date | invoice covering service/item to |
date_payed | date | Date on which the payment was actually documented as Done |
amount_discount | float | total of the detail discount |
amount_net | float | Total without tax |
tax_analysis | json | tax details { "lines": [ {"label":"", "rate":"", "base":"", "amount":""}] … ], "total":"" } |
amount_total | float | total net + tax total |
status | int | ENUM (module configuration): draft, validated, payed, cancelled, deleted |
currency_rcp_code | str | currency of the recipient (if different) |
currency_code | str | currency of insurance |
note | bigttext | |
terms | bigttext | conditions |
billLineItems
to document the content for the bill
field | type | comment |
code | str | reference |
HistoryModel fields | ||
billId | UUID | reference to bill |
description | str | |
details | json | depend of the type, TBD |
ledger_account | int | from config |
quantity | float | |
unit_price | type | |
discount | float | to document difference between the std price and the price to be paid, useful for relative pricing |
tax_rate | Calculation uuid | Calculation to calculate the tax |
tax_analysis | json | tax details { "lines": [ {"label":"", "rate":"", "base":"", "amount":""}] … ], "total":"" } |
amount_total | float | net +tax |
amount_net | qty * unitprice - discount |
billPayments
To document the payment done on the invoice. out of scope: a payment done for 2 invoice, to support such scenario an “generalPayment“ table need to be created, this table will have sub table with relationships to billPayments, once the reconciliation between the different invoice will be done.
field | type | comment |
HistoryModel fields |
| |
Status | int | Accepted / Rejected |
code_ext | str | payment reference |
label | str | label of the payment |
code_rcp | str | Reference from the payment system / bank |
billId | UUID | reference to bills |
code_receipt | str | receipt number |
amount_payed | float | Amount that need to be matched against business items (fees might be added if there were removed before reaching the system) |
fees | float | |
amount_recieved | float | Amount that is received (may include or not the fees) |
date_payment | date |
billEvents
this table will log the event relating to the invoice
field | type | comment |
HistoryModel fields |
| |
billId | UUID | reference to bills |
type | int | Message / Status / Warning / Payment / Payment error |
data | json | Payload linked to type (TODO) |
[out of scope]billdocuments
This should be managed by a document management module
Integration points:
Services
o billPaymentSent
o billPaymentRejected
o billPaymentRefunded
o billCreate (called on save)
o billUpdate (called on save)
o billDelete
o billItemCreate
o billItemUpdate
o billItemDelete
o billAmend
o billValidateItems
o billMatchItems
bill Payment specific modules (Calculation rules)
those calculation rules modules structure
models: none
services: 1 per signal listened
converters: one converter from another openIMIS object to invoice
parameters: on for the “recipient” and “subject“ on the invoice
change might be required in the calculation module to save it in dedicated fields instead of json_ext OR we move those in the json ext fields
support search on those parameters
Listening to other modules signal are strikethrough because during the migration not all update will happens through modular therefore such trigger will complexity the invoice creation processes
Fee-for-service
Registration on signals from other module(existing or not):
billCreationFromCalculation
Only the “valuated“ claims are eligible for bill generation meaning that the batch run might be triggered before in case .
[nice to have]Ideally the “batchrun“ would be rename “close accounts payable”, closing account will be on a defined scope and be available from the thee dots menue
billCreationFromCalculation will have a variable that will tell the signal listener to be activated or not: this will be activated for “fee-for-service“
Converter
[to be updated]
two way of creating the accountPayable are possible for the valuation, in both case there will be one “accountPayable” per HF
One asset (line) per claim, claim details as asset description: claimed amount as unit price, net amount as net price, discount calculated based on net and unit price
one asset (line) per item or service with claim detail as asset description: item/service claimed unit price as unit price, net as valuated price, quantity as quantity, discount calculated based on net and unit price
Capitation
Registration on signals from other module(existing or not):
billCreationFromCalculation
Batch run might be required upfront to have the relative indexes calculated / all claim valuated where there is relative prices.
billCreationFromCalculation will have a variable that will tell the signal listener to be activated or not: this will be activated for “capitation“
Converter
[to be updated]
two way of creating the accountPayableare possible for the capitation, in both case there will be one “accountPayable” per HF
one asset (line) per weighted indicator I for product P : Allocated contribution/ Sum(indicator for P) as unit price , indicator I as quantity, (1-weight) as discount;
Population living in catchments area of the health facility
Number of families living in catchments area of the health facility
Insured population living in catchments area of the health facility
Insured number of families living in catchments area of the health facility
Number of claims (contacts) with the health facility by insured in the catchment area
Adjusted amount
asset (line) per product with the detail of the calculation as asset description
Commission
Converters
one accountPayable per EO,
one asset (line) per product/commission, sum of policy value as quantity, commission as unit price, product account code as ledger account
one asset (line) per policy : policy value as quantity, commission as unit price, product account code as ledger account (dependent detail as asset description)
Payment fees
Converter
one accountPayable per type of payment (TBC)
one asset (line) per product/commission, sum of policy value as quantity, Payment fees as unit price, product account code as ledger account
one asset (line) per policy : policy value as quantity, Payment fees as unit price, product account code as ledger account (dependent detail as asset description)
[OUT OF SCOPE]Insuree cash transfet
converter
one accountPayable per insuree (for all dependant), one line per cash payment (level of Item and service)
one accountPayable per period, one line per cash payment claim
Approach
[to be updated]
area: if not national, will take only the product define on the level selected or below
type: the type below could be checked
supplier payment method (notion not yet existing)
Claim valuation (fee for service - batchRun): https://openimis.atlassian.net/browse/OTC-10
Capitation payment: https://openimis.atlassian.net/browse/OTC-10
operation fee payment method (notion not yet existing)
Commission payment:
Payment fees
insuree Cash payment (doesn’t exist yet)
an account payable param report will be generated for each of the bellow Item when required by the payment method
Product / payment period for “supplier payment method”
actor / payment period for “operation fee payment method”
insuree for the insuree payment period
[out of scope]new signals are use to trigger action in another module:
o [one signal per service]
o billValidated (all billItemMatched and billItemAmountValidated)
o billFullyPaid
Create a FHIR interface for the accounting systems
Here the FHIR ressource to be used:
https://www.hl7.org/fhir/invoice.html
Acceptance criteria
Insurance clerk generates claim bill per health facility for a given time period
Insurance clerk generates commission bill per EO for a given time period
Insurance clerk generates capitation bill per HF for a given time period
Insurance clerk display the bill with details
Insurance clerk add a payment on the bill
Insurance clerk print the bill
Insurance clerk delete a bill (this won’t delete the generating Item)
Front end
Search page
search criteria
search result
card page
general information
detials
Account receivable, using the same structure as Account payable, when associated to the contract might also replace the “contribution/premium“
Other FE approach (not prefered)
Either drop down as current screen
General Account Payable section
Select “Account payable”
Payment plan picker in the future data model
can be a static drop down list for the old model: Valuation / Capitation / Commission fees / payment fees + Product picker
Or calculation for payment plan using the product configuration could be created, then payment plan could be created for each products
two datetime entries: DateFrom/DateTo
Location picker
Export Account Payable section
Payment plan picker in the future data model
can be a static drop down list for the old model: Valuation / Capitation / Commission fees / payment fees + Product picker
Or calculation for payment plan using the product configuration could be created, then payment plan could be created for each products
two datetime entries: DateFrom/DateTo
Location picker
group by: Product or third party
third party: user(EnrolmentOffice)/HF/”insuree”
section “payment plan calculated” that will display all “Account Payable generated” with there input detail in 1 column, working var in a second and the result in the third (relative index)