Batched accounting return file processing method, system and apparatus

Abstract

This disclosure provides a method, system, and apparatus for processing batch accounting return files. The method includes: acquiring batch accounting basic data from a multi-source system and preprocessing it; generating multiple batches of financial data to be processed independently from the preprocessed data; using multiple first threads to verify each batch of financial data in parallel; matching corresponding return file format templates based on the financial institution information of each batch; using multiple second threads to generate batch return files in parallel from the verified batches of accounting data according to the matched return file format templates; using multiple third threads to verify the batch return files; uploading the verified batch return files in parallel to a designated SFTP server directory via an SFTP connection; and summarizing the processing results of each stage—acquiring the basic data, verifying the batches of financial data, and generating, verifying, and uploading the batch return files—to generate a final processing report.

Description

Technical Field

[0001] This invention relates to the field of financial technology, specifically to a method, system, and apparatus for processing batch accounting return files. Background Technology

[0002] The generation, verification, and uploading of accounting reconciliation files are core components of a company's financial reconciliation process, connecting internal accounting with reconciliation with external financial institutions. Current batch accounting reconciliation file processing is primarily a semi-automated, manually-driven process, mainly consisting of four stages: data preparation, file generation, manual verification, and manual uploading. The entire process, from basic data preparation to SFTP upload, requires significant manual intervention. Data accuracy depends on manual verification, and file uploads are prone to errors due to human negligence. Furthermore, basic accounting data contains sensitive financial information, and issues such as data leakage, tampering, and loss are easily encountered during manual export, local storage, and manual uploading. Summary of the Invention

[0003] The purpose of this invention is to provide a method, system, and apparatus for batch processing of accounting return files, which can automatically process accounting return files in batches to solve the pain points of manual processing in the prior art.

[0004] One embodiment of the present invention relates to a method for processing batch accounting reconciliation files, comprising: acquiring batch accounting basic data from a multi-source system and preprocessing the basic data; generating multiple batches of financial data to be processed independently from the preprocessed data according to the financial institution and / or reconciliation cycle; verifying each batch of financial data in parallel using multiple first threads according to preset data verification rules; matching the corresponding reconciliation file format template from multiple reconciliation file format templates according to the financial institution information of each batch; generating corresponding batch reconciliation files in parallel using multiple second threads for each batch of accounting data that has passed verification according to the matched reconciliation file format template; verifying the batch reconciliation files using multiple third threads according to preset file verification rules; uploading the batch reconciliation files that have passed verification to a designated SFTP server directory in parallel via an SFTP (Secure File Transfer Protocol) connection; and summarizing the processing results of each step, including the acquisition of the basic data, the verification of each batch of financial data, and the generation, verification, and uploading of the batch reconciliation files, to generate a total processing report.

[0005] In some embodiments, preprocessing the basic data includes performing preliminary format standardization on the basic data. In some embodiments, the preliminary format standardization includes unifying field types and handling null values.

[0006] In some implementations, the preset data verification rules include one or more of the following: amount consistency, account validity, transaction uniqueness, and accounting logic relevance.

[0007] In some implementations, the generation of the batch return files includes: each second thread performing field mapping and format conversion on the corresponding batch of financial data according to the matching return file format template, thereby generating a return file in the corresponding format.

[0008] In some implementations, the method further includes: before uploading the batch return files, temporarily storing the generated return files in an encrypted file storage area, wherein the file names are automatically generated according to preset rules, the preset rules including a combination of financial institution code, reconciliation cycle and batch number.

[0009] In some implementations, the preset file verification rules include one or more of the following: consistency between the number of file entries and the number of data batch entries; compliance of file size; standardization of format; and field integrity.

[0010] In some implementations, the method further includes: verifying the batches of financial data or the batch return files; when verification fails, automatically repairing the corresponding data or files or pushing them to manual processing according to the exception handling rules.

