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

Abstract

The invention relates to a report generation method, a report generation device, electronic equipment and a storage medium. The method comprises the following steps: acquiring report configuration information associated with a specified report type; wherein the report configuration information comprises a report sample 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 an index value of each report index item based on the business data associated with each report index item; and generating a target report adaptive to the specified report type based on the index value of each report index item and the report sample. According to the method and the device, flexible configuration can be directly performed through system functions of the financial report system, and automatic access from an upstream system and target report generation are realized, so that the report generation efficiency is improved, and the accuracy and compliance of data are ensured.

Description

Technical Field

[0001] The present disclosure relates to the technical field of reports, and in particular to a report generating method, a report generating device, an electronic device and a storage medium. Background Art

[0002] The disclosure of bank financial reports aims to provide comprehensive and transparent information to the outside world and help stakeholders understand financial status, operating results, cash flow, and risk exposure. Domestic and foreign banking institutions must issue financial statements in accordance with local accounting standards and external regulatory requirements, in accordance with the prescribed reporting style and reporting items. Since the report presentation style and data caliber vary greatly among different institutions and are frequently updated, banks need to respond flexibly, but the current efficiency of report generation is low, which increases the workload of banks and affects the accuracy and compliance of reports. Summary of the invention

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

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

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

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

[0007] Determining the index value of each report index item based on the business data associated with each report index item;

[0008] Based on the indicator value of each of the report indicator items and the report sample, a target report adapted to the specified report type is generated.

[0009] According to a second aspect of an embodiment of the present disclosure, there is provided a report generating device, comprising:

[0010] A 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 of at least one report indicator item;

[0011] A second acquisition module, 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] A determination module, used to determine the indicator value of each report indicator item based on the business data associated with each report indicator item;

[0013] A generating module is used to generate a target report adapted to the specified report type based on the indicator value of each report indicator item and the report sample.

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

[0015] According to a fourth aspect of an embodiment of the present disclosure, a computer-readable storage medium is provided. When instructions in the computer-readable storage medium are executed by a processor of an electronic device, the electronic device can execute the report generating method as described in the above embodiment of the present disclosure.

[0016] According to a fifth aspect of an embodiment of the present disclosure, a computer program product is provided, including: a computer program, wherein when the computer program is executed by a processor, the report generating method as described in the above embodiment of the present disclosure is implemented.

[0017] The technical solution provided by the embodiments of the present disclosure brings at least the following beneficial effects:

[0018] In the present disclosure, the report configuration information associated with the specified report type is first obtained, and the report configuration information includes a report template and indicator configuration information of at least one report indicator item. Then, based on the indicator configuration information of each report indicator item, the business data associated with each report indicator item is obtained, and based on the business data associated with each report indicator item, the indicator value of each report indicator item is determined. Finally, based on the indicator value of each report indicator item and the report template, a target report adapted to the specified report type is generated. Therefore, the present disclosure directly performs flexible configuration through the system function of the financial reporting system, realizes automatic data acquisition from the upstream system, and generates a target report, which not only improves the report generation efficiency, but also ensures the accuracy and compliance of the data.

[0019] It is to be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present disclosure. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] The drawings herein are incorporated into and constitute a part of the specification, illustrate embodiments consistent with the present disclosure, and together with the description are used to explain the principles of the present disclosure, and do not constitute improper limitations on the present disclosure.

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

[0022] Figure 2 is a flowchart of an indicator value determination method shown in the second embodiment of the present disclosure;

[0023] Figure 3 is a flowchart of a method for acquiring business data according to a third embodiment of the present disclosure;

[0024] Figure 4 is a schematic diagram of a process for updating an indicator value shown in the fourth embodiment of the present disclosure;

[0025] Figure 5 is a schematic diagram of a process of generating a target report adapted to a specified report type, shown in the fifth embodiment of the present disclosure;

[0026] Figure 6 It is a flowchart of updating an initial report to obtain a target report according to the sixth embodiment of the present disclosure;

[0027] Figure 7 It is a structural diagram of a report generating device shown in the seventh embodiment of the present disclosure.

[0028] Figure 8 It is a schematic structural diagram of an electronic device shown in an exemplary embodiment of the present disclosure. DETAILED DESCRIPTION

