Accounting electronic certificate processing method based on cloud database

Abstract

The invention relates to the technical field of accounting data processing, and discloses an accounting electronic certificate processing method based on a cloud database, and the method comprises the steps: carrying out the integrity analysis, error analysis and format analysis of a target certificate, judging whether the data of the electronic certificate is accurate and meets the requirements or not, and when the data of the electronic certificate is incomplete, carrying out the processing of the electronic certificate. According to the accounting electronic certificate processing method based on the cloud database, whether the data of the electronic certificate is accurate and meets requirements is automatically judged, whether the data of the electronic certificate is complete is automatically judged, whether the data of the electronic certificate is tampered is automatically judged, and when the data of the electronic certificate is incomplete or tampered, the data of the electronic certificate is recovered. According to the method, the data are automatically restored to correct and complete data or the voucher is marked in time, and related personnel are reminded to recheck, so that serious errors and loss are avoided, the accuracy of data transmission is improved, the number of manual processing times is reduced, and the working efficiency is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of accounting data processing, and in particular to a method for processing accounting electronic vouchers based on a cloud database. Background Art

[0002] The cloud database-based accounting electronic voucher processing method aims to utilize cloud computing technology to improve the processing efficiency and security of accounting vouchers. By using cloud computing technology, efficient processing and management of accounting vouchers can be achieved, which not only improves the efficiency and accuracy of accounting processing, but also enhances the security and traceability of data, providing strong support for the financial management of enterprises.

[0003] Accounting electronic voucher processing method based on cloud database: Select a suitable cloud database solution to ensure the reliability and scalability of the database, and take measures such as data encryption and access control to protect data security. Use the financial management system to automatically generate electronic vouchers and extract key data. Integrate the accounting system with other related systems through APIs to automatically synchronize financial data. Store electronic voucher data in the cloud database and organize it using appropriate data models. Perform version control on changes to each voucher to ensure the traceability of historical versions. Develop automatic audit and inspection rules to ensure the integrity and accuracy of the vouchers. Identify potential abnormal transactions and fraudulent behavior through machine learning algorithms. Design electronic processes to implement online review and approval of electronic vouchers. Utilize the powerful computing power of the cloud database to perform real-time analysis of accounting voucher data. Set up a regular automatic backup mechanism to back up data to secure cloud storage to prevent data loss. Implement strict access control policies to ensure that only authorized personnel can access or operate accounting voucher data. Regularly evaluate the system's performance and user feedback, and perform system optimization and function upgrades as needed.

[0004] The existing accounting electronic voucher processing method based on cloud database cannot automatically determine whether the data of the electronic voucher is accurate and meets the requirements, cannot automatically determine whether the data of the electronic voucher is complete, and cannot automatically determine whether the data of the electronic voucher has been tampered with. When the data of the electronic voucher is incomplete or tampered with, it cannot be automatically restored to the correct and complete data. Its practicality has certain limitations. Summary of the Invention

[0005] The present invention provides an accounting electronic voucher processing method based on a cloud database, which has the functions of automatically judging whether the data of the electronic voucher is accurate and meets the requirements, automatically judging whether the data of the electronic voucher is complete, and automatically judging whether the data of the electronic voucher has been tampered with. When the data of the electronic voucher is incomplete or tampered with, when the data cannot be restored, the voucher is marked in time to remind relevant personnel to review, so as to avoid serious mistakes and losses, and automatically restore to correct and complete data, improve the accuracy of data transmission, reduce the number of manual processing times, and improve work efficiency. It solves the problem mentioned in the above background technology that in the process of electronic voucher processing, it is impossible to automatically judge whether the data of the electronic voucher is accurate and meets the requirements, it is impossible to automatically judge whether the data of the electronic voucher is complete, it is impossible to automatically judge whether the data of the electronic voucher has been tampered with, and when the data of the electronic voucher is incomplete or tampered with, it is impossible to automatically restore to correct and complete data.

[0006] The present invention provides the following technical solution: a method for processing accounting electronic vouchers based on a cloud database, comprising:

[0007] S1. Obtain target credentials;

[0008] S2. Perform integrity analysis on the target credentials:

[0009] S21, obtain the judgment parameter verify_sou;

[0010] S22. If verify_sou = R1, then record verify_I = WR1;

[0011] If verify_sou=R2, then perform data recovery on the target certificate;

[0012] S23, obtaining the determination parameter verify_Re;

