阅读说明：本技术 一种账单稽核的方法和系统 (Method and system for checking bills ) 是由 王娟 佀华闯 周朝龙 胥龙霄 沈彤 于 2021-08-19 设计创作，主要内容包括：本发明公开了网络数据领域的一种账单稽核的方法和系统,包括：获取数据信息,分别进行首页汇总数据稽核、账户级明细数据稽核、订户级明细数据稽核、详单明细数据稽核；根据获取数据信息并将所获取的数据信息分为首页汇总数据、账户级明细数据、订户级明细数据和详单明细数据,对各组数据的费用进行分项汇总以及自洽,获取各组数据属性值进行对比稽核,实现自动化账单稽核,判断出帐是否成功,降低人工出错概率,提升出帐效率。(The invention discloses a method and a system for checking bills in the field of network data, which comprises the following steps: acquiring data information, and respectively auditing the first page summary data, account level detail data, subscriber level detail data and detailed detail data; according to the method, the data information is obtained and divided into the header summary data, the account level detail data, the subscriber level detail data and the detailed statement detail data, the charges of all groups of data are collected in different items and are self-consistent, the attribute values of all groups of data are obtained to be compared and audited, automatic bill auditing is achieved, whether the account is successfully checked is judged, the probability of manual errors is reduced, and the account checking efficiency is improved.)

1. A method for checking bills comprises

Acquiring data information of a bill to be audited, and dividing the acquired data information into header page summarized data, account level detail data, subscriber level detail data and detail data;

collecting the expense sub-items of the first page summarized data and carrying out self-consistency, acquiring the attribute value of the first page summarized data, and storing the first page summarized data and the attribute value thereof as the sub-item value;

the expense details of each expense subentry in each account level detail data are listed and self-consistent, the self attribute value of the account level detail data is obtained, and the account level detail data and the attribute value thereof are stored as subentry values; comparing and auditing the subentry value of the account level detail data and the corresponding subentry value of the first page summarized data;

listing and self-consistent expense details of each expense subentry in each subscriber-level detail data, acquiring the attribute value of the subscriber-level detail data, and storing the subscriber-level detail data and the attribute value thereof as subentry values; comparing and auditing the itemized values of the subscriber-level detail data and the corresponding itemized values of the account-level detail data;

comparing and auditing the summary of each expense in the detailed schedule detail data with the total expense in the subscriber-level detail data;

and outputting a judgment result of whether the bill to be audited is correct or not according to all self-consistency and comparison audit results.

2. The method of claim 1 wherein the attribute values of the data information include node name, node type, parent node and child node.

3. The method of claim 1, wherein the values of the account level detail data are listed in the form of classes, each class having a corresponding classification value, the columns are accumulated to form corresponding values, and the values of the account level detail data and the classification values are compared to determine whether the data are equal to the data collected from the top page; and when the classification value and the classification value of the comparison account level detail data are not equal to the first page summarized data, returning a corresponding column or class set, and comparing and auditing the elements of the set with the first page summarized data one by one.

4. The method of claim 3, wherein the ratings of the subscriber-level detail data are tabulated in classes, and are aggregated for each class as a classification value, and wherein each column is aggregated as a classification value, and wherein the account-level detail data is audited against the classification value and the classification value of the subscriber-level detail data.

5. The method as claimed in claim 1, wherein the self-consistency of the first page summary audit data, the self-consistency of the account level detail data and the self-consistency of the subscriber level detail data are used to determine whether the summary of the cost components is equal to the corresponding total cost.

6. The method of claim 1 wherein the detail statement data is a consumption record for each charge, the detail statement data and the subscriber-level detail data being compared one by one in the detail statement audit.

7. The method of claim 1, wherein the steps of the bill auditing method are implemented using extensible markup language (XML).

8. The method as claimed in claim 7, wherein the data information of the bill to be audited is stored in xml file format, and the obtaining the data information of the bill to be audited comprises: adopting an mxl.dom.minidom module to open an xml file for storing the data information of the bill to be audited, and enabling a file object to be subjected to dom variable; and obtaining the document elements of the xml file object by adopting documentElement, and giving the obtained document elements to root.

