Detailed Description
The following description of the embodiments of the present invention will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are some, but not all embodiments of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The method for checking the business data and the financial data provided by the embodiment can be applied to an application environment as shown in fig. 1, wherein a client communicates with a server through a network. Clients include, but are not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices. The server may be implemented by a stand-alone server or a server cluster formed by a plurality of servers. The server stores the financial system and the business system, and in some cases, the service may provide only one integrated system with both the financial processing function and the business processing function. Financial staff can access the server through the client and acquire business data and financial data to be checked from a business system and a financial system on the server respectively.
In one embodiment, as shown in fig. 2, a method for checking business data and financial data is provided, and the method is applied to the server in fig. 1 for illustration, and includes the following steps:
s10, receiving service data sent by a service system, and recording a first appointed storage path of the service data in the service system.
The business system is an information system for supporting the business processing procedure in a targeted manner, and can provide powerful tool support for completing the work items. If the service data generated in the service system relates to settlement of the amount of money, the service system transmits the part of the service data to a server for converting the service data into financial data. Meanwhile, the server side records the received business data in a first appointed storage position in a business system. The first designated storage location of the service data in the service system includes, but is not limited to, a service system number, a service system name, a database where the service data is located, and a data table where the service data is located. Through the first appointed storage path, the position of the service data in the service system can be quickly found out, and then the financial staff can conveniently check the initial record of the service data. It should be noted that the service system may be a separate service system, or may be a subsystem of a comprehensive system having both a financial processing function and a service processing function.
S20, converting the business data into financial data through an accounting processing engine, and storing the financial data in a second designated storage path of the financial system.
In this embodiment, the server is provided with an accounting processing engine, which can convert the acquired service data into financial data. Since the business data generated by the business system belongs to highly programmed data, in other words, each business data is generated by a specific business process. Conversion rules for business data and financial data may thus be determined based on the flow of the business system. The conversion rules may be executed by an accounting processing engine and convert business data into financial data.
After converting the business data into financial data, the obtained financial data is sent to the financial system and stored in a second designated storage path of the financial system. Wherein the second designated storage location of the financial data in the financial system includes, but is not limited to, a financial system number, a financial system name, a database in which the financial data is located, a data table in which the financial data is located.
S30, importing the business data, the first designated storage path, the financial data and the second designated storage path into a preset business account checking table according to designated relative positions, wherein the designated relative positions comprise a first designated table cell area in the business account checking table stored in association with the first designated storage path and a second designated table cell area in the business account checking table stored in association with the second designated storage path, and the position relation between the first designated table cell area and the second designated table cell area comprises adjacent or similar positions.
In this embodiment, the obtained business data, the first designated storage path, the financial data, and the second designated storage path are imported into a preset business accounting table. An industry and property reconciliation table may be preset, and the industry and property reconciliation table may be an empty table before the business data and the financial data are imported. Specifying a relative location refers to determining the relative storage location (i.e., the second specified table cell area) of the financial data when determining the storage location (i.e., the first specified table cell area) of the business data. The positional relationship of the first designated form cell area and the second designated form cell area may be adjacent or similar. Taking the positional relationship as an example, as in table 1, one item of business data is stored in the 10 th row of the left table, and the corresponding financial data may be stored in the 10 th row of the right table. Taking the positional relationship as a similar example, when a first designated form cell area of one business data storage is in the display interface, a second designated form cell area corresponding to the financial data stored in the business data storage is also in the display interface, for example, the first designated form cell area is at the upper left of the display interface, and the second designated form cell area is at the lower right of the display interface.
Each piece of business data and the financial data converted from the business data may be stored in adjacent or similar table cells in the business balance table. For example, in a financial balance sheet, business data may be stored in the left-hand table cell and financial data may be stored in the right-hand table cell. As another example, business data may be stored in an upper table cell and financial data may be stored in a lower table cell. In practical application, the positions of the business data and the financial data in the business accounting table can be properly adjusted, so that the business data and the financial data converted by the business data are simultaneously on the same display interface (a plurality of display interfaces displayed in a split screen mode are regarded as the same display interface here), and thus, consistency of the business data and the financial data can be conveniently checked by financial staff.
As shown in table 1, table 1 is an example financial accounting table. In table 1, the area marked with a thick line frame on the left side is a first designated table cell area, and the area marked with a thick line frame on the right side is a second designated table cell area. Distributing a first appointed form cell area to business data with a field name of 'business A001', and reserving a form cell in the first appointed form cell area for storing a first appointed storage path; the second designated table cell area is further reserved with a table cell for storing a second designated storage path. If the financial data does not accord with the business data, the financial staff can quickly search out the corresponding business data from the business system according to a first appointed storage path in the business accounting table; corresponding financial data can be quickly looked up from the financial system according to the second designated storage path in the financial balance table. In some cases, a corresponding access link may be made based on the first specified storage path and/or the second specified storage path, and when the financial person clicks on the access link, the corresponding access object may be directly accessed.
Table 1 an exemplary financial accounting table
In step S10-S30, service data sent by a service system is received, and a first designated storage path of the service data in the service system is recorded, so as to obtain service data that needs to be converted into financial data. The business data is converted to financial data by an accounting processing engine and the financial data is stored in a second designated storage path of the financial system to convert the business data to financial data. And importing the business data, the first appointed storage path, the financial data and the second appointed storage path into a preset business account checking table according to an appointed relative position, wherein the appointed relative position comprises a first appointed table cell area in the business account checking table stored in an associated mode of the business data and the first appointed storage path, and a second appointed table cell area in the business account checking table stored in an associated mode of the financial data and the second appointed storage path, and the position relation between the first appointed table cell area and the second appointed table cell area comprises adjacent or similar positions so as to form the business account checking table convenient for financial staff to check.
Optionally, as shown in fig. 3, after step S30, the method further includes:
s40, after the business data and the financial data are checked, receiving accounting documents associated with the financial data;
s50, after all accounting vouchers associated with the financial data are received, a report export instruction is received, and an accounting report in a specified period is exported according to the report export instruction, wherein the accounting report is generated based on the financial data.
In this embodiment, an accounting report may also be generated according to the financial data after the verification is completed. When generating accounting statements, accounting documents associated with financial data need to be acquired. Accounting documents refer to written evidence of occurrence or completion of an economic service, and are the basis for registering an account book. Here, the accounting document may refer to an electronic document, may be a scanned document of an accounting document, or may simply record a storage location of the accounting document in paper. Accounting documents can be obtained in an input mode, or can be obtained in a mode of being imported from other systems.
Each piece of financial data requires one or more accounting documents, and the required accounting documents can be determined according to the accounting process in which the financial data is located. The accounting process refers to the process from the generation of accounting documents to the preparation of accounting reports, and can also be an accounting cycle. In the process of accounting, the original certificates, the accounting certificates and other accounting certificates are generated, and different types of accounting reports such as detail accounts, general accounts and the like can be generated by the corresponding accounting certificates. A general accounting report may refer to a system report file that is organized by accounting personnel of an enterprise according to a given period (e.g., month, season, year) according to a given format and category. And the accounting report is automatically generated according to the financial data which is already audited. Here, the financial data after the audit is completed refers to the financial data after the business data and the financial data are checked and the accounting document and the financial data are checked.
In step S40-S50, after the business data and the financial data are checked, an accounting document associated with the financial data is received, so that the financial staff can continuously check the accounting document after checking the business data and the financial data, and the checking efficiency of the financial data is improved. And after determining that all accounting documents associated with the financial data are received, receiving a report export instruction, and exporting an accounting report in a specified period according to the report export instruction, wherein the accounting report is generated based on the financial data, and the accounting report can be exported after checking the accounting documents, so that the efficiency of producing the accounting report is improved.
Optionally, as shown in fig. 4, after step S30, the method further includes:
s31, judging whether the single financial amount converted by the single business amount related in the business data is equal to the actual account-in amount recorded in the financial system, wherein the financial data comprises the actual account-in amount.
S32, if the single financial amount converted by the single business amount related in the business data is not equal to the actual account entry amount recorded in the financial system, adding a first identification mark for the business data and the financial data in the business account checking table.
In this embodiment, the server may also verify a single service amount related to the service data. The accounting processing engine can firstly convert the single business amount related to the business data into the corresponding single financial amount in the financial data, and then judge whether the converted single financial data is equal to the actual account entry amount recorded in the financial system. If the converted single financial data is equal to the actual account amount recorded in the financial system, the business data and the financial data are matched, and the financial staff can reduce the auditing time of the data. The first identification may be bolding, highlighting, changing font color, etc. the corresponding data content. For example, in business data, the arrears of the customer A are 100 yuan, while in financial data, the corresponding actual account deposit amount is only 99 yuan, and the single business amount of the business data and the actual account deposit amount of the financial data are not equal. At this time, the business data and the financial data can be marked as red, and a bright yellow font background is added, so that the financial staff can check conveniently.
In some cases, such as those involving exchange rate conversion, it may result in the individual business amount not being equal to the corresponding individual financial amount, at which time a further check by the financial staff is required to correct the issue of the individual business amount not being equal to the corresponding individual financial amount.
In steps S31-S32, it is determined whether the single financial amount converted from the single service amount related in the service data is equal to the actual account entry amount recorded in the financial system, and the financial data includes the actual account entry amount, so as to automatically check the service data and the amount data related in the financial data. If the single financial amount converted by the single business amount related in the business data is not equal to the actual account entry amount recorded in the financial system, a first identification mark is added for the business data and the financial data in the business financial account checking table, so that financial staff can check some data which may be in error.
Optionally, as shown in fig. 5, step S20 includes:
s201, analyzing the business vocabulary in the business data.
In this embodiment, the accounting processing engine may automatically parse the business vocabulary in the business data. For example, in a business data related to insurance sales, the following are included: the third business person opens the third, the fourth customer plum, the dangerous seed XX, and the underwriting amount is 100 yuan. Wherein the "underwriting amount" is the business vocabulary identified by the accounting processing engine. Upon conversion to financial data, the business vocabulary may be converted to a corresponding financial vocabulary. As another example, where an insurance company provides a guarantee to a first company that an indemnity event has occurred, the business data recorded in the business system may be expressed as: the guarantor insurance company compensates the debtor alpha company for 30 ten thousand yuan. Wherein "compensation" is the business vocabulary identified by the accounting processing engine.
S202, converting the business vocabulary into financial vocabulary according to a preset conversion rule.
Here, the preset conversion rules included in the accounting processing engine may convert the business vocabulary in the business data into the financial vocabulary. The preset conversion rule can convert specific business words in the business data into financial words based on the business process related to the business data. In the above embodiment, the business vocabulary "underwriting amount" may be converted into the financial vocabulary "primary business income" in the business process where it is located; the business vocabulary "compensation" can be converted into the financial vocabulary "other accounts payable" in the business process where it is located.
S203, generating the financial data based on the financial vocabulary and the business data.
In this embodiment, after the business vocabulary is converted into the financial vocabulary, the financial data may be generated by combining the business data. In one example, the generated financial data may be represented as: the third business person opens, the fourth customer is the third, the dangerous seed XX, and the main business income is 100 yuan.
S204, sending the financial data to the financial system, acquiring a storage path of the financial data in the financial system, and marking the storage path of the financial data in the financial system as the second designated storage path.
In this embodiment, the converted financial data is sent to the financial system and stored in the database of the financial system. And simultaneously, the financial system returns the storage path of the financial data in the database to the server. Here, the storage path of the financial data at the financial system may be marked as a second designated storage path. The second designated storage path may be expressed as: db_b\table_b. Wherein the database of the finance system is denoted as DB_B, and the finance data is stored in a database Table with the Table name of Table_B.
In steps S201-S204, the business vocabulary in the business data is parsed to automatically identify the business vocabulary in the business data. And converting the business vocabulary into financial vocabulary according to a preset conversion rule so as to reduce errors of artificial conversion and improve conversion efficiency. And generating the financial data based on the financial vocabulary and the business data so as to reorganize the converted financial vocabulary to form the financial data which is convenient for the financial staff to understand. And sending the financial data to the financial system, acquiring a storage path of the financial data in the financial system, and marking the storage path of the financial data in the financial system as the second designated storage path so as to complete archiving of the financial data.
Optionally, as shown in fig. 6, after step S30, the method further includes:
s33, acquiring the service source of the financial data.
Here, a service source may refer to a service person or a client. The selected service source can be determined according to actual needs. For example, when it is checked whether the business data of a certain business person has a large variation, a business source may be selected as the business person; to check whether there is a large change in the business with a certain customer, the business source can be selected as the customer.
S34, acquiring financial data of the service source in a prior specified period.
The previously specified period may refer to one or more financial audit periods herein. For example, if the financial audit period is one month, the prior specified period may be three months. The prior specified period can also be adjusted according to actual needs, such as half a year or one year. The financial data for the same business source during the previous specified period includes a plurality of financial data associated with the business source during the previous specified period. Taking the business source as a business person three, taking three months as a prior specified period as an example, and taking the current month as 11 months, the acquired data comprise financial data of all businesses accepted by the business person three in 8, 9 and 10 months.
S35, determining the service amount change range of the service source based on the financial data of the service source in the prior appointed period.
After the financial data in the prior specified period of the service source is acquired, the financial data in the prior specified period can be sequenced to find out the highest service amount and the lowest service amount, and then the service amount change range of the service source is determined according to the highest service amount and the lowest service amount. If the highest business amount is 7 ten thousand yuan and the lowest business amount is 3000 yuan, the business amount change range of the business source can be set as [3000,70000].
In practical cases, the service amount change range can also be determined according to the user setting. If the highest business amount is 35000 yuan, the lowest business amount is 3000 yuan, and the highest business amount is lower than the height limit amount, the business amount change range of the business source can be set as [3000,35000]; if the highest business amount is 60000 yuan, the lowest business amount is 3000 yuan, and the highest business amount is higher than the limit height amount, the business amount change range of the business source can be set as [3000,50000]. And so on.
S36, judging whether the business amount in the financial data is in the business amount change range or not.
S37, if the business amount in the financial data is not in the business amount change range, adding a second identification mark for the financial data in the financial account checking table.
In this embodiment, if the business amount in the financial data is not within the business amount variation range, it is indicated that the possibility of errors in the financial data is high, and further auditing by financial staff is required. And if the business amount in the financial data is within the business amount change range, the error probability of the financial data without significance is indicated, and special attention of financial staff is not needed. The second identifying indicia may be bolded, highlighted, change font color, etc. of the financial data content. The second identification mark may be marked in a different manner from the first identification mark or may be the same as the first identification mark.
In steps S33-S37, a business source of the financial data is obtained to determine relevant persons of the financial data. Financial data of the business source during a prior specified period is obtained to obtain historical financial data of the business source. And determining the service amount change range of the service source based on the financial data of the service source in the prior appointed period, and determining the reasonable service amount change range according to the historical financial data of the service source. It is determined whether the business amount in the financial data is within the business amount variation range to check whether the current financial data is abnormal (here, the financial data of which the business amount exceeds the business amount variation range is regarded as abnormal). And if the business amount in the financial data is not in the business amount change range, adding a second identification mark for the financial data in the financial account checking table so as to remind financial staff to perform key verification on abnormal financial data.
Optionally, as shown in fig. 7, after step S37, the method further includes:
s38, receiving the notes information input for the financial data;
s39, sending the remark information to a second designated storage path of the financial system, and storing the remark information in association with the financial data.
In this embodiment, if the financial data is added with the second identification mark, after the financial staff reviews the financial data, the financial staff needs to add corresponding remark information to explain the reason for labeling the financial data. If the financial data needs to be modified, the financial data can be modified in the financial accounting table, and the additional information is added, so that the financial accounting table can synchronously update the financial data in the financial system, and the additional information is stored in a second designated storage path of the financial system and is stored in association with the modified financial data. If the financial data does not need to be modified, only the obtained notes information is stored in a second designated storage path of the financial system.
In steps S38-S39, the notes information entered for the financial data is received to obtain the notes information added by the financial staff, so that the financial data can be checked conveniently during review. And sending the remark information to a second designated storage path of the financial system, and storing the remark information in association with the financial data so as to store the remark information, so that financial staff can inquire the remark information of the financial data.
It should be understood that the sequence number of each step in the foregoing embodiment does not mean that the execution sequence of each process should be determined by the function and the internal logic, and should not limit the implementation process of the embodiment of the present invention.
In one embodiment, a device for checking business data and financial data is provided, where the device for checking business data and financial data corresponds to the method for checking business data and financial data in the above embodiment one by one. As shown in fig. 8, the checking device of business data and financial data includes a reception data module 10, a data conversion module 20, and an import accounting module 30. The functional modules are described in detail as follows:
a receiving data module 10, configured to receive service data sent by a service system, and record a first designated storage path of the service data in the service system;
a data conversion module 20 for converting the business data into financial data by an accounting processing engine and storing the financial data in a second designated storage path of the financial system;
and an import accounting table module 30, configured to import the business data, the first designated storage path, the financial data, and the second designated storage path into a preset business accounting table according to a designated relative position, where the designated relative position includes a first designated table cell area in the business accounting table stored in association with the first designated storage path, and a second designated table cell area in the business accounting table stored in association with the second designated storage path, and a positional relationship between the first designated table cell area and the second designated table cell area includes adjacent or similar.
Optionally, as shown in fig. 9, the checking device of the business data and the financial data further includes:
a verification module 40, configured to determine whether an individual financial amount converted from an individual service amount related to the service data is equal to an actual account amount recorded in the financial system, where the financial data includes the actual account amount;
and the first identification module 50 is configured to add a first identification mark to the business data and the financial data in the business accounting table if the single financial amount converted from the single business amount related to the business data is not equal to the actual account entry amount recorded in the financial system.
Optionally, the data conversion module 20 includes:
the analyzing unit is used for analyzing the business vocabulary in the business data;
the conversion unit is used for converting the business vocabulary into financial vocabulary according to a preset conversion rule;
a generation unit configured to generate the financial data based on the financial vocabulary and the business data;
and the sending data unit is used for sending the financial data to the financial system, acquiring the storage path of the financial data in the financial system, and marking the storage path of the financial data in the financial system as the second designated storage path.
Optionally, the device for checking the business data and the financial data further comprises:
the service source acquisition module is used for acquiring the service source of the financial data;
the historical financial data acquisition module is used for acquiring financial data of the service source in a prior specified period;
a determining range module for determining a range of change in the business amount for the business source based on financial data of the business source in a prior specified period;
the judging module is used for judging whether the business amount in the financial data is in the business amount change range or not;
and adding a second identification module, which is used for adding a second identification mark for the financial data in the financial accounting table if the business amount in the financial data is not in the business amount change range.
Optionally, the device for checking the business data and the financial data further comprises:
the notes receiving information module is used for receiving notes information recorded for the financial data;
and the notes information storage module is used for sending the notes information to a second designated storage path of the financial system and storing the notes information in association with the financial data.
Optionally, the device for checking the business data and the financial data further comprises:
the accounting document receiving module is used for receiving accounting documents associated with the financial data after the business data and the financial data are checked;
and the derived accounting report module is used for receiving report deriving instructions after determining that all accounting vouchers associated with the financial data are received, deriving accounting reports in a specified period according to the report deriving instructions, and generating the accounting reports based on the financial data.
For specific limitations on the means for reconciling business data with financial data, reference may be made to the above limitations on the method for reconciling business data with financial data, and no further description is given here. The respective modules in the above-described collation apparatus of business data and financial data may be realized in whole or in part by software, hardware, and combinations thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a server, and the internal structure of which may be as shown in fig. 10. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer device is used for storing data related to a checking method of business data and financial data. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by the processor to implement a method of reconciling business data with financial data.
In one embodiment, a computer device is provided comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the steps of when executing the computer program:
receiving service data sent by a service system, and recording a first appointed storage path of the service data in the service system;
converting, by an accounting processing engine, the business data into financial data and storing the financial data in a second designated storage path of the financial system;
and importing the business data, the first appointed storage path, the financial data and the second appointed storage path into a preset business account checking table according to an appointed relative position, wherein the appointed relative position comprises a first appointed table cell area in the business account checking table stored in an associated mode of the business data and the first appointed storage path, and a second appointed table cell area in the business account checking table stored in an associated mode of the financial data and the second appointed storage path, and the position relation between the first appointed table cell area and the second appointed table cell area comprises adjacent or similar.
In one embodiment, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, performs the steps of:
receiving service data sent by a service system, and recording a first appointed storage path of the service data in the service system;
converting, by an accounting processing engine, the business data into financial data and storing the financial data in a second designated storage path of the financial system;
and importing the business data, the first appointed storage path, the financial data and the second appointed storage path into a preset business account checking table according to an appointed relative position, wherein the appointed relative position comprises a first appointed table cell area in the business account checking table stored in an associated mode of the business data and the first appointed storage path, and a second appointed table cell area in the business account checking table stored in an associated mode of the financial data and the second appointed storage path, and the position relation between the first appointed table cell area and the second appointed table cell area comprises adjacent or similar.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in embodiments provided herein may include non-volatile and/or volatile memory. The nonvolatile memory can include Read Only Memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), memory bus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-described division of the functional units and modules is illustrated, and in practical application, the above-described functional distribution may be performed by different functional units and modules according to needs, i.e. the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-described functions.
The above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention, and are intended to be included in the scope of the present invention.