CA3129802A1

CA3129802A1 - Business report generation method and device, computer equipment and storage medium

Info

Publication number: CA3129802A1
Application number: CA3129802A
Authority: CA
Inventors: Zhenhua HAO; Jian Hou; Junlong LU; Jinzhi Guo; Shuai HU
Original assignee: 10353744 Canada Ltd
Current assignee: 10353744 Canada Ltd
Priority date: 2020-09-02
Filing date: 2021-09-02
Publication date: 2022-03-02
Also published as: CN112131843A

Abstract

The present application relates to a business report generating method, a device, a computer equipment and a storage medium. The method comprises obtaining a report template of the business report; obtaining business data of the business report, and basing on the first identification information of each cell to load the business data into the cell of the worksheet;
and basing on the calculation formula of the business to be processed to obtain the business data of the corresponding cell in the worksheet and performing data processing on the obtained business data, and basing on data processing result to generate the business report. The foregoing method is capable of enhancing generation efficiency of business reports.

Description

BUSINESS REPORT GENERATION METHOD AND DEVICE, COMPUTER
EQUIPMENT AND STORAGE MEDIUM
BACKGROUND OF THE INVENTION
Technical Field [0001] The present application relates to the field of business data processing technology, and more particularly to a business report generating method, a business report generating device, a computer equipment and a storage medium.
Description of Related Art

[0002] With the introduction of various preferential policies to the development of small and micro-scale enterprises, more and more small and micro-scale enterprises of various styles come into being. This engenders an abrupt increase in entrusted bookkeeping, but the conventional bookkeeping software is no longer adapted to the practical demand for batch bookkeeping. In addition, in the traditional bookkeeping mode it is usual for the bookkeeping agent to fetch the material bill, judge the type of the bill, then write and input voucher information into the bookkeeping software. The bookkeeping agent subsequently hands over the material bill, and generates the relevant business report by means of the bookkeeping software after the material bill and voucher information have been examined by the examining personnel. In such a traditional report generation mode, since data in the report is manually input, there is potentiality for data error and the manual data input also takes long time and causes low efficiency in report generation.
SUMMARY OF THE INVENTION

[0003] In view of the above, there is an urgent need to provide a business report generating method, a business report generating device, a computer equipment and a storage medium capable of enhancing generation efficiency of business reports to address the aforementioned technical problems.

[0004] Proposed is a business report generating method, which comprises:
obtaining a report template of the business report, wherein each cell in a worksheet of the report template is provided with first identification information and the worksheet of the report template is provided with a calculation formula of business to be processed in the business report, and the calculation formula is employed for basing on the first identification information of each cell to identify the specific cell and for determining calculation relation between the cells; obtaining business data of the business report, and basing on the first identification information of each cell to load the business data into the cell of the worksheet; and basing on the calculation formula of the business to be processed to obtain the business data of the corresponding cell in the worksheet and performing data processing on the obtained business data, and basing on data processing result to generate the business report.

[0005] In one of the embodiments, the worksheet of the report template is further provided with plural regions according to business information of the business to be processed, and cells of different regions are used to be written in business data of different business attributes.

[0006] In one of the embodiments, the step of obtaining a report template of the business report includes: sending a report template obtaining request to a server side, and the report template obtaining request being employed for requesting to obtain a report template of the latest version; receiving the report template of the latest version issued by the server side;
and obtaining the report template of the latest version, and taking the report template of the latest version as the report template of the business report.

[0007] In one of the embodiments, prior to the step of obtaining business data of the business report is included the following: confirming a component triggered in a spreadsheet client side of the business report; basing on the triggered component to send a data obtaining request to background, and the data obtaining request being employed for requesting to obtain business data to which the triggered component corresponds; and receiving the business data to which the triggered component corresponds sent by the background.

[0008] In one of the embodiments, a business report generating method further comprises:
receiving second identification information of the business data of the business report sent by the background; wherein the step of basing on the first identification information of each cell to load the business data into the cell of the worksheet includes:
matching the second identification information with the first identification information, and basing on matching result to load the business data into the cell of the worksheet.

[0009] In one of the embodiments, the mode for the background to obtain the business data to which the triggered component corresponds includes the following: the background sets up plural preset fields of a business bookkeeping subject; the background bases on the plural preset fields to generate bookkeeping voucher templates of plural business types; the background receives bill information relevant to the business report from a system channel of the business type to which the business report corresponds; the background writes the bill information in the bookkeeping voucher template of the corresponding business type, and obtains a bookkeeping voucher, in which is included the business data of the business report; and the background obtains the business data to which the triggered component corresponds from the bookkeeping voucher.

[0010] In one of the embodiments, the business data is data relevant to tax declaration, the business report is a bookkeeping report, and a business report generating method further comprises: setting up completion identification of the business report when it is determined that the business report has been generated; and initiating robotic process automation software when the completion identification is identified, so as to use the robotic process automation software to read the business data in the business report for automatic tax declaration.

[0011] Proposed is a business report generating device, which comprises: a first obtaining module, for obtaining a report template of the business report, wherein each cell in a worksheet of the report template is provided with first identification information and the worksheet of the report template is provided with a calculation formula of business to be processed in the business report, and the calculation formula is employed for basing on the first identification information of each cell to identify the specific cell and for determining calculation relation between the cells; a second obtaining module, for obtaining business data of the business report, and basing on the first identification information of each cell to load the business data into the cell of the worksheet; and a generating module, for basing on the calculation formula of the business to be processed to obtain the business data of the corresponding cell in the worksheet and performing data processing on the obtained business data, and basing on data processing result to generate the business report.