9. A system for bill auditing, comprising:

the acquisition module is used for acquiring data information;

a classification module for classifying the acquired data information into header summary data, account-level detail data, subscriber-level detail data, and detailed-order detail data;

the storage module is used for storing the itemized values of the home page summary data, the account level detail data, the subscriber level detail data and the detailed list detail data;

and the calculation module is used for carrying out summary audit on the home page summary data, the account level detail data, the subscriber level detail data and the detailed detail data and judging whether the data information is abnormal or not.

Technical Field

The invention belongs to the technical field of network data, and particularly relates to bill auditing.

Background

With the coming of 5G communication, a traditional BOSS (Business & Operation Support System) Business Operation Support System becomes more and more complex, has been developed from multi-Business to full-Business mode, has a great variety of Business, and has a more and more complex marketing strategy for packaging each Business into a package, and meanwhile, more and more items are paid, so that a higher requirement is put on the correct result of the billing, and as the bill output by the core, the traditional check of a database layer is not enough to ensure the correct guarantee of the result of the billing.

Disclosure of Invention

The invention aims to provide a method and a system for checking bills, which ensure the correctness of a bill output result.

In order to achieve the purpose, the technical scheme adopted by the invention is as follows:

in a first aspect, the present invention provides a method for bill audit, comprising

Acquiring data information of a bill to be audited, and dividing the acquired data information into header page summarized data, account level detail data, subscriber level detail data and detail data;

collecting the expense sub-items of the first page summarized data and carrying out self-consistency, acquiring the attribute value of the first page summarized data, and storing the first page summarized data and the attribute value thereof as the sub-item value;

the expense details of each expense subentry in each account level detail data are listed and self-consistent, the self attribute value of the account level detail data is obtained, and the account level detail data and the attribute value thereof are stored as subentry values; comparing and auditing the subentry value of the account level detail data and the corresponding subentry value of the first page summarized data;

listing and self-consistent expense details of each expense subentry in each subscriber-level detail data, acquiring the attribute value of the subscriber-level detail data, and storing the subscriber-level detail data and the attribute value thereof as subentry values; comparing and auditing the itemized values of the subscriber-level detail data and the corresponding itemized values of the account-level detail data;

comparing and auditing the summary of each expense in the detailed schedule detail data with the total expense in the subscriber-level detail data;

and outputting a judgment result of whether the bill to be audited is correct or not according to all self-consistency and comparison audit results.

Preferably, the attribute values of the data information include a node name, a node type, a parent node, and a child node.

Preferably, each item value of the account-level detail data is listed in a class form, each class has a corresponding classification value, each column is accumulated to form a corresponding classification value, and the classification value of the account-level detail data are compared to judge whether the summary data of the first page are equal or not; and when the classification value and the classification value of the comparison account level detail data are not equal to the first page summarized data, returning a corresponding column or class set, and comparing and auditing the elements of the set with the first page summarized data one by one.

Preferably, the individual item values of the subscriber-level detail data are listed in the form of classes, and are summarized as classification values for each class, and are summarized as classification values for each column, and the account-level detail data are audited in comparison with the classification values and the classification values of the subscriber-level detail data.

Preferably, the self-consistency of the first page summary audit data, the self-consistency of the account level detail data and the self-consistency of the subscriber level detail data are used for judging whether the summary of the fees is equal to the corresponding total fee.

Preferably, the detail specification data is a consumption record of each expense, and the detail specification data and the subscriber-level specification data are compared one by one in the detail specification audit.

Preferably, the steps of the bill auditing method are implemented by using extensible markup language XML.

Preferably, the data information of the bill to be audited is stored in an xml file format, and the acquiring the data information of the bill to be audited includes: adopting an mxl.dom.minidom module to open an xml file for storing the data information of the bill to be audited, and enabling a file object to be subjected to dom variable; and obtaining the document elements of the xml file object by adopting documentElement, and giving the obtained document elements to root.

