TWM641297U - Settlement and final accounts report integration system - Google Patents

Abstract

A settlement and final accounts report integration system includes a communicative device, a database, and a processor. The communicative device is configured to connect to a first department data storage and a second department data storage by connecting an external network. The communicative device is further configured to connect an electronic device of a user. The database is connected to the communicative device and includes a settlement report sub-database and a final accounts report sub-database. The processor is connected to the communicative device and the database and is configured to accept an integration request from the electronic device. The processor is further configured to execute a integration procedure based on the integration request, in which the integration procedure enables the processor to generate an integrated settlement report information, an integrated final accounts report information, and an integrated monthly report information based on the settlement report sub-database and the final accounts report sub-database.

Description

Settlement statement integration system

This disclosure relates to a system for integrating settlement and settlement reports.

At present, the output of the settlement and final statement is manually printed by the handling personnel from the settlement statements and final settlement statements from other departments. After the above-mentioned settlement statements and final settlement statements are printed out in paper, the handling personnel must manually edit them according to different needs. Only in accordance with the order of the reports shall they be submitted to the supervisors at all levels for approval and the declaration of the reports prescribed by the competent authority shall be handled. However, this will lead to a long time for report making and waste of paper.

Therefore, how to propose an integration system for settlement and settlement reports that can solve the above-mentioned problems is one of the problems that the industry is eager to invest in research and development resources to solve.

In view of this, one purpose of this disclosure is to propose a system for integrating settlement and settlement reports that can solve the above-mentioned problems.

In order to achieve the above purpose, according to an implementation manner of the present disclosure, a settlement statement integration system includes a communication device, a database, and a processor. The communication device is configured to connect to the first departmental data storage and the second departmental data storage by connecting to the external network. The communication device is further configured to connect with the user's electronic device. The database is connected to the communication device, and includes a settlement statement sub-database and a settlement statement sub-database. The processor is connected to the communication device and the database, and is configured to accept integration requests from the electronic device. The processor is also configured to execute an integration program based on the integration request, wherein the integration program causes the processor to generate integrated settlement statement information, integrated final statement information, and integrated monthly statement information based on the settlement statement sub-database and the settlement statement sub-database.

In one or more embodiments of the present disclosure, the processor further includes an updating unit. The update unit is configured to: after the control unit of the processor receives the update request from the electronic device of the first user, control the communication device to connect the first department data storage and the second department data storage through the external network, and update the first department The settlement detailed statement data and final settlement detailed statement data in the data warehouse and the second department data warehouse are stored in the settlement statement sub-database and the final settlement statement sub-database respectively.

In one or more embodiments of the present disclosure, the processor further includes an integration unit. The integration unit is configured to: integrate the settlement detailed statement data in the settlement statement sub-database and the final settlement detailed statement data in the final settlement statement sub-database into integrated settlement statement information, integrated final settlement statement information, and integrated monthly statement information.

In one or more implementations of the present disclosure, the processor further includes a judging unit. The judging unit is configured to: execute a judging program after the processor receives a judging request from the electronic device of the first user.

In one or more implementations of the present disclosure, the judging unit is further configured to: determine whether the settlement statement sub-database contains or does not contain settlement detailed statement data and/or the final settlement statement sub-database contains or does not contain final settlement statement data; The time difference between the submission deadline of settlement detailed statement data and/or final settlement detailed statement data and the current time; judging the chronological sequence between the submission deadline and the current time; and judging whether the time difference is less than the warning time interval.

In one or more embodiments of the present disclosure, the processor further includes an alert unit. The warning unit is configured to: when the judging unit judges that the submission deadline is later than the current time, the time difference is less than the warning time interval, and the settlement statement sub-database does not contain settlement detail statement data and/or the final settlement statement sub-database does not contain final settlement detail statement data , sending the first warning notification to the electronic device of the second user; and judging by the judging unit that the submission deadline is earlier than the current time and the settlement statement sub-database does not contain settlement detail report data and/or the final settlement statement sub-database does not contain final settlement details When reporting data, send a second warning notification to the electronic device of the second user.

In one or more implementations of this disclosure, the electronic device of the second user transmits the settlement statement data and settlement statement data in the first department data warehouse and the second department data warehouse to the settlement statement sub In the database and the sub-database of the final statement.

In one or more embodiments of the present disclosure, the processor further includes an output unit. The output unit is configured to output integrated settlement statement information, integrated final settlement statement information, and integrated monthly statement information after the first user sends an output request to the processor through the electronic device.

In one or more implementations of the present disclosure, outputting integrated settlement statement information, integrated final settlement statement information, and integrated monthly statement information includes an export operation and a print operation.

In one or more embodiments of the present disclosure, the processor further includes an input unit . Enter the cell configuration to perform the review process. The review procedure includes: when the processor displays the consolidated settlement statement information, consolidated settlement statement information, and consolidated monthly statement information on the user interface of the third user's electronic device, the third user uses the input unit to perform electronic signature or Manual sign-off.

To sum up, in the settlement statement integration system disclosed in this disclosure, since the data warehouses of different departments can be connected through communication devices, a large amount of settlement statement data and final settlement statement information can be imported to perform the integration process. In the settlement statement integration system disclosed in this disclosure, since the integration unit can be used to compile reports according to different requirements, the time schedule for the integration of settlement and settlement statements is simplified. In the settlement statement integration system disclosed in this disclosure, the judging unit judges whether the database contains the documents submitted by the second user, the chronological order of the submission deadline and the current time, and whether the time difference between the two is based on the integrated data. If it is less than the warning time interval, the warning unit will issue a warning notice to remind the second user to provide the documents, so that the declaration of the report required by the competent authority can be handled within the time limit. In the settlement report integration system disclosed in this disclosure, since the output unit can export different reports into different file formats for third-party users to read, the effect of reducing the storage cost of entity reports can be achieved. In the settlement statement integration system disclosed in this disclosure, since the input unit can be used by a third user to execute the review process, and the review process can be in the form of electronic signature, it is beneficial to improve the review efficiency and enhance the efficiency of account statement inquiry.

The above description is only used to explain the problems to be solved by the present disclosure, the technical means to solve the problems, and the effects thereof, etc. The specific details of the present disclosure will be introduced in detail in the following implementation methods and related drawings.

The following will disclose multiple implementations of the present disclosure with diagrams, and for the sake of clarity, many practical details will be described together in the following description. However, it should be understood that these practical details should not be used to limit the present disclosure. That is to say, in some embodiments of the present disclosure, these practical details are unnecessary. In addition, for the sake of simplifying the drawings, some well-known structures and components will be shown in a simple and schematic manner in the drawings. The same reference numbers will be used throughout the drawings to refer to the same or similar elements.

The term "based on" mentioned in this disclosure means that any element contains related information, or that any element is bound to another element.

The structure, function and connection relationship among the components included in the settlement statement integration system 100 of this embodiment will be introduced in detail below.

Please refer to FIG. 1 , which is a functional block diagram illustrating a settlement statement integration system 100 according to an embodiment of the present disclosure. In this embodiment, as shown in FIG. 1 , the settlement statement integration system 100 includes a communication device 110 , a database 120 and a processor 130 . The communication device 110 is configured to communicate or physically connect with the electronic device 200 , and is configured to connect to the first departmental data warehouse 300 and the second departmental data warehouse 400 through the external network NW. The processor 130 communicates or is physically connected to the communication device 110 . The processor 130 communicates or is physically connected to the communication device 110 and the database 120 , and is configured to receive an integration request from the electronic device 200 . Specifically, the user US can operate the electronic device 200 to send an integration request to the processor 130 . Processor 130 is also configured to execute an integration program based on the integration request. The integration program enables the processor 130 to generate integrated data based on the database 120 . Details about the integration of data will be explained below.

Please refer to FIG. 2 , which is a detailed functional block diagram of the settlement statement integration system 100 according to an embodiment of the present disclosure. In this embodiment, as shown in FIG. 2 , the database 120 includes a settlement report sub-database 122 and a settlement statement sub-database 124 . The settlement statement sub-database 122 is configured to store settlement detail report data from the first departmental data warehouse 300 and the second departmental data warehouse 400 . The final account report sub-database 124 is configured to store final account detail report data from the first departmental data warehouse 300 and the second departmental data warehouse 400 .

Please continue to refer to FIG. 2 , the processor 130 includes a control unit 131 , an integration unit 132 , a judgment unit 133 , a warning unit 134 , an output unit 135 , an update unit 136 and an input unit 137 . The control unit 131 is configured to receive an integration request from the electronic device 200 . Specifically, the first user US1 can operate the electronic device 200 to send an integration request to the processor 130 of the settlement statement integration system 100 . For example, the first user US1 may be an operator. As shown in Fig. 2, the integration unit 132 is configured to integrate the detailed settlement report data in the settlement statement sub-database 122 and the final settlement statement data in the final settlement statement sub-database 124 into an integrated settlement statement information 126, an integrated final settlement statement Information 127 and the above-mentioned integrated data of the integrated monthly report information 128. Specifically, the integrated settlement statement information 126 , the integrated final statement information 127 , and the integrated monthly statement information 128 are all different integrated data based on the above-mentioned settlement detailed report data and final settlement detailed report data.