[0011] In some implementations, the method further includes: if a network interruption or server connection failure occurs during the upload of the batch of files to disk, automatically retrying the upload operation according to preset rules; and after the batch of files to disk is uploaded, verifying the integrity of the file upload and generating a record indicating whether the upload was successful or failed.

[0012] In some implementations, the overall processing report includes the processing status of each batch, the number of successful or failed batches, and details of any anomalies.

[0013] Another embodiment of the present invention relates to a batch accounting return file processing system, which can be used to perform the method described in any embodiment of the present invention, including: The basic data access module is configured to: acquire batch accounting basic data from multiple source systems and preprocess the basic data; and generate multiple batches of financial data to be processed independently from the preprocessed data according to the financial institution and / or reconciliation cycle. The multi-format configuration module establishes a visual format template library to configure the return file format, field mapping relationship, encoding rules, and file extension requirements for different financial institutions, thereby obtaining return file format templates in various formats. The verification engine module includes a data verification submodule and a file verification submodule. The data verification submodule is used to verify each batch of financial data in parallel using multiple first threads according to preset data verification rules. The parallel processing and file generation module is configured to: match the corresponding return file format template from the multi-format configuration module according to the financial institution information of each batch; use multiple second threads to generate corresponding batch return files in parallel according to the matched return file format templates for each batch of verified accounting data; and call the file verification submodule to verify the batch return files according to preset file verification rules using multiple third threads. The SFTP automatic upload module is configured to upload batch files that have passed pairwise verification to a specified SFTP server directory in parallel via an SFTP connection; and The summary module is configured to summarize the processing results of each step, including the acquisition of the basic data, the verification of the financial data of each batch, and the generation, verification, and uploading of the batch return files, and generate a total processing report.

[0014] Furthermore, embodiments of the present invention provide a computer program product comprising a computer program that, when executed by a processor, implements the steps of the method described in any embodiment of the present invention.

[0015] In addition, embodiments of the present invention also provide a computer device, comprising: a memory storing a computer program thereon; and a processor that executes the computer program to implement the steps of the method described in any embodiment of the present invention.

[0016] The following beneficial effects can be achieved by implementing this invention: According to embodiments of the present invention, this invention achieves end-to-end automated processing of batch accounting return files, from initial basic data preparation, data accuracy verification, return file generation, file integrity verification to automatic SFTP upload, reducing the need for manual intervention and lowering the human error rate and data security risks. The multi-format configuration module can adapt to the file formats, fields, and encoding requirements of different financial institutions. Through batch data verification, parallel file generation, and batch upload mechanisms, the processing speed of batch accounting return files from data preparation to SFTP upload is significantly improved.

[0017] Various aspects, features, and advantages of the embodiments of the present invention will be described in detail below with reference to the accompanying drawings. Attached Figure Description

[0018] Figure 1 This is a flowchart illustrating an embodiment of the batch accounting return file processing method of the present invention.

[0019] Figure 2 This is a block diagram illustrating an embodiment of the batch accounting return file processing system of the present invention.

[0020] Figure 3 This is a block diagram illustrating an embodiment of the present invention of a computer device that can be used to perform a batch accounting return file processing method. Detailed Implementation

[0021] The exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. It should be noted that the present invention can be implemented in various forms and is not limited to the specific embodiments described herein or shown in the accompanying drawings.

[0022] The terms “comprising,” “including,” and “having” are used herein to indicate the presence of certain features, steps, operations, elements, and / or components, but do not exclude the presence or addition of other features, steps, operations, elements, components, or combinations thereof. Unless explicitly defined by context, the terms “first,” “second,” and similar terms do not indicate any priority or order, but are used only to distinguish different elements in the description.