[0013] S24. If verify_Re=R1, then record verify_I=WR1;

[0014] If verify_Re=R2, then record verify_I=WR2;

[0015] S3. Analyze the target voucher for errors;

[0016] S4. Analyze the format of the target voucher;

[0017] S5. Conduct rationality analysis on the target voucher:

[0018] S51. Obtain verify_I, verify_E, and verify_D;

[0019] S52. Calculate the sum of the parameters based on the summation formula:

[0020] sum_of_parameter=(verify_I+verify_E+verify_D);

[0021] S53. If sum_of_parameter=3, it is determined that the target voucher data has high accuracy;

[0022] If sum_of_parameter≠3, the target voucher data is judged to be of low accuracy, the voucher is marked, and relevant personnel are reminded to review it.

[0023] As an optional solution to the cloud database-based accounting electronic voucher processing method of the present invention, the integrity analysis of the target voucher is specifically as follows:

[0024] Get the original data of the target credential, recorded as data_source;

[0025] Generate the original hash value of the original data, recorded as stored_hash:

[0026] stored_hash=SHA-256(data_source);

[0027] The original hash value stored_hash is stored and locked;

[0028] Get the received data of the target credential, recorded as data_received;

[0029] Generate the received hash value of the received data, recorded as current_hash:

[0030] current_hash=SHA-256(data_received);

[0031] Based on the data comparison function, calculate the comparison results:

[0032]

[0033] Among them, SHA-256(·) is a one-way cryptographic hash algorithm that converts input data into a 256-bit digital value;

[0034] Set the judgment parameter verify_sou;

[0035] If VerifyDataIntegrity(data_source,data_received)=R1, then verify_sou=R1;

[0036] If VerifyDataIntegrity(data_source, data_received)=R2, then verify_sou=R2.

[0037] As an optional solution to the cloud database-based accounting electronic voucher processing method of the present invention, wherein: the data recovery of the target voucher is specifically:

[0038] Get all historical data records to form a historical data record set, recorded as HistoryData;

[0039] Get the original data of the target credential, recorded as data_source;

[0040] Get the received data of the target credential, recorded as data_received;

[0041] Get the comparison result of the data comparison function;

[0042] Generate recovery data based on the data recovery function:

[0043]

[0044] Among them, RecoverData(TamperNodes, BackupStorage) is the backup recovery function, TamperNodes is a set of tamper-prone nodes, and BackupStorage is a database table that stores all backed-up data.

[0045] As an optional solution to the cloud database-based accounting electronic voucher processing method of the present invention, wherein: obtaining TamperNodes in the data recovery function is specifically:

[0046] Get all historical data records to form a historical data record set, recorded as HistoryData;

[0047] Get the node information of each record in the historical data record set, recorded as record[node];

[0048] Get the tampering flag of each record in the historical data record set, recorded as record[tampered];

[0049] Set up a tamper analysis function to calculate the set of nodes that are easily tampered, denoted as TamperNodes:

[0050]

[0051] Among them, node refers to the intermediate nodes, storage nodes and other key points that data passes through during the transmission process.

[0052] As an optional solution of the cloud database-based accounting electronic voucher processing method of the present invention, wherein: obtaining BackupStorage in the data recovery function is specifically:

[0053] Get the original data of the target credential, recorded as data_source;

[0054] Get the tamperable node set TamperNodes;

[0055] At each node in the tamperable node set TamperNodes, the original data is encrypted based on the encryption function:

[0056] Encrypt(data_source)=Base64Encode(data_source);

[0057] Among them, Base64Encode(·) is a function that encodes data into Base64;

[0058] Set up a backup function, using node as the key, and store the encrypted data in BackupStorage_node:

[0059]

[0060] Among them, BackupStorage_node is the database table that stores the backup data, and node is the identifier of the backup node;

[0061] Based on the integrated backup function, all backup nodes and encrypted backup data are integrated to form a database table BackupStorage that stores all backup data:

[0062] BackupStorage={node:Encrypt(data_source)|node∈TamperNodes}.

[0063] As an optional solution to the cloud database-based accounting electronic voucher processing method of the present invention, wherein: obtaining the backup recovery function in the data recovery function is specifically:

[0064] Get the tamperable node set TamperNodes;

[0065] Get the database table BackupStorage;

[0066] Based on the backup and recovery function, determine whether the target certificate has backup data:

[0067]

