CN111145003B

CN111145003B - Accounts receivable age counting method, device, medium and electronic equipment

Info

Publication number: CN111145003B
Application number: CN201911205732.3A
Authority: CN
Inventors: 董峰
Original assignee: Taikang Insurance Group Co Ltd; Taikang Online Property Insurance Co Ltd
Current assignee: Taikang Insurance Group Co Ltd; Taikang Online Property Insurance Co Ltd
Priority date: 2019-11-29
Filing date: 2019-11-29
Publication date: 2023-06-02
Anticipated expiration: 2039-11-29
Also published as: CN111145003A

Abstract

The embodiment of the invention provides a method and a device for counting accounts receivable ages, a storage medium and electronic equipment, and relates to the technical field of computers, wherein the method comprises the following steps: storing the receivable data of the newly added policy in the current period into a current receivable account age statistical table; the real receipt data of all the policies in the current account receivable statistics table in the current period is stored in the current account receivable statistics table; judging whether the current financial receivable data is consistent with the receivable data of all the insurance policy in the current period; if the statistics are inconsistent, acquiring a accounts receivable age statistical backup table of the last period of backup; and checking the policy data which are receivable and not received in the last period according to the current account receivable age statistical table and the account receivable age statistical backup table. According to the technical scheme provided by the embodiment of the invention, when the receivable data in the current period is inconsistent, the policy data is checked according to the current receivable account age statistical table and the backup table, so that the cause of the problem can be rapidly positioned when the service is inconsistent with the financial data, and the working efficiency is improved.

Description

Accounts receivable age counting method, device, medium and electronic equipment

Technical Field

The invention relates to the technical field of computer software, in particular to a method and a device for counting accounts receivable ages, a computer readable medium and electronic equipment.

Background

In the insurance industry, in the process of generating a plurality of insurance policies, the insurance policies are generated first and then charged.

And recording the premium to be paid in the pay-per-view system while generating the policy, wherein if the premium is paid on the client, the amount of money after the premium item to be paid is zero. And at the end of the month, the financial department of the insurance company judges whether the business organization has no premium according to whether the amount of the accounts to be charged, namely, the account age, is zero. In addition, the accounting age index is reported to the security prison every month, and the customer is paid in a following way according to the accounting age index.

In order to generate the account data, the account data is generally generated by subtracting the amount of the premium to be paid from all the amounts of the premium to be paid since the business. With the increase of data volume, the current SQL (Structured Query Language ) script query statistical method cannot generate account age indexes, and cannot acquire detailed information of an unreceived policy.

If the data is abnormal or the financial accounting errors occur, the business and financial accounts are inconsistent when accounting age indexes are counted, and when the problem reasons need to be found, the reasons for the abnormal occurrence are difficult to locate due to the huge data volume.

How to locate the cause of abnormality when the business and finance of the amount of the premium is inconsistent is a technical problem that needs to be solved at present.

It should be noted that the information disclosed in the above background section is only for enhancing understanding of the background of the invention and thus may include information that does not form the prior art that is already known to those of ordinary skill in the art.

Disclosure of Invention

The embodiment of the invention aims to provide a method and a device for counting accounts receivable ages, a computer readable medium and electronic equipment, so that the reasons for abnormality are positioned at least to a certain extent when the business and finance of the accounts receivable amount are inconsistent.

Other features and advantages of the invention will be apparent from the following detailed description, or may be learned by the practice of the invention.

According to a first aspect of an embodiment of the present invention, there is provided a accounts receivable age counting method, including: storing the receivable data of the newly added policy in the current period into a current receivable account age statistical table; storing real receipt data of all the policies in the current period in the current account receivable statistics table to the current account receivable statistics table; judging whether the current financial receivable data is consistent with the receivable data of all the insurance policies in the current period; if the data are inconsistent, acquiring a accounts receivable statistical backup table of the accounts receivable backup in the previous period, wherein the accounts receivable statistical backup table stores all the accounts receivable data and real-time receipts of all the insurance policies in the previous period; and checking the policy data which are receivable and not received in the last period according to the current account receivable age statistical table and the account receivable age statistical backup table.

In some embodiments, after checking the policy data that should be received and not actually received in the previous period according to the current accounts receivable and accounts receivable statistics backup table, the method further includes:

and storing the receivable data and the actual receivable data of all the insurance policies in the current period into the receivable account age statistical backup table.

In some embodiments, after the determining whether the receivable data in the current period of the all policy is consistent according to the current financial receivable data and the current receivable age statistics table, the method further comprises: and deleting the policy data which are recorded and received in the current account receivable statistics table according to the real receipt data of the current account receivable statistics table.

In some embodiments, after deleting the policy data that is received while in fact in the current accounts receivable age statistics table according to the real receipt data of the current accounts receivable age statistics table, the method further includes: and generating a accounts receivable counting table of the next period based on the deleted current accounts receivable counting table.

In some embodiments, the current accounts receivable age statistics includes accounts receivable voucher numbers and time of the policy for the amount of the premium, real time status of the premium, real time voucher numbers and real time of the premium.

In some embodiments, after saving the real receipt data in the current period of all the policies in the current accounts receivable statistics to the current accounts receivable statistics, the method further comprises: and generating the account age index of the current period according to the receivable data and the actual receivable data of the current account age statistical table.

According to a second aspect of an embodiment of the present invention, there is provided a accounts receivable statistics apparatus, comprising: the first storage unit is used for storing the receivable data of the newly added insurance policy in the current period into the current receivable account age statistical table; the second storage unit is used for storing the real receipt data of all the policies in the current period in the current account receivable statistics table to the current account receivable statistics table; the judging unit is used for judging whether the current financial receivable data is consistent with the receivable data of all the insurance policies in the current period; the acquisition unit is used for acquiring a accounts receivable statistical backup table of the last period backup when the accounts receivable statistical backup table is inconsistent, wherein the accounts receivable statistical backup table stores the accounts receivable data and the real receipt data of all the insurance policies of the last period; and the checking unit is used for checking the policy data which are receivable and not practically receivable in the last period according to the current accounts receivable statistical table and the accounts receivable statistical backup table.

In some embodiments, the apparatus further includes a deleting unit configured to delete policy data that is actually received at the same time in the current accounts receivable years statistics table according to the real receipt data of the current accounts receivable years statistics table after determining whether the accounts receivable data of all policies in the current period are identical according to the current financial accounts receivable data and the current accounts receivable years statistics table.

According to a third aspect of embodiments of the present invention, there is provided a computer readable medium having stored thereon a computer program which when executed by a processor implements the accounts receivable age counting method as described in the first aspect of the above embodiments.

According to a fourth aspect of an embodiment of the present invention, there is provided an electronic device including: one or more processors; and storage means for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to implement the method of accounts receivable statistics as described in the first aspect of the embodiments above.

The technical scheme provided by the embodiment of the invention can have the following beneficial effects:

in the technical schemes provided by some embodiments of the invention, when the receivable data of the newly added policy in the current period is inconsistent, the policy data is checked according to the current receivable age statistics table and the backup table, so that the cause of the problem can be rapidly positioned when the business is inconsistent with the financial data, and the working efficiency is improved.

It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the invention as claimed.

Drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the invention and together with the description, serve to explain the principles of the invention. It is evident that the drawings in the following description are only some embodiments of the present invention and that other drawings may be obtained from these drawings without inventive effort for a person of ordinary skill in the art. In the drawings:

FIG. 1 schematically illustrates a flow chart of a method of accounts receivable statistics in accordance with one embodiment of the invention;

FIG. 2 shows a schematic diagram of a backup accounts receivable statistics table according to an embodiment of the invention;

FIG. 3 schematically illustrates a flow chart of a method of accounts receivable statistics in accordance with another embodiment of the invention;

FIG. 4 schematically illustrates a block diagram of a accounts receivable statistics device according to one embodiment of the invention;

FIG. 5 schematically illustrates a block diagram of a accounts receivable statistics apparatus according to another embodiment of the invention;