[0029] In order to enable ordinary persons in the art to better understand the technical solutions of the present disclosure, the technical solutions in the embodiments of the present disclosure will be clearly and completely described below in conjunction with the accompanying drawings.

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

[0031] It should be noted that the acquisition, storage, use, and processing of data in the technical solution disclosed in this disclosure are in compliance 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, stored data, displayed data, 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 relevant data must comply with relevant laws, regulations and standards.

[0033] It should also be noted that in the embodiments of the present disclosure, certain software, components, models and other existing solutions in the industry may be mentioned, which should be regarded as exemplary. Their purpose is only to illustrate the feasibility of implementing the technical solution of the present disclosure, but it does not mean that the applicant has or will necessarily use the solution.

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

[0035] Figure 1 It is a flowchart of the report generation method shown in the first embodiment of the present disclosure.

[0036] The embodiment of the present disclosure takes the report generation method configured in a report generation device as an example. The report generation device can be applied to any electronic device. The electronic device is provided with a financial report system, and the financial report system in the electronic device can perform a report generation function.

[0037] Among them, the electronic device can be any device with computing capabilities, such as a personal computer, a mobile terminal, a server (or cloud), etc. The mobile terminal can be, for example, a vehicle-mounted device, a mobile phone, a tablet computer, a personal digital assistant, a wearable device, and other hardware devices with various operating systems, touch screens and / or display screens.

[0038] like Figure 1 As shown, the report generation method of the embodiment of the present disclosure may include the following steps S1 to 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 of at least one report indicator item.

[0040] In the financial reporting system, the administrator pre-configures different types of reports, such as balance sheets, income statements, cash flow statements, etc. The configuration information of each report includes the report template and the indicator configuration information of at least one report indicator item. When the user chooses to generate a report, the system will obtain the report configuration information associated with the report type from the configuration library, and then define the format and layout of the report, including the header (such as title, period, unit, etc.) and the body (such as total assets, total liabilities, total owner's equity, etc.), as well as define the name, calculation formula, data source and data range of each report indicator item.

[0041] Example:

[0042] Report Type: Balance Sheet

[0043] Report configuration information:

[0044] Report template: including header and body

[0045] Header:

[0046] Title: Balance Sheet

[0047] Date: December 31, 2023

[0048] Unit: RMB

[0049] Table body:

[0050] Total assets

[0051] Total liabilities

[0052] Total owners' equity

[0053] Indicator configuration information for report indicator items:

[0054] Total assets:

[0055] Index number: 1001

[0056] Data source: General ledger system

[0057] Data collection range: All asset accounts (such as 1001-cash, 1002-accounts receivable, etc.)

[0058] Total liabilities:

[0059] Index number: 1002

[0060] Data source: General ledger system

[0061] Data collection range: All liability accounts (such as 2001-accounts payable, 2002-short-term loans, etc.)

[0062] Total owners' equity:

[0063] Index number: 1003

[0064] Data source: General ledger system

[0065] Data collection range: All owner's equity accounts (such as 3001-paid-in capital, 3002-retained earnings, etc.)

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

[0067] According to the indicator configuration information of each report indicator item, determine the data acquisition rules (including the data acquisition subject range and other additional conditions, etc.), and obtain the business data associated with each report indicator from the general ledger system or other upstream systems.

[0068] Example:

[0069] Assuming that the user chooses to generate a balance sheet, the system has obtained the report configuration information of the balance sheet from the configuration library. Next, the system will obtain the business data associated with each report indicator item based on the indicator configuration information of each report indicator item.

[0070] Balance Sheet

[0071] Determine the number-taking rules:

[0072] Total assets:

[0073] Data collection range: All asset accounts (such as 1001-cash, 1002-accounts receivable, etc.)

[0074] Additional conditions: Data collection time is December 31, 2023

[0075] Total liabilities:

[0076] Data collection range: All liability accounts (such as 2001-accounts payable, 2002-short-term loans, etc.)

[0077] Additional conditions: Data collection time is December 31, 2023

[0078] Total owners' equity:

[0079] Data collection range: All owner's equity accounts (such as 3001-paid-in capital, 3002-retained earnings, etc.)

[0080] Additional conditions: Data collection time is December 31, 2023

[0081] Data acquisition:

[0082] Total assets:

[0083] The ending balance of Cash (1001) extracted 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) extracted 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 owners' 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 owners' equity accounts from the general ledger system.

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

