Accounting data processing and analyzing method and system

A technology of accounting data and analysis methods, which is applied in the field of accounting data processing and analysis methods and systems, and can solve problems such as high error rate in reconciliation work, high complexity of work, and inconsistent management dimensions between the financial department and the business department.

Pending Publication Date: 2019-11-15
CHUXIONG POWER SUPPLY BUREAU OF YUNNAN POWER GRID CO LTD
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] In view of the above analysis, the present invention aims to provide a material reconciliation method and system to solve the problems of high error rate and high complexity of reconciliation work caused by the inconsistency of management dimensions between the existing financial department and business department

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Accounting data processing and analyzing method and system
  • Accounting data processing and analyzing method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0042] A specific embodiment of the present invention discloses a method for processing and analyzing account data, the method flow chart is as follows figure 1 As shown, the schematic diagram of the data relationship between the material department and the financial department in the accounting data processing and analysis method involved is as follows figure 2As shown, the corresponding relationship between the expense item and the material warehouse is established in advance, and the relationship table between the expense item and the material warehouse is formed; the automatic reconciliation cycle is preset by the material reconciliation system, and when the reconciliation cycle expires, the material reconciliation The system performs the following steps:

[0043] Step S1: Retrieve the monthly inbound and outbound report during the reconciliation period from the material system of the material department. The business data in the monthly inbound and outbound report takes ...

Embodiment 2

[0057] The present invention also provides an example of accounting data processing and analysis. In the material reconciliation of financial management software, the business data of the material system and the accounting data of the financial system are connected by a corresponding relationship to perform reconciliation analysis of business data and financial data. .

[0058] If there are four items of expense items A, B, C, and D in the current month, the raw materials of the four items are warehouse management, financial accounting, and material reconciliation for warehousing, outbound, and allocation. The materials for A and B items are stored in warehouse 1, C The materials of Project D and D are stored in Warehouse 2.

[0059] The financial personnel log in to the material reconciliation micro-service, and the first step is to maintain the four items of A, B, C, and D into the micro-service through the "cost item maintenance" function;

[0060] The second step is to us...

Embodiment 3

[0065] The present invention also provides an accounting data processing and analysis system, including: a material reconciliation system, a material system of the material department, a financial system, and a relationship storage module; The corresponding relationship between the project and the material warehouse forms a relationship table between the cost item and the material warehouse; the material system of the material department stores the monthly report of material information, and the business data in the monthly report is based on the cost item. Dimension, which records the storage amount, output amount, allocation amount, and transfer amount of each expense item; the financial system stores financial data, and the financial data takes the material warehouse as its dimension, and records the amount of each material The amount listed in the warehouse, the amount listed in the warehouse, the amount listed in the transfer, the amount listed in the warehouse, and the en...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention relates to an accounting data processing and analyzing method and system, belongs to the technical field of enterprise information management systems, and solves the problems of high account checking error rate and high complexity caused by inconsistent management dimensions of financial departments and business departments in the prior art. The method comprises the following steps of: calling warehouse-in and warehouse-out monthly report service data taking an expense project as a dimension in an account checking period from a material system of a material department; calling anexpense project material and material warehouse relation table, adjusting service data in the warehouse-in and warehouse-out monthly report, and generating service data taking a material warehouse asa dimension; calling financial data taking a material warehouse as a dimension in an account checking period from a financial system; taking the material warehouse as a reference, and comparing the total amount of the material warehouse in the service data with the listed total amount of the accounting affairs in the corresponding financial data until the global account checking is finished; andjudging whether the global reconciliation is successful or not, if so, recording that the global reconciliation in the period is successful, generating a material reconciliation summary sheet, and ending the reconciliation in the period.

Description

technical field [0001] The invention relates to the technical field of enterprise information management systems, in particular to a method and system for processing and analyzing account data. Background technique [0002] In general engineering project material management, the accounting dimension of the financial department for engineering or non-engineering materials is inconsistent with that of the business department. The general business process is: [0003] The material department starts from the dimension of engineering projects or cost items, fills in the storage amount, output amount, and transfer amount of the material department, and issues monthly material reports, and there is no relationship with the material warehouse; while the financial department Then start from the dimension of financial items or material warehouses, and make financial vouchers corresponding to each material warehouse. [0004] Since the accounting dimension of the accounting departmen...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F16/22G06F16/23G06F16/28G06Q10/06G06Q10/08G06Q40/00
CPCG06F16/2282G06F16/23G06F16/284G06Q10/06313G06Q10/087G06Q40/125
Inventor 杨柳李开良陈思元汪雅劼
Owner CHUXIONG POWER SUPPLY BUREAU OF YUNNAN POWER GRID CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap