Electronic voucher-based financial data merging offset processing method, device and equipment

Abstract

The application discloses a financial data merging offset processing method, device and equipment based on electronic vouchers, comprising: assigning a globally unique ID to the electronic vouchers after compliance verification; determining the business mode corresponding to each electronic voucher, performing business matching on the electronic vouchers to obtain multiple collaborative tasks, initiating online confirmation to the corresponding transaction parties, and establishing an association index of the globally unique ID and the collaborative number after confirmation; determining the transaction type identifier and the transaction unit level identifier corresponding to each electronic voucher, and calculating the corresponding derivative financial indicators; obtaining multiple target electronic vouchers corresponding to the same collaborative task according to the association index, generating a multi-level offset journal according to the transaction type identifier, the transaction unit level identifier and the derivative financial indicators; and binding the multi-level offset journal with the globally unique ID to obtain traceable financial offset data. The application improves the efficiency, accuracy and reliability of financial data merging offset, and can be applied to the technical field of data processing.

Description

Technical Field

[0001] This invention relates to the field of data processing technology, and in particular to a method, apparatus and equipment for consolidating and offsetting financial data based on electronic vouchers. Background Technology

[0002] Currently, most large energy groups in China have established independent accounting archive systems and financial accounting consolidation and elimination systems. These two systems are deployed independently and their databases are isolated. This model is a common and similar existing solution in the industry, and the specific situation is as follows: 1) Current general solutions for electronic voucher processing: Currently, enterprise electronic archive systems only implement basic functions such as document uploading and image storage. Based on traditional industry standards for electronic archives and patented solutions for general financial systems, they only complete the archiving of PDF and paper scans. For OFD-format electronic invoices, bank receipts, and internal settlement statements in accordance with the Ministry of Finance's document Caihui

[2022] No. 6, conventional systems on the market only support fragmented parsing of single-type documents, lacking a unified integrated process for multi-source data collection, automatic signature verification, four-dimensional verification, and automatic metadata extraction. Electronic vouchers are only used as image files for post-event review and are not linked to accounting data.

[0003] 2) Existing Common Solutions for Consolidation and Offsetting of Group Transactions: Domestic central state-owned enterprises generally adopt the "first record, then offline offsetting at the end of the month" model for consolidation and offsetting of group transactions. This corresponds to the existing technology of traditional group financial accounting: both parties independently enter vouchers for accounting, and at the end of the month, the financial personnel export the accounting data of both parties to an Excel spreadsheet, manually verify internal transactions, and manually prepare offsetting entries. The mainstream accounting system only relies on the general ledger amount to carry out offsetting calculations and cannot link or retrieve the original electronic business documents. For the 71 types of complex internal transactions of the power grid at the provincial, municipal, and county levels, only simple one-to-one transactions are supported for manual matching, and there is no automatic matching mechanism for one-to-many and many-to-many internal transactions.

[0004] 3) The system architecture adopts a modular architecture. The electronic accounting archive module and the accounting offset module belong to two independent microservices, and the data is not interconnected. Electronic vouchers are only archived and do not synchronize structured transaction information to the accounting layer. The offset calculation only reads the account balance and journal entry. There is no three-layer data binding logic of electronic voucher-journal voucher-offset entry. During audit and regulatory verification, it is necessary to manually search and match the original business documents across systems.

[0005] As can be seen from the above, the existing technology has the following defects: the two existing systems are physically isolated, lack unified data association indexing technology, and the audit evidence chain is incomplete; multi-source and multi-format electronic vouchers lack integrated automated processing technology, resulting in a large amount of manual operation and non-compliant archiving; internal transactions adopt a post-offline offsetting scheme, lacking pre-collaboration and intelligent matching algorithms, leading to frequent data discrepancies; there are data silos between archives and accounting, and voucher data cannot be automatically transferred to the offsetting calculation stage.

[0006] In summary, existing financial data consolidation and offsetting schemes suffer from inefficiency, inaccuracy, and unreliability. Summary of the Invention

[0007] The purpose of this invention is to at least partially solve one of the technical problems existing in the prior art.

[0008] Therefore, one objective of this invention is to provide a method for consolidating and offsetting financial data based on electronic vouchers. This method performs business matching on electronic vouchers to obtain multiple collaborative tasks, generates multi-level offsetting entries for multiple target electronic vouchers corresponding to the same collaborative task based on transaction type identifier, transaction unit level identifier, and derived financial indicators, and binds them with the globally unique ID of the target electronic vouchers to obtain traceable financial offsetting data, thereby improving the efficiency, accuracy, and reliability of consolidating and offsetting financial data.

[0009] Another objective of this invention is to provide a financial data consolidation and offsetting processing device based on electronic vouchers.

[0010] To achieve the above-mentioned technical objectives, the technical solutions adopted in the embodiments of the present invention include: On one hand, embodiments of the present invention provide a method for consolidating and offsetting financial data based on electronic vouchers, comprising the following steps: Obtain multiple electronic vouchers generated from purchasing and sales transactions, and assign globally unique IDs to the electronic vouchers after compliance verification; The business model corresponding to each electronic voucher is determined, the electronic voucher is matched with the business to obtain multiple collaborative tasks, and then online confirmation is initiated to the transaction party corresponding to each collaborative task. After the transaction party confirms, an association index between the globally unique ID and the collaborative number is established. Determine the transaction type identifier and transaction unit level identifier corresponding to each of the aforementioned electronic vouchers, and calculate the derivative financial indicators corresponding to each of the aforementioned electronic vouchers; Multiple target electronic vouchers corresponding to the same collaborative task are obtained according to the association index, and multi-level offset entries corresponding to the target electronic vouchers are generated according to the transaction type identifier, the transaction unit level identifier and the derived financial indicators. By binding the multi-level offsetting entries with the globally unique ID corresponding to the target electronic voucher, traceable financial offsetting data is obtained.

[0011] Furthermore, in one embodiment of the present invention, the step of assigning a globally unique ID after performing compliance verification on the electronic certificate specifically includes: Extract the structured metadata corresponding to the electronic voucher. The structured metadata includes the transaction entity, collaboration number, amount of receipt and payment, and the corresponding billing period. The electronic certificate is verified for integrity based on the structured metadata, for usability based on the data format, for security based on the electronic signature, and for readability based on the rendering result. When the integrity verification, availability verification, security verification, and readability verification are all successful, the compliance verification is determined to be passed, and the electronic certificate is bound to the corresponding globally unique ID and stored in the electronic archive.

[0012] Furthermore, in one embodiment of the present invention, the step of determining the business mode corresponding to each of the electronic vouchers and performing business matching on the electronic vouchers to obtain multiple collaborative tasks specifically includes: The electronic vouchers are classified according to the preset collaborative business template to obtain the corresponding business model. The business model is one of bilateral collaboration, unilateral offsetting, and tripartite collaboration. Multiple candidate electronic vouchers corresponding to the same collaborative task are filtered according to the collaborative number, and the candidate electronic vouchers are matched according to the transaction subject and the amount of income and expenditure to determine multiple collaborative electronic vouchers belonging to the same collaborative task. Then, the multiple collaborative electronic vouchers corresponding to the same collaborative task are pushed to the collaborative task pool.

