CN114596147A

CN114596147A - Data reconciliation method and device, computer equipment and storage medium

Info

Publication number: CN114596147A
Application number: CN202210241714.6A
Authority: CN
Inventors: 杨芳; 李福涛; 刘佳; 张家豪; 陈伟
Original assignee: Kingdee Software China Co Ltd
Current assignee: Kingdee Software China Co Ltd
Priority date: 2022-03-11
Filing date: 2022-03-11
Publication date: 2022-06-07

Abstract

The application relates to a data reconciliation method, a data reconciliation device, computer equipment and a storage medium. The method comprises the following steps: responding to item selection operation, and acquiring a target account checking item in the candidate account checking items; configuring subjects, accounting dimensions and report identifications based on the target reconciliation project, and forming a report reconciliation scheme according to the subjects, the accounting dimensions and the report identifications; acquiring corresponding service data according to the access logic; acquiring corresponding first general account data based on the subjects and the accounting dimensionality; and checking the business data and the first general account data based on the report checking scheme to obtain a report checking result. By adopting the method, the multidimensional reconciliation requirement can be met.

Description

Data reconciliation method and device, computer equipment and storage medium

Technical Field

The present application relates to the field of reconciliation technologies, and in particular, to a data reconciliation method, an apparatus, a computer device, and a storage medium.

Background

With the development of modern society, account checking technology appears, and account checking is account checking, which means that in accounting, related data in an account book are checked and checked for ensuring the record of the account book to be correct and reliable. And matching the bills of the two parties to be checked according to the configured field mapping relation and different matching rules, and finally checking the bills which accord with all matching conditions.

In the traditional reconciliation technology, data needing reconciliation is usually exported to a table (excel), then manual reconciliation is carried out, and accounting dimensions are fixed, so that the multidimensional reconciliation requirement cannot be met.

Disclosure of Invention

In view of the foregoing, it is desirable to provide a data reconciliation method, apparatus, computer device and computer readable storage medium capable of satisfying the multidimensional reconciliation requirement.

In a first aspect, the present application provides a data reconciliation method. The method comprises the following steps:

responding to item selection operation, and acquiring a target account checking item in the candidate account checking items;

configuring subjects, accounting dimensions and report identifications based on the target reconciliation project, and forming a report reconciliation scheme according to the subjects, the accounting dimensions and the report identifications;

acquiring corresponding service data according to the access logic;

acquiring corresponding first general account data based on the subjects and the accounting dimensionality;

and checking the business data and the first general account data based on the report checking scheme to obtain a report checking result.

In one embodiment, the method further comprises:

configuring the candidate account checking items based on a preset account checking scene;

and configuring corresponding access logic based on each candidate tie-out item.

In one embodiment, the obtaining the corresponding service data according to the access logic includes:

determining a data fetching logic based on the report identifier;

reading the service field identification in the access logic;

and acquiring corresponding service data based on the service field identification.

In one embodiment, the obtaining corresponding first general ledger data based on the subject and the accounting dimension includes:

acquiring general account data of the subject corresponding to the subject;

and inquiring first general ledger data corresponding to the accounting dimension from the general ledger data of the subject.

In one embodiment, after reconciling the business data and the first general ledger data based on the statement reconciliation scheme, the method includes:

when the account checking result is unbalanced, acquiring an item causing the unbalance;

and taking the item causing the unbalance as an inspection item, and inspecting the reconciliation result to obtain an inspection result.

In one embodiment, the method further comprises:

responding to a parameter selection operation, and selecting the subject, the accounting dimension and a document identifier;

determining a document reconciliation scheme based on the subject, the accounting dimension and the document identification;

acquiring target document data based on the document identification;

acquiring second general ledger data based on the subjects and the accounting dimension;

and carrying out account checking on the target receipt data and the second general account data based on the receipt account checking scheme to obtain a receipt account checking result.

In one embodiment, the method further comprises:

acquiring voucher data corresponding to the second general ledger data;

determining a detailed reconciliation scheme based on the document reconciliation scheme;

and checking the target receipt data and the voucher data based on the detailed checking scheme to obtain a detailed checking result.

In a second aspect, the application further provides a data reconciliation device. The device comprises:

the first acquisition module is used for responding to item selection operation and acquiring a target account checking item in the candidate account checking items;

the forming module is used for configuring subjects, accounting dimensions and report identifications based on the target reconciliation item, and forming a report reconciliation scheme according to the subjects, the accounting dimensions and the report identifications;

the second acquisition module is used for acquiring corresponding service data according to the access logic;