[0012] Proposed is a computer equipment comprising a memory, a processor and a computer program stored on the memory and executable on the processor, and the method steps according to anyone of the aforementioned embodiments are realized when the processor executes the computer program.

[0013] Proposed is a computer readable storage medium storing thereon a computer program, and the computer program realizes the method steps according to anyone of the aforementioned embodiments upon execution by a processor.

[0014] In the aforementioned business report generating method and device, computer equipment and storage medium, each cell in the worksheet of the report template is provided with first identification information, while the worksheet is provided with a calculation formula of business to be processed. The business data can be loaded into the cell of the worksheet of the report template through the first identification information of each cell. At the same time, it is also possible to perform data processing on the business data loaded into the worksheet through the calculation formula of the worksheet of the report template to obtain the business report of the business to be processed.
Accordingly, business data is automatically input into the report template without the need for manual input, and it is further possible to automatically process business data of business to be processed in the report template, and to automatically generate the business report, thus greatly lowering the probability of data error engendered in the process of report generation, and enhancing the generation efficiency of business reports.
BRIEF DESCRIPTION OF THE DRAWINGS

[0015] Fig. 1 is a view illustrating the environment in which a business report generating method according to an embodiment is applied;

[0016] Fig. 2 is a flowchart schematically illustrating a business report generating method according to an embodiment;

[0017] Fig. 3 is a view schematically illustrating interface display of a bookkeeping voucher template according to an embodiment;

[0018] Fig. 4 is a flowchart schematically illustrating robotic process automation software executing automatic tax declaration according to an embodiment;

[0019] Fig. 5 is a view schematically illustrating the system framework of an automatic tax declaration flow according to an embodiment;

[0020] Fig. 6 is a block diagram illustrating the structure of a business report generating device according to an embodiment; and

[0021] Fig. 7 is a view illustrating the internal structure of a computer equipment according to an embodiment.

DETAILED DESCRIPTION OF THE INVENTION

[0022] To make more lucid and clear the objectives, technical solutions and advantages of the present application, the present application is described in greater detail below with reference to the accompanying drawings and embodiments. As should be understood, the specific embodiments as described here are merely meant to explain the present application, rather than to restrict the present application.

[0023] The present application provides a business report generating method that is applied in the environment as shown in Fig. 1, in which the terminal is used to execute the business report generating method according to the present application. As shown in Fig. 1, the terminal may be desktop computer 102, portable computer 104 and mobile phone 106.
Specifically, on the terminal is installed a client side for processing the business report generating method. The client side may be a spreadsheet client side. Server cluster 202 is a background server side to which the terminal corresponds, and is used for providing the terminal with data information needed to generate business report.
Specifically, server cluster 202 provides the terminal with a report template of the business report and business data of the business report. The terminal obtains the report template of the business report, each cell in the worksheet of the report template is provided with first identification information and the worksheet of the report template is provided with a calculation formula of business to be processed in the business report, the calculation formula is employed for basing on the first identification information of each cell to identify the specific cell and for determining calculation relation between the cells, business data of the business report is obtained at the same time, the business data is loaded into the cell of the worksheet according to the first identification information of each cell, business data of the corresponding cell in the worksheet is then obtained according to the calculation formula of the business to be processed and data processing is performed on the obtained business data, and the data processing result is based to generate the business report.
Therefore, automatic generation of business report is realizable at the terminal.

[0024] In one embodiment, as shown in Fig. 2, there is provided a business report generating method, which is explained by way of its being applied in the terminal shown in Fig. 1 for example, and which comprises the steps described below.

[0025] S102 ¨ obtaining a report template of the business report, wherein each cell in a worksheet of the report template is provided with first identification information and the worksheet of the report template is provided with a calculation formula of business to be processed in the business report, and the calculation formula is employed for basing on the first identification information of each cell to identify the specific cell and for determining calculation relation between the cells.

[0026] In this embodiment, on the terminal is installed a self-developed VSTO
(Visual Studio Tool for Office, Visual Studio toolkit) plug-in component, and an Excel-based Excel client side is generated after installation is complete. The Excel client side is activated, and a newly added user-defined menu is displayed in the Excel menu bar, including such options as "selecting enterprise", "loading voucher data", and "generating report", etc. The business report is of the Excel format, and the template of the business report is also an Excel-based spreadsheet template.

[0027] The report template of the business report can be one that receives what the background sends by the mode of sending a request to the background server side. Each cell in the worksheet of the report template is provided with first identification information. The first identification information of each cell is for the unique identification of the corresponding cell. The first identification information can be the remark information of each cell. If a certain cell A5 is remarked as "userId", "userId" will be the first identification information of this cell. Moreover, the worksheet of the report template is provided with a calculation formula of business to be processed in the business report, and the calculation formula is employed for basing on the first identification information of each cell to identify the specific cell and for determining calculation relation between the cells. The calculation formula of the business to be processed can be set through an underlying formula computing engine of the client side. Specifically, the calculation formula can be one that is set up between cells self-contained by the Excel client side. The Excel underlayer provides a set of formula computing engines, as long as the Excel user inputs a statement that conforms to the Excel formula syntax in a cell, the formula computing engine will calculate the result of the formula and display it in the cell. Take a simple summation formula for example: =SUM(Al:A5). Once this formula is input in an A6 cell, the sum of Al-A5 will be obtained. The calculation formula can also be set up across sheet labels.