[0013] Furthermore, in one embodiment of the present invention, the step of initiating online confirmation to the transaction parties corresponding to each of the collaborative tasks, and establishing an association index between the globally unique ID and the collaborative number after the transaction parties confirm, specifically includes: The collaborative electronic vouchers for each collaborative task are pushed to several corresponding trading parties, so that the trading parties can verify the collaborative electronic vouchers and return confirmation information after verification. The collaboration number of the collaborative task is bound to the globally unique ID of the corresponding collaborative electronic voucher, and a corresponding accounting number is assigned to obtain the association index.

[0014] Furthermore, in one embodiment of the present invention, the transaction type identifier is one of receivables, payables, and cash flows; the transaction unit level identifier is determined according to the organizational structure level to which the transaction party corresponding to the electronic voucher belongs; and the derived financial indicators include at least one of internal unrealized profits and intercompany differences.

[0015] Furthermore, in one embodiment of the present invention, the step of obtaining multiple target electronic vouchers corresponding to the same collaborative task according to the association index, and generating multi-level offsetting entries corresponding to the target electronic vouchers according to the transaction type identifier, the transaction unit level identifier, and the derived financial indicators, specifically includes: Based on the associated index, obtain multiple target globally unique IDs corresponding to the same collaborative task, and based on the target globally unique IDs, obtain the corresponding target electronic vouchers from the electronic archive. Obtain the corresponding consolidation and offsetting strategy based on the transaction type identifier of the target electronic voucher; Based on the transaction unit level identifier of the target electronic voucher, the derivative financial indicators are calculated layer by layer according to the consolidation and offset strategy in ascending order of level to obtain the corresponding offset entry data for each level. The multi-level offsetting entries corresponding to the target electronic voucher are generated based on the offsetting entry data.

[0016] Furthermore, in one embodiment of the present invention, the financial data consolidation and offsetting processing method further includes the following steps: In response to a traceability request for the traceable financial offset data, a number of target electronic vouchers are obtained by querying based on the corresponding number of globally unique IDs, and the target electronic vouchers are displayed. or, In response to a business query request for the target electronic voucher, the corresponding traceable financial offset data is obtained by querying based on the corresponding globally unique ID, and the traceable financial offset data is displayed.

[0017] On the other hand, embodiments of the present invention provide a financial data consolidation and offsetting processing apparatus based on electronic vouchers, comprising: The electronic voucher acquisition module is used to acquire multiple electronic vouchers generated from purchasing and sales transactions, and assign a globally unique ID to the electronic vouchers after performing compliance verification. The association index building module is used to determine the business mode corresponding to each of the electronic vouchers, perform business matching on the electronic vouchers to obtain multiple collaborative tasks, and then initiate online confirmation to the transaction parties corresponding to each collaborative task, and establish an association index between the globally unique ID and the collaborative number after the transaction parties confirm. The identifier and indicator determination module is used to determine the transaction type identifier and transaction unit level identifier corresponding to each of the electronic vouchers, and to calculate the derivative financial indicators corresponding to each of the electronic vouchers. The offsetting entry generation module is used to obtain multiple target electronic vouchers corresponding to the same collaborative task according to the association index, and generate multi-level offsetting entries corresponding to the target electronic vouchers according to the transaction type identifier, the transaction unit level identifier and the derived financial indicators. The binding module is used to bind the multi-level offsetting entries to the globally unique ID corresponding to the target electronic voucher, so as to obtain traceable financial offsetting data.

[0018] On the other hand, embodiments of the present invention provide an electronic device, including: At least one processor; At least one memory for storing at least one program; When the at least one program is executed by the at least one processor, the at least one processor implements the above-described method for consolidating and offsetting financial data based on electronic vouchers.

[0019] On the other hand, embodiments of the present invention also provide a computer-readable storage medium storing a processor-executable computer program that, when executed by a processor, implements the above-described method for consolidating and offsetting financial data based on electronic vouchers.

[0020] On the other hand, embodiments of the present invention also provide a computer program product, including a computer program that, when executed by a processor, implements the above-described method for consolidating and offsetting financial data based on electronic vouchers.

[0021] The advantages and beneficial effects of the present invention will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention: This invention acquires multiple electronic vouchers generated from purchasing and sales transactions. After compliance verification, each electronic voucher is assigned a globally unique ID. The business model corresponding to each electronic voucher is determined, and business matching is performed to obtain multiple collaborative tasks. Online confirmation is then initiated with the corresponding trading parties for each collaborative task. After confirmation by the trading parties, an association index is established between the globally unique ID and the collaborative number. The transaction type identifier and transaction unit level identifier corresponding to each electronic voucher are determined, and the derived financial indicators corresponding to each electronic voucher are calculated. Based on the association index, multiple target electronic vouchers corresponding to the same collaborative task are obtained. Multi-level offsetting entries corresponding to the target electronic vouchers are generated based on the transaction type identifier, transaction unit level identifier, and derived financial indicators. These multi-level offsetting entries are bound to the globally unique ID corresponding to the target electronic vouchers to obtain traceable financial offsetting data. This invention improves the efficiency, accuracy, and reliability of financial data consolidation and offsetting by performing business matching on electronic vouchers to obtain multiple collaborative tasks, generating multi-level offsetting entries for multiple target electronic vouchers corresponding to the same collaborative task based on the transaction type identifier, transaction unit level identifier, and derived financial indicators, and binding these entries to the globally unique ID of the target electronic vouchers. Attached Figure Description

[0022] To more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings used in the embodiments of the present invention are described below. It should be understood that the drawings described below are only for the convenience of clearly describing some embodiments of the technical solutions of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0023] Figure 1 A flowchart illustrating the steps of a method for consolidating and offsetting financial data based on electronic vouchers, provided in an embodiment of the present invention; Figure 2 A structural block diagram of a financial data consolidation and offsetting processing device based on electronic vouchers provided in an embodiment of the present invention; Figure 3 This is a structural block diagram of an electronic device provided in an embodiment of the present invention. Detailed Implementation

[0024] To make the objectives, technical solutions, and advantages of this invention clearer, the invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention. In the following description, when referring to the accompanying drawings, unless otherwise indicated, the same numbers in different drawings represent the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the embodiments of this invention; they are merely examples of apparatuses and methods consistent with some aspects of the embodiments of this invention as detailed in the appended claims.

[0025] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention pertains. The terminology used herein is for the purpose of describing embodiments of the invention only and is not intended to limit the invention.