[0023] Reference Figure 1 This illustrates a batch accounting reconciliation file processing method according to an exemplary embodiment of the present invention. For example... Figure 1 As shown, the method includes the following steps: S10, acquiring batch accounting basic data from a multi-source system and preprocessing the basic data; S20, generating multiple batches of financial data to be processed independently from the preprocessed data according to the financial institution and / or reconciliation cycle; S30, verifying each batch of financial data in parallel using multiple first threads according to preset data verification rules; S40, matching the corresponding return file format template from multiple return file format templates according to the financial institution information of each batch; S50, generating corresponding batch return files in parallel using multiple second threads based on the matched return file format templates for each batch of accounting data that has passed verification; S60, verifying the batch return files using multiple third threads according to preset file verification rules; S70, uploading the verified batch return files in parallel to the specified SFTP server directory via SFTP (Secure File Transfer Protocol) connection; S80, summarizing the processing results of each stage of acquiring the basic data, verifying each batch of financial data, and generating, verifying, and uploading the batch return files, and generating a total processing report.

[0024] In some implementations, in step S10, batch accounting basic data is automatically extracted from the enterprise financial system or ERP (Enterprise Resource Planning) system according to pre-configured access rules, such as synchronization time, data source, business scope, etc.

[0025] In some embodiments, preprocessing the basic data in step S10 includes performing preliminary format standardization on the basic data. For example, the preliminary format standardization includes unifying field types and handling null values. In some embodiments, the preprocessed data is temporarily stored in a temporary database.

[0026] In some implementations, in step S30, the preset data verification rules include one or more of the following: amount consistency, account validity, transaction uniqueness, and accounting logic relevance.

[0027] In some implementations, in step S30, batch data that passes verification proceeds to step S40 and is marked as valid; for data that fails verification, the failed data items are marked and the reason for failure is recorded. Further, in some implementations, automatic repair is performed according to anomaly handling rules (e.g., field completion, format correction, etc.). If repair is not possible, an anomaly data list is generated, subsequent processing of that batch is paused, and a manual reminder is sent.

[0028] In some implementations, in step S50, the generation of the batch return files includes: each second thread performs field mapping and format conversion on the corresponding batch of financial data according to the matching return file format template, thereby generating a return file in the corresponding format.

[0029] In some implementations, the method further includes: before uploading the batch return files, temporarily storing the generated return files in an encrypted file storage area, wherein the file names are automatically generated according to preset rules, the preset rules including a combination of financial institution code, reconciliation cycle and batch number.

[0030] In some implementations, in step S60, the preset file verification rules include one or more of the following: consistency between the number of file entries and the number of data batch entries; compliance of file size; format standardization; and field integrity. In some implementations, files that pass verification generate a file verification pass receipt, proceeding to step S70; files that fail verification are marked with the reason for failure, and are automatically repaired (regenerated) or a manual reminder is sent according to the exception handling rules.

[0031] In some implementations, the method further includes: before uploading the batch of return files, loading pre-configured SFTP server connection information (e.g., address, port, account, password, or key file) based on the financial institution information corresponding to each return file, and establishing an encrypted SFTP connection.

[0032] In some embodiments, the method further includes: if a network interruption or server connection failure occurs during the upload of the batch of files to disk, automatically retrying the upload operation according to preset rules; after the batch of files to disk is uploaded, verifying the integrity of the uploaded files and generating a record indicating whether the upload was successful or failed. In some embodiments, if the retry still fails, a manual reminder is sent along with the reason for the failure.

[0033] In some implementations, in step S80, the overall processing report includes the processing status of each batch, the number of successful or failed batches, and details of any anomalies. In some implementations, the method further includes synchronizing the overall processing report, verification receipts, and upload receipts to the enterprise's financial system to achieve data traceability.

[0034] In one or more of the above embodiments, the operation behavior and processing logs of the entire process can be encrypted and stored to achieve operation traceability and auditing.

[0035] Reference Figure 2 This illustrates an exemplary embodiment of a batch accounting return file processing system according to the present invention. The system can be used to perform the methods described in any of the above embodiments. Figure 2 As shown, the system includes at least: a multi-format configuration module 200, a basic data access module 210, a verification engine module 220, a parallel processing and file generation module 230, an SFTP automatic upload module 240, and a summary module 250.