[0028] S104 ¨ obtaining business data of the business report, and basing on the first identification information of each cell to load the business data into the cell of the worksheet.

[0029] In this embodiment, the business data of the business report can be stored in the background server side. The client side of the terminal sends a data obtaining request to the background server side for requesting to obtain the business data of the business report.
When the terminal receives the business data of the business report, the first identification information of each cell in the report template is confirmed, and the business data is loaded into the cell of the worksheet according to the first identification information. For instance, the business data is json data. After the client side on the terminal obtains the business data, the first identification information is identified as the cell of "userId"
according to key:
userId of json data, the value 'John Doe' of j son data is put inside this cell, and loading of business data into the cell is completed.

[0030] S106 - basing on the calculation formula of the business to be processed to obtain the business data of the corresponding cell in the worksheet and performing data processing on the obtained business data, and basing on data processing result to generate the business report.

[0031] In this embodiment, when the client side on the terminal completes the operation of loading the business data into the cell of the worksheet, it is further possible to obtain the business data of the corresponding cell in the worksheet according to the calculation formula of the business to be processed in the worksheet and to perform data processing on the obtained business data. For instance, after =SUM(A 1 :A5) is set in the A6 cell, a certain relation is established among cells A 1 -A5. Automatic variation in the value of A6 cell follows variations in the values of cells Al -A5. After it is identified through the first identification information of each cell that the cell is loaded with business data, A6 is automatically derivable according to the calculation formula as long as A6 is provided with a calculation formula. Hence, a business report to which the business to be processed corresponds can be generated after data processing of the business to be processed is completed.

[0032] In the aforementioned business report generating method, each cell in the worksheet of the report template is provided with first identification information, while the worksheet is provided with a calculation formula of business to be processed. The business data can be loaded into the cell of the worksheet of the report template through the first identification information of each cell. At the same time, it is also possible to perform data processing on the business data loaded into the worksheet through the calculation formula of the worksheet of the report template to obtain the business report of the business to be processed. Accordingly, business data is automatically input into the report template without the need for manual input, and it is further possible to automatically process business data of business to be processed in the report template, and to automatically generate the business report, thus greatly lowering the probability of data error engendered in the process of report generation, and enhancing the generation efficiency of business reports.

[0033] In one embodiment, the worksheet of the report template is further provided with plural regions according to business information of the business to be processed, and cells of different regions are used to be written in business data of different business attributes.

[0034] In this embodiment, the business information of the business to be processed includes plural types of business attribute information. Formats of business data to which the different business attributes correspond are different. Different regions of the worksheet are provided to be written in business data of different business attributes, so that the worksheet of the report template can be written in business data of different business attributes of business to be processed, whereby is realized automatic writing-in of business data by the report template.

[0035] Specifically, the worksheet is divided into one or more region(s) according to actual business information. For instance, cells in section Al-H1 are taken as one region to display a simple key value pair k-v, for example, Username (k): John Doe(v). Age(k):
18(v).
Gender(k): Male(v). Business information of this region is of a one-versus-one relation.
For example, one person only has one name, one age, one gender. For another example, cells in sections A2-H2, A3-H3, A4-H4... are taken as one region to display business information of a one-versus-many relation. For instance, these cells are used to display work experience of John Doe, and work experience may be in many lines. Every line contains time of entry, work unit, post, etc. These pieces of business information are characterized in that every person may have plural lines of work experience, and attributes of every line are identical.

[0036] Accordingly, providing the worksheet of the report template with plural regions to be written in business data of different business attributes according to business information of the business to be processed makes it better to match with formats of business data, and achieves automatic reception of business data by the use of the worksheet of the report template.
1.0

[0037] In one embodiment, step S102 includes: sending a report template obtaining request to a server side, and the report template obtaining request being employed for requesting to obtain a report template of the latest version; receiving the report template of the latest version issued by the server side; and obtaining the report template of the latest version, and taking the report template of the latest version as the report template of the business report.

[0038] In this embodiment, the server side provides the report template to the terminal of each client side. When the terminal requests the server side to obtain the report template of the latest version, the server side determines the version number of the report template of the terminal, and bases on the version number to determine whether the report template is of the latest version. If not, the server side sends a report template of the latest version to the terminal. After the terminal receives the report template of the latest version issued by the server side, the report template of the latest version is taken as the report template of the business report.

[0039] Report templates stored at the server side can be obtained through uploading by any terminal that makes report templates. After the server side receives report templates uploaded by any terminal, the report templates are set with version information. The server side identifies the various report templates according to their version information. When any terminal requests the server side to obtain the report template of the latest version, the server side may firstly obtain the version information of the report template currently used by the terminal to determine whether the report template used by the terminal is of the latest version, if not, the server side issues the report template of the latest version to the terminal.
Therefore, the report template of the terminal is compatible with various updated data types or business data of business to be processed whose data format has been changed, whereby is further realized automatic reading of business data.

[0040] In one embodiment, prior to step S104 is further included the following: confirming a component triggered in a spreadsheet client side of the business report;
basing on the triggered component to send a data obtaining request to background, and the data obtaining request being employed for requesting to obtain business data to which the triggered component corresponds; and receiving the business data to which the triggered component corresponds sent by the background.

