CN117596559A - Account checking method and device - Google Patents

Abstract

The invention provides a reconciliation method and a reconciliation device, which are used for acquiring a short message sending record and storing the short message sending record in a sending record table; summarizing the short message sending records in the sending period according to the suppliers and the sending accounts to obtain summarized data of the suppliers and summarized data of the accounts, and storing the summarized data and the summarized data of the accounts in a summary table; based on the short message sending record in the sending period, counting to obtain charging data and storing the charging data into a charging table; generating a supplier bill by respectively acquiring related data from a summary table and a charging table for each supplier; respectively acquiring related data from a summary table and a charging table for each enterprise department to generate a department bill; checking is performed based on the supplier bill and the department bill. In the scheme, the short message sending records are acquired in real time for storage, and the processing procedures of data statistics, summarization, calculation and the like are automatically carried out according to the preset period based on the short message sending records, so that the supplier bill and the department bill are obtained for checking, and the purposes of reducing the checking time consumption, improving the checking efficiency and saving the manpower are achieved.

Description

Account checking method and device

Technical Field

The invention relates to the technical field of data processing, in particular to a checking method and a checking device.

Background

At present, an enterprise with a short message sending requirement generally signs a plurality of short message suppliers for short message sending, and each month needs to be checked out at the end of each month, so that the check out of the enterprise and the short message suppliers is related, and bills of each department of the enterprise and bills of the suppliers need to be independently checked.

In the prior art, the data are independently checked manually according to suppliers, departments and sending account numbers, and are summarized and calculated to generate a bill of the suppliers and a bill of the departments for checking, so that the problems of long time consumption, low efficiency and manpower waste exist.

Therefore, the problems of long time consumption, low efficiency and labor waste in the checking process are the problems to be solved urgently at present.

Disclosure of Invention

In view of the above, the embodiments of the present invention provide a method and apparatus for checking account, so as to achieve the purposes of reducing time consumption for checking account, improving efficiency of checking account, and saving manpower.

In order to achieve the above object, the embodiment of the present invention provides the following technical solutions:

the first aspect of the embodiment of the invention discloses a reconciliation method, which comprises the following steps:

acquiring a short message sending record in real time and storing the short message sending record in a preset sending record table; the short message sending record at least comprises: the short message type, the sending account number and the provider; the sending account is associated with an enterprise department;

Responding to the end of a sending period, summarizing each short message sending record in the sending period in the sending record table according to the suppliers and the sending account numbers respectively to obtain supplier summarizing data and account number summarizing data, and storing the data into a preset summarizing table;

based on the short message sending record in the sending period and the short message unit price preset by each provider for each short message type, counting to obtain charging data and storing the charging data into a preset charging list;

acquiring a reconciliation period consisting of at least one transmission period;

for each supplier, acquiring target supplier summary data and first charging data from the summary table and the charging table based on the reconciliation period;

generating a supplier bill based on the target supplier summary data and the first billing data;

for each enterprise department, acquiring target account summary data and second charging data corresponding to each sending account associated with the enterprise department from the summary table and the charging table respectively based on the reconciliation period;

generating a department bill based on the target account summary data and the second charging data;

And checking accounts based on the supplier bill and the department bill to obtain a checking account result.

Preferably, the responding to the end of the sending period gathers the sending records of the short message in the sending period in the sending record table according to the provider and the sending account number, so as to obtain provider gathering data and account number gathering data, and stores the provider gathering data and account number gathering data in a preset gathering table, including:

for each provider, inquiring a first short message sending record corresponding to the provider from each short message sending record in the sending period in the sending record table;

calculating to obtain index values of all provider summarization indexes based on the first short message sending record and a preset calculation rule of all provider summarization indexes;

summarizing index values of summarized indexes of all suppliers to obtain summarized data of the suppliers and storing the summarized data into a preset summary table;

for each sending account, inquiring a second short message sending record corresponding to the sending account from each short message sending record in the sending period in the sending record table;

calculating to obtain index values of all account summary indexes based on the corresponding second short message sending records and preset calculation rules of all account summary indexes;

And summarizing index values of the account summarizing indexes to obtain account summarizing data and storing the account summarizing data into a summarizing table.

Preferably, the counting, based on the short message sending record in the sending period and the short message unit price preset by each provider for each short message type, obtains charging data and stores the charging data in a preset charging table, including:

counting to obtain the number of short message billing of each short message type and the provider corresponding to each short message sending record based on the short message sending record corresponding to the sending account in the sending period;

based on the number of short message billing of each short message type, the provider corresponding to each short message sending record and the short message unit price preset by each provider for each short message type, billing data are generated and stored in a preset billing table.

Preferably, the first charging data includes: the generating a provider bill based on the target provider summary data and the first charging data includes:

multiplying the number of the short message billing bars by the unit price of the corresponding short message aiming at each short message type to obtain first billing summary data;

