Note : Les descriptions sont présentées dans la langue officielle dans laquelle elles ont été soumises.
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
1
CA 3129802 2021-11-02
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
2
CA 3129802 2021-11-02
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.
3
CA 3129802 2021-11-02
[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
4
CA 3129802 2021-11-02
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.
CA 3129802 2021-11-02
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.
6
CA 3129802 2021-11-02
[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
7
CA 3129802 2021-11-02
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.
8
CA 3129802 2021-11-02
[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
9
CA 3129802 2021-11-02
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
CA 3129802 2021-11-02
[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
11
CA 3129802 2021-11-02
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,
12
CA 3129802 2021-11-02
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,
13
CA 3129802 2021-11-02
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.
14
CA 3129802 2021-11-02
[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.
CA 3129802 2021-11-02
[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.
16
CA 3129802 2021-11-02
[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.
17
CA 3129802 2021-11-02
[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,
18
CA 3129802 2021-11-02
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
19
CA 3129802 2021-11-02
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
CA 3129802 2021-11-02
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
21
CA 3129802 2021-11-02
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
22
CA 3129802 2021-11-02
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,
23
CA 3129802 2021-11-02
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
24
CA 3129802 2021-11-02
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
CA 3129802 2021-11-02
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
26
CA 3129802 2021-11-02
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
27
CA 3129802 2021-11-02
(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
28
CA 3129802 2021-11-02