[0041] In this embodiment, the terminal makes the business report using spreadsheet client side.
The spreadsheet client side can be an Excel client side. After the terminal downloads the report template, the user may trigger a corresponding component at the display interface of the spreadsheet client side, and the terminal bases on the triggered component to send to the background a data obtaining request requesting to obtain the business data to which the triggered component corresponds. The background may be a server side according to the aforementioned embodiments, and may as well be another service platform independent of the aforementioned server side. The background stores therein business data of business to be processed, and the business data may be voucher data of json format.
Specifically, the corresponding component triggered by the user on the display interface may be a component of the business data indicative of a certain month of a certain enterprise. In this case, the terminal sends the data obtaining request to the server side in http mode, so as to obtain the business data of the certain month of the certain enterprise.
Accordingly, precision in automatic loading of business data can be enhanced and efficiency of business data loading can be improved.

[0042] In one embodiment, prior to step S104 is further included the following: receiving second identification information of the business data of the business report sent by the background. Step S104 includes: matching the second identification information with the first identification information, and basing on matching result to load the business data into the cell of the worksheet.

[0043] In this embodiment, when the background stores business data of the business report, associated second identification information is provided to each business data to identify the uniquely corresponding business data. When the terminal requests to obtain business data, the second identification information and the business data are sent to the terminal.
The terminal performs matching check on the second identification information and the first identification information, and loads the successfully matched business data into the corresponding cell. For instance, the client side sends an http obtaining data request.
Business data is returned in json format. The business data is: fuserId:'001, username:
'John Doe'}, after receiving the business data, the client side bases on key:
userId of json data to match the cell remarked "userId" in the cells, and loads the value "John Doe" into this cell, in which key: userId is the second identification information, and the remark "userId" in the cell is the first identification information. Thus, automatic and precise loading of business data is realized.

[0044] In one embodiment, the mode for the background to obtain the business data to which the triggered component corresponds includes the following: the background sets up plural preset fields of a business bookkeeping subject; the background bases on the plural preset fields to generate bookkeeping voucher templates of plural business types; the background receives bill information relevant to the business report from a system channel of the business type to which the business report corresponds; the background writes the bill information in the bookkeeping voucher template of the corresponding business type, and obtains a bookkeeping voucher, in which is included the business data of the business report.
The background obtains the business data to which the triggered component corresponds from the bookkeeping voucher.

[0045] In this embodiment, the background stores therein business data of various business to be processed, and the business data can be data that is recorded in the bookkeeping voucher to which the bill information corresponds. Specifically, the background sets up plural preset fields of a business bookkeeping subject. For instance, basic master data is created. The background initializes business types, and newly creates a bookkeeping subject list. Further, such fields frequently used by the bill as "amount of tax", "train date", "train number" and "sum" etc. are initialized. Moreover, the background bases on the plural preset fields to generate bookkeeping voucher templates of plural business types. For instance, referring to what is shown in Fig. 3, bookkeeping voucher templates are correlated under business types. A bookkeeping voucher template contains bookkeeping subject, accounting dimension, debtor and creditor, and value field etc., of which "value field"
is used to correlate with nominal value information of the bill identified by OCR, such as "train date"
and "sum" in the nominal value.

[0046] Finally, the background receives bill information relevant to the business report from a system channel of the business type to which the business report corresponds, writes the bill information in the bookkeeping voucher template of the corresponding business type, and obtains a bookkeeping voucher, in which is included the business data of the business report. Specifically, the operating personnel scans the material bill to generate a scanned copy of the bill picture, and introduces the scanned copy to the background according to the system channel of the business type. The background automatically identifies the image through previous data accumulation and analysis in cooperation with OCR
technique, and automatically generates business data under different business types.
Moreover, the background bases on OCR technique to identify nominal value information of bills and bill types, and invokes bookkeeping voucher templates, to which business types correspond, to automatically fill the fields in the bill information into the voucher template to generate the bookkeeping voucher. Finally, data in the bookkeeping voucher is stored as business data in j son format. When any terminal requests to obtain business data, the corresponding business data in json format is read according to the data obtaining request, and issues the read business data to the sender side of the data obtaining request.
Accordingly, the background completes storage of business data, manual input of data information in the bill is dispensed with in the process of generating the corresponding business report, and the terminal can directly receive business data sent by the background, whereby is realized automatic loading of business data.

[0047] In one embodiment, the business data is data relevant to tax declaration, the business report is a bookkeeping report. The following is further included after step S106: setting up completion identification of the business report when it is determined that the business report has been generated; and initiating robotic process automation software when the completion identification is identified, so as to use the robotic process automation software to read the business data in the business report for automatic tax declaration.

[0048] In this embodiment, the Excel client side of the terminal automatically loads the well made Excel report template. The user may trigger on the display interface of the Excel client side to select enterprise and month, the terminal reads the business data of the background via http mode, and the business data can be voucher data in json format. The dispersed business data is loaded into cells of different sheet pages of the Excel report template. After completion of business data loading, the Excel report template sets up a calculation formula for automatic computation of the cells to generate a financial report needed for payment of tax. After the business report is generated, the user may click the option "storing report" of the user-defined menu, and stores the business report in Excel format in a file service system OSS of the background. The report content, namely the business data of the business report, is written back into the database of the server side, for client sides of other machines to read.

[0049] Specifically, when automatic generation of data of bookkeeping vouchers in all backgrounds is completed, the completion identification is set as true. When the system regularly detects the completion identification of business data as true, RPA
(Robotic Process Automation software) is wakened, and RPA automatically completes such operations at the background as opening the Excel client side, selecting enterprise, month, loading data, and storing data etc., without manual interference, so that business report is automatically generated.

