Patent multi-dimensional monthly bill merging method and system

Abstract

The invention relates to the technical field of financial system computers, in particular to a patent multi-dimensional monthly bill merging method and system, and the method comprises the following steps: obtaining the specific information of all approved contracts of a company; the charging system generates a corresponding charging order according to the contract; the charging system generates monthly bill information according to the charging order, the monthly user use condition and the contract payment node; carrying out bill merging on the obtained bill information through a bill merging rule algorithm; and finally, the whole income statistics of the company in the month is completed and related financial statements are issued. The patent multi-dimensional monthly bill merging method and system provided by the invention have the beneficial effects that corresponding orders and bills are generated by acquiring the specific contract information of each company, and finally the overall income of the company is confirmed. The method finally solves the problem of overlong monthly settlement time caused by large monthly bill amount of a company, and is high in credibility, high in efficiency and convenient to operate.

Description

Technical Field

[0001] The present invention relates to the field of financial system computer technology, and in particular to a patented multi-dimensional monthly bill merging method and system. Background Art

[0002] Cloud services are a pattern of adding, using and interacting with Internet-based services, usually involving the provision of dynamically scalable and often virtualized resources over the Internet. Cloud is a metaphor for the network and the Internet. In the past, clouds were often used in diagrams to represent telecommunications networks, and later they were also used to represent the abstraction of the Internet and underlying infrastructure. Cloud services refer to obtaining required services through the network in an on-demand, scalable manner. Such services can be IT and software, Internet-related, or other services. It means that computing power can also be circulated as a commodity over the Internet.

[0003] As a large cloud service provider, the company has hundreds of subsidiaries, and the business content of each subsidiary is different. As the company's overall business volume grows, a large number of bills will be issued between each subsidiary every month. In order to improve the accuracy of the company's finances and reduce the workload of financial personnel, it is particularly important to achieve systematization and intelligence in bill consolidation. To this end, the present invention proposes a method for automatically obtaining order information, generating bills, and realizing multi-dimensional bill consolidation. Summary of the invention

[0004] The purpose of the present invention is to provide a patented multi-dimensional monthly bill merging method and system to solve the problems raised in the above-mentioned background technology.

[0005] To achieve the above purpose, the present invention provides the following technical solution: a patented multi-dimensional monthly bill merging method, the method comprising the following steps:

[0006] Obtain detailed information of all contracts approved by the company;

[0007] The billing system generates corresponding billing orders based on the contract;

[0008] The billing system generates monthly billing information based on billing orders, monthly user usage, and contract payment nodes;

[0009] The obtained bill information is merged through the bill merging rule algorithm;

[0010] Finally complete the company's overall revenue statistics for this month and issue relevant financial statements.

[0011] Preferably, the specific operations for obtaining the specific information of all contracts approved by the company include:

[0012] Obtain the specific information of all approved contracts, including: customer, signing unit, product, payment method, project number, amount information, use the RFC data interaction mode to connect to the customer management system database, use the contract number as the unique identifier and judge the corresponding contract status, obtain the data and store it in the corresponding database table.

[0013] Preferably, the specific operations of the billing system to generate the corresponding billing order according to the contract include:

[0014] At the time of monthly settlement, HTTP data interaction mode is used to connect to the billing system database to obtain all billing orders for the current month in the billing system. At the same time, the main information in the billing order: customer, product, signing unit, payment information, and contract number and project number are used as primary keys to compare with the contract information. The correctly matched data is stored in the corresponding database table, and the orders with differences are returned through the interface and the differences are prompted. The billing system makes corresponding adjustments to the billing orders based on the corresponding returned information and retrieves them after the adjustments.

[0015] Preferably, the specific operations of the billing system generating monthly billing information according to the billing order, monthly user usage, and contract payment nodes include:

[0016] At monthly settlement, HTTP data interaction mode is used to connect to the billing system database to obtain the bill information generated in the billing system that month. The billing order number in the bill is used to establish the association between the bill and the order. At the same time, the main information in the bill: customer, product, signing unit, payment information, and the contract number and project number are used as the primary key to compare with the contract information; the correctly matched data is stored in the corresponding database table, and the orders with differences are returned through the interface and the differences are prompted. The billing system makes corresponding adjustments to the billing order based on the corresponding returned information and retrieves it after the adjustment.