a third obtaining module, configured to obtain corresponding first general ledger data based on the subject and the accounting dimension;

and the report reconciliation module is used for reconciling the business data and the first general account data based on the report reconciliation scheme to obtain a report reconciliation result.

In one embodiment, the apparatus further comprises:

the configuration module is used for configuring the candidate reconciliation items based on a preset reconciliation scene; and configuring corresponding access logic based on each candidate tie-out item.

In one embodiment, the second obtaining module is further configured to determine a fetching logic based on the report identifier; reading the service field identification in the access logic; and acquiring corresponding service data based on the service field identification.

In one embodiment, the third obtaining module is further configured to obtain general ledger data of the subject corresponding to the subject; and inquiring first general ledger data corresponding to the accounting dimension from the general ledger data of the subject.

In one embodiment, the apparatus further comprises:

the checking module is used for acquiring an item causing imbalance when the account checking result is imbalance; and taking the item causing the unbalance as an inspection item, and inspecting the reconciliation result to obtain an inspection result.

In one embodiment, the apparatus further comprises:

the bill reconciliation module is used for responding to parameter selection operation and selecting the subject, the accounting dimension and the bill identification; determining a document reconciliation scheme based on the subject, the accounting dimension and the document identification; acquiring target document data based on the document identification; acquiring second general ledger data based on the subjects and the accounting dimension; and carrying out account checking on the target receipt data and the second general account data based on the receipt account checking scheme to obtain a receipt account checking result.

In one embodiment, the apparatus further comprises:

the detail reconciliation module is used for acquiring the voucher data corresponding to the second general ledger data; determining a detailed reconciliation scheme based on the document reconciliation scheme; and carrying out account checking on the target receipt data and the voucher data based on the detailed account checking scheme to obtain a detailed account checking result.

In a third aspect, the present application also provides a computer device. The computer device comprises a memory storing a computer program and a processor implementing the steps of the above method when executing the computer program.

In a fourth aspect, the present application further provides a computer-readable storage medium. The computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the above-mentioned method.

In a fifth aspect, the present application further provides a computer program product. The computer program product comprises a computer program which, when executed by a processor, carries out the steps of the above-mentioned method.

According to the data reconciliation method, the data reconciliation device, the computer equipment and the storage medium, the reconciliation event scene of business and finance is converted into the corresponding reconciliation item, the subject, the accounting dimension and the report identifier are configured based on the target reconciliation item according to the selection of the target reconciliation item, the report reconciliation scheme is formed according to the subject, the accounting dimension and the report identifier, the corresponding business data and the general account data are automatically reconciled based on the report reconciliation scheme, and most of conventional reconciliation requirements are conveniently and efficiently met. Moreover, aiming at complex and personalized account checking requirements, the configurable document account checking scheme is provided, so that a customer can independently select document data to be checked, the flexibility of account checking data is improved, and the multi-dimensional account checking requirements are met.

Drawings

FIG. 1 is a diagram of an application environment of a data reconciliation method in one embodiment;

FIG. 2 is a flow diagram illustrating a data reconciliation method in one embodiment;

FIG. 3 is a functional overview of data reconciliation;

FIG. 4 is a flow diagram illustrating reconciliation of reports in one embodiment;

FIG. 5 is a flowchart illustrating the document reconciliation step in one embodiment;

FIG. 6 is a functional overview of another data reconciliation;

FIG. 7 is a schematic diagram illustrating a flow of document reconciliation in one embodiment;

FIG. 8 is a block diagram showing the structure of a data reconciliation apparatus in one embodiment;

FIG. 9 is a block diagram showing the construction of a data reconciliation apparatus in another embodiment;

FIG. 10 is a diagram showing an internal structure of a computer device according to an embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of and not restrictive on the broad application.

The data reconciliation method provided by the embodiment of the application can be applied to the application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. The data storage system may store data that the server 104 needs to process. The data storage system may be integrated on the server 104, or may be located on the cloud or other network server. The present application can be executed by the terminal 102 or the server 104, or the terminal 102 and the server 104 cooperate to execute, and the present embodiment takes the terminal 102 as an example for description.

The terminal 102 responds to the item selection operation and obtains a target account checking item in the candidate account checking items; the terminal 102 configures subjects, accounting dimensions and report identifications based on the target reconciliation item, and forms a report reconciliation scheme according to the subjects, the accounting dimensions and the report identifications; the terminal 102 acquires corresponding service data according to the access logic; the terminal 102 acquires corresponding first general account data based on subjects and accounting dimensions; the terminal 102 performs reconciliation on the business data and the first general account data based on the statement reconciliation scheme to obtain a statement reconciliation result.

The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, internet of things devices and portable wearable devices, and the internet of things devices may be smart speakers, smart televisions, smart air conditioners, smart car-mounted devices, and the like. The portable wearable device can be a smart watch, a smart bracelet, a head-mounted device, and the like. The terminal 102 has installed therein a parent application, such as a reconciliation platform, which can be a reconciliation platform that sets all financial reconciliation in the terminal 102 or the server 104 for maintenance and has a unified reconciliation entry. The server 104 may be implemented as a stand-alone server or as a server cluster comprised of multiple servers.

In one embodiment, as shown in fig. 2, a data reconciliation method is provided, which can be executed by the terminal 102 or the server 104, or by the terminal 102 and the server 104 cooperatively, and which is described by taking the terminal 102 as an example, and includes the following steps:

s202, responding to item selection operation, and acquiring a target account checking item in the candidate account checking items.

The item can be defined according to the business and finance reconciliation event after the business and finance (industry and finance) reconciliation event is made into a scene, and the item can be receivable, payable, temporary estimate payable, inventory, fund, fixed asset, original value of the asset, accumulated depreciation, depreciation and commodity sending and the like. For example, when the reconciliation event is receivable, the reconciliation event is preset as a receivable scene, and a corresponding item corresponding to the reconciliation event is receivable.

The candidate reconciliation item can refer to a reconciliation item to be selected in the reconciliation platform, for example, when the corresponding reconciliation item in the reconciliation platform has receivable, payable, tentatively estimated payable, inventory, fund, fixed asset, original asset value, accumulated depreciation, depreciation preparation and issued commodity, the candidate reconciliation item is receivable, payable, tentatively estimated payable, inventory, fund, fixed asset, original asset value, accumulated depreciation, depreciation preparation and issued commodity. The target reconciliation item can refer to a reconciliation item selected from candidate reconciliation items, for example, the candidate reconciliation item is receivable, payable, tentatively estimated payable, inventory, fund, fixed asset, original value of asset, accumulated depreciation, decrement value preparation and commodity issue, and the user selects a corresponding reconciliation item 'receivable' in the candidate reconciliation item in the reconciliation platform according to the requirement of the user, namely, the target reconciliation item is determined to be 'receivable'.

In one embodiment, before S202, the terminal configures candidate reconciliation items based on a preset reconciliation scenario; and configuring corresponding access logic based on each candidate reconciliation item.

The reconciliation scene may refer to a reconciliation scene generated after a reconciliation event is schematized, the preset reconciliation scene may be a preset reconciliation scene, and the preset reconciliation scene may be used for configuring corresponding candidate reconciliation items, for example, the reconciliation event may be defined as ten scenes, namely, a scene of account receivable, a scene of account payable, a scene of temporary estimate payable, a scene of inventory, a scene of fund, a scene of fixed asset, a scene of original asset value, a scene of accumulated depreciation, a scene of reduced value preparation and a scene of commodity issue, and the corresponding preset reconciliation scene may be a scene of account receivable, a scene of account payable, a scene of temporary estimate payable, a scene of inventory, a scene of fund, a scene of fixed asset, a scene of original asset value, a scene of accumulated depreciation, a scene of reduced value preparation and a scene of commodity issue, and the configured candidate reconciliation items may be paid, Due payment, due on hold, inventory, funds, fixed assets, original value of assets, accumulated depreciation, depreciation preparation and shipment. The access logic can refer to the limitation of access flow, access range and other parameters related to access of the business report.

For example, as shown in fig. 3, a functional overview of data reconciliation, in detail, a functional overview of reconciliation of business statements, the functional overview includes four parts of a reconciliation type, a reconciliation statement, a reconciliation scheme, and a reconciliation result. Firstly, the reconciliation type (candidate reconciliation item) is configured based on the preset reconciliation scene, the reconciliation type can be receivable, payable, due for tentative estimation, inventory, fund, fixed asset and the like, and then the corresponding reconciliation report is determined according to the reconciliation type, as can be seen in the figure, the reconciliation type is 'accounts receivable', the corresponding reconciliation report is 'accounts receivable', the reconciliation type is 'accounts receivable', the account checking report can be corresponding to an account receivable report, the account checking type is an account receivable, the account checking report can be corresponding to an account payable report, the account checking type is a tentatively estimated account payable, the reconciliation report can be corresponding to 'temporarily estimated due report' and 'inventory' type, the reconciliation report can be corresponding to 'inventory report' and 'fund' type, the reconciliation report which can be corresponded is a capital report, the reconciliation type is a fixed asset, and the reconciliation report which can be corresponded is a fixed asset report. When account checking subjects (subjects), account checking dimensionality (accounting dimensionality), account checking reports, report filtering conditions, account checking subject value sources and the like in the account checking and fetching device are determined, corresponding general account data and an account checking scheme are determined, and the account checking and fetching device can be a software module installed in an account checking platform. After account checking is carried out based on the account checking scheme, a corresponding account checking result is obtained, and account checking difference analysis and account checking early warning can be carried out according to the account checking result. The reconciliation early warning can be used for generating a corresponding early warning prompt message when the reconciliation result is unbalanced.

Specifically, the terminal displays all candidate reconciliation items in a corresponding reconciliation scheme setting page in response to item selection operation, and acquires a target reconciliation item in the candidate reconciliation items.

S204, configuring subjects, accounting dimensions and report identifications based on the target reconciliation item, and forming a report reconciliation scheme according to the subjects, the accounting dimensions and the report identifications.

The subject may refer to a subject in the general ledger, that is, a general ledger subject, where the general ledger subject includes an asset class, a liability class, a common class, an owner equity class, a cost class, a profit and loss class, and for example, the subject of the asset class in the general ledger subject includes: accounts receivable, pre-receivables, bills due, and employee compensation due, among others, and the cost-based items in the general ledger items include: production costs, manufacturing costs, labor costs, and development expenditures, among others, and the categories of profit and loss in general ledger include: business revenue, interest revenue, investment revenue, sales costs, administrative costs, and the like. The accounting dimension may refer to an accounting dimension of the general ledger data, which is used for classifying or screening the general ledger data, and includes clients, sales personnel, departments, and the like. The report identifier may refer to an identifier of the business report, and the identifier may be used to obtain business data in the corresponding report, for example, when the report identifier may be an accounts receivable statement. The statement reconciliation scheme may refer to a scheme for reconciling the business data with the general ledger data in the statement, for example, the statement reconciliation scheme is a reconciliation scheme between the business data in the accounts receivable detail table and the general ledger data determined by the subject for accounts receivable and for the customer for accounting dimensions.

Specifically, the terminal configures subjects, accounting dimensions and report identifiers based on the target reconciliation item, responds to the selection operation of the subjects, the accounting dimensions and the report identifiers, sequentially determines corresponding subjects, the accounting dimensions and the report identifiers, and forms a report reconciliation scheme according to the subjects, the accounting dimensions and the report identifiers.

For example, when the target reconciliation item is receivable, the user selects corresponding subjects as receivable and pre-receivable, the accounting dimension is the client, the report identifier (business report) is a receivable detail table, and a corresponding report reconciliation scheme is formed according to the reconciliation item "receivable", the subjects "receivable" and "pre-receivable", the accounting dimension "client", and the report identifier "receivable detail table".

And S206, acquiring corresponding service data according to the access logic.

The access logic may refer to the limitation of access-related parameters such as an access flow and an access range of the business report, and the access flow may refer to an access step of the business report, for example, the access flow may be to determine the access range of the business report first and then obtain the business data in the business report according to the access range. The access range may refer to which business fields in the business report identify corresponding business data, for example, the report identifier is an account receivable list, and the business field identifier in the access range is a current unit code, a current unit name, a business description, a bill type, a bill code, and a business date.

Specifically, the terminal determines the access logic based on the report identifier; reading a service field identifier in the access logic; and acquiring corresponding service data based on the service field identification.

For example, the report identifier is a list of accounts receivable, and the service field identifier in the access logic is read, where the service field identifier is a current unit code, a current unit name, and a service description. Acquiring service data 'CUST 0001', 'CUST 0002' and 'CUST 0003' corresponding to the service field identifier 'to-and-fro unit code'; and acquiring business data 'company A', 'company B' and 'company C' corresponding to the business field identification 'to-and-fro unit name'. And acquiring service data 'initial balance', 'receivable occurrence amount' and 'collection amount' corresponding to the service field identification 'service description'.

And S208, acquiring corresponding first general ledger data based on the subjects and the accounting dimensionality.