In some embodiments, the above-mentioned detailed statement of settlement includes but is not limited to time parameters (for example, year, month and day), balance sheet, comprehensive profit and loss statement, statement of changes in shareholders' equity, cash flow statement, and financial statements. In some implementations, the above-mentioned final statement details include but are not limited to time parameters (eg, year, month, and day), business reports, financial statements, and profit distribution or loss making-up tables. In some implementations, the consolidated settlement statement information 126 is formed by integrating settlement statement data and final settlement statement data from different departments (for example, the first department data warehouse 300 and the second department data warehouse 400 ) through the integration unit 132 Including, but not limited to, time parameters (eg, year, month, and day), balance sheets, consolidated income statements, statements of changes in stockholders' equity, cash flow statements, and financial statements. In some implementations, the consolidated final statement information 127 is formed by integrating the settlement detailed statement data and final settlement detailed statement data from different departments (for example, the first department data warehouse 300 and the second department data warehouse 400 ) via the integration unit 132 Including but not limited to business reports, financial statements, and profit distribution or loss allowance statements. In some implementations, the integrated monthly report information 128 is integrated through the integration unit 132 for the settlement detailed statement data and final settlement detailed statement data from different departments (for example, the first department data warehouse 300 and the second department data warehouse 400 ). Including but not limited to balance sheet, comprehensive profit and loss statement, statement of changes in shareholders' equity, cash flow statement, financial statement, business report, and profit distribution or loss making-up statement.

As shown in FIG. 2 , the judging unit 133 is configured to execute a judging program after the control unit 131 of the processor 130 receives a judging request from the electronic device 200 . The judging program is to make the judging unit 133 calculate the time difference between the submission deadline of the settlement detailed statement data and/or final settlement detailed statement data and the current time. The judging program also enables the judging unit 133 to judge the chronological order of the submission deadline and the current time. The judging program also enables the judging unit 133 to judge whether the above-mentioned time difference is smaller than the warning time interval. Accordingly, "the time difference is less than the warning time interval" or "the time difference is not less than the warning time interval" is used as the judging condition of the judging unit 133 based on the settlement detailed report data and/or final settlement detailed report data. The judging program also enables the judging unit 133 to judge whether the settlement statement sub-database 122 contains settlement detailed statement data and/or whether the final settlement statement sub-database 124 contains final settlement statement data.

As shown in FIG. 2 , the warning unit 134 sends a first warning notification to the electronic device 200 of the second user US2 based on the above settlement statement data and/or settlement statement data. For example, it is judged in the judging unit 133 that "the submission deadline is later than the current time", "the time difference is less than the warning time interval" and "the settlement statement sub-database 122 does not contain settlement detail statement data and/or final settlement statement subdata When the database 124 does not contain the final account details report data", the warning unit 134 sends a first warning notification to the electronic device 200 of the second user US2.

In some implementations, as shown in FIG. 2 , the warning unit 134 sends a second warning notification to the electronic device 200 of the second user US2 based on the above settlement statement data and/or settlement statement data. For example, when the judging unit 133 judges that "the deadline for submission is earlier than the current time" and "the settlement statement sub-database 122 does not contain settlement detailed statement data and/or the final settlement statement sub-database 124 does not contain final settlement statement data" , the warning unit 134 sends a second warning notification to the electronic device 200 of the second user US2.

In some implementations, the second user US2 may be personnel from other departments. In some embodiments, the second user US2 is from the first department and the second department and has the use authority of the first department's data warehouse 300 and the second department's data warehouse 400 .

As shown in FIG. 2 , the output unit 135 is configured to output the integrated settlement statement information 126 , the integrated final statement information 127 and the integrated monthly statement information 128 after the first user US1 sends an output request to the processor 130 through the electronic device 200 . In some implementations, the first user US1 as an operator can use the output unit 135 to perform an export operation on the consolidated settlement statement information 126 , the consolidated final settlement statement information 127 and the consolidated monthly statement information 128 . For example, the export operation is to enable the first user US1 to use the output unit 135 to convert the integrated settlement statement information 126, the integrated settlement statement information 127, and the integrated monthly statement information 128 into required file formats (for example, PDF files, ODT file or other suitable file format). In some implementations, the first user US1 as an operator can use the output unit 135 to perform a printing operation on the consolidated settlement statement information 126 , the consolidated final settlement statement information 127 and the consolidated monthly statement information 128 . For example, the first user US1 can use the output unit 135 to print the consolidated settlement statement information 126 , the consolidated settlement statement information 127 and the consolidated monthly statement information 128 on paper.