[0026] The existing financial data consolidation and elimination scheme has the following problems: 1) The two existing systems are physically isolated, lack a unified data association and indexing technology, and the audit evidence chain is incomplete. The electronic filing system and the consolidation and offsetting system have independent databases and lack a globally unified indexing mechanism; electronic vouchers only store images, and the structured metadata of transactions cannot be synchronized to the accounting and offsetting module; the generation of offsetting entries relies solely on general ledger data and cannot be linked to the original internal transaction electronic vouchers. During audits and state-owned asset inspections, financial personnel must manually compare documents with offsetting working papers across two systems, resulting in a huge workload for manual retrieval and verification; offsetting transactions cannot be traced back to their source, and multiple audits have pointed out that internal offsetting lacks a complete chain of business evidence, posing compliance risks.

[0027] 2) Multi-source and multi-format electronic vouchers lack integrated automated processing technology, resulting in a large amount of manual operation and non-compliant archiving. The existing general financial system lacks a standardized multi-channel automatic data collection interface. Various OFD electronic vouchers generated by tax, banking, railway, and internal business operations require manual uploading and entry by finance personnel. It lacks dedicated OFD parsing components, automatic electronic signature verification, and automated verification capabilities for integrity, availability, security, and readability (four properties). It cannot automatically extract metadata such as transaction unit, collaboration number, and amount to establish a retrieval database. When processing massive amounts of vouchers from multiple provincial, municipal, and county-level units concurrently, the system response is slow. A large number of documents do not meet the Ministry of Finance's legal standards for paperless electronic archiving and still require paper document archiving.

[0028] 3) Internal transactions employ a post-transaction offline offsetting scheme, lacking pre-transaction collaboration and intelligent matching algorithms, resulting in frequent data discrepancies. The existing industry-standard offsetting model is a post-processing logic of "first recording, then reconciliation," which lacks an online collaborative confirmation process based on electronic vouchers; it lacks collaborative numbering and multi-dimensional composite matching algorithms, and only supports simple one-to-one manual verification of transactions, failing to automatically identify complex one-to-many and many-to-many internal transactions involving materials, funds, and engineering projects; multi-level offsetting entries and multi-caliber consolidated financial statements are all manually prepared, making it impossible to control differences in the timing, amount, and business scope of recording between the two parties in advance, lengthening the settlement cycle, and easily causing inconsistencies in multiple sets of financial statements.

[0029] 4) Data silos exist between archives and accounting, and voucher data cannot be automatically transferred to the offsetting calculation stage. Data exchange between the two systems relies on manual export and import. The structured data of transactions and income and expenditure within the electronic vouchers cannot be automatically pushed to the offset calculation module. Each month-end settlement requires manual reorganization of document information and repeated data processing, which is prone to data entry errors and significantly extends the time for the group's monthly and annual settlement.

[0030] To address the above issues, this invention constructs a three-layer bidirectional association index architecture consisting of electronic voucher ID, accounting voucher number, and offsetting entry number. This architecture connects the underlying data of archives and accounting, enabling one-click access to original electronic vouchers for offsetting entries and forming a complete and traceable audit evidence chain. It designs an integrated processing flow encompassing unified collection of multi-source electronic vouchers, dedicated OFD parsing, automatic signature verification, compliance checks, automatic metadata extraction, and hierarchical index archiving. This achieves full-process automation of documents and meets paperless archiving standards. A pre-collaborative control mechanism for electronic vouchers is established, requiring collaborative confirmation before accounting vouchers can be generated. A triple-matching algorithm based on collaboration number, counterparty, and amount is designed to automatically identify various complex internal transactions, automatically generate offsetting entries at each level, and unify the underlying data to achieve consistent output of multi-caliber reports. An automated data flow channel is established from the archive module to the accounting offsetting module, automatically collecting voucher metadata into the internal transaction data pool. Offset calculations directly reuse original business data, eliminating manual secondary processing steps.

[0031] The relevant terms used in the embodiments of the present invention are explained below: Electronic vouchers: OFD format documents that conform to the accounting data standards for electronic vouchers in Finance and Accounting Document No. 6 of 2022, including electronic VAT invoices (special / general), railway / airline electronic tickets, bank electronic receipts, non-tax payment slips, and electronic settlement slips for internal power grid transactions, and have legal electronic signature and archiving validity.

[0032] Four-fold verification: Electronic record compliance testing standards, which respectively verify the integrity, usability, security and readability of documents, and provide a mandatory archiving testing process with clearly defined project requirements.

[0033] Metadata: Structured fields automatically extracted by the system from OFD electronic vouchers, including unique document number, transaction parties' units, amount, business type, collaboration number, payment period, etc., used for data association retrieval.

[0034] Pre-transaction collaboration and confirmation: Project requirements define the control process. After the internal electronic transaction voucher is generated, both parties to the transaction verify the information online and confirm it. Only after the confirmation is passed can the accounting voucher be generated.

[0035] Integrated consolidation and offsetting: Based on internal transaction electronic voucher data, an automated accounting process is used to automatically identify and match internal transactions, generate offsetting entries at all levels and consolidate data from multiple sources, which is the core construction content of this project.

[0036] Two-way association index: Establish a one-to-one mapping relationship between electronic voucher ID, accounting voucher number, and offsetting entry number to achieve two-way penetration query between entries and original documents.

[0037] The financial data consolidation and offsetting processing method based on electronic vouchers provided in this invention can be applied to terminals, servers, or software running on either terminal or server. In some embodiments, the terminal can be a smartphone, tablet, laptop, desktop computer, smart speaker, smartwatch, or vehicle terminal, but is not limited thereto; the server can be configured as an independent physical server, a server cluster or distributed system composed of multiple physical servers, or a cloud server providing basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communication, middleware services, domain name services, security services, CDN, and big data and artificial intelligence platforms. The server can also be a node server in a blockchain network; the software can be an application implementing the financial data consolidation and offsetting processing method based on electronic vouchers, but is not limited to the above forms.

[0038] This invention can be used in a wide variety of general-purpose or special-purpose computer system environments or configurations. Examples include: personal computers, server computers, handheld or portable devices, tablet devices, multiprocessor systems, microprocessor-based systems, set-top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, and distributed computing environments including any of the above systems or devices. This invention can be described in the general context of computer-executable instructions, such as program modules, that are executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc., that perform specific tasks or implement specific abstract data types. This invention can also be practiced in distributed computing environments where tasks are performed by remote processing devices connected via a communication network. In distributed computing environments, program modules can reside in local and remote computer storage media, including storage devices.

[0039] It should be noted that in various specific embodiments of the present invention, when processing data related to user identity or characteristics, such as user information, user behavior data, user historical data, and user parking space location information, user permission or consent is obtained first. Furthermore, the collection, use, and processing of this data comply with relevant laws, regulations, and standards. In addition, when embodiments of the present invention require access to sensitive personal information of users, separate permission or consent from the user is obtained through pop-ups or redirection to a confirmation page. Only after obtaining the user's separate permission or consent is the necessary user-related data for the normal operation of the embodiments of the present invention acquired.