[0068] Set the judgment parameter verify_Re;

[0069] If RecoverData(TamperNodes,BackupStorage)=Restore, then verify_Re=R1;

[0070] Through the decryption function, the data of each node in the database table is decrypted separately to generate decrypted data:

[0071] data_decrypt=Decrypt(BackupStorage[node]);

[0072] Where Decrypt(·) is a decryption function that decrypts encrypted data using Base64, and node is the identifier of the backup node;

[0073] Generate the decrypted hash value of each decrypted data, recorded as decrypt_hash:

[0074] decrypt_hash=SHA-256(data_decrypt);

[0075] Get the original data of the target credential, recorded as data_source;

[0076] Based on the data comparison function, calculate the comparison results:

[0077]

[0078] Among them, stored_hash is the original hash value of the original data;

[0079] If VerifyDataIntegrity(data_source, data_decrypt) = R1, extract the decrypted data data_decrypt, identify it as restored data, record it as data_restore, and update the restored data to the received data of the target certificate;

[0080] If VerifyDataIntegrity(data_source, data_decrypt) = R2, extract the node corresponding to the decrypted data, identify it as a tampered node, record it as node_Tamper, generate a tamper flag for the tampered node, and update the historical data record;

[0081] If RecoverData(TamperNodes, BackupStorage)=None, then verify_Re=R2.

[0082] As an optional solution to the cloud database-based accounting electronic voucher processing method of the present invention, the target voucher is subjected to error analysis, specifically:

[0083] Get the original data of the target credential, recorded as data_source;

[0084] Generate the checksum parameters of the original data, recorded as checksum_source:

[0085] checksum_source=CRC32(data_source);

[0086] Among them, is a function that performs CRC32 check on the input data, which converts the input data into a 32-bit integer;

[0087] The checksum_source parameter of the original data is stored and locked;

[0088] Get the received data of the target credential, recorded as data_received;

[0089] Generate the checksum parameter for the received data, recorded as checksum_received:

[0090] checksum_received=CRC32(data_received);

[0091] Based on the data comparison function, calculate the comparison results:

[0092]

[0093] If VerifyDataInaccuracy(data_source, data_received)=E1, then record verify_E=WR1;

[0094] If VerifyDataInaccuracy(data_source, data_received)=E2, then record verify_E=WR2.

[0095] As an optional solution of the cloud database-based accounting electronic voucher processing method of the present invention, the format of the target voucher is analyzed, specifically:

[0096] Get the keyword dataset of the target credential, denoted as data;

[0097] The keyword data set includes the amount field of the target voucher, payer information, and payee information;

[0098] Set a format validation function to determine whether the target credential meets the logic and format requirements:

[0099]

[0100] Among them, amount_valid is the amount verification function, payer_valid is the payer verification function, and payee_valid is the payee verification function;

[0101] If validate_fields(data)=D1, then record verify_D=WR1;

[0102] If validate_fields(data)=D2, then record verify_D=WR2.

[0103] As an optional solution to the cloud database-based accounting electronic voucher processing method of the present invention, the amount verification function, the payer verification function, and the payee verification function are specifically:

[0104] The amount verification function is specifically:

[0105]

[0106] The payer verification function is specifically:

[0107]

[0108] in, Represents an empty string;

[0109] The payee verification function is specifically:

[0110]

[0111] in, Represents an empty string.

[0112] The present invention has the following beneficial effects:

[0113] 1. The accounting electronic voucher processing method based on cloud database obtains the original data and received data of the electronic voucher, generates hash values ​​for the original data and received data, compares them, and determines whether they are consistent, thereby determining whether the data of the electronic voucher has been tampered with. By obtaining backup data, the tampered received data is restored to the correct original data of the backup, thereby improving the accuracy of data transmission, reducing the number of manual processing times, and improving work efficiency.

[0114] 2. The accounting electronic voucher processing method based on cloud database obtains historical data records, obtains data transmission nodes for each historical data record, and obtains whether there is a tampering mark under each data transmission node for each historical data record to form a tamper-prone node set. Each node in the tamper-prone node set backs up the electronic voucher, so that when the data of the electronic voucher is incomplete or tampered with, it is automatically restored to the correct and complete data. If the node of the electronic voucher that is tampered with this time is not in the tamper-prone node set, the electronic voucher has no backup data and needs to be re-transmitted. At the same time, the node is marked and the tamper-prone node set is updated to make the data more complete, prevent other data from being tampered with at the same node during the transmission process, improve the accuracy of data transmission, reduce the number of manual processing times, and improve work efficiency.