And generating a supplier bill based on a preset supplier bill template, the target supplier summary data and the first charging summary data.

Preferably, the second charging data includes: the generating a department bill based on the target account summary data and the second charging data includes:

multiplying the number of the short message billing bars by the unit price of the corresponding short message aiming at each short message type to obtain second billing summary data;

and generating a department bill based on a preset department bill template, the target account summary data and the second charging summary data.

Preferably, the short message sending record includes: the receipt status code to be updated and the receipt time to be updated, the method further comprising:

aiming at each short message sending record, acquiring a corresponding short message sending receipt; the short message sending receipt is used for representing whether the short message corresponding to the short message sending record is sent successfully or not;

updating the receipt time to be updated based on the time of acquiring the corresponding short message sending receipt;

Updating the state code to be updated based on the short message sending receipt, so that the updated state code represents whether the short message corresponding to the short message sending record is sent successfully or not.

The second aspect of the embodiment of the invention discloses a reconciliation device, which comprises:

the first acquisition unit is used for acquiring the short message sending record in real time and storing the short message sending record in a preset sending record table; the short message sending record at least comprises: the short message type, the sending account number and the provider; the sending account is associated with an enterprise department;

the response unit is used for responding to the end of the sending period, summarizing the short message sending records in the sending period in the sending record table according to the suppliers and the sending accounts respectively to obtain supplier summarizing data and account summarizing data, and storing the supplier summarizing data and the account summarizing data into a preset summarizing table;

the statistics unit is used for counting and obtaining charging data based on the short message sending records in the sending period and short message unit prices preset by each provider for each short message type, and storing the charging data in a preset charging table;

a second acquisition unit configured to acquire a reconciliation cycle composed of at least one of the transmission cycles;

A third obtaining unit, configured to obtain, for each of the suppliers, target supplier summary data and first charging data from the summary table and the charging table, respectively, based on the reconciliation period;

a first generation unit configured to generate a supplier bill based on the target supplier summary data and the first charging data;

a fourth obtaining unit, configured to obtain, for each enterprise department, target account summary data and second charging data corresponding to each sending account associated with the enterprise department from the summary table and the charging table based on the reconciliation period, respectively;

the second generation unit is used for generating a department bill based on the target account summary data and the second charging data;

and the reconciliation unit is used for reconciling based on the supplier bill and the department bill to obtain a reconciliation result.

Preferably, the response unit is specifically configured to:

for each provider, inquiring a first short message sending record corresponding to the provider from each short message sending record in the sending period in the sending record table;

calculating to obtain index values of all provider summarization indexes based on the first short message sending record and a preset calculation rule of all provider summarization indexes;

Summarizing index values of summarized indexes of all suppliers to obtain summarized data of the suppliers and storing the summarized data into a preset summary table;

for each sending account, inquiring a second short message sending record corresponding to the sending account from each short message sending record in the sending period in the sending record table;

calculating to obtain index values of all account summary indexes based on the corresponding second short message sending records and preset calculation rules of all account summary indexes;

and summarizing index values of the account summarizing indexes to obtain account summarizing data and storing the account summarizing data into a summarizing table.

Preferably, the statistics unit is specifically configured to:

counting to obtain the number of short message billing of each short message type and the provider corresponding to each short message sending record based on the short message sending record corresponding to the sending account in the sending period;

based on the number of short message billing of each short message type, the provider corresponding to each short message sending record and the short message unit price preset by each provider for each short message type, billing data are generated and stored in a preset billing table.

Preferably, the first charging data includes: the first generation unit is specifically configured to:

multiplying the number of the short message billing bars by the unit price of the corresponding short message aiming at each short message type to obtain first billing summary data;

and generating a supplier bill based on a preset supplier bill template, the target supplier summary data and the first charging summary data.

Based on the account checking method and the account checking device provided by the embodiment of the invention, the short message sending record is obtained in real time and stored in the preset sending record table; the short message sending record at least comprises: the short message type, the sending account number and the provider; the sending account is associated with an enterprise department; responding to the end of a sending period, summarizing each short message sending record in the sending period in the sending record table according to the suppliers and the sending account numbers respectively to obtain supplier summarizing data and account number summarizing data, and storing the data into a preset summarizing table; based on the short message sending record in the sending period and the short message unit price preset by each provider for each short message type, counting to obtain charging data and storing the charging data into a preset charging list; acquiring a reconciliation period consisting of at least one transmission period; for each supplier, acquiring target supplier summary data and first charging data from the summary table and the charging table based on the reconciliation period; generating a supplier bill based on the target supplier summary data and the first billing data; for each enterprise department, acquiring target account summary data and second charging data corresponding to each sending account associated with the enterprise department from the summary table and the charging table respectively based on the reconciliation period; generating a department bill based on the target account summary data and the second charging data; and checking accounts based on the supplier bill and the department bill to obtain a checking account result. In the scheme, the short message sending records are acquired in real time for storage, and the processing procedures of data statistics, summarization, calculation and the like are automatically carried out according to the preset period based on the short message sending records, so that the supplier bill and the department bill are obtained for checking, and the purposes of reducing the checking time consumption, improving the checking efficiency and saving the manpower are achieved.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are required to be used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are only embodiments of the present invention, and that other drawings can be obtained according to the provided drawings without inventive effort for a person skilled in the art.