As shown in FIG. 2, the input unit 137 is configured to execute the review process. The review process is when the processor 130 displays the integrated settlement statement information 126, the integrated final statement information 127 and the integrated monthly statement information 128 on the user interface of the electronic device 200 of the third user US3, the third user US3 uses the input Unit 137 performs electronic or manual sign-off. In some implementations, the third user US3 may be executives at various levels. Specifically, after the first user US1 or the third user US3 successfully logs into the settlement and settlement report integration system 100 on the user interface of the electronic device 200, the first user US1 or the third user US3 can query the consolidated settlement Report information 126, integrated final statement information 127, and integrated monthly statement information 128, and the third user US3 can integrate the integrated settlement statement information 126, integrated final statement information 127, and integrated monthly statement information 128 for the first user US1 Execute the review procedure (for example, the third user US3 signs by means of electronic signature), so as to improve the review efficiency. In some implementations, the third user US3 can manually sign on the consolidated settlement statement information 126, consolidated final settlement statement information 127, and consolidated monthly statement information 128 of the first user US1's consolidated settlement. nuclear.

As shown in FIG. 2 , the control unit 131 is also configured to receive an update request from the electronic device 200 . After the update unit 131 of the processor 130 receives the update request from the electronic device 200, the update unit 136 controls the communication device 110 to connect to the first department data warehouse 300 and the second department data warehouse 400 through the external network NW, and updates the first department The settlement statement data and final settlement statement data in the data warehouse 300 and the second department data warehouse 400 are stored in the settlement statement sub-database 122 and the final settlement statement sub-database 124 . In some embodiments, the update unit 136 can automatically update the settlement statement data and settlement details in the settlement statement sub-database 122 and the settlement statement sub-database 124 without the control unit 131 receiving an update request from the electronic device 200 Report data.

With the aforementioned structural configuration, the users US (the first user US1 , the second user US2 and the third user US3 ) can send update requests to the processor 130 through the electronic device 200 . When the processor 130 receives an update request from the electronic device 200 via the communication device 110, the update unit 136 controls the communication device 110 to connect to the first department data warehouse 300 and the second department data warehouse 400 based on the update request, and then uploads the first department data The settlement statement data and final settlement statement data in the warehouse 300 and the second department data warehouse 400 are stored in the settlement statement sub-database 122 and the final settlement statement sub-database 124 respectively. In addition, when the processor 130 receives the integration request from the electronic device 200 via the communication device 110, the integration unit 132 generates the integration data, and the integration unit 132 executes the integration program to generate the integrated settlement statement information 126 and the integrated settlement statement information 127 And integrate monthly report information 128. The warning unit 134 sends the first warning notification and the second warning notification based on the judging procedure performed by the judging unit 133 for the consolidated settlement statement information 126, the consolidated final settlement statement information 127 and the consolidated monthly statement information 128, so as to remind the second user US2 to provide overdue Documentation not provided or incorrectly corrected. Next, the control unit 131 can output the consolidated settlement statement information 126 , the consolidated settlement statement information 127 , and the consolidated monthly statement information 128 to the user interface of the electronic device 200 for the third user US3 to execute the verification procedure.

Next, how the settlement and settlement report integration system 100 completes the update request required by the user US will be described in detail.

Step (1): Send an update request. In a usage scenario, for example, first, the first user US1 logs in on the electronic device 200 such as the settlement statement information management platform of our bank, and the user interface of the settlement statement information management platform may display several options. Main menu screen. User US can click on the options of the main menu screen on the user interface of the settlement report information management platform. For example, the main menu screen can include options such as "update data" and "send document reminder" for the first use Or US1 click. In a usage scenario, for example, if the user US clicks "Update Data", he can click the "Update Data" option to send an update request to obtain the latest settlement detail report data and final settlement detail report data. After the first user US1 clicks the option on the main menu screen on the user interface of the settlement statement information management platform, the electronic device 200 sends an update request to the processor 130, and step (1) is completed.

Step (2): Acquiring settlement detailed report data and final settlement detailed report data. In a usage scenario, after the first user US1 sends an update request through step (1), the update unit 136 of the processor 130 controls the communication device 110 to connect to the first department data warehouse 300 and the second department data warehouse 400 based on the update request , and through the processor 130 to receive the first departmental data warehouse 300 and the second departmental data warehouse 400 in several settlement detailed report data and final settlement detailed report data, the update unit 136 then updates the several settlement detailed report data and final settlement detailed report data They are respectively stored in the settlement statement sub-database 122 and the settlement statement sub-database 124 of the database 120 . By performing the above operations, step (2) is completed. For example, when several second users US2 from the first department and the second department have completed the file editing of the settlement statement data and the final settlement statement data and stored the files in the first department data warehouse 300 and the second department respectively. In the departmental data warehouse 400 , the update unit 136 can automatically retrieve these files into the settlement statement sub-database 122 and the settlement statement sub-database 124 .