[0115] 3. The accounting electronic voucher processing method based on cloud database obtains the original data and received data of the electronic voucher, generates CRC32 check parameters for the original data and the received data, compares them, and determines whether they are consistent, thereby determining whether errors occur in the transmission and storage process of the electronic voucher, and generates a keyword data set for the electronic voucher, verifies each keyword in the keyword data set separately, thereby determining whether each keyword meets the logic and format requirements, and then determines whether the electronic voucher is omitted or missing during the filling, transmission or storage process, integrates the judgment results of integrity analysis, error analysis and format analysis, and determines whether the data of the electronic voucher is reasonable and accurate, so as to perform subsequent operations. When the data of the electronic voucher is unreasonable or inaccurate, the voucher is marked in time to remind relevant personnel to review, so as to avoid serious mistakes and losses, improve the accuracy of data transmission, reduce the number of manual processing times, and improve work efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0116] Figure 1 This is a flow chart of the accounting electronic voucher processing method based on cloud database of the present invention. DETAILED DESCRIPTION

[0117] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of the present invention.

[0118] Example 1: A method for processing accounting electronic vouchers based on a cloud database, see Figure 1 ,include:

[0119] S1. Obtain target credentials;

[0120] S2. Perform integrity analysis on the target credential to verify whether the electronic credential has been tampered with during transmission and storage:

[0121] S21, obtain the judgment parameter verify_sou;

[0122] S22. If verify_sou = R1, then record verify_I = WR1, where verify_sou is the conclusion of whether the target credential has been tampered with. If verify_sou = R1, it means that the data is intact and has not been tampered with. Verify_I is the conclusion of the integrity of the target credential. If WR1 is 1, that is, the target credential data is intact, then the conclusion is recorded as 1.

[0123] If verify_sou=R2, data recovery is performed on the target certificate, where verify_sou is the conclusion of whether the target certificate has been tampered with. If verify_sou=R2, it means that the data has been tampered with.

[0124] S23, obtaining the determination parameter verify_Re;

[0125] S24. If verify_Re = R1, then record verify_I = WR1, where verify_Re is the conclusion on whether the target credential can be restored. If verify_Re = R1, it means the data can be restored. Verify_I is the conclusion on the integrity of the target credential. If WR1 is 1, it means the target credential data is intact, and the conclusion is recorded as 1.

[0126] If verify_Re=R2, then record verify_I=WR2, where verify_Re is the conclusion on whether the target credential can be restored. If verify_Re=R2, it means the data cannot be restored. Verify_I is the conclusion on the integrity of the target credential. If WR2 is 0, it means the target credential data is incomplete, and its conclusion is recorded as 0.

[0127] S3. Perform error analysis on the target voucher to verify whether any data errors occur during the transmission and storage of the electronic voucher;

[0128] S4. Analyze the format of the target voucher to verify whether any omissions or missing items are present during the filling, transmission, or storage process of the electronic voucher;

[0129] S5. Conduct rationality analysis on the target voucher:

[0130] S51. Obtain verify_I, verify_E, and verify_D;

[0131] S52. Calculate the sum of the parameters based on the summation formula:

[0132] sum_of_parameter=(verify_I+verify_E+verify_D);

[0133] S53. If sum_of_parameter = 3, the target voucher data is determined to be highly accurate, i.e., the target voucher has passed the integrity analysis, error analysis, and format analysis verifications, indicating that the data is essentially error-free and subsequent operations can be performed.

[0134] If sum_of_parameter≠3, the target voucher data is judged to have low accuracy, and the voucher is marked to remind relevant personnel to review it. That is, the target voucher has at least one factor that failed the verification in the integrity analysis, error analysis, and format analysis, indicating that its data is incorrect and subsequent operations cannot be performed.

[0135] Through the above method, it is possible to automatically determine whether the data of the electronic certificate is accurate and meets the requirements, automatically determine whether the data of the electronic certificate is complete, and automatically determine whether the data of the electronic certificate has been tampered with. When the data of the electronic certificate is incomplete or has been tampered with, it is automatically restored to the correct and complete data. When the data cannot be restored, the certificate is marked in time to remind relevant personnel to review it, so as to avoid serious mistakes and losses, improve the accuracy of data transmission, reduce the number of manual processing times, and improve work efficiency.