FIG. 1 is a flow chart of a reconciliation method of the present disclosure;

FIG. 2 is a diagram of a table structure model according to an embodiment of the present invention;

FIG. 3 is an exemplary diagram of a vendor billing template disclosed in an embodiment of the invention;

FIG. 4 is an exemplary diagram of a department billing template disclosed in an embodiment of the present invention;

fig. 5 is a block diagram of a reconciliation device according to an embodiment of the disclosure.

Detailed Description

The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.

In this application, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.

As known from the background art, in the prior art, the supplier bill and the department bill are obtained through manual summarization, so that the supplier bill and the department bill are utilized for checking, and the problems of long time consumption, low efficiency and manpower waste exist.

Therefore, the embodiment of the invention discloses a checking method and a checking device, in the scheme, a short message sending record is acquired in real time and stored, and the processing procedures of data statistics, summarization, calculation and the like are automatically performed according to a preset period based on the short message sending record, so that a supplier bill and a department bill are obtained for checking, and the purposes of reducing checking time consumption, improving checking efficiency and saving manpower are realized.

As shown in fig. 1, a flowchart of a reconciliation method disclosed in an embodiment of the present invention mainly includes the following steps:

s101, acquiring a short message sending record in real time and storing the short message sending record in a preset sending record table.

In S101, the short message sending record at least includes: the method comprises the steps of short message type, a sending account number and a provider, wherein the sending account number is associated with an enterprise department.

The generation process of the short message sending record mainly comprises the following steps:

when receiving a short message sending request of a business party, firstly checking whether an enterprise department where the business party is located registers department information in a department table.

If not, the department information of the department where the business party is located is added in the department table.

If yes, a sending account is allocated to the sending request, the sending account is stored in an account list, and the sending account is associated with an enterprise department where a business party is located.

Then, the transmission content, the mobile phone number, the transmission account number, and the like are stored as tasks in the message queue.

And matching the tasks to the suppliers according to the weights after the tasks are consumed, and finally completing the short message sending by using the matched suppliers.

Wherein, each supplier is stored in advance in a supplier table, and the weight of the supplier is set in the supplier table.

By weight matching algorithm, matching to the provider according to weight, for example: and the weight of the providers A, B, C is 3:4:3 respectively, and 100 requests are required, and the three providers actually send short messages close to 30, 40 and 30.

After the short message transmission is completed, a short message transmission record is generated and inserted into a preset transmission record table.

The short message sending record may further include, but is not limited to: unique request id, mobile phone number, request time, send content, send account number, vendor, receipt status code to be updated, and receipt time to be updated.

It should be noted that, the mobile phone number refers to a mobile phone number for receiving a short message, the sending account refers to an account number adopted by a short message sender, each sending account number needs to be matched to a corresponding provider according to weight, and the provider provides a short message sending service based on the sending account number.

As shown in fig. 2, a table structure model diagram is disclosed in the embodiment of the present invention, and fig. 2 includes the above-mentioned 4 tables: account tables, department tables, vendor tables, and transmission record tables, and summary tables and billing tables that may be involved in subsequent steps, the tables shown in fig. 2 are all pre-established.

The account table is used for storing a sending account number of a sending short message and authority control of the sending short message type, the department table is used for associating departments to which the sending account number belongs to, and is convenient for checking, the provider table is used for storing provider information and the short message type supported by the provider, the sending record table is used for storing short message sending of each time, and the account table, the department table and the provider table are all service sending record tables.

In the subsequent step, after each preset short message sending period, counting short message sending records in the short message sending period according to rules from a sending record table, obtaining provider summary data and account summary data, storing the provider summary data and the account summary data into the summary table, calculating according to rules based on the short message sending records in the short message sending period, obtaining charging data, and storing the charging data into the charging table, wherein the specific process is as shown in the subsequent step.

If the short message sending record includes the receipt status code to be updated and the receipt time to be updated, the method further includes an update process before executing S102:

and aiming at each short message sending record, acquiring a corresponding short message sending receipt, wherein the short message sending receipt is used for representing whether the short message corresponding to the short message sending record is sent successfully or not.

It should be noted that, whether the short message is sent successfully or not, the provider can push a receipt, and the receipt pushed by each provider is stored in the log file according to the day.