In some implementation manners, the system 100 for integrating settlement and settlement statements can automatically update the detailed settlement statement information and the detailed settlement statement information. For example, the user US can set the settlement and settlement statement integration system 100 to automatically obtain the latest settlement statement data and final settlement statement information every year. Or, the first user US1 can set the update unit 136 to be automatically connected to the first department data warehouse 300 and the second department data warehouse 400 every half a year (or with a more frequent frequency). frequency) to obtain the latest detailed settlement report data and final settlement detailed report data from the first department data warehouse 300 and the second department data warehouse 400 . The above is just an example for simple description, and the present disclosure does not intend to limit the above-mentioned method and means for setting automatic update and the frequency of data update.

Next, how the settlement report integration system 100 completes the integration request required by the first user US1 will be described in detail.

Step (1): The electronic device 200 sends an integration request. In a usage scenario, for example, after the first user US1 logs into the settlement statement information management platform on the electronic device 200, the user interface of the settlement statement information management platform will first display the above-mentioned main menu containing several options. The menu screen displays options such as "integrate data" on the user interface for the first user US1 to click on. In a usage scenario, for example, if the first user US1 clicks "Integrate Data", he can click the "Integrate Data" option to send an integration request to obtain integrated settlement statement information 126, integrated settlement statement information 127, and Integrate monthly report information 128. After the first user US1 clicks the option on the main menu screen on the user interface of the settlement statement information management platform, the electronic device 200 sends an integration request to the processor 130, and step (1) is completed. How the integration unit 132 generates the integrated settlement statement information 126 , the integrated settlement statement information 127 , and the integrated monthly statement information 128 during the integration process will be described in detail in the description of step (1) below.

In some implementations, after the first user US1 sends an integration request from the electronic device 200, the control unit 131 controls the integration unit 132 to transfer the detailed settlement statement data in the settlement statement sub-database 122 and the settlement statement sub-database 124 The details of final accounts report are integrated into consolidated data. Specifically, the integration unit 132 can extract the detailed settlement report data and the data contained in the detailed settlement report data according to different requirements and integrate them into integrated settlement statement information 126 , integrated final settlement statement information 127 , and integrated monthly statement information 128 . In a usage scenario, the first user US1 can click "Generate Settlement Statement" on the main menu, and further select "Balance Sheet", "Comprehensive Profit and Loss Statement", "Statement of Changes in Shareholders' Equity", "Cash Flow Tables" and "Financial Statements" to generate consolidated statement information 126 that is consolidated and presented in tabular form. In a usage scenario, the first user US1 can click "Generate Final Statement" on the main menu, and further check "Business Report", "Financial Statement" and "Profit Distribution or Loss Appropriation Statement" to Generate consolidated financial statement information 127 that is presented in a tabular form. In a usage scenario, the first user US1 can click "Generate Monthly Statement" on the main menu, and further select "Balance Sheet", "Comprehensive Profit and Loss Statement", "Statement of Changes in Shareholders' Equity", "Cash "Flow Statement", "Financial Statement", "Business Report" or "Profit Distribution or Loss Appropriation Statement", and then check "Classification by Month" as the filter condition to generate an integrated table format and monthly Presented integrated monthly report information 128 .

In some implementation manners, the first user US1 can arrange the order of the pages of the checked report types by themselves.

In some embodiments, the integration unit 132 can automatically integrate the settlement statement data and settlement details in the settlement statement sub-database 122 and the settlement statement sub-database 124 without the control unit 131 receiving the integration request from the electronic device 200 report data to generate integrated settlement statement information 126 , integrated settlement statement information 127 and integrated monthly statement information 128 .

In some implementations, the consolidated settlement statement information 126 and the consolidated monthly statement information 128 may be presented to the third user US3. As the third user US3, executives at all levels can understand the operation status of each department of the bank and various financial and account information by integrating the settlement statement information 126 and the integrated monthly statement information 128, and can use it according to This proposes management solutions that can be improved for each department of the Bank.

In some implementations, the above-mentioned detailed settlement report information includes but is not limited to cash and equivalent cash, deposits with the central bank and interbank lending, assets measured through fair value of profit and loss, financial assets of FVOCI, debt instrument investment of AC, and promissory notes Bond and bond investment, net receivables, central bank and interbank deposits, central bank and interbank financing, liabilities measured at fair value through profit and loss, bonds and bond liabilities attached to repossessions, accounts payable, current income tax liabilities, and for-sale Liabilities directly related to assets, deposits and remittances, current income tax assets, assets to be sold, net discounts and loans, net investments using the equity method, net other financial assets, net real estate and equipment, financial bonds payable, special shares Liabilities, other financial liabilities, provision for liabilities/lease provision, deferred tax liabilities, other liabilities, transactions and exchanges, investment properties, net intangible assets, deferred tax assets, net other assets, equity, retained earnings or other possible parameters.

