Report generation method, report generation device, electronic device, and storage medium

Abstract

The present disclosure relates to a report generation method, a report generation device, an electronic device and a storage medium. The method comprises: obtaining report configuration information associated with a specified report type; wherein the report configuration information comprises report layout and index configuration information of at least one report index item; obtaining business data associated with each report index item based on the index configuration information of each report index item; determining the index value of each report index item based on the business data associated with each report index item; and generating a target report adapted to the specified report type based on the index value of each report index item and the report layout. The present disclosure can be flexibly configured directly through the system function of the financial reporting system, realize automatic data extraction from the upstream system, and generate a target report. In this way, the report generation efficiency is improved, and the accuracy and compliance of the data are ensured.

Description

Technical Field

[0001] This disclosure relates to the field of report technology, and in particular to report generation methods, report generation devices, electronic devices, and storage media. Background Technology

[0002] Bank financial reporting aims to provide comprehensive and transparent information to the outside world, helping stakeholders understand their financial position, operating results, cash flows, and risk exposure. Domestic and foreign banking institutions must issue financial statements in accordance with local accounting standards and external regulatory requirements, following prescribed reporting formats and items. Because the presentation styles and data definitions of these statements vary significantly among different institutions and are frequently updated, banks need to be flexible. However, the current efficiency of statement generation is low, which increases the workload of banks and affects the accuracy and compliance of the reports. Summary of the Invention

[0003] This disclosure provides a report generation method, a report generation apparatus, an electronic device, and a storage medium to at least partially solve one of the technical problems in the related art. The technical solution of this disclosure is as follows:

[0004] According to a first aspect of the present disclosure, a report generation method is provided, comprising:

[0005] Obtain report configuration information associated with a specified report type; wherein, the report configuration information includes a report template and indicator configuration information for at least one report indicator item;

[0006] Based on the indicator configuration information of each of the report indicator items, obtain the business data associated with each of the report indicator items;

[0007] Based on the business data associated with each of the aforementioned report indicator items, determine the indicator value of each of the aforementioned report indicator items;

[0008] Based on the indicator values ​​of each of the aforementioned report indicators and the report template, a target report adapted to the specified report type is generated.

[0009] According to a second aspect of the present disclosure, a report generation apparatus is provided, comprising:

[0010] The first acquisition module is used to acquire report configuration information associated with a specified report type; wherein, the report configuration information includes a report template and indicator configuration information for at least one report indicator item;

[0011] The second acquisition module is used to acquire business data associated with each of the report indicator items based on the indicator configuration information of each of the report indicator items;

[0012] The determination module is used to determine the indicator value of each of the report indicator items based on the business data associated with each of the report indicator items;

[0013] The generation module is used to generate a target report that is compatible with the specified report type based on the indicator values ​​of each of the report indicator items and the report template.

[0014] According to a third aspect of the present disclosure, an electronic device is provided, comprising: a processor; and a memory for storing processor-executable instructions; wherein the processor is configured to execute the instructions to implement the report generation method as described in the above embodiments of the present disclosure.

[0015] According to a fourth aspect of the present disclosure, a computer-readable storage medium is provided that, when instructions in the computer-readable storage medium are executed by a processor of an electronic device, enables the electronic device to perform the report generation method as described in the above embodiments of the present disclosure.

[0016] According to a fifth aspect of the present disclosure, a computer program product is provided, comprising: a computer program that, when executed by a processor, implements the report generation method as described in the above embodiments of the present disclosure.

[0017] The technical solutions provided by the embodiments of this disclosure have at least the following beneficial effects:

[0018] In this disclosure, report configuration information associated with a specified report type is first obtained. This report configuration information includes a report template and indicator configuration information for at least one report indicator item. Then, based on the indicator configuration information for each report indicator item, business data associated with each report indicator item is obtained. Based on this business data, the indicator value for each report indicator item is determined. Finally, based on the indicator values ​​of each report indicator item and the report template, a target report adapted to the specified report type is generated. Therefore, this disclosure directly utilizes the system functions of the financial reporting system for flexible configuration, automatically retrieving data from upstream systems and generating target reports. This not only improves report generation efficiency but also ensures data accuracy and compliance.

[0019] It should be understood that the above general description and the following detailed description are exemplary and explanatory only, and are not intended to limit this disclosure. Attached Figure Description

[0020] The accompanying drawings, which are incorporated in and form part of this specification, illustrate embodiments consistent with this disclosure and, together with the description, serve to explain the principles of this disclosure, and are not intended to unduly limit this disclosure.

[0021] Figure 1 This is a flowchart illustrating the report generation method shown in the first embodiment of this disclosure;

[0022] Figure 2 This is a flowchart illustrating the index value determination method shown in the second embodiment of this disclosure;

[0023] Figure 3 This is a flowchart illustrating the business data acquisition method shown in the third embodiment of this disclosure;

[0024] Figure 4 This is a schematic diagram of the process for updating index values ​​as shown in the fourth embodiment of this disclosure;

[0025] Figure 5 This is a schematic diagram of the process for generating a target report that is compatible with a specified report type, as shown in the fifth embodiment of this disclosure;

[0026] Figure 6 This is a schematic diagram of the process of updating the initial report to obtain the target report as shown in the sixth embodiment of this disclosure;

[0027] Figure 7 This is a schematic diagram of the report generation device shown in the seventh embodiment of this disclosure.

[0028] Figure 8 This is a schematic diagram of the structure of an electronic device shown in an exemplary embodiment of the present disclosure. Detailed Implementation

[0029] To enable those skilled in the art to better understand the technical solutions of this disclosure, the technical solutions in the embodiments of this disclosure will be clearly and completely described below with reference to the accompanying drawings.

