CN106598925A - Method and system for quickly generating department final statement report data - Google Patents
Method and system for quickly generating department final statement report data Download PDFInfo
- Publication number
- CN106598925A CN106598925A CN201611032055.6A CN201611032055A CN106598925A CN 106598925 A CN106598925 A CN 106598925A CN 201611032055 A CN201611032055 A CN 201611032055A CN 106598925 A CN106598925 A CN 106598925A
- Authority
- CN
- China
- Prior art keywords
- report
- unit
- data
- department
- surplus
- 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
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
-
- 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
Abstract
The invention discloses a method and system for quickly generating department final statement report data. The method comprises the following steps: initializing unit information, and determining filling logic of data in an improved integrated final statement filling manuscript according to the unit information; filling income, expenditure and carry over balance data of a unit in the improved integrated final statement filling manuscript according to items, functions and subjects, and performing audit in the table; and automatically extracting data from the data filled in the improved integrated final statement filling manuscript, and generating corresponding department final statement report data according to the filling specification of each table of a department final statement report. According to the method and the system disclosed by the invention, the traditional multiple pieces of final statement reports with multiple business latitudes are replaced by the improved integrated final statement filling manuscript, the improved integrated final statement filling manuscript is highly unified with the financial accounting flow and logic height, the requirements for the specialized knowledge of reporting personnel are reduced, the filling efficiency is improved, and the logic check of the final statement report software can be realized by performing the audit in the table while filling the data. The method and the system disclosed by the invention can be widely applied to the technical field of computers.
Description
Technical field
The present invention relates to field of computer technology, especially a kind of method for quickly generating department's statement data and be
System.
Background technology
According to《The Budget Law of the PRC》And relevant laws and regulations, governments at all levels, all departments and constituent parts（It is i.e. pre-
Calculation department）, ending in each budget year must weave final accounts draft, and each budget sector pair within the time that State Council specifies
The final accounts draft of affiliated constituent parts should be audited and collect the final accounts draft of establishment this department, and report this level in the specified period
Government finance department for review.In actual operation, statement data are filled and presented country by final accounts draft by each budget sector
In department's final accounts software of Ministry of Finance's Uniform provisions.National Ministry of Finance specify in the statement table to be filled in each unit lattice it
Between, extremely strong mathematical logic and service logic are suffered between form and form, therefore directly in existing department's final accounts software
Middle establishment department statement has high demands to the professional standards of compiling and assembling people and needs to spend longer time, and it also requires
Through repeatedly back and forth modification could pass through the logical checking of statement software.
It is current that directly the general process of establishment statement is in department's statement software：
（1）Fill in front cover code information；
（2）Fill in the data of each form；
（3）The data inside each form are changed back and forth, by the examination ＆ verification of formula between Biao Nei and table；
Above-mentioned steps（3）Continuous staggeredly modification back and forth is needed, examination ＆ verification, fill in the time length and effect between the interior examination ＆ verification of table and table could be passed through
Rate is very low.
In sum, current administrative institution needs badly and a kind of fill in efficiency high and determine to filling in the low department of personnel requirement
Calculate report data generation method.
The content of the invention
To solve above-mentioned technical problem, it is an object of the invention to：There is provided that a kind of personnel requirement is low, fill in the time to filling in
It is short and fill in efficiency high, the method for quickly generating department's statement data.
Another object of the present invention is to：Personnel requirement is low, fill in the time is short and fills in efficiency high to filling in provide one kind
, the system for quickly generating department's statement data.
The technical solution used in the present invention is：
A kind of method for quickly generating department's statement data, comprises the following steps：
Initialization unit information, and determine that filling in for data is patrolled in draft is made a report in improved integrated final accounts according to unit information
Volume, wherein, unit information includes but is not limited to organization, Institution Code, unit fundamental property and unit and performs accounting system；
In draft is made a report in improved integrated final accounts sub-item make a report on the income of unit by function subject, surplus number of paying and carry down
According to, and by table audit, the income of the unit, pay and carry down surplus data include but is not limited to the beginning of the year carry down surplus,
This annual income, this year expenditure and year end carry down surplus, and the budget that unit is made a report in draft reflection is made a report in the improved integrated final accounts
Implementation status and accounting overall process, and it is built-in with the critical field for filling in or selecting and the logic examination ＆ verification for auditing in table
Formula, wherein, critical field includes but is not limited to unit fundamental property, unit and performs accounting system, entry property, item class
Not, the general public budget financial allocation fund for arranging is concentrated in fund property and this grade of development with reform department, and logic examination ＆ verification is public
Formula is the income that critical field and improved integrated final accounts are made a report in draft, the logic pass paid and carry down between surplus data
System；
Make a report in the data that draft is filled in from improved integrated final accounts and peek automatically, and making a report on by every table of department's statement
Specification generates corresponding department's statement data.
Further, the initialization unit information, and draft is made a report in improved integrated final accounts according to unit information determination
The step for filling in logic of middle data, it includes：
Judgement makes a report on whether unit information is present in database, if so, then reads corresponding historical data from database and believes
Breath makes a report on unit information as form；Conversely, then creating new form makes a report on unit, the form has been then filled out it and has made a report on unit information
And store in database；
Determine that data fill in logic in draft is made a report in improved integrated final accounts according to unit information is made a report on.
Further, the sub-item in draft is made a report in improved integrated final accounts by function subject make a report on unit income,
Expenditure and surplus data of carrying down, and the step for by auditing in table, it includes：
Each critical field that form makes a report on unit is filled in, wherein, unit fundamental property includes administrative unit, reference Civil Service Law
Public institution, financial aid public institution, self-financed public institution and other unit；Entry property includes basic expenditure, OK
Government affairs industry intermediate item, capital construction intermediate item and the item to manage；Fund property pulls out money, special family fund, floating capital including finance
With other funds；Unit performs accounting system includes accounting of governmental units system, Institution Accounting System, cause of science unit
Accounting system, middle and primary schools' accounting system, institution of higher education's accounting system, accounting regulations ror hospitals and Basic medical and health institutions accounting
System；Project category including State Council determined project, regular special operating cost project, the expenditure that straddles over year and its
His project；This grade development with reform department concentrate arrange general public budget financial allocation fund include be this grade develop and change
The general public budget financial allocation fund and Fei Ben levels that leather department concentration is arranged develops and reform department concentrates the general of arrangement
Public budget financial allocation fund；
In draft is made a report in improved integrated final accounts sub-item make a report on the income of unit by function subject, surplus number of paying and carry down
According to；
Judge the income of made a report on unit, pay and whether surplus data of carrying down meet built-in logic auditing formula, if so, then
By auditing in table, conversely, then prompting is filled in people and needs income to filling in, pays and surplus data of carrying down are modified, directly
It is met to built-in logic auditing formula；
The income of examination ＆ verification in table will be passed through, paid and carried down in surplus data Cun Chudao database.
Further, the improved integrated final accounts are made a report on draft the project for making a report on unit are divided into into basic expenditure project and specially
The item class of expenditure two, the basic expenditure project and special expenditure meet the service logic of setting, the industry of the setting
Business logic expression formula be：Last year carries down surplus+this annual income-this year expenditure+make up balance of payment-knot with enterprise fund
Remaining distribution=year end carries down surplus.
Further, described making a report in the data that draft is filled in from improved integrated final accounts is peeked automatically, and by department's final accounts
The step for making a report on specification generation corresponding department's statement data of every table of form, it includes：
It is determined that automatic access method and peek unit；
Automatic access method and peek unit according to selecting is made a report in the data that draft is filled in certainly from improved integrated final accounts
Data needed for dynamic acquisition department every table of statement；
According to the data, critical field and income, surplus data filling out by every table of department's statement of paying and carry down that obtain
Report specification generates corresponding department's statement data.
Further, the automatic access method is including but not limited to based on the access method of retrieval function and based on final accounts report
The SQL query script peek method of table service logic, the peek unit includes but is not limited to cell and row, wherein, cell
For to fixed row and the form of fixed row is peeked, arranging for floating row and the form of fixed row is peeked.
Another technical scheme for being taken of the present invention is：
A kind of system for quickly generating department's statement data, including with lower module：
Initialization module, draft is made a report on for initializing unit information, and determining according to unit information in improved integrated final accounts
Middle data fill in logic, wherein, unit information includes but is not limited to organization, Institution Code, unit fundamental property and list
Position performs accounting system；
Data fill in module, for the receipts that sub-item in making a report on draft in improved integrated final accounts is made a report on unit by function subject
Enter, pay and carry down surplus data, and by table audit, the income of the unit, pay and carry down surplus data include but
Being not limited to carry down surplus, this annual income, this year expenditure and year end at the beginning of the year carries down surplus, and draft is made a report in the improved integrated final accounts
The budget enforcement and accounting overall process of unit are made a report in reflection, and are built-in with the critical field for filling in or selecting and confession
The logic auditing formula of examination ＆ verification in table, wherein, critical field includes but is not limited to unit fundamental property, unit and performs accounting system
Degree, entry property, project category, fund property and this grade of development concentrate the general public budget finance for arranging to dial with reform department
Money fund, logic auditing formula is income, the surplus of paying and carry down that critical field is made a report in draft with improved integrated final accounts
Logical relation between data；
Report generation module, peeks automatically for making a report in the data that draft is filled in from improved integrated final accounts, and determines by department
The specification of making a report on for calculating every table of form generates corresponding department's statement data.
Further, the data are filled in module and are included：
Critical field fills in unit, for filling in each critical field that form makes a report on unit, wherein, unit fundamental property includes
Administrative unit, reference Civil Service Law public institution, financial aid public institution, self-financed public institution and other unit；
Mesh property includes basic expenditure, administrative institution intermediate item, capital construction intermediate item and the item to manage；Fund property is pulled out including finance
Money, special family fund, floating capital and other funds；Unit performs accounting system includes accounting of governmental units system, public institution
Accounting system, sicentific research institute accounting system, middle and primary schools' accounting system, institution of higher education's accounting system, accounting regulations ror hospitals
With Basic medical and health institutions accounting system；Project category has determined project, regular special operating cost including State Council
Project, the expenditure that straddles over year and sundry item；This grade of development concentrates the general public budget finance for arranging to dial with reform department
Money fund includes it being that the general public budget financial allocation fund and the development of Fei Ben levels for arranging is concentrated in this grade of development with reform department
The general public budget financial allocation fund for arranging is concentrated with reform department；
Data fill in unit, for the receipts that sub-item in making a report on draft in improved integrated final accounts is made a report on unit by function subject
Enter, pay and carry down surplus data；
Judging unit, for judging the income of made a report on unit, pays and whether surplus data of carrying down meet built-in logic and examine
Core formula, if so, then by examination ＆ verification in table, conversely, then prompting fills in people's needs to the income filled in, surplus number of paying and carry down
According to modifying, until built-in logic auditing formula is met；
Memory cell, for will pass through to be audited in table income, pay and carry down in surplus data Cun Chudao database.
Further, improved integrated final accounts are stated make a report on draft and the project for making a report on unit is divided into into basic expenditure project and special project
The class of expenditure two, the basic expenditure project and special expenditure meet the service logic of setting, the business of the setting
The expression formula of logic is：Last year carries down surplus+this annual income-this year expenditure+make up balance of payment-surplus with enterprise fund
Distribution=year end carries down surplus.
Further, the report generation module includes：
Determining unit, for determining automatic access method and peek unit；
Peek unit, for making a report on draft from improved integrated final accounts and filling out according to the automatic access method and peek unit that select
Automatically the data needed for department's every table of statement are obtained in the data write；
Report data signal generating unit, for according to the data, critical field and income for obtaining, pay and surplus data of carrying down are by portion
The specification of making a report on of door every table of statement generates corresponding department's statement data.
The beneficial effects of the method for the present invention is：Draft is made a report on including initialization unit information, in improved integrated final accounts
Middle sub-item made a report on the income of unit by function subject, pay and carry down and surplus data and peek automatically and generate corresponding portion
The step of door statement data, employ improved integrated final accounts and make a report on draft to replace multiple traditional multi-service latitudes to determine
Calculate form so that the personnel that make a report on only need to complete integrated final accounts make a report on the data of draft just can be combined by way of peek automatically it is every
The business tine for opening table reflection automatically generates required department's statement data, with the finance for making a report on unit during making a report on
Adjust flow process and logic to be identical, make the personnel of making a report on to grasp in department's statement the business that every form reflected and patrol
Volume, mathematical logic and make a report on content and just can complete to make a report on, changing when prior art fills and presents statement needs by every form
Business tine come the mode filled and presented one by one, reduce the requirement to making a report on personnel's professional knowledge, improve and fill in efficiency, and only
Need to carry out while data are filled in table examination ＆ verification just can by the table of National Ministry of Finance's statement software and between table logic
Inspection, it is no longer necessary to repeatedly modify to the data of form back and forth, highly shortened fill in the time and improves and fill in effect
Rate.
The beneficial effect of system of the present invention is：Module and report generation module are filled in including initialization module, data,
Data are filled in and improved integrated final accounts are employed in module make a report on draft to replace the statement of traditional multiple multi-service latitudes,
Make a report on the data of draft just every table to be combined by way of peek automatically anti-so that making a report on personnel and need to only complete integrated final accounts
The business tine reflected automatically generates required department's statement data, with the financial accounting stream for making a report on unit during making a report on
Journey and logic are identical, and make the personnel of making a report on to grasp every form is reflected in department's statement service logic, number
According to logic and make a report on content and just can complete to make a report on, changing when prior art fills and presents statement needs by the business of every form
Content reduces the requirement to making a report on personnel's professional knowledge come the mode filled and presented one by one, improves and fills in efficiency, and only need to fill out
Examination ＆ verification in table is carried out while writing data can just pass through the interior logical checking and between table of table of National Ministry of Finance's statement software, no
Need again back and forth repeatedly to modify the data of form, highly shortened fill in the time and improve and fill in efficiency.
Description of the drawings
Fig. 1 is a kind of overall flow figure of the method for quickly generating department's statement data of the present invention.
Specific embodiment
With reference to Fig. 1, a kind of method for quickly generating department's statement data is comprised the following steps：
Initialization unit information, and determine that filling in for data is patrolled in draft is made a report in improved integrated final accounts according to unit information
Volume, wherein, unit information includes but is not limited to organization, Institution Code, unit fundamental property and unit and performs accounting system；
In draft is made a report in improved integrated final accounts sub-item make a report on the income of unit by function subject, surplus number of paying and carry down
According to, and by table audit, the income of the unit, pay and carry down surplus data include but is not limited to the beginning of the year carry down surplus,
This annual income, this year expenditure and year end carry down surplus, and the budget that unit is made a report in draft reflection is made a report in the improved integrated final accounts
Implementation status and accounting overall process, and it is built-in with the critical field for filling in or selecting and the logic examination ＆ verification for auditing in table
Formula, it is ensured that fill in accounting system and critical field of the people according to performed by unit and fill in data, wherein, critical field include but
It is not limited to unit fundamental property, unit to perform accounting system, entry property, project category, fund property and this grade of development and change
Leather department concentrates the general public budget financial allocation fund for arranging, logic auditing formula be critical field with it is improved it is integrated certainly
Calculate the income made a report in draft, the logical relation paid and carry down between surplus data；
Make a report in the data that draft is filled in from improved integrated final accounts and peek automatically, and making a report on by every table of department's statement
Specification generates corresponding department's statement data.
Wherein, project refers to required commodity and labor service of each function office of country in order to complete its public functions, to purchase
The statistics for carrying out various financial fund payment activities and determining or the object of accounting, generally itself and Governmental Expenditure budget items keep
Unanimously.Function subject, refers to a kind of classification subject that Governmental Expenditure is made by its Major Function activity, mainly reflects government activities
Difference in functionality and policy goals, be specifically provided with class, money and item this three-level, it is by National Ministry of Finance's Uniform provisions.
The expenditure for making a report on unit is economic course.Economic course, refers to Governmental Expenditure by economic property and particular use
A kind of classification subject made, it is by National Ministry of Finance's Uniform provisions.
Every table of department's statement makes a report on specification by unified department's statement for specifying to National Ministry of Finance
The business tine and mathematical logic that every table is reflected is analyzed and obtains.
It is further used as preferred embodiment, the initialization unit information, and is determined in improvement according to unit information
Integrated final accounts make a report on the step for filling in logic of data in draft, it includes：
Judgement makes a report on whether unit information is present in database, if so, then reads corresponding historical data from database and believes
Breath makes a report on unit information as form；Conversely, then creating new form makes a report on unit, the form has been then filled out it and has made a report on unit information
And store in database；
Determine that data fill in logic in draft is made a report in improved integrated final accounts according to unit information is made a report on.
It is further used as preferred embodiment, the sub-item in draft is made a report in improved integrated final accounts is by function section
Mesh makes a report on the income of unit, surplus data of paying and carry down, and the step for by auditing in table, it includes：
Each critical field that form makes a report on unit is filled in, wherein, unit fundamental property includes administrative unit, reference Civil Service Law
Public institution, financial aid public institution, self-financed public institution and other unit；Entry property includes basic expenditure, OK
Government affairs industry intermediate item, capital construction intermediate item and the item to manage；Fund property pulls out money, special family fund, floating capital including finance
With other funds；Unit performs accounting system includes accounting of governmental units system, Institution Accounting System, cause of science unit
Accounting system, middle and primary schools' accounting system, institution of higher education's accounting system, accounting regulations ror hospitals and Basic medical and health institutions accounting
System；Project category including State Council determined project, regular special operating cost project, the expenditure that straddles over year and its
His project；This grade development with reform department concentrate arrange general public budget financial allocation fund include be this grade develop and change
The general public budget financial allocation fund and Fei Ben levels that leather department concentration is arranged develops and reform department concentrates the general of arrangement
Public budget financial allocation fund；
In draft is made a report in improved integrated final accounts sub-item make a report on the income of unit by function subject, surplus number of paying and carry down
According to；
Judge the income of made a report on unit, pay and whether surplus data of carrying down meet built-in logic auditing formula, if so, then
By auditing in table, conversely, then prompting is filled in people and needs income to filling in, pays and surplus data of carrying down are modified, directly
It is met to built-in logic auditing formula；
The income of examination ＆ verification in table will be passed through, paid and carried down in surplus data Cun Chudao database.
It is further used as preferred embodiment, the improved integrated final accounts are made a report on draft and will make a report on the project point of unit
For basic expenditure project and the special class of expenditure two, the basic expenditure project and special expenditure meet the business of setting
Logic, the expression formula of the service logic for setting as：Last year carry down surplus+this annual income-this year pay+use enterprise fund
Making up balance of payment-surplus distribution=year end carries down surplus.
It is further used as preferred embodiment, it is described to make a report in the data that draft is filled in automatically from improved integrated final accounts
Peek, and by every table of department's statement make a report on specification generate corresponding department's statement data the step for, its bag
Include：
It is determined that automatic access method and peek unit；
Automatic access method and peek unit according to selecting is made a report in the data that draft is filled in certainly from improved integrated final accounts
Data needed for dynamic acquisition department every table of statement；
According to the data, critical field and income, surplus data filling out by every table of department's statement of paying and carry down that obtain
Report specification generates corresponding department's statement data.
It is further used as preferred embodiment, the automatic access method including but not limited to taking based on retrieval function
Counting method and the peek method of the SQL query script based on statement service logic, the peek unit includes but is not limited to unit
Lattice and row, wherein, cell is used for fixed row and the form of fixed row is peeked, and arranges for floating row and fixed row
Form is peeked.
With reference to Fig. 1, a kind of system for quickly generating department's statement data, including with lower module：
Initialization module, draft is made a report on for initializing unit information, and determining according to unit information in improved integrated final accounts
Middle data fill in logic, wherein, unit information includes but is not limited to organization, Institution Code, unit fundamental property and list
Position performs accounting system；
Data fill in module, for the receipts that sub-item in making a report on draft in improved integrated final accounts is made a report on unit by function subject
Enter, pay and carry down surplus data, and by table audit, the income of the unit, pay and carry down surplus data include but
Being not limited to carry down surplus, this annual income, this year expenditure and year end at the beginning of the year carries down surplus, and draft is made a report in the improved integrated final accounts
The budget enforcement and accounting overall process of unit are made a report in reflection, and are built-in with the critical field for filling in or selecting and confession
The logic auditing formula of examination ＆ verification in table, wherein, critical field includes but is not limited to unit fundamental property, unit and performs accounting system
Degree, entry property, project category, fund property and this grade of development concentrate the general public budget finance for arranging to dial with reform department
Money fund, logic auditing formula is income, the surplus of paying and carry down that critical field is made a report in draft with improved integrated final accounts
Logical relation between data；
Report generation module, peeks automatically for making a report in the data that draft is filled in from improved integrated final accounts, and determines by department
The specification of making a report on for calculating every table of form generates corresponding department's statement data.
It is further used as preferred embodiment, the data fill in module to be included：
Critical field fills in unit, for filling in each critical field that form makes a report on unit, wherein, unit fundamental property includes
Administrative unit, reference Civil Service Law public institution, financial aid public institution, self-financed public institution and other unit；
Mesh property includes basic expenditure, administrative institution intermediate item, capital construction intermediate item and the item to manage；Fund property is pulled out including finance
Money, special family fund, floating capital and other funds；Unit performs accounting system includes accounting of governmental units system, public institution
Accounting system, sicentific research institute accounting system, middle and primary schools' accounting system, institution of higher education's accounting system, accounting regulations ror hospitals
With Basic medical and health institutions accounting system；Project category has determined project, regular special operating cost including State Council
Project, the expenditure that straddles over year and sundry item；This grade of development concentrates the general public budget finance for arranging to dial with reform department
Money fund includes it being that the general public budget financial allocation fund and the development of Fei Ben levels for arranging is concentrated in this grade of development with reform department
The general public budget financial allocation fund for arranging is concentrated with reform department；
Data fill in unit, for the receipts that sub-item in making a report on draft in improved integrated final accounts is made a report on unit by function subject
Enter, pay and carry down surplus data；
Judging unit, for judging the income of made a report on unit, pays and whether surplus data of carrying down meet built-in logic and examine
Core formula, if so, then by examination ＆ verification in table, conversely, then prompting fills in people's needs to the income filled in, surplus number of paying and carry down
According to modifying, until built-in logic auditing formula is met；
Memory cell, for will pass through to be audited in table income, pay and carry down in surplus data Cun Chudao database.
It is further used as preferred embodiment, stating improved integrated final accounts and making a report on draft and be divided into the project for making a report on unit
The business that basic expenditure project and the special class of expenditure two, the basic expenditure project and special expenditure meet setting is patrolled
Volume, the expression formula of the service logic for setting as：Last year carries down surplus+this annual income-this year expenditure+with enterprise fund more
Mend balance of payment-surplus distribution=year end to carry down surplus.
It is further used as preferred embodiment, the report generation module includes：
Determining unit, for determining automatic access method and peek unit；
Peek unit, for making a report on draft from improved integrated final accounts and filling out according to the automatic access method and peek unit that select
Automatically the data needed for department's every table of statement are obtained in the data write；
Report data signal generating unit, for according to the data, critical field and income for obtaining, pay and surplus data of carrying down are by portion
The specification of making a report on of door every table of statement generates corresponding department's statement data.
The present invention is described in further detail with reference to Figure of description and specific embodiment.
Embodiment one
Directly statement is worked out in department's statement software for prior art will to the professional standards of compiling and assembling people
Ask high and need to spend longer time, fill in the problem of inefficiency, the present invention is proposed and a kind of brand-new quickly generates portion
Door statement data method.The generation department statement data method of the present invention can be used for department's statement and make a report on unit
It is rapidly completed filling and presenting for statement.
As shown in figure 1, the detailed process for quickly generating department's statement data method is as follows：
1st, unit information is initialized, and determines that filling in for data is patrolled in draft is made a report in improved integrated final accounts according to unit information
Volume.
Unit information includes that organization, Institution Code, unit fundamental property and unit perform the information such as accounting system.
Fill in and first have to judgement when form makes a report on unit information and make a report on whether unit information is present in database, if so, then show
This is made a report on and carried out before unit filling in for statement, now directly reads corresponding historical data information from database and makees
Unit information is made a report on for form；Conversely, then showing that this is made a report on do not carried out before unit filling in for statement, now create new
Form makes a report on unit, has been then filled out the form and has made a report on unit information and store in database.
2nd, sub-item makes a report on the income of unit, pays and carry down by function subject in draft is made a report in improved integrated final accounts
Surplus data, and by auditing in table.
The improved integrated final accounts of the present invention are made a report on draft and are had the characteristics that：
（1）The project for making a report on unit is divided into：Basic expenditure project and special expenditure.
（2）Based on unified service logic（The service logic for setting）To design, specific service logic is：Last year ties
Turn surplus+this annual income-this year expenditure+make up balance of payment-surplus distribution=year end with enterprise fund to carry down surplus.Should
Service logic changes prior art needs the service logic by every form when form is filled and presented come in the way of filling and presenting one by one, and
And be identical with financial accounting flow process and logic, reduce and make a report on the requirement of personnel's professional knowledge, and improve and fill in efficiency.
（3）It is built-in with critical field to fill in or select for the personnel of making a report on.Wherein, critical field includes but is not limited to unit base
This property, unit perform the development of accounting system, entry property, project category, fund property and this level and concentrate peace with reform department
The general public budget financial allocation fund of row.So that National Ministry of Finance specifies the statement to be filled in as an example, now to fill in
Or the critical field for selecting is specially：Unit fundamental property includes administrative unit, reference Civil Service Law public institution, financial aid
Public institution, self-financed public institution and other unit；Entry property includes basic expenditure, administrative institution intermediate item, basic
Build intermediate item and the item to manage；Fund property pulls out money, special family fund, floating capital and other funds including finance；Unit is held
Row accounting system includes accounting of governmental units system, Institution Accounting System, sicentific research institute accounting system, middle and primary schools
Accounting system, institution of higher education's accounting system, accounting regulations ror hospitals and Basic medical and health institutions accounting system；Project category includes
Project, regular special operating cost project, the expenditure that straddles over year and sundry item have been determined by State Council；This level develop with
Reform department to concentrate the general public budget financial allocation fund for arranging to include is that this grade of development and reform department concentrate and arrange
The general public budget financial allocation for arranging is concentrated in general public budget financial allocation fund and the development of Fei Ben levels with reform department
Fund.The concrete option of each critical field is determined by department's statement content that National Ministry of Finance specifies.
（4）The income in draft is made a report on improved integrated final accounts according to critical field, pay and carry down surplus data it
Between logic corresponding logic auditing formula is built-in with integrated form（Can be adjusted flexibly according to actual needs, but its
It is identical with examination ＆ verification principle in existing table that logic audits principle）.
3rd, department's statement data are generated.
This process can be further subdivided into：
（1）It is determined that automatic access method and peek unit.Wherein, automatic access method is including but not limited to taken based on self-defined
The access method of number function and the SQL query script peek method based on statement service logic.Peek unit includes but does not limit
In cell and row：Cell is used for fixed row and the form of fixed row is peeked, and it is directed to the business of each cell
Logical sum object is peeking；Arrange for floating row and the form of fixed row is peeked, it to be directed to the service logic of each row
Peek with object.
（2））Automatic access method and peek unit according to selecting makes a report on what draft was filled in from improved integrated final accounts
Automatically the data needed for department's every table of statement are obtained in data.
（3）According to the data, critical field and income for obtaining, pay and carry down surplus data by department's statement per
The specification of making a report on of table generates corresponding department's statement data.
Department's statement data of the present invention specify the department's statement data to be filled in for National Ministry of Finance.
4th, department's statement data of generation are imported or are copied to National Ministry of Finance's statement software by interface
In, it is easy to National Ministry of Finance's statement software subsequently to be collected and the operation such as analyzes.
The method of the present invention is actually obtaining successfully application.It is pre- that Guilin City develops and change the annual finance of the committee
Calculation project up to more than 90, original its accounting directly makes a report on department's final accounts report in department's statement software of National Ministry of Finance
Table, is filled with altogether more than 20 days and also audits not over logic, is made a report on the method for the present invention later, has only used 3 day time just complete
Into the department's statement software examination ＆ verification made a report on and pass through National Ministry of Finance.And Guilin City Ziyuan County Bureau of Land and Resources is in state's family property
Department's statement is made a report in department's statement software in political affairs portion, needs repeatedly to carry out back and forth changing that examination ＆ verification could be passed through, filled out
Call time up to two weeks, the data summarization that have impact on the whole county is reported, and is made a report on the method for the present invention later, only used 2
Its time just completes to make a report on and disposably by department's statement software examination ＆ verification of National Ministry of Finance.As can be seen here, the present invention
Method substantially reduce the fill in the time of department's statement and improve and fill in efficiency.
It is more than that the preferable enforcement to the present invention is illustrated, but the present invention is not limited to the embodiment, it is ripe
Knowing those skilled in the art can also make a variety of equivalent variations or replacement on the premise of without prejudice to spirit of the invention, this
The deformation or replacement of a little equivalents is all contained in the application claim limited range.
Claims (10)
1. a kind of method for quickly generating department's statement data, it is characterised in that：Comprise the following steps：
Initialization unit information, and determine that filling in for data is patrolled in draft is made a report in improved integrated final accounts according to unit information
Volume, wherein, unit information includes but is not limited to organization, Institution Code, unit fundamental property and unit and performs accounting system；
In draft is made a report in improved integrated final accounts sub-item make a report on the income of unit by function subject, surplus number of paying and carry down
According to, and by table audit, the income of the unit, pay and carry down surplus data include but is not limited to the beginning of the year carry down surplus,
This annual income, this year expenditure and year end carry down surplus, and the budget that unit is made a report in draft reflection is made a report in the improved integrated final accounts
Implementation status and accounting overall process, and it is built-in with the critical field for filling in or selecting and the logic examination ＆ verification for auditing in table
Formula, wherein, critical field includes but is not limited to unit fundamental property, unit and performs accounting system, entry property, item class
Not, the general public budget financial allocation fund for arranging is concentrated in fund property and this grade of development with reform department, and logic examination ＆ verification is public
Formula is the income that critical field and improved integrated final accounts are made a report in draft, the logic pass paid and carry down between surplus data
System；
Make a report in the data that draft is filled in from improved integrated final accounts and peek automatically, and making a report on by every table of department's statement
Specification generates corresponding department's statement data.
2. a kind of method for quickly generating department's statement data according to claim 1, it is characterised in that：It is described first
Beginningization unit information, and fill in logic this step according to what unit information determined in draft is made a report in improved integrated final accounts data
Suddenly, it includes：
Judgement makes a report on whether unit information is present in database, if so, then reads corresponding historical data from database and believes
Breath makes a report on unit information as form；Conversely, then creating new form makes a report on unit, the form has been then filled out it and has made a report on unit information
And store in database；
Determine that data fill in logic in draft is made a report in improved integrated final accounts according to unit information is made a report on.
3. a kind of method for quickly generating department's statement data according to claim 1, it is characterised in that：It is described
Improved integrated final accounts make a report on sub-item in draft make a report on the income of unit by function subject, surplus data of paying and carry down, and
The step for by auditing in table, it includes：
Each critical field that form makes a report on unit is filled in, wherein, unit fundamental property includes administrative unit, reference Civil Service Law
Public institution, financial aid public institution, self-financed public institution and other unit；Entry property includes basic expenditure, OK
Government affairs industry intermediate item, capital construction intermediate item and the item to manage；Fund property pulls out money, special family fund, floating capital including finance
With other funds；Unit performs accounting system includes accounting of governmental units system, Institution Accounting System, cause of science unit
Accounting system, middle and primary schools' accounting system, institution of higher education's accounting system, accounting regulations ror hospitals and Basic medical and health institutions accounting
System；Project category including State Council determined project, regular special operating cost project, the expenditure that straddles over year and its
His project；This grade development with reform department concentrate arrange general public budget financial allocation fund include be this grade develop and change
The general public budget financial allocation fund and Fei Ben levels that leather department concentration is arranged develops and reform department concentrates the general of arrangement
Public budget financial allocation fund；
In draft is made a report in improved integrated final accounts sub-item make a report on the income of unit by function subject, surplus number of paying and carry down
According to；
Judge the income of made a report on unit, pay and whether surplus data of carrying down meet built-in logic auditing formula, if so, then
By auditing in table, conversely, then prompting is filled in people and needs income to filling in, pays and surplus data of carrying down are modified, directly
It is met to built-in logic auditing formula；
The income of examination ＆ verification in table will be passed through, paid and carried down in surplus data Cun Chudao database.
4. a kind of method for quickly generating department's statement data according to claim 1, it is characterised in that：It is described to change
The integrated final accounts entered are made a report on draft and the project for making a report on unit are divided into into basic expenditure project and the special class of expenditure two, the base
This expenditure and special expenditure meet the service logic of setting, the expression formula of the service logic for setting as：Last year
Surplus+this annual income-this year of carrying down expenditure+make up balance of payment-surplus distribution=year end with enterprise fund is carried down surplus.
5. a kind of method for quickly generating department's statement data according to any one of claim 1-4, its feature exists
In：Described making a report in the data that draft is filled in from improved integrated final accounts is peeked automatically, and by every table of department's statement
The step for making a report on specification generation corresponding department's statement data, it includes：
It is determined that automatic access method and peek unit；
Automatic access method and peek unit according to selecting is made a report in the data that draft is filled in certainly from improved integrated final accounts
Data needed for dynamic acquisition department every table of statement；
According to the data, critical field and income, surplus data filling out by every table of department's statement of paying and carry down that obtain
Report specification generates corresponding department's statement data.
6. a kind of method for quickly generating department's statement data according to claim 5, it is characterised in that：It is described from
Access method and SQL query pin based on statement service logic of the dynamic access method including but not limited to based on retrieval function
This peek method, the peek unit includes but is not limited to cell and row, wherein, cell is used for fixed row and fixes row
Form is peeked, and is arranged for floating row and the form of fixed row is peeked.
7. a kind of system for quickly generating department's statement data, it is characterised in that：Including with lower module：
Initialization module, draft is made a report on for initializing unit information, and determining according to unit information in improved integrated final accounts
Middle data fill in logic, wherein, unit information includes but is not limited to organization, Institution Code, unit fundamental property and list
Position performs accounting system；
Data fill in module, for the receipts that sub-item in making a report on draft in improved integrated final accounts is made a report on unit by function subject
Enter, pay and carry down surplus data, and by table audit, the income of the unit, pay and carry down surplus data include but
Being not limited to carry down surplus, this annual income, this year expenditure and year end at the beginning of the year carries down surplus, and draft is made a report in the improved integrated final accounts
The budget enforcement and accounting overall process of unit are made a report in reflection, and are built-in with the critical field for filling in or selecting and confession
The logic auditing formula of examination ＆ verification in table, wherein, critical field includes but is not limited to unit fundamental property, unit and performs accounting system
Degree, entry property, project category, fund property and this grade of development concentrate the general public budget finance for arranging to dial with reform department
Money fund, logic auditing formula is income, the surplus of paying and carry down that critical field is made a report in draft with improved integrated final accounts
Logical relation between data；
Report generation module, peeks automatically for making a report in the data that draft is filled in from improved integrated final accounts, and determines by department
The specification of making a report on for calculating every table of form generates corresponding department's statement data.
8. a kind of system for quickly generating department's statement data according to claim 7, it is characterised in that：The number
Include according to module is filled in：
Critical field fills in unit, for filling in each critical field that form makes a report on unit, wherein, unit fundamental property includes
Administrative unit, reference Civil Service Law public institution, financial aid public institution, self-financed public institution and other unit；
Mesh property includes basic expenditure, administrative institution intermediate item, capital construction intermediate item and the item to manage；Fund property is pulled out including finance
Money, special family fund, floating capital and other funds；Unit performs accounting system includes accounting of governmental units system, public institution
Accounting system, sicentific research institute accounting system, middle and primary schools' accounting system, institution of higher education's accounting system, accounting regulations ror hospitals
With Basic medical and health institutions accounting system；Project category has determined project, regular special operating cost including State Council
Project, the expenditure that straddles over year and sundry item；This grade of development concentrates the general public budget finance for arranging to dial with reform department
Money fund includes it being that the general public budget financial allocation fund and the development of Fei Ben levels for arranging is concentrated in this grade of development with reform department
The general public budget financial allocation fund for arranging is concentrated with reform department；
Data fill in unit, for the receipts that sub-item in making a report on draft in improved integrated final accounts is made a report on unit by function subject
Enter, pay and carry down surplus data；
Judging unit, for judging the income of made a report on unit, pays and whether surplus data of carrying down meet built-in logic and examine
Core formula, if so, then by examination ＆ verification in table, conversely, then prompting fills in people's needs to the income filled in, surplus number of paying and carry down
According to modifying, until built-in logic auditing formula is met；
Memory cell, for will pass through to be audited in table income, pay and carry down in surplus data Cun Chudao database.
9. a kind of system for quickly generating department's statement data according to claim 7, it is characterised in that：State improvement
Integrated final accounts make a report on draft the project for making a report on unit be divided into into basic expenditure project and the special class of expenditure two, it is described basic
Expenditure and special expenditure meet the service logic of setting, the expression formula of the service logic for setting as：Last year ties
Turn surplus+this annual income-this year expenditure+make up balance of payment-surplus distribution=year end with enterprise fund to carry down surplus.
10. a kind of system for quickly generating department's statement data according to claim 7,8 or 9, it is characterised in that：
The report generation module includes：
Determining unit, for determining automatic access method and peek unit；
Peek unit, for making a report on draft from improved integrated final accounts and filling out according to the automatic access method and peek unit that select
Automatically the data needed for department's every table of statement are obtained in the data write；
Report data signal generating unit, for according to the data, critical field and income for obtaining, pay and surplus data of carrying down are by portion
The specification of making a report on of door every table of statement generates corresponding department's statement data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611032055.6A CN106598925A (en) | 2016-11-22 | 2016-11-22 | Method and system for quickly generating department final statement report data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611032055.6A CN106598925A (en) | 2016-11-22 | 2016-11-22 | Method and system for quickly generating department final statement report data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106598925A true CN106598925A (en) | 2017-04-26 |
Family
ID=58591581
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611032055.6A Pending CN106598925A (en) | 2016-11-22 | 2016-11-22 | Method and system for quickly generating department final statement report data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106598925A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108510380A (en) * | 2018-03-21 | 2018-09-07 | 安徽天勤盛创信息科技股份有限公司 | A kind of property tax analysis platform based on big data |
| CN109101470A (en) * | 2018-08-20 | 2018-12-28 | 齐鲁工业大学 | A kind of intelligent report system and its implementation |
| CN110263307A (en) * | 2019-04-15 | 2019-09-20 | 重庆金融资产交易所有限责任公司 | Report form generation method, server and computer readable storage medium |
| CN110858355A (en) * | 2018-08-22 | 2020-03-03 | 北京国双科技有限公司 | Project budget balance prediction method and device |
| CN113674073A (en) * | 2021-08-20 | 2021-11-19 | 广东电网有限责任公司 | Financial cross-domain fusion statistical statement system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101937463A (en) * | 2010-09-10 | 2011-01-05 | 西安交通大学 | Method for automatically generating form for workflow model |
| CN103778503A (en) * | 2013-12-29 | 2014-05-07 | 远光软件股份有限公司 | Report data locking method and device thereof |
| CN104615725A (en) * | 2015-02-09 | 2015-05-13 | 武汉众联信息技术股份有限公司 | Web-based online self-defined reporting method |
| CN105320690A (en) * | 2014-07-30 | 2016-02-10 | 北京中海纪元数字技术发展股份有限公司 | Metadata based rapid statistic form generation method and system |
| CN105843788A (en) * | 2016-03-31 | 2016-08-10 | 浪潮通信信息系统有限公司 | Report generation method and device |
-
2016
- 2016-11-22 CN CN201611032055.6A patent/CN106598925A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101937463A (en) * | 2010-09-10 | 2011-01-05 | 西安交通大学 | Method for automatically generating form for workflow model |
| CN103778503A (en) * | 2013-12-29 | 2014-05-07 | 远光软件股份有限公司 | Report data locking method and device thereof |
| CN105320690A (en) * | 2014-07-30 | 2016-02-10 | 北京中海纪元数字技术发展股份有限公司 | Metadata based rapid statistic form generation method and system |
| CN104615725A (en) * | 2015-02-09 | 2015-05-13 | 武汉众联信息技术股份有限公司 | Web-based online self-defined reporting method |
| CN105843788A (en) * | 2016-03-31 | 2016-08-10 | 浪潮通信信息系统有限公司 | Report generation method and device |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108510380A (en) * | 2018-03-21 | 2018-09-07 | 安徽天勤盛创信息科技股份有限公司 | A kind of property tax analysis platform based on big data |
| CN109101470A (en) * | 2018-08-20 | 2018-12-28 | 齐鲁工业大学 | A kind of intelligent report system and its implementation |
| CN110858355A (en) * | 2018-08-22 | 2020-03-03 | 北京国双科技有限公司 | Project budget balance prediction method and device |
| CN110263307A (en) * | 2019-04-15 | 2019-09-20 | 重庆金融资产交易所有限责任公司 | Report form generation method, server and computer readable storage medium |
| CN113674073A (en) * | 2021-08-20 | 2021-11-19 | 广东电网有限责任公司 | Financial cross-domain fusion statistical statement system |
| CN113674073B (en) * | 2021-08-20 | 2023-09-19 | 广东电网有限责任公司 | Financial cross-domain fusion statistical statement system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106598925A (en) | Method and system for quickly generating department final statement report data | |
| US8200557B2 (en) | Systems and methods for providing migration and performance matrices | |
| Leal et al. | Fiscal forecasting: lessons from the literature and challenges | |
| CN106022902A (en) | Accounting method and device | |
| CN106651573A (en) | Business data processing method and apparatus | |
| CN107644328A (en) | Generation method, device, medium and the electronic equipment of accounting voucher | |
| Schick | Reflections on two decades of public financial management reforms | |
| CN109740792A (en) | Data predication method, system, terminal and computer storage medium | |
| CN109754157A (en) | A kind of methods of marking and system for reflecting enterprise's health management, financing and increasing letter | |
| NGUYEN et al. | Bank-specific determinants of loan growth in Vietnam: Evidence from the CAMELS approach | |
| Rossi | Public sector accounting and auditing in Italy | |
| CN112419035A (en) | Intelligent accounting and intelligent management accounting information generation method and system | |
| CN110070426A (en) | A kind of Audit Report generation method | |
| CN108335087A (en) | Value-added tax invoice for sales data statistical approach based on EXCEL and device | |
| CN111861378A (en) | Reimbursement guide system, method and reimbursement device | |
| Lukkezen et al. | Stochastic debt sustainability indicators 1 | |
| Chumba et al. | Effect of financial investment strategies on the financial sustainability of universities in Kenya | |
| CN111652716A (en) | Method and device for determining label of account number | |
| Agbo et al. | Effects of treasury single account on performance and survival of deposit money banks in Nigeria | |
| Basistha et al. | Currency crises and output dynamics | |
| Ayadi et al. | Construction of financial social accounting matrix for Tunisia | |
| Chen et al. | Measuring the on-going changes in China's capital flow management: a de jure and a hybrid index data set | |
| Yamaguchi | Developing an asd macroeconomic model of the stock approach-with emphasis on bank lending and interest rates | |
| Marshall et al. | Response to the GASB Invitation to Comment on Financial Reporting Model Improvements—Governmental Funds (Project No. 3-25I) | |
| Ahmed Maude | Moderating Effect of Industry Concentration on the Effect of Camels Financial Indicators on Financial Performance of Deposit Money Banks in Nigeria |
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: 20170426 |