And updating the receipt time to be updated based on the time when the corresponding short message is acquired to send the receipt.

Based on the short message sending receipt, the state code to be updated is updated, so that the updated state code characterizes whether the short message corresponding to the short message sending record is sent successfully or not.

And S102, responding to the end of the sending period, summarizing all short message sending records in the sending period in the sending record table according to the suppliers and the sending accounts respectively, obtaining supplier summarizing data and account summarizing data, and storing the supplier summarizing data and the account summarizing data in a preset summarizing table.

In S102, S102 may be performed with one day as one transmission period, i.e., after the end of each day.

It should be noted that, each provider having a corresponding short message sending record in the sending period corresponds to a piece of provider summary data, and each sender has a corresponding sending account number of the short message sending record in the sending period corresponds to a piece of account summary data.

In the specific implementation process of S102, the method mainly includes:

s11: and inquiring a first short message sending record corresponding to each provider from each short message sending record in the sending period in the sending record table aiming at each provider.

In S11, for each provider, the total number of the current provider ' S current day of transmission is checked according to the provider name and date, if the total number is greater than 0, the current provider ' S current day of transmission is indicated as the current provider ' S current day of transmission is extracted as the first message transmission record.

S12: and calculating the index value of each provider summary index based on the first short message sending record and a preset calculation rule of each provider summary index.

Exemplary, the preset summary indicators of each provider include: the number of short message billing bars, the number of successful transmission, the number of failure, the number of invalid, the number of validity, the number of successful 60s, the success rate and the success rate of 60 s.

The number of short message charging, the number of successful sending, the number of failure, the number of invalid and the number of valid are used as statistical indexes, and can be counted in a counting mode based on the first short message sending record.

It should be noted that, the invalid number indicates that the short message corresponding to the short message sending record is sent to an invalid mobile phone number, and the valid number indicates that the short message corresponding to the short message sending record is sent to an valid mobile phone number.

And calculating the success number, the success rate and the success rate of 60s according to preset calculation rules of the summarizing indexes of all suppliers.

The specific calculation rules are as follows:

effective number=total number of transmissions-ineffective number, success rate=successful number/effective number, 60s success rate=60 s successful number/effective number, 60s successful number is total number of receipt time-transmission time < 60.

Wherein the total number of transmissions is the number of first short message transmission records.

It will be understood that the number of short message billing bars refers to the number of short message billing bars that need to be paid, for example, if some type of short message transmission fails and payment is also required, the number of short message billing bars needs to be counted.

S13: and summarizing index values of the summarized indexes of the suppliers to obtain summarized data of the suppliers and storing the summarized data into a preset summary table.

It should be noted that, each time the provider summary data of one provider is obtained, the summary table may be inserted in real time, and the flag position of the provider summary data is 1, which is used to indicate that the provider summary data corresponds to the provider.

S14: and inquiring a second short message sending record corresponding to the sending account from each short message sending record in the sending period in the sending record table aiming at each sending account.

In S14, a transmission account number of a corresponding short message transmission record of the current day is queried in the transmission record table according to the date (i.e. transmission period).

And traversing each sending account number with a sending record, and inquiring the short message sending record corresponding to the sending account number in the sending period to be used as a second short message sending record.

S15: and calculating the index value of each account summary index based on the corresponding second short message sending record and a preset calculation rule of each account summary index.

In the specific implementation process of S15, based on the corresponding second short message sending record, the number of short message billing bars, the number of successful sending, the number of failure, the number of invalid and the success rate are counted or calculated.

The short message charging number, the sending success number and the invalid number are obtained through counting based on the second short message sending record.

For example, each second short message sending record stores a re-updated receipt status code, whether the short message corresponding to the second short message sending record is successful or not can be judged according to the receipt status code, if so, the sending success number is increased by one, and according to the counting mode, all the second short message sending records are traversed, so that the sending success number can be obtained.

Number of failures = total number of transmissions-number of successes, success rate = total number of successes/total number of transmissions.

Wherein the total number of transmissions is the number of second short message transmission records.

S16: and summarizing index values of the account summary indexes to obtain account summary data and storing the account summary data into a summary table.

It should be noted that, once account summary data corresponding to a sending account is obtained, the summary table may be inserted in real time, and the flag position of the account summary data is 0, which is used to indicate that the account summary data corresponds to the sending account.

S103, based on the short message sending record in the sending period and the short message unit price preset by each provider for each short message type, counting to obtain charging data and storing the charging data in a preset charging list.

In S103, each piece of charging data includes at least: the method comprises the steps of sending an account number, a provider, a short message type, a short message billing number of each short message type and a short message unit price.

Each account number may have multiple billing data per day, because the same sms type may be sent by multiple providers, and each provider may price the sms type differently.

In the specific implementation process of S103, the method mainly includes:

and counting the number of short message billing pieces of each short message type and the provider corresponding to each short message sending record based on the short message sending record corresponding to each sending account in the sending period.

Based on the number of short message billing pieces of each short message type, the provider corresponding to each short message sending record and the short message unit price preset by each provider for each short message type, billing data are generated and stored in a preset billing table.

Illustratively, the billing table is shown in Table 1.

Table 1:

transmittingAccount number	Suppliers (suppliers)	Short message type	Short message charging number (bar)	Unit price of short message
					Transmitting account number 1	Supplier 1	Short message type A	50	0.1
Transmitting account number 1	Supplier 2	Short message type A	20	0.05
					Transmitting account number 1	Supplier 3	Short message type B	30	0.2
Transmitting account number 2	Supplier 1	Short message type A	60	0.1
					Transmitting account number 3	Supplier 3	Short message type B	70	0.2

It will be appreciated that each action of table 1 is one piece of billing data, for example, there are 3 pieces of billing data for the transmission account number 1.

S104, acquiring a reconciliation period consisting of at least one transmission period.

In S104, the reconciliation cycle is entered by the user according to the reconciliation requirement, for example: the transmission period is daily and the reconciliation period may be one month in the past.

S105, acquiring target provider summary data and first charging data from the summary table and the charging table respectively based on the reconciliation period for each provider.

It may be understood that each piece of billing data includes at least a sending account number and a provider, and then based on the sending account number or the provider, the corresponding billing data may be queried from the billing table, and S105 queries the billing data for the provider, and uses the queried billing data as the first billing data.

And S106, generating a supplier bill based on the target supplier summary data and the first charging data.

In S106, the first charging data includes at least: the number of short message charging strips and the unit price of the short messages of each short message type corresponding to the provider.

The following list first billing data corresponding to provider 1 and provider 2:

the number of the charging strips of the A, B and C three types of short messages corresponding to the provider 1 is 10, 20 and 30, and the unit price of the A, B and C three types of short messages corresponding to the provider 1 is 0.1 element, 0.2 element and 0.1 element respectively.

The number of the charging strips of the A, B and C short messages corresponding to the provider 2 is 20, 10 and 50, and the unit price of the A, B and C short messages corresponding to the provider 2 is 0.05 element, 0.1 element and 0.1 element respectively.

In the specific implementation process of S106, for each short message type, the number of short message charging strips is multiplied by the corresponding short message unit price to obtain first charging summary data.

Based on the above example of the first charging data, the specific calculation process of the first charging summary data is:

for vendor 1: and multiplying 10, 20 and 30 short message billing bars of A, B and C types by the unit price of the short message by 0.1 element, 0.2 element and 0.1 element respectively to obtain the total price 1 element, 4 element and 3 element of the short message of A, B and C types sent by the provider 1.

And finally, taking the first charging data and the calculated total price of each message type as first charging summarized data.

FIG. 3 is a diagram illustrating an example of a vendor billing template according to an embodiment of the present invention.

And generating a supplier bill based on the preset supplier bill template, the target supplier summary data and the first charging summary data.

The provider billing template example provided in fig. 3 includes the number of SLAs up to standard and the rate of SLAs up to standard.

SLA (Service Level Agreement) service level agreements refer to agreements or contracts that are commonly accepted by both parties between the business providing the service and the clients in terms of quality, level, performance, etc. of the service.

Correspondingly, when the statistics provider summary data is recorded based on the short message sending, the number of the SLA standard and the SLA standard rate are counted according to the SLA agreement, and the statistics provider summary data is used as a part of the provider summary data.

S107, for each enterprise department, acquiring target account summary data and second charging data corresponding to each sending account associated with the enterprise department from a summary table and a charging table based on the reconciliation period.

It may be understood that each piece of billing data includes at least a sending account number and a provider, and then based on the sending account number or the provider, the corresponding billing data may be queried from the billing table, and S105 queries the billing data for the sending account number associated with each enterprise department, and uses the queried billing data as the first billing data.

S108, generating a department bill based on the target account summary data and the second charging data.

In S108, the second charging data includes at least: the number of short message billing and the unit price of the short message corresponding to the sending account number associated by the enterprise department.

The following enumerates the second billing data corresponding to the sending account 1 associated with the enterprise department:

the number of the short message billing bars of the type A and the type B corresponding to the sending account number 1 is 100 and 200, wherein 50 of the 100 short message billing bars of the type A are sent by the provider 1, the unit price of the short message is 0.1 element, the other 50 short message billing bars are sent by the provider 2, and the unit price of the short message is 0.05 element; and the number of the short message charging strips of the short message type B is 100, all the short message charging strips are sent by the provider 1, and the unit price of the short message is 0.2 element.

In the specific implementation process of S108, mainly includes:

and multiplying the number of the short message billing bars by the unit price of the corresponding short message according to each short message type to obtain second billing summary data.