[0050] When it is determined that the business report is generated, completion identification of the business report can be set up to identify that generation of the business report is complete. Robotic process automation software is initiated when the completion identification is identified, so as to use the robotic process automation software to read the business data in the business report for automatic tax declaration.
Specifically, referring to what is shown in Fig. 4, the robotic process automation software analyzes and packages business report, and regularly generates tax declaration data of a specific format to which the business report corresponds. After data preparation is complete, tax bureau tax declaring interfaces are invoked to perform tax declaration, declaration of deduction, payment voucher, and payment record enquiry with respect to various tax categories. Since the tax declaration interface and declaration of deduction interface do not return the declaration results in real time, the robotic process automation software makes use of the polling mode to invoke and inquire the API interface to obtain the declaration results according to specified frequencies, the declaration results are scanned for analysis, and items concerning declaration failure and deduction failure are applied anew for declaration and deduction after a certain time according to rules specified by the system.

[0051] The tax declaration interface includes the following interfaces:

[0052] Declaration registering interface: maintaining basic information, and information associated with tax ID. These are preconditions whose basic information should be perfected for subsequent invoking of other interfaces relevant to declaration.

[0053] Declaration initializing interface: initiating initializing request.

[0054] Declaration submitting interface: for use by client to submit declaration request message.

[0055] Declaration state inquiring interface: for state enquiry after submission of declaration, this interface likewise supporting initializing, nullifying, and inquiring payment state.

[0056] Payment declaration interface: for performing payment operation after successful declaration.

[0057] Inventory list for declaration interface: for obtaining declaration list information of user within current declaration period.

[0058] After declaration and payment are successful, the system informs the operating personnel of the tax declaration result, and completes tax declaration and payment of the current month. After tax declaration and payment are completed, bookkeeping bills, vouchers, tax declaration details and relevant report documents of the current month are arranged and placed in files to facilitate subsequent enquiry and submission of reports.

[0059] In addition, on the basis of the aforementioned plural embodiments, in the entire automated procedure ranging from automatic identification of bills, generation of vouchers, generation of reports, automatic tax declaration to placement in files, the system automatically sends the execution results of the various phases via SMS
platform and internal communication tools, thus achieving quality check and abnormality monitor &
control in the entire procedure. Full-automation and semi-automation are realized according to business requirements, and the procedure is controllable.

[0060] In one embodiment, the system framework of an automatic tax declaration flow according to the aforementioned embodiment can be referred from Fig. 5, and the following techniques are used for realization.

[0061] The system adopts B/S architecture for implementation, and server side application is realized using a framework and a technology stack that conform to J2EE
technical specifications, for example such technology stack as SpringBoot/Spring MVC+MyBatis.

[0062] Python is used as the technical architecture to realize RPA (Robotic Process Automation software), user operation is imitated, and definable, highly repetitive, rule-based, conventional operations are automated.

[0063] Timer, Quartz of Java JDK, Task of Spring, or AP Scheduler of Python are used to realize timed automatic execution of tasks.

[0064] OCR bill character recognition technique is relevantly recommended for use as the OCR
technique, making it possible to optimize specific typefaces and printing formats of various bills, and achieving a field precision as high as 98% under an integrated scenario, in which the precision in the four essentials concerning value-added invoices and taxi fares is up to 99.9%.

[0065] FTP/HDFS file storing technique is used to store and file bill pictures and files. It is also possible to base on the amount of business to select to use a commercially available file storing scheme, such as the file storing system NAS, the file storing system CFS, and the mass storing system (KODO), etc.

[0066] The tax bureau tax declaring interface makes use of interface tax declaration related API, including declaration registration, declaration submission, declaration enquiry, declaration for payment, and payment enquiry, etc.

[0067] A relational database (such as Oracle/DB2/SQLServer/MySQL, etc.) is used to serve as permanent storage of data, and it is responsible for storing entity definitions, rule configurations, template data, task projects, flow procedure, business procedural data, and filing of data of various items of the system.

[0068] To avoid single point of failure, applications can be deployed in a cluster, and soft/hard load balancing is performed via Apache/Nginx/F5, etc. Considering from the viewpoint of cost and the amount of business of the business data, it generally suffices to use Apache/Nginx to perform soft load balancing.

[0069] In summary, it is usual for a traditional entrusted bookkeeper to manually fill in forms and declare tax at night. It takes at least three to four hours from voucher input to completion of tax declaration, the tax declaration software should be repetitively signed in, user account and password should be repetitively clicked/input, and data is extracted from the income statistical table. The entire procedure might lead to erroneous extraction of data, and such operations as line-by-line comparison of taxing standards, multiple clicks for zero fill/storage, repetitive clicks for uploading reports/repetitive clicks for printing, etc. After adopting the generation of business reports according to the present application, it is possible to use electronic images for bookkeeping, bill information is collected through the images and uploaded to the background, the background automatically generates a bookkeeping voucher to which the bill corresponds, a corresponding report template is then generated, and finally the terminal can obtain the report template and the business data of the bookkeeping voucher through the background to hence generate a business report used for tax declaration. Except for the examination of the voucher, full-automation is realized from voucher input, report generation, tax declaration, and declaration for deduction.
Manual operation is reduced, precision in business data input is enhanced and efficiency of tax declaration that is based on the business data is improved.