For example, the submission deadline can be customized by the first user US1.

Step (2): The judging unit 133 executes the judging program. The following will specifically illustrate how the judging unit 133 determines whether to control the warning unit 134 to issue the first warning notification and the second warning notification by executing the judging program.

First, the judging program causes the judging unit 133 to calculate the time difference between the submission deadline of the settlement statement data and/or the final settlement statement data and the current time. Specifically, the submission deadline refers to the deadline within which the second user US2 must upload the file. The current time refers to the current time when the first user US1, the second user US2 or the third user US3 is using the settlement report integration system 100, and the current time includes the year, month, day, hour, minute and second wait time unit. The time delta is the length of time obtained by subtracting the submission deadline from the current time. For example, if there is a document containing detailed settlement statement information and/or final settlement statement information that is not stored in the database 120, and the reporting time of the relevant statistical statement is November 15, 2022, the submission deadline can be determined according to the settlement statement. The default setting of the settlement statement integration system 100 is, for example, November 01, 2022 (that is, 14 days before the declaration time), and the current time is October 27, 2022. Accordingly, the judging unit 133 can calculate that the time difference is 5 days.

Next, the judging program enables the judging unit 133 to judge the chronological order of the settlement detailed statement data and/or the final settlement detailed statement data submission deadline and the current time. Specifically, the above chronological order refers to the time point of the submission deadline before and after the current time point, in other words, it is judged that "the time point of the submission deadline is earlier than the time point of the current time" or "the time point of the submission deadline A point in time later than the current time". For example, there is a document containing settlement statement data and/or final settlement statement data not stored in the database 120, the submission deadline is, for example, November 01, 2022, and the current time is October 27, 2022 . Accordingly, the judging unit 133 can judge that the time point of the submission deadline is later than the current time point.

Next, the judging program enables the judging unit 133 to judge whether the time difference is smaller than the warning time interval. Specifically, the above-mentioned warning time interval refers to the time length parameter set by the second user US2 and the third user US3 in the settlement report integration system 100 , and the above-mentioned time length parameter is used as a trigger condition for the function of the warning unit 134 . For example, there is a document containing settlement statement data and/or final settlement statement data not stored in the database 120, the submission deadline is, for example, November 01, 2022, and the current time is October 27, 2022 . Based on this, the judging unit 133 calculates that the time difference is 5 days. The warning time interval set by the first user US1 in the settlement statement integration system 100 is 7 days. Accordingly, the judging unit 133 can judge that the time difference is smaller than the warning time interval.

Through the above operations, the judging unit 133 can determine whether to control the warning unit 134 to issue the first warning notification and the second warning notification by executing the judging program.

Step (3): The warning unit 134 issues a first warning notification and a second warning notification based on the determination procedure of the determination unit 133 . In detail, the warning unit 134 can send the first warning notification and the second warning notification based on the detailed settlement statement data and/or the detailed settlement statement data. The purpose of sending the first warning notification or the second warning notification is to allow the second user US2 to grasp every urgent to-do item. For other department personnel as the second user US2, they can know which to-do items have urgent timeliness by receiving the first warning notification or the second warning notification, and the warning notification can also affect the mental state of other department personnel. Generate appropriate incentives to facilitate other departments to prioritize time-sensitive to-do items.

The following will specifically illustrate how the warning unit 134 sends the first warning notification and the second warning notification based on the detailed settlement report data and/or the final settlement detailed report data.

Specifically, the above-mentioned warning notification refers to a notification message generated by the warning unit 134 . For example, if there is a document containing detailed settlement statement information and/or final settlement statement information that is not stored in the database 120, and the reporting time of the relevant statistical statement is November 15, 2022, the submission deadline can be determined according to the settlement statement. The default setting of the settlement statement integration system 100 is, for example, November 01, 2022 (that is, 14 days before the declaration time), and the current time is October 27, 2022. Based on this, the judging unit 133 calculates that the time difference is 5 days. The warning time interval set by the second user US2 and the third user US3 in the settlement statement integration system 100 is 7 days. Accordingly, the judging unit 133 can judge that "the submission deadline is later than the current time" and "the time difference is smaller than the warning time interval". When the judging unit 133 judges that "the submission deadline is later than the current time" and "the time difference is less than the warning time interval", the warning unit 134 can display a notification message (for example, the words "official deadline is coming") to the second user On the user interface of the electronic device 200 of US2, the function of alerting the second user US2 can be achieved.

The following will describe how the output unit 135 outputs the integrated data and how the input unit 137 enables the third user US3 to execute the verification procedure after the settlement statement integration system 100 completes the integration request.

Step (A): The output unit 135 outputs the integrated data.

In this embodiment, after the settlement and settlement report integration system 100 completes the integration request, and the first user US1 sends an output request to the processor 130 through the electronic device 200, the integrated settlement statement information 126, the consolidated settlement statement The information 127 and the integrated monthly report information 128 are exported, or the integrated settlement report information 126 , the integrated final statement information 127 and the integrated monthly report information 128 are printed as paper. Since the specific implementation manner of outputting the integrated data by the output unit 135 is described in detail above, it will not be repeated here.

Step (B): The input unit 137 is used for the third user US3 to execute the verification procedure.

Specifically, after the output unit 135 outputs the integrated data, the control unit 131 displays the integrated data on the user interface of the electronic device 200 of the third user US3 for the third user US3 to execute the verification procedure. For example, as the third user US3, executives at various levels can click the "electronic signature" option in the user interface, and the user interface can display integrated data in the form of a table, for example. For example, the user interface can display the consolidated settlement statement information 126, consolidated final settlement statement information 127, and consolidated monthly statement information 128 of the first user US1 who has completed the consolidated settlement. As the third user US3, managers at various levels can Input the electronic signature in the user interface to complete the verification process. However, the present disclosure is not intended to limit the means and methods for the above-mentioned third user US3 to complete the verification procedure.

Thereby, through the above operations, the control unit 131 can output the integrated data to the electronic device 200 for the third user US3 to execute the verification procedure to complete the step (A) and the step (B).

In some implementations, the electronic device 200 may be a desktop computer, a notebook computer, a smart phone, or a tablet computer. The present disclosure is not intended to limit the types of the electronic device 200 .

In some embodiments, the above-mentioned competent authority is the Banking Bureau of the Financial Supervisory Commission, but this disclosure is not limited thereto.

In some embodiments, the external network NW may include computers such as local area network (LAN), wireless area network (WLAN), wide area network (WAN), campus area network (CAN) or virtual private network (VPN). Network type, and mobile phone network types such as 3G, LTE (Long Term Evolution), 4G, or 5G. In other words, the present disclosure does not intend to limit the type of the external network NW (ie, the way the settlement statement integration system 100 is connected to the external network NW).

Through the above steps, the first user US1 (or the second user US2 and the third user US3) can complete the update request, integration request, judgment request and output required by the user US through the settlement report integration system 100 Request to obtain integrated settlement report information 126 , integrated final statement information 127 and integrated monthly report information 128 . In addition, as the third user US3, supervisors at various levels can supervise the second user US2 in advance and review the integrated accounting documents of the first user US1, so as to achieve the purpose of overall production efficiency.

From the above detailed description of the specific implementation of this disclosure, it can be clearly seen that in the settlement statement integration system disclosed in this disclosure, since the data warehouses of different departments can be connected through communication devices, a large number of settlement statement reports can be introduced Data and financial statement data to implement the integration process. In the settlement statement integration system disclosed in this disclosure, since the integration unit can be used to compile reports according to different requirements, the time schedule for the integration of settlement and settlement statements is simplified. In the settlement statement integration system disclosed in this disclosure, the judging unit judges whether the database contains the documents submitted by the second user, the chronological order of the submission deadline and the current time, and whether the time difference between the two is based on the integrated data. If it is less than the warning time interval, the warning unit will issue a warning notice to remind the second user to provide the documents, so that the declaration of the report required by the competent authority can be handled within the time limit. In the settlement report integration system disclosed in this disclosure, since the output unit can export different reports into different file formats for third-party users to read, the effect of reducing the storage cost of entity reports can be achieved. In the settlement statement integration system disclosed in this disclosure, since the input unit can be used by a third user to execute the review process, and the review process can be in the form of electronic signature, it is beneficial to improve the review efficiency and enhance the efficiency of account statement inquiry.

Although the present disclosure has been disclosed above in terms of implementation, it is not intended to limit this disclosure. Any person skilled in the art may make various changes and modifications without departing from the spirit and scope of this disclosure. Therefore, the protection of this disclosure The scope shall be defined by the scope of the appended patent application.

100: Settlement and settlement report integration system 110: Communication device 120: database 122: Settlement report sub-database 124: Sub-database of final accounts report 126:Integrated settlement statement information 127:Integrate final statement information 128:Integrate monthly report information 130: Processor 131: Control unit 132: Integration unit 133: judgment unit 134: warning unit 135: output unit 136: update unit 137: input unit 200: electronic device 300: The first sector data storage 400:Second sector data storage US: user US1: first user US2: Second user US3: third user NW: Extranet

In order to make the above and other purposes, features, advantages and embodiments of the present disclosure more comprehensible, the accompanying drawings are described as follows: FIG. 1 shows a functional block diagram of a settlement statement integration system according to an embodiment of the present disclosure. FIG. 2 shows a detailed functional block diagram of the settlement statement integration system according to an embodiment of the present disclosure.

100: Settlement and settlement report integration system

110: Communication device

120: database

122: Settlement report sub-database

124: Sub-database of final accounts report

126:Integrated settlement statement information

127: Integrate final statement information

128:Integrate monthly report information

130: Processor

131: Control unit

132: Integration unit

133: judgment unit

134: warning unit

135: output unit

136: update unit

137: input unit

200: electronic device

300: The first sector data storage

400:Second sector data storage

US1: first user

US2: Second user

US3: third user

NW: Extranet

Claims (10)

A settlement statement integration system, comprising: a communication device configured to connect to a first department data warehouse and a second department data warehouse through an external network, and configured to connect to an electronic device of a user; a data library, connected to the communication device, and includes a settlement statement sub-database and a settlement statement sub-database; and a processor, connected to the communication device and the database, and configured to: accept an integration request from the electronic device and executing an integration program based on the integration request, wherein the integration program causes the processor to generate an integrated settlement statement information, an integrated final settlement statement information, and an integrated month based on the settlement statement sub-database and the final settlement statement sub-database Report information. The settlement statement integration system as described in claim 1, wherein the processor further includes an update unit configured to: receive one of the electronic devices from a first user at a control unit of the processor After the update request, control the communication device to connect to the first departmental data warehouse and the second departmental data warehouse through the external network, and transfer the settlement details report data in the first departmental data warehouse and the second departmental data warehouse and a final statement detail statement data are stored in the settlement statement sub-database and the final settlement statement sub-database respectively. The settlement statement integration system as described in claim item 2, wherein the processor further includes an integration unit configured to: combine the settlement detail statement data in the settlement statement sub-database with the final settlement statement sub-database The detailed report information of the final accounts is integrated into the information of the consolidated settlement report, the information of the consolidated final report and the information of the consolidated monthly report. The settlement statement integration system as described in claim 3, wherein the processor further includes a judging unit configured to: after the processor receives a judging request from the electronic device of the first user, Execute a judgment procedure. The settlement statement integration system as described in claim item 4, wherein the judging unit is configured to: determine whether the settlement statement sub-database contains or does not contain the settlement detail statement data and/or the final settlement statement sub-database contains or does not contain the Detailed statement data of final accounts; calculation of the time difference between the submission deadline of the detailed statement data and/or the detailed statement data of final accounts and a current time; judging the chronological order of the submission deadline and the current time; and judging Whether the time difference is less than a warning time interval. The settlement statement integration system as described in claim 5, wherein the processor further includes a warning unit configured to: judge in the judging unit that the submission deadline is later than the current time, and that the time difference is less than the warning time interval and the settlement statement sub-database does not contain the settlement statement data and/or the settlement statement sub-database does not contain the settlement statement data, send a first warning notification to the electronic device of a second user and when the judging unit judges that the submission deadline is earlier than the current time and the settlement statement sub-database does not contain the settlement detailed statement data and/or the final settlement statement sub-database does not contain the final settlement statement data, send a first Two warning notifications are sent to the electronic device of the second user. The settlement statement integration system as described in claim item 6, wherein the electronic device of the second user uses the communication device to store the settlement detail report data in the first department data warehouse and the second department data warehouse and the The settlement report details report data is sent to the settlement report sub-database and the final settlement report sub-database. The settlement report integration system as described in Claim 1, wherein the processor further includes an output unit configured to: send an output request to the electronic device when a first user sends it there After the processor, output the integrated settlement statement information, the integrated final settlement statement information and the integrated monthly statement information. The settlement and settlement statement integration system described in claim 8, wherein outputting the consolidated settlement statement information, the consolidated settlement statement information and the consolidated monthly statement information includes an export operation and a print operation. The settlement statement integration system as described in Claim 1, wherein the processor further includes an input unit configured to execute a review program, the review process comprising: displaying the consolidated settlement report information on the processor . When the integrated final statement information and the integrated monthly statement information are on a user interface of the electronic device of a third user, the third user uses the input unit to perform an electronic signature or a manual signature.

Images