CN110457308A - A kind of accounting data processing analysis method and system - Google Patents
A kind of accounting data processing analysis method and system Download PDFInfo
- Publication number
- CN110457308A CN110457308A CN201910519103.1A CN201910519103A CN110457308A CN 110457308 A CN110457308 A CN 110457308A CN 201910519103 A CN201910519103 A CN 201910519103A CN 110457308 A CN110457308 A CN 110457308A
- Authority
- CN
- China
- Prior art keywords
- money
- amount
- materials
- goods
- reconciliation
- 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
- 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/23—Updating
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06313—Resource planning in a project environment
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- 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)
- Theoretical Computer Science (AREA)
- Human Resources & Organizations (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- Databases & Information Systems (AREA)
- Strategic Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Data Mining & Analysis (AREA)
- Entrepreneurship & Innovation (AREA)
- General Engineering & Computer Science (AREA)
- General Business, Economics & Management (AREA)
- Development Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- Life Sciences & Earth Sciences (AREA)
- Biodiversity & Conservation Biology (AREA)
- Educational Administration (AREA)
- Game Theory and Decision Science (AREA)
- Software Systems (AREA)
- Technology Law (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The present invention relates to a kind of accounting data processing analysis methods and system, belong to enterprise information management system technical field, solve the problems, such as that reconciliation error rate is high caused by existing Finance Department and business department's management dimension are inconsistent, complexity is big.Steps are as follows: transferred from the goods and materials system of resources area it is in the reconciliation period, using expense project as dimension go out storage monthly magazine business datum;Expense project goods and materials and material depot relation table are transferred, the business datum in storage monthly magazine is adjusted out, generates using material depot as the business datum of dimension;From the financial data using material depot as its dimension transferred in financial system in the reconciliation period;On the basis of material depot, the account column total amount in the materials warehousing total amount and corresponding financial data in business datum is compared, until this overall situation reconciliation terminates;Judge whether this global reconciliation succeeds, if so, minute book period overall situation reconciliation success, generates goods and materials reconciliation summary sheet, the reconciliation of this period terminates.
Description
Technical field
The present invention relates to enterprise information management system technical field more particularly to a kind of accounting data processing analysis method and
System.
Background technique
When universal engineering project handling of goods and materials, accounting dimension and business department of the Finance Department to engineering or non-engineering material
The accounting dimension of door is inconsistent.General business process is:
Resources area from engineering project or the dimension of expense project, make a report on this resources area the storage amount of money,
The outbound amount of money allots the amount of money, and provides and incidence relation is monthly not present between goods and materials monthly magazine, with material depot;And Finance Department
Then from the dimension of financial indicator or material depot, the corresponding financial affairs receipt of each material depot is made.
Since the accounting dimension of Finance Department's book keeping operation is extensive compared with resources area, the dimension of business account and financial account management is not
Together, cause reconciliation miswork rate height, work complexity big.
Simultaneously as being stored with mass data in existing resources area tables of data and Finance Department's tables of data, and number
It according to an incidence relation complexity, pulls one hair and move the whole body, not the data knot of the existing resources area of malleable and Finance Department's storage
Structure.On this basis, data dimension, reduction work complexity and the reconciliation for how unifying resources area and Finance Department work out
The problem of error rate is this field urgent need to resolve.
Summary of the invention
In view of above-mentioned analysis, the present invention is intended to provide a kind of goods and materials account checking method and system, to solve existing finance
The problem that reconciliation miswork rate is high, work complexity is big caused by department and business department's management dimension are inconsistent.
The purpose of the present invention is mainly achieved through the following technical solutions:
A kind of accounting data processing analysis method, pre-establishes the corresponding relationship between expense project and material depot,
Formation expense project and material depot relation table;
By the goods and materials reconciliation systemic presupposition automatic reconciliation period, the reconciliation period, then the goods and materials reconciliation system executed as follows
Step:
It is transferred from the goods and materials system of resources area in the reconciliation period and goes out storage monthly magazine, the industry in the monthly magazine of storage out
Using expense project as dimension, record has the storage amount of money of each expense project, the outbound amount of money, allots the amount of money, moves data of being engaged in
The library amount of money;
The expense project goods and materials and material depot relation table are transferred, and according to the expense project goods and materials and goods and materials
Relation table adjustment in warehouse is described to go out to be put in storage the business datum in monthly magazine, generates using material depot as the business datum of dimension, record
There is the storage amount of money of each material depot, the outbound amount of money, allots the amount of money, moves the library amount of money and materials warehousing total amount;
From the financial data transferred in the reconciliation period in financial system, the financial data is using material depot as its dimension
Degree, record have the storage column account amount of money of each material depot, the outbound column account amount of money, allot the column account amount of money, move the library column account amount of money and
Ending balance;
On the basis of material depot, compare in the materials warehousing total amount and corresponding financial data in the business datum
Ending balance, until this overall situation reconciliation terminate;
Judge whether this global reconciliation succeeds, if so, minute book period overall situation reconciliation success, generates goods and materials reconciliation and converge
Summary table, the reconciliation of this period terminate.
On the basis of above scheme, the present invention has also done following improvement:
Further, it if this global reconciliation is unsuccessful, on the basis of material depot, is compared in the business datum respectively
The storage amount of money and financial data in the storage column account amount of money, the outbound column in the outbound amount of money and financial data in business datum
In the account amount of money, business datum allot in the amount of money and financial data allot the column account amount of money, the shifting library amount of money in business datum and
The shifting library column account amount of money in financial data, differences are searched, and according to the differences, from the goods and materials system of resources area
It transfers corresponding detailed data, transfer corresponding financial affairs receipt from financial system, screen wrong account and do not do the data information of account.
Further, when the differences result from the storage amount of money in the business datum and the storage column in financial data
When the account amount of money, comprehensive storage bill is transferred from the goods and materials system of resources area, the comprehensive storage unirecord has each expense item
The corresponding storage record of mesh, the storage is recorded and is compared with the corresponding financial affairs receipt in financial system, screening error
Account and the data information for not doing account.
Further, when the differences result from the outbound amount of money in the business datum and the outbound column in financial data
When the account amount of money, comprehensive material requistion is transferred from the goods and materials system of resources area, the comprehensive material requistion record has each expense item
The corresponding outbound record of mesh, the outbound record is compared with the corresponding financial affairs receipt in financial system, screening error
Account and the data information for not doing account.
Further, column are alloted when the differences result from alloting in the amount of money and financial data in the business datum
When the shifting library column account amount of money moved in the library amount of money and financial data in the account amount of money, business datum, from the goods and materials system of resources area
In transfer and move library/requisition slip, there is the corresponding shifting library of each expense project in the shiftings library/allot unirecord, allots record, will described in
Outbound record is compared with the corresponding financial affairs receipt in financial system, screening error account and the data information for not doing account.
Further, described to transfer the expense project goods and materials and material depot relation table, and according to the expense item
Business datum in mesh goods and materials and the material depot relation table adjustment monthly magazine of storage out, generates using material depot as the industry of dimension
Business data, comprising:
For every business datum using expense project as its dimension, closed from the expense project and material depot
It is the determining material depot with the expense item association in table, converts the business datum to using material depot as dimension
Business datum;
The identical business datum of a plurality of material depot if it exists, by it according to storage, outbound, allot, move library and sort out respectively
Summarize the amount of money, generates final using material depot as the business datum of dimension.
Further, the corresponding relationship pre-established between expense project and material depot forms expense project
With material depot relation table, comprising:
When the raw material of expense project have outbound, are put in storage, allot or move library movement, the outbound, storage, tune are recorded
The account amount of money and associated material depot in library are dialled or moved, expense project and material depot relation table are formed.
Further, when the corresponding relationship between the expense project and material depot changes, real-time update institute
State expense project and material depot relation table.
Further, the goods and materials reconciliation system is before transferring the data of the goods and materials system and financial system, the goods and materials
To the goods and materials system and financial system check information occurs for reconciliation system respectively, is confirmed by the goods and materials system and financial system
Data are executed after the check information is errorless transfers process.
The present invention also provides a kind of accounting datas to handle analysis system, comprising: the object of goods and materials reconciliation system, resources area
Resource system, financial system and relationship storage module;Wherein,
The relationship storage module be stored with it is pre-establishing, according to corresponding relationship between expense project and material depot
Formation expense project and material depot relation table;
The goods and materials system of the resources area is stored with the storage monthly magazine out of material information, described to go out to be put in storage the industry in monthly magazine
Using expense project as dimension, record has the storage amount of money of each expense project, the outbound amount of money, allots the amount of money, moves data of being engaged in
The library amount of money;
The financial system is stored with financial data, and using material depot as its dimension, record has every the financial data
The storage column account amount of money of one material depot, allots the column account amount of money, moves the library column account amount of money and ending balance the outbound column account amount of money;;
Go out storage monthly magazine, finance system in goods and materials system of the goods and materials system of the resources area by calling resources area
The expense project and material depot relation table in financial data and relationship storage module in system executes following operation, real
Existing accounting data processing analysis:
The expense project goods and materials and material depot relation table are transferred, and according to the expense project goods and materials and goods and materials
Relation table adjustment in warehouse is described to go out to be put in storage the business datum in monthly magazine, generates using material depot as the business datum of dimension, record
There is the storage amount of money of each material depot, the outbound amount of money, allots the amount of money, moves the library amount of money and materials warehousing total amount;
On the basis of material depot, compare in the materials warehousing total amount and corresponding financial data in the business datum
Ending balance, until this overall situation reconciliation terminate;
Judge whether this global reconciliation succeeds, if so, minute book period overall situation reconciliation success, generates goods and materials reconciliation and converge
Summary table, the reconciliation of this period terminate.
The present invention has the beneficial effect that: this patent application is remembered based on unified handling of goods and materials business department and Finance Department
Account dimension, effective administration fee project goods and materials realize the thought from kinetonucleus account.Pipe is carried out with warehouse with expense project goods and materials
Reason thought is core, is correspondingly arranged function by expense project and material depot, by the goods and materials monthly magazine of resources area, goes out to be put in storage
The business datums such as detail are shown and are compared with material depot dimension with Finance Department's accounting data, on the one hand can check object
In resource system each business paper whether mistakes and omissions, on the one hand can check financial system book keeping operation whether mistakes and omissions, and based on verification after
Reconciliation data form reconciliation conclusion and temporarily estimate storage conclusion.Since the present embodiment is identical as above method embodiment principle, so
This system also has the corresponding technical effect of above method embodiment.
It in the present invention, can also be combined with each other between above-mentioned each technical solution, to realize more preferred assembled schemes.This
Other feature and advantage of invention will illustrate in the following description, also, certain advantages can become from specification it is aobvious and
It is clear to, or understand through the implementation of the invention.The objectives and other advantages of the invention can by specification, claims with
And it is achieved and obtained in specifically noted content in attached drawing.
Detailed description of the invention
Attached drawing is only used for showing the purpose of specific embodiment, and is not to be construed as limiting the invention, in entire attached drawing
In, identical reference symbol indicates identical component.
Fig. 1 is that accounting data handles analysis method flow chart in the embodiment of the present invention 1;
Fig. 2 is that accounting data handles resources area and Finance Department's data relationship in analysis method in the embodiment of the present invention 1
Schematic diagram.
Specific embodiment
Specifically describing the preferred embodiment of the present invention with reference to the accompanying drawing, wherein attached drawing constitutes the application a part, and
Together with embodiments of the present invention for illustrating the principle of the present invention, it is not intended to limit the scope of the present invention.
Embodiment 1
A specific embodiment of the invention discloses a kind of accounting data processing analysis method, method flow diagram such as Fig. 1
It is shown, resources area and data relationship schematic diagram such as Fig. 2 institute, Finance Department in the accounting data processing analysis method being directed to
Show, pre-establish the corresponding relationship between expense project and material depot, forms expense project and material depot relation table;
By the goods and materials reconciliation systemic presupposition automatic reconciliation period, the reconciliation period, then the goods and materials reconciliation system executed following steps:
Step S1: it is transferred from the goods and materials system of resources area in the reconciliation period and goes out storage monthly magazine, the storage moon out
Using expense project as dimension, record has the storage amount of money of each expense project, the outbound amount of money, allots business datum in report
The amount of money moves the library amount of money;
Step S2: the expense project goods and materials and material depot relation table are transferred, and according to the expense project object
Money and the business datum in the material depot relation table adjustment monthly magazine of storage out, generate using material depot as the business number of dimension
According to record has the storage amount of money of each material depot, the outbound amount of money, allots the amount of money, moves the library amount of money and materials warehousing total amount;
For every business datum using expense project as its dimension, closed from the expense project and material depot
It is the determining material depot with the expense item association in table, converts the business datum to using material depot as dimension
Business datum;The identical business datum of a plurality of material depot if it exists, by it according to storage, outbound, allot, move library and return respectively
Class summarizes the amount of money, generates final using material depot as the business datum of dimension.
Step S3: from the financial data transferred in the reconciliation period in financial system, the financial data is made with material depot
For its dimension, record has the storage column account amount of money of each material depot, the outbound column account amount of money, allots the column account amount of money, moves library column account
The amount of money and ending balance;
Step S4: on the basis of material depot, the materials warehousing total amount in the business datum and corresponding wealth are compared
Ending balance in data of being engaged in, until this overall situation reconciliation terminates;
Step S5: judging whether this global reconciliation succeeds, if so, minute book period overall situation reconciliation success, product
Reconciliation summary sheet is provided, the reconciliation of this period terminates.
Step S6: it if this global reconciliation is unsuccessful, on the basis of material depot, is compared in the business datum respectively
The storage amount of money and financial data in the storage column account amount of money, the outbound column in the outbound amount of money and financial data in business datum
In the account amount of money, business datum allot in the amount of money and financial data allot the column account amount of money, the shifting library amount of money in business datum and
The shifting library column account amount of money in financial data searches differences, and according to the differences, adjusts from the goods and materials system of resources area
It takes corresponding detailed data, transfer corresponding financial affairs receipt from financial system, screen wrong account and do not do the data information of account.
For further analyze wrong account and do not do account data information source, it is also necessary to execute following operation:
Step S61: when the differences result from the storage amount of money in the business datum and the storage in financial data
When the column account amount of money, comprehensive storage bill is transferred from the goods and materials system of resources area, the comprehensive storage unirecord has each expense
The corresponding storage record of project, the storage is recorded and is compared with the corresponding financial affairs receipt in financial system, is filtered out
Wrong account and the data information for not doing account.
Step S62: when the differences result from the outbound amount of money in the business datum and the outbound in financial data
When the column account amount of money, comprehensive material requistion is transferred from the goods and materials system of resources area, the comprehensive material requistion record has each expense
The corresponding outbound record of project, the outbound record is compared with the corresponding financial affairs receipt in financial system, is filtered out
Wrong account and the data information for not doing account.
Step S63: alloting in the amount of money and financial data is alloted when the differences result from the business datum
The shifting library column account amount of money moved in the library amount of money and financial data in the column account amount of money, business datum constantly, from the goods and materials of resources area
It is transferred in system and moves library/requisition slip, there is the corresponding shifting library of each expense project in the shiftings library/allot unirecord, allots record, general
The outbound record is compared with the corresponding financial affairs receipt in financial system, screening error account and the data letter for not doing account
Breath.
Preferably, the corresponding relationship pre-established between expense project and material depot forms expense project
With material depot relation table, comprising: when the raw material of expense project have outbound, are put in storage, allot or move library movement, record institute
The account amount of money and associated material depot stated outbound, be put in storage, allot or move library form expense project and material depot
Relation table.When the corresponding relationship between the expense project and material depot changes, expense described in real-time update
Project and material depot relation table.
For the safety for guaranteeing resources area data service data and financial data, the goods and materials reconciliation system transfer it is described
Before goods and materials system and the data of financial system, to the goods and materials system and financial system school occurs for the goods and materials reconciliation system respectively
Information is tested, confirms that executing data after the check information is errorless transfers process by the goods and materials system and financial system.
Embodiment 2
It is by object that the present invention, which gives an accounting data processing analysis example in financial management software goods and materials reconciliation,
Resource system business datum is that connection carries out business datum and financial data with a corresponding relationship with financial system accounting data
Reconciliation analysis.
If this month has the raw material of expense project tetra- projects of A, B, C, D to have storage, outbound, the warehouse pipe alloted
Reason, financial accounting and goods and materials reconciliation, the goods and materials of A and B project are stored in warehouse 1, and the goods and materials of C and D project are stored in warehouse 2.
Financial staff logs on to goods and materials reconciliation micro services, the first step by " cost project maintenance " function by A, B, C,
Tetra- project maintenances of D are into micro services;
Function is corresponding with warehouse 1 by A, B project by " repository entry correspondence setting " for second step, C, D project and storehouse
Library 2 is corresponding, and resources area personnel carry out storehouse management storage according to " expense project and material depot corresponding relationship ";
Third step financial staff when expense project goods and materials are kept accounts, calculate and choose corresponding material depot by auxiliary;
When the 4th step end of each month carried out goods and materials reconciliation, Finance Department personnel are by project A, B, C, D goods and materials in goods and materials system
Monthly magazine, storage bill detail, outbound list detail, requisition slip detail export and imported into " the goods and materials reconciliation remittance of goods and materials reconciliation micro services
In the reconciliations function such as summary table ", " storage difference Macro or mass analysis ", " outbound variance analysis ", " alloting variance analysis ";Each reconciliation function
The business datum and financial system for taking importing respectively calculate accounting data, according to the setting of second step, with the dimension in warehouse 1, warehouse 2
Degree, which summarizes, shows business datum and accounting data, and carries out reconciliation analysis;Analyze discrepant warehouse entry business number and wealth
Business storage book keeping operation number carries out the matching of storage detail and financial affairs receipt detail, the detail mark not matched again according to built-in rule
It is denoted as " not keeping accounts ", is verified for Finance Department personnel;" not keeping accounts " for having verified storage detail is formed and temporarily estimates storage conclusion confession
Next month reconciliation uses.
Finance Department personnel can real-time perfoming reconciliation analysis, according to reconciliation as a result, searching wrong account, leakage bill according to being remembered
Account adjustment, final output reconciliation conclusion adjusted.
Embodiment 3
The present invention also provides a kind of accounting datas to handle analysis system, comprising: the object of goods and materials reconciliation system, resources area
Resource system, financial system and relationship storage module;Wherein, the relationship storage module be stored with it is pre-establishing, according to expense
Property project and material depot between corresponding relationship form expense project and material depot relation table;The goods and materials of the resources area
System be stored with material information go out storage monthly magazine, it is described go out storage monthly magazine in business datum using expense project as dimension,
Record has the storage amount of money of each expense project, the outbound amount of money, allots the amount of money, moves the library amount of money;The financial system is stored with
Financial data, using material depot as its dimension, record has the storage column account amount of money of each material depot, goes out the financial data
The library column account amount of money allots the column account amount of money, moves the library column account amount of money and ending balance;The goods and materials system of the resources area passes through calling
Go out storage monthly magazine, the financial data in financial system and the expense in relationship storage module in the goods and materials system of resources area
Property project and material depot relation table, execute following operation, realize accounting data processing analysis:
The expense project goods and materials and material depot relation table are transferred, and according to the expense project goods and materials and goods and materials
Relation table adjustment in warehouse is described to go out to be put in storage the business datum in monthly magazine, generates using material depot as the business datum of dimension, record
There is the storage amount of money of each material depot, the outbound amount of money, allots the amount of money, moves the library amount of money and materials warehousing total amount;
On the basis of material depot, compare in the materials warehousing total amount and corresponding financial data in the business datum
Ending balance, until this overall situation reconciliation terminate;
Judge whether this global reconciliation succeeds, if so, minute book period overall situation reconciliation success, generates goods and materials reconciliation and converge
Summary table, the reconciliation of this period terminate.
The specific implementation process of present system embodiment is referring to above method embodiment, and the present embodiment is herein no longer
It repeats.Since the present embodiment is identical as above method embodiment principle, so this system also has above method embodiment corresponding
Technical effect.
It will be understood by those skilled in the art that realizing all or part of the process of above-described embodiment method, meter can be passed through
Calculation machine program is completed to instruct relevant hardware, and the program can be stored in computer readable storage medium.Wherein, institute
Stating computer readable storage medium is disk, CD, read-only memory or random access memory etc..
The foregoing is only a preferred embodiment of the present invention, but scope of protection of the present invention is not limited thereto,
In the technical scope disclosed by the present invention, any changes or substitutions that can be easily thought of by anyone skilled in the art,
It should be covered by the protection scope of the present invention.
Claims (10)
1. a kind of accounting data handles analysis method, which is characterized in that pre-establish between expense project and material depot
Corresponding relationship forms expense project and material depot relation table;
By the goods and materials reconciliation systemic presupposition automatic reconciliation period, the reconciliation period, then the goods and materials reconciliation system executed following steps:
It is transferred from the goods and materials system of resources area in the reconciliation period and goes out storage monthly magazine, the business number in the monthly magazine of storage out
Expense project is dimension accordingly, and record has the storage amount of money of each expense project, the outbound amount of money, allots the amount of money, moves library gold
Volume;
The expense project goods and materials and material depot relation table are transferred, and according to the expense project goods and materials and material depot
Relation table adjustment is described to go out to be put in storage the business datum in monthly magazine, generates using material depot as the business datum of dimension, record has every
The storage amount of money of one material depot, allots the amount of money, moves the library amount of money and materials warehousing total amount the outbound amount of money;
From the financial data transferred in the reconciliation period in financial system, the financial data is using material depot as its dimension, note
Record has the storage column account amount of money of each material depot, the outbound column account amount of money, allots the column account amount of money, moves the library column account amount of money and more than the end of term
Volume;
On the basis of material depot, the phase in the materials warehousing total amount and corresponding financial data in the business datum is compared
Last remaining sum, until this overall situation reconciliation terminates;
Judge whether this global reconciliation succeeds, if so, minute book period overall situation reconciliation success, generates goods and materials reconciliation and summarize
Table, the reconciliation of this period terminate.
2. accounting data according to claim 1 handles analysis method, which is characterized in that if this global reconciliation not at
Function compares the storage amount of money in the business datum and the storage column account gold in financial data on the basis of material depot respectively
The outbound amount of money in volume, business datum and the outbound column account amount of money in financial data allot the amount of money and finance in business datum
The column account amount of money, the shifting library column account amount of money moved in the library amount of money and financial data in business datum are alloted in data, searches difference
, and according to the differences, corresponding detailed data is transferred from the goods and materials system of resources area, is transferred from financial system
Corresponding financial affairs receipt screens wrong account and does not do the data information of account.
3. accounting data according to claim 2 handles analysis method, which is characterized in that when the differences result from institute
When stating the storage column account amount of money being put in storage in the amount of money and financial data in business datum, transferred from the goods and materials system of resources area
Comprehensive storage bill, the comprehensive storage unirecord has the corresponding storage record of each expense project, by storage record and wealth
Corresponding financial affairs receipt in business system is compared, screening error account and the data information for not doing account.
4. accounting data according to claim 2 handles analysis method, which is characterized in that when the differences result from institute
When stating the outbound amount of money in business datum and the outbound column account amount of money in financial data, transferred from the goods and materials system of resources area
Comprehensive material requistion, the comprehensive material requistion record have the corresponding outbound record of each expense project, and the outbound is recorded and wealth
Corresponding financial affairs receipt in business system is compared, screening error account and the data information for not doing account.
5. accounting data according to claim 2 handles analysis method, which is characterized in that when the differences result from institute
It states alloting in the amount of money and financial data in business datum and allots the column account amount of money, the shifting library amount of money in business datum and financial number
It when the shifting library column account amount of money in, is transferred from the goods and materials system of resources area and moves library/requisition slip, the shiftings library/requisition slip is remembered
Record has corresponding the shiftings library of each expense project, allots record, by the outbound record it is corresponding with financial system it is financial with
Card is compared, screening error account and the data information for not doing account.
6. goods and materials account checking method according to claim 1, which is characterized in that it is described transfer the expense project goods and materials with
Material depot relation table, and go out to be put in storage in monthly magazine according to the expense project goods and materials and the adjustment of material depot relation table are described
Business datum is generated using material depot as the business datum of dimension, comprising:
For every business datum using expense project as its dimension, from the expense project and material depot relation table
The business datum is converted the industry using material depot as dimension by the material depot of middle determination and the expense item association
Business data;
The identical business datum of a plurality of material depot if it exists, by it according to storage, outbound, allot, move library and sort out respectively and summarize
The amount of money generates final using material depot as the business datum of dimension.
7. accounting data according to claim 1 to 6 handles analysis method, which is characterized in that described to build in advance
Corresponding relationship between vertical expense project and material depot, forms expense project and material depot relation table, comprising:
When the raw material of expense project have outbound, be put in storage, allot or move library movement when, record the outbound, be put in storage, allot or
The account amount of money and associated material depot in library are moved, expense project and material depot relation table are formed.
8. accounting data according to claim 7 handles analysis method, which is characterized in that when the expense project and object
When corresponding relationship between money warehouse changes, expense project and material depot relation table described in real-time update.
9. accounting data according to claim 1 handles analysis method, which is characterized in that the goods and materials reconciliation system is being adjusted
Before taking the goods and materials system and the data of financial system, the goods and materials reconciliation system is respectively to the goods and materials system and financial system
Check information occurs, is confirmed by the goods and materials system and financial system and executes transferring for data after the check information is errorless
Journey.
10. a kind of accounting data handles analysis system, which is characterized in that the system comprises: goods and materials reconciliation system, resources area
Goods and materials system, financial system and relationship storage module;Wherein,
The relationship storage module be stored with it is pre-establishing, formed according to corresponding relationship between expense project and material depot
Expense project and material depot relation table;
The goods and materials system of the resources area is stored with the storage monthly magazine out of material information, described to go out to be put in storage the business number in monthly magazine
Expense project is dimension accordingly, and record has the storage amount of money of each expense project, the outbound amount of money, allots the amount of money, moves library gold
Volume;
The financial system is stored with financial data, and for the financial data using material depot as its dimension, record has each object
The storage column account amount of money in warehouse is provided, the outbound column account amount of money, the column account amount of money is alloted, moves the library column account amount of money and ending balance;
In the monthly magazine of storage out, financial system in goods and materials system of the goods and materials system of the resources area by calling resources area
Financial data and expense project and material depot relation table in relationship storage module, execute following operation, realize account
Business Data Management Analysis:
The expense project goods and materials and material depot relation table are transferred, and according to the expense project goods and materials and material depot
Relation table adjustment is described to go out to be put in storage the business datum in monthly magazine, generates using material depot as the business datum of dimension, record has every
The storage amount of money of one material depot, allots the amount of money, moves the library amount of money and materials warehousing total amount the outbound amount of money;
On the basis of material depot, the phase in the materials warehousing total amount and corresponding financial data in the business datum is compared
Last remaining sum, until this overall situation reconciliation terminates;
Judge whether this global reconciliation succeeds, if so, minute book period overall situation reconciliation success, generates goods and materials reconciliation and summarize
Table, the reconciliation of this period terminate.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910519103.1A CN110457308A (en) | 2019-06-18 | 2019-06-18 | A kind of accounting data processing analysis method and system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910519103.1A CN110457308A (en) | 2019-06-18 | 2019-06-18 | A kind of accounting data processing analysis method and system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110457308A true CN110457308A (en) | 2019-11-15 |
Family
ID=68480758
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910519103.1A Pending CN110457308A (en) | 2019-06-18 | 2019-06-18 | A kind of accounting data processing analysis method and system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110457308A (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112258151A (en) * | 2020-10-16 | 2021-01-22 | 广东电网有限责任公司 | Reconciliation method and device based on pandas, computer equipment and storage medium |
CN113421066A (en) * | 2021-07-15 | 2021-09-21 | 郑州工程技术学院 | Method for monitoring school financial fund flow direction based on data tracking model |
-
2019
- 2019-06-18 CN CN201910519103.1A patent/CN110457308A/en active Pending
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112258151A (en) * | 2020-10-16 | 2021-01-22 | 广东电网有限责任公司 | Reconciliation method and device based on pandas, computer equipment and storage medium |
CN112258151B (en) * | 2020-10-16 | 2023-10-24 | 广东电网有限责任公司 | Pampas-based account checking method, device, computer equipment and storage medium |
CN113421066A (en) * | 2021-07-15 | 2021-09-21 | 郑州工程技术学院 | Method for monitoring school financial fund flow direction based on data tracking model |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US8121385B1 (en) | System and method for generating magnetic ink character recognition (MICR) testing documents | |
Lewis et al. | Software testing and continuous quality improvement | |
US7523068B2 (en) | Centralized payment processing system | |
US20180144276A1 (en) | System, method and apparatus for converting the business processes to test-centric activity diagrams | |
US20080109467A1 (en) | Data entity centric approach for designing workflows | |
US20110066601A1 (en) | Information lifecycle cross-system reconciliation | |
US20180255160A1 (en) | Computerized accounting information system and a method of processing accounting data | |
US20210326350A1 (en) | Systems and Methods for Unifying Formats and Adaptively Automating Processing of Business Records Data | |
WO2012088427A2 (en) | Method and system of generating audit procedures and forms | |
WO2021227444A1 (en) | Accounting report generation method and apparatus, and electronic device | |
CN110457308A (en) | A kind of accounting data processing analysis method and system | |
CN106056418A (en) | Invoice submission method, device and system | |
CN108876584A (en) | A kind of personnel's revenue control and Individual Income Tax accounting system, method and electronic equipment | |
AU2011204930B2 (en) | Capturing and processing data generated in an ERP interim phase | |
Ganapathy | Robotic process automation: end from entrepreneurial content editing to go live | |
JP2008077149A (en) | Document generation support program, document generation support device, and document generation support system | |
Malviya et al. | The changing face of accounting: Prospects and issues in the application of artificial intelligence | |
Sretenovic et al. | Model payment order in the SEPA system | |
Pau et al. | Data warehouse model for audit trail analysis in workflows | |
US20150379487A1 (en) | System and method to facilitate the exchange of payment information | |
Garmus | Certified function point specialist examination guide | |
Sasso et al. | The practice of office analysis: objectives, obstacles, and opportunities | |
US20060195393A1 (en) | Creation of recurring transactions | |
Khan et al. | RPA Using UiPATH in the Context of Next Generation Automation | |
KR20220106610A (en) | System and method for calculating expense |
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 |