[0136] Example 2: This example is an improvement made on the basis of Example 1. In the method for processing accounting electronic vouchers based on a cloud database, the integrity analysis of the target voucher is specifically as follows:

[0137] Get the original data of the target credential, recorded as data_source;

[0138] Generate the original hash value of the original data, recorded as stored_hash:

[0139] stored_hash=SHA-256(data_source);

[0140] The original hash value stored_hash is stored and locked for subsequent verification to determine whether the electronic certificate has been tampered with during transmission and storage;

[0141] Get the received data of the target credential, recorded as data_received;

[0142] Generate the received hash value of the received data, recorded as current_hash:

[0143] current_hash=SHA-256(data_received);

[0144] Based on the data comparison function, calculate the comparison results:

[0145]

[0146] Among them, SHA-256(·) is a one-way cryptographic hash algorithm that converts input data into a 256-bit digital value;

[0147] Set the judgment parameter verify_sou to determine the integrity of the target certificate;

[0148] If VerifyDataIntegrity(data_source,data_received)=R1, then verify_sou=R1;

[0149] If VerifyDataIntegrity(data_source, data_received)=R2, then verify_sou=R2.

[0150] This embodiment also provides that the data recovery of the target credential is specifically as follows:

[0151] Get all historical data records to form a historical data record set, recorded as HistoryData;

[0152] Get the original data of the target credential, recorded as data_source;

[0153] Get the received data of the target credential, recorded as data_received;

[0154] Get the comparison result of the data comparison function;

[0155] Generate recovery data based on the data recovery function:

[0156]

[0157] Among them, RecoverData(TamperNodes, BackupStorage) is the backup recovery function, TamperNodes is a set of tamper-prone nodes, and BackupStorage is a database table that stores all backed-up data.

[0158] This embodiment also provides a method for obtaining TamperNodes in a data recovery function, specifically:

[0159] Get all historical data records to form a historical data record set, recorded as HistoryData;

[0160] Get the node information of each record in the historical data record set, recorded as record[node];

[0161] Get the tampering flag of each record in the historical data record set, recorded as record[tampered];

[0162] Set up a tamper analysis function to calculate the set of nodes that are easily tampered with, denoted as TamperNodes, to identify nodes that are easily tampered with during data transmission:

[0163]

[0164] Among them, node refers to the intermediate nodes, storage nodes and other key points that data passes through during the transmission process.

[0165] This embodiment also provides a method for obtaining BackupStorage in a data recovery function, specifically:

[0166] Get the original data of the target credential, recorded as data_source;

[0167] Get the tamperable node set TamperNodes;

[0168] At each node in the tamperable node set TamperNodes, the original data is encrypted based on the encryption function:

[0169] Encrypt(data_source)=Base64Encode(data_source);

[0170] Among them, Base64Encode(·) is a function that encodes data into Base64;

[0171] Set up a backup function that uses node node as the key and stores the encrypted data in BackupStorage_node. If node already exists in BackupStorage_node, update the backup data of the node; otherwise, return None, which means that the backup data will not be updated:

[0172]

[0173] Among them, BackupStorage_node is the database table that stores the backup data, and node is the identifier of the backup node;

[0174] Based on the integrated backup function, all backup nodes and encrypted backup data are integrated to form a database table BackupStorage that stores all backup data:

[0175] BackupStorage={node:Encrypt(data_source)|node∈TamperNodes}.

[0176] This embodiment also provides a method for obtaining a backup recovery function in a data recovery function, specifically:

[0177] Get the tamperable node set TamperNodes;

[0178] Get the database table BackupStorage;

[0179] Based on the backup and recovery function, determine whether the target certificate has backup data:

[0180]

[0181] Set the judgment parameter verify_Re;

[0182] If RecoverData(TamperNodes,BackupStorage)=Restore, then verify_Re=R1;

[0183] Through the decryption function, the data of each node in the database table is decrypted separately to generate decrypted data:

[0184] data_decrypt=Decrypt(BackupStorage[node]);

[0185] Where Decrypt(·) is a decryption function that decrypts encrypted data using Base64, and node is the identifier of the backup node;

[0186] Generate the decrypted hash value of each decrypted data, recorded as decrypt_hash:

[0187] decrypt_hash=SHA-256(data_decrypt);

[0188] Get the original data of the target credential, recorded as data_source;