fig. 6 schematically shows a block diagram of a computer system suitable for use in implementing an embodiment of the invention.

Detailed Description

Example embodiments will now be described more fully with reference to the accompanying drawings. However, the exemplary embodiments may be embodied in many forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of the example embodiments to those skilled in the art.

Furthermore, the described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided to give a thorough understanding of embodiments of the invention. One skilled in the relevant art will recognize, however, that the invention may be practiced without one or more of the specific details, or with other methods, components, devices, steps, etc. In other instances, well-known methods, devices, implementations, or operations are not shown or described in detail to avoid obscuring aspects of the invention.

The block diagrams depicted in the figures are merely functional entities and do not necessarily correspond to physically separate entities. That is, the functional entities may be implemented in software, or in one or more hardware modules or integrated circuits, or in different networks and/or processor devices and/or microcontroller devices.

The flow diagrams depicted in the figures are exemplary only, and do not necessarily include all of the elements and operations/steps, nor must they be performed in the order described. For example, some operations/steps may be decomposed, and some operations/steps may be combined or partially combined, so that the order of actual execution may be changed according to actual situations.

In the related art, account age index statistics is performed according to the records of the premium to be charged and the real premium to be charged.

The premium records are shown in table 1 below:

TABLE 1

The real premium records are shown in table 2 below:

TABLE 2

The receivable age data obtained according to tables 1 and 2 are shown in table 3 below:

TABLE 3 Table 3

When the method for counting the account age index is adopted, if the business and the financial accounts chargeable amount are inconsistent when the account age index is counted, the reason for abnormality is difficult to locate.

In order to solve the above problems, embodiments of the present invention provide a method, an apparatus, a computer readable storage medium, and an electronic device for accounting-capable statistics, so as to quickly locate and timely solve the difference between the business and the financial accounting-capable premium amount when the business and the financial accounting-capable premium amount are inconsistent when the accounting-capable index appears.

Fig. 1 schematically illustrates a method of accounts receivable statistics according to an exemplary embodiment of the invention. The method provided by the embodiment of the invention can be executed by any electronic equipment with calculation processing capability, for example, a user terminal and/or a server. Referring to fig. 1, the method for calculating the accounts receivable age according to the embodiment of the present invention may include the following steps:

step S102, the receivable data of the newly added policy in the current period is stored in the current receivable account age statistical table.

Step S104, the real receipt data of all the policies in the current account receivable statistics table in the current period is stored in the current account receivable statistics table.

Step S106, judging whether the current financial receivable data is consistent with the receivable data of all the insurance policies in the newly added insurance policy in the current period.

Step S108, if the data are inconsistent, acquiring a accounts receivable statistical backup table of the last period backup, wherein the accounts receivable statistical backup table stores all the accounts receivable data and real-time receipt data of the last period.

Step S110, checking the data of the policy which is received and not received in practice in the last period according to the current account receiving age statistics table and the account receiving age statistics backup table.

In the accounts receivable statistics method provided by the embodiment of the invention, when the accounts receivable amount of the business and the financial accounts receivable amount are inconsistent, the reasons for the inconsistent business and the financial accounts receivable amount are checked through the accounts receivable statistics table backed up in the last period and the current accounts receivable amount statistics table, so that the reasons for the problems can be rapidly positioned.

In an embodiment of the present invention, the current accounts receivable statistics may include the accounts receivable voucher number and the time for the accounts receivable of the policy. Specifically, the accounts receivable statistics table (gppolicy) stores the accounts receivable voucher number (voucherNo) and the time of receipt (voucherDate) for which the premium was not actually received. When the policy is newly generated in the current period, the receipt and payment system is billed and step S102 is executed to save the accounts receivable data of the newly added policy in the current accounts receivable statistics table.

In other embodiments, the current accounts receivable statistics may also include the actual receipt status, actual receipt number, and actual receipt time of the premium. If the policy is received, step S104 is executed to update the real receipt status (e.g. the label provind= '1', but the invention is not limited thereto) in the current account-receivable statistics table, and record the real receipt credential number (payVoucherNo) and the real receipt time (paymentDate).

Wherein provind= '1' represents that the premium has been paid, and provind= '0' represents that the premium has not been paid. The receipt-less voucher number is not null and represents receipt, and the receipt-less voucher number is null and represents no receipt. The fact that the receipt number is not null represents that the receipt has been made, and the fact that the receipt number is null represents that the receipt has not been made.

Specifically, the accounts receivable data are shown in table 4 below:

TABLE 4 Table 4

Wherein, the receipt number of the policy corresponding to the organization C1 is V1 for receipt, and the receipt number of the policy corresponding to the organization C2 is V2 for receipt. The actual receipt number of the policy corresponding to the organization C1 is PV1 representing that the policy has been actually received, and the actual receipt number of the policy corresponding to the organization C2 is PV2 representing that the policy has been actually received.

After step S104, a current period account age indicator may be generated according to the receivable data and the actual receivable data of the current receivable account age statistics table.

In the embodiment of the present invention, the period is a month, but the present invention is not limited to this in practical application. For example, the cycle may be quarterly.

When the current month account age index is generated, only the policy data which should be received but not actually received needs to be counted, namely the policy data with the receipt not being empty (voucherNo not being empty) and the real receipt state being 0 (provind= '0') is counted.

After the account age index is successfully generated, the current account age statistical table is backed up into an account age statistical backup table (GPPOLICYAGINGARCHIVE).

After the backup is successful, the policy data which is actually received at the same time in the current account receivable statistics table is deleted according to the real receipt data of the current account receivable statistics table. Specifically, the policy data that has been received in fact, that is, the receipt-should-be-credence is not empty (voucherNo is not empty), and the policy data whose receipt-in-fact state is 1 (provind= '1') is deleted. Therefore, the data volume in the account receivable statistics table can be prevented from being excessively large, and the follow-up provision of a policy list for clients or channels is facilitated.

In the embodiment of the invention, the accounts receivable statistics table of the next period can be generated based on the deleted current accounts receivable statistics table. Thus, the newly added policy data and the actual charge of the next period can be updated based on the account age statistics table to generate the account age index of the next period, and a basis is provided for checking the accounts charge and the actual charge of the next period.

After step S106, if the business data and the financial data are inconsistent, step S110 is performed to check the reason for the inconsistency between the business data and the financial data through the accounts receivable statistics table and the accounts receivable statistics backup table.

In step S108, a backup accounts receivable statistical backup table is acquired. Wherein, the account receivable statistics backup table stores the receivable data and the actual receivable data of all the insurance policies in the previous period.

When step S110 is executed, the accounts receivable statistics table of the previous cycle has been backed up to the accounts receivable statistics backup table. After step S110, the receivable data and the actual receivable data of all the policies of the current period need to be saved in the receivable account age statistical backup table.

As shown in fig. 2, A3 is a policy statement, i.e., a business receipt, to be newly recorded in the current month, and in step S106, it is necessary to check whether the business receipt represented by A3 coincides with the financial receipt.

Here, the financial receivable refers to data of received policy fees recorded by the financial system, and when the business receivable and the financial receivable data agree, data representing a statistics of the receivable ages are normal, and the financial system is normally billed.

When the business receivable and the financial receivable data are inconsistent, the current month policy details and the previous month backup policy details need to be checked to determine the reason of the inconsistent business receivable and the financial receivable data. Specifically, comparing at A2, it can be known whether the current month policy details are consistent with the previous month backup policy details, if not, the difference between the current month policy details and the previous month backup policy details needs to be analyzed, so that the cause of the difference can be rapidly located.

A1 is the bill detail which is received in the last month and before, and after the account age index is generated in the last month, the part of data needs to be deleted from the account age statistics table to ensure that the data amount in the account age statistics table is not excessive, thereby being convenient for providing a bill list for customers or channels.

In the embodiment of the invention, when the list of the accounts receivable is provided corresponding to the channel requirement, the account receivable and non-received data of the accounts receivable statistics table (GPPOLICYAGING) can be directly extracted, so that the method is accurate and convenient.