[0070] As should be understood, although the various steps in the flowcharts are sequentially displayed as indicated by arrows, these steps are not necessarily executed in the sequences indicated by arrows. Unless otherwise explicitly noted in this paper, execution of these steps is not restricted by any sequence, as these steps can also be executed in other sequences (than those indicated in the drawings). Moreover, at least partial steps in the drawings may include plural sub-steps or multi-phases, these sub-steps or phases are not necessarily completed at the same timing, but can be executed at different timings, and these sub-steps or phases are also not necessarily sequentially performed, but can be performed in turns or alternately with other steps or with at least some of sub-steps or phases of other steps.

[0071] The present application further provides a business report generating device, as shown in Fig. 6, the device comprises a first obtaining module 10, a second obtaining module 20 and a generating module 30. The first obtaining module 10 is employed for obtaining a report template of the business report, wherein each cell in a worksheet of the report template is provided with first identification information and the worksheet of the report template is provided with a calculation formula of business to be processed in the business report, and the calculation formula is employed for basing on the first identification information of each cell to identify the specific cell and for determining calculation relation between the cells. The second obtaining module 20 is employed for obtaining business data of the business report, and basing on the first identification information of each cell to load the business data into the cell of the worksheet. The generating module 30 is employed for basing on the calculation formula of the business to be processed to obtain the business data of the corresponding cell in the worksheet and performing data processing on the obtained business data, and basing on data processing result to generate the business report.

[0072] In one of the embodiments, the worksheet of the report template is further provided with plural regions according to business information of the business to be processed, and cells of different regions are used to be written in business data of different business attributes.

[0073] In one of the embodiments, the first obtaining module 10 is specifically further employed for sending a report template obtaining request to a server side, and the report template obtaining request being employed for requesting to obtain a report template of the latest version; receiving the report template of the latest version issued by the server side;
and obtaining the report template of the latest version, and taking the report template of the latest version as the report template of the business report.

[0074] In one of the embodiments, the business report generating device further comprises a first receiving module (not shown in Fig. 6) for confirming a component triggered in a spreadsheet client side of the business report; basing on the triggered component to send a data obtaining request to background, and the data obtaining request being employed for requesting to obtain business data to which the triggered component corresponds; and receiving the business data to which the triggered component corresponds sent by the background.

[0075] In one of the embodiments, the business report generating device further comprises a second receiving module (not shown in Fig. 6) for receiving second identification information of the business data of the business report sent by the background. The second obtaining module 20 is specifically employed for matching the second identification information with the first identification information, and basing on matching result to load the business data into the cell of the worksheet.

[0076] In one of the embodiments, the mode for the background to obtain the business data to which the triggered component corresponds includes the following: the background sets up plural preset fields of a business bookkeeping subject; the background bases on the plural preset fields to generate bookkeeping voucher templates of plural business types; the background receives bill information relevant to the business report from a system channel of the business type to which the business report corresponds; the background writes the bill information in the bookkeeping voucher template of the corresponding business type, and obtains a bookkeeping voucher, in which is included the business data of the business report; and the background obtains the business data to which the triggered component corresponds from the bookkeeping voucher.

[0077] In one of the embodiments, the business data is data relevant to tax declaration, the business report is a bookkeeping report, and the business report generating device further comprises an automatic tax declaring module (now shown in Fig. 6) for setting up completion identification of the business report when it is determined that the business report has been generated; and initiating robotic process automation software when the completion identification is identified, so as to use the robotic process automation software to read the business data in the business report for automatic tax declaration.

[0078] Specific definitions relevant to the business report generating device may be inferred from the aforementioned definitions to the business report generating method, while no repetition is made in this context. The various modules in the aforementioned business report generating device can be wholly or partly realized via software, hardware, and a combination of software with hardware. The various modules can be embedded in the form of hardware in a processor in a computer equipment or independent of any computer equipment, and can also be stored in the form of software in a memory in a computer equipment, so as to facilitate the processor to invoke and perform operations corresponding to the aforementioned various modules.

[0079] In one embodiment, a computer equipment is provided, the computer equipment can be a terminal, and its internal structure can be as shown in Fig. 7. The computer equipment comprises a processor, a memory, a network interface, a display screen and an input means connected to each other via a system bus. The processor of the computer equipment is employed to provide computing and controlling capabilities. The memory of the computer equipment includes a nonvolatile storage medium, and an internal memory. The nonvolatile storage medium stores therein an operating system and a computer program. The internal memory provides environment for the running of the operating system and the computer program in the nonvolatile storage medium. The network interface of the computer equipment is employed to connect to a server side via network for communication. The computer program realizes a business report generating method when it is executed by a processor. The display screen of the computer equipment is a liquid crystal display screen or an E-ink Vizplex, and the input means of the computer equipment can be a touch layer covering on the display screen, can also be a press key, a trackball or a touch control pad disposed on the housing of the computer equipment, and can further be externally connected keypad, touch control pad or mouse.

[0080] As understandable to persons skilled in the art, the structure illustrated in Fig. 7 is merely a block diagram of partial structure relevant to the solution of the present application, and does not constitute any restriction to the computer equipment on which the solution of the present application is applied, as the specific computer equipment may comprise component parts that are more than or less than those illustrated in Fig. 7, or may combine certain component parts, or may have different layout of component parts.