The general ledger data is the core of financial system software, all the business data are collected to a general ledger system for processing after generating the voucher, and the general ledger data can also be used for voucher making work of daily business such as collection, payment and reimbursement; all financial processing work from account establishment, daily business, account book inquiry to monthly payment and the like is realized in the general ledger system. The term "first" in the first general ledger data is used for distinguishing "second" and the like hereinafter, and represents general ledger data distinguished from the second general ledger data, that is, the first general ledger data is different from the second general ledger data, and for example, the first general ledger data may refer to data in a subject balance table. The subject balance table may be a basic conference account table, which is a balance of each subject, and includes an initial balance, a current generation amount, a final balance, and the like.

Specifically, the terminal acquires subject general ledger data corresponding to a subject; and inquiring first general account data corresponding to the accounting dimension from the account general account data.

For example, the subject is accounts receivable, the accounting dimension is client, the client reports the client 1, the client 2 and the client 3, and the terminal acquires the subject general ledger data corresponding to the subject which is the accounts receivable; first general ledger data corresponding to the customer 1, the customer 2, and the customer 3 is inquired from the subject general ledger data.

And S210, checking the business data and the first general account data based on the report checking scheme to obtain a report checking result.

The reconciliation may refer to a process of comparing the business data with data corresponding to the general ledger data, for example, a process of comparing current-term increase data in the business data with current-term increase data in the general ledger data. The statement reconciliation result may refer to a reconciliation result of the business data and the first general account data in the business statement, for example, the statement reconciliation result is balanced or unbalanced.

Specifically, the terminal performs reconciliation (comparison) on data of a field corresponding to the business data and the first general account data based on the report reconciliation scheme, judges whether the data between the business data and the first general account data are consistent, and when the data are consistent, the report reconciliation result is balanced, and when the data are inconsistent, the report reconciliation result is unbalanced.

For example, the fields corresponding to the business data and the first general ledger data are "initial balance", "current balance increase", "current decrease" and "end balance", the field corresponding to the field "initial balance" of the business data is 643779700, the field corresponding to the field "current increase" of the business data is 180000, the field corresponding to the field "current decrease" of the business data is 0, the field corresponding to the field "end balance" of the business data is 18000000, the field corresponding to the field "initial balance" of the first general ledger data is 643779700, the field corresponding to the field "current increase" of the business data is 180000.11, the field corresponding to the field "current decrease" of the business data is 150, and the field corresponding to the field "end balance" of the business data is 179850.11. And judging that the data corresponding to the 'initial balance' field, the 'current increase' field, the 'current decrease' field and the 'final balance' field of the business data are consistent, so that the reconciliation results of the business data and the first general account data are unbalanced.

In one embodiment, after S210, the reconciliation difference analysis step comprises: when the account checking result is unbalanced, the terminal acquires an unbalanced item; and taking the items causing the unbalance as inspection items, and inspecting the account checking result to obtain an inspection result.

The item causing the imbalance may refer to an item corresponding to a possible reason for imbalance of the reconciliation result. The check item may refer to an item to be checked or verified, for example, the check item includes: the document does not generate a voucher,

The voucher generated by the voucher does not comprise a specified subject, the voucher is manually input, the source voucher of the voucher does not exist in the business report, the business voucher is matched with the general ledger voucher and the like. The check result may be a result obtained by checking the reconciliation result according to the check item, and the check result may be a pass or a fail, where a pass indicates that the reason corresponding to the check item is not the reason for making the reconciliation result unbalanced, and a fail indicates that the reason corresponding to the check item is the reason for making the reconciliation result unbalanced.

For example, fig. 4 is a schematic flow chart of statement reconciliation in an embodiment, as shown in the figure, the terminal determines the subjects and the accounting dimensions of the corresponding business statement and the general ledger, that is, determines the corresponding business data and the general ledger data, and a corresponding reconciliation scheme (statement reconciliation scheme), performs reconciliation on the business data and the general ledger data according to the reconciliation scheme to obtain a reconciliation result, and performs reconciliation difference analysis on the reconciliation result to obtain a corresponding inspection result.

According to the data reconciliation method, the reconciliation event scenario of the business and the finance is converted into the corresponding reconciliation item, the subject, the accounting dimension and the report identification are configured based on the target reconciliation item according to the selection of the target reconciliation item, a report reconciliation scheme is formed according to the subject, the accounting dimension and the report identification, the corresponding business data and the general account data are automatically reconciled based on the report reconciliation scheme, and most of conventional reconciliation requirements are conveniently and efficiently met. Moreover, aiming at complex and individualized reconciliation requirements, the scheme provides a configurable document reconciliation scheme, so that a client can autonomously select document data to be reconciled, the flexibility of the reconciliation data is improved, and the multi-dimensional reconciliation requirement is met.