As shown in fig. 3, in one embodiment of the present invention, the accounts receivable statistics may be performed as follows:

step S301, a statistical backup table of the accounts receivable ages after the last period of backup is obtained.

Step S302, the receivable data of the newly added policy in the current period is stored in the current receivable account age statistical table.

After step S302 is executed, step S303 is executed to save the actual receipt data of the differential policy in the current accounts receivable statistics table in the current period to the current accounts receivable statistics table.

Step S304 is executed to generate the account age index of the current period according to the receivable data and the actual receivable data of the current account age statistical table.

Step S305 is then executed to backup the current accounts receivable statistics table to the accounts receivable statistics backup table.

Then, step S306 is executed to delete the policy data that is actually received at the same time in the current accounts receivable statistics table according to the real receipt data of the current accounts receivable statistics table.

Step S307 is then executed to generate a accounts receivable count table for the next period based on the deleted current accounts receivable count table.

Step S308 is then executed to determine whether the current financial receivable data and the receivable data of all the policies in the current period are consistent.

If the result of step S308 is no, step S309 is executed to check the policy data that should be received and not actually received in the previous period according to the current account receivable statistics table and the account receivable statistics backup table after the backup in the previous period. The accounts receivable backup statistics table after the previous period of backup is obtained through step S301.

When the result of step S308 is yes, the flow is ended.

In the accounts receivable statistics cases shown in tables 5 to 10 below, table 5 is a accounts receivable statistics table of 2018, 1, and table 6 is a accounts receivable statistics backup table of 2018, 1. Table 7 is a accounts receivable statistics table for 2 months in 2018, and table 8 is a accounts receivable statistics backup table for 2 months in 2018. Table 9 is a accounts receivable statistics table for 3 months in 2018, and table 10 is a accounts receivable statistics backup table for 3 months in 2018.

TABLE 5

TABLE 6

TABLE 7

/>

TABLE 8

TABLE 9

Table 10

/>

As shown in tables 5 to 10, data without change in the current period is recorded in real time in the accounts receivable statistics table. If a policy is recorded and is also received, the data is not counted when the policy is counted, and the month end can be deleted from the account-to-be-received age counting table. In order to ensure the complete consistency of the historical data and facilitate the searching of the problem data, all the data are backed up to the account receivable age statistical backup table before deleting the data. Thus, the total data of the statistics to be collected for each month exists in the backup table of the statistics to be collected for the account. And the subsequent problem data backtracking is facilitated.

If the business receivable amount is not consistent with the financial receivable subject amount. The method is divided into two cases that the difference is received in the current month and the log-in data of the current month is normal but the historical data is wrong.

Among them, the case where the harvest of the current month, that is, 3 months in 2018, was different can be obtained by combining table 9 and tables 11 to 12 below.

TABLE 11

Table 12

As shown in tables 11 and 12, the total financial accounts for 3 months should be 125 yuan. As shown in table 9, the business calculates the total chargeable premium 111 (sum of the policies P3, P16, P17, P12) based on the chargeable age table, 14 yuan worse. Checking all generated certificates and policy details according to the month, and finding that the policy P10 is received in fact but not billed.

By combining tables 9, 11, 12 and 8, it is possible to obtain a case where the current month check-in data is normal but the history data is erroneous. The total financial charge for 3 months is 125 yuan. The business calculates the total chargeable premium 122 (policy P3, P14, P16, P17, P12) according to the chargeable age table, which differs by 3 yuan. Checking is performed based on the month generation certificate (V6, V7, V8, V9, PV6, PV7, PV8, PV 9) to find the same amount of the check-in amount in the month. Since the business receivable amount of the last month is consistent with the financial receivable amount, the data of the last month backup of the 3 month receivable account age statistical table and the 2 month receivable account age statistical backup table are checked again. The check account receivable statistics table and the backup table find that the following insurance policy is different: p3, P7, P8, P11, P13, P14, P15, P16, P17, P18, P19, P20.

