Medical bill checking method and device, electronic equipment and storage medium

By acquiring and mapping bill fields, combining user-selected combination operations to determine the reconciliation mode, and automatically checking the billing documents of the target medical unit and third-party institutions, the problems of low efficiency and poor accuracy of manual checking are solved, and efficient and accurate bill checking is achieved.

CN119808753BActive Publication Date: 2025-10-24GUANGZHOU KINGMED CENTER FOR CLINICAL LABORATORY CO LTD +1
View PDF 1 Cites 0 Cited by

Patent Information

Application Number
CN202411791610.8
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-12-06
Publication Date
2025-10-24
Estimated Expiration
2044-12-06

AI Technical Summary

Technical Problem

In the existing technology, manual verification of medical institution bills by third-party medical testing institutions is inefficient and prone to human errors, resulting in discrepancies in the accounts.

Method used

By obtaining the bill template file of the target medical institution, extracting and mapping the bill fields, determining the reconciliation mode based on the combination of operations selected by the user, and comparing the bill files of the target medical institution and the third-party agency, automated verification is achieved.

Benefits of technology

It improves the efficiency and accuracy of medical bill verification, supports unified processing of bill formats of different medical units, and enhances the flexibility and accuracy of verification.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119808753B_ABST
    Figure CN119808753B_ABST
Patent Text Reader

Abstract

Embodiments of the present application disclose a medical bill checking method and device, electronic equipment and storage medium, the method comprising: obtaining a bill template file corresponding to a target medical unit; extracting a plurality of first bill fields contained in the bill template file; mapping the plurality of first bill fields to a plurality of second bill fields based on the meanings represented by the respective first bill fields; the plurality of second bill fields correspond one-to-one to the plurality of first bill fields; in response to a combination operation triggered on the plurality of second bill fields, determining a target reconciliation mode according to a plurality of target second bill fields selected in combination; obtaining a first bill file corresponding to the target medical unit and a second bill file corresponding to a third-party medical detection agency; and checking the first bill file and the second bill file according to the target reconciliation mode to obtain a reconciliation result, which can improve the efficiency and accuracy of medical bill checking.
Need to check novelty before this filing date? Find Prior Art

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data processing, in particular to a medical bill checking method and device, an electronic device and a storage medium. BACKGROUND

[0002] With the development of the medical industry, most medical units (such as hospitals, etc.) choose to entrust a third-party medical testing agency to test the biological samples of users, so the third-party medical testing agency needs to check the bills with the medical units regularly, and after checking, the third-party medical testing agency issues invoices to the medical units.

[0003] Currently, the staff of the third-party medical testing agency need to manually check the bills of the third-party medical testing agency and the bills of the medical units, find out the same and different records of the bills of the two parties, which not only is inefficient and has a large workload, but also is prone to human errors, resulting in inconsistent accounts. SUMMARY

[0004] The embodiments of the present application disclose a medical bill checking method and device, an electronic device and a storage medium, which can improve the efficiency and accuracy of medical bill checking.

[0005] The first aspect of the embodiments of the present application discloses a medical bill checking method, which comprises:

[0006] obtaining a bill template file corresponding to a target medical unit;

[0007] extracting a plurality of first bill fields contained in the bill template file;

[0008] mapping the plurality of first bill fields into a plurality of second bill fields based on the meanings represented by each of the first bill fields; the plurality of second bill fields correspond one-to-one to the plurality of first bill fields;

[0009] in response to a combination operation triggered on the plurality of second bill fields, determining a target reconciliation mode according to a plurality of target second bill fields selected in combination;

[0010] obtaining a first bill file corresponding to the target medical unit and a second bill file corresponding to a third-party medical testing agency;

[0011] checking the first bill file and the second bill file according to the target reconciliation mode to obtain a reconciliation result.

[0012] As an optional implementation, in the first aspect of the embodiment of the present application, the plurality of second billing fields are divided into a first group of fields and a second group of fields; and in response to the combination operation triggered on the plurality of second billing fields, the target reconciliation mode is determined according to the selected combination of the plurality of target second billing fields, including:

[0013] In response to the combination operation triggered on the plurality of second billing fields, one or more target second billing fields selected and combined in the first group of fields and one or more target second billing fields selected and combined in the second group of fields are determined;

[0014] According to the one or more target second billing fields corresponding to the first group of fields and the one or more target second billing fields corresponding to the second group of fields, the target reconciliation mode is determined.

[0015] As an optional implementation, in the first aspect of the embodiment of the present application, the second group of fields includes a project identifier field; and the target reconciliation mode is determined according to the one or more target second billing fields corresponding to the first group of fields and the one or more target second billing fields corresponding to the second group of fields, including:

[0016] In the case where the one or more target second billing fields corresponding to the second group of fields include the project identifier field, the target reconciliation mode is determined as a first reconciliation mode;

[0017] The first billing file and the second billing file are reconciled according to the target reconciliation mode to obtain a reconciliation result, including:

[0018] Based on the first reconciliation mode, first billing data corresponding to a first medical detection project in the first billing file is obtained, and second billing data corresponding to the first medical detection project in the second billing file is obtained; the first medical detection project is any medical detection project in the first billing file;

[0019] The first billing data and the second billing data are reconciled according to the one or more target second billing fields corresponding to the first group of fields to obtain a reconciliation result.

[0020] As an optional implementation, in the first aspect of the embodiment of the present application, before the first billing data corresponding to the first medical detection project in the first billing file is obtained, the method further includes:

[0021] According to first project information corresponding to a first medical detection project contained in the first billing file, second project information matching the first project information is searched in a project comparison file;

[0022] The acquiring the second billing data corresponding to the first medical detection item in the second billing file comprises:

[0023] According to the second item information, the second billing data corresponding to the second item information corresponding to the first medical detection item is acquired from the second billing file.

[0024] As an optional implementation, in the first aspect of the embodiment of the present application, the second group of fields comprises an amount field; and the determining the target reconciliation mode according to the one or more target second billing fields corresponding to the first group of fields and the one or more target second billing fields corresponding to the second group of fields comprises:

[0025] In the case that the one or more target second billing fields corresponding to the second group of fields comprises the amount field, the target reconciliation mode is determined as a second reconciliation mode;

[0026] The reconciling the first billing file and the second billing file according to the target reconciliation mode to obtain a reconciliation result comprises:

[0027] Based on the first reconciliation mode, the third billing data corresponding to each target second billing field of the first group of fields in the first billing file is acquired, and the fourth billing data corresponding to each target second billing field of the first group of fields in the second billing file is acquired;

[0028] The first summary amount corresponding to the third billing data is calculated, and the second summary amount corresponding to the fourth billing data is calculated;

[0029] The first summary amount and the second summary amount are compared to obtain a reconciliation result.

[0030] As an optional implementation, in the first aspect of the embodiment of the present application, after the reconciling the first billing file and the second billing file according to the target reconciliation mode to obtain a reconciliation result, the method further comprises:

[0031] According to the reconciliation list corresponding to the target reconciliation mode, a reconciliation table is output according to the reconciliation result; different reconciliation modes correspond to different reconciliation lists.

[0032] As an optional implementation, in the first aspect of the embodiment of the present application, the target reconciliation mode comprises a first reconciliation mode, the first reconciliation mode is used for comparing the billing data of each medical detection item in the first billing file and the second billing file; the reconciliation list corresponding to the first reconciliation mode comprises: an item comparison error list corresponding to the target medical unit and an item comparison error list corresponding to the third-party medical detection institution.

[0033] Or,

[0034] The target reconciliation mode comprises a second reconciliation mode, the second reconciliation mode is used for comparing the total amount in the first billing file and the second billing file; the reconciliation list corresponding to the second reconciliation mode comprises: an amount error list corresponding to the target medical unit and an amount error list corresponding to the third-party medical detection institution.

[0035] The second aspect of the embodiment of the present application discloses a medical billing checking device, the device comprises:

[0036] A template file acquisition module is configured to acquire a billing template file corresponding to a target medical unit.

[0037] An extraction module is configured to extract a plurality of first billing fields contained in the billing template file.

[0038] A mapping module is configured to map the plurality of first billing fields to a plurality of second billing fields based on the meanings represented by the first billing fields.

[0039] A combination module is configured to determine a target reconciliation mode according to a plurality of selected second billing fields in response to a combination operation triggered by the plurality of second billing fields.

[0040] A billing file acquisition module is configured to acquire a first billing file corresponding to the target medical unit and a second billing file corresponding to a third-party medical detection institution.

[0041] A checking module is configured to check the first billing file and the second billing file according to the target reconciliation mode to obtain a reconciliation result.

[0042] The third aspect of the embodiment of the present application discloses an electronic device, comprising:

[0043] A memory storing executable program codes;

[0044] A processor coupled with the memory;

[0045] The processor invokes the executable program code stored in the memory to execute the method described in any of the above embodiments.

[0046] The fourth aspect of the embodiments of the present application discloses a computer readable storage medium storing a computer program, wherein the computer program is executed by a processor to make the processor execute the method described in any of the above embodiments.

[0047] Compared with the related art, the embodiments of the present application have at least the following beneficial effects:

[0048] The medical bill checking method and device, electronic equipment and storage medium disclosed by the embodiments of the present application, the bill template file corresponding to the target medical unit is obtained; a plurality of first bill fields contained in the bill template file are extracted; the plurality of first bill fields are mapped into a plurality of second bill fields based on the meanings represented by the respective first bill fields; the plurality of second bill fields correspond one-to-one to the first bill fields; in response to a combination operation triggered by the plurality of second bill fields, a target reconciliation mode is determined according to a plurality of target second bill fields selected for combination; a first bill file corresponding to the target medical unit and a second bill file corresponding to a third-party medical testing agency are obtained; the first bill file and the second bill file are checked according to the target reconciliation mode, and a reconciliation result is obtained. In the embodiments of the present application, the first bill fields in the bill template file corresponding to the target medical unit can be mapped into second bill fields, realizing unified processing of bill formats of different medical units, and users can select different bill fields for combination according to actual needs, and determine a matching target reconciliation mode according to a plurality of target second bill fields selected for combination, and check the bill files of the target medical unit and the third-party medical testing agency based on the target reconciliation mode, improving the flexibility of medical bill checking, and improving the efficiency and accuracy of medical bill checking. BRIEF DESCRIPTION OF DRAWINGS

[0049] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings needed in the embodiments will be briefly introduced as follows. Obviously, the drawings in the following description are only some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative labor.

[0050] Figure 1 An application scenario diagram of the medical bill checking method in an embodiment;

[0051] Figure 2 A flowchart of the medical bill checking method in an embodiment;

[0052] Figure 3 A schematic diagram of a field combination interface in an embodiment;

[0053] Figure 4 A flow chart for determining a target reconciliation mode according to a selected combination of multiple target second billing fields, for a combined operation triggered by multiple second billing fields in one embodiment;

[0054] Figure 5 A flow chart for reconciling a first billing file and a second billing file according to a target reconciliation mode, to obtain a reconciliation result, in one embodiment;

[0055] Figure 6 A flow chart for reconciling a first billing file and a second billing file according to a target reconciliation mode, to obtain a reconciliation result, in another embodiment;

[0056] Figure 7 A structural schematic diagram of a medical billing reconciliation device disclosed in one embodiment;

[0057] Figure 8 A structural schematic diagram of an electronic device disclosed in one embodiment. DETAILED DESCRIPTION

[0058] The technical solutions in the embodiments of the present application will be described clearly and completely below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only some of the embodiments of the present application, but not all the embodiments of the present application. Based on the embodiments in the present application, all other embodiments obtained by those skilled in the art without creative work fall within the scope of protection of the present application.

[0059] It should be noted that the terms "comprising" and "having" and any variations thereof in the embodiments of the present application and the drawings are intended to cover non-exclusive inclusion. For example, a process, method, system, product or device including a series of steps or units is not limited to the listed steps or units, but can optionally include steps or units not listed or can optionally include other steps or units inherent to the process, method, product or device.

[0060] At present, a third-party medical testing institution needs to periodically reconcile bills with medical units, and then the third-party medical testing institution issues invoices to the medical units after reconciliation. The third-party medical testing institution needs to face tens of thousands of medical units, and the billing formats of each medical unit can be different, and the reconciliation methods can also be different. The personnel of the third-party medical testing institution need to compare the bills of the third-party medical testing institution and the bills of the medical units according to the billing formats of the medical units, find out the same and different records of the bills of the two parties, and provide the basis for providing the final collection invoice. For a medical unit with a large amount of data, the reconciliation work is tedious and the reconciliation time is long.

[0061] In addition, the project names of the medical units and the project names of the third-party medical testing institutions are usually different. When checking the bills of the third-party medical testing institutions and the bills of the medical units, the project names need to be converted. The third-party medical testing institutions record the conversion relationship between the projects of the medical units and the projects of the third-party medical testing institutions through a project comparison table. Therefore, the staff of the third-party medical testing institutions need to update the project comparison table frequently to ensure the correctness and timeliness of the account checking.

[0062] Embodiments of the present application disclose a medical bill checking method and device, electronic equipment and storage medium, which can improve the efficiency and accuracy of medical bill checking.

[0063] The medical bill checking method provided by the present application can be applied to the application scenario as shown in the figure. Figure 1 The application scenario can include multiple clients 110, a server 120 and a terminal device 130. The multiple clients 110 and the server 120 can communicate through a network, and the server 120 and the terminal device 130 can also communicate through a network.

[0064] The multiple clients 110 can be respectively deployed in different medical units, including but not limited to hospitals and other compliant medical collection units. Each client 110 can store the bill files of the corresponding medical unit and send the bill files to the server 120. Further, the client 110 can send the bill files of the corresponding medical unit in a preset period to the server 120 every interval.

[0065] The server 120 can be deployed in a third-party medical testing institution, which refers to a team with detection capability and qualification. The server 120 can be implemented by an independent server or a server cluster composed of multiple servers. The server 120 can receive the bill files sent by the client 110 and store the bill files corresponding to the medical unit identification. When the staff checks the bills, the bill files corresponding to the target medical unit can be obtained according to the medical unit identification, and the bill files corresponding to the third-party medical testing institution are checked.

[0066] The terminal device 130 can be deployed in the third-party medical testing institution to provide the staff of the third-party medical testing institution with the interface display and interaction functions for checking the medical bills.

[0067] In an embodiment of the present application, the terminal device 130 can obtain a bill template file corresponding to the target medical unit, extract multiple first bill fields contained in the bill template file, and map the multiple first bill fields to multiple second bill fields based on the meaning represented by each first bill field; the multiple second bill fields correspond one-to-one to the multiple first bill fields. The staff can select multiple second bill fields on the interface displayed by the terminal device 130 to combine. The terminal device 130 can respond to the combination operation triggered on the multiple second bill fields and determine the target reconciliation mode based on the multiple target second bill fields selected for combination. The terminal device 130 can obtain the first bill file corresponding to the target medical unit and the second bill file corresponding to the third-party medical testing agency, and check the first bill file and the second bill file according to the target reconciliation mode to obtain the reconciliation result.

[0068] like Figure 2 As shown, in one embodiment, a medical bill verification method is provided, which can be applied to the above-mentioned terminal device 130. The method may include the following steps:

[0069] Step 210: Obtain the bill template file corresponding to the target medical institution.

[0070] The target medical institution refers to the medical institution selected by the user for bill verification.

[0071] A bill template file is a document containing bill fields that is used to populate the target medical institution's billing data. Different medical institutions may have different bill template files, for example, due to differences in the bill fields or the names of the included bill fields.

[0072] Billing fields may include one or more of the following: date, patient name, order item code, order item name, and price. The date may indicate the payment date; the order item code uniquely identifies the medical test item; the order item name may indicate the name of the medical test item; and the price may indicate the corresponding test price for the medical test item. Medical test items may refer to specific tests performed on biological samples, such as, but not limited to, routine blood tests or urine tests.

[0073] In some embodiments, the terminal device may pre-store medical institution information corresponding to the target medical institution, which may include a bill template file corresponding to the target medical institution and a medical institution identifier corresponding to the target medical institution. When a user needs to obtain a bill template file corresponding to the target medical institution, the user may enter the medical institution identifier corresponding to the target medical institution in an interface displayed on the terminal device to query the bill template file corresponding to the medical institution identifier.

[0074] The medical unit identifier can be used to uniquely identify a medical unit. For example, the medical unit identifier can include, but is not limited to, a medical unit name, a medical unit number, and the like.

[0075] In some embodiments, the user can select to import the billing template file. When it is necessary to obtain the billing template file corresponding to the target medical unit, the user can select the target medical unit in the interface displayed on the terminal device to import the billing template file corresponding to the target medical unit.

[0076] In step 220, a plurality of first billing fields contained in the billing template file are extracted.

[0077] The first billing field refers to a header field in the billing template file, and the header field refers to a field located in the first row in the billing template file.

[0078] In some embodiments, the terminal device can identify and locate the first row of the billing template file, extract each field contained in the first row of the billing template file, and take each extracted field as a first billing field.

[0079] The first billing field can include a date, a patient name, a medical order item code, a medical order item name, and a price, and the like. The date can represent the payment date of a medical detection item of a patient in the target medical unit. The medical order item code can be used to uniquely identify the medical detection item of the target medical unit. The medical order item name can represent the name of the medical detection item in the target medical unit. The price can represent the detection price of the medical detection item in the target medical unit.

[0080] In step 230, based on the meaning represented by each first billing field, the plurality of first billing fields are mapped to a plurality of second billing fields; the plurality of second billing fields correspond one-to-one to the plurality of first billing fields.

[0081] The second billing field refers to a billing field for account screening with the same meaning as the first billing field. Further, the second billing field can be a billing field with the same field name in the billing file of the third-party medical detection institution.

[0082] The meaning represented by the first billing field refers to the specific meaning of the first billing field. For example, the specific meaning of the "price" in the first billing field is the detection price of the medical detection item in the target medical unit.

[0083] In some embodiments, the terminal device can pre-store a field mapping relationship table, which can be pre-established by staff according to the meaning represented by each first billing field included in each billing template file and the meaning represented by each second billing field. The field mapping relationship table can include a plurality of first billing fields and a second billing field to which each first billing field is mapped. After extracting the plurality of first billing fields included in the billing template file, the terminal device can map each extracted first billing field to the corresponding second billing field according to the field mapping relationship table.

[0084] In some embodiments, the terminal device can display each extracted first billing field on a field mapping interface, and the user can input a second billing field to which each first billing field is mapped. The terminal device can map each first billing field to the input second billing field in response to the user's field input operation on each second billing field. By mapping a plurality of first billing fields to a plurality of second billing fields, uniform processing of different medical unit billing formats can be achieved.

[0085] Step 240, in response to the combination operation triggered on the plurality of second billing fields, determining a target reconciliation mode according to the plurality of target second billing fields selected for combination.

[0086] The terminal device can display a plurality of second billing fields on a field combination interface, and the user can select a plurality of target second billing fields for combination in the field combination interface. The terminal device can determine a target reconciliation mode according to the plurality of target second billing fields selected for combination in response to the combination operation triggered on the plurality of second billing fields.

[0087] In some embodiments, as shown in Figure 3 The terminal device can display a plurality of second billing fields and a combination control 320 corresponding to each second billing field on a field combination interface 310, and the user can select a plurality of target second billing fields by clicking the combination control 320 corresponding to each second billing field. The terminal device can determine a target reconciliation mode according to the plurality of target second billing fields selected for combination in response to the combination operation triggered on the combination control 320 corresponding to the plurality of second billing fields.

[0088] In some embodiments, the terminal device can be pre-provided with a plurality of reconciliation modes, and different reconciliation modes can correspond to different reconciliation strategies. The reconciliation mode can be determined according to the plurality of target second billing fields selected by the user, and the reconciliation strategy corresponding to the reconciliation mode is a strategy based on the main billing field in the plurality of target second billing fields.

[0089] In some embodiments, the reconciliation mode can be set by selecting a combination of the second billing fields, and different reconciliation modes correspond to different combinations of the target second billing fields. When the terminal device determines that the user selects a combination of the target second billing fields, the target reconciliation mode can be determined according to the combination of the target second billing fields selected by the user.

[0090] In some embodiments, the target reconciliation mode can include a first reconciliation mode, which can be a reconciliation mode for reconciling the bills of each medical detection item respectively. The first reconciliation mode is used to compare the bill amounts of each medical detection item in the bill file of the medical unit and the bill file of the third-party medical detection institution. For example, when the item identifier field is included in the combination of the target second billing fields selected by the user, the target reconciliation mode can be determined to be the first reconciliation mode.

[0091] In some embodiments, the target reconciliation mode can include a second reconciliation mode, which can be a reconciliation mode for reconciling the total bills of multiple medical detection items. The second reconciliation mode is used to compare the aggregated amounts corresponding to the multiple medical detection items in the bill file of the medical unit and the bill file of the third-party medical detection institution. For example, when the aggregated amount field is included in the combination of the target second billing fields selected by the user, the target reconciliation mode can be determined to be the second reconciliation mode.

[0092] Step 250: Obtain the first bill file corresponding to the target medical unit and the second bill file corresponding to the third-party medical detection institution.

[0093] The first bill file refers to a file recording the billing data corresponding to the target medical unit; and the second bill file refers to a file recording the billing data corresponding to the third-party medical detection institution.

[0094] In some embodiments, the server can periodically receive the first bill file sent by the client corresponding to the target medical unit, and store the first bill file corresponding to the medical unit identifier of the target medical unit.

[0095] When the user needs to import the first bill file and the second bill file, the terminal device can query the first bill file corresponding to the medical unit identifier of the target medical unit from the server, and query the second bill file corresponding to the third-party medical detection institution from the memory according to the medical unit identifier of the target medical unit.

[0096] Step 260: Reconcile the first bill file and the second bill file according to the target reconciliation mode to obtain a reconciliation result.

[0097] The terminal device can compare the billing data corresponding to the selected combination of the plurality of target second billing fields extracted from the first billing file with the billing data corresponding to the selected combination of the plurality of target second billing fields extracted from the second billing file according to the target reconciliation mode, to obtain a reconciliation result.

[0098] In some embodiments, the terminal device can check the amount of any medical test item in the first billing file with the amount of the same medical test item in the second billing file.

[0099] In some embodiments, the terminal device can check the total amount of a plurality of medical test items in the first billing file with the total amount of the plurality of medical test items in the second billing file.

[0100] For example, the plurality of target second billing fields in the target reconciliation mode can include medical unit barcodes and item codes, and the terminal device can check the billing data corresponding to any medical unit barcode and item code extracted from the first billing file with the billing data corresponding to the same medical unit barcode and item code extracted from the second billing file, to obtain a reconciliation result.

[0101] In the process of billing check, different reconciliation modes correspond to different check objects. Optionally, the check object can be the amount corresponding to one medical test item, or the total amount corresponding to a plurality of medical test items.

[0102] The reconciliation result can be used to record the correct and incorrect accounts in the first billing file and the second billing file. For example, the reconciliation result can include a consistent list, an inconsistent list, a non-existent list, a duplicate list, etc., wherein the consistent list can refer to a list of medical tests matched in the first billing file and the second billing file; the inconsistent list can refer to a list of medical tests whose total amount of a plurality of medical test items in the first billing file is inconsistent with the total amount of the plurality of medical test items in the second billing file; the non-existent list can refer to a list of medical test items that exist in the second billing file but do not exist in the first billing file; and the duplicate list can refer to a list of accounts that repeatedly appear in the first billing file, or a list of accounts that repeatedly appear in the second billing file.

[0103] In an embodiment of the present application, the terminal device can obtain a bill template file corresponding to the target medical unit; extract multiple first bill fields contained in the bill template file; map the multiple first bill fields to multiple second bill fields based on the meaning represented by each first bill field; the multiple second bill fields correspond one-to-one to the first bill field; in response to the combination operation triggered on the multiple second bill fields, determine the target reconciliation mode according to the selected combined multiple target second bill fields; obtain the first bill file corresponding to the target medical unit and the second bill file corresponding to the third-party medical testing agency; according to the target reconciliation mode, check the first bill file and the second bill file to obtain the reconciliation result, thereby realizing unified processing of bill formats of different medical units, and according to actual needs, the user can select different bill fields for combination to determine the most appropriate reconciliation mode, which can improve the efficiency and accuracy of medical bill reconciliation.

[0104] In some embodiments, as Figure 4 As shown, in response to the combination operation triggered on multiple second bill fields, determining the target reconciliation mode according to the multiple target second bill fields selected for combination may include the following steps:

[0105] Step 410 : In response to a combination operation triggered on a plurality of second billing fields, determining one or more target second billing fields for the selected combination in the first set of fields and one or more target second billing fields for the selected combination in the second set of fields.

[0106] In some embodiments, the plurality of second billing fields are divided into a first group of fields and a second group of fields.

[0107] The first group of fields can be used to uniquely identify a medical bill record. Optionally, the first group of fields can include one or more of a medical institution identification field, a medical testing institution identification field, and a patient identification field. The medical institution identification field can be used to uniquely identify a medical institution, such as a hospital barcode, medical institution code, or medical institution number; the medical testing institution identification field can be used to uniquely identify a third-party medical testing institution, such as a medical testing institution barcode or medical testing institution code; and the patient identification field can be used to uniquely identify a patient, such as a patient name, patient ID number, or patient number.

[0108] The second set of fields can be used to determine the content of the verification. Optionally, the second set of fields can include one or more of a project identification field and a summary amount field. The project identification field can be used to uniquely identify the medical test project, such as a project code, project number, project barcode, or project name. The summary amount field can refer to the total amount corresponding to multiple medical test projects determined by selecting and combining one or more target second billing fields from the first set of fields.

[0109] As shown in Figure 3 The terminal device can display the first set of fields 330 and the second set of fields 340 on the field combination interface 310. The user can perform a point selection operation on the combination control 320 corresponding to any second billing field in the first set of fields 330 and the combination control 320 corresponding to any second billing field in the second set of fields 340. The terminal device can determine one or more target second billing fields in the first set of fields that are selected for combination and one or more target second billing fields in the second set of fields that are selected for combination in response to the point selection operation.

[0110] At step 420, the target reconciliation mode is determined according to the one or more target second billing fields corresponding to the first set of fields and the one or more target second billing fields corresponding to the second set of fields.

[0111] The target reconciliation mode can refer to a mode of checking the billing by the one or more target second billing fields corresponding to the first set of fields and the one or more target second billing fields corresponding to the second set of fields.

[0112] For example, the one target second billing field corresponding to the first set of fields can be a medical unit code, and the one target second billing field corresponding to the second set of fields can be a project code. The target reconciliation mode refers to a mode of checking the billing by the medical unit code and the project code.

[0113] In the embodiments of the present application, the terminal device can determine one or more target second billing fields in the first set of fields that are selected for combination and one or more target second billing fields in the second set of fields that are selected for combination in response to the combination operation triggered on the plurality of second billing fields. The target reconciliation mode is determined according to the one or more target second billing fields corresponding to the first set of fields and the one or more target second billing fields corresponding to the second set of fields. The target reconciliation mode is determined by combining the second billing fields in the first set of fields and the second set of fields, which enhances the adaptability and flexibility of medical billing reconciliation.

[0114] In some embodiments, the second set of fields can include a project identification field, which can be used to uniquely identify a medical detection project. As shown in Figure 5 The step of checking the first billing file and the second billing file according to the target reconciliation mode to obtain a reconciliation result can include the following steps:

[0115] At step 510, the first billing data corresponding to the first medical detection project in the first billing file and the second billing data corresponding to the first medical detection project in the second billing file are obtained based on the first reconciliation mode. The first medical detection project is any medical detection project in the first billing file.

[0116] In a case where the one or more target second billing fields corresponding to the second set of fields include an item identifier field, the terminal device can determine that the target reconciliation mode is the first reconciliation mode.

[0117] The terminal device can obtain, according to the item identifier corresponding to the first medical detection item, billing data corresponding to the first medical detection item from the first billing file.

[0118] In some embodiments, before obtaining the first billing data corresponding to the first medical detection item in the first billing file, the terminal device can find, according to the first item information corresponding to the first medical detection item included in the first billing file, second item information matching the first item information in the item comparison file, and then the terminal device can obtain, according to the second item information, second billing data corresponding to the second item information corresponding to the first medical detection item from the second billing file. The item information can be used to identify medical detection items, such as item name, item number, and item code.

[0119] For example, the item comparison table can include the item code of the first medical detection item corresponding to the medical unit and the item code of the first medical detection item corresponding to the third-party medical detection institution, and the terminal device can find, according to the first item code corresponding to the first medical detection item in the first billing file, second item code matching the first item code in the item comparison file, and then the terminal device can obtain, according to the second item code, second billing data corresponding to the second item code from the second billing file.

[0120] Step 520: According to the one or more target second billing fields corresponding to the first set of fields, the first billing data and the second billing data are reconciled to obtain a reconciliation result.

[0121] The reconciliation result can be used to represent the comparison result of the amount of each medical detection item between the medical unit and the third-party medical detection institution.

[0122] The terminal device can reconcile the first billing data and the second billing data according to the one or more target second billing fields corresponding to the first set of fields and the item identifier field to obtain a reconciliation result.

[0123] In some embodiments, the one or more target second billing fields corresponding to the first group of fields can be a patient identifier field, and the terminal device can extract a first medical billing record from the first billing data and a second medical billing record from the second billing data according to the patient identifier field, compare the amount corresponding to the first medical billing record with the amount corresponding to the second medical billing record, and obtain the reconciliation result. The first medical billing record refers to the medical billing record corresponding to the patient identifier field in the first billing data, and the second medical billing record refers to the medical billing record corresponding to the patient identifier field in the second billing data.

[0124] For example, the terminal device can extract a first medical billing record corresponding to a patient name from the first billing data and a second medical billing record corresponding to the patient name from the second billing data according to the patient name, compare the amount corresponding to the first medical billing record with the amount corresponding to the second medical billing record, and if the amount corresponding to the first medical billing record is inconsistent with the amount corresponding to the second medical billing record, record the first medical billing record and the second medical billing record to an inconsistency list of the medical unit and an inconsistency list of the third-party medical detection institution, respectively; if the amount corresponding to the first medical billing record is consistent with the amount corresponding to the second medical billing record, record the first medical billing record and the second medical billing record to a consistency list of the medical unit and a consistency list of the third-party medical detection institution, respectively.

[0125] In the embodiments of the present application, the terminal device can obtain first billing data corresponding to a first medical detection item in the first billing file and second billing data corresponding to the first medical detection item in the second billing file based on the first reconciliation mode, and check the first billing data and the second billing data according to the one or more target second billing fields corresponding to the first group of fields to obtain the reconciliation result. The first medical detection item is any medical detection item in the first billing file. By comparing the medical detection items in the first billing file and the second billing file one by one, the accuracy of medical billing checking can be improved.

[0126] In some embodiments, the second group of fields can include an amount field that can aggregate the amount of billing data determined by the one or more target second billing fields corresponding to the first group of fields. As shown in Figure 6 The step of checking the first billing file and the second billing file according to the target reconciliation mode to obtain the reconciliation result can include the following steps:

[0127] In step 610, third billing data corresponding to each target second billing field of the first group of fields in the first billing file and fourth billing data corresponding to each target second billing field of the first group of fields in the second billing file are obtained based on the second reconciliation mode.

[0128] The terminal device can determine that the target reconciliation mode is the second reconciliation mode in a case where the one or more target second billing fields corresponding to the second group of fields include an amount field.

[0129] In some embodiments, the target second billing field includes a medical unit identification field, and the terminal device can obtain third billing data corresponding to the medical unit identification field in the first billing file, and obtain fourth billing data corresponding to the medical unit identification field in the second billing file. The third billing data can be used to represent billing data corresponding to any medical unit identification in the first billing file, and the fourth billing data can be used to represent billing data corresponding to any medical unit identification in the second billing file.

[0130] In some embodiments, the target second billing field includes a medical testing agency identification field, and the terminal device can obtain third billing data corresponding to the medical testing agency identification field in the first billing file, and obtain fourth billing data corresponding to the medical testing agency identification field in the second billing file. The third billing data can be used to represent billing data corresponding to any medical testing agency identification in the first billing file, and the fourth billing data can be used to represent billing data corresponding to any medical testing agency identification in the second billing file.

[0131] For example, the medical testing agency identification field can be a medical testing agency code, such as A1B2C3D4E5, and the terminal device can obtain third billing data corresponding to the medical testing agency code A1B2C3D4E5 in the first billing file, and obtain fourth billing data corresponding to the medical testing agency code A1B2C3D4E5 in the second billing file. The third billing data can refer to all billing data corresponding to the medical testing agency code A1B2C3D4E5 in the first billing file, and the fourth billing data can refer to all billing data corresponding to the medical testing agency code A1B2C3D4E5 in the second billing file.

[0132] In some embodiments, the target second billing field includes a patient identification field, and the terminal device can obtain third billing data corresponding to the patient identification field in the first billing file, and obtain fourth billing data corresponding to the patient identification field in the second billing file. The third billing data can be used to represent billing data corresponding to any patient in the first billing file, and the fourth billing data can be used to represent billing data corresponding to any patient in the second billing file.

[0133] For example, the patient identification field can be a patient name, and the terminal device can obtain third billing data corresponding to the patient name from the first billing file and fourth billing data corresponding to the same patient name from the second billing file. The third billing data can refer to all billing data corresponding to the patient in the first billing file, and the fourth billing data can refer to all billing data corresponding to the patient in the second billing file.

[0134] In step 620, a first total amount corresponding to the third billing data is calculated, and a second total amount corresponding to the fourth billing data is calculated.

[0135] The terminal device can calculate the sum of amounts corresponding to each medical billing record in the third billing data to obtain the first total amount, and calculate the sum of amounts corresponding to each medical billing record in the fourth billing data to obtain the second total amount.

[0136] In step 630, the first total amount and the second total amount are compared to obtain an account reconciliation result.

[0137] The account reconciliation result can be used to represent the comparison result of the total amounts corresponding to a plurality of medical detection items between the medical unit and the third-party medical detection institution.

[0138] The terminal device can compare the first total amount and the second total amount. If the first total amount and the second total amount are consistent, the third billing data and the fourth billing data can be recorded to a total amount consistent list corresponding to the medical unit and a total amount consistent list corresponding to the third-party medical detection institution, respectively. If the first total amount and the second total amount are inconsistent, the third billing data and the fourth billing data can be recorded to a total amount inconsistent list corresponding to the medical unit and a total amount inconsistent list corresponding to the third-party medical detection institution, respectively.

[0139] In the embodiments of the present application, the terminal device can obtain, based on a first account reconciliation mode, third billing data corresponding to each target second billing field of the first group of fields in the first billing file, and fourth billing data corresponding to each target second billing field of the first group of fields in the second billing data; calculate a first total amount corresponding to the third billing data, and calculate a second total amount corresponding to the fourth billing data; compare the first total amount and the second total amount to obtain an account reconciliation result. By checking the total amounts of a plurality of billing data in the first billing file and the second billing file, the efficiency of medical billing checking can be improved.

[0140] In some embodiments, after checking the first billing file and the second billing file according to the target account reconciliation mode to obtain an account reconciliation result, the terminal device can output an account reconciliation table according to the account reconciliation result according to an account reconciliation list corresponding to the target account reconciliation mode; different account reconciliation modes correspond to different account reconciliation lists.

[0141] In some embodiments, the target reconciliation mode can include a first reconciliation mode, the first reconciliation mode being configured to compare billing data of each medical test item in the first billing file and the second billing file; the reconciliation list corresponding to the first reconciliation mode including: an item comparison error list corresponding to the target medical unit and an item comparison error list corresponding to the third-party medical testing institution.

[0142] In some embodiments, the item comparison error list corresponding to the target medical unit can include: an item no comparison list corresponding to the target medical unit, an item nonexistence list corresponding to the target medical unit, and an item duplication list corresponding to the target medical unit. The item no comparison list corresponding to the target medical unit can be configured to record medical test items in the target medical unit that have no comparison with the third-party medical testing institution; the item nonexistence list corresponding to the target medical unit can be configured to record medical test items in the target medical unit that do not exist compared with the third-party medical testing institution; and the item duplication list corresponding to the target medical unit can be configured to record medical test items that appear repeatedly in the target medical unit.

[0143] In some embodiments, the item comparison error list corresponding to the third-party medical testing institution can include: an item no comparison list corresponding to the third-party medical testing institution, an item nonexistence list corresponding to the third-party medical testing institution, and an item duplication list corresponding to the third-party medical testing institution. The item no comparison list corresponding to the third-party medical testing institution can be configured to record medical test items in the third-party medical testing institution that have no comparison with the target medical unit; the item nonexistence list corresponding to the third-party medical testing institution can be configured to record medical test items in the third-party medical testing institution that do not exist compared with the target medical unit; and the item duplication list corresponding to the target medical unit can be configured to record medical test items that appear repeatedly in the third-party medical testing institution.

[0144] In some embodiments, the reconciliation list corresponding to the first reconciliation mode can include a suspected match list and a price difference list. The suspected match list can be configured to record medical billing records in which the amount is the same but the medical test items do not match in the first reconciliation data and the second reconciliation data; and the price difference list can be configured to record medical billing records in which the medical test items match but the amounts do not match in the first reconciliation data and the second reconciliation data.

[0145] In some embodiments, the target reconciliation mode can include a second reconciliation mode, the second reconciliation mode being configured to compare the total amount in the first billing file and the second billing file; the reconciliation list corresponding to the second reconciliation mode including: an amount error list corresponding to the target medical unit and an amount error list corresponding to the third-party medical testing institution.

[0146] In some embodiments, the target medical institution's amount error list may include a target medical institution non-existence list and a target medical institution's summary amount inconsistency list. The target medical institution non-existence list may be used to record medical billing records that do not exist in the third billing data compared to the fourth billing data; and the target medical institution summary amount inconsistency list may be used to record medical billing records in the third billing data that have a summary amount that is inconsistent with that of the fourth billing data.

[0147] In some embodiments, the amount error list corresponding to the third-party medical testing institution may include a non-existent list corresponding to the third-party medical testing institution and a summary amount inconsistency list corresponding to the third-party medical testing institution. The non-existent list corresponding to the third-party medical testing institution may be used to record medical billing records that do not exist in the fourth billing data compared to the third billing data; and the summary amount inconsistency list corresponding to the third-party medical testing institution may be used to record medical billing records in the fourth billing data that have a summary amount that is inconsistent with that of the third billing data.

[0148] like Figure 7 As shown, in one embodiment, a medical bill verification device is provided, which can be applied to the terminal device described above. The medical bill verification device 700 may include a template file acquisition module 710, an extraction module 720, a mapping module 730, a combination module 740, a bill file acquisition module 750, and a verification module 760.

[0149] The template file acquisition module 710 is used to acquire the bill template file corresponding to the target medical institution.

[0150] The extraction module 720 is configured to extract multiple first bill fields contained in the bill template file.

[0151] The mapping module 730 is configured to map the plurality of first bill fields into a plurality of second bill fields based on the meaning represented by each first bill field; the plurality of second bill fields correspond one-to-one to the first bill fields.

[0152] The combining module 740 is configured to determine a target reconciliation mode according to the selected combined second bill fields in response to a combining operation triggered on the plurality of second bill fields.

[0153] The bill file acquisition module 750 is used to acquire a first bill file corresponding to the target medical unit and a second bill file corresponding to the third-party medical testing agency.

[0154] The checking module 760 is configured to check the first bill file and the second bill file according to the target reconciliation mode to obtain a reconciliation result.

[0155] In some embodiments, the plurality of second billing fields are divided into a first group of fields and a second group of fields; the combination module 740 comprises a field determination unit and a mode determination unit.

[0156] The field determination unit is configured to, in response to the combination operation triggered on the plurality of second billing fields, determine one or more target second billing fields in the first group of fields to be combined, and one or more target second billing fields in the second group of fields to be combined.