And multiplying the number of the short message billing bars by the corresponding short message unit price to obtain the total price of each short message type corresponding to the sending account, and taking the total price and the second billing data as second billing summary data.

Fig. 4 is a diagram illustrating an example of a department bill template according to an embodiment of the present invention.

Generating a department bill based on a preset department bill template, target account summary data and second charging summary data.

S109, checking the account based on the supplier bill and the department bill to obtain a checking result.

In S109, the reconciliation result is displayed through the visual interface, where the reconciliation result mainly includes: and errors of the SLA not up to standard, the short message billing number and the total amount, etc.

In an embodiment, after the accounting result is obtained, after the accounting result is confirmed manually, a sending mail is clicked, the accounting result is filled according to a mail template to generate mail content, an excel file generated by the obtained supplier bill is attached to the mail template to be sent to a relevant responsible person of the supplier, and a department bill is sent to relevant responsible persons of each department of the company in the form of an execl file through the mail.

Based on the reconciliation method disclosed by the embodiment of the invention, the short message sending record is obtained and stored in the sending record table; summarizing the short message sending records in the sending period according to the suppliers and the sending accounts to obtain summarized data of the suppliers and summarized data of the accounts, and storing the summarized data and the summarized data of the accounts in a summary table; based on the short message sending record in the sending period, counting to obtain charging data and storing the charging data into a charging table; generating a supplier bill by respectively acquiring related data from a summary table and a charging table for each supplier; respectively acquiring related data from a summary table and a charging table for each enterprise department to generate a department bill; checking is performed based on the supplier bill and the department bill. In the scheme, the short message sending records are acquired in real time for storage, and the processing procedures of data statistics, summarization, calculation and the like are automatically carried out according to the preset period based on the short message sending records, so that the supplier bill and the department bill are obtained for checking, and the purposes of reducing the checking time consumption, improving the checking efficiency and saving the manpower are achieved.

Corresponding to the method for checking account disclosed in the above embodiment of the present invention, as shown in fig. 5, the device for checking account disclosed in the embodiment of the present invention is a structure diagram of a checking account device, and the device includes: a first acquisition unit 501, a response unit 502, a statistics unit 503, a second acquisition unit 504, a third acquisition unit 505, a first generation unit 506, a fourth acquisition unit 507, a second generation unit 508, and a reconciliation unit 509.

The first obtaining unit 501 is configured to obtain a short message sending record in real time and store the short message sending record in a preset sending record table.

The short message sending record at least comprises: the method comprises the steps of short message type, a sending account number and a provider, wherein the sending account number is associated with an enterprise department.

And the response unit 502 is configured to, in response to the end of the sending period, summarize each short message sending record in the sending period in the sending record table according to the provider and the sending account, obtain provider summarized data and account summarized data, and store the obtained provider summarized data and account summarized data in a preset summary table.

In an embodiment, the response unit 502 is specifically configured to:

and inquiring a first short message sending record corresponding to each provider from each short message sending record in the sending period in the sending record table aiming at each provider.

And calculating the index value of each provider summary index based on the first short message sending record and a preset calculation rule of each provider summary index.

And summarizing index values of the summarized indexes of the suppliers to obtain summarized data of the suppliers and storing the summarized data into a preset summary table.

And inquiring a second short message sending record corresponding to the sending account from each short message sending record in the sending period in the sending record table aiming at each sending account.

And calculating the index value of each account summary index based on the corresponding second short message sending record and a preset calculation rule of each account summary index.

And summarizing index values of the account summary indexes to obtain account summary data and storing the account summary data into a summary table.

The statistics unit 503 is configured to obtain billing data based on the short message sending record in the sending period and the short message unit price preset by each provider for each short message type, and store the billing data in a preset billing table.

In one embodiment, the statistics unit 503 is specifically configured to:

and counting the number of short message billing pieces of each short message type and the provider corresponding to each short message sending record based on the short message sending record corresponding to each sending account in the sending period.

Based on the number of short message billing pieces of each short message type, the provider corresponding to each short message sending record and the short message unit price preset by each provider for each short message type, billing data are generated and stored in a preset billing table.

A second acquisition unit 504 for acquiring a reconciliation cycle composed of at least one transmission cycle.

The third obtaining unit 505 is configured to obtain, for each provider, the target provider summary data and the first charging data from the summary table and the charging table, respectively, based on the reconciliation period.

A first generating unit 506, configured to generate a supplier bill based on the target supplier summary data and the first charging data.

In one embodiment, the first billing data includes: the first generation unit 506 is specifically configured to:

and multiplying the number of the short message billing bars by the unit price of the corresponding short message according to each short message type to obtain first billing summary data.

And generating a supplier bill based on the preset supplier bill template, the target supplier summary data and the first charging summary data.