Wherein, P7, P8, P11, P13 and P14 are data which have been received in fact in 2 months, and should not be considered in the scope of the statistics to be received, and should be deleted from the statistics to be received; p15, P16, P17, P18, P19 and P20 are 3 months newly-checked-in policy, and are normal if they do not exist in the 2 months backup data; the policy P3 should pay inconsistent, 5-ary in the account age statistics table, 8-ary in the backup table, and the difference is exactly 3-ary. From this, it is found that the policy P3 premium amount is modified.

According to the account receivable age statistics method provided by the embodiment of the invention, when the account receivable data of the newly added insurance policy in the current period is inconsistent, the insurance policy data is checked according to the current account receivable age statistics table and the backup table, so that the reasons of problems can be rapidly positioned when the business is inconsistent with the financial data, and the working efficiency is improved.

The following describes an embodiment of the apparatus of the present invention, which may be used to perform the accounts receivable statistics method of the present invention described above. As shown in fig. 4, a accounts receivable statistics apparatus 400 according to an embodiment of the present invention may include:

the first storage unit 402 may be configured to store receivable data of the newly added policy in the current period in the current receivable account age statistics table.

The second storing unit 404 may be configured to store the real receipt data of all the policies in the current accounts receivable statistics table in the current period to the current accounts receivable statistics table.

The determining unit 406 may be configured to determine whether the current financial receivable data and the receivable data of all the policies in the current period are consistent.

And the acquiring unit 408 is configured to acquire, when the data are inconsistent, a accounts receivable statistics backup table backed up in the previous period, where the accounts receivable statistics backup table stores the accounts receivable data and the real receipt data of all the policies in the previous period.

The checking unit 410 checks the policy data which should be received and not actually received in the last period according to the current account receivable count table and the account receivable count backup table.

In the accounts receivable statistics device provided by the embodiment of the invention, when the accounts receivable amount of the business and the financial accounts receivable amount are inconsistent, the reasons for the inconsistent business and the financial accounts receivable amount are checked through the accounts receivable statistics table backed up in the last period and the current accounts receivable statistics table, so that the reasons for the problems can be rapidly positioned.

According to an exemplary embodiment of the present invention, referring to fig. 5, compared to the accounts receivable statistics apparatus 400, the accounts receivable statistics apparatus 500 may include not only the first saving unit 402, the second saving unit 404, the judging unit 406, the acquiring unit 408, and the collating unit 410, but also the deleting unit 502.

The deletion unit 502 may be configured to delete policy data that is actually received at the time of recording in the current accounts receivable age statistics table from the real-time receipt data of the current accounts receivable age statistics table after judging whether the accounts receivable data in the current period are consistent with the all policies according to the current financial accounts receivable data.

Therefore, the data volume in the account receivable statistics table can be prevented from being excessively large, and the follow-up provision of a policy list for clients or channels is facilitated.

After deleting the policy data that is actually received at the same time of recording in the current accounts receivable age statistics table, the accounts receivable age statistics table of the next period may also be generated based on the deleted current accounts receivable age statistics table. Thus, in the next cycle, an update may be made based on this accounts receivable statistics.

In the embodiment of the present invention, the accounts receivable statistics device may further include a backup unit configured to backup the current accounts receivable statistics table to the accounts receivable statistics backup table.

And analyzing the difference between the current period accounts receivable statistical table and the accounts receivable statistical table backed up in the previous period, so that the reason of the difference can be rapidly positioned.

The accounts receivable age statistics device may further generate an account receivable age index of the current period according to the accounts receivable data and the real-time data of the current accounts receivable age statistics table.

Since each functional module of the accounts receivable statistics device according to the exemplary embodiment of the present invention corresponds to a step of the exemplary embodiment of the accounts receivable statistics method described above, for details not disclosed in the apparatus embodiment of the present invention, please refer to the embodiment of the accounts receivable statistics method described above.