[0030] It should be noted that the terms "first," "second," etc., used in the specification, claims, and accompanying drawings of this disclosure are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate so that the embodiments of this disclosure described herein can be implemented in orders other than those illustrated or described herein. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with this disclosure. Rather, they are merely examples of apparatuses and methods consistent with some aspects of this disclosure as detailed in the appended claims.

[0031] It should be noted that the acquisition, storage, use, and processing of data in this disclosed technical solution comply with the provisions of relevant laws and regulations and do not violate public order and good morals.

[0032] It should also be noted that the information (including but not limited to user device information, user personal information, etc.), data (including but not limited to data used for analysis, data stored, data displayed, etc.) and signals involved in this disclosure are all authorized by the user or fully authorized by all parties, and the collection, use and processing of related data must comply with relevant laws, regulations and standards.

[0033] It should also be noted that in the embodiments disclosed herein, certain software, components, models and other existing solutions in the industry may be mentioned. These should be considered as exemplary and are intended only to illustrate the feasibility of implementing the technical solutions disclosed herein. However, they do not mean that the applicant has used or necessarily used such solutions.

[0034] The report generation method, report generation apparatus, electronic device, and storage medium of this disclosure are described below with reference to the accompanying drawings.

[0035] Figure 1 This is a flowchart illustrating the report generation method shown in the first embodiment of this disclosure.

[0036] This disclosure illustrates the example of the report generation method being configured in a report generation device. The report generation device can be applied to any electronic device equipped with a financial reporting system, which can perform report generation functions.

[0037] Among them, electronic devices can be any device with computing capabilities, such as personal computers, mobile terminals, servers (or cloud computing), etc. Mobile terminals can be hardware devices with various operating systems, touch screens and / or displays, such as in-vehicle devices, mobile phones, tablets, personal digital assistants, wearable devices, etc.

[0038] like Figure 1 As shown, the report generation method of this disclosure embodiment may include the following steps S1-S3.

[0039] In step S1, report configuration information associated with a specified report type is obtained; wherein, the report configuration information includes a report template and indicator configuration information for at least one report indicator item.