In a second aspect, the present invention provides a system for bill auditing, comprising:

the acquisition module is used for acquiring data information;

a classification module for classifying the acquired data information into header summary data, account-level detail data, subscriber-level detail data, and detailed-order detail data;

the storage module is used for storing the itemized values of the home page summary data, the account level detail data, the subscriber level detail data and the detailed list detail data;

and the calculation module is used for carrying out summary audit on the home page summary data, the account level detail data, the subscriber level detail data and the detailed detail data and judging whether the data information is abnormal or not.

Compared with the prior art, the invention has the following beneficial effects:

according to the method and the device, the charges of each group of data are collected in different items and are self-consistent according to the acquired data information and the acquired data information is divided into the header page summarized data, the account level detailed data, the subscriber level detailed data and the detailed list detailed data, the attribute values of each group of data are acquired for comparison and audit, automatic bill audit is realized, whether the account is successfully checked is judged, the probability of manual errors is reduced, and the account checking efficiency is improved.

The branch values of the account level detail data are listed in a class form, each class has a corresponding classification value, each column is accumulated to form a corresponding classification value, the classification values and the classification values of the account level detail data are compared with the home page summary data, and the classification values of the account level detail data are directly compared, so that the calculation amount can be reduced, the auditing efficiency is improved, the payment process is accelerated, and the extremely high-efficiency economic benefit is brought to the operation of each communication operator.

Drawings

Fig. 1 is a flowchart of a method for checking bills according to an embodiment of the present invention.

Detailed Description

The invention is further described below with reference to the accompanying drawings. The following examples are only for illustrating the technical solutions of the present invention more clearly, and the protection scope of the present invention is not limited thereby.

Example one

As shown in fig. 1, a method for checking bills, which uses XML as extensible markup language to check bills; the method comprises the steps of acquiring data information and dividing the acquired data information into header summary data, account level detail data, subscriber level detail data and detailed statement detail data; the data information of the bill to be audited is stored in an xml file format, and the acquiring of the data information of the bill to be audited comprises the following steps: adopting an mxl.dom.minidom module to open an xml file for storing the data information of the bill to be audited, and enabling a file object to be subjected to dom variable; obtaining the document elements of the xml file object by adopting documentElement, and sending the obtained document elements to root; each piece of data information has a node name, a node type, father node attributes and child node attributes, and a data information attribute value is obtained through Python programming;

the method comprises the steps of primary page summary audit, wherein the cost of primary page summary data comprises package rent, use cost, international long-distance cost, special use cost, real object staging cost, carrier billing cost, past historical arrearage total cost, current cost and total cost; and summarizing the expense subentries of the first page summarized data and carrying out self-consistency, acquiring the attribute value of the first page summarized data, and storing the first page summarized data and the attribute value thereof as subentries.

The self-consistency of the home page summarized data mainly judges whether the SUM [ package rent, use cost, international long-distance cost, special use cost, real object staging cost, carrier billing cost, past history arrearage total cost and current cost ] = total cost ] and the SUM [ package rent, use cost, international long-distance cost, special use cost, real object staging cost and carrier billing cost ] = current cost ] are satisfied.

Account level detail audit, wherein the cost of account level detail data comprises all subscriber package rent fees, all subscriber use fee fees, all subscriber international long distance fees, all subscriber special use fee fees, all real staging fees, all subscriber carrier billing fees, historical arrearages of each current period under the account, current period fees under the account and total fees under the account; and listing and self-consistency the charge details of each charge item in each account level detail data, acquiring the attribute value of the account level detail data, and storing the account level detail data and the attribute value thereof as item values.

The account level detail data self-consistency mainly judges that ' SUM [ package rent charge + use charge + international long distance charge + special use charge + real object installment charge + carrier billing charge + past history arrearage total charge + current period charge ] = total charge of each account ' of each account level and ' SUM [ package rent charge detail ] = package rent charge account level total amount ', ' SUM [ use charge detail ] = use charge account level total amount of account level ', ' SUM [ international long distance charge detail ] = international long distance charge account level total amount ', ' SUM [ special use charge detail ] = special use charge account level total amount ', ' SUM [ international long distance charge detail ] = international long distance charge account level total amount ', ' account level SUM [ real object charge detail ] = real object charge account level total amount Whether the SUM [ carrier billing expense detail ] = carrier billing expense account grade SUM and the SUM [ past historical debt total expense detail ] = past historical debt total expense account grade SUM of account grade "of account grade is satisfied or not is judged.