[0036] The multi-format configuration module 200 is used to establish a visual format template library to configure the return file format, field mapping relationship, encoding rules (such as UTF-8, GBK), and file extension requirements for different financial institutions, thereby obtaining return file format templates in various formats. Furthermore, the multi-format configuration module 200 is configured to support operations such as adding, editing, deleting, and reusing templates.

[0037] The basic data access module 210, serving as the system data entry point, is configured to: acquire batch accounting basic data from multiple source systems (such as corporate financial systems and ERP systems), preprocess the basic data, and generate multiple batches of financial data to be processed independently from the preprocessed data according to the financial institution and / or reconciliation cycle. In some embodiments, the basic data access module 210 is configured to extract data using both timed synchronization and triggered synchronization methods.

[0038] The verification engine module 220 includes a data verification submodule and a file verification submodule. The data verification submodule is used to verify each batch of financial data in parallel using multiple first threads according to preset data verification rules. In some embodiments, the data verification submodule verifies the accuracy, relevance, and logic of the accounting data.

[0039] The parallel processing and file generation module 230 is configured to: match the corresponding return file format template from the multi-format configuration module 200 based on the financial institution information for each batch; use multiple second threads to generate corresponding batch return files in parallel from the verified batches of accounting data according to the matched return file format template; and call the file verification submodule to verify the batch return files using multiple third threads according to preset file verification rules. In some embodiments, the file verification submodule verifies the integrity, standardization, and format consistency of the return files.

[0040] The SFTP automatic upload module 240 is configured to upload batch return files that have passed verification to a designated SFTP server directory in parallel via an SFTP connection. In some embodiments, the SFTP automatic upload module 240 is pre-configured with the SFTP server information (address, port, account, password) of each financial institution, establishes an encrypted SFTP connection, realizes batch and automatic upload of return files, supports interrupted resume upload, and generates a transmission verification receipt after the upload is completed.

[0041] The summary module 250 is configured to summarize the processing results of each step, including the acquisition of the basic data, the verification of each batch of financial data, the generation, verification and uploading of the batch return files, and generate a total processing report.

[0042] In some implementations, the system also includes a dynamic rule management module, which is configured to allow users to customize data verification rules, file integrity verification rules, SFTP upload rules, and exception handling rules. The system can dynamically load and execute the rules without modifying the core code.

[0043] In some implementations, the system also includes a full-link security management module, which is used for data encryption (e.g., transmission encryption, storage encryption), operation permission control (e.g., role-based authorization), operation behavior logging, and file anti-tampering verification to ensure data security throughout the entire process.

[0044] In some implementations, the system also includes an anomaly handling and monitoring module, which monitors the running status of each stage of data access, verification, file generation, and uploading in real time, automatically identifies anomalies and automatically repairs or retryes according to preset rules, generates anomaly reports and pushes reminders, and provides a full-process visual monitoring interface.

[0045] It should be understood that the steps, processes, and operations described in the above embodiments can be implemented by computer software programs. Therefore, the embodiments of the present invention also relate to a computer program product, which includes a computer program that, when executed by a processor, implements the steps, processes, or operations performed by the method or system described in any embodiment of the present invention. In some embodiments, program code for executing the computer program of the embodiments of the present invention can be written in any combination of one or more programming languages. For example, the computer program can be written using high-level procedural and / or object-oriented programming languages, and / or assembly / machine languages. Programming languages ​​include, but are not limited to, languages ​​such as Java, C++, Python, "C", or similar programming languages. The program code can be executed entirely on a personal computing device, partially on a personal computing device, partially on a remote computing device, or entirely on a remote computing device or server. In the case of a remote computing device, the remote computing device can be connected to the personal computing device through any type of network, including a local area network (LAN) or a wide area network (WAN), or it can be connected to an external computing device (e.g., via the Internet using an Internet service provider).