[0040] In the financial reporting system, administrators pre-configure different types of reports, such as balance sheets, income statements, and cash flow statements. Each report's configuration information includes a report template and configuration information for at least one report indicator. When a user selects to generate a report, the system retrieves the report configuration information associated with that report type from the configuration library. It then defines the report's format and layout, including the header (such as title, period, and unit) and body (such as total assets, total liabilities, and total owner's equity), as well as defining the name, calculation formula, data source, and data range for each report indicator.

[0041] Example:

[0042] Report type: Balance sheet

[0043] Report configuration information:

[0044] Report format: including header and body

[0045] Header:

[0046] Title: Balance Sheet

[0047] Date: December 31, 2023

[0048] Unit: RMB Yuan

[0049] Table body:

[0050] Total assets

[0051] Total Liabilities

[0052] Total equity

[0053] Indicator configuration information for report indicators:

[0054] Total assets:

[0055] Indicator Number: 1001

[0056] Data source: General Ledger System

[0057] Data retrieval scope: All asset accounts (such as 1001-Cash, 1002-Accounts Receivable, etc.)

[0058] Total liabilities:

[0059] Indicator Number: 1002

[0060] Data source: General Ledger System

[0061] Data range: All liability items (such as 2001-Accounts Payable, 2002-Short-term Loans, etc.)

[0062] Total equity:

[0063] Indicator Number: 1003

[0064] Data source: General Ledger System

[0065] Data Scope: All equity accounts (such as 3001-Paid-in Capital, 3002-Retained Earnings, etc.)

[0066] In step S2, business data associated with each report indicator item is obtained based on the indicator configuration information of each report indicator item.

[0067] Based on the indicator configuration information of each report indicator, determine the data retrieval rules (including the range of data retrieval accounts and other additional conditions), and obtain the business data associated with each report indicator from the general ledger system or other upstream systems.

[0068] Example:

[0069] Assuming the user selects to generate a balance sheet, the system has already retrieved the balance sheet's report configuration information from the configuration library. Next, the system will retrieve the business data associated with each report indicator based on its configuration information.

[0070] Balance Sheet

[0071] Determine the rules for selecting numbers:

[0072] Total assets:

[0073] Data retrieval scope: All asset accounts (such as 1001-Cash, 1002-Accounts Receivable, etc.)

[0074] Additional condition: Data retrieval time is December 31, 2023.

[0075] Total liabilities:

[0076] Data range: All liability items (such as 2001-Accounts Payable, 2002-Short-term Loans, etc.)

[0077] Additional condition: Data retrieval time is December 31, 2023.

[0078] Total equity:

[0079] Data Scope: All equity accounts (such as 3001-Paid-in Capital, 3002-Retained Earnings, etc.)

[0080] Additional condition: Data retrieval time is December 31, 2023.

[0081] Data Acquisition:

[0082] Total assets:

[0083] The ending balance of cash withdrawal (1001) from the general ledger system is RMB 1,000,000.

[0084] The ending balance of accounts receivable (1002) extracted from the general ledger system is RMB 2,000,000.

[0085] Extract the ending balances of other asset accounts from the general ledger system.

[0086] Total liabilities:

[0087] The ending balance of accounts payable (2001) extracted from the general ledger system is RMB 1,500,000.

[0088] The ending balance of short-term loans (2002) withdrawn from the general ledger system is RMB 1,000,000.

[0089] Extract the ending balances of other liability accounts from the general ledger system.

[0090] Total equity:

[0091] The ending balance of paid-in capital (3001) extracted from the general ledger system is RMB 1,200,000.

[0092] The ending balance of retained earnings (3002) extracted from the general ledger system is RMB 800,000.

[0093] Extract the ending balances of other owner's equity accounts from the general ledger system.

[0094] In step S3, the indicator value of each report indicator is determined based on the business data associated with each report indicator item.

[0095] Based on predefined data processing rules, the acquired business data is processed to calculate the value of each report indicator item; the calculation method can use SQL statements or other data processing tools.

[0096] Example:

[0097] Assuming the user selects to generate a balance sheet, the system has already retrieved the business data associated with each report indicator from the general ledger system. Next, the system will use this business data to calculate the indicator value for each report indicator.

[0098] Data processing:

[0099] Total assets:

[0100] Business data extracted from the general ledger system:

[0101] The ending balance of cash (1001) was RMB 1,000,000.

[0102] The ending balance of accounts receivable (1002) was RMB 2,000,000.

[0103] The closing balance of other asset accounts was RMB 3,000,000.

[0104] Calculation method (using SQL statements):

[0105] SELECT SUM(amount)AS total_assets

[0106] FROM ledger

[0107] WHERE account_code IN('1001','1002',...)AND period='20231231';

[0108] Calculation result: Total assets: 1,000,000 + 2,000,000 + 3,000,000 = 6,000,000 yuan

[0109] Total liabilities:

[0110] Business data extracted from the general ledger system:

[0111] The ending balance of accounts payable (2001) was RMB 1,500,000.

[0112] The ending balance of short-term borrowings (2002) was RMB 1,000,000.

[0113] The ending balance of other liability items was RMB 1,500,000.

[0114] Calculation method:

[0115] SELECT SUM(amount)AS total_liabilities

[0116] FROM ledger

[0117] WHERE account_code IN('2001','2002',...)AND period='20231231';

[0118] Calculation result: Total liabilities = 1,500,000 + 1,000,000 + 1,500,000 = 4,000,000 yuan

[0119] Total equity:

[0120] Business data extracted from the general ledger system:

[0121] The ending balance of paid-in capital (3001) was RMB 1,200,000.

[0122] The ending balance of retained earnings (3002) was RMB 800,000.

[0123] The closing balance of other equity accounts was RMB 1,000,000.

[0124] Calculation method:

[0125] SELECT SUM(amount)AS total_equity

[0126] FROM ledger

[0127] WHERE account_code IN('3001','3002',...)AND period='20231231';

[0128] Calculation result: Total owners' equity = 1,200,000 + 800,000 + 1,000,000 = 3,000,000 yuan

[0129] By executing step S3, the system can accurately calculate the indicator value of each report indicator based on the business data associated with each report indicator, which provides accurate data support for subsequent report generation.

[0130] In step S4, a target report adapted to the specified report type is generated based on the indicator values ​​of each report indicator item and the report template.

[0131] After calculating the indicator values ​​for each report indicator item in step S3, the indicator values ​​are filled into the report template to generate initial report data. Based on the initial report data, the final target report is generated.

[0132] Example:

[0133] Assuming the user selects to generate a balance sheet, the system has already calculated the values ​​for each report indicator. Next, the system will generate the final target report based on these indicator values ​​and the report template.

[0134] Data population:

[0135] Total assets: 6,000,000 yuan

[0136] Total liabilities: 4,000,000 yuan

[0137] Total equity: RMB 3,000,000

[0138] Fill these indicator values ​​into the report template to generate the initial report data:

[0139] Title: Balance Sheet

[0140] Date: December 31, 2023

[0141] Unit: RMB Yuan

[0142] Total assets:

[1001]

[0143] Total liabilities:

[1002]

[0144] Total owners' equity:

[1003]

[0145] Initial report data after filling:

[0146] Title: Balance Sheet

[0147] Date: December 31, 2023

[0148] Unit: RMB Yuan

[0149] Total assets: 6,000,000

[0150] Total liabilities: 4,000,000

[0151] Total equity: 3,000,000

[0152] The final balance sheet generated:

[0153] Title: Balance Sheet

[0154] Date: December 31, 2023

[0155] Unit: RMB Yuan

[0156] Total assets: 6,000,000

[0157] Total liabilities: 4,000,000

[0158] Total equity: 3,000,000

[0159] In this disclosure, at the end of each accounting period, the financial reporting system retrieves business data from upstream systems based on pre-configured report templates and indicator items. After data cleaning, transformation, and aggregation, the system generates the required indicator values ​​and then populates these values ​​into the report templates, automatically generating financial statements. Through this process, the system can efficiently generate accurate target reports to meet the needs of different organizations. This not only improves report generation efficiency but also ensures data accuracy and compliance.

[0160] Figure 2 This is a flowchart illustrating the index value determination method shown in the second embodiment of this disclosure.

[0161] In this disclosure, the report indicators are categorized into basic indicators and derived indicators. Basic indicators are those calculated directly from business data; derived indicators are those calculated based on basic indicators and / or other derived indicators.

[0162] like Figure 2 As shown, this embodiment of the disclosure determines the indicator value of each report indicator based on business data associated with each report indicator, including:

[0163] S21. For any basic indicator item, determine the indicator value of any basic indicator item based on the business data associated with the basic indicator item and the processing caliber of the basic indicator item.

[0164] S22, for any derived indicator item, determine the associated indicator items related to any derived indicator item; wherein, the associated indicator items include basic indicator items and / or derived indicator items;

[0165] S23. Determine the value of any derived indicator based on the value of the associated indicator and the processing caliber of any derived indicator.

[0166] Assuming the user selects to generate a profit and loss statement, the system needs to determine the values ​​of the basic and derived indicator items in the profit and loss statement.

[0167] Report type: Profit and loss statement

[0168] Report configuration information:

[0169] Report template:

[0170] Header:

[0171] Title: Profit and Loss Statement

[0172] Date: December 31, 2023

[0173] Unit: RMB Yuan

[0174] Table body:

[0175] Operating revenue

[0176] Operating costs

[0177] Operating profit

[0178] Net profit

[0179] Indicator configuration information for report indicators:

[0180] Operating revenue:

[0181] Indicator Number: 2001

[0182] Data source: General Ledger System

[0183] Data range: All revenue categories (such as 4001-Main Business Revenue, 4002-Other Business Revenue, etc.)

[0184] Operating costs:

[0185] Indicator Number: 2002

[0186] Data source: General Ledger System

[0187] Data range: All cost categories (such as 5001 - Cost of Main Business Operations, 5002 - Other Business Costs, etc.)

[0188] Operating profit:

[0189] Indicator Number: 2003

[0190] Related indicators: Operating revenue, Operating costs

[0191] Processing method: Operating profit = Operating revenue - Operating cost

[0192] Net profit:

[0193] Indicator Number: 2004

[0194] Related indicators: operating profit, operating expenses, taxes

[0195] Processing method: Net profit = Operating profit - Operating expenses - Taxes

[0196] Based on this, the indicator values ​​of the basic indicator items and the indicator values ​​of the derived indicator items are calculated.

[0197] The process of determining the indicator values ​​of the basic indicator items in step S21 is as follows:

[0198] Operating revenue:

[0199] Business data:

[0200] The main business revenue (4001) amounted to 5,000,000 yuan.

[0201] Other operating income (4002) amounted to RMB 1,000,000.

[0202] Calculation method: SQL statement

[0203] Calculation result: Operating revenue = 5,000,000 + 1,000,000 = 6,000,000 yuan

[0204] Operating costs:

[0205] Business data:

[0206] The cost of main business (5001) is 3,000,000 yuan.

[0207] Other operating costs (5002) amount to RMB 1,000,000.

[0208] Calculation method: SQL statement

[0209] Calculation result: Operating cost = 3,000,000 + 1,000,000 = 4,000,000 yuan

[0210] Step S22, determining the associated indicator items of the derived indicator items, is as follows:

[0211] Operating profit:

[0212] Related indicators: Operating revenue, Operating costs

[0213] Net profit:

[0214] Related indicators: operating profit, operating expenses, taxes

[0215] The process of determining the indicator value of the derived indicator item in step S23 is as follows:

[0216] Operating profit:

[0217] The values ​​of related indicator items:

[0218] Operating revenue: 6,000,000 yuan

[0219] Operating costs: 4,000,000 yuan

[0220] Calculation method: SQL statement

[0221] Calculation result: Operating profit = 6,000,000 - 4,000,000 = 2,000,000 yuan

[0222] Net profit:

[0223] The values ​​of related indicator items:

[0224] Operating profit: 2,000,000 yuan

[0225] Operating expenses: 500,000 yuan

[0226] Taxes and fees: 300,000 yuan

[0227] Calculation method: SQL statement

[0228] Calculation result: Net profit = 2,000,000 - 500,000 - 300,000 = 1,200,000 yuan

[0229] Through the above steps, the system can accurately determine the indicator values ​​of basic and derived indicator items based on the business data and processing standards associated with each report indicator item, which provides accurate data support for subsequent report generation.

[0230] Figure 3 This is a flowchart illustrating the business data acquisition method shown in the third embodiment of this disclosure.

[0231] In this disclosure, the indicator configuration information includes the data source, data retrieval method, and data retrieval frequency for the report indicator items.

[0232] like Figure 3 As shown, this disclosure obtains business data associated with each report indicator item based on the indicator configuration information of each report indicator item, including:

[0233] In step S31, for any report indicator item, a target business system that matches the data source of any report indicator item is determined from multiple business systems.

[0234] In step S32, based on the data retrieval method and frequency of any report indicator, business data associated with any report indicator is obtained from the target business system.

[0235] For example

[0236] Statement Template: Profit and Loss Statement

[0237] Report metrics and their configuration information:

[0238] Operating revenue:

[0239] Indicator Number: 2001

[0240] Data source: General Ledger System

[0241] Data retrieval method: SQL query

[0242] Data collection frequency: end of each month

[0243] Operating costs:

[0244] Indicator Number: 2002

[0245] Data source: Cost management system

[0246] Data retrieval method: API interface

[0247] Data collection frequency: end of each quarter

[0248] Operating expenses:

[0249] Indicator Number: 2003

[0250] Data source: Expense reimbursement system

[0251] Data retrieval method: File import

[0252] Data retrieval frequency: daily

[0253] Taxes and fees:

[0254] Indicator Number: 2004

[0255] Data source: Tax Management System

[0256] Data retrieval method: API interface

[0257] Data collection frequency: end of each month

[0258] Specific examples

[0259] Suppose we need to generate a profit and loss statement on December 31, 2023. The system needs to obtain the business data associated with each report indicator item by following these steps.

[0260] Step S31, determining the target business system, is as follows:

[0261] Operating revenue:

[0262] Data source: General Ledger System

[0263] Target business system: General ledger system

[0264] Operating costs:

[0265] Data source: Cost management system

[0266] Target business system: Cost management system

[0267] Operating expenses:

[0268] Data source: Expense reimbursement system

[0269] Target business system: Expense reimbursement system

[0270] Taxes and fees:

[0271] Data source: Tax Management System

[0272] Target business system: Tax management system

[0273] The process of obtaining business data in step S32 is as follows:

[0274] Operating revenue:

[0275] Data retrieval method: SQL query

[0276] Data collection frequency: end of each month

[0277] Specific operations:

[0278] Calculation result: Operating revenue = 6,000,000 yuan

[0279] Operating costs:

[0280] Data retrieval method: API interface

[0281] Data collection frequency: end of each quarter

[0282] Specific operations:

[0283] Calculation result: Operating cost = 4,000,000 yuan

[0284] Operating expenses:

[0285] Data retrieval method: File import

[0286] Data retrieval frequency: daily

[0287] Specific operations:

[0288] Calculation result: Operating expenses = 500,000 yuan

[0289] Taxes and fees:

[0290] Data retrieval method: API interface

[0291] Data collection frequency: end of each month

[0292] Specific operations:

[0293] Calculation result: Taxes and fees = 300,000 yuan

[0294] Through the above steps, the system can obtain business data associated with each report indicator from different business systems based on the indicator configuration information of each report indicator. This data will be used for subsequent report generation and analysis to ensure the accuracy and timeliness of the reports.

[0295] Figure 4 This is a schematic diagram of the process for updating index values ​​as shown in the fourth embodiment of this disclosure.

[0296] like Figure 4 As shown, after determining the indicator values ​​of each report indicator based on the business data associated with each report indicator, this disclosure also includes:

[0297] In step S41, in response to an update in the target business system, the updated data in the target business system is obtained.

[0298] For example, the system can be configured with a monitoring mechanism to periodically check for updated data in the target business system. The target business system can provide an update notification mechanism, such as a webhook or message queue, to notify the system of data updates in real time. Once an update is detected in the target business system, the system will retrieve the updated data from the target business system.

[0299] In step S42, the indicator values ​​of each report indicator item are updated based on the updated data.

[0300] The updated data is processed to calculate new indicator values, and these new values ​​are then updated in the report to ensure the accuracy and timeliness of the report data.

[0301] Example:

[0302] Suppose we generated a profit and loss statement on December 31, 2023, and the system has already determined the initial values ​​for each report indicator. Now, suppose the target business system is updated on January 5, 2024. The system needs to respond to these updates, obtain the updated data, and update the indicator values ​​for the report items.

[0303] Initial report data

[0304] Operating revenue: 6,000,000 yuan

[0305] Operating costs: 4,000,000 yuan

[0306] Operating expenses: 500,000 yuan

[0307] Taxes and fees: 300,000 yuan

[0308] Update process

[0309] In response to an update in the target business system, retrieve the updated data.

[0310] General Ledger System:

[0311] A new income item was added: January 1, 2024, income item 4001, amount 500,000 yuan.

[0312] Cost Management System:

[0313] A new cost item has been added: January 2, 2024, cost item 5001, amount 200,000 yuan.

[0314] Expense reimbursement system:

[0315] A new expense has been added: January 3, 2024, expense item 6001, amount 100,000 yuan.

[0316] Tax Management System:

[0317] A new tax expense has been added: January 4, 2024, tax expense item 7001, amount 50,000 yuan.

[0318] Based on the updated data, update the indicator values ​​for each report indicator item.

[0319] Operating revenue:

[0320] Initial value: 6,000,000 yuan

[0321] Updated data: New revenue of 500,000 yuan

[0322] New value: 6,000,000 + 500,000 = 6,500,000 yuan

[0323] Operating costs:

[0324] Initial value: 4,000,000 yuan

[0325] Updated data: Additional cost of 200,000 yuan

[0326] New value: 4,000,000 + 200,000 = 4,200,000 yuan

[0327] Operating expenses:

[0328] Initial value: 500,000 yuan

[0329] Updated data: Additional fee of 100,000 yuan.

[0330] New value: 500,000 + 100,000 = 600,000 yuan

[0331] Taxes and fees:

[0332] Initial value: 300,000 yuan

[0333] Updated data: Additional taxes and fees of 50,000 yuan.

[0334] New value: 300,000 + 50,000 = 350,000 yuan

[0335] Updated report data

[0336] Operating revenue: 6,500,000 yuan

[0337] Operating costs: 4,200,000 yuan

[0338] Operating expenses: 600,000 yuan

[0339] Taxes and fees: 350,000 yuan

[0340] Through the above steps, the system can promptly obtain updated data after the target business system is updated, and update the indicator values ​​of each report indicator based on this updated data. This ensures the accuracy and timeliness of the report data and improves the reliability and usability of the reports.

[0341] Figure 5 This is a schematic diagram of the process for generating a target report that is compatible with a specified report type, as shown in the fifth embodiment of this disclosure.

[0342] In this disclosure, the report configuration information also includes basic report information. This basic information includes the report title, date, and unit. Report format: defines the report's format and layout, including the header and body.

[0343] like Figure 5 As shown, this disclosure generates a target report adapted to a specified report type based on the indicator values ​​of each report indicator item and the report template, including:

[0344] In step S51, an initial report adapted to the report template is generated based on the basic information of the report.

[0345] Basic information of the report:

[0346] Title: Profit and Loss Statement

[0347] Date: December 31, 2023

[0348] Unit: RMB Yuan

[0349] Report template:

[0350] Header:

[0351] Title: Profit and Loss Statement

[0352] Date: December 31, 2023

[0353] Unit: RMB Yuan

[0354] Table body:

[0355] Operating revenue

[0356] Operating costs

[0357] Operating profit

[0358] Net profit

[0359] Generate initial report:

[0360] Generate an initial report framework based on the basic information and format of the report.

[0361] The initial report framework is as follows:

[0362] Title: Profit and Loss Statement

[0363] Date: December 31, 2023

[0364] Unit: RMB Yuan

[0365] Operating revenue:

[2001]

[0366] Operating costs:

[2002]

[0367] Operating profit:

[2003]

[0368] Net profit:

[2004]

[0369] In step S52, the initial report is updated based on the indicator values ​​of each report indicator item and the report format to obtain the target report.

[0370] Following the example above:

[0371] Obtain the indicator values ​​for each report indicator item:

[0372] Operating revenue: 6,500,000 yuan

[0373] Operating costs: 4,200,000 yuan

[0374] Operating profit: RMB 2,300,000 (= RMB 6,500,000 - RMB 4,200,000)

[0375] Net profit: RMB 1,600,000 (=2,300,000-500,000-200,000)

[0376] Update the initial report:

[0377] Fill the initial report with the indicator values ​​of each report indicator item to generate the target report.

[0378] The updated target report is as follows:

[0379] Title: Profit and Loss Statement

[0380] Date: December 31, 2023

[0381] Unit: RMB Yuan

[0382] Operating revenue: 6,500,000

[0383] Operating costs: 4,200,000

[0384] Operating profit: 2,300,000

[0385] Net profit: 1,600,000

[0386] Therefore, through the above steps, the system can generate a target report adapted to a specified report type based on the indicator values ​​of each report indicator and the report format. First, the system generates an initial report framework based on the basic report information, and then fills the initial report with the indicator values ​​of each report indicator to generate the final target report. This ensures the accuracy and completeness of the report.

[0387] Figure 6 This is a schematic diagram of the process of updating the initial report to obtain the target report as shown in the sixth embodiment of this disclosure.

[0388] In this disclosure, the report template is used to indicate the association between each field in the report to be generated and the indicator number of the report indicator item. For example, for operating revenue: the "Operating Revenue" field is associated with indicator number "2001"; the "Operating Cost" field is associated with indicator number "2002"; the "Operating Profit" field is associated with indicator number "2003"; and the "Net Profit" field is associated with indicator number "2004".

[0389] like Figure 6 As shown, this disclosure updates the initial report based on the indicator values ​​and report templates of each report indicator item to obtain the target report, including:

[0390] In step S61, the filling position of each report indicator item in the initial report is determined according to the correlation indicated by the report template.

[0391] In step S62, based on the fill position of each report indicator item, each report indicator item and its corresponding indicator value are filled into the initial report to obtain the target report.

[0392] Suppose we need to generate the profit and loss statement as of December 31, 2023, the system will generate the target report according to the following steps.

[0393] The process of determining the pop-up positions of each report indicator item in the initial report is as follows:

[0394] Analysis of report templates:

[0395] Title: Profit and Loss Statement

[0396] Date: December 31, 2023

[0397] Unit: RMB Yuan

[0398] Table body:

[0399] Operating Revenue

[2001]

[0400] Operating costs

[2002]

[0401] Operating profit

[2003]

[0402] Net profit

[2004]

[0403] Determine the fill location:

[0404] Operating Revenue: Indicator No. 2001, the populate field is the "Operating Revenue" field.

[0405] Operating Costs: Indicator No. 2002, fill in the "Operating Costs" field.

[0406] Operating Profit: Indicator No. 2003, the populate field is the "Operating Profit" field.

[0407] Net Profit: Indicator No. 2004, fill in the "Net Profit" field.

[0408] The process of filling in the initial report is as follows:

[0409] Obtain the indicator values ​​for each report indicator item:

[0410] Operating revenue: 6,500,000 yuan

[0411] Operating costs: 4,200,000 yuan

[0412] Operating profit: RMB 2,300,000 (= RMB 6,500,000 - RMB 4,200,000)

[0413] Net profit: RMB 1,600,000 (=2,300,000-500,000-200,000)

[0414] Fill in the initial report:

[0415] Fill the initial report with each report indicator item and its corresponding indicator value to generate the target report.

[0416] The updated target report is as follows:

[0417] Title: Profit and Loss Statement

[0418] Date: December 31, 2023

[0419] Unit: RMB Yuan

[0420] Operating revenue: 6,500,000

[0421] Operating costs: 4,200,000

[0422] Operating profit: 2,300,000

[0423] Net profit: 1,600,000

[0424] Through the above steps, the system first parses the report template, determines the filling position of each report indicator item in the initial report, and then fills each report indicator item and its corresponding indicator value into the initial report to generate the final target report. This ensures the accuracy and completeness of the report.

[0425] Corresponding to the report generation method provided in the above embodiments, this disclosure also provides a report generation device. Since the report generation device provided in this disclosure corresponds to the report generation method provided in the above embodiments, the implementation of the report generation method is also applicable to the report generation device provided in this disclosure, and will not be described in detail in this disclosure.

[0426] Figure 7 This is a schematic diagram of the report generation device shown in the seventh embodiment of this disclosure.

[0427] like Figure 7 As shown, the report generation apparatus 700 of this embodiment includes:

[0428] The first acquisition module 710 is used to acquire report configuration information associated with a specified report type; wherein, the report configuration information includes a report template and indicator configuration information for at least one report indicator item;

[0429] The second acquisition module 720 is used to acquire business data associated with each report indicator item based on the indicator configuration information of each report indicator item.

[0430] The determination module 730 is used to determine the indicator value of each report indicator based on the business data associated with each report indicator item;

[0431] The generation module 740 is used to generate a target report that is compatible with the specified report type based on the indicator values ​​and report templates of each report indicator item.

[0432] In one embodiment of this disclosure, the report metrics include basic metrics and derived metrics. When determining the metric value of each report metric based on business data associated with it, the determining module 730 includes:

[0433] For any basic indicator, the indicator value of any basic indicator is determined based on the business data associated with that basic indicator and the processing method of that basic indicator.

[0434] For any derived indicator item, identify the associated indicator items related to that derived indicator item; wherein, the associated indicator items include basic indicator items and / or derived indicator items;

[0435] The value of any derived indicator is determined based on the value of the associated indicator and the processing caliber of the derived indicator.

[0436] In one embodiment of this disclosure, the indicator configuration information includes the data source, data acquisition method, and data acquisition frequency for the report indicator items. The second acquisition module 720, when acquiring business data associated with each report indicator item based on the indicator configuration information for each report indicator item, includes:

[0437] For any report indicator, determine the target business system from multiple business systems whose data source matches that of the report indicator.

[0438] Based on the data retrieval method and frequency for any report indicator, obtain the business data associated with any report indicator from the target business system.

[0439] In one embodiment of this disclosure, the apparatus further includes:

[0440] The update module is used to respond to updates in the target business system, obtain the updated data in the target business system, and update the indicator values ​​of each report indicator item based on the updated data.

[0441] In one embodiment of this disclosure, the report configuration information further includes basic report information. When the generation module 740 generates a target report adapted to a specified report type based on the indicator values ​​of each report indicator item and the report template, it includes:

[0442] Based on the basic information of the report, generate an initial report that matches the report template;

[0443] Based on the indicator values ​​of each report item and the report format, the initial report is updated to obtain the target report.

[0444] In one embodiment of this disclosure, a report template is used to indicate the association between the index numbers of each field in the report to be generated and the index items in the report.

[0445] The update module is used to update the initial report based on the indicator values ​​of each report indicator and the report format. When obtaining the target report, it includes:

[0446] Based on the relationships indicated by the report template, determine the pop-up positions of each report indicator item in the initial report;

[0447] Based on the fill position of each report indicator item, each report indicator item and its corresponding indicator value are filled into the initial report to obtain the target report.

[0448] The report generation apparatus of this disclosure acquires report configuration information associated with a specified report type through a first acquisition module. This report configuration information includes a report template and indicator configuration information for at least one report indicator item. A second acquisition module acquires business data associated with each report indicator item based on its indicator configuration information. A determination module determines the indicator value for each report indicator item based on the associated business data. Finally, a generation module generates a target report adapted to the specified report type based on the indicator values ​​and the report template. Therefore, this disclosure allows for flexible configuration directly through the system functions of a financial reporting system, enabling automatic data retrieval from upstream systems and the generation of target reports. This not only improves report generation efficiency but also ensures data accuracy and compliance.

[0449] In an exemplary embodiment, this disclosure also proposes an electronic device.

[0450] The electronic devices include:

[0451] processor;

[0452] Memory used to store processor-executable instructions;

[0453] The processor is configured to execute instructions to implement the report generation method as proposed in any of the foregoing embodiments.

[0454] As an example, Figure 8 This is a schematic diagram of the structure of an electronic device 800 as shown in an exemplary embodiment of this disclosure, as follows: Figure 8 As shown, the above-mentioned electronic device 800 may further include:

[0455] The present invention includes a memory 810 and a processor 820, and a bus 830 connecting different components (including the memory 810 and the processor 820). The memory 810 stores a computer program, and when the processor 820 executes the program, it implements the report generation method described in the embodiments of the present disclosure.

[0456] Bus 830 represents one or more of several bus architectures, including a memory bus or memory controller, a peripheral bus, a graphics acceleration port, a processor, or a local bus using any of the various bus architectures. Examples of these architectures include, but are not limited to, the Industry Standard Architecture (ISA) bus, the Micro Channel Architecture (MAC) bus, the Enhanced ISA bus, the Video Electronics Standards Association (VESA) local bus, and the Peripheral Component Interconnect (PCI) bus.

[0457] Electronic device 800 typically includes a variety of electronic device readable media. These media can be any available media that can be accessed by electronic device 800, including volatile and non-volatile media, removable and non-removable media.

[0458] The memory 810 may also include computer system readable media in the form of volatile memory, such as random access memory (RAM) 840 and / or cache memory 850. The server 800 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, the storage system 860 may be used to read and write non-removable, non-volatile magnetic media (…). Figure 8 Not shown; usually referred to as a "hard drive"). Although Figure 8 Not shown, a disk drive for reading and writing to a removable non-volatile disk (e.g., a "floppy disk") and an optical disk drive for reading and writing to a removable non-volatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 830 via one or more data media interfaces. Memory 810 may include at least one program product having a set (e.g., at least one) of program modules configured to perform the functions of the embodiments of this disclosure.