According to the accounts receivable statistics device provided by the embodiment of the invention, when the accounts receivable data of the newly added insurance policy in the current period is inconsistent, the insurance policy data is checked according to the current accounts receivable statistics table and the backup table, so that the reasons of problems can be rapidly positioned when the business is inconsistent with the financial data, and the working efficiency is improved.

Referring now to FIG. 6, there is illustrated a schematic diagram of a computer system 600 suitable for use in implementing an electronic device of an embodiment of the present invention. The computer system 600 of the electronic device shown in fig. 6 is only an example and should not be construed as limiting the functionality and scope of use of embodiments of the invention.

As shown in fig. 6, the computer system 600 includes a Central Processing Unit (CPU) 601, which can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 602 or a program loaded from a storage section 608 into a Random Access Memory (RAM) 603. In the RAM 603, various programs and data required for system operation are also stored. The CPU 601, ROM 602, and RAM 603 are connected to each other through a bus 604. An input/output (I/O) interface 605 is also connected to bus 604.

The following components are connected to the I/O interface 605: an input portion 606 including a keyboard, mouse, etc.; an output portion 607 including a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, a speaker, and the like; a storage section 608 including a hard disk and the like; and a communication section 609 including a network interface card such as a LAN card, a modem, or the like. The communication section 609 performs communication processing via a network such as the internet. The drive 610 is also connected to the I/O interface 605 as needed. Removable media 611 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is installed as needed on drive 610 so that a computer program read therefrom is installed as needed into storage section 608.

In particular, according to embodiments of the present invention, the processes described above with reference to flowcharts may be implemented as computer software programs. For example, embodiments of the present invention include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method shown in the flowcharts. In such an embodiment, the computer program may be downloaded and installed from a network through the communication portion 609, and/or installed from the removable medium 611. The above-described functions defined in the system of the present application are performed when the computer program is executed by a Central Processing Unit (CPU) 601.

The computer readable medium shown in the present invention may be a computer readable signal medium or a computer readable storage medium, or any combination of the two. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples of the computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present invention, however, the computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, with the computer-readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.

The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

The units involved in the embodiments of the present invention may be implemented by software, or may be implemented by hardware, and the described units may also be provided in a processor. Wherein the names of the units do not constitute a limitation of the units themselves in some cases.

As another aspect, the present application also provides a computer-readable medium that may be contained in the electronic device described in the above embodiment; or may exist alone without being incorporated into the electronic device. The computer-readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to implement the accounts receivable age counting method as described in the above embodiments.

For example, the electronic device may implement the method as shown in fig. 1: step S102, the receivable data of the newly added policy in the current period is stored in a current receivable account age statistical table; step S104, storing the real receipt data of all the policies in the current period in the current account receivable statistics table to the current account receivable statistics table; step S106, judging whether the current financial receivable data is consistent with the receivable data of all the insurance policies in the current period; step S108, if the data are inconsistent, acquiring a accounts receivable statistical backup table of the accounts receivable backup in the previous period, wherein the accounts receivable statistical backup table stores the accounts receivable data and the real receipt data of all the insurance policies in the previous period; step S110, checking the data of the policy which is received and not received in practice in the last period according to the current account receiving age statistics table and the account receiving age statistics backup table.

As another example, the electronic device may implement the steps shown in fig. 3.

It should be noted that although in the above detailed description several modules or units of a device for action execution are mentioned, such a division is not mandatory. Indeed, the features and functions of two or more modules or units described above may be embodied in one module or unit in accordance with embodiments of the invention. Conversely, the features and functions of one module or unit described above may be further divided into a plurality of modules or units to be embodied.

From the above description of embodiments, those skilled in the art will readily appreciate that the example embodiments described herein may be implemented in software, or may be implemented in software in combination with the necessary hardware. Thus, the technical solution according to the embodiments of the present invention may be embodied in the form of a software product, which may be stored in a non-volatile storage medium (may be a CD-ROM, a U-disk, a mobile hard disk, etc.) or on a network, and includes several instructions to cause a computing device (may be a personal computer, a server, a touch terminal, or a network device, etc.) to perform the method according to the embodiments of the present invention.