[0046] It should also be understood that the computer program product may be stored on a computer-readable storage medium, such as hard disks, floppy disks, magnetic tapes, optical disks, solid-state drives, flash memory, etc.

[0047] Furthermore, it can be understood that the method of any embodiment of the present invention can be executed by a computer device. Accordingly, embodiments of the present invention also relate to a computer device comprising: a memory storing a computer program thereon; and a processor that, when executing the computer program, implements the steps (processing, operations, etc.) of the method described in any embodiment of the present disclosure.

[0048] Figure 3 An exemplary structure of a computer apparatus for performing the methods described in any embodiment of the present invention is shown. For example... Figure 3As shown, the computer device 100 may include at least a processor 101 and a memory 102, wherein the memory 102 may be or include a storage medium storing a computer program (or computer-readable instructions). The processor 101 executes the computer program to perform some or all of the operations described in any embodiment of this disclosure, including but not limited to: S10, obtaining batch accounting basic data from a multi-source system and preprocessing the basic data; S20, generating multiple batches of financial data to be processed independently from the preprocessed data according to the financial institution and / or reconciliation cycle; S30, verifying each batch of financial data in parallel using multiple first threads according to preset data verification rules; S4 S50: Based on the financial institution information for each batch, match the corresponding return file format template from multiple return file format templates; S60: Using multiple second threads, generate corresponding batch return files in parallel from the verified accounting data of each batch according to the matched return file format template; S70: According to preset file verification rules, use multiple third threads to verify the batch return files; S80: Upload the verified batch return files in parallel to the designated SFTP server directory via SFTP connection; S90: Summarize the processing results of the acquisition of basic data, the verification of each batch of financial data, and the generation, verification, and uploading of the batch return files, and generate a processing summary report.

[0049] In some embodiments, the computer device 100 may further include a data storage device 103, a display 104, a speaker 105, and a communication module 106. The processor 101, memory 102, and data storage device 103 communicate with each other via a bus and interact with peripheral devices, such as the display 104 and communication module 106, via the bus and I / O module 107.

[0050] Specifically, data storage device 103 can store application programs and their various configuration files and data. Computer programs are stored on memory 102. Processor 101 executes the computer programs to perform various processes, operations, or steps in the method or system. Display 104 can be used to display various data, images, etc.

[0051] In optional embodiments, the communication module 106 may be omitted where communication with the other systems, devices, or equipment is not required. In some embodiments, the computer device 100 may further include a speaker 105 for voice output.

[0052] In some implementations, processor 101 may include any suitable semiconductor-based electronic processing unit, chip, microchip, or integrated circuit (IC). Memory 102 is a programmable memory, which may include any suitable electronic storage device configured to store instructions and be reprogrammable. For example, programmable memory may include an erasable programmable read-only memory (EPROM) device. Data storage device 103 may be a persistent storage device, which may include any suitable electronic storage device configured to retain stored information as power cycles. For example, data storage device 103 may include a hard disk drive, solid-state drive (SSD), flash memory drive, hybrid drive, etc., or any combination thereof.

[0053] Therefore, processor 101 can control the output of information on I / O module 107 by storing information in memory and / or executing programs / instructions stored in memory. For example, several aspects of the methods described herein can be executed by processor 101 according to programs / instructions stored in memory (e.g., memory 102 and / or data storage device 103).

[0054] Furthermore, the processor 101 can electronically communicate with the I / O module 107 and / or the communication module 106 to receive or send relevant instructions and information. The I / O module 107 may include any suitable mechanical or virtual user interface configured to enable a user to interact with the computer device 100 or to allow the user to perform one or more functions of the computer device 100 itself, such as a graphical user interface (GUI) on a screen or other display. In some instances, the user interface may include a voice interface capable of speech recognition, through which an operator can provide voice commands to the processor.