In one embodiment, as shown in fig. 5, the document reconciliation step comprises:

and S502, responding to the parameter selection operation, and selecting the subject, the accounting dimension and the document identification.

The document identifier may refer to an identifier of a business document, and the identifier may be used to obtain target document data in a corresponding business document, for example, when the document identifier may be an order to be received. FIG. 6 is a functional overview of another data reconciliation; the method is characterized in that the method comprises a step of checking a document, and a step of checking a document. As shown, the business document types include: receivable order, payable order, payment order, collection order, sales delivery order, purchase storage order, etc. When account checking subjects (subjects), account checking dimensionality (accounting dimensionality), source documents, document value taking conditions, source organization, source accounting dimensionality values, source amount values and the like in the account checking and data taking device are determined, corresponding general account data and an account checking scheme are determined. The reconciliation access device can be a software module installed in the reconciliation platform. After reconciliation is carried out based on the reconciliation scheme, a corresponding total reconciliation result (reconciliation result) is obtained, and detailed reconciliation, detailed reconciliation difference analysis and reconciliation early warning can be carried out according to the reconciliation result. The reconciliation early warning can be used for generating a corresponding early warning prompt message when the reconciliation result is unbalanced.

Specifically, the terminal responds to the parameter selection operation, displays all correspondingly selectable subjects and all accounting dimensions, and selects the subjects, the accounting dimensions and the document identification.

S504, determining a bill reconciliation scheme based on the subject, the accounting dimension and the bill identification.

The document reconciliation scheme may refer to a scheme for reconciling target document data in the business document with general ledger data, for example, the document reconciliation scheme is a reconciliation scheme between target document data in an receivable document and second general ledger data determined by an account for receivable accounts and an accounting dimension for a customer.

Specifically, the terminal can obtain the document reconciliation scheme in the corresponding database based on the subjects, the accounting dimensions and the document identification.

S506, obtaining target bill data based on the bill identification.

Specifically, the terminal determines a corresponding access logic based on the document identifier; reading a document field identifier in the access logic; and acquiring corresponding target document data based on the document field identification.

For example, the bill identification is a payable bill, the bill field identification in the counting logic is read, and the bill field identification is accounting organization, date and currency. Acquiring target document data 'document head, settlement organization' corresponding to the document field identifier 'accounting organization'; and acquiring target document data 'document head, business date' corresponding to the document field identifier 'date'. And acquiring target document data, namely a document head and a currency, corresponding to the document field identifier, namely the currency.

And S508, acquiring second general ledger data based on the subjects and the accounting dimension.

The term "second" in the second general ledger data is used for distinguishing "first" and the like in the text, and represents general ledger data different from the first general ledger data, that is, the first general ledger data and the second general ledger data are different, for example, the second general ledger data may refer to data in a subject balance table.

Specifically, the terminal acquires subject general ledger data corresponding to a subject; and inquiring second general ledger data corresponding to the accounting dimension from the subject general ledger data.

For example, the subject is accounts receivable, the accounting dimension is a department, the department comprises a department 1, a department 2 and a department 3, and the terminal acquires the subject general ledger data corresponding to the subject which is the accounts receivable; second general ledger data corresponding to the department 1, the department 2, and the department 3 are inquired from the subject general ledger data.

And S510, performing account checking on the target bill data and the second general account data based on the bill account checking scheme to obtain a bill account checking result.

The document reconciliation result may refer to a reconciliation result of the target document data and the second general account data in the business document, for example, the document reconciliation result is balanced or unbalanced.

Specifically, the terminal performs account checking (comparison) on data of a field corresponding to the target document data and the second general account data based on the document account checking scheme, judges whether the data between the target document data and the second general account data are consistent, and when the data are consistent, the document account checking result is balanced, and when the data are inconsistent, the document account checking result is unbalanced.

In one embodiment, after S510, the reconciliation difference analysis step comprises: when the account checking result is unbalanced, the terminal acquires an unbalanced item; and taking the items causing the unbalance as inspection items, and inspecting the account checking result to obtain an inspection result.

The check result may be a result obtained by checking the reconciliation result according to the check item, and the check result may be a pass or a fail, where a pass indicates that the reason corresponding to the check item is not the reason for making the reconciliation result unbalanced, and a fail indicates that the reason corresponding to the check item is the reason for making the reconciliation result unbalanced.

In one embodiment, after S510, the terminal acquires credential data corresponding to the second general ledger data; determining a detailed reconciliation scheme based on the document reconciliation scheme; and performing reconciliation on the target document data and the voucher data based on the detailed reconciliation scheme to obtain a detailed reconciliation result, and performing detailed reconciliation difference analysis on the detailed reconciliation result to obtain a corresponding inspection result.

The voucher data is generated according to the target receipt data, the voucher data can be used for generating second general ledger data, and the second general ledger data and the voucher data are in a corresponding relation. The detail reconciliation scheme may be a scheme for reconciling target document data with credential data in a document.

For example, FIG. 7 is a schematic diagram illustrating a flow of document reconciliation in one embodiment; as shown in the figure, the terminal determines the business clause and the subject and the accounting dimension of the general ledger, that is, determines corresponding target document data and general ledger data and a corresponding reconciliation scheme (document reconciliation scheme), performs reconciliation on the target document data and the general ledger data according to the document reconciliation scheme to obtain a document reconciliation result (summary reconciliation result), and performs reconciliation difference analysis on the reconciliation result to obtain a corresponding inspection result. And generating a corresponding detailed reconciliation scheme according to the document reconciliation scheme, reconciling the target document data and the voucher data according to the detailed reconciliation scheme to obtain a detailed reconciliation result, and performing reconciliation difference analysis on the detailed reconciliation result to obtain a corresponding inspection result.

In the embodiment, the configurable document reconciliation scheme is provided, so that a customer can independently select document data which is required to be reconciled for reconciliation, the flexibility of the reconciliation data is improved, the requirement of multidimensional reconciliation is met, further, the detailed reconciliation scheme for the document reconciliation is also provided, and the reason of unbalanced document reconciliation results can be quickly and conveniently checked.

It should be understood that, although the steps in the flowcharts related to the embodiments are shown in sequence as indicated by the arrows, the steps are not necessarily executed in sequence as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a part of the steps in the flowcharts related to the above embodiments may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of performing the steps or stages is not necessarily sequential, but may be performed alternately or alternately with other steps or at least a part of the steps or stages in other steps.

Based on the same inventive concept, the embodiment of the application also provides a data reconciliation device for realizing the data reconciliation method. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme recorded in the method, so that specific limitations in one or more embodiments of the data reconciliation device provided below can be referred to the limitations on the data reconciliation method in the foregoing, and details are not repeated herein.

In one embodiment, as shown in fig. 8, there is provided a data reconciliation apparatus comprising: a first obtaining module 802, a forming module 804, a second obtaining module 806, a third obtaining module 808, and a report reconciliation module 810, wherein:

a first obtaining module 802, configured to obtain a target reconciliation item in the candidate reconciliation items in response to an item selection operation;

the forming module 804 is used for configuring subjects, accounting dimensions and report identifications based on the target reconciliation item, and forming a report reconciliation scheme according to the subjects, the accounting dimensions and the report identifications;

a second obtaining module 806, configured to obtain corresponding service data according to the access logic;

a third obtaining module 808, configured to obtain corresponding first general ledger data based on the subject and the accounting dimension;

the report reconciliation module 810 is configured to perform reconciliation on the service data and the first general ledger data based on the report reconciliation scheme, so as to obtain a report reconciliation result.

In one embodiment, the second obtaining module 806 is further configured to determine a fetching logic based on the report identifier; reading a service field identifier in the access logic; and acquiring corresponding service data based on the service field identification.

In one embodiment, the third obtaining module 808 is further configured to obtain general ledger data of the subject corresponding to the subject; and inquiring first general account data corresponding to the accounting dimension from the account general account data.

In one embodiment, as shown in fig. 9, the data reconciliation apparatus further includes: a configuration module 812, a document reconciliation module 814, a detail reconciliation module 816, and an inspection module 818, wherein:

a configuration module 812, configured to configure candidate reconciliation items based on a preset reconciliation scenario; and configuring corresponding access logic based on each candidate reconciliation item.

The document reconciliation module 814 is used for responding to the parameter selection operation and selecting the subject, the accounting dimension and the document identifier; determining a document reconciliation scheme based on the subject, the accounting dimension and the document identification; acquiring target document data based on the document identification; acquiring second general ledger data based on the subjects and the accounting dimension; and carrying out account checking on the target bill data and the second general account data based on the bill account checking scheme to obtain a bill account checking result.

The detail reconciliation module 816 is configured to obtain credential data corresponding to the second general ledger data; determining a detailed reconciliation scheme based on the document reconciliation scheme; and carrying out reconciliation on the target document data and the voucher data based on the detailed reconciliation scheme to obtain a detailed reconciliation result.