[0095] According to pre-defined data processing rules, the acquired business data is processed to calculate the indicator value of each report indicator item; wherein, the calculation method can use SQL statements or other data processing tools for calculation.

[0096] Example:

[0097] Assuming that the user has chosen to generate a balance sheet, the system has already obtained the business data associated with each report indicator item from the general ledger system. Next, the system will calculate the indicator value of each report indicator item based on this business data.

[0098] Data processing:

[0099] Total assets:

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

[0101] The ending balance of Cash (1001) is RMB 1,000,000

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

[0103] The ending balance of other asset items is RMB 3,000,000

[0104] Calculation method (calculated by SQL statement):

[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) is RMB 1,500,000

[0112] The ending balance of short-term loans (2002) is RMB 1,000,000

[0113] The ending balance of other liabilities is 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 owners' equity:

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

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

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

[0123] The ending balance of other owners' equity items is 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 owner's 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 item based on the business data associated with each report indicator item, 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 value of each report indicator item and the report sample.

[0131] After calculating and obtaining the index value of each report index item in step S3, the index value of each report index item is filled into the report sample to generate initial report data. According to the initial report data, the final target report is generated.

[0132] Example:

[0133] Assuming that the user has chosen to generate a balance sheet, the system has calculated the indicator values ​​of each report indicator item. Next, the system will generate the final target report based on these indicator values ​​and report templates.

[0134] Data filling:

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

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

[0137] Total owners' equity: 3,000,000 yuan

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

[0139] Title: Balance Sheet

[0140] Date: December 31, 2023

[0141] Unit: RMB

[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

[0149] Total assets: 6,000,000

[0150] Total liabilities: 4,000,000

[0151] Total owners' equity: 3,000,000

[0152] The final balance sheet generated is:

[0153] Title: Balance Sheet

[0154] Date: December 31, 2023

[0155] Unit: RMB

[0156] Total assets: 6,000,000

[0157] Total liabilities: 4,000,000

[0158] Total owners' equity: 3,000,000

[0159] In the present disclosure, at the end of each accounting period, the financial reporting system obtains business data from the upstream system according to the pre-configured report templates and report indicator items, generates the required indicator values ​​after data cleaning, conversion and aggregation, and then fills these indicator values ​​into the report template to automatically generate financial reports. Through this process, the system can efficiently generate accurate target reports to meet the needs of different institutions. This not only improves the efficiency of report generation, but also ensures the accuracy and compliance of data.

[0160] Figure 2 It is a flowchart of the indicator value determination method shown in the second embodiment of the present disclosure.

[0161] In the present disclosure, the classification of report index items includes basic index items and derived index items. Among them, basic index items are index items calculated directly from business data; derived index items are index items calculated based on basic index items and / or other derived index items.

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

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

[0164] S22, for any derived indicator item, determining an associated indicator item associated with any derived indicator item; wherein the associated indicator item includes a basic indicator item and / or a derived indicator item;

[0165] S23, determining the index value of any derived index item based on the index value of the associated index item associated with any derived index item and the processing caliber of any derived index item.

[0166] Assuming that the user chooses to generate an income statement, the system needs to determine the indicator values ​​of the basic indicator items and derived indicator items in the income statement.

[0167] Report Type: Income Statement

[0168] Report configuration information:

[0169] Sample report:

[0170] Header:

[0171] Title: Income Statement

[0172] Date: December 31, 2023

[0173] Unit: RMB

[0174] Table body:

[0175] Operating income

[0176] Operating costs

[0177] Operating Profit

[0178] Net Profit

[0179] Indicator configuration information for report indicator items:

[0180] Operating Revenue:

[0181] Index number: 2001

[0182] Data source: General ledger system

[0183] Data collection range: All income items (such as 4001-main business income, 4002-other business income, etc.)

[0184] Operating costs:

[0185] Index number: 2002

[0186] Data source: General ledger system

[0187] Data collection range: All cost items (such as 5001-main business cost, 5002-other business cost, etc.)

[0188] Operating Profit:

[0189] Index number: 2003

[0190] Related indicators: operating income, operating costs

[0191] Processing caliber: operating profit = operating income - operating costs

[0192] Net Profit:

[0193] Index number: 2004

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

[0195] Processing caliber: Net profit = operating profit - operating expenses - taxes

[0196] On this basis, the index values ​​of the basic index items and the index values ​​of the derived index items are calculated.

[0197] The process of determining the index value of the basic index item in step S21 is as follows:

[0198] Operating Revenue:

[0199] Business data:

[0200] The amount of main business income (4001) is RMB 5,000,000

[0201] The amount of other business income (4002) is RMB 1,000,000

[0202] Calculation method: SQL statement

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

[0204] Operating costs:

[0205] Business data:

[0206] The amount of main business cost (5001) is RMB 3,000,000

[0207] The amount of other operating costs (5002) is 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] The process of determining the associated index items of the derived index items in step S22 is as follows:

[0211] Operating Profit:

[0212] Related indicators: operating income, operating costs

[0213] Net Profit:

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

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

[0216] Operating Profit:

[0217] The indicator value of the associated indicator item:

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

[0219] Operating cost: 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 indicator value of the associated indicator item:

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

[0225] Operating expenses: 500,000 yuan

[0226] Taxes: 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 indicator items and derived indicator items based on the business data and processing caliber associated with each report indicator item, which provides accurate data support for subsequent report generation.

[0230] Figure 3 It is a flowchart of a method for acquiring business data shown in the third embodiment of the present disclosure.

[0231] In the present disclosure, the indicator configuration information includes the data source, data collection method and data collection frequency of the report indicator items.

[0232] like Figure 3 As shown, the present 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 matching the data acquisition source of any report indicator item is determined from multiple business systems.

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

[0235] Example

[0236] Sample report: Income statement

[0237] Report indicator items and their configuration information:

[0238] Operating Revenue:

[0239] Index number: 2001

[0240] Data source: General ledger system

[0241] Data acquisition method: SQL query

[0242] Frequency of data collection: End of each month

[0243] Operating costs:

[0244] Index number: 2002

[0245] Data source: Cost management system

[0246] Data acquisition method: API interface

[0247] Frequency of data collection: End of each quarter

[0248] Operating Expenses:

[0249] Index number: 2003

[0250] Data source: expense reimbursement system

[0251] Data acquisition method: file import

[0252] Frequency of data collection: Daily

[0253] Taxes:

[0254] Index number: 2004

[0255] Data source: Tax management system

[0256] Data acquisition method: API interface

[0257] Frequency of data collection: End of each month

[0258] Specific examples

[0259] Assume that we need to generate an income statement on December 31, 2023. The system needs to follow the steps below to obtain the business data associated with each report indicator item.

[0260] The process of determining the target business system in step S31 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:

[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 acquisition method: SQL query

[0276] Frequency of data collection: End of each month

[0277] Specific operations:

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

[0279] Operating costs:

[0280] Data acquisition method: API interface

[0281] Frequency of data collection: End of each quarter

[0282] Specific operations:

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

[0284] Operating Expenses:

[0285] Data acquisition method: file import

[0286] Frequency of data collection: Daily

[0287] Specific operations:

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

[0289] Taxes:

[0290] Data acquisition method: API interface

[0291] Frequency of data collection: End of each month

[0292] Specific operations:

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

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

[0295] Figure 4 4 is a flowchart of updating an indicator value according to the fourth embodiment of the present disclosure.

[0296] like Figure 4 As shown, the present disclosure further includes: after determining the index value of each report index item based on the business data associated with each report index item,

[0297] In step S41 , in response to the target business system being updated, updated data in the target business system is acquired.

[0298] For example, the system can set up a monitoring mechanism to regularly check whether the target business system has updated data. 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 the target business system is updated, the system will obtain the updated data from the target business system.

[0299] In step S42, the index value of each report index item is updated based on the updated data.

[0300] Process the updated data obtained, calculate new indicator values, and update the new indicator values ​​to the report to ensure the accuracy and timeliness of the report data.

[0301] Example:

[0302] Assume that we generate an income statement on December 31, 2023, and the system has determined the initial indicator values ​​for each report indicator item. Now, assume that on January 5, 2024, the target business system is updated, and the system needs to respond to these updates, obtain the updated data, and update the indicator values ​​of the report indicator items.

[0303] Initial report data

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

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

[0306] Operating expenses: 500,000 yuan

[0307] Taxes: 300,000 yuan

[0308] Update Process

[0309] In response to updates to the target business system, obtain updated data

[0310] General Ledger System:

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

[0312] Cost management system:

[0313] A new cost is added: January 2, 2024, cost account 5001, amount 200,000 yuan.

[0314] Expense Reimbursement System:

[0315] A new expense is added: January 3, 2024, expense account 6001, amount 100,000 yuan.

[0316] Tax management system:

[0317] A new tax is added: January 4, 2024, tax account 7001, amount 50,000 yuan.

[0318] Update the indicator values ​​of each report indicator item based on the updated data

[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: New 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: New cost of 100,000 yuan

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

[0331] Taxes:

[0332] Initial value: 300,000 yuan

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

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

[0335] Updated report data

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

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

[0338] Operating expenses: 600,000 yuan

[0339] Taxes: 350,000 yuan

[0340] Through the above steps, the system can obtain updated data in a timely manner after the target business system is updated, and update the indicator values ​​of each report indicator item based on these updated data, which ensures the accuracy and timeliness of the report data and improves the reliability and practicality of the report.

[0341] Figure 5 It is a flowchart of generating a target report adapted to a specified report type shown in the fifth embodiment of the present disclosure.

[0342] In the present disclosure, report configuration information also includes basic report information, including report title, date, unit, etc. Report template: defines the format and layout of the report, including the header and body.

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

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

[0345] Basic information of the report:

[0346] Title: Income Statement

[0347] Date: December 31, 2023

[0348] Unit: RMB

[0349] Sample report:

[0350] Header:

[0351] Title: Income Statement

[0352] Date: December 31, 2023

[0353] Unit: RMB

[0354] Table body:

[0355] Operating income

[0356] Operating costs

[0357] Operating Profit

[0358] Net Profit

[0359] Generate an initial report:

[0360] Generate the initial report framework based on the basic report information and report sample.

[0361] The initial report framework is as follows:

[0362] Title: Income Statement

[0363] Date: December 31, 2023

[0364] Unit: RMB

[0365] Operating income:

[2001]

[0366] Operating costs:

[2002]

[0367] Operating Profit:

[2003]

[0368] Net Profit:

[2004]

[0369] In step S52, based on the indicator value of each report indicator item and the report sample, the initial report is updated to obtain a target report.

[0370] Following the above example:

[0371] Get the indicator value of each report indicator item:

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

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

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

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

[0376] Update the initial report:

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

[0378] The updated target report is as follows:

[0379] Title: Income Statement

[0380] Date: December 31, 2023

[0381] Unit: RMB

[0382] Operating income: 6,500,000

[0383] Operating cost: 4,200,000

[0384] Operating profit: 2,300,000

[0385] Net profit: 1,600,000

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

[0387] Figure 6 It is a flowchart of updating an initial report to obtain a target report according to the sixth embodiment of the present disclosure.

[0388] In the present disclosure, a report template is used to indicate the association relationship between each field in the report to be generated and the indicator number of the report indicator item. For example, operating income: associate the "operating income" field with the indicator number "2001"; associate the "operating cost" field with the indicator number "2002"; associate the "operating profit" field with the indicator number "2003"; and associate the "net profit" field with the indicator number "2004".

[0389] like Figure 6 As shown, the present disclosure updates the initial report based on the indicator values ​​of each report indicator item and the report sample 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 association relationship indicated by the report template.

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

[0392] Assuming that we need to generate an income statement as of December 31, 2023, the system will generate the target report in the following steps.

[0393] The process of determining the filling position of each report indicator item in the initial report is as follows:

[0394] Sample analysis report:

[0395] Title: Income Statement

[0396] Date: December 31, 2023

[0397] Unit: RMB

[0398] Table body:

[0399] Operating income

[2001]

[0400] Operating costs

[2002]

[0401] Operating profit

[2003]

[0402] Net Profit

[2004]

[0403] Determine the fill position:

[0404] Operating income: indicator number 2001, filled in the "operating income" field

[0405] Operating cost: indicator number 2002, filled in the "operating cost" field

[0406] Operating Profit: Indicator number 2003, filled in the "Operating Profit" field

[0407] Net Profit: indicator number 2004, filled in the "Net Profit" field

[0408] The process for populating the initial report is as follows:

[0409] Get the indicator value of each report indicator item:

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

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

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

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

[0414] Populate the initial report:

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

[0416] The updated target report is as follows:

[0417] Title: Income Statement

[0418] Date: December 31, 2023

[0419] Unit: RMB

[0420] Operating income: 6,500,000

[0421] Operating cost: 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 sample, 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, which can ensure the accuracy and completeness of the report.

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

[0426] Figure 7 It is a structural diagram of a report generating device shown in the seventh embodiment of the present disclosure.

[0427] like Figure 7 As shown, the report generation device 700 of the embodiment of the present disclosure 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 of at least one report indicator item;

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

[0430] A determination module 730, configured to determine an indicator value of each report indicator item based on business data associated with each report indicator item;

[0431] The generating module 740 is used to generate a target report adapted to a specified report type based on the indicator value of each report indicator item and the report sample.

[0432] In one embodiment of the present disclosure, the report indicator items include basic indicator items and derived indicator items. The determination module 730 is used to determine the indicator value of each report indicator item based on the business data associated with each report indicator item, including:

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

[0434] For any derived indicator item, determining an associated indicator item associated with any derived indicator item; wherein the associated indicator item includes a basic indicator item and / or a derived indicator item;

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

[0436] In one embodiment of the present disclosure, the indicator configuration information includes the data acquisition source, data acquisition method and data acquisition frequency of the report indicator item. The second acquisition module 720 is used to acquire the business data associated with each report indicator item based on the indicator configuration information of each report indicator item, including:

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

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

[0439] In one embodiment of the present disclosure, the above-mentioned device further includes:

[0440] The update module is used to obtain update data in the target business system in response to an update of the target business system, and update the indicator value of each report indicator item based on the updated data.

[0441] In one embodiment of the present disclosure, the report configuration information also includes basic report information. The generating module 740 is used to generate a target report adapted to a specified report type based on the indicator value of each report indicator item and the report sample, including:

[0442] Generate an initial report that matches the report template based on the basic report information;

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

[0444] In one embodiment of the present disclosure, a report sample is used to indicate the association relationship between each field in the report to be generated and the indicator number of the report indicator item;

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

[0446] According to the association relationship indicated by the report sample, determine the filling position of each report indicator item in the initial report;

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

[0448] The report generation device of the embodiment of the present disclosure obtains report configuration information associated with the specified report type through a first acquisition module, the report configuration information includes a report sample and indicator configuration information of at least one report indicator item, obtains business data associated with each report indicator item based on the indicator configuration information of each report indicator item through a second acquisition module, determines the indicator value of each report indicator item based on the business data associated with each report indicator item through a determination module, and generates a target report adapted to the specified report type based on the indicator value of each report indicator item and the report sample through a generation module. Therefore, the present disclosure can be flexibly configured directly through the system functions of the financial reporting system, realize automatic data acquisition from the upstream system, and generate a target report, which not only improves the report generation efficiency, but also ensures the accuracy and compliance of the data.

[0449] In an exemplary embodiment, the present disclosure also provides an electronic device.

[0450] Among them, electronic equipment includes:

[0451] processor;

[0452] a memory for storing processor-executable instructions;

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

[0454] As an example, Figure 8 is a schematic diagram of the structure of an electronic device 800 shown in an exemplary embodiment of the present disclosure, such as Figure 8 As shown, the electronic device 800 may further include:

[0455] The memory 810 and the processor 820, 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, the report generation method described in the embodiment of the present disclosure is implemented.

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

[0457] The electronic device 800 typically includes a variety of electronic device readable media. These media can be any available media that can be accessed by the 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 called 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, a DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to the bus 830 via one or more data medium interfaces. The memory 810 may include at least one program product having a set (e.g., at least one) of program modules that are configured to perform the functions of the various embodiments of the present disclosure.

[0459] A program / utility 880 having a set (at least one) of program modules 870 may be stored, for example, in the memory 810, such program modules 870 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment. The program modules 870 generally perform the functions and / or methods of the embodiments described in the present disclosure.

[0460] The electronic device 800 may also communicate with one or more external devices 890 (e.g., keyboard, pointing device, display 891, etc.), may also communicate with one or more devices that enable a user to interact with the electronic device 800, and / or may communicate with any device that enables the electronic device 800 to communicate with one or more other computing devices (e.g., network card, modem, etc.). Such communication may be performed via an input / output (I / O) interface 892. Furthermore, the electronic device 800 may also communicate with one or more networks (e.g., local area network (LAN), wide area network (WAN) and / or public network, such as the Internet) via a network adapter 893. As shown, the network adapter 893 communicates with other modules of the electronic device 800 via a bus 830. It should be understood that, although not shown in the figure, other hardware and / or software modules may be used in conjunction with the 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 executes various functional applications and data processing by running the programs stored in the memory 810 .

[0462] It should be noted that the implementation process and technical principles of the electronic device of this embodiment refer to the aforementioned explanation of the report generation method of the embodiment of the present disclosure, which 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, and the above instructions 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 can be a ROM, a random access memory (RAM), a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, etc.

[0464] In an exemplary embodiment, a computer program product is further provided, including a computer program / instruction, wherein when the computer program / instruction is executed by a processor, the report generation method proposed in any of the above embodiments is implemented.

[0465] Those skilled in the art will readily appreciate other embodiments of the present disclosure after considering the specification and practicing the invention disclosed herein. The present disclosure is intended to cover any variations, uses or adaptations of the present disclosure that follow the general principles of the present disclosure and include common knowledge or customary techniques in the art that are not disclosed in the present disclosure. The description and examples are to be considered exemplary only, and the true scope and spirit of the present disclosure are indicated by the following claims.

[0466] It should be understood that the present disclosure is not limited to the exact structures that have been described above and shown in the drawings, and that various modifications and changes may be made without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.

Claims

1. A report generation method, characterized in that: include: Acquire report configuration information associated with a specified report type; wherein the report configuration information includes a report template and indicator configuration information of at least one report indicator item; Based on the indicator configuration information of each of the report indicator items, obtaining the business data associated with each of the report indicator items; Determining the index value of each report index item based on the business data associated with each report index item; Based on the indicator value of each of the report indicator items and the report sample, a target report adapted to the specified report type is generated.

2. The method according to claim 1, characterized in that: The report indicator items include basic indicator items and derived indicator items. The determining of the indicator value of each report indicator item based on the business data associated with each report indicator item includes: For any basic indicator item, based on the business data associated with the any basic indicator item and the processing caliber of the any basic indicator item, determine the indicator value of the any basic indicator item; For any derived indicator item, determining an associated indicator item associated with the any derived indicator item; wherein the associated indicator item includes a basic indicator item and / or a derived indicator item; The index value of any derived index item is determined based on the index value of the associated index item associated with any derived index item and the processing caliber of any derived index item.

3. The method according to claim 1, characterized in that The indicator configuration information includes the data acquisition source, data acquisition method and data acquisition frequency of the report indicator item. The acquiring of the business data associated with each report indicator item based on the indicator configuration information of each report indicator item includes: For any report indicator item, determine a target business system that matches the data source of any report indicator item from multiple business systems; Based on the data acquisition method and frequency of any of the report indicator items, business data associated with any of the report indicator items is acquired from the target business system.

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

5. The method according to claim 1, characterized in that The report configuration information also includes basic report information. The target report adapted to the specified report type is generated based on the indicator value and report sample of each report indicator item, including: Based on the basic report information, generate an initial report that matches the report sample; Based on the indicator value of each report indicator item and the report sample, the initial report is updated to obtain the target report.

6. The method according to claim 1, characterized in that The report template is used to indicate the association relationship between each field in the report to be generated and the indicator number of the report indicator item; The updating of the initial report based on the indicator value of each report indicator item and the report sample to obtain the target report includes: Determine the filling position of each of the report index items in the initial report according to the association relationship indicated by the report sample; Based on the filling position of each report indicator item, each report indicator item and the corresponding indicator value are filled into the initial report to obtain the target report.

7. A report generation device, characterized in that: include: A 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 of at least one report indicator item; A second acquisition module, 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; A determination module, used to determine the indicator value of each report indicator item based on the business data associated with each report indicator item; A generating module is used to generate a target report adapted to the specified report type based on the indicator value of each report indicator item and the report sample.

8. An electronic device, characterized in that: include: processor; a memory for storing instructions executable by the processor; The processor is configured to execute the instructions to implement the report generation method according to any one of claims 1 to 6.

9. A computer-readable storage medium, when instructions in the computer-readable storage medium are executed by a processor of an electronic device, the electronic device is enabled to execute the report generating method according to any one of claims 1 to 6.

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the report generating method according to any one of claims 1 to 6 is implemented.

Images