Other embodiments of the invention will be apparent to those skilled in the art from consideration of the specification and practice of the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of the invention following, in general, the principles of the invention and including such departures from the present disclosure as come within known or customary practice within the art to which the invention pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the invention being indicated by the following claims.

It is to be understood that the invention is not limited to the precise arrangements and instrumentalities shown in the drawings, which have been described above, and that various modifications and changes may be effected without departing from the scope thereof. The scope of the invention is limited only by the appended claims.

Claims

1. A method of accounts receivable statistics, comprising:

storing the receivable data of the newly added policy in the current period into a current receivable account age statistical table;

storing real receipt data of all the policies in the current period in the current account receivable statistics table to the current account receivable statistics table;

judging whether the current financial receivable data is consistent with the receivable data of all the insurance policies in the current period;

if the data are inconsistent, acquiring a accounts receivable statistical backup table of the accounts receivable backup in the previous period, wherein the accounts receivable statistical backup table stores all the accounts receivable data and real-time receipts of all the insurance policies in the previous period;

checking the policy data which are received and not received in real in the last period according to the current account receiving age statistics table and the account receiving age statistics backup table;

wherein after the determining whether the current financial receivable data and the receivable data of the all policy in the current period are consistent, the method further includes:

deleting the policy data which are recorded and received in real time in the current account receivable statistics table according to the real receipt data of the current account receivable statistics table;

generating a accounts receivable counting table of the next period based on the deleted current accounts receivable counting table;

the current accounts receivable statistics table includes the accounts receivable certificate number and the real receipt status of the policy, and the deleting the policy data of the current accounts receivable statistics table, which is recorded and real received, according to the real receipt data of the current accounts receivable statistics table includes: and deleting the policy data of which the receipt-receivable certificates are not empty in the current account-receivable age statistical table and the real receipt state indicates that the receipt-receivable premium has been real received.

2. The method of claim 1, wherein after checking the policy data that was receivable and not received in the last period according to the current receivable statistics table and the receivable statistics backup table, the method further comprises:

3. The method of claim 1, wherein the current accounts receivable age statistics further comprises a time of receipt for a premium, a real receipt number, and a real time of receipt for a policy.

4. The method of claim 3, wherein after saving the actual receipt data in the current period for all policies in the current accounts receivable statistics to the current accounts receivable statistics, the method further comprises:

and generating the account age index of the current period according to the receivable data and the actual receivable data of the current account age statistical table.

5. A accounts receivable statistics apparatus, comprising:

the first storage unit is used for storing the receivable data of the newly added insurance policy in the current period into the current receivable account age statistical table;

the second storage unit is used for storing the real receipt data of all the policies in the current period in the current account receivable statistics table to the current account receivable statistics table;

the judging unit is used for judging whether the current financial receivable data is consistent with the receivable data of all the insurance policies in the current period;

the acquisition unit is used for acquiring a accounts receivable statistical backup table of the last period backup when the accounts receivable statistical backup table is inconsistent, wherein the accounts receivable statistical backup table stores the accounts receivable data and the real receipt data of all the insurance policies of the last period;

the checking unit is used for checking the policy data which are receivable and not practically receivable in the last period according to the current account receivable statistics table and the account receivable statistics backup table;

a deleting unit, configured to delete policy data that is actually received at the time of recording and receiving in the current account receivable age statistics table according to the actual receipt data of the current account receivable age statistics table; generating a accounts receivable counting table of the next period based on the deleted current accounts receivable counting table;

the current account receivable statistics table comprises the account receivable certificate number and the real receipt state of the policy, and the deleting unit is further configured to delete policy data that the account receivable certificate is not empty and the real receipt state indicates that the policy data that the policy charge is received in real.

6. A computer readable medium on which a computer program is stored, characterized in that the program, when executed by a processor, implements the accounts receivable statistics method of any one of claims 1 to 4.

7. An electronic device, comprising:

one or more processors;

storage means for storing one or more programs which when executed by the one or more processors cause the one or more processors to implement the accounts receivable age statistics method as claimed in any one of claims 1 to 4.