[0189] Based on the data comparison function, calculate the comparison results:

[0190]

[0191] Among them, stored_hash is the original hash value of the original data;

[0192] If VerifyDataIntegrity(data_source, data_decrypt) = R1, extract the decrypted data data_decrypt, identify it as restored data, record it as data_restore, and update the restored data to the received data of the target certificate;

[0193] If VerifyDataIntegrity(data_source, data_decrypt) = R2, extract the node corresponding to the decrypted data, identify it as a tampered node, record it as node_Tamper, generate a tamper flag for the tampered node, and update the historical data record;

[0194] If RecoverData(TamperNodes, BackupStorage)=None, then verify_Re=R2.

[0195] Example 3: This example is an improvement made on the basis of Example 2. In this example, the target voucher is analyzed for errors, specifically:

[0196] Get the original data of the target credential, recorded as data_source;

[0197] Generate the checksum parameters of the original data, recorded as checksum_source:

[0198] checksum_source=CRC32(data_source);

[0199] Among them, is a function that performs CRC32 check on the input data, which converts the input data into a 32-bit integer;

[0200] The checksum_source parameter of the original data is stored and locked for subsequent verification to determine whether errors occurred during the transmission and storage of the electronic certificate;

[0201] Get the received data of the target credential, recorded as data_received;

[0202] Generate the checksum parameter for the received data, recorded as checksum_received:

[0203] checksum_received=CRC32(data_received);

[0204] Based on the data comparison function, calculate the comparison results:

[0205]

[0206] If VerifyDataInaccuracy(data_source, data_received) = E1, then record verify_E = WR1, where verify_E is the error determination conclusion of the target voucher, that is, the determination conclusion of whether an error occurred during the transmission of the target voucher. If WR1 is 1, that is, there is no error in the target voucher data, then its conclusion is recorded as 1;

[0207] If VerifyDataInaccuracy(data_source,data_received)=E2, then record verify_E=WR2, where verify_E is the error judgment conclusion of the target certificate, that is, the judgment conclusion of whether an error occurred in the target certificate during the transmission process. WR2 is 0, that is, if an error occurs in the target certificate data, its conclusion is recorded as the value 0.

[0208] Example 4: This example is an improvement made on the basis of Example 3. In this example, the format of the target voucher is analyzed, specifically:

[0209] Get the keyword dataset of the target credential, denoted as data;

[0210] The keyword data set includes the amount field of the target voucher, payer information, and payee information;

[0211] Set a format validation function to determine whether the target credential meets the logic and format requirements:

[0212]

[0213] Among them, amount_valid is the amount verification function, payer_valid is the payer verification function, and payee_valid is the payee verification function;

[0214] If validate_fields(data) = D1, then record verify_D = WR1, where verify_D is the format determination conclusion of the target voucher, that is, the determination conclusion of whether the target voucher has any missing or omitted data during the filling and transmission process. If WR1 is 1, that is, the format of the target voucher is correct, then its conclusion is recorded as a value of 1;

[0215] If validate_fields(data)=D2, then record verify_D=WR2, where verify_D is the format judgment conclusion of the target voucher, that is, the judgment conclusion on whether there are any missing or omissions in the target voucher during the filling and transmission process. If WR2 is 0, that is, the format of the target voucher is incorrect, then its conclusion is recorded as the value 1.

[0216] This embodiment also provides an amount verification function, a payer verification function, and a payee verification function, specifically:

[0217] The amount verification function is specifically:

[0218]

[0219] The payer verification function is specifically:

[0220]

[0221] in, Indicates an empty string. If data[payer] = None, it means that the payer information in the voucher exists, but the format is incorrect. This indicates that the data is omitted during the data generation process or lost during the data transmission process. Therefore, it is necessary to satisfy both data[payer]≠None and Make sure the payer information is correct;

[0222] The payee verification function is specifically:

[0223]

[0224] in, Indicates an empty string. If data[payee]=None, it means that the payee information in the voucher exists, but the format is incorrect. This indicates that the data is omitted during the data generation process or lost during the data transmission process. Therefore, it is necessary to satisfy both data[payee]≠None and Make sure the payee information is correct.