[0040] Reference Figure 1 This invention provides a method for consolidating and offsetting financial data based on electronic vouchers, specifically including the following steps: S101. Obtain multiple electronic vouchers generated from purchasing and sales transactions, and assign a globally unique ID to the electronic vouchers after compliance verification. S102. Determine the business model corresponding to each electronic voucher, perform business matching on the electronic voucher to obtain multiple collaborative tasks, then initiate online confirmation to the transaction party corresponding to each collaborative task, and establish a globally unique ID and collaborative number association index after the transaction party confirms. S103. Determine the transaction type identifier and transaction unit level identifier corresponding to each electronic voucher, and calculate the derivative financial indicators corresponding to each electronic voucher. S104. Obtain multiple target electronic vouchers corresponding to the same collaborative task based on the association index, and generate multi-level offset entries corresponding to the target electronic vouchers based on the transaction type identifier, transaction unit level identifier and derived financial indicators. S105. Bind the multi-level offsetting entries to the globally unique ID corresponding to the target electronic voucher to obtain traceable financial offsetting data.

[0041] It can be recognized that the embodiments of the present invention perform business matching on electronic vouchers to obtain multiple collaborative tasks, generate multi-level offset entries for multiple target electronic vouchers corresponding to the same collaborative task based on transaction type identifier, transaction unit level identifier and derived financial indicators, and bind them with the globally unique ID of the target electronic vouchers to obtain traceable financial offset data, thereby improving the efficiency, accuracy and reliability of financial data consolidation and offset.

[0042] As a further optional implementation, after compliance verification of the electronic certificate, a globally unique ID is assigned, which specifically includes: S1011. Extract the structured metadata corresponding to the electronic voucher. The structured metadata includes the transaction entity, collaboration number, amount of receipt and payment, and the corresponding payment period. S1012. Perform integrity verification on electronic vouchers based on structured metadata, usability verification on electronic vouchers based on data format, security verification on electronic vouchers based on electronic signatures, and readability verification on electronic vouchers based on rendering results. S1013. When the integrity verification, availability verification, security verification and readability verification are all successful, the compliance verification is determined to be passed, and the electronic certificate is bound to the corresponding globally unique ID and stored in the electronic archive.

[0043] Specifically, the first step involves unified collection, parsing, and compliance preprocessing of multi-source electronic vouchers: This embodiment of the invention interfaces with tax platforms, bank-enterprise direct connection systems, and internal business systems, automatically retrieving electronic vouchers in OFD and PDF formats. It supports both batch import and real-time synchronization collection modes to adapt to the data transmission needs of different business scenarios. Pre-defined anomaly identification rules automatically detect vouchers with missing core fields such as transaction subject / amount / payment period, failed electronic signature verification, or corrupted file formats. Abnormal vouchers are intercepted and a return notification is pushed, along with a detailed explanation of the anomaly, facilitating correction and completion by the business side. A dedicated parsing engine is developed for the national standard OFD format, accurately extracting 12 types of core metadata, including transaction unit, collaboration number, income and expenditure amount, and payment period. For PDF format vouchers, a combination of OCR and NLP technologies is used to realize unstructured data processing. The system performs structured transformation of electronic vouchers; it conducts four-dimensional compliance verification, including integrity verification (checking that the voucher file and core business fields are not missing or damaged), usability verification (verifying that the file can be opened normally and the data format conforms to financial accounting standards), security verification (completing electronic signature hash verification through the CA interface to confirm that the file has not been tampered with), and readability verification (verifying that the layout file can be rendered and displayed normally, ensuring the integrity of visual information). Vouchers that pass all four verifications are marked with a "compliant" label and proceed to the next process; each compliant voucher is assigned a globally unique ID, establishing a one-to-one mapping relationship between the original file and metadata, and is stored using layered encryption technology, with metadata using symmetric encryption and the original file using asymmetric encryption; electronic vouchers are stored in an electronic archive, supporting multi-dimensional retrieval by voucher ID, transaction unit, time, and other dimensions.

[0044] Specifically, in the multi-level financial scenarios of power groups, various electronic vouchers come from diverse sources, have inconsistent formats, and contain abnormal data such as damaged documents, invalid signatures, and missing information. If these vouchers were to flow directly into the accounting process, it would cause distortion in reconciliation and offsetting data. This invention designs a standardized voucher preprocessing workflow to uniformly complete document filtering, structured parsing, and archiving mapping. The system integrates with the tax platform, multiple banks for direct bank-enterprise connections, and internal business systems to automatically retrieve OFD and PDF format electronic vouchers. It sets abnormal document filtering rules to automatically identify and reject vouchers with missing transaction fields, failed electronic signature verification, or damaged format images. Dedicated parsing logic has been developed for national standard OFD files to automatically extract structured metadata such as transaction unit, collaboration number, income and expenditure amount, and payment period. It simultaneously performs compliance checks on integrity, availability, security, and readability (the four-compliance check process sequentially completes layered checks on integrity, availability, security, and readability: first, it verifies that the voucher file and core business fields are not missing or damaged; second, it verifies that the file can be opened normally and the data format is compliant; then, it completes electronic signature hash verification through the CA interface to determine if the file has been tampered with; finally, it verifies that the format file can be rendered and recognized normally; all four checks are completed). The compliant vouchers, once approved by the department, are marked with a compliance tag and enter the archiving process; if any verification fails, the voucher is intercepted. A globally unique ID is assigned to each compliant voucher, establishing a one-to-one mapping between the original file and its metadata. This mapping provides the underlying unique identifier for the subsequent three-layer business association index; it is only used for document storage and basic information retrieval within the accounting archives. The subsequent three-layer association index—electronic voucher-accounting voucher-offsetting entry—constructed in the collaboration and offsetting stages is a cross-archive and accounting module business association mapping. During audit tracing, the system first queries the three-layer association index through the offsetting entry to obtain the globally unique ID of the electronic voucher, then retrieves the original voucher file and complete metadata through the stored mapping relationship. The two mapping tables work together to achieve a complete penetrating query from the offsetting working paper to the original business document. This is then stored in the electronic archive database with layered encryption. After this process, a standardized electronic voucher dataset carrying complete metadata, compliance verification tags, and a unique identifier is output.

[0045] As an optional implementation, the business model corresponding to each electronic voucher is determined, and the electronic vouchers are matched for business purposes to obtain multiple collaborative tasks, which specifically include: S1021. Classify each electronic voucher according to the preset collaborative business template to obtain the corresponding business model. The business model is one of bilateral collaboration, unilateral offsetting, and tripartite collaboration. S1022. Filter multiple candidate electronic vouchers corresponding to the same collaborative task according to the collaborative number, and perform business matching on the candidate electronic vouchers according to the transaction subject and the amount of income and expenditure to determine multiple collaborative electronic vouchers belonging to the same collaborative task, and then push the multiple collaborative electronic vouchers corresponding to the same collaborative task to the collaborative task pool.