A checking module 818, configured to, when the reconciliation result is unbalanced, obtain an item that causes the unbalance; and taking the items causing the unbalance as inspection items, and inspecting the account checking result to obtain an inspection result.

The method comprises the steps of performing scenario of account checking events of business and finance into corresponding account checking items, configuring subjects, accounting dimensions and report identifications based on the target account checking items according to selection of the target account checking items, forming a report account checking scheme according to the subjects, the accounting dimensions and the report identifications, and automatically checking corresponding business data and general account data based on the report account checking scheme, so that most conventional account checking requirements are met conveniently and efficiently. Moreover, aiming at complex and personalized account checking requirements, the configurable document account checking scheme is provided, so that a client can independently select data to be checked, the flexibility of account checking data is improved, and the multi-dimensional account checking requirements are met.

The modules in the data reconciliation device can be wholly or partially realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.

In one embodiment, a computer device is provided, where the computer device may be a terminal or a server, and the present embodiment is described by taking a terminal as an example, and its internal structure diagram may be as shown in fig. 10. The computer apparatus includes a processor, a memory, an input/output interface, a communication interface, a display unit, and an input device. The processor, the memory and the input/output interface are connected by a system bus, and the communication interface, the display unit and the input device are connected by the input/output interface to the system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The input/output interface of the computer device is used for exchanging information between the processor and an external device. The communication interface of the computer device is used for communicating with an external terminal in a wired or wireless manner, and the wireless manner can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program is executed by a processor to implement a data reconciliation method. The display unit of the computer equipment is used for forming a visual and visible picture, and can be a display screen, a projection device or a virtual reality imaging device, the display screen can be a liquid crystal display screen or an electronic ink display screen, the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.

Those skilled in the art will appreciate that the architecture shown in fig. 10 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.

In one embodiment, a computer device is provided, comprising a memory in which a computer program is stored and a processor, which when executing the computer program implements the embodiments described above.

In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored, which when executed by a processor, implements the embodiments described above.

In an embodiment, a computer program product is provided comprising a computer program which, when executed by a processor, implements the embodiments described above.

It should be noted that, the user information (including but not limited to user equipment information, user personal information, etc.) and data (including but not limited to data for analysis, stored data, displayed data, etc.) referred to in the present application are information and data authorized by the user or sufficiently authorized by each party, and the collection, use and processing of the related data need to comply with the relevant laws and regulations and standards of the relevant country and region.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware related to instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high-density embedded nonvolatile Memory, resistive Random Access Memory (ReRAM), Magnetic Random Access Memory (MRAM), Ferroelectric Random Access Memory (FRAM), Phase Change Memory (PCM), graphene Memory, and the like. Volatile Memory can include Random Access Memory (RAM), external cache Memory, and the like. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others. The databases referred to in various embodiments provided herein may include at least one of relational and non-relational databases. The non-relational database may include, but is not limited to, a block chain based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic devices, quantum computing based data processing logic devices, etc., without limitation.

All possible combinations of the technical features in the above embodiments may not be described for the sake of brevity, but should be considered as being within the scope of the present disclosure as long as there is no contradiction between the combinations of the technical features.

The above examples only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present application. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present application shall be subject to the appended claims.

Claims

1. A method for reconciling data, the method comprising:

acquiring corresponding service data according to the access logic;

2. The method of claim 1, further comprising:

3. The method of claim 1, wherein the obtaining the corresponding service data according to the access logic comprises:

determining a data fetching logic based on the report identifier;

reading the service field identification in the access logic;

4. The method of claim 1, wherein the obtaining corresponding first general ledger data based on the subject and the accounting dimension comprises:

acquiring general account data of the subject corresponding to the subject;

and inquiring first general ledger data corresponding to the accounting dimensionality from the subject general ledger data.

5. The method of claim 1, wherein after reconciling the business data with the first summary data based on the statement reconciliation scheme, the method comprises:

6. The method of claim 1, further comprising:

determining a bill reconciliation scheme based on the subject, the accounting dimension and the bill identification;

acquiring target document data based on the document identification;

7. The method of claim 6, further comprising:

acquiring credential data corresponding to the second general ledger data;

and carrying out account checking on the target receipt data and the voucher data based on the detailed account checking scheme to obtain a detailed account checking result.

8. A data reconciliation apparatus, the apparatus comprising:

the forming module is used for configuring subjects, accounting dimensions and report identifications based on the target reconciliation project and forming a report reconciliation scheme according to the subjects, the accounting dimensions and the report identifications;

9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of the method of any of claims 1 to 7.

10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.