[0017] Preferably, the specific operation of merging the acquired bill information through the bill merging rule algorithm includes:

[0018] The bill consolidation algorithm is as follows: the bill amounts are summarized according to the contract number, project number, signing unit, customer, product information, and cloud center in the bill; when entering the account, the accounts receivable are recorded in different profit centers by distinguishing the cloud center in the order.

[0019] A patented multi-dimensional monthly bill consolidation system, the system comprising:

[0020] The data acquisition module connects to the database of the customer management system through the RFC data interaction mode;

[0021] The billing order comparison and adjustment module obtains all billing orders of the month from the billing system database through HTTP data interaction mode at the time of monthly settlement;

[0022] The bill information comparison and processing module, at the time of monthly settlement, again obtains the bill information generated in the current month from the billing system database through the HTTP data interaction mode;

[0023] The bill consolidation module includes a bill consolidation rule algorithm that aggregates the bill amount based on the contract number, project number, signing unit, customer, product information, and cloud center dimensions in the bill;

[0024] The financial statement generation module automatically completes the statistics of the company's overall revenue this month based on the billing information obtained, compared, processed and merged by the above modules, and generates relevant financial statements, including but not limited to income statement, income statement, cash flow statement, to support the company's financial analysis and decision-making.

[0025] Preferably, the data acquisition module uses the contract number as a unique identifier to automatically obtain the specific information of all approved contracts, including but not limited to the customer, signing unit, product, payment method, project number, amount, and stores the information in the system's database for subsequent processing.

[0026] Preferably, the billing order comparison and adjustment module uses the key information in the billing order, with the contract number and project number as the primary key, to compare with the contract information stored in the system. For orders that are correctly compared, the module stores their data in the corresponding database table; for orders with differences, the module returns the difference point information to the billing system through the interface, prompting it to make corresponding adjustments, and re-acquires the billing order data after the adjustment is completed.

[0027] Preferably, the bill information comparison and processing module uses the billing order number in the bill to establish an association between the bill and the order, and compares the key information in the bill with the contract information in the system. For bills that are correctly compared, the bill information comparison and processing module stores the data in the corresponding database table; for bills with differences, the bill information comparison and processing module returns the difference point information to the billing system through the interface, and prompts it to make corresponding adjustments, and then re-acquire the bill information after the adjustment.

[0028] Preferably, during the accounting process, the bill consolidation module records the accounts receivable into different profit centers according to the distinction of cloud centers in the order, so as to achieve accurate financial management and profit analysis.

[0029] Compared with the prior art, the present invention has the following beneficial effects:

[0030] The patented multi-dimensional monthly bill merging method and system proposed in the present invention obtains the specific contract information of each company, generates corresponding orders and bills, and finally confirms the company's overall income. The present invention ultimately solves the problem of a company's large monthly bill volume leading to a long monthly settlement time, and has high credibility, high efficiency, and easy operation. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] Figure 1 is a flow chart of the method of the present invention;

[0032] Figure 2 This is a technical architecture diagram of the method of the present invention. DETAILED DESCRIPTION

[0033] In order to make the purpose and technical solution of the present invention clearly and completely described, and the advantages more clearly understood, the embodiments of the present invention are further described in detail with reference to the accompanying drawings. It should be understood that the specific embodiments described herein are part of the embodiments of the present invention, rather than all of the embodiments, and are only used to explain the embodiments of the present invention, and are not used to limit the embodiments of the present invention. All other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0034] For example, see Figure 1 to Figure 2 The present invention provides a technical solution: a patented multi-dimensional monthly bill merging method, the method comprising the following steps:

[0035] 1. The contract information of all branches and subsidiaries of a large company is in the customer management system. First, obtain the specific information of all approved contracts. This mainly includes: customer, signing unit, product, payment method, project number, amount and other information. Use the RFC data interaction mode to connect to the customer management system database, use the contract number as the unique identifier and judge the corresponding contract status, obtain the data and store it in the corresponding database table.