[0459] A program / utility 880 having a set (at least one) of program modules 870 may be stored, for example, in memory 810. Such program modules 870 include—but are not limited to—an operating system, one or more application programs, other program modules, and program data. Each or some combination of these examples may include an implementation of a network environment. Program modules 870 typically perform the functions and / or methods described in the embodiments of this disclosure.

[0460] Electronic device 800 can also communicate with one or more external devices 890 (e.g., keyboard, pointing device, display 891, etc.), and with one or more devices that enable a user to interact with electronic device 800, and / or with any device that enables electronic device 800 to communicate with one or more other computing devices (e.g., network card, modem, etc.). This communication can be performed via input / output (I / O) interface 892. Furthermore, electronic device 800 can also communicate with one or more networks (e.g., local area network (LAN), wide area network (WAN), and / or public networks, such as the Internet) via network adapter 893. As shown, network adapter 893 communicates with other modules of electronic device 800 via bus 830. It should be understood that, although not shown in the figures, other hardware and / or software modules can be used in conjunction with electronic device 800, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0461] The processor 820 performs various functional applications and data processing by running programs stored in the memory 810.

[0462] It should be noted that the implementation process and technical principles of the electronic device in this embodiment are explained in the foregoing description of the report generation method of this disclosure embodiment, and will not be repeated here.