[0157] The mode determination unit is configured to determine the target reconciliation mode according to the one or more target second billing fields corresponding to the first group of fields, and the one or more target second billing fields corresponding to the second group of fields.

[0158] In some embodiments, the second group of fields comprises an item identifier field; and the mode determination unit is further configured to, in a case where the one or more target second billing fields corresponding to the second group of fields comprise the item identifier field, determine that the target reconciliation mode is the first reconciliation mode.

[0159] The reconciliation module 760 comprises a billing data acquisition unit and a billing data reconciliation unit.

[0160] The billing data acquisition unit is configured to acquire, based on the first reconciliation mode, first billing data corresponding to a first medical detection item in the first billing file, and second billing data corresponding to the first medical detection item in the second billing file; the first medical detection item is any medical detection item in the first billing file.

[0161] The billing data reconciliation unit is configured to reconcile the first billing data and the second billing data according to the one or more target second billing fields corresponding to the first group of fields, to obtain a reconciliation result.

[0162] In some embodiments, the medical billing reconciliation apparatus 700 further comprises a searching module.

[0163] The searching module is configured to search, according to first item information corresponding to a first medical detection item included in the first billing file, second item information matching the first item information in an item reference file.

[0164] The billing data acquisition unit is further configured to acquire, according to the second item information, second billing data corresponding to the second item information corresponding to the first medical detection item from the second billing file.

[0165] In some embodiments, the second group of fields comprises an amount field; and the mode determination unit is further configured to, in a case where the one or more target second billing fields corresponding to the second group of fields comprise the amount field, determine that the target reconciliation mode is a second reconciliation mode.

[0166] The reconciliation module 760 is further configured to acquire third billing data corresponding to each target second billing field of the first set of fields in the first billing file and fourth billing data corresponding to each target second billing field of the first set of fields in the second billing file based on the first reconciliation mode; calculate a first total amount corresponding to the third billing data and a second total amount corresponding to the fourth billing data; and compare the first total amount with the second total amount to obtain a reconciliation result.

[0167] In some embodiments, the medical billing reconciliation apparatus comprises an output module.

[0168] The output module is configured to output a reconciliation table according to a reconciliation statement corresponding to the target reconciliation mode based on the reconciliation result; and different reconciliation modes correspond to different reconciliation statements.

[0169] In some embodiments, the target reconciliation mode comprises a first reconciliation mode configured to compare billing data of each medical detection item in the first billing file and the second billing file; the reconciliation statement corresponding to the first reconciliation mode comprises an item comparison error list corresponding to the target medical unit and an item comparison error list corresponding to the third-party medical detection institution; or the target reconciliation mode comprises a second reconciliation mode configured to compare total amounts in the first billing file and the second billing file; the reconciliation statement corresponding to the second reconciliation mode comprises an amount error list corresponding to the target medical unit and an amount error list corresponding to the third-party medical detection institution.

[0170] In the embodiments of the present application, the terminal device can acquire a billing template file corresponding to a target medical unit; extract a plurality of first billing fields contained in the billing template file; map the plurality of first billing fields to a plurality of second billing fields based on the meanings represented by the first billing fields; the plurality of second billing fields correspond one-to-one to the first billing fields; determine a target reconciliation mode according to a plurality of target second billing fields selected in response to a combination operation triggered on the plurality of second billing fields; acquire a first billing file corresponding to the target medical unit and a second billing file corresponding to a third-party medical detection institution; and reconcile the first billing file and the second billing file according to the target reconciliation mode to obtain a reconciliation result, which realizes unified processing of billing formats of different medical units and enables a user to select different billing fields for combination to determine the most suitable reconciliation mode according to actual needs, thereby improving the efficiency and accuracy of medical billing reconciliation.

[0171] Please refer to Figure 8 , Figure 8 is a structural schematic diagram of an electronic device disclosed in an embodiment. As Figure 8 shown, the electronic device 800 can include:

[0172] a memory 810 storing executable program code;

[0173] a processor 820 coupled with the memory 810;

[0174] The processor 820 invokes the executable program code stored in the memory 810 to perform any of the medical bill checking methods disclosed in the embodiments of the present application.

[0175] The embodiments of the present application disclose a computer readable storage medium storing a computer program, wherein the computer program is executed by the processor to implement any of the medical bill checking methods disclosed in the embodiments of the present application.

[0176] It should be understood that the "one embodiment" or "an embodiment" mentioned throughout the specification means that the specific features, structures or characteristics related to the embodiment are included in at least one embodiment of the present application. Therefore, "in one embodiment" or "in an embodiment" appearing throughout the specification does not necessarily mean the same embodiment. In addition, these specific features, structures or characteristics can be combined in any suitable manner in one or more embodiments. Those skilled in the art should also know that the embodiments described in the specification are all optional embodiments, and the actions and modules involved are not necessarily essential to the present application.

[0177] In various embodiments of the present application, it should be understood that the size of the serial number of the above processes does not mean the inevitable sequence of execution, and the execution sequence of the processes should be determined according to its function and inherent logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.

[0178] The units described above as separate components may or may not be physically separate, and the components shown as units may or may not be physical units, i.e. they can be located in one place, or can be distributed to multiple network units. According to actual needs, part or all of the units can be selected to achieve the purpose of the embodiments of the present application.

[0179] In addition, each functional unit in the embodiments of the present application can be integrated in one processing unit, or each unit can exist physically, or two or more units can be integrated in one unit. The integrated unit can be realized in the form of hardware or in the form of a software functional unit.

[0180] The above integrated units, if implemented in the form of software functional units and sold or used as independent products, can be stored in a computer accessible memory. Based on this understanding, the technical solutions of the present application essentially or the part that contributes to the prior art or the whole or part of the technical solutions can be embodied in the form of a software product. The computer software product is stored in a memory and includes a number of parts or all steps of the above-mentioned methods of the embodiments of the present application for enabling a computer device (which can be a personal computer, a server or a network device, and specifically can be a processor in the computer device) to perform the steps of the above-mentioned methods.

[0181] A person of ordinary skill in the art can understand that all or part of the steps in the above-mentioned embodiments can be completed by a program instructing relevant hardware, and the program can be stored in a computer readable storage medium, including a Read-Only Memory (ROM), a Random Access Memory (RAM), a Programmable Read-Only Memory (PROM), an Erasable Programmable Read-Only Memory (EPROM), a One-time Programmable Read-Only Memory (OTPROM), an Electrically-Erasable Programmable Read-Only Memory (EEPROM), a Compact Disc Read-Only Memory (CD-ROM) or other optical disk storage, a magnetic disk storage, a magnetic tape storage, or any other medium that can be used to carry or store data which can be read by a computer.