[0036] 2. The billing system will generate corresponding billing orders according to the contract. At the time of monthly settlement, the HTTP data interaction mode is used to connect to the billing system database to obtain all billing orders in the billing system for the current month. At the same time, the main information in the billing order: customer, product, signing unit, payment information, etc. will be used to compare the contract information with the contract number and project number as the primary key. The correctly compared data will be stored in the corresponding database table, and the orders with differences will be returned through the interface and the differences will be prompted. The billing system will make corresponding adjustments to the billing order based on the corresponding returned information, and then retrieve it again after the adjustment.

[0037] 3. The billing system will generate monthly billing information based on billing orders, monthly user usage, and contract payment nodes. At the time of monthly settlement, the HTTP data interaction mode is used to connect to the billing system database to obtain the billing information generated in the billing system for the current month. The billing order number in the bill is used to establish the association between the bill and the order. At the same time, the main information in the bill: customer, product, signing unit, payment information, etc., will be used to compare the contract information with the contract number and project number as the primary key. The correctly compared data will be stored in the corresponding database table, and the orders with differences will be returned through the interface and the differences will be prompted. The billing system will make corresponding adjustments to the billing order based on the corresponding returned information and retrieve it after the adjustment.

[0038] 4. The bill information obtained is merged through the bill merging rule algorithm. The bill merging algorithm is: according to the contract number, project number, signing unit, customer, product information, and cloud center in the bill, the bill amount is summarized. When entering the account, the accounts receivable are recorded in different profit centers by distinguishing the cloud center in the order.

[0039] 5. Finally complete the company's overall revenue statistics for this month and issue relevant financial statements.

[0040] Embodiment 2, based on embodiment 1, proposes a patented multi-dimensional monthly bill merging system, the system comprising:

[0041] The data acquisition module connects to the database of the customer management system through the RFC data interaction mode; using the contract number as the unique identifier, it automatically obtains the specific information of all approved contracts, including but not limited to the customer, signing unit, product, payment method, project number, amount, and stores the information in the system's database for subsequent processing.

[0042] The billing order comparison and adjustment module obtains all billing orders for the month from the billing system database through the HTTP data interaction mode at the time of monthly settlement; uses the key information in the billing order, with the contract number and project number as the primary key, and compares it with the contract information stored in the system. For orders that are correctly compared, the module stores their data in the corresponding database table; for orders with differences, the module returns the difference point information to the billing system through the interface, prompting it to make corresponding adjustments, and re-obtains the billing order data after the adjustment is completed.

[0043] The billing information comparison and processing module, at the time of monthly settlement, again obtains the billing information generated in the current month from the billing system database through the HTTP data interaction mode; uses the billing order number in the bill to establish the association between the bill and the order, and compares the key information in the bill with the contract information in the system. For bills that are correctly compared, the billing information comparison and processing module stores their data in the corresponding database table; for bills with differences, the billing information comparison and processing module returns the difference point information to the billing system through the interface, and prompts it to make corresponding adjustments, and then re-obtain the bill information after the adjustment.

[0044] The bill consolidation module includes a bill consolidation rule algorithm, which summarizes the bill amount according to the contract number, project number, signing unit, customer, product information, and cloud center dimensions in the bill; during the accounting process, the module records the accounts receivable into different profit centers according to the distinction of cloud centers in the order, so as to achieve accurate financial management and profit analysis.

[0045] The financial statement generation module automatically completes the statistics of the company's overall revenue this month based on the billing information obtained, compared, processed and merged by the above modules, and generates relevant financial statements, including but not limited to income statement, income statement, cash flow statement, to support the company's financial analysis and decision-making.

[0046] Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions and variations may be made to the embodiments without departing from the principles and spirit of the present invention, and that the scope of the present invention is defined by the appended claims and their equivalents.

Claims

1. A patented multi-dimensional monthly bill merging method, characterized by: The method comprises the following steps: Obtain detailed information of all contracts approved by the company; The billing system generates corresponding billing orders based on the contract; The billing system generates monthly billing information based on billing orders, monthly user usage, and contract payment nodes; The obtained bill information is merged through the bill merging rule algorithm; Finally complete the company's overall revenue statistics for this month and issue relevant financial statements.

2. According to claim 1, a patented multi-dimensional monthly bill merging method is characterized by: The specific operations for obtaining the detailed information of all contracts approved by the company include: Obtain the specific information of all approved contracts, including: customer, signing unit, product, payment method, project number, amount information, use the RFC data interaction mode to connect to the customer management system database, use the contract number as the unique identifier and judge the corresponding contract status, obtain the data and store it in the corresponding database table.