[0463] In an exemplary embodiment, a computer-readable storage medium including instructions is also provided, such as a memory including instructions, which can be executed by a processor of an electronic device to complete the report generation method proposed in any of the above embodiments. Optionally, the computer-readable storage medium may be a ROM, random access memory (RAM), CD-ROM, magnetic tape, floppy disk, and optical data storage device, etc.

[0464] In an exemplary embodiment, a computer program product is also provided, including a computer program / instructions, characterized in that the computer program / instructions, when executed by a processor, implement the report generation method proposed in any of the above embodiments.

[0465] Other embodiments of this disclosure will readily occur to those skilled in the art upon consideration of the specification and practice of the invention disclosed herein. This disclosure is intended to cover any variations, uses, or adaptations of this disclosure that follow the general principles of this disclosure and include common knowledge or customary techniques in the art not disclosed herein. The specification and examples are to be considered exemplary only, and the true scope and spirit of this disclosure are indicated by the following claims.

[0466] It should be understood that this disclosure is not limited to the precise structures described above and shown in the accompanying drawings, and various modifications and changes can be made without departing from its scope. The scope of this disclosure is limited only by the appended claims.

Claims

1. A report generation method, characterized in that, include: Obtain report configuration information associated with a specified report type; wherein, the report configuration information includes a report template and indicator configuration information for at least one report indicator item; Based on the indicator configuration information of each of the report indicator items, obtain the business data associated with each of the report indicator items; Based on the business data associated with each of the aforementioned report indicator items, determine the indicator value of each of the aforementioned report indicator items; Based on the indicator values ​​of each of the aforementioned report indicator items and the report template, a target report adapted to the specified report type is generated. The report indicators include basic indicators and derived indicators. Determining the indicator value of each report indicator based on the business data associated with it includes: For any basic indicator item, the indicator value of the basic indicator item is determined based on the business data associated with the basic indicator item and the processing method of the basic indicator item. For any derived indicator item, determine the associated indicator item related to the derived indicator item; wherein, the associated indicator item includes the basic indicator item and / or the derived indicator item; The value of any derived indicator is determined based on the indicator value of the associated indicator associated with any derived indicator and the processing caliber of any derived indicator. The indicator configuration information includes the data source, data retrieval method, and data retrieval frequency for each report indicator item. The step of obtaining business data associated with each report indicator item based on its configuration information includes: For any report indicator, determine the target business system that matches the data source of the report indicator from multiple business systems; Based on the data retrieval method and frequency of any of the report indicators, obtain the business data associated with any of the report indicators from the target business system.

