CN109993642A - Financial bill analysis method and system - Google Patents
Financial bill analysis method and system Download PDFInfo
- Publication number
- CN109993642A CN109993642A CN201711458004.4A CN201711458004A CN109993642A CN 109993642 A CN109993642 A CN 109993642A CN 201711458004 A CN201711458004 A CN 201711458004A CN 109993642 A CN109993642 A CN 109993642A
- Authority
- CN
- China
- Prior art keywords
- bill
- information
- server
- data
- billing information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The embodiment of the present invention provides a kind of financial bill analysis method and system, wherein client generates electronic bill information, stores the electronic bill information of all generations to database, and upload electronic bill information to server;Server establishes bill fact table according to corresponding billing information from the corresponding billing information for acquiring the bill issued in set period of time in electronic bill information;According to the one or more parameters paid in unit information that user chooses, dimension table is generated;With the corresponding billing information in the parameter combination bill fact table in each dimension table, the result table of multiple and different types is generated.It avoids only electronic bill information and saves the plenty of time without management system management bring defect for client, a convenient and fast platform is provided to bill analysis work.
Description
Technical field
The present invention relates to data analyses, more particularly to a kind of financial bill analysis method and system.
Background technique
For the non-tax reciept of finance according to electronization, since financial electronic bill electronization is at the early-stage soon, for electronic ticket
It is not mature enough according to systematic management, history bill can not intuitively be shown, therefore lack to financial electronic bill
Management and analysis method.
Summary of the invention
The purpose of the embodiment of the present invention is that provide a kind of financial bill analysis method and system, this method passes through and will generate
Electronic bill is all uploaded to server, and is generated in dimension table and server by the server according to the parameter for selection
Data real-time table combines the result table for generating the related data that client needs, and may be implemented intuitively to show the data that client needs
Information saves the plenty of time that data, comparison data are scanned in server mass data for client.
To achieve the goals above, the embodiment of the present invention provides a kind of political affairs bill analysis method, this method comprises:
Client generates electronic bill information, stores the electronic bill information of all generations to database, and upload
The electronic bill information is to server;
The server is for performing the following operations:
From the corresponding billing information for acquiring the bill issued in set period of time in the electronic bill information, and according to this
Corresponding billing information establishes bill fact table;
According to the one or more parameters paid in unit information that user chooses, dimension table is generated;
With the parameter in each dimension table in conjunction with the corresponding billing information in the bill fact table, generate more
A different types of result table.
Optionally, this method further include:
The corresponding billing information is filtered cancel bill, filtering repeats bill, unified billing information format and
The data-optimized operation to correct wrong spellings, and institute is established according to the corresponding billing information Jing Guo the data-optimized operation
State bill fact table.
Optionally, the electronic bill information include it is following at least one: bill issues date, voucher code, bill number
Code pays in unit, payee, holds and receive unit, pay in the amount of money.
Optionally, it is described pay in unit information include it is following at least one: hold receive unit, hold receipts project, item amount, item
Mesh is made out an invoice quantity, item amount accounting, payee, financial organization, financial organization's secondary, administrative division, taxpayer's grade.
Optionally, the corresponding billing information for the bill issued in the acquisition set period of time includes: the acquisition of next day zero point
Issued bill all electronic bill information accordingly yesterday.
Optionally, this method further include:
The server is according to the electronic bill information or pays in relevant parameter in unit information and scans for;And
Corresponding search result data table is generated according to the search result of corresponding search condition, and according to described search result
Tables of data draws corresponding fiscal revenues statistical chart.
Optionally, this method further include:
The server is also used to appoint according in the bill fact table, the dimension table or described search result data table
Parameter in one table provides corresponding bill managing detailed catalogue.
Optionally, this method further include: data supplement, data correction are carried out to the data information in already present dimension table
Or data merge.
The embodiment of the present invention provides a kind of political affairs bill analysis system, which includes:
Client, for generating electronic bill and being uploaded to server;
Database, the electronic bill information generated for storing the client;And
Server is used for:
From the corresponding billing information for acquiring the bill issued in set period of time in the electronic bill information, and according to this
Corresponding billing information establishes bill fact table;
According to the one or more parameters paid in unit information that user chooses, dimension table is generated;And
It is more in conjunction with the corresponding billing information generation in the bill fact table with the parameter in each dimension table
A different types of result table.
Optionally, the server is also used to:
The corresponding billing information is filtered cancel bill, filtering repeats bill, unified billing information format and
The data-optimized operation to correct wrong spellings, and institute is established according to the corresponding billing information Jing Guo the data-optimized operation
State bill fact table.
Optionally, the electronic bill information include it is following at least one: bill issues date, voucher code, bill number
Code pays in unit, payee, holds and receive unit, pay in the amount of money.
Optionally, it is described pay in unit information include it is following at least one: hold receive unit, hold receipts project, item amount, item
Mesh is made out an invoice quantity, item amount accounting, payee, financial organization, financial organization's secondary, administrative division, taxpayer's grade.
Optionally, the corresponding billing information for the bill issued in the acquisition set period of time includes: the acquisition of next day zero point
Issued bill all electronic bill information accordingly yesterday.
Optionally, the server is also used to:
According to the electronic bill information or pays in relevant parameter in unit information and scanned in the database;With
And
Corresponding search result data table is generated according to the search result of corresponding search condition, and according to described search result
Tables of data draws corresponding fiscal revenues statistical chart.
Optionally, the server is also used to according to the bill fact table, the dimension table or described search number of results
According to the parameter in table any in table, corresponding bill managing detailed catalogue is provided.
Optionally, the server is also used to carry out data supplement, data to the data information in already present dimension table
Amendment or data merge.
Through the above technical solutions, being uploaded to server by the electronic bill information for generating client;The service
Device acquires the relevant information for the bill issued in set period of time in electronic bill information, and according to collected relevant information
Establish bill fact table;Dimension table is generated according to the parameter paid in unit information that user chooses, with the parameter in dimension table
The result table of client's needs can be generated in conjunction with the corresponding electronic bill information in bill fact table, which can be intuitive
The billing information that client needs to analyze is shown, only electronic bill information is avoided, carries out analyzer tube without management system
Bring defect is managed, saves the plenty of time for client, a convenient and fast platform is provided to bill analysis work.
The other feature and advantage of the embodiment of the present invention will the following detailed description will be given in the detailed implementation section.
Detailed description of the invention
Attached drawing is to further understand for providing to the embodiment of the present invention, and constitute part of specification, under
The specific embodiment in face is used to explain the present invention embodiment together, but does not constitute the limitation to the embodiment of the present invention.Attached
In figure:
Fig. 1 is a kind of flow diagram of financial bill analysis method provided in an embodiment of the present invention;
Fig. 2 is a kind of structural schematic diagram of financial bill analysis system provided in an embodiment of the present invention.
Specific embodiment
It is described in detail below in conjunction with specific embodiment of the attached drawing to the embodiment of the present invention.It should be understood that this
Locate described specific embodiment and be merely to illustrate and explain the present invention embodiment, is not intended to restrict the invention embodiment.
The noun of locality in embodiments of the present invention, in the absence of explanation to the contrary, used such as " upper and lower, left and right ",
" inside and outside ", " remote, close " refer to the direction with reference to attached drawing, and therefore, use direction term is for illustrating not to be to limit this hair
It is bright.
Fig. 1 shows a kind of flow diagram of financial bill analysis method provided in an embodiment of the present invention, such as Fig. 1 institute
Show, this method may include: that all information of financial bill are acquired by client, generate electronic bill information, wherein the electricity
Sub- billing information may include that bill issues the date, voucher code, note number, pays in unit, payee, holds and receive unit, pay
The money amount of money.The electronic bill information of generation is uploaded to server by the client, which can be set in financial organization, just
The analysis of financial bill is carried out by the server in financial organization staff.The client can also be by the electricity of generation simultaneously
Sub- billing information backs up to database.
The server acquires the corresponding bill for the bill issued in set period of time according to the electronic bill information received
Information establishes bill fact table.The corresponding billing information for the bill issued in the acquisition set period of time can be with are as follows: next day zero
Yesterday was issued bill all electronic bill information accordingly in point acquisition;It was opened yesterday for example, server can acquire in morning on next day
All billing informations of the bill of tool are created as bill fact table according to corresponding billing information, and such staff can pass through
Date easily inquires the related billing information for issuing bill on the date.The corresponding ticket for the bill issued in the set period of time
It is filtered according to for the bill in collected corresponding billing information is carried out the filtering of calcellation bill, repeats bill, unified billing information
The bill collection formed after format and the corrigendum of bill misspelling.It is filtered, is reduced by that will cancel bill, repeat bill
The data volume size of electronic bill information avoids system and carries out unnecessary operations, while saving the operating time.By electronic ticket
It is believed that the format that the format and financial organization in breath require carries out unification;For example, amount of money numerical value is unified, address format is unified,
In, 1000 (members) recorded in the electronic bill information collected can be changed to " 1000.00 (member) " or will be adopted
Collect the address Haidian District recorded in obtained electronic bill information and is revised as " Haidian District, Beijing City ".By by electronic bill information
The unification of middle format, convenient for search, the management to data.By the bill of misspelling in the electronic bill information collected into
Row corrigendum, avoids causing the misspelling bill being considered as invalid bill impact analysis result just due to bill misspelling
True property.For the off-line analysis mode in bill analysis the technical program, system's work-load is reduced, system performance is improved.It fills
Divide the data result that the generation of financial bill electronization is utilized, helps financial organization intuitively to acquire data, analysis data, greatly
Ground has helped the building-up work of the electronization of financial bill.
The server generates dimension table according to the one or more parameters paid in unit information that user chooses, wherein
Paying in unit information may include holding receive unit, hold receipts project, item amount, project billing quantity, item amount accounting, pay in
People, financial organization, financial organization's secondary, administrative division, taxpayer's grade classification.For example, unit information is paid in user's selection
In parameter be to hold receipts project, server is parameter formation dimension table to hold receipts project, this is held receipts project dimension table and is held with this
The relevant all bill fact tables of receipts project combine, and extract and hold the relevant all information of receipts project with this, and will hold receipts project and tie up
The parameter of degree table and all relevant informations of extraction, which carry out being aggregated to form result table, to be shown.If what user chose pays in unit
Information is multiple parameters, for example, user, which has chosen payee, item amount simultaneously and holds, receives these three parameters of unit, service
Device forms dimension table according to above three parameter, extracted from bill fact table simultaneously with payee, item amount and hold receipts
The relevant billing information of unit, and by the payee of above-mentioned dimension table, item amount and hold receive unit and extraction all phases
It closes billing information and carries out being aggregated to form result table and be shown.The number of parameters that unit information is paid in user's selection is unrestricted, can
To be chosen according to the use demand of user.Wherein, taxpayer's grade classification can be divided into according to taxpayer's credit grade
A class enterprise, B class enterprise and C class enterprise, A class enterprise can be to pay the expenses of taxation to be higher than the setting expenses of taxation, the enterprise without tax punishment, B
Class enterprise can be to pay the expenses of taxation to be lower than on the setting expenses of taxation and the minimum tax bearing rate as defined in the tax authority, have no tax punishment
Enterprise, C class enterprise can be occurred the tax punishment enterprise.
In embodiment, after forming dimension table, wrong data present in dimension table can also be modified, example
Such as, bill misspelling present in dimension table is modified.Can also there will be the dimension table of intersection to merge, by building
Corresponding polymorphic type, multidata dimension table are found, summarizes for billing information and different basic conditions is provided.It can be with real-time update data
Content, for example, newly-increased will hold receive unit or it is newly-increased hold receipts project and be supplemented in electronic bill information, thus according to newly-increased electronics
Billing information establishes corresponding bill fact table, by newly-established ticket data fact table in conjunction with the parameter in each dimension table shape
It is shown at corresponding result table.
In embodiment, it is corresponding that the electronic bill information backed up in database also issues decimation in time accordingly according to bill
Billing information establishes bill fact table.It is different, server only retain the billing information of current year for financial organization staff into
Row financial bill analysis management, however all history billing informations of DB Backup.The databases storage electronic ticket it is believed that
Breath not only can be used as the preliminary data of server, but also can extract or analyze the financial bill information in former years.
In embodiment, which according to electronic bill information or can also pay in unit information relevant parameter and carry out
Search generates corresponding search result data table according to search result, and is drawn out accordingly according to the search result data table
Fiscal revenues statistical chart;For example, search condition is item amount, server is according to search condition (item amount) in the bill fact
The billing information of all about item amount is extracted in table, and counts according to dimension to form search result data table and opened up
Show.The fan-shaped statistical chart of fiscal revenues distribution is drawn further according to the search result data table of the billing information of the item amount, such as
The fan-shaped statistical chart of the item amount accounting current year fiscal revenues, the item amount accounting accordingly pay in the fan that unit pays in total value
Shape statistical chart or the item amount accounting, which are accordingly held, receives the fan-shaped statistical chart etc. that unit always holds the receipts amount of money.Fiscal revenues distribution system
The all types of statistical charts that meter figure can generate in all electronic bill range of information in server according to user demand.Not only
In this way, the fiscal revenues statistical chart can also mention for fiscal revenues trend broken line graph for example, searching for some holds receipts unit
It takes this to hold to receive and hold in unit one or more set period of time and take over money total amount and compare, is drawn out according to comparing result
Fiscal revenues trend broken line graph;In the case where holding the receipts amount of money within one period of extraction, for example, only extracting upper half in this year
Year this hold and receive unit and hold the total amount for taking over money, and with settling time in month point-rendering go out this and hold to receive to hold receipts unit the first half of this year
Pay in the broken line graph of the fiscal revenues trend of total amount;In the case where holding the receipts amount of money within extraction multiple periods, for example,
It will extract this in the end of the year and hold and receive holding for four season of unit this year and take over money total amount and be depicted as broken line graph, united by the broken line
Meter figure can directly show this hold receive four season of unit between hold take over the money amount of money trend comparison.
In embodiment, database side can complete all related operations of server, but mainly as the number of server
According to backup, when server needs can send and request to database, ask for former years when annual data is with former years data comparison
The former years relevant information that server is asked for can be sent directly to server by the data of corresponding billing information, database, can also
Server is sent to after server same type table or statistical chart being fabricated to former years relevant information.
In embodiment, which can also click on the selection bill fact table, the dimension table or described
Parameter in search result data table in any table provides corresponding bill managing detailed catalogue, improves the interaction capabilities of system.Example
Such as, the board-like file of electronic bill is provided;The server can also provide previous corresponding fiscal revenues comparison as a result, can be real
Existing fiscal revenues period Precision management analysis, has greatly helped the building-up work of financial bill electronic management.
Fig. 2 is to show a kind of structural schematic diagram of financial bill analysis system provided in an embodiment of the present invention, such as Fig. 2 institute
Show, which may include client, database and server, and specifically, which acquires all letters of financial bill
Breath generates electronic bill information, wherein the electronic bill information may include that bill issues date, voucher code, bill number
Code pays in unit, payee, holds and receive unit, pay in the amount of money.The electronic bill information of generation is uploaded to service by the client
Device, the server can be set in financial organization, carry out financial bill by the server convenient for financial organization staff
Analysis.The client can also be by the electronic bill information back-up of generation to database simultaneously.
The server acquires the corresponding bill for the bill issued in set period of time according to the electronic bill information received
Information establishes bill fact table, and the corresponding billing information of the bill issued in the acquisition set period of time can be with are as follows: next day zero
Yesterday was issued bill all electronic bill information accordingly in point acquisition;It was opened yesterday for example, server can acquire in morning on next day
All billing informations of the bill of tool are created as bill fact table according to corresponding billing information, and such staff can pass through
Date easily inquires the related billing information for issuing bill on the date.
The server generates dimension table according to the one or more parameters paid in unit information that user chooses, wherein
Paying in unit information may include holding receive unit, hold receipts project, item amount, project billing quantity, item amount accounting, pay in
People, financial organization, financial organization's secondary, administrative division.For example, the parameter paid in unit information that user chooses is to hold receipts item
Mesh, server using hold receipts project as parameter formed dimension table, by this hold receipts project dimension table with this hold receipts project it is relevant own
Bill fact table combines, and extracts and holds the relevant all information of receipts project, and the parameter and extraction that will hold receipts project dimension table to this
All relevant informations carry out being aggregated to form result table and be shown.If it is multiple parameters that user chose, which pays in unit information,
For example, user, which has chosen payee, item amount simultaneously and holds, receives these three parameters of unit, server is joined according to above three
Number form is extracted from bill fact table and receives the relevant bill of unit to payee, item amount and holding simultaneously and believe at dimension table
Breath, and by the payee of above-mentioned dimension table, item amount and hold and receive unit and converge to all related billing informations of extraction
Total result table that formed is shown.The number of parameters that unit information is paid in user's selection is unrestricted, can be according to the use of user
Demand is chosen.
In embodiment, it is corresponding that the electronic bill information backed up in database also issues decimation in time accordingly according to bill
Billing information establishes bill fact table.It is different, server only retain the billing information of current year for financial organization staff into
Row financial bill analysis management, however all history billing informations of DB Backup.The databases storage electronic ticket it is believed that
Breath not only can be used as the preliminary data of server, but also can extract or analyze the financial bill information in former years.
In embodiment, which according to electronic bill information or can also pay in unit information relevant parameter and carry out
Search generates corresponding search result data table according to search result, and is drawn out accordingly according to the search result data table
Fiscal revenues statistical chart;For example, search condition is item amount, server is according to search condition (item amount) in the bill fact
The billing information of all about item amount is extracted in table, and counts according to dimension to form search result data table and opened up
Show.The fan-shaped statistical chart of fiscal revenues distribution is drawn further according to the search result data table of the billing information of the item amount, such as
The fan-shaped statistical chart of the item amount accounting current year fiscal revenues, the item amount accounting accordingly pay in the fan that unit pays in total value
Shape statistical chart or the item amount accounting, which are accordingly held, receives the fan-shaped statistical chart etc. that unit always holds the receipts amount of money.Fiscal revenues distribution system
The all types of statistical charts that meter figure can generate in all electronic bill range of information in server according to user demand.Not only
In this way, the fiscal revenues statistical chart can also mention for fiscal revenues trend broken line graph for example, searching for some holds receipts unit
It takes this to hold to receive and hold in unit one or more set period of time and take over money total amount and compare, is drawn out according to comparing result
Fiscal revenues trend broken line graph;In the case where holding the receipts amount of money within one period of extraction, for example, only extracting upper half in this year
Year this hold and receive unit and hold the total amount for taking over money, and with settling time in month point-rendering go out this and hold to receive to hold receipts unit the first half of this year
Pay in the broken line graph of the fiscal revenues trend of total amount;In the case where holding the receipts amount of money within extraction multiple periods, for example,
It will extract this in the end of the year and hold and receive holding for four season of unit this year and take over money total amount and be depicted as broken line graph, united by the broken line
Meter figure can directly show this hold receive four season of unit between hold take over the money amount of money trend comparison.
In embodiment, database side can complete all related operations of server, but mainly as the number of server
According to backup, when server needs can send and request to database, ask for former years when annual data is with former years data comparison
The former years relevant information that server is asked for can be sent directly to server by the data of corresponding billing information, database, can also
Server is sent to after server same type table or statistical chart being fabricated to former years relevant information.
In embodiment, which can also pass through bill fact table, the dimension table or described search described in motor
Parameter in result data table in any table provides corresponding bill managing detailed catalogue, improves the interaction capabilities of system.For example,
The board-like file of electronic bill is provided;The server can also provide previous corresponding fiscal revenues comparison as a result, it is possible to achieve
The analysis of fiscal revenues period Precision management, has greatly helped the building-up work of financial bill electronic management.
The optional embodiment of the embodiment of the present invention is described in detail in conjunction with attached drawing above, still, the embodiment of the present invention is simultaneously
The detail being not limited in above embodiment can be to of the invention real in the range of the technology design of the embodiment of the present invention
The technical solution for applying example carries out a variety of simple variants, these simple variants belong to the protection scope of the embodiment of the present invention.
It is further to note that specific technical features described in the above specific embodiments, in not lance
In the case where shield, it can be combined in any appropriate way.In order to avoid unnecessary repetition, the embodiment of the present invention pair
No further explanation will be given for various combinations of possible ways.
It will be appreciated by those skilled in the art that implementing the method for the above embodiments is that can pass through
Program is completed to instruct relevant hardware, which is stored in a storage medium, including some instructions are used so that single
Piece machine, chip or processor (processor) execute all or part of the steps of each embodiment the method for the application.And it is preceding
The storage medium stated includes: USB flash disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory
The various media that can store program code such as (RAM, Random Access Memory), magnetic or disk.
In addition, any combination can also be carried out between a variety of different embodiments of the embodiment of the present invention, as long as it is not
The thought of the embodiment of the present invention is violated, equally should be considered as disclosure of that of the embodiment of the present invention.
Claims (16)
1. a kind of financial bill analysis method, which is characterized in that this method comprises:
Client generates electronic bill information, stores the electronic bill information of all generations to database, and described in uploading
Electronic bill information is to server;
The server is for performing the following operations:
From the corresponding billing information for acquiring the bill issued in set period of time in the electronic bill information, and it is corresponding according to this
Billing information establishes bill fact table;
According to the one or more parameters paid in unit information that user chooses, dimension table is generated;
With the parameter in each dimension table in conjunction with the corresponding billing information in the bill fact table, generation is multiple not
The result table of same type.
2. the method according to claim 1, wherein this method further include:
The corresponding billing information is filtered and cancels bill, filtering repetition bill, unified billing information format and corrigendum
The data-optimized operation of misspelling, and the ticket is established according to the corresponding billing information Jing Guo the data-optimized operation
According to true table.
3. the method according to claim 1, wherein the electronic bill information include it is following at least one:
Bill issues the date, voucher code, note number, pays in unit, payee, holds and receive unit, pay in the amount of money.
4. the method according to claim 1, wherein it is described pay in unit information include it is following at least one:
It holds and receives unit, holds receipts project, item amount, project billing quantity, item amount accounting, payee, financial organization, finance
Organ's secondary, administrative division, taxpayer's grade.
5. the method according to claim 1, wherein the bill issued in the acquisition set period of time is corresponding
Billing information includes: that yesterday was issued bill all electronic bill information accordingly in the acquisition of next day zero point.
6. the method according to claim 1, wherein this method further include:
The server is according to the electronic bill information or pays in relevant parameter in unit information and scans for;And
Corresponding search result data table is generated according to the search result of corresponding search condition, and according to described search result data
Table draws corresponding fiscal revenues statistical chart.
7. according to the method described in claim 6, it is characterized in that, this method further include:
The server is also used to according to either table in the bill fact table, the dimension table or described search result data table
Parameter in lattice provides corresponding bill managing detailed catalogue.
8. the method according to claim 1, wherein this method further include: to the number in already present dimension table
Merge it is believed that breath carries out data supplement, data correction or data.
9. a kind of financial bill analysis system characterized by comprising
Client, for generating electronic bill and being uploaded to server;
Database, the electronic bill information generated for storing the client;And
Server is used for:
From the corresponding billing information for acquiring the bill issued in set period of time in the electronic bill information, and it is corresponding according to this
Billing information establishes bill fact table;
According to the one or more parameters paid in unit information that user chooses, dimension table is generated;And
It is multiple not in conjunction with the corresponding billing information generation in the bill fact table with the parameter in each dimension table
The result table of same type.
10. system according to claim 9, which is characterized in that the server is also used to:
The corresponding billing information is filtered and cancels bill, filtering repetition bill, unified billing information format and corrigendum
The data-optimized operation of misspelling, and the ticket is established according to the corresponding billing information Jing Guo the data-optimized operation
According to true table.
11. system according to claim 9, which is characterized in that the electronic bill information include it is following at least one:
Bill issues the date, voucher code, note number, pays in unit, payee, holds and receive unit, pay in the amount of money.
12. system according to claim 9, which is characterized in that it is described pay in unit information include it is following at least one:
It holds and receives unit, holds receipts project, item amount, project billing quantity, item amount accounting, payee, financial organization, finance
Organ's secondary, administrative division, taxpayer's grade.
13. system according to claim 9, which is characterized in that the phase for the bill issued in the acquisition set period of time
Answering billing information includes: that yesterday was issued bill all electronic bill information accordingly in the acquisition of next day zero point.
14. system according to claim 9, which is characterized in that the server is also used to:
According to the electronic bill information or pays in relevant parameter in unit information and scanned in the database;And
Corresponding search result data table is generated according to the search result of corresponding search condition, and according to described search result data
Table draws corresponding fiscal revenues statistical chart.
15. system according to claim 14, which is characterized in that the server is also used to true according to the bill
Parameter in table, the dimension table or described search result data table in any table, provides corresponding bill managing detailed catalogue.
16. system according to claim 9, which is characterized in that the server is also used to in already present dimension table
Data information carry out data supplement, data correction or data merge.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711458004.4A CN109993642A (en) | 2017-12-28 | 2017-12-28 | Financial bill analysis method and system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711458004.4A CN109993642A (en) | 2017-12-28 | 2017-12-28 | Financial bill analysis method and system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN109993642A true CN109993642A (en) | 2019-07-09 |
Family
ID=67108299
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201711458004.4A Pending CN109993642A (en) | 2017-12-28 | 2017-12-28 | Financial bill analysis method and system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109993642A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110503493A (en) * | 2019-08-16 | 2019-11-26 | 安徽航天信息有限公司 | A kind of bill distribution method of summary, system and electronic equipment |
CN110706089A (en) * | 2019-10-15 | 2020-01-17 | 重庆远见信息产业集团有限公司 | Financial non-tax fund payment system and method |
CN113590683A (en) * | 2021-07-22 | 2021-11-02 | 福建博思软件股份有限公司 | Multi-dimensional electronic bill suspicious ticket comprehensive monitoring and analyzing method |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101226613A (en) * | 2008-02-21 | 2008-07-23 | 金蝶软件(中国)有限公司 | Method for generating credence according to document |
CN102254248A (en) * | 2011-06-24 | 2011-11-23 | 上海宝钢浦东国际贸易有限公司 | Method for constructing enterprise financial expense accounting model |
CN103678591A (en) * | 2013-12-12 | 2014-03-26 | 用友软件股份有限公司 | Device and method for automatically executing multi-service receipt statistical treatment |
CN106296376A (en) * | 2015-06-09 | 2017-01-04 | 北京京东尚科信息技术有限公司 | The acquisition and recording method and system of electronics accounting data |
CN106504079A (en) * | 2016-09-22 | 2017-03-15 | 江苏富山企业服务有限公司 | A kind of composite type financial management method and its management platform |
CN106874283A (en) * | 2015-12-11 | 2017-06-20 | 航天信息股份有限公司 | Tax control counting system and the method using the tax control counting system statistics commodity data |
CN107392744A (en) * | 2017-07-11 | 2017-11-24 | 北京欣欣苹果网络科技有限公司 | Bookkeeping methods and device based on business scenario |
-
2017
- 2017-12-28 CN CN201711458004.4A patent/CN109993642A/en active Pending
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101226613A (en) * | 2008-02-21 | 2008-07-23 | 金蝶软件(中国)有限公司 | Method for generating credence according to document |
CN102254248A (en) * | 2011-06-24 | 2011-11-23 | 上海宝钢浦东国际贸易有限公司 | Method for constructing enterprise financial expense accounting model |
CN103678591A (en) * | 2013-12-12 | 2014-03-26 | 用友软件股份有限公司 | Device and method for automatically executing multi-service receipt statistical treatment |
CN106296376A (en) * | 2015-06-09 | 2017-01-04 | 北京京东尚科信息技术有限公司 | The acquisition and recording method and system of electronics accounting data |
CN106874283A (en) * | 2015-12-11 | 2017-06-20 | 航天信息股份有限公司 | Tax control counting system and the method using the tax control counting system statistics commodity data |
CN106504079A (en) * | 2016-09-22 | 2017-03-15 | 江苏富山企业服务有限公司 | A kind of composite type financial management method and its management platform |
CN107392744A (en) * | 2017-07-11 | 2017-11-24 | 北京欣欣苹果网络科技有限公司 | Bookkeeping methods and device based on business scenario |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110503493A (en) * | 2019-08-16 | 2019-11-26 | 安徽航天信息有限公司 | A kind of bill distribution method of summary, system and electronic equipment |
CN110706089A (en) * | 2019-10-15 | 2020-01-17 | 重庆远见信息产业集团有限公司 | Financial non-tax fund payment system and method |
CN113590683A (en) * | 2021-07-22 | 2021-11-02 | 福建博思软件股份有限公司 | Multi-dimensional electronic bill suspicious ticket comprehensive monitoring and analyzing method |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105243514A (en) | Salary management system | |
CN109993642A (en) | Financial bill analysis method and system | |
CN101520929A (en) | Method for managing tax fund based on data acquisition | |
US20150058188A1 (en) | Calculating Estimated Tax Payments | |
CN109308296A (en) | A kind of generation method, device and the computer readable storage medium of business datum table | |
US20170161802A9 (en) | A wip management system | |
CN109598631B (en) | Method and system for generating human resource outsourcing client bill based on social security policy | |
CN108428072A (en) | The method of the financial comprehensive physical examination of air control | |
CN105930517A (en) | Tax data processing method and apparatus | |
KR20150110463A (en) | Systems and methods for providing computer-automated adjusting entries | |
CN108876584A (en) | A kind of personnel's revenue control and Individual Income Tax accounting system, method and electronic equipment | |
CN106447498A (en) | Insurance policy advance payment method, device and system | |
CN106055565A (en) | Method and device for generating tax affair report | |
US20110191221A1 (en) | Approval and payment portal | |
EP3907690A1 (en) | The modified cash ledger basis for an accounting system and process | |
CN110717813A (en) | Individual tax multiple automatic tax counting system and method | |
CN116091258A (en) | Data processing method and device for account checking management | |
CN103310372A (en) | Method and system of extracting finance system data for taxation adjusting data processing | |
JP4146956B2 (en) | Insurance levy storage record update device and insurance levy storage record update program storage medium | |
CN110852857A (en) | Fare reimbursement method, device and storage medium | |
CN108921684A (en) | A kind of processing method and processing device of source attribute values | |
JP2019153193A (en) | Compacted data generating apparatus, compacted data generating method, and compacted data generating program | |
CN102289746A (en) | Method and system for implementing plan, implementation and evaluation management planning and converting experiences | |
CN116069827A (en) | Cash flow condition determining method and device, electronic equipment and medium | |
CN114549161A (en) | Budget accounting document generation system and method with liability collection and reimbursement function |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190709 |