[0055] Communication module 106 may include any suitable devices and / or structures configured to facilitate information exchange between computer device 100 and external electronic devices (such as corporate financial systems, ERP systems, or SFTP servers). Communication module 106 may include devices configured to send and / or receive wireless or wired information with other devices. For example, communication module 106 may include antennas, transceivers, connectors for wired data reception and / or transmission, data exchange devices, etc., or any combination thereof. Communication module 106 may also include ancillary components, such as filtering circuitry, encryption / decryption circuitry, and / or integrated circuit (IC) chips (e.g., Bluetooth® chips) for processing signals. In some embodiments, communication module 106 may include a WiFi device configured to connect to a local wireless network.

[0056] In some implementations, computer device 100 may include smartphones, wearable computers, portable / mobile electronic devices, tablet computers, smartwatches, personal digital assistants (PDAs), personal computers (PCs), desktop computers, laptop computers, servers, and so on. Computer device 100 may include or have installed one or more application programs (APPs), one of which is configured to perform the batch accounting reconciliation file processing method described herein.

[0057] Although not shown, it should be understood that the computer device 100 also includes a power supply component, which may include any suitable device and / or structure configured to provide an electrical interface between the computer device 100 and a power source. The power source may include any suitable source of electrical energy, such as a battery, socket, capacitor, fuel cell, etc., or any combination thereof. Additionally or optionally, the power source may be included within the power supply component. For example, a battery or battery pack may be included within the computer device 100. In some embodiments, the battery may be rechargeable, for example, charged via a cable or an interface provided by the power supply component. In some embodiments, the power supply component may share features with or repeat features of the communication module 106. For example, a USB or micro-USB cable connector may be included in the computer device 100, so that power supply or data communication is performed by the same component.

[0058] The function or effect of the present invention will be described below.

[0059] The embodiments of this invention significantly improve processing efficiency through parallel processing and batch uploading mechanisms. Tests show that the overall processing speed of batch accounting return files is increased by over 300%, and server resource utilization is improved by 45%.

[0060] According to the system of this invention, end-to-end automated processing is adopted, saving time and costs associated with manual verification and operation. In specific implementation, the automation level reaches over 98%, reducing the workload of financial personnel by approximately 85%.

[0061] This invention improves data and file accuracy by implementing multi-dimensional comprehensive verification through a verification engine module. In practice, it reduces data error rate and file format error rate to below 0.005%.

[0062] This invention, through a multi-format configuration module, supports various common financial institution return file formats, thereby enhancing format adaptability and system scalability. Furthermore, the multi-format configuration module supports adding, editing, deleting, and reusing templates, reducing the configuration time for new formats or rules by 80% and improving system scalability by 6 times. The exception handling and automatic retry mechanism of the present invention reduces exception handling time by 95% and significantly reduces manual intervention.

[0063] The embodiments of this invention employ end-to-end encryption and access control, reducing the risk of data leakage, tampering, and loss by 99.9%. Operations are fully traceable and auditable, comprehensively improving data security.

[0064] The embodiments of the present invention provide a visual interface for rule configuration, format configuration and SFTP configuration through a dynamic rule management module. No professional development capabilities are required, and financial personnel can complete the configuration independently, thus lowering the threshold for system use.

[0065] The embodiments of this invention construct a unified batch accounting reconciliation file processing flow, breaking down the processing differences between different financial institutions and different business scenarios, and realizing standardized management of the pre-reconciliation process of enterprise finance.

[0066] Those skilled in the art should understand that the above disclosure is merely illustrative of embodiments of this disclosure, and the scope of patent protection claimed in this application is not limited thereto. Various modifications, alterations, substitutions, and other changes can be made to the embodiments disclosed herein without departing from the spirit and essence of this disclosure, and such changes are within the scope covered by the claims of this application.

Claims