A fourth obtaining unit 507, configured to obtain, for each enterprise department, target account summary data and second billing data corresponding to each sending account associated with the enterprise department from the summary table and the billing table based on the reconciliation period, respectively.

And a second generating unit 508, configured to generate a department bill based on the target account summary data and the second charging data.

In an embodiment, the second charging data includes: the second generating unit 508 is specifically configured to:

and multiplying the number of the short message billing bars by the unit price of the corresponding short message according to each short message type to obtain second billing summary data.

Generating a department bill based on a preset department bill template, target account summary data and second charging summary data.

And the reconciliation unit 509 is configured to perform reconciliation based on the supplier bill and the department bill, and obtain a reconciliation result.

In an embodiment, the short message sending record includes: the receipt status code to be updated and the receipt time to be updated correspond to each other, and the reconciliation device further comprises: and the updating unit is used for acquiring corresponding short message sending response pieces aiming at each short message sending record. The short message sending receipt is used for representing whether the short message corresponding to the short message sending record is sent successfully or not.

And updating the receipt time to be updated based on the time when the corresponding short message is acquired to send the receipt.

Based on the short message sending receipt, the state code to be updated is updated, so that the updated state code characterizes whether the short message corresponding to the short message sending record is sent successfully or not.

Based on the account checking device disclosed by the embodiment of the invention, the short message sending record is acquired and stored in the sending record table; summarizing the short message sending records in the sending period according to the suppliers and the sending accounts to obtain summarized data of the suppliers and summarized data of the accounts, and storing the summarized data and the summarized data of the accounts in a summary table; based on the short message sending record in the sending period, counting to obtain charging data and storing the charging data into a charging table; generating a supplier bill by respectively acquiring related data from a summary table and a charging table for each supplier; respectively acquiring related data from a summary table and a charging table for each enterprise department to generate a department bill; checking is performed based on the supplier bill and the department bill. In the scheme, the short message sending records are acquired in real time for storage, and the processing procedures of data statistics, summarization, calculation and the like are automatically carried out according to the preset period based on the short message sending records, so that the supplier bill and the department bill are obtained for checking, and the purposes of reducing the checking time consumption, improving the checking efficiency and saving the manpower are achieved.

In this specification, each embodiment is described in a progressive manner, and identical and similar parts of each embodiment are all referred to each other, and each embodiment mainly describes differences from other embodiments. In particular, for a system or system embodiment, since it is substantially similar to a method embodiment, the description is relatively simple, with reference to the description of the method embodiment being made in part. The systems and system embodiments described above are merely illustrative, wherein the elements illustrated as separate elements may or may not be physically separate, and the elements shown as elements may or may not be physical elements, may be located in one place, or may be distributed over a plurality of network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment. Those of ordinary skill in the art will understand and implement the present invention without undue burden.

Those of skill would further appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the various illustrative elements and steps are described above generally in terms of functionality in order to clearly illustrate the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.

The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims (10)

1. A method of reconciliation, the method comprising:

acquiring a short message sending record in real time and storing the short message sending record in a preset sending record table; the short message sending record at least comprises: the short message type, the sending account number and the provider; the sending account is associated with an enterprise department;

responding to the end of a sending period, summarizing each short message sending record in the sending period in the sending record table according to the suppliers and the sending account numbers respectively to obtain supplier summarizing data and account number summarizing data, and storing the data into a preset summarizing table;

based on the short message sending record in the sending period and the short message unit price preset by each provider for each short message type, counting to obtain charging data and storing the charging data into a preset charging list;

acquiring a reconciliation period consisting of at least one transmission period;

for each supplier, acquiring target supplier summary data and first charging data from the summary table and the charging table based on the reconciliation period;

generating a supplier bill based on the target supplier summary data and the first billing data;

For each enterprise department, acquiring target account summary data and second charging data corresponding to each sending account associated with the enterprise department from the summary table and the charging table respectively based on the reconciliation period;

generating a department bill based on the target account summary data and the second charging data;

and checking accounts based on the supplier bill and the department bill to obtain a checking account result.

2. The method according to claim 1, wherein the step of, in response to the end of the transmission period, summarizing each of the sms transmission records in the transmission record table in the transmission period according to the provider and the transmission account number, respectively, to obtain provider summary data and account number summary data, and storing the provider summary data and the account number summary data in a preset summary table, includes:

for each provider, inquiring a first short message sending record corresponding to the provider from each short message sending record in the sending period in the sending record table;

calculating to obtain index values of all provider summarization indexes based on the first short message sending record and a preset calculation rule of all provider summarization indexes;

Summarizing index values of summarized indexes of all suppliers to obtain summarized data of the suppliers and storing the summarized data into a preset summary table;

for each sending account, inquiring a second short message sending record corresponding to the sending account from each short message sending record in the sending period in the sending record table;