2. The method according to claim 1, characterized in that, After determining the indicator value of each report indicator based on the business data associated with each report indicator, the method further includes: In response to an update in the target business system, the updated data in the target business system is obtained; Based on the updated data, update the indicator values ​​of each report indicator item.

3. The method according to claim 1, characterized in that, The report configuration information also includes basic report information. The process of generating a target report adapted to the specified report type based on the indicator values ​​and report format of each report indicator item includes: Based on the basic information of the report, an initial report adapted to the report template is generated; Based on the indicator values ​​of each of the aforementioned report indicators and the report format, the initial report is updated to obtain the target report.

4. The method according to claim 3, characterized in that, The report template is used to indicate the association between each field in the report to be generated and the indicator number of the report indicator item; The process of updating the initial report based on the indicator values ​​and report format of each of the report indicators to obtain the target report includes: Based on the relationships indicated by the report template, determine the fill position of each report indicator item in the initial report; Based on the filling position of each of the report indicator items, each of the report indicator items and its corresponding indicator value are filled into the initial report to obtain the target report.

5. A report generation device, characterized in that, include: The first acquisition module is used to acquire report configuration information associated with a specified report type; wherein, the report configuration information includes a report template and indicator configuration information for at least one report indicator item; The second acquisition module is used to acquire business data associated with each of the report indicator items based on the indicator configuration information of each of the report indicator items; The determination module is used to determine the indicator value of each of the report indicator items based on the business data associated with each of the report indicator items; The generation module is used to generate a target report that is compatible with the specified report type based on the indicator values ​​of each of the report indicator items and the report template. The report indicators include basic indicators and derived indicators. When determining the indicator value of each report indicator based on business data associated with it, the determining module includes: For any basic indicator item, the indicator value of the basic indicator item is determined based on the business data associated with the basic indicator item and the processing method of the basic indicator item. For any derived indicator item, determine the associated indicator item related to the derived indicator item; wherein, the associated indicator item includes the basic indicator item and / or the derived indicator item; The value of any derived indicator is determined based on the indicator value of the associated indicator associated with any derived indicator and the processing caliber of any derived indicator. The indicator configuration information includes the data source, data acquisition method, and data acquisition frequency for each report indicator item. The second acquisition module, when acquiring business data associated with each report indicator item based on its indicator configuration information, includes: For any report indicator, determine the target business system that matches the data source of the report indicator from multiple business systems; Based on the data retrieval method and frequency of any of the report indicators, obtain the business data associated with any of the report indicators from the target business system.

6. An electronic device, characterized in that, include: processor; Memory used to store the processor's executable instructions; The processor is configured to execute the instructions to implement the report generation method as described in any one of claims 1 to 4.

7. A computer-readable storage medium, wherein when instructions in the computer-readable storage medium are executed by a processor of an electronic device, the electronic device is enabled to perform the report generation method as described in any one of claims 1 to 4.

8. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by a processor, it implements the report generation method as described in any one of claims 1 to 4.

Images