3. According to claim 1, a patented multi-dimensional monthly bill merging method is characterized by: The billing system will generate the corresponding billing order according to the contract. The specific operations include: At the time of monthly settlement, HTTP data interaction mode is used to connect to the billing system database to obtain all billing orders for the current month in the billing system. At the same time, the main information in the billing order: customer, product, signing unit, payment information, and contract number and project number are used as primary keys to compare with the contract information. The correctly matched data is stored in the corresponding database table, and the orders with differences are returned through the interface and the differences are prompted. The billing system makes corresponding adjustments to the billing orders based on the corresponding returned information and retrieves them after the adjustments.

4. According to claim 1, a patented multi-dimensional monthly bill merging method is characterized by: The billing system generates monthly billing information based on billing orders, monthly user usage, and contract payment nodes. The specific operations include: At monthly settlement, HTTP data interaction mode is used to connect to the billing system database to obtain the billing information generated in the billing system that month. The billing order number in the bill is used to establish the association between the bill and the order. At the same time, the main information in the bill: customer, product, signing unit, payment information, and the contract number and project number are used as the primary key to compare with the contract information; the correctly matched data is stored in the corresponding database table, and the orders with differences are returned through the interface and the differences are prompted. The billing system makes corresponding adjustments to the billing order based on the corresponding returned information and retrieves it after the adjustment.

5. According to claim 1, a patented multi-dimensional monthly bill merging method is characterized by: The specific operations of merging the acquired bill information through the bill merging rule algorithm include: The bill consolidation algorithm is as follows: the bill amounts are summarized according to the contract number, project number, signing unit, customer, product information, and cloud center in the bill; when entering the account, the accounts receivable are included in different profit centers by distinguishing the cloud center in the order.

6. A patented multi-dimensional monthly bill merging system according to the patented multi-dimensional monthly bill merging method according to any one of claims 1 to 5, characterized in that: The system comprises: The data acquisition module connects to the database of the customer management system through the RFC data interaction mode; The billing order comparison and adjustment module obtains all billing orders of the month from the billing system database through HTTP data interaction mode at the time of monthly settlement; The bill information comparison and processing module, at the time of monthly settlement, again obtains the bill information generated in the current month from the billing system database through the HTTP data interaction mode; The bill consolidation module includes a bill consolidation rule algorithm that aggregates the bill amount based on the contract number, project number, signing unit, customer, product information, and cloud center dimensions in the bill; The financial statement generation module automatically completes the statistics of the company's overall revenue this month based on the billing information obtained, compared, processed and merged by the above modules, and generates relevant financial statements, including but not limited to income statement, income statement, cash flow statement, to support the company's financial analysis and decision-making.

7. The patented multi-dimensional monthly bill consolidation system according to claim 6 is characterized by: The data acquisition module uses the contract number as a unique identifier to automatically obtain the specific information of all approved contracts, including but not limited to the customer, signing unit, product, payment method, project number, amount, and stores the information in the system's database for subsequent processing.

8. The patented multi-dimensional monthly bill consolidation system according to claim 6 is characterized by: The billing order comparison and adjustment module uses the key information in the billing order, with the contract number and project number as the primary key, to compare with the contract information stored in the system. For orders that are correctly compared, the module stores their data in the corresponding database table; for orders with differences, the module returns the difference point information to the billing system through the interface, prompting it to make corresponding adjustments, and re-acquires the billing order data after the adjustment is completed.

9. The patented multi-dimensional monthly bill consolidation system according to claim 6 is characterized by: The bill information comparison and processing module uses the billing order number in the bill to establish an association between the bill and the order, and compares the key information in the bill with the contract information in the system. For bills that are correctly compared, the bill information comparison and processing module stores the data in the corresponding database table; for bills with differences, the bill information comparison and processing module returns the difference point information to the billing system through the interface, and prompts it to make corresponding adjustments, and then re-acquire the bill information after the adjustment.

10. The patented multi-dimensional monthly bill consolidation system according to claim 6 is characterized by: During the accounting process, the bill consolidation module will record the accounts receivable into different profit centers according to the distinction of cloud centers in the order, so as to achieve accurate financial management and profit analysis.

Images