[0046] Specifically, the system then performs pre-collaborative classification and matching of internal transaction electronic vouchers: Based on the group's preset collaborative business templates, this invention automatically identifies internal transaction vouchers and supports automatic classification of three business models: bilateral collaboration, unilateral offsetting, and tripartite collaboration. It constructs a triple matching dimension of "business unit code + exclusive collaboration number + transaction amount," automatically aggregating vouchers from both parties for the same transaction into a collaborative task pool, achieving intelligent pairing for complex one-to-many and many-to-many transactions. Online confirmation requests are pushed to both parties, supporting multi-terminal operation on web and mobile devices. Both parties must verify core information such as the transaction entity, amount, and payment period. Collaboration is completed only after confirmation by both parties. The system only grants permission to generate accounting vouchers after confirmation by both parties, preventing discrepancies in accounting entries from the source. The system automatically records the association between electronic voucher ID, collaboration number, and accounting voucher number, constructing a business association mapping across archives and accounting modules, providing a foundation for subsequent offsetting and traceability.

[0047] As an optional implementation, online confirmation is initiated to the parties involved in each collaborative task, and a globally unique ID and collaboration number association index is established after the parties confirm the confirmation. This specifically includes: S1023. Push the collaborative electronic vouchers of each collaborative task to the corresponding number of trading parties, so that the trading parties can verify the collaborative electronic vouchers and return confirmation information after verification. S1024. Bind the collaboration number of the collaboration task to the globally unique ID of the corresponding collaboration electronic voucher, and assign the corresponding accounting number to obtain the association index.

[0048] Specifically, existing group offsetting models rely on manual offline verification after the fact, which cannot proactively control discrepancies in accounting entries between the two parties, and makes automatic matching difficult for complex one-to-many and many-to-many internal transactions. This invention identifies internal transaction vouchers based on pre-set group-wide templates for two-party collaboration, unilateral offsetting, and three-party collaboration. It constructs a matching logic based on three dimensions: counterparty code, unique collaboration number, and transaction amount. It automatically aggregates vouchers from both parties corresponding to the same cross-unit transaction into a collaboration task pool, pushing online confirmation requests to both parties. The system only grants voucher generation permissions after both parties have verified the document information and completed collaboration confirmation, thus avoiding discrepancies in accounting timing and amount calculations from the source. After collaboration is completed, it automatically records the association index of the electronic voucher ID, collaboration number, and voucher number. This step outputs an internal transaction voucher dataset bound to the three-layer association index and marked with the collaboration completion status.

[0049] As an optional implementation method, the transaction type is identified as one of claims, debts, and cash flows; the transaction unit level is determined according to the organizational structure level of the party to which the electronic voucher belongs; and the derived financial indicators include at least one of internal unrealized profits and intercompany differences.

[0050] Specifically, the internal transaction voucher then undergoes multi-caliber data enhancement processing: Based on voucher metadata, this embodiment of the invention automatically identifies and labels business categories such as receivables, payables, and cash flows, supports custom label extensions, and adapts to the specific business needs of the group; according to the multi-level organizational structure of provinces, cities, and counties, it automatically supplements the hierarchical affiliation identifier of the transaction unit, supporting automatic identification and labeling of cross-level transactions; it automatically calculates derivative financial fields such as internal unrealized profits and intercompany differences, and intelligently identifies the internal profit portions that need to be offset based on transaction type and amount; it unifies data formats such as amount and date, eliminates format differences of vouchers from multiple channels, and generates a standardized dataset that meets the requirements of multi-caliber consolidation.

[0051] Specifically, power grid groups need to issue multiple consolidated financial statements simultaneously, including those for legal entities, industry sectors, and state-owned asset supervision. The original vouchers only contain basic revenue and expenditure information, lacking multi-dimensional statistical identifiers, and cannot directly support multi-caliber offsetting calculations. This invention enhances the processing of pre-processed, collaboratively completed voucher metadata, automatically extracting business classification tags for receivables, payables, and cash flow; automatically supplementing hierarchical affiliation identifiers according to provincial, municipal, and county-level organizations; automatically calculating derived financial fields such as internal unrealized profits and inter-company differences; and standardizing the data formats for amounts and dates, eliminating differences in voucher formats across multiple channels, and providing a standardized data source for multi-caliber consolidation calculations. The enhanced dataset generates a standardized voucher dataset with multiple management dimensions and derived financial indicators.

[0052] As a further optional implementation, multiple target electronic vouchers corresponding to the same collaborative task are obtained based on the association index, and multi-level offsetting entries corresponding to the target electronic vouchers are generated based on the transaction type identifier, transaction unit level identifier, and derived financial indicators. Specifically, this includes: S1041. Obtain multiple globally unique IDs of targets corresponding to the same collaborative task based on the association index, and obtain the corresponding electronic vouchers of targets from the electronic archive based on the globally unique IDs of targets. S1042. Obtain the corresponding consolidation and offsetting strategy based on the transaction type identifier of the target electronic voucher; S1043. Based on the transaction unit level identifier of the target electronic voucher, the derivative financial indicators are calculated layer by layer according to the consolidation and elimination strategy in order from low to high level to obtain the corresponding elimination entry data for each level. S1044. Generate multi-level offset entries corresponding to the target electronic voucher based on the offset entry data.

[0053] Specifically, multi-level automatic consolidation and offsetting operations are then performed: This embodiment of the invention distinguishes between two independent sets of offsetting calculation rules for inter-company transactions and funds transactions, supports custom rule configuration, and adapts to the offsetting needs of different business scenarios; it retrieves the three-layer association index generated in the collaboration phase, automatically matches the business data of both parties in each group of internal transactions, and supports automatic matching and offsetting of complex one-to-many and many-to-many transactions; it calculates the internal inter-company offsetting amount and unrealized profit layer by layer according to the order of prefecture-level city, province, and group, and generates corresponding offsetting entries at each level to ensure the accuracy and traceability of the data; based on the same set of underlying voucher data, it synchronously outputs three types of consolidated financial statement drafts for legal persons, industries, and regulators, and each offsetting entry is backfilled with the unique traceability ID of the corresponding original electronic voucher.

[0054] Specifically, traditional offsetting relies on manual journal entries, resulting in a large workload for multi-level group adjustments and potential inconsistencies in multiple sets of reports. This invention uses an enhanced standardized voucher dataset as the underlying data source for the offsetting calculation module, distinguishing between two independent offsetting calculation rules for inter-company transactions and funds transactions. It retrieves the three-layer association index generated during the collaboration phase, automatically matching the business data of each group of internal transaction parties. Internal inter-company offsetting amounts and unrealized profits are calculated level by level according to city, province, and group, generating corresponding offsetting entries at each level. Based on the same set of underlying voucher data, it simultaneously outputs three types of consolidated working papers: legal entity, industry, and regulatory. Each offsetting entry is backfilled with the unique traceability ID of the corresponding original electronic voucher. This step outputs offsetting entries at all levels and consolidated working papers with multiple calibers, allowing for one-to-one binding of entries to original vouchers.

[0055] As an optional implementation, the financial data consolidation and elimination processing method further includes the following steps: S106. In response to the traceability request for traceable financial offset data, query the corresponding target electronic vouchers based on the corresponding globally unique IDs and display the target electronic vouchers. or, S107. In response to a business query request for the target electronic voucher, retrieve the corresponding traceable financial offset data based on the corresponding globally unique ID, and display the traceable financial offset data.

[0056] Specifically, the final step involves bidirectional reconstruction and tracing of offsetting data and original vouchers: This embodiment of the invention stores the mapping relationship of the entire process of voucher collection, collaborative confirmation, accounting processing, and offsetting calculation, establishing a complete data link from offsetting entries to original vouchers; it supports reverse retrieval of original OFD document images and a complete set of structured transaction metadata from offsetting entries, and also allows forward querying of corresponding offsetting entries and consolidated report entries from original vouchers; it automatically merges and deduplicates multiple offsetting records corresponding to the same internal transaction, supporting two evidence collection modes: single-record query and batch packaging of vouchers for the entire report, meeting different audit needs; it fully records the time, operator, and operation content of each tracing operation in audit logs, which are tamper-proof, ensuring the authenticity and completeness of audit traces.

[0057] Specifically, traditional accounting systems suffer from fragmented archives and offsetting modules, making it impossible to retrieve original business documents from offsetting entries during audits, resulting in cumbersome evidence collection processes. This invention stores the entire process of vouchers, collaboration, accounting, and offsetting mapping relationships, enabling source tracing queries for any offsetting entry or consolidated report item. It retrieves original OFD document images and complete structured transaction metadata based on the electronic voucher ID carried by the entry; automatically merges and deduplicates multiple offsetting records corresponding to the same internal transaction; and supports both single-entry queries and batch packaging of vouchers for the entire report as evidence collection modes; and fully records the audit log for each source tracing operation. This step achieves complete evidence chain reconstruction of entries and original business vouchers, outputting an audit archive data package and operation logs that can be previewed online and exported offline.

[0058] The method steps of the embodiments of the present invention have been described above. The present invention will be further described below with reference to a specific embodiment.

[0059] Taking the internal material purchase and sale business between a provincial materials company and local power supply bureaus as an example, the complete process of the financial data consolidation and offsetting method based on electronic vouchers of this invention is as follows: 1. The system automatically collects OFD internal settlement electronic vouchers generated by the procurement business of the city and enters the preprocessing stage. After verifying that the electronic signature and document information are normal, the system parses the transaction amount and collaboration number and assigns a unique voucher ID, and stores it in the archive. 2. The system identifies that the transaction is an internal transaction between provincial and municipal units, collects the vouchers of both the buyer and seller into the same collaborative task, pushes the online confirmation of the financial personnel of both parties, and unlocks the accounting function after the verification is correct, and automatically records the association index of vouchers, collaboration, and accounting. 3. Enhance the voucher data by automatically adding provincial and municipal level identifiers and calculating unrealized profits within the purchase and sale of materials; 4. The offset module reads the paired collaborative vouchers and generates offset entries at the city and group levels according to the material transaction offset formula. The entries are bound to the corresponding electronic voucher IDs. 5. When auditors query the provincial consolidation and offsetting working papers, they can click the entry tracing button. The system will retrieve the complete set of electronic settlement voucher images and transaction details for both the buyer and seller. The entire set of business data can be directly packaged and exported for audit archiving. The system will also record the query operation log simultaneously.

[0060] It can be recognized that the embodiments of the present invention perform business matching on electronic vouchers to obtain multiple collaborative tasks, generate multi-level offset entries for multiple target electronic vouchers corresponding to the same collaborative task based on transaction type identifier, transaction unit level identifier and derived financial indicators, and bind them with the globally unique ID of the target electronic vouchers to obtain traceable financial offset data, thereby improving the efficiency, accuracy and reliability of financial data consolidation and offset.

[0061] This invention effectively solves problems such as fragmented archives and accounting modules in traditional financial systems, heavy workload of manual reconciliation of internal transactions, broken audit evidence chains, and inconsistencies in data from multiple sets of reports. This invention utilizes a complete linkage process through standardized preprocessing of multi-source electronic vouchers, pre-collaborative confirmation and control, three-layer data association indexing, voucher-driven automatic offsetting, and reverse tracing and reconstruction of journal entries. This reduces the burden of manual offline operations for financial personnel, controls the quality of accounting data from the source, and fully meets the dual compliance requirements of national electronic archives paperlessness and state-owned asset audit traceability supervision. This solution utilizes a pre-confirmation collaborative mechanism to complete online verification between both parties before internal transaction vouchers are entered into the accounting system, eliminating discrepancies in the timing, amount, and business scope of transaction entry from the source. Leveraging a three-tiered bidirectional index of electronic vouchers, accounting vouchers, and offsetting entries, it enables one-click reverse retrieval of original business documents for offsetting entries, fully connecting the evidence throughout the entire process from business origin to accounting processing and consolidation offsetting. Based on voucher metadata, it drives multi-level automatic offsetting calculations, unifying the underlying data source to output multi-caliber consolidated reports, completely avoiding data conflicts between multiple sets of reports. This automated process significantly reduces the month-end group settlement cycle, while pre-processing data cleaning and four-factor verification rules intercept abnormal vouchers from flowing into the accounting stage, reducing data errors and omissions caused by manual entry and verification, and simultaneously improving the efficiency of multi-level financial accounting and audit evidence collection within the group.

[0062] Reference Figure 2 This invention provides a financial data consolidation and offsetting processing apparatus based on electronic vouchers, comprising: The electronic voucher acquisition module is used to acquire multiple electronic vouchers generated by purchasing and sales transactions, and assign a globally unique ID to the electronic vouchers after compliance verification. The association index building module is used to determine the business model corresponding to each electronic voucher, perform business matching on the electronic voucher to obtain multiple collaborative tasks, and then initiate online confirmation to the transaction party corresponding to each collaborative task. After the transaction party confirms, an association index of globally unique ID and collaborative number is established. The identifier and indicator determination module is used to determine the transaction type identifier and transaction unit level identifier corresponding to each electronic voucher, and to calculate the derivative financial indicators corresponding to each electronic voucher. The offsetting entry generation module is used to obtain multiple target electronic vouchers corresponding to the same collaborative task based on the association index, and generate multi-level offsetting entries corresponding to the target electronic vouchers based on the transaction type identifier, transaction unit level identifier and derivative financial indicators. The binding module is used to bind multi-level offsetting entries to the globally unique ID corresponding to the target electronic voucher, thereby obtaining traceable financial offsetting data.