The method comprises the following steps that various item values of account-level detail data are listed in a class form, each class has a corresponding classification value, each column is accumulated to form a corresponding sublist value, the sublist value is used as a new element to be arranged at the tail of each column, and whether the sublist value and the classification value of the account-level detail data are equal to the summarized data of a first page or not is compared; by directly comparing the sorting value and the classification value of the account level detail data, the operation amount can be reduced, and the auditing efficiency is improved.

When the sorting value and the classification value of the compared account-level detail data are not equal to the first-page summarized data, the method returns a corresponding column or class set, and whether elements of the set are the same as the first-page summarized data one by one is compared to determine specific wrong data information.

Subscriber-level detail audit, the fees in the subscriber-level detail data including package rental fees per subscriber, royalty fees per subscriber, international long distance fees per subscriber, special royalty fees per subscriber, per-subscriber real-life fees, carrier billing fees per subscriber, current fees per subscriber; and listing and self-consistency the charge details of each charge item in each subscriber-level detail data, acquiring the attribute value of the subscriber-level detail data, and storing the subscriber-level detail data and the attribute value thereof as item values.

The subscriber-level detail data is self-consistent mainly by judging "SUM of each subscriber [ package rent + use charge + international long distance charge + special use charge + real staging charge + carrier billing charge ] = total charge per subscriber" and "SUM of subscriber level [ package rent detail ] = package rent subscriber level total amount", "SUM of subscriber level [ use charge detail ] = use charge subscriber level total amount", "SUM of subscriber level [ international long distance charge detail ] = international long distance charge subscriber level total amount", "SUM of subscriber level [ special use charge detail ] = special use charge subscriber level total amount", "", "subscriber-level SUM [ international long distance details ] = international long distance subscriber-level total amount", "subscriber-level SUM [ real staging costs details ] = real staging costs subscriber-level total amount", "subscriber-level SUM [ carrier billing costs details ] = carrier billing costs subscriber-level total amount" holds.

The classification values of the subscriber-level detail data are listed in a class form, each class is summarized into a classification value, each column is summarized into a classification value, the account-level detail data and the classification values of the subscriber-level detail data are compared and audited, and the amount of operation can be reduced and the auditing efficiency can be improved by comparing the classification values and the classification values.

Detailed list detail audit: the detailed data is consumption records of all expenses, and the consumption records comprise service types (voice, short message, data, domestic roaming, international roaming and international long distance), called parties, Unit types (duration, flow and times) of charging units, charging use data (XX minutes, YY flow and ZZ times) and actual deduction amount; comparing the detailed schedule detail data and the subscriber-level detail data information item by item; and comparing and auditing the total cost in the detailed list detailed data and the total cost in the subscriber-level detailed data, and outputting a judgment result of whether the bill to be audited is correct or not according to all self-consistency and comparison auditing results.

Example two

A system for bill auditing, comprising:

the acquisition module is used for acquiring data information;

a classification module for classifying the acquired data information into header summary data, account-level detail data, subscriber-level detail data, and detailed-order detail data;

the storage module is used for storing the itemized values of the home page summary data, the account level detail data, the subscriber level detail data and the detailed list detail data;

and the calculation module is used for carrying out summary audit on the home page summary data, the account level detail data, the subscriber level detail data and the detailed detail data and judging whether the data information is abnormal or not.

For the specific method steps for implementing the corresponding functions by the modules, reference may be made to embodiment one, and details are not described herein.

As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.

The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

The above description is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, several modifications and variations can be made without departing from the technical principle of the present invention, and these modifications and variations should also be regarded as the protection scope of the present invention.