[0081] In one embodiment, there is provided a computer equipment that comprises a memory, a processor and a computer program stored on the memory and operable on the processor, and the processor realizes the following steps when it executes the computer program:
obtaining a report template of the business report, wherein each cell in a worksheet of the report template is provided with first identification information and the worksheet of the report template is provided with a calculation formula of business to be processed in the business report, and the calculation formula is employed for basing on the first identification information of each cell to identify the specific cell and for determining calculation relation between the cells; obtaining business data of the business report, and basing on the first identification information of each cell to load the business data into the cell of the worksheet; and basing on the calculation formula of the business to be processed to obtain the business data of the corresponding cell in the worksheet and performing data processing on the obtained business data, and basing on data processing result to generate the business report.

[0082] In one of the embodiments, the worksheet of the report template is further provided with plural regions according to business information of the business to be processed, and cells of different regions are used to be written in business data of different business attributes.

[0083] In one of the embodiments, when the processor executes the computer program to realize the aforementioned step of obtaining a report template of the business report, the following steps are specifically realized: sending a report template obtaining request to a server side, and the report template obtaining request being employed for requesting to obtain a report template of the latest version; receiving the report template of the latest version issued by the server side; and obtaining the report template of the latest version, and taking the report template of the latest version as the report template of the business report.

[0084] In one of the embodiments, when the processor executes the computer program, the following steps are further realized: confirming a component triggered in a spreadsheet client side of the business report; basing on the triggered component to send a data obtaining request to background, and the data obtaining request being employed for requesting to obtain business data to which the triggered component corresponds; and receiving the business data to which the triggered component corresponds sent by the background.

[0085] In one of the embodiments, when the processor executes the computer program, the following step is further realized: receiving second identification information of the business data of the business report sent by the background. When the processor executes the computer program to realize the aforementioned step of basing on the first identification information of each cell to load the business data into the cell of the worksheet, the following steps are specifically realized: matching the second identification information with the first identification information, and basing on matching result to load the business data into the cell of the worksheet.

[0086] In one of the embodiments, the mode for the background to obtain the business data to which the triggered component corresponds includes the following: the background sets up plural preset fields of a business bookkeeping subject; the background bases on the plural preset fields to generate bookkeeping voucher templates of plural business types; the background receives bill information relevant to the business report from a system channel of the business type to which the business report corresponds; the background writes the bill information in the bookkeeping voucher template of the corresponding business type, and obtains a bookkeeping voucher, in which is included the business data of the business report; and the background obtains the business data to which the triggered component corresponds from the bookkeeping voucher.

[0087] In one of the embodiments, the business data is data relevant to tax declaration, the business report is a bookkeeping report, and the following steps are further realized when the processor executes the computer program: setting up completion identification of the business report when it is determined that the business report has been generated; and initiating robotic process automation software when the completion identification is identified, so as to use the robotic process automation software to read the business data in the business report for automatic tax declaration.

[0088] In one embodiment, there is provided a computer readable storage medium storing thereon a computer program, and the following steps are realized when the computer program is executed by a processor: obtaining a report template of the business report, wherein each cell in a worksheet of the report template is provided with first identification information and the worksheet of the report template is provided with a calculation formula of business to be processed in the business report, and the calculation formula is employed for basing on the first identification information of each cell to identify the specific cell and for determining calculation relation between the cells; obtaining business data of the business report, and basing on the first identification information of each cell to load the business data into the cell of the worksheet; and basing on the calculation formula of the business to be processed to obtain the business data of the corresponding cell in the worksheet and performing data processing on the obtained business data, and basing on data processing result to generate the business report.

[0089] In one of the embodiments, the worksheet of the report template is further provided with plural regions according to business information of the business to be processed, and cells of different regions are used to be written in business data of different business attributes.

[0090] In one of the embodiments, when the computer program is executed by a processor to realize the aforementioned step of obtaining a report template of the business report, the following steps are specifically realized: sending a report template obtaining request to a server side, and the report template obtaining request being employed for requesting to obtain a report template of the latest version; receiving the report template of the latest version issued by the server side; and obtaining the report template of the latest version, and taking the report template of the latest version as the report template of the business report.

[0091] In one of the embodiments, when the computer program is executed by a processor, the following steps are further realized: confirming a component triggered in a spreadsheet client side of the business report; basing on the triggered component to send a data obtaining request to background, and the data obtaining request being employed for requesting to obtain business data to which the triggered component corresponds; and receiving the business data to which the triggered component corresponds sent by the background.

[0092] In one of the embodiments, when the computer program is executed by a processor, the following step is further realized: receiving second identification information of the business data of the business report sent by the background. When the computer program is executed by a processor to realize the aforementioned step of basing on the first identification information of each cell to load the business data into the cell of the worksheet, the following steps are specifically realized: matching the second identification information with the first identification information, and basing on matching result to load the business data into the cell of the worksheet.

[0093] In one of the embodiments, the mode for the background to obtain the business data to which the triggered component corresponds includes the following: the background sets up plural preset fields of a business bookkeeping subject; the background bases on the plural preset fields to generate bookkeeping voucher templates of plural business types; the background receives bill information relevant to the business report from a system channel of the business type to which the business report corresponds; the background writes the bill information in the bookkeeping voucher template of the corresponding business type, and obtains a bookkeeping voucher, in which is included the business data of the business report; and the background obtains the business data to which the triggered component corresponds from the bookkeeping voucher.

[0094] In one of the embodiments, the business data is data relevant to tax declaration, the business report is a bookkeeping report, and the following steps are further realized when the computer program is executed by a processor: setting up completion identification of the business report when it is determined that the business report has been generated; and initiating robotic process automation software when the completion identification is identified, so as to use the robotic process automation software to read the business data in the business report for automatic tax declaration.

[0095] As comprehensible to persons ordinarily skilled in the art, the entire or partial flows in the methods according to the aforementioned embodiments can be completed via a computer program instructing relevant hardware, the computer program can be stored in a nonvolatile computer-readable storage medium, and the computer program can include the flows as embodied in the aforementioned various methods when executed. Any reference to the memory, storage, database or other media used in the various embodiments provided by the present application can all include nonvolatile and/or volatile memory/memories.
The nonvolatile memory can include a read-only memory (ROM), a programmable ROM
(PROM), an electrically programmable ROM (EPROM), an electrically erasable and programmable ROM (EEPROM) or a flash memory. The volatile memory can include a random access memory (RAM) or an external cache memory. To serve as explanation rather than restriction, the RAM is obtainable in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), dual data rate SDRAM
(DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM

(SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct Rambus dynamic RAM (DRDRAM), and Rambus dynamic RAM (RDRAM), etc.

[0096] Technical features of the aforementioned embodiments are randomly combinable, while all possible combinations of the technical features in the aforementioned embodiments are not exhausted for the sake of brevity, but all these should be considered to fall within the scope recorded in the Description as long as such combinations of the technical features are not mutually contradictory.

[0097] The foregoing embodiments are merely directed to several modes of execution of the present application, and their descriptions are relatively specific and detailed, but they should not be hence misunderstood as restrictions to the inventive patent scope. As should be pointed out, persons with ordinary skill in the art may further make various modifications and improvements without departing from the conception of the present application, and all these should pertain to the protection scope of the present application.
Accordingly, the patent protection scope of the present application shall be based on the attached Claims

Claims

1. A business report generating method, characterized in comprising:
obtaining a report template of the business report, wherein each cell in a worksheet of the report template is provided with first identification information and the worksheet of the report template is provided with a calculation formula of business to be processed in the business report, and the calculation formula is employed for basing on the first identification information of each cell to identify the specific cell and for determining calculation relation between the cells;
obtaining business data of the business report, and basing on the first identification information of each cell to load the business data into the cell of the worksheet; and basing on the calculation formula of the business to be processed to obtain the business data of the corresponding cell in the worksheet and performing data processing on the obtained business data, and basing on data processing result to generate the business report.

2. The method according to Claim 1, characterized in that the worksheet of the report template is further provided with plural regions according to business information of the business to be processed, and that cells of different regions are used to be written in business data of different business attributes.

3. The method according to Claim 1, characterized in that the step of obtaining a report ternplate of the business report includes:
sending a report template obtaining request to a server side, and the report template obtaining request being employed for requesting to obtain a report template of the latest version;

receiving the report template of the latest version issued by the server side;
and obtaining the report template of the latest version, and taking the report template of the latest version as the report template of the business report.

4. The method according to Claim 1, characterized in that prior to the step of obtaining business data of the business report is included the following:
confirming a component triggered in a spreadsheet client side of the business report;
basing on the triggered component to send a data obtaining request to background, and the data obtaining request being employed for requesting to obtain business data to which the triggered component corresponds; and receiving the business data to which the triggered component corresponds sent by the background.

5. The method according to Claim 4, characterized in further comprising:
receiving second identification information of the business data of the business report sent by the background;
wherein the step of basing on the first identification information of each cell to load the business data into the cell of the worksheet includes:
matching the second identification information with the first identification information, and basing on matching result to load the business data into the cell of the worksheet.

6. The method according to Claim 4, characterized in that the mode for the background to obtain the business data to which the triggered component corresponds includes the following:
the background sets up plural preset fields of a business bookkeeping subject;

the background bases on the plural preset fields to generate bookkeeping voucher templates of plural business types;
the background receives bill information relevant to the business report from a system channel of the business type to which the business report corresponds;
the background writes the bill information in the bookkeeping voucher template of the corresponding business type, and obtains a bookkeeping voucher, in which is included the business data of the business report; and the background obtains the business data to which the triggered component corresponds from the bookkeeping voucher.

7. The method according to Claim 1, characterized in that the business data is data relevant to tax declaration, that the business report is a bookkeeping report, and that the method further comprises:
setting up completion identification of the business report when it is determined that the business report has been generated; and initiating robotic process automation software when the completion identification is identified, so as to use the robotic process automation software to read the business data in the business report for automatic tax declaration.

8. A business report generating device, characterized in comprising:
a first obtaining module, for obtaining a report template of the business report, wherein each cell in a worksheet of the report template is provided with first identification information and the worksheet of the report template is provided with a calculation formula of business to be processed in the business report, and the calculation formula is employed for basing on the first identification information of each cell to identify the specific cell and for determining calculation relation between the cells;
a second obtaining module, for obtaining business data of the business report, and basing on the first identification information of each cell to load the business data into the cell of the worksheet; and a generating module, for basing on the calculation formula of the business to be processed to obtain the business data of the corresponding cell in the worksheet and performing data processing on the obtained business data, and basing on data processing result to generate the business report.

9. A computer equipment, comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the method steps according to anyone of Claims 1 to 7 are realized when the processor executes the computer program.

10. A computer readable storage medium, storing a computer program thereon, characterized in that the computer program realizes the method steps according to anyone of Claims 1 to 7 upon execution by a processor.