calculating to obtain index values of all account summary indexes based on the corresponding second short message sending records and preset calculation rules of all account summary indexes;

and summarizing index values of the account summarizing indexes to obtain account summarizing data and storing the account summarizing data into a summarizing table.

3. The method according to claim 1, wherein the counting and storing billing data in a preset billing table based on the short message transmission record in the transmission period and a short message unit price preset by each provider for each short message type, comprises:

counting to obtain the number of short message billing of each short message type and the provider corresponding to each short message sending record based on the short message sending record corresponding to the sending account in the sending period;

Based on the number of short message billing of each short message type, the provider corresponding to each short message sending record and the short message unit price preset by each provider for each short message type, billing data are generated and stored in a preset billing table.

4. The method of claim 1, wherein the first billing data comprises: the generating a provider bill based on the target provider summary data and the first charging data includes:

multiplying the number of the short message billing bars by the unit price of the corresponding short message aiming at each short message type to obtain first billing summary data;

and generating a supplier bill based on a preset supplier bill template, the target supplier summary data and the first charging summary data.

5. The method of claim 1, wherein the second billing data comprises: the generating a department bill based on the target account summary data and the second charging data includes:

Multiplying the number of the short message billing bars by the unit price of the corresponding short message aiming at each short message type to obtain second billing summary data;

and generating a department bill based on a preset department bill template, the target account summary data and the second charging summary data.

6. The method according to any one of claims 1 to 5, wherein the short message sending record includes: the receipt status code to be updated and the receipt time to be updated, the method further comprising:

aiming at each short message sending record, acquiring a corresponding short message sending receipt; the short message sending receipt is used for representing whether the short message corresponding to the short message sending record is sent successfully or not;

updating the receipt time to be updated based on the time of acquiring the corresponding short message sending receipt;

updating the state code to be updated based on the short message sending receipt, so that the updated state code represents whether the short message corresponding to the short message sending record is sent successfully or not.

7. A reconciliation apparatus, the apparatus comprising:

the first acquisition unit is used for acquiring the short message sending record in real time and storing the short message sending record in a preset sending record table; the short message sending record at least comprises: the short message type, the sending account number and the provider; the sending account is associated with an enterprise department;

The response unit is used for responding to the end of the sending period, summarizing the short message sending records in the sending period in the sending record table according to the suppliers and the sending accounts respectively to obtain supplier summarizing data and account summarizing data, and storing the supplier summarizing data and the account summarizing data into a preset summarizing table;

the statistics unit is used for counting and obtaining charging data based on the short message sending records in the sending period and short message unit prices preset by each provider for each short message type, and storing the charging data in a preset charging table;

a second acquisition unit configured to acquire a reconciliation cycle composed of at least one of the transmission cycles;

a third obtaining unit, configured to obtain, for each of the suppliers, target supplier summary data and first charging data from the summary table and the charging table, respectively, based on the reconciliation period;

a first generation unit configured to generate a supplier bill based on the target supplier summary data and the first charging data;

a fourth obtaining unit, configured to obtain, for each enterprise department, target account summary data and second charging data corresponding to each sending account associated with the enterprise department from the summary table and the charging table based on the reconciliation period, respectively;

The second generation unit is used for generating a department bill based on the target account summary data and the second charging data;

and the reconciliation unit is used for reconciling based on the supplier bill and the department bill to obtain a reconciliation result.

8. The apparatus according to claim 7, wherein the response unit is specifically configured to:

for each provider, inquiring a first short message sending record corresponding to the provider from each short message sending record in the sending period in the sending record table;

calculating to obtain index values of all provider summarization indexes based on the first short message sending record and a preset calculation rule of all provider summarization indexes;

summarizing index values of summarized indexes of all suppliers to obtain summarized data of the suppliers and storing the summarized data into a preset summary table;

for each sending account, inquiring a second short message sending record corresponding to the sending account from each short message sending record in the sending period in the sending record table;

calculating to obtain index values of all account summary indexes based on the corresponding second short message sending records and preset calculation rules of all account summary indexes;

And summarizing index values of the account summarizing indexes to obtain account summarizing data and storing the account summarizing data into a summarizing table.

9. The apparatus according to claim 7, wherein the statistics unit is configured to:

counting to obtain the number of short message billing of each short message type and the provider corresponding to each short message sending record based on the short message sending record corresponding to the sending account in the sending period;

based on the number of short message billing of each short message type, the provider corresponding to each short message sending record and the short message unit price preset by each provider for each short message type, billing data are generated and stored in a preset billing table.

10. The apparatus of claim 7, wherein the first billing data comprises: the first generation unit is specifically configured to:

multiplying the number of the short message billing bars by the unit price of the corresponding short message aiming at each short message type to obtain first billing summary data;

and generating a supplier bill based on a preset supplier bill template, the target supplier summary data and the first charging summary data.