[0225] This embodiment automatically determines whether the data of the electronic certificate is accurate and meets the requirements, automatically determines whether the data of the electronic certificate is complete, and automatically determines whether the data of the electronic certificate has been tampered with. When the data of the electronic certificate is incomplete or tampered with, when the data cannot be restored, the certificate is marked in time to remind relevant personnel to review it to avoid serious mistakes and losses, and automatically restore to correct and complete data, thereby improving the accuracy of data transmission, reducing the number of manual processing times, and improving work efficiency.

[0226] The embodiment of the present disclosure also provides a non-transitory computer-readable storage medium, which stores computer instructions, and the computer instructions are used to enable the computer to execute the cloud database-based accounting electronic voucher processing method in the aforementioned method embodiment.

[0227] It should be noted that more specific examples of computer-readable storage media may include portable computer disks, hard disks, erasable programmable read-only memories (EPROMs or flash memories), optical storage devices, magnetic storage devices, or any suitable combination thereof. In the present disclosure, a computer-readable storage medium may be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. The computer-readable medium may be included in the electronic device described above, or may exist independently without being incorporated into the electronic device.

[0228] The computer-readable medium carries one or more programs. When the one or more programs are executed by the electronic device, the electronic device can implement the solution provided by the above method embodiment.

[0229] Computer program code for performing operations of the present disclosure may be written in one or more programming languages, or a combination thereof, and may be executed entirely on the user's computer, partially on the user's computer, as a stand-alone software package, partially on the user's computer and partially on a remote computer, or entirely on the remote computer or server. Where a remote computer is involved, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., through the Internet using an Internet service provider).

[0230] It should be noted that, in this document, relational terms such as first and second, etc., are used only to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any actual relationship or order between these entities or operations. Moreover, the terms "comprises," "comprising," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that includes a list of elements includes not only those elements but also other elements not explicitly listed, or elements inherent to such process, method, article, or apparatus.

[0231] The above is only a preferred embodiment of the present invention. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the technical principles of the present invention. These improvements and modifications should also be regarded as within the scope of protection of the present invention.

Claims

1. A method for processing accounting electronic vouchers based on a cloud database, characterized by: include: S1. Obtain target credentials; S2. Perform integrity analysis on the target credentials: S21, obtain the judgment parameter verify_sou; S22. If verify_sou = R1, then record verify_I = WR1; If verify_sou=R2, then perform data recovery on the target certificate; S23, obtaining the determination parameter verify_Re; S24. If verify_Re=R1, then record verify_I=WR1; If verify_Re=R2, then record verify_I=WR2; S3. Analyze the target voucher for errors; S4. Analyze the format of the target voucher; S5. Conduct rationality analysis on the target voucher: S51. Obtain verify_I, verify_E, and verify_D; S52. Calculate the sum of the parameters based on the summation formula: sum_of_parameter=(verify_I+verify_E+verify_D); S53. If sum_of_parameter=3, it is determined that the target voucher data has high accuracy; If sum_of_parameter≠3, the target voucher data is judged to be of low accuracy, the voucher is marked, and relevant personnel are reminded to review it.

2. The method for processing accounting electronic vouchers based on a cloud database according to claim 1, characterized in that: The integrity analysis of the target credential is specifically as follows: Get the original data of the target credential, recorded as data_source; Generate the original hash value of the original data, recorded as stored_hash: stored_hash=SHA-256(data_source); The original hash value stored_hash is stored and locked; Get the received data of the target credential, recorded as data_received; Generate the received hash value of the received data, recorded as current_hash: current_hash=SHA-256(data_received); Based on the data comparison function, calculate the comparison results: Among them, SHA-256(·) is a one-way cryptographic hash algorithm that converts input data into a 256-bit digital value; Set the judgment parameter verify_sou; If VerifyDataIntegrity(data_source,data_received)=R1, then verify_sou=R1; If VerifyDataIntegrity(data_source, data_received)=R2, then verify_sou=R2.

3. The method for processing accounting electronic vouchers based on a cloud database according to claim 1, characterized in that: The data recovery of the target credential is specifically as follows: Get all historical data records to form a historical data record set, recorded as HistoryData; Get the original data of the target credential, recorded as data_source; Get the received data of the target credential, recorded as data_received; Get the comparison result of the data comparison function; Generate recovery data based on the data recovery function: Among them, RecoverData(TamperNodes, BackupStorage) is the backup recovery function, TamperNodes is a set of tamper-prone nodes, and BackupStorage is a database table that stores all backed-up data.