[0063] It is understood that the content of the above method embodiments is applicable to the present device embodiments. The specific functions implemented by the present device embodiments are the same as those of the above method embodiments, and the beneficial effects achieved are also the same as those achieved by the above method embodiments.

[0064] Reference Figure 3 This invention provides an electronic device, comprising: At least one processor; At least one memory for storing at least one program; When the above-mentioned at least one program is executed by the above-mentioned at least one processor, the above-mentioned at least one processor implements the above-mentioned method for consolidating and offsetting financial data based on electronic vouchers.

[0065] It is understood that the content of the above method embodiments is applicable to this device embodiment. The specific functions implemented by this device embodiment are the same as those of the above method embodiments, and the beneficial effects achieved are also the same as those achieved by the above method embodiments.

[0066] This invention also provides a computer-readable storage medium storing a processor-executable computer program that, when executed by a processor, implements the above-described method for consolidating and offsetting financial data based on electronic vouchers.

[0067] A computer-readable storage medium according to an embodiment of the present invention can execute a financial data consolidation and offsetting processing method based on electronic vouchers provided in an embodiment of the present invention. It can execute any combination of implementation steps of the method embodiment and has the corresponding functions and beneficial effects of the method.

[0068] This invention also provides a computer program product, including a computer program that, when executed by a processor, implements the above-described method for consolidating and offsetting financial data based on electronic vouchers.

[0069] It is understood that the content of the above method embodiments is applicable to the embodiments of this program product. The specific functions implemented by the embodiments of this program product are the same as those of the above method embodiments, and the beneficial effects achieved are also the same as those achieved by the above method embodiments.

[0070] Memory, as a non-transitory computer-readable storage medium, can be used to store non-transitory software programs and non-transitory computer-executable programs. Furthermore, memory may include high-speed random access memory, and may also include non-transitory memory, such as at least one disk storage device, flash memory device, or other non-transitory solid-state storage device. In some embodiments, memory may optionally include memory remotely located relative to the processor, and these remote memories can be connected to the processor via a network. Examples of such networks include, but are not limited to, the Internet, intranets, local area networks, mobile communication networks, and combinations thereof.

[0071] The embodiments described in this invention are for the purpose of more clearly illustrating the technical solutions of the embodiments of this invention, and do not constitute a limitation on the technical solutions provided by the embodiments of this invention. As those skilled in the art will know, with the evolution of technology and the emergence of new application scenarios, the technical solutions provided by the embodiments of this invention are also applicable to similar technical problems.

[0072] The terms "first," "second," "third," "fourth," etc. (if present) in the specification and accompanying drawings of this invention are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate so that embodiments of the invention described herein can be implemented in orders other than those illustrated or described herein. Furthermore, the terms "comprising" and "having," and any variations thereof, are intended to cover a non-exclusive inclusion; for example, a process, method, system, product, or apparatus that comprises a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or apparatus.

[0073] In some alternative embodiments, the functions / operations mentioned in the block diagrams may not occur in the order shown in the operation diagrams. For example, depending on the functions / operations involved, two consecutively shown blocks may actually be executed substantially simultaneously, or the aforementioned blocks may sometimes be executed in reverse order. Furthermore, the embodiments presented and described in the flowcharts of this invention are provided by way of example to provide a more comprehensive understanding of the technology. The disclosed methods are not limited to the operations and logic flows presented herein. Alternative embodiments are contemplated in which the order of various operations is changed and sub-operations described as part of a larger operation are executed independently.

[0074] Furthermore, although the invention has been described in the context of functional modules, it should be understood that, unless otherwise stated, one or more of the aforementioned functions and / or features may be integrated into a single physical device and / or software module, or one or more functions and / or features may be implemented in a separate physical device or software module. It is also understood that a detailed discussion of the actual implementation of each module is unnecessary for understanding the invention. Rather, given the properties, functions, and internal relationships of the various functional modules in the apparatus disclosed herein, the actual implementation of the module will be understood within the scope of conventional skill of an engineer. Therefore, those skilled in the art can implement the invention as set forth in the claims using ordinary techniques without excessive experimentation. It is also understood that the specific concepts disclosed are merely illustrative and not intended to limit the scope of the invention, which is determined by the full scope of the appended claims and their equivalents.

[0075] If the aforementioned functions are implemented as software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of this invention, or the part that contributes to the prior art, or a portion of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of this invention. The aforementioned storage medium includes various media capable of storing program code, such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.

[0076] The logic and / or steps represented in the flowchart or otherwise described herein, for example, can be considered as a sequenced list of executable instructions for implementing logical functions, and can be embodied in any computer-readable medium for use by, or in conjunction with, an instruction execution system, apparatus, or device (such as a computer-based system, a processor-including system, or other system that can fetch and execute instructions from, an instruction execution system, apparatus, or device). For the purposes of this specification, "computer-readable medium" can be any means that can contain, store, communicate, propagate, or transmit programs for use by, or in conjunction with, an instruction execution system, apparatus, or device.

[0077] More specific examples (a non-exhaustive list) of computer-readable media include: electrical connections (electronic devices) having one or more wires, portable computer disk drives (magnetic devices), random access memory (RAM), read-only memory (ROM), erasable and editable read-only memory (EPROM or flash memory), fiber optic devices, and portable optical disc read-only memory (CDROM). Furthermore, computer-readable media can even be paper or other suitable media on which the aforementioned program can be printed, because the aforementioned program can be obtained electronically, for example, by optically scanning the paper or other medium, followed by editing, interpreting, or otherwise processing as necessary, and then stored in computer memory.

[0078] It should be understood that various parts of the present invention can be implemented in hardware, software, firmware, or a combination thereof. In the above embodiments, multiple steps or methods can be implemented in software or firmware stored in memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, it can be implemented using any one or a combination of the following techniques known in the art: discrete logic circuits having logic gates for implementing logical functions on data signals, application-specific integrated circuits (ASICs) having suitable combinational logic gates, programmable gate arrays (PGAs), field-programmable gate arrays (FPGAs), etc.

[0079] In the foregoing description of this specification, references to terms such as "one embodiment," "another embodiment," or "some embodiments" indicate that a specific feature, structure, material, or characteristic described in connection with an embodiment or example is included in at least one embodiment or example of the present invention. In this specification, illustrative expressions of the above terms do not necessarily refer to the same embodiment or example. Furthermore, the specific features, structures, materials, or characteristics described may be combined in any suitable manner in one or more embodiments or examples.

[0080] Although embodiments of the invention have been shown and described, those skilled in the art will understand that various changes, modifications, substitutions and alterations can be made to these embodiments without departing from the principles and spirit of the invention, the scope of which is defined by the claims and their equivalents.

