Method, device and equipment for automatically cancelling receivable account after verification and medium
By using preset interfaces in traditional accounting systems to obtain incremental data and automatically write off accounts receivable, the problems of data inconsistency between multiple systems and inefficient manual write-offs in traditional accounting systems are solved, and automated write-offs and accounting accuracy are achieved.
Patent Information
- Application Number
- CN202311723589.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2023-12-14
- Publication Date
- 2025-06-17
AI Technical Summary
When using traditional accounting systems, it is necessary to repeatedly sort, match and write-off the payments in multiple systems, resulting in high manual error rates, low efficiency, and inconsistent data between multiple systems.
The incremental data is obtained through the preset interface, updated to the financial voucher information and the write-off relationship data table, and determined the payment item and repayment method of the write-off voucher based on the mapping relationship between the preset account number and the deposit item. The accounts receivable record is determined based on the matching priority, and the write-off amount is modified based on the amount of the write-off voucher, and finally the write-off relationship table is added.
It realizes automatic write-off of accounts receivable, reduces labor costs, ensures accounting accuracy, avoids inefficient write-off operations between multiple systems, and solves the problem of data inconsistency.
Smart Images
Figure CN120163670A_ABST
Abstract
Description
Technical Field
[0001] This application relates to a method, device, equipment and medium for automatically writing off accounts receivable. Background Art
[0002] In recent years, with the increasing intelligent development level of enterprise management software and financial management software year by year, business-finance integration software has also been widely used. When accounting uses a traditional bookkeeping system for accounting, it often needs to repeat the sorting, matching and writing off of received payments in multiple systems. Enterprises also need to invest more manpower and costs to ensure the accurate matching of fund settlement and book balance. There are also disadvantages such as high error rates and low efficiency in manual sorting and matching. Summary of the Invention
[0003] In order to better achieve the automatic write-off of accounts receivable, the embodiments of this application provide a method, device, equipment and medium for automatically writing off accounts receivable.
[0004] In a first aspect, the embodiments of this application provide a method for automatically writing off accounts receivable, the method includes:
[0005] Based on a preset interface, obtain incremental data, and update the incremental data to the financial voucher information and the write-off relationship data table; the incremental data includes at least a pair of write-off vouchers and vouchers to be written off;
[0006] According to the preset mapping relationship between the preset account number and the received payment item, determine the received payment item corresponding to the account number in the write-off voucher;
[0007] According to the received payment item, determine the payment method, and based on the payment method, the write-off voucher and the voucher to be written off, obtain the corresponding payment record;
[0008] According to the voucher to be written off, based on the preset matching priority, determine the corresponding accounts receivable record;
[0009] According to the amount in the write-off voucher, modify the write-off amount in the accounts receivable record;
[0010] Based on the payment record and the modified accounts receivable record, add a write-off relationship table.
[0011] In an optional implementation manner of the embodiments of this application, the determining the corresponding accounts receivable record according to the voucher to be written off based on the preset matching priority includes:
[0012] According to the voucher number in the voucher to be written off, determine the corresponding invoice application number;
[0013] According to the invoice application number, determine whether there is an accounts receivable record with an accounts receivable balance greater than zero;
[0014] If so, obtain the corresponding accounts receivable record;
[0015] If not, based on the customer number and project number of the written-off voucher, determine whether there is an accounts receivable record with an accounts receivable balance equal to the written-off amount among all accounts receivable records with matching customer numbers and project numbers;
[0016] If so, obtain the corresponding accounts receivable record;
[0017] If not, based on the customer number of the written-off voucher, determine whether there is an accounts receivable record with an accounts receivable balance equal to the written-off amount among all accounts receivable records with matching customer numbers;
[0018] If so, obtain the corresponding accounts receivable record;
[0019] If not, based on the customer number of the written-off voucher, determine the accounts receivable record with a matching customer number.
[0020] In an alternative implementation manner of the embodiment of the present application, the determining the accounts receivable record with a matching customer number according to the customer number of the written-off voucher further includes:
[0021] If there are multiple accounts receivable records with matching customer numbers, sort them according to the aging date and allocate the written-off amount to the multiple accounts receivable records.
[0022] In an alternative implementation manner of the embodiment of the present application, the modifying the written-off amount in the accounts receivable record according to the amount in the written-off voucher includes:
[0023] Add the original written-off amount in the accounts receivable record to the amount in the written-off voucher to obtain the written-off amount, and modify the original written-off amount to the written-off amount.
[0024] In an alternative implementation manner of the embodiment of the present application, the obtaining incremental data based on a preset interface and updating it to the financial voucher information and the write-off relationship data table includes:
[0025] According to a preset time period, through preset input parameters, based on the preset interface, obtain incremental data and update it to the financial voucher information and the write-off relationship data table; the preset input parameters include the account set code, start time, and end time.
[0026] In an alternative implementation manner of the embodiment of the present application, after adding the write-off relationship table based on the collection record and the modified accounts receivable record, it further includes:
[0027] Judge whether the accounts receivable balance of the accounts receivable record is zero;
[0028] If so, it is determined that all the accounts receivable balances recorded in the accounts receivable records are written off, and the corresponding accounting vouchers are marked as cleared accounting vouchers.
[0029] In a second aspect, an embodiment of the present application provides an automatic accounts receivable write-off device, which includes:
[0030] An acquisition module, configured to acquire incremental data based on a preset interface, and update the incremental data to the financial voucher information and the write-off relationship data table; the incremental data includes at least a pair of write-off vouchers and written-off vouchers;
[0031] A first determination module, configured to determine the receipt item corresponding to the account number in the write-off voucher according to a preset mapping relationship between the preset account number and the receipt item;
[0032] A second determination module, configured to determine the repayment method according to the receipt item, and obtain a corresponding repayment record based on the repayment method, the write-off voucher and the written-off voucher;
[0033] A third determination module, configured to determine a corresponding accounts receivable record according to the written-off voucher based on a preset matching priority;
[0034] A write-off module, configured to modify the write-off amount in the accounts receivable record according to the amount in the write-off voucher;
[0035] A recording module, configured to add a write-off relationship table based on the repayment record and the modified accounts receivable record.
[0036] In a third aspect, an embodiment of the present application provides a computer-readable storage medium, on which a computer program is stored, and when the program is executed by a processor, the automatic accounts receivable write-off method as described above is implemented.
[0037] In a fourth aspect, an embodiment of the present application provides a computer device, including a memory, a processor, and a computer program stored on the memory and executable on the processor, and when the processor executes the computer program, the automatic accounts receivable write-off method as described above is implemented.
[0038] In a fifth aspect, an embodiment of the present application provides a computer program product including instructions, and when the computer program product runs on a computer device, the computer device is enabled to execute the automatic accounts receivable write-off method as described above.
[0039] In a sixth aspect, an embodiment of the present application provides a chip, which includes a processor and a communication interface, the communication interface is coupled to the processor, and the processor is configured to run a computer program or instruction to implement the automatic accounts receivable write-off method as described above.
[0040] The beneficial effects of the above technical solutions provided by the embodiments of the present application at least include:
[0041] The method for automatically writing off accounts receivable provided by the embodiments of the present application obtains at least a pair of write-off vouchers and vouchers to be written off through a preset interface, determines the receipt items and receipt methods corresponding to the account numbers in the write-off vouchers according to the preset mapping relationship between the preset account numbers and receipt items, and obtains the corresponding receipt records based on the write-off vouchers and vouchers to be written off. Then, according to the vouchers to be written off and based on the preset matching priority, the corresponding accounts receivable records are determined. Next, according to the amount in the write-off vouchers, the written-off amount in the accounts receivable records is modified. Finally, based on the receipt records and the modified accounts receivable records, a write-off relationship table is added. This method reduces labor costs, enabling accountants to perform only one sorting and write-off operation in the traditional accounting system when conducting receipt settlement, while the business and finance integration system will automatically write off and match the accounts receivable balance through this method, ensuring the accuracy of the accounts, avoiding the inefficient operation of performing multiple write-off operations in the traditional accounting system and the business and finance integration system, and being able to better solve the problem of data inconsistency between multiple systems.
[0042] Other features and advantages of the present application will be described in the subsequent specification, and part of them will become obvious from the specification or be understood by implementing the present application. The objectives and other advantages of the present application can be achieved and obtained through the structures specifically pointed out in the written specification, claims, and drawings.
[0043] The technical solutions of the present application will be further described in detail below through the drawings and embodiments. Description of the Drawings
[0044] The drawings are used to provide a further understanding of the present application and constitute a part of the specification. Together with the embodiments of the present application, they are used to explain the present application and do not constitute a limitation to the present application; in the drawings:
[0045] Figure 1 It is a schematic diagram of the steps of the method for automatically writing off accounts receivable provided by the embodiments of the present application;
[0046] Figure 2 It is a schematic diagram of an example of the division of the preset matching priority provided by the embodiments of the present application;
[0047] Figure 3 It is a schematic diagram of the overall process of automatic write-off provided by the embodiments of the present application;
[0048] Figure 4 It is a schematic diagram of the structure of the device for automatically writing off accounts receivable provided by the embodiments of the present application. Detailed Embodiments
[0049] In the following description, specific details such as specific system architectures and technologies are presented for purposes of illustration and not limitation, so as to provide a thorough understanding of the embodiments of the present application. However, those skilled in the art should understand that the present application can also be implemented in other embodiments without these specific details. In other cases, detailed descriptions of well-known systems, devices, circuits, and methods are omitted to avoid unnecessary details from obscuring the description of the present application.
[0050] It should be understood that when used in the specification of the present application and the appended claims, the term "comprising" indicates the presence of the described features, wholes, steps, operations, elements, and / or components, but does not exclude the presence or addition of one or more other features, wholes, steps, operations, elements, components, and / or their combinations.
[0051] It should also be understood that the term "and / or" as used in the specification of the present application and the appended claims refers to any combination and all possible combinations of one or more of the associated listed items, and includes these combinations.
[0052] As used in the specification of the present application and the appended claims, the term "if" can be interpreted as "when" or "once" or "in response to determining" or "in response to detecting" depending on the context. Similarly, the phrase "if determined" or "if [the described condition or event] is detected" can be interpreted as meaning "once determined" or "in response to determining" or "once [the described condition or event] is detected" or "in response to detecting [the described condition or event]" depending on the context.
[0053] In addition, in the description of the specification of the present application and the appended claims, the terms "first", "second", "third", etc. are only used for differentiating descriptions and cannot be understood as indicating or implying relative importance.
[0054] The reference to "one embodiment" or "some embodiments" or the like described in the specification of the present application means that a specific feature, structure, or characteristic described in connection with that embodiment is included in one or more embodiments of the present application. Thus, statements such as "in one embodiment", "in some embodiments", "in other some embodiments", "in still other embodiments", etc. that appear in different places in this specification are not necessarily all referring to the same embodiment, but mean "one or more but not all embodiments", unless otherwise specifically emphasized in another way. The terms "comprising", "including", "having", and their variants all mean "including but not limited to", unless otherwise specifically emphasized in another way.
[0055] It should be understood that the sequence numbers of the steps in the following embodiments do not imply the order of execution. The order of execution of each process should be determined according to its function and internal logic, and should not constitute any limitation to the implementation process of the embodiments of the present application.
[0056] To illustrate the technical solution of the present application, specific embodiments are used for illustration below.
[0057] The inventor found that in the prior art, when using traditional accounting software for accounting, it is necessary to manually repeat the sorting, matching, and verification of received payments in multiple systems. There are disadvantages such as a high error rate and low efficiency in manual sorting and matching, which requires enterprises to invest more manpower and costs to ensure the accurate matching of fund settlement and book balance. There is also a problem of data inconsistency between multiple systems, which does not meet the inventor's expectations. Based on this, after further research and development, the inventor proposed the present application, providing an automatic accounts receivable verification method, device, equipment, and medium.
[0058] Embodiment 1
[0059] The embodiment of the present application provides an automatic accounts receivable verification method. Referring to Figure 1 as shown, the method includes:
[0060] S101: Based on a preset interface, obtain incremental data, and update the incremental data to the financial voucher information and the verification relationship data table; the incremental data includes at least a pair of verification vouchers and vouchers to be verified.
[0061] In the embodiment of the present application, the obtaining of incremental data based on a preset interface and updating it to the financial voucher information and the verification relationship data table specifically includes:
[0062] According to a preset time period, through preset input parameters, based on the preset interface, obtain incremental data and update it to the financial voucher information and the verification relationship data table; the preset input parameters include the account set code, start time, and end time.
[0063] In the embodiment of the present application, financial data in the traditional accounting system is obtained through a preset interface. The preset interface runs regularly according to a preset time period, pulls accounting voucher information and verification relationship data from the traditional accounting system, and determines the incrementally updated data (i.e., incremental data) based on the comparison of data in the previous time period. Starting from the incremental data, automatic verification begins. The preset time period is set according to the actual situation. For example, it can be set to 23:00 every day.
[0064] In the process of obtaining incremental data through the preset interface above, the preset interface obtains the data returned by the traditional accounting system through preset input parameters, and updates the obtained incremental data to the accounting voucher information and the verification relationship data table.
[0065] Among them, the preset input parameters may include fields such as the account set code, start time, and end time. Table 1 below is an example of the preset input parameters, which includes fields such as the account set code, start time, end time, responsibility center, subject number, and counterpart unit. The parameter values corresponding to each field are manually given during initialization. As shown in Table 1 below, they can be fixed when the business does not change.
[0066] Table 1 Main core fields of the preset input parameters
[0067]
[0068] The incremental data obtained through the interface includes at least a pair of write-off vouchers and the vouchers to be written off. They are written into the accounting voucher information and the write-off relationship data table. Table 2 below is an example of the accounting voucher information and the write-off relationship data table. In the table, the value of the hanging write-off flag field being 0 indicates the write-off voucher, and the value of 1 indicates the voucher to be written off. The voucher number fields of the write-off voucher and the voucher to be written off are different.
[0069] Table 2 Main core fields of the accounting voucher information and the write-off relationship data retrieved through the preset interface
[0070] Field Name Field Code Sample Data Remarks Accounting Period PZRQ 202108 Write-off Date HXRQ 20210919 Write-off Number HXBH 34689 Voucher Date DATE 20210819 Voucher Number PZBH JZPZ01806 Responsibility Center ZRCODE 20912264 Subject Number KMBH 10020300 10020300 = Bank Deposit Bill Number YSBH 10190842 Project Number XMBH BJSJ202100012 Business Partner DWBH 1001176792 Unit Number Write-off and Reconciliation Flag HXHC 0 0 = Write-off; 1 = Written off Accounting Direction JZFX J J = Debit; D = Credit Amount HXJE 1005700.60 Foreign Currency Number WBBH 1001 1001 = RMB; 1002 = US Dollar Exchange Rate HL 1 Foreign Currency Amount HXWB 1005700.60 Write-off Processed CHECKED 1 Null is the initial default, 1 = Processed, 2 = Failed
[0071] S102: Determine the receipt item corresponding to the subject number in the write-off voucher according to the preset mapping relationship between the preset subject number and the receipt item.
[0072] In the embodiments of the present application, the receipt items are configured differently according to the situations of each company, generally including bank deposits, accounts payable, notes receivable, etc. The mapping relationship between the subject number and the receipt item is preset. For example, the mapping relationship can be set as follows: 290500010002 indicates that the receipt item is advance receipt, that is, contract liability - price; 2202 indicates that the receipt item is payable, that is, accounts payable; 1011 indicates that the receipt item is internal deposit; 2241 indicates that the receipt item is other payables; 1121 indicates that the receipt item is notes receivable; 1002 indicates that the receipt item is bank deposit.
[0073] According to the preset mapping relationship between the subject number and the receipt item, the receipt item corresponding to the subject number in the unprocessed write-off voucher can be determined, and the receipt item can also be used as the type of write-off. For example, in the example data in Table 2 above, the subject number is 10020300, indicating that the receipt item is bank deposit.
[0074] S103: Determine the receipt method according to the receipt item, and obtain the corresponding receipt record based on the receipt method, the write-off voucher, and the voucher to be written off.
[0075] In the embodiment of the present application, according to the received payment item determined for a write-off voucher in S102, the corresponding payment collection method can be determined. The payment collection methods are generally bank deposits, promissory notes receivable, etc. After confirming the payment collection method, based on the pair of write-off vouchers and the written-off vouchers, a corresponding payment collection record can be obtained. This payment collection record can be used as the main basis for querying the current funds flow. As shown in Table 3 below, an example of a payment collection record is given. If the example data given in the payment collection method field in the table is 1, it indicates that the payment collection method of this payment collection record is bank deposit.
[0076] Table 3 Main core fields of the payment collection table of the business-finance integration system
[0077] Field Name Field Code Sample Data Remarks Collection Number HKBH HK1100123 Subsidiary Company GSDM H900 Project Number XMBH 34689 Customer Number KHBH 10190842 Voucher Number PZBH JZPZ01806 Collection Date HKRQ 20210819 Collection Method ZLBH 1 1 = Bank Deposit, 2 = Receivable Bill Customer Number KHBH 10190842 Collection Amount JE 1005700.60 Foreign Currency Number WBBH 1001 1001 = RMB; 1002 = US Dollar Exchange Rate HL 1 Foreign Currency Amount HXWB 1005700.60
[0078] S104: Based on the written-off voucher, determine the corresponding accounts receivable record according to the preset matching priority.
[0079] In the embodiment of the present application, the determining the corresponding accounts receivable record based on the written-off voucher according to the preset matching priority includes:
[0080] Determine the corresponding invoicing application number according to the voucher number in the written-off voucher;
[0081] Judge whether there is an accounts receivable record with an accounts receivable balance greater than zero according to the invoicing application number;
[0082] If so, obtain the corresponding accounts receivable record;
[0083] If not, judge whether there is an accounts receivable record with an accounts receivable balance equal to the write-off amount among all the accounts receivable records with matching customer numbers and project numbers according to the customer number and project number of the written-off voucher;
[0084] If so, obtain the corresponding accounts receivable record;
[0085] If not, judge whether there is an accounts receivable record with an accounts receivable balance equal to the write-off amount among all the accounts receivable records with matching customer numbers according to the customer number of the written-off voucher;
[0086] If so, obtain the corresponding accounts receivable record;
[0087] If not, determine the accounts receivable record with a matching customer number according to the customer number of the written-off voucher.
[0088] In the embodiment of the present application, the determining the accounts receivable record with a matching customer number according to the customer number of the written-off voucher further includes:
[0089] If there are multiple accounts receivable records matching the customer number, sort them by aging date and allocate write-off amounts to the multiple accounts receivable records.
[0090] In the embodiment of this application, after determining the repayment record, it is necessary to match the corresponding accounts receivable record in the business and finance integration system for write-off. The accounts receivable records are shown in Table 4 below:
[0091] Table 4 Main core fields of the accounts receivable record table
[0092] Field Name Field Code Sample Data Remarks Receivable ID YSID YSZK100123 Invoice Number FPBH 20210919 Project Number XMBH 34689 Voucher Date PZRQ 20210819 Voucher Number PZBH JZPZ01806 Responsibility Center ZRZX 20912264 Account Age Date ZLRQ 20210819 Customer Number DWBH 10190842 Accounts Receivable Amount YSJE 1005700.60 Returned Check Amount TPJE 0 Write-off Amount HXJE 1005700.60 Foreign Currency Number WBBH 1001 1001 = RMB; 1002 = US Dollar Exchange Rate HL 1 Foreign Currency Amount HXWB 1005700.60
[0093] In the embodiment of this application, according to the written-off voucher, the corresponding accounts receivable records for this write-off can be screened through a preset matching priority. Among them, the division of the preset matching priority can be as Figure 2 shown, and it is divided into the following four levels of priority:
[0094] First priority: According to the hanging voucher (i.e., the written-off voucher), find the corresponding invoicing application number in the business and finance voucher table, and then according to the invoicing application number, check whether there is an accounts receivable record in the accounts receivable record table with an accounts receivable balance (accounts receivable balance = accounts receivable amount - write-off amount - amount of returned vouchers) greater than 0. If it exists, use the accounts receivable record with an accounts receivable balance greater than 0 as the result of this match; if not, proceed to the next priority for processing. Among them, the business and finance voucher table is the background data table for the operation of the business and finance integration system itself. Since invoicing application belongs to the main function of the business and finance integration system, there must be an invoicing application number in its background voucher table. However, if no invoicing application number is matched, it is normal and will proceed to the next priority for processing.
[0095] Second priority: If no receivable record is matched in the first priority, use the customer number (i.e., unit number) in the corresponding unit field of the written-off voucher, combined with the project number field of the written-off voucher, to screen all accounts receivable records in the accounts receivable record table whose customer number and project number match the written-off voucher. Then, among these matching accounts receivable records, check whether there is an accounts receivable record with an accounts receivable balance equal to the write-off amount. If it exists, use the accounts receivable record with an accounts receivable balance equal to the write-off amount as the result of this match; if not, proceed to the next priority for processing.
[0096] Third priority: If no receivable record is matched in the second priority, use the counterparty field of the written-off voucher as the customer number to screen all the accounts receivable records in the accounts receivable record table whose customer numbers match the written-off voucher. Among these matching accounts receivable records, determine whether there is an accounts receivable record with the same receivable balance and write-off amount. If so, use the accounts receivable record with the same receivable balance and write-off amount as the result of this match; if not, proceed to the next priority for processing. And, if there are multiple accounts receivable records with the same receivable balance and write-off amount, sort them by the aging date and match all the accounts receivable records that meet the conditions of the third priority for write-off.
[0097] Fourth priority: If no receivable record is matched in the third priority, but according to the customer number of the written-off voucher, one or more accounts receivable records are found under the same customer number, then determine the accounts receivable records that match the customer number as the result of this match, sort them by the aging date, and allocate the write-off amount. The write-off amount allocated to each accounts receivable record does not exceed the remaining accounts receivable amount of that record.
[0098] S105: Modify the write-off amount in the accounts receivable record according to the amount in the written-off voucher.
[0099] In the embodiment of the present application, the step of modifying the write-off amount in the accounts receivable record according to the amount in the written-off voucher includes:
[0100] Add the original write-off amount in the accounts receivable record to the amount in the written-off voucher to obtain the write-off amount, and modify the original write-off amount to the write-off amount.
[0101] In the embodiment of the present application, after matching the corresponding accounts receivable record through the preset matching priority, it is necessary to modify the value of the write-off amount field in the accounts receivable record to achieve the purpose of write-off. Add the original write-off amount in the accounts receivable record to the amount in the written-off voucher to obtain the write-off amount, and then replace the original write-off amount with the write-off amount.
[0102] For example, the accounts receivable amount in the accounts receivable record is 1,005,700.60, the original write-off amount is 1,000,000.00, and the amount in the written-off voucher is 5,700.60. During this write-off process, add the amount 5,700.60 in the written-off voucher to the original write-off amount 1,000,000.00 to obtain the write-off amount 1,005,700.60, and then modify the original write-off amount 1,000,000.00 to the write-off amount 1,005,700.60. At this time, the accounts receivable record shows that the accounts receivable amount is 1,005,700.60 and the original write-off amount is 1,005,700.60, that is, the accounts receivable balance is 0, and the write-off is completed.
[0103] S106: Add a write-off relationship table based on the collection record and the modified accounts receivable record.
[0104] In the embodiment of the present application, after completing the write-off by modifying the write-off amount in the accounts receivable record, a write-off relationship table can be added according to the collection number in the collection record, the receivable ID, and the write-off amount in the modified accounts receivable record. As shown in Table 5 below, it is an example of the write-off relationship table, and the table contains core fields such as write-off ID, collection number, receivable ID, and write-off amount. Among them, the write-off ID is the serial number of the write-off relationship table.
[0105] Table 5 Main core fields of the write-off relationship table in the business-finance integration system
[0106] Field Name Field Code Sample Data Remarks Write-off ID HXID HX202209200123 Serial Number Collection Number HKBH HK1100123 Receivable ID YSID YSZK100123 Write-off Amount HXJE 1005700.60
[0107] In the embodiment of the present application, after adding the write-off relationship table based on the collection record and the modified accounts receivable record, it further includes:
[0108] Judge whether the accounts receivable balance of the accounts receivable record is zero;
[0109] If so, it is determined that all the accounts receivable balances of the accounts receivable record have been written off, and the corresponding accounting voucher is marked as a cleared accounting voucher.
[0110] In the embodiment of the present application, it is confirmed whether the accounts receivable record is completely written off by judging whether the accounts receivable balance of the accounts receivable record is zero. If it is completely written off, the clearing flag of the accounting voucher corresponding to the accounts receivable record is marked as "cleared".
[0111] In the embodiment of the present application, after completing the above steps S101 to S105, the "written-off processed" fields of the write-off voucher and the written-off voucher can also be marked with corresponding processing identifiers according to the write-off result, where Null is the initial default, 1 = processed, and 2 = failed. If the write-off result is failed, all operations in steps S101 to S105 can be rolled back in the database, and steps S101 to S105 are executed in reverse, which is equivalent to restoring the data to a state where it has never been executed, and can ensure the transactionality of the write-off process.
[0112] In the embodiment of the present application, the overall process of automatic write-off is as Figure 3As shown, after obtaining at least a pair of verification vouchers and vouchers to be verified and starting the verification process, first calculate the verification type according to the subject number of the verification voucher, determine the corresponding repayment method, write it into the corresponding repayment voucher table (i.e., repayment record), determine the corresponding accounts receivable record based on the preset matching priority, modify the accounts receivable record table, and then write the above verification relationship into the verification relationship table according to the repayment record and the modified accounts receivable record. After completing the verification, modify the clearing flag of the accounting voucher, and mark the "verified and processed" fields of the verification voucher and the voucher to be verified with the corresponding processing identifier according to the verification result, ending the entire verification process.
[0113] In a specific embodiment, incremental data is obtained based on a preset interface and updated to the accounting voucher information and verification relationship data table. The incremental data is a pair of verification vouchers and vouchers to be verified as shown in Table 6 below:
[0114] Table 6 Example of Accounting Voucher Information and Verification Relationship Data Table
[0115] Field Name Field Code Sample Data 1 Sample Data 2 Accounting Period PZRQ 202208 202208 Write-off Date HXRQ 20220820 20220820 Write-off Number HXBH 34689 34689 Voucher Date DATE 20220820 20220820 Voucher Number PZBH HXPZ01806 JZPZ01805 Responsibility Center ZRCODE 20912264 20912264 Subject Number KMBH 11220300 11220300 Bill Number YSBH 10190842 10190842 Project Number XMBH BJSJ2020012 BJSJ2020012 Business Partner DWBH 1176792 1176792 Write-off Flag HXHC 0 1 Accounting Direction JZFX D J Amount HXJE 5700.60 5700.60 Write-off Processed CHECKED Null -> 1 Null -> 1
[0116] As shown in Table 6 above, Example Data 1 and Example Data 2 are a pair of verification vouchers and vouchers to be verified with the same verification number, generated for one verification. Among them, Example Data 1 with a verification flag of 0 is the verification voucher, and Example Data 2 with a verification flag of 1 is the voucher to be verified (aging voucher).
[0117] Confirm the receipt item and the corresponding repayment method according to the subject number 11220300 in the verification voucher that has not been processed, and write a repayment record. Then, based on the preset matching priority, search for the corresponding accounts receivable record according to the voucher to be verified. When searching for the accounts receivable record, perform matching step by step according to the preset matching priority. The example data shows matching through the second priority, that is, using the counterpart unit field of the voucher to be verified as the customer number, combined with the project number field of the voucher to be verified, screening all accounts receivable records in the accounts receivable record table whose customer numbers and project numbers match the voucher to be verified, and writing off in the order of the aging date from the earliest to the latest. According to the counterpart unit field of the voucher to be verified, the customer number is "1176792", and the following two eligible accounts receivable records as shown in Table 7 are screened out:
[0118] Table 7 Example of Accounts Receivable Record Table
[0119] Field Name Field Code Sample Data 1 Sample Data 2 Receivable ID YSID YSZK100123 YSZK100124 Invoice Number FPBH 20220820 20220820 Project Number XMBH BJSJ2020012 BJSJ2020012 Voucher Number PZBH NULL NULL Account Age Date ZLRQ 20220815 20210820 Customer Number DWBH 1176792 1176792 Accounts Receivable Amount YSJE 5200.00 500.60 Returned Check Amount TPJE 0 0 Write-off Amount HXJE 0->5200.00 0->500.60
[0120] After allocating the write-off amount of 5,700.60 according to the accounts receivable amounts of 5,200.00 and 500.60 in two example data, perform the write-off. Modify the value of the "write-off amount" field in the example 1 data in the accounts receivable record table from 0 to 5,200.00, and modify the value of the "write-off amount" field in the example 2 data from 0 to 500.60 to complete the write-off. After the write-off is completed, modify the value of the "write-off processed" field in the accounting voucher information and the write-off relationship data table from Null to 1, indicating that the write-off has been processed. After the write-off is completed, the updated collection record is shown in Table 8 below:
[0121] Table 8 Example of the collection statement in the business-finance integration system
[0122] Field Name Field Code Sample Data Collection Number HKBH HK1100123 Company GSDM H900 Project Number XMBH BJSJ2020012 Customer Number DWBH 1176792 Voucher Number PZBH JZPZ01806 Receivable Date HKRQ 20220820 Receivable Method ZLBH 1 Receivable Amount JE 5700.6
[0123] After the write-off is completed, add a write-off relationship table according to the collection record and the modified accounts receivable record, as shown in Table 9 below:
[0124] Table 9 Example of the write-off relationship statement in the business-finance integration system
[0125] Field Name Field Code Sample Data 1 Sample Data 2 Write-off ID HXID HX202208200123 HX202208200123 Receivable Number HKBH HK1100123 HK1100123 Receivable ID YSID YSZK100123 YSZK100124 Write-off Amount HXJE 5200 500.6
[0126] The method for automatically writing off accounts receivable provided by the embodiment of the present application obtains at least a pair of write-off vouchers and vouchers to be written off through a preset interface, determines the collection item and collection method corresponding to the account number in the write-off voucher according to the preset mapping relationship between the preset account number and the collection item, and obtains the corresponding collection record based on the write-off voucher and the voucher to be written off. Then, according to the voucher to be written off, the corresponding accounts receivable record is determined based on the preset matching priority. Next, according to the amount in the write-off voucher, the write-off amount in the accounts receivable record is modified. Finally, a write-off relationship table is added based on the collection record and the modified accounts receivable record. This method reduces labor costs, enabling the accountant to perform only one sorting and write-off operation in the traditional accounting system during collection settlement, while the business-finance integration system will automatically perform write-off matching of the accounts receivable balance through this method to ensure accurate accounts, avoiding the inefficient operation of multiple write-off operations in the traditional accounting system and the business-finance integration system, and being able to better solve the problem of data inconsistency between multiple systems.
[0127] Embodiment 2
[0128] Based on the same inventive concept, the embodiment of the present application also provides an apparatus for automatically writing off accounts receivable. Referring to Figure 4 as shown, the apparatus includes:
[0129] An acquisition module 101, configured to acquire incremental data based on a preset interface, and update the incremental data to the financial voucher information and the write-off relationship data table; the incremental data includes at least a pair of write-off vouchers and vouchers to be written off;
[0130] The first determination module 102 is configured to determine the receipt item corresponding to the account number in the write-off voucher according to a preset mapping relationship between the preset account number and the receipt item.
[0131] The second determination module 103 is configured to determine the repayment method according to the receipt item, and obtain a corresponding repayment record based on the repayment method, the write-off voucher, and the voucher to be written off.
[0132] The third determination module 104 is configured to determine a corresponding accounts receivable record according to the voucher to be written off based on a preset matching priority.
[0133] The write-off module 105 is configured to modify the written-off amount in the accounts receivable record according to the amount in the write-off voucher.
[0134] The recording module 106 is configured to add a write-off relationship table based on the repayment record and the modified accounts receivable record.
[0135] Embodiment III
[0136] Based on the same inventive concept, an embodiment of the present application further provides a computer-readable storage medium, on which a computer program is stored, and when the program is executed by a processor, the automatic accounts receivable write-off method described in Embodiment I above is implemented.
[0137] Embodiment IV
[0138] Based on the same inventive concept, an embodiment of the present application further provides a computer device, including a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the computer program, the automatic accounts receivable write-off method described in Embodiment I above is implemented.
[0139] Embodiment V
[0140] Based on the same inventive concept, an embodiment of the present application further provides a computer program product including instructions. When the computer program product runs on a computer device, the computer device is caused to execute the automatic accounts receivable write-off method described in Embodiment I above.
[0141] Embodiment VI
[0142] Based on the same inventive concept, an embodiment of the present application further provides a chip, which includes a processor and a communication interface. The communication interface is coupled to the processor, and the processor is configured to run a computer program or instructions to implement the automatic accounts receivable write-off method described in Embodiment I above.
[0143] Those skilled in the art should understand that the embodiments of the present application can be provided as a method, a system, or a computer program product. Therefore, the present application can take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware aspects. Moreover, the present application can take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage and optical storage, etc.) that contain computer-usable program code.
[0144] The present application is described with reference to the flowcharts and / or block diagrams of methods, apparatuses (systems), and computer program products according to the embodiments of the present application. It should be understood that each flow and / or block in the flowchart and / or block diagram, as well as the combination of flows and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to the processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing devices to generate a machine, such that the instructions executed by the processor of the computer or other programmable data processing devices generate means for implementing the functions specified in Figure 1 one flow or multiple flows and / or blocks Figure 1 one block or multiple blocks.
[0145] These computer program instructions can also be stored in a computer-readable memory that can direct a computer or other programmable data processing device to work in a specific manner, such that the instructions stored in the computer-readable memory generate a manufactured article including instruction means that implement the functions specified in Figure 1 one flow or multiple flows and / or blocks Figure 1 one block or multiple blocks.
[0146] These computer program instructions can also be loaded onto a computer or other programmable data processing device, such that a series of operation steps are executed on the computer or other programmable device to generate a computer-implemented process, so that the instructions executed on the computer or other programmable device provide steps for implementing the functions specified in Figure 1 one flow or multiple flows and / or blocks Figure 1 one block or multiple blocks.
[0147] Obviously, those skilled in the art can make various modifications and variations to the present application without departing from the spirit and scope of the present application. Thus, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalent technologies, the present application is also intended to include these modifications and variations.
Claims
1. An automatic accounts receivable write-off method, characterized in that, Including: Based on a preset interface, obtain incremental data and update the incremental data to the financial voucher information and the write-off relationship data table; The incremental data includes at least a pair of write-off vouchers and vouchers to be written off; According to the preset mapping relationship between the preset subject number and the receipt item, determine the receipt item corresponding to the subject number in the write-off voucher; According to the receipt item, determine the repayment method, and based on the repayment method, the write-off voucher and the voucher to be written off, obtain the corresponding repayment record; According to the voucher to be written off, based on the preset matching priority, determine the corresponding accounts receivable record; According to the amount in the write-off voucher, modify the written-off amount in the accounts receivable record; Based on the repayment record and the modified accounts receivable record, add a write-off relationship table.
2. The method according to claim 1, characterized in that, The determining the corresponding accounts receivable record according to the voucher to be written off based on the preset matching priority includes: According to the voucher number in the voucher to be written off, determine the corresponding invoicing application number; According to the invoicing application number, determine whether there is an accounts receivable record with an accounts receivable balance greater than zero; If so, obtain the corresponding accounts receivable record; If not, according to the customer number and project number of the voucher to be written off, determine whether there is an accounts receivable record with an accounts receivable balance equal to the written-off amount among all accounts receivable records with matching customer numbers and project numbers; If so, obtain the corresponding accounts receivable record; If not, according to the customer number of the voucher to be written off, determine whether there is an accounts receivable record with an accounts receivable balance equal to the written-off amount among all accounts receivable records with matching customer numbers; If so, obtain the corresponding accounts receivable record; If not, according to the customer number of the voucher to be written off, determine the accounts receivable record with a matching customer number.
3. The method according to claim 2, characterized in that, The determining the accounts receivable record with a matching customer number according to the customer number of the voucher to be written off further includes: If there are multiple accounts receivable records with a matching customer number, sort them according to the aging date and allocate the written-off amount to the multiple accounts receivable records.
4. The method according to claim 1, characterized in that, The modifying the written-off amount in the accounts receivable record according to the amount in the write-off voucher includes: Add the original written-off amount in the accounts receivable record to the amount in the write-off voucher to obtain the written-off amount, and modify the original written-off amount to the written-off amount.
5. The method according to claim 1, characterized in that, The obtaining incremental data and updating it to the financial voucher information and the write-off relationship data table based on the preset interface includes: According to a preset time period, through preset input parameters, based on the preset interface, obtain incremental data and update it to the financial voucher information and the write-off relationship data table; the preset input parameters include the account set code, start time, and end time.
6. The method according to claim 1, characterized in that, After adding the write-off relationship table based on the repayment record and the modified accounts receivable record, it further includes: Determine whether the accounts receivable balance of the accounts receivable record is zero; If so, determine that the entire accounts receivable balance of the accounts receivable record has been written off, and mark the corresponding accounting voucher as a cleared accounting voucher.
7. An automatic accounts receivable write-off device, characterized in that, Including: An acquisition module, configured to acquire incremental data based on a preset interface and update the incremental data to a financial voucher information and write-off relationship data table; the incremental data includes at least a pair of write-off vouchers and vouchers to be written off. A first determination module, configured to determine a receipt item corresponding to the account number in the write-off voucher according to a preset mapping relationship between a preset account number and a receipt item. A second determination module, configured to determine a repayment method according to the receipt item, and obtain a corresponding repayment record based on the repayment method, the write-off voucher and the voucher to be written off. A third determination module, configured to determine a corresponding accounts receivable record based on the voucher to be written off according to a preset matching priority. A write-off module, configured to modify the written-off amount in the accounts receivable record according to the amount in the write-off voucher. A recording module, configured to add a write-off relationship table based on the repayment record and the modified accounts receivable record.
8. A computer-readable storage medium stores a computer program. When the program is executed by a processor, the processor is caused to execute the method for automatically writing off accounts receivable according to any one of claims 1-6.
9. A computer device, characterized in that It includes a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the computer program, it implements the method for automatically writing off accounts receivable according to any one of claims 1-6.
10. A computer program product containing instructions, when the computer program product runs on a computer device, causes the computer device to execute the method for automatically writing off accounts receivable according to any one of claims 1-6.
11. A chip, the chip includes a processor and a communication interface, the communication interface is coupled to the processor, and the processor is used to run a computer program or instructions to implement the method for automatically writing off accounts receivable according to any one of claims 1-6.