1. A method for batch processing of accounting return files, characterized in that, include: Batch accounting basic data is obtained from multiple source systems, and the basic data is preprocessed; For the preprocessed data, generate multiple batches of financial data to be processed independently according to the financial institution and / or reconciliation cycle; According to the preset data verification rules, multiple first threads are used to verify the financial data of each batch in parallel. Based on the information from financial institutions in each batch, the corresponding return file format template is matched from various return file format templates. Multiple second threads are used to generate corresponding batch return files in parallel from each batch of verified accounting data according to the matching return file format template; According to preset file verification rules, multiple third-party threads are used to verify the batch of returned files. For batch files that pass verification, upload them in parallel to the specified SFTP server directory via an SFTP connection. as well as A summary processing report is generated by summarizing the results of each step, including the acquisition of the basic data, the verification of the financial data in each batch, and the generation, verification, and uploading of the batch return files.

2. The method according to claim 1, characterized in that, Preprocessing the basic data includes: performing preliminary format standardization on the basic data.

3. The method according to claim 2, characterized in that, The initial format standardization process includes field type unification and null value handling.

4. The method according to claim 1, characterized in that, The preset data verification rules include one or more of the following: consistency of amount, legality of account, uniqueness of transaction records, and logical relevance of accounting.

5. The method according to claim 1, characterized in that, The generation of the batch return files includes: Each second thread maps fields and converts formats of the corresponding batch of financial data according to the matching return file format template, thereby generating a return file in the corresponding format.

6. The method according to claim 5, characterized in that, Also includes: Before uploading the batch return files, the generated return files are temporarily stored in an encrypted file storage area. The file names are automatically generated according to preset rules, which include a combination of financial institution code, reconciliation cycle and batch number.

7. The method according to claim 1, characterized in that, The preset file verification rules include one or more of the following: consistency between the number of file entries and the number of data batch entries; compliance of file size; standardization of format; and integrity of fields.

8. The method according to claim 1, characterized in that, Also includes: The verification of each batch of financial data or the batch return files is performed. If the verification fails, the corresponding data or files are automatically repaired or pushed to manual processing according to the exception handling rules.

9. The method according to claim 1, characterized in that, Also includes: If a network interruption or server connection failure occurs during the upload of the batch of files to disk, the upload operation will be automatically retried according to preset rules. After the batch file upload is completed, verify the integrity of the file upload and generate a record indicating whether the upload was successful or failed.

10. The method according to claim 1, characterized in that, The overall processing report includes the processing status of each batch, the number of successful or failed batches, and details of any anomalies.

11. A batch accounting return file processing system, characterized in that, include: The basic data access module is configured to: acquire batch accounting basic data from multiple source systems and preprocess the basic data; And for the pre-processed data, generate multiple batches of financial data to be processed independently according to the financial institution and / or reconciliation cycle; The multi-format configuration module establishes a visual format template library to configure the return file format, field mapping relationship, encoding rules, and file extension requirements for different financial institutions, thereby obtaining return file format templates in various formats. The verification engine module includes a data verification submodule and a file verification submodule. The data verification submodule is used to verify each batch of financial data in parallel using multiple first threads according to preset data verification rules. The parallel processing and file generation module is configured to: match the corresponding return file format template from the multi-format configuration module based on the financial institution information of each batch; and use multiple second threads to generate corresponding batch return files in parallel from the verified accounting data of each batch according to the matched return file format template. And call the file verification submodule to verify the batch of returned files using multiple third threads according to preset file verification rules; The SFTP automatic upload module is configured to upload batch files that have passed pair verification to disk in parallel to the specified SFTP server directory via an SFTP connection. as well as The summary module is configured to summarize the processing results of each step, including the acquisition of the basic data, the verification of the financial data of each batch, and the generation, verification, and uploading of the batch return files, and generate a total processing report.

12. A computer program product comprising a computer program, characterized in that, When executed by a processor, the computer program performs the steps of the method according to any one of claims 1 to 10.

13. A computer device, characterized in that, include: A memory on which computer programs are stored; A processor that, when executing the computer program, implements the steps of the method according to any one of claims 1 to 10.

Images