[0182] The above describes in detail the medical bill checking method and device, electronic equipment and storage medium disclosed in the embodiments of the present application. The principles and implementation manners of the present application are described by applying specific examples. The above description of the embodiments is only used to help understand the method of the present application and its core idea. Meanwhile, for those skilled in the art, according to the idea of the present application, the specific implementation manner and application range can be changed. In summary, the content of the specification should not be understood as a limitation of the present application.

Claims

1. A medical billing reconciliation method, characterized by, The method comprises the following steps: obtaining a bill template file corresponding to a target medical unit; extracting a plurality of first bill fields contained in the bill template file; mapping the plurality of first bill fields to a plurality of second bill fields based on the meanings represented by the respective first bill fields; the plurality of second bill fields correspond one-to-one to the plurality of first bill fields; the plurality of second bill fields are divided into a first group of fields and a second group of fields; in response to a combination operation triggered on the plurality of second bill fields, determining one or more target second bill fields selected for combination in the first group of fields and one or more target second bill fields selected for combination in the second group of fields; determining a target reconciliation mode according to the one or more target second bill fields corresponding to the first group of fields and the one or more target second bill fields corresponding to the second group of fields; obtaining a first bill file corresponding to the target medical unit and a second bill file corresponding to a third-party medical testing agency, the first bill file referring to a file recording bill data corresponding to the target medical unit, and the second bill file referring to a file recording bill data corresponding to the third-party medical testing agency; checking the first bill file and the second bill file according to the target reconciliation mode to obtain a reconciliation result; the second group of fields includes a project identifier field; determining a target reconciliation mode according to the one or more target second bill fields corresponding to the first group of fields and the one or more target second bill fields corresponding to the second group of fields comprises: in the case where the one or more target second bill fields corresponding to the second group of fields include the project identifier field, determining that the target reconciliation mode is a first reconciliation mode; checking the first bill file and the second bill file according to the target reconciliation mode to obtain a reconciliation result comprises: based on the first reconciliation mode, obtaining first bill data corresponding to a first medical testing project in the first bill file and obtaining second bill data corresponding to the first medical testing project in the second bill file; the first medical testing project is any medical testing project in the first bill file; checking the first bill data and the second bill data according to the one or more target second bill fields corresponding to the first group of fields to obtain a reconciliation result.

2. The method of claim 1, wherein, Before obtaining the first bill data corresponding to the first medical testing project in the first bill file, the method further comprises: finding second project information matching the first project information in a project comparison file according to first project information corresponding to the first medical testing project contained in the first bill file; obtaining second bill data corresponding to the first medical testing project from the second bill file according to the second project information. ​ 3. The method of claim 1, wherein, The second group of fields includes an amount field; the target reconciliation mode is determined according to one or more target second bill fields corresponding to the first group of fields and one or more target second bill fields corresponding to the second group of fields, including: In the case that the one or more target second bill fields corresponding to the second group of fields include the amount field, the target reconciliation mode is determined as a second reconciliation mode; The first bill file and the second bill file are reconciled according to the target reconciliation mode to obtain a reconciliation result, including: Based on the first reconciliation mode, third bill data corresponding to each target second bill field of the first group of fields in the first bill file is obtained, and fourth bill data corresponding to each target second bill field of the first group of fields in the second bill file is obtained; The first summary amount corresponding to the third bill data is calculated, and the second summary amount corresponding to the fourth bill data is calculated; The first summary amount and the second summary amount are compared to obtain a reconciliation result.

4. The method of claim 1, wherein, After the first bill file and the second bill file are reconciled according to the target reconciliation mode to obtain a reconciliation result, the method further includes: According to the reconciliation list corresponding to the target reconciliation mode, a reconciliation table is output according to the reconciliation result; different reconciliation modes correspond to different reconciliation lists.

5. The method of claim 4, wherein, The target reconciliation mode includes a first reconciliation mode, and the first reconciliation mode is used to compare the bill data of each medical detection item in the first bill file and the second bill file; The reconciliation list corresponding to the first reconciliation mode includes an item comparison error list corresponding to the target medical unit and an item comparison error list corresponding to the third-party medical detection institution; Or, The target reconciliation mode includes a second reconciliation mode, and the second reconciliation mode is used to compare the summary amount in the first bill file and the second bill file; the reconciliation list corresponding to the second reconciliation mode includes an amount error list corresponding to the target medical unit and an amount error list corresponding to the third-party medical detection institution.

6. A bill reconciliation apparatus, characterized by comprising: Including: A template file acquisition module is configured to acquire a bill template file corresponding to a target medical unit; An extraction module is configured to extract a plurality of first bill fields included in the bill template file; A mapping module is configured to map the plurality of first bill fields to a plurality of second bill fields based on the meaning represented by each of the first bill fields; The plurality of second bill fields correspond one-to-one to the plurality of first bill fields; the plurality of second bill fields are divided into a first group of fields and a second group of fields; The combination module includes a field determination unit and a mode determination unit; The field determination unit is configured to determine one or more target second bill fields selected and combined in the first group of fields and one or more target second bill fields selected and combined in the second group of fields in response to a combination operation triggered on the plurality of second bill fields; The mode determining unit is further configured to determine a target reconciliation mode according to one or more target second-bill fields corresponding to the first set of fields and one or more target second-bill fields corresponding to the second set of fields. The bill file obtaining module is configured to obtain a first bill file corresponding to the target medical unit and a second bill file corresponding to a third-party medical testing institution, the first bill file being a file recording bill data corresponding to the target medical unit, and the second bill file being a file recording bill data corresponding to the third-party medical testing institution. The reconciliation module is configured to reconcile the first bill file and the second bill file according to the target reconciliation mode to obtain a reconciliation result. The second set of fields includes a project identifier field. The mode determining unit is further configured to determine that the target reconciliation mode is a first reconciliation mode when the one or more target second-bill fields corresponding to the second set of fields include the project identifier field. The reconciliation module includes a bill data obtaining unit and a bill data reconciliation unit. The bill data obtaining unit is configured to obtain first bill data corresponding to a first medical testing project in the first bill file and second bill data corresponding to the first medical testing project in the second bill file based on the first reconciliation mode, the first medical testing project being any medical testing project in the first bill file. The bill data reconciliation unit is configured to reconcile the first bill data and the second bill data according to the one or more target second-bill fields corresponding to the first set of fields to obtain a reconciliation result.

7. An electronic device, comprising: comprising: a memory storing executable program codes; a processor coupled with the memory; the processor invokes the executable program codes stored in the memory to execute the method of any one of claims 1 to 5.

8. A computer-readable storage medium, characterized in that, The computer readable storage medium stores a computer program, wherein the computer program is executed by the processor to make the processor execute the method of any one of claims 1 to 5. The computer readable storage medium stores a computer program, wherein the computer program is executed by the processor to make the processor execute the method of any one of claims 1 to 5.

Citation Information

Patent Citations

  • Bill generation method and device, medium and electronic equipment

    CN113379523A