[0081] The above is a detailed description of the preferred embodiments of the present invention. However, the present invention is not limited to the above embodiments. Those skilled in the art can make various equivalent modifications or substitutions without departing from the spirit of the present invention. All such equivalent modifications or substitutions are included within the scope defined by the claims of the present invention.

Claims

1. A method for consolidating and offsetting financial data based on electronic vouchers, characterized in that, Includes the following steps: Obtain multiple electronic vouchers generated from purchasing and sales transactions, and assign globally unique IDs to the electronic vouchers after compliance verification; The business model corresponding to each electronic voucher is determined, the electronic voucher is matched with the business to obtain multiple collaborative tasks, and then online confirmation is initiated to the transaction party corresponding to each collaborative task. After the transaction party confirms, an association index between the globally unique ID and the collaborative number is established. Determine the transaction type identifier and transaction unit level identifier corresponding to each of the aforementioned electronic vouchers, and calculate the derivative financial indicators corresponding to each of the aforementioned electronic vouchers; Multiple target electronic vouchers corresponding to the same collaborative task are obtained according to the association index, and multi-level offset entries corresponding to the target electronic vouchers are generated according to the transaction type identifier, the transaction unit level identifier and the derivative financial indicators. By binding the multi-level offsetting entries with the globally unique ID corresponding to the target electronic voucher, traceable financial offsetting data is obtained.

2. The method for consolidating and offsetting financial data based on electronic vouchers according to claim 1, characterized in that, The process of assigning a globally unique ID after verifying the compliance of the electronic certificate specifically includes: Extract the structured metadata corresponding to the electronic voucher. The structured metadata includes the transaction entity, collaboration number, amount of receipt and payment, and the corresponding billing period. The electronic certificate is verified for integrity based on the structured metadata, for usability based on the data format, for security based on the electronic signature, and for readability based on the rendering result. When the integrity verification, availability verification, security verification, and readability verification are all successful, the compliance verification is determined to be passed, and the electronic certificate is bound to the corresponding globally unique ID and stored in the electronic archive.

3. The method for consolidating and offsetting financial data based on electronic vouchers according to claim 1, characterized in that, The step of determining the business model corresponding to each of the electronic vouchers and performing business matching on the electronic vouchers to obtain multiple collaborative tasks specifically includes: The electronic vouchers are classified according to the preset collaborative business template to obtain the corresponding business model. The business model is one of bilateral collaboration, unilateral offsetting, and tripartite collaboration. Multiple candidate electronic vouchers corresponding to the same collaborative task are filtered according to the collaborative number, and the candidate electronic vouchers are matched according to the transaction subject and the amount of income and expenditure to determine multiple collaborative electronic vouchers belonging to the same collaborative task. Then, the multiple collaborative electronic vouchers corresponding to the same collaborative task are pushed to the collaborative task pool.

4. The method for consolidating and offsetting financial data based on electronic vouchers according to claim 1, characterized in that, The step of initiating online confirmation to the transaction parties corresponding to each of the aforementioned collaborative tasks, and establishing an association index between the globally unique ID and the collaborative number after the transaction parties confirm, specifically includes: The collaborative electronic vouchers for each collaborative task are pushed to several corresponding trading parties, so that the trading parties can verify the collaborative electronic vouchers and return confirmation information after verification. The collaboration number of the collaborative task is bound to the globally unique ID of the corresponding collaborative electronic voucher, and a corresponding accounting number is assigned to obtain the association index.

5. The method for consolidating and offsetting financial data based on electronic vouchers according to claim 1, characterized in that, The transaction type identifier is one of debt, liability, and cash flow; the transaction unit level identifier is determined according to the organizational structure level of the party to which the electronic voucher belongs; and the derived financial indicators include at least one of internal unrealized profit and intercompany difference.

6. The method for consolidating and offsetting financial data based on electronic vouchers according to claim 1, characterized in that, The step of obtaining multiple target electronic vouchers corresponding to the same collaborative task based on the association index, and generating multi-level offsetting entries corresponding to the target electronic vouchers based on the transaction type identifier, the transaction unit level identifier, and the derived financial indicators, specifically includes: Based on the associated index, obtain multiple target globally unique IDs corresponding to the same collaborative task, and based on the target globally unique IDs, obtain the corresponding target electronic vouchers from the electronic archive. Obtain the corresponding consolidation and offsetting strategy based on the transaction type identifier of the target electronic voucher; Based on the transaction unit level identifier of the target electronic voucher, the derivative financial indicators are calculated layer by layer according to the consolidation and offset strategy in ascending order of level to obtain the corresponding offset entry data for each level. The multi-level offsetting entries corresponding to the target electronic voucher are generated based on the offsetting entry data.

7. A method for consolidating and offsetting financial data based on electronic vouchers according to any one of claims 1 to 6, characterized in that, The method for consolidating and offsetting financial data also includes the following steps: In response to a traceability request for the traceable financial offset data, a number of target electronic vouchers are obtained by querying based on the corresponding number of globally unique IDs, and the target electronic vouchers are displayed. or, In response to a business query request for the target electronic voucher, the corresponding traceable financial offset data is obtained by querying based on the corresponding globally unique ID, and the traceable financial offset data is displayed.

8. A financial data consolidation and offsetting processing device based on electronic vouchers, characterized in that, include: The electronic voucher acquisition module is used to acquire multiple electronic vouchers generated from purchasing and sales transactions, and assign a globally unique ID to the electronic vouchers after performing compliance verification. The association index building module is used to determine the business mode corresponding to each of the electronic vouchers, perform business matching on the electronic vouchers to obtain multiple collaborative tasks, and then initiate online confirmation to the transaction parties corresponding to each collaborative task, and establish an association index between the globally unique ID and the collaborative number after the transaction parties confirm. The identifier and indicator determination module is used to determine the transaction type identifier and transaction unit level identifier corresponding to each of the electronic vouchers, and to calculate the derivative financial indicators corresponding to each of the electronic vouchers. The offsetting entry generation module is used to obtain multiple target electronic vouchers corresponding to the same collaborative task according to the association index, and generate multi-level offsetting entries corresponding to the target electronic vouchers according to the transaction type identifier, the transaction unit level identifier and the derived financial indicators. The binding module is used to bind the multi-level offsetting entries to the globally unique ID corresponding to the target electronic voucher, so as to obtain traceable financial offsetting data.

9. An electronic device, characterized in that, include: At least one processor; At least one memory for storing at least one program; When the at least one program is executed by the at least one processor, the at least one processor implements a method for consolidating and offsetting financial data based on electronic vouchers as described in any one of claims 1 to 7.

10. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by the processor, it implements a financial data consolidation and offsetting processing method based on electronic vouchers as described in any one of claims 1 to 7.

Images