4. The method for processing accounting electronic vouchers based on a cloud database according to claim 3, characterized in that: Get the TamperNodes in the data recovery function, specifically: Get all historical data records to form a historical data record set, recorded as HistoryData; Get the node information of each record in the historical data record set, recorded as record[node]; Get the tampering flag of each record in the historical data record set, recorded as record[tampered]; Set up a tamper analysis function to calculate the set of nodes that are easily tampered, denoted as TamperNodes: Among them, node refers to the intermediate nodes, storage nodes and other key points that data passes through during the transmission process.

5. The method for processing accounting electronic vouchers based on a cloud database according to claim 3, characterized in that: Get the BackupStorage in the data recovery function, specifically: Get the original data of the target credential, recorded as data_source; Get the tamperable node set TamperNodes; At each node in the tamperable node set TamperNodes, the original data is encrypted based on the encryption function: Encrypt(data_source)=Base64Encode(data_source); Among them, Base64Encode(·) is a function that encodes data into Base64; Set up a backup function, using node as the key, and store the encrypted data in BackupStorage_node: Among them, BackupStorage_node is the database table that stores the backup data, and node is the identifier of the backup node; Based on the integrated backup function, all backup nodes and encrypted backup data are integrated to form a database table BackupStorage that stores all backup data: BackupStorage={node:Encrypt(data_source)|node∈TamperNodes}.

6. The method for processing accounting electronic vouchers based on a cloud database according to claim 3, characterized in that: Get the backup recovery function in the data recovery function, specifically: Get the tamperable node set TamperNodes; Get the database table BackupStorage; Based on the backup and recovery function, determine whether the target certificate has backup data: Set the judgment parameter verify_Re; If RecoverData(TamperNodes,BackupStorage)=Restore, then verify_Re=R1; Through the decryption function, the data of each node in the database table is decrypted separately to generate decrypted data: data_decrypt=Decrypt(BackupStorage[node]); Where Decrypt(·) is a decryption function that decrypts encrypted data using Base64, and node is the identifier of the backup node; Generate the decrypted hash value of each decrypted data, recorded as decrypt_hash: decrypt_hash=SHA-256(data_decrypt); Get the original data of the target credential, recorded as data_source; Based on the data comparison function, calculate the comparison results: Among them, stored_hash is the original hash value of the original data; If VerifyDataIntegrity(data_source, data_decrypt) = R1, extract the decrypted data data_decrypt, identify it as restored data, record it as data_restore, and update the restored data to the received data of the target certificate; If VerifyDataIntegrity(data_source, data_decrypt) = R2, extract the node corresponding to the decrypted data, identify it as a tampered node, record it as node_Tamper, generate a tamper flag for the tampered node, and update the historical data record; If RecoverData(TamperNodes, BackupStorage)=None, then verify_Re=R2.

7. The method for processing accounting electronic vouchers based on a cloud database according to claim 1, characterized in that: Perform error analysis on the target credentials, specifically: Get the original data of the target credential, recorded as data_source; Generate the checksum parameters of the original data, recorded as checksum_source: checksum_source=CRC32(data_source); Among them, is a function that performs CRC32 check on the input data, which converts the input data into a 32-bit integer; The checksum_source parameter of the original data is stored and locked; Get the received data of the target credential, recorded as data_received; Generate the checksum parameter for the received data, recorded as checksum_received: checksum_received=CRC32(data_received); Based on the data comparison function, calculate the comparison results: If VerifyDataInaccuracy(data_source, data_received)=E1, then record verify_E=WR1; If VerifyDataInaccuracy(data_source, data_received)=E2, then record verify_E=WR2.

8. The method for processing accounting electronic vouchers based on a cloud database according to claim 7, characterized in that: Perform format analysis on the target voucher, specifically: Get the keyword dataset of the target credential, denoted as data; The keyword data set includes the amount field of the target voucher, payer information, and payee information; Set a format validation function to determine whether the target credential meets the logic and format requirements: Among them, amount_valid is the amount verification function, payer_valid is the payer verification function, and payee_valid is the payee verification function; If validate_fields(data)=D1, then record verify_D=WR1; If validate_fields(data)=D2, then record verify_D=WR2.

9. The method for processing accounting electronic vouchers based on a cloud database according to claim 8, characterized in that: The amount verification function, payer verification function, and payee verification function are as follows: The amount verification function is specifically: The payer verification function is specifically: in, Represents an empty string; The payee verification function is specifically: in, Represents an empty string.

Images