CN115222497B - Financial data verification processing method and system - Google Patents

Financial data verification processing method and system Download PDF

Info

Publication number
CN115222497B
CN115222497B CN202210823722.1A CN202210823722A CN115222497B CN 115222497 B CN115222497 B CN 115222497B CN 202210823722 A CN202210823722 A CN 202210823722A CN 115222497 B CN115222497 B CN 115222497B
Authority
CN
China
Prior art keywords
commodity
financial data
commodities
warehouse
bill
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202210823722.1A
Other languages
Chinese (zh)
Other versions
CN115222497A (en
Inventor
马科
刘孟君
骆海东
颜嘉梁
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Jiaxing Jushuitan Intelligent Technology Co ltd
Shanghai Jushuitan Network Technology Co ltd
Shanghai Juhuotong E Commerce Co ltd
Original Assignee
Jiaxing Jushuitan Intelligent Technology Co ltd
Shanghai Jushuitan Network Technology Co ltd
Shanghai Juhuotong E Commerce Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Jiaxing Jushuitan Intelligent Technology Co ltd, Shanghai Jushuitan Network Technology Co ltd, Shanghai Juhuotong E Commerce Co ltd filed Critical Jiaxing Jushuitan Intelligent Technology Co ltd
Priority to CN202210823722.1A priority Critical patent/CN115222497B/en
Publication of CN115222497A publication Critical patent/CN115222497A/en
Application granted granted Critical
Publication of CN115222497B publication Critical patent/CN115222497B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12—Accounting
    • G06Q40/125—Finance or payroll
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • G06Q10/103—Workflow collaboration or project management
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00—Commerce
    • G06Q30/06—Buying, selling or leasing transactions
    • G06Q30/0601—Electronic shopping [e-shopping]
    • G06Q30/0633—Lists, e.g. purchase orders, compilation or processing
    • G06Q30/0635—Processing of requisition or of purchase orders

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Strategic Management (AREA)
  • Finance (AREA)
  • Accounting & Taxation (AREA)
  • Economics (AREA)
  • General Business, Economics & Management (AREA)
  • Human Resources & Organizations (AREA)
  • Marketing (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Development Economics (AREA)
  • Tourism & Hospitality (AREA)
  • Quality & Reliability (AREA)
  • Operations Research (AREA)
  • Data Mining & Analysis (AREA)
  • Technology Law (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention relates to a financial data verification processing method and a financial data verification processing system, which relate to the technical field of data processing, wherein the method comprises the following steps: calculating the value to be received by a merchant according to the sales amount of the commodity in the order to be processed, the commodity input-output bill corresponding to the commodity in the order to be processed and the refund value in the after-sales bill; acquiring the balance record information of the order to be processed from a merchant database, and calculating the actual collection value of the merchant according to the balance record information; judging whether the business receivable value is consistent with the business real receivable value or not to obtain a first result; judging whether the number and the number of the commodities in the after-sale bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill or not, and obtaining a second result; determining a financial data state according to the first result and the second result; and outputting a financial data abnormality reminder when the financial data state is financial data abnormality. The invention combines the information of the commodity in and out of the warehouse and the order information to realize the accurate verification and confirmation of the financial data in and out of the merchant.

Description

Financial data verification processing method and system
Technical Field
The invention relates to the technical field of data processing, in particular to a financial data verification processing method and system.
Background
With the rapid development of electronic commerce and express business, more and more people shop on the internet, and a plurality of network merchants and network shops are induced. Currently, for a certain network shop, sales conditions in a period of time are generally determined directly through sales in-out warehouse data (sales warehouse entry bill and sales warehouse out bill) and platform bill. The sales amount in the sales warehouse receipt and the sales withdrawal warehouse receipt can be obtained or distributed only according to the amount in the order, and may not be consistent with the final actual account amount, especially the common operations such as a plurality of commodity details, the withdrawal and exchange of commodities, the turnover of express delivery, and the split and combination before delivery are involved, and it is difficult to ensure that the receivable sales amount of the commodities in the order is consistent with the final account amount. Particularly in the case of a large single quantity, there must be a difference between actual income and applied money, and this difference can only be rolled down. If the money difference is placed regardless, the resulting difference and management hole may be enormous over time.
At present, the verification of the amount of refund and collection by merchants is realized by only manually checking the amount information and the bill information in an order, and the problems of low efficiency and easy error exist.
Disclosure of Invention
The invention aims to provide a financial data verification processing method and system, which combine the information of the in-out warehouse and the order information of commodities to realize the accurate verification of the in-out financial data of merchants.
In order to achieve the above object, the present invention provides the following solutions:
a financial data verification processing method, comprising:
acquiring an order to be processed and an after-sales order corresponding to the order to be processed; the commodity sales amount is recorded in the order to be processed; the after-sale bill is recorded with refund numerical value and refund commodity information; the goods returned information comprises the serial numbers and the quantity of goods;
acquiring commodity input and output documents corresponding to commodities in the order to be processed; the commodity warehouse-in and warehouse-out bill comprises a commodity warehouse-out bill and a commodity warehouse-out bill; the commodity delivery warehouse is characterized in that the commodity delivery warehouse list is recorded with the numbers and the quantity of commodities delivered out of the warehouse; the number and the quantity of the commodities sent to the warehouse are recorded in the commodity warehouse-out bill;
calculating a merchant receiving value according to the sales amount of the commodity in the order to be processed, the commodity input-output bill corresponding to the commodity in the order to be processed and the refund value in the after-sales bill;
acquiring the balance record information of the order to be processed from a merchant database, and calculating a merchant actual collection value according to the balance record information; the merchant database is a database storing the amount of the balance records of the merchant;
judging whether the business receivable value is consistent with the business actual receivable value or not, and obtaining a first result; the first result includes the merchant account number being consistent with the merchant actual account number and the merchant account number not being consistent with the merchant actual account number;
judging whether the number and the number of the commodities in the after-sales bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill or not, and obtaining a second result; the second result comprises that the number and the number of the commodities in the after-sales bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill, and the number of the commodities in the after-sales bill are inconsistent with the number and the number of the commodities in the commodity warehouse-out bill;
determining a financial data state based on the first result and the second result; the financial data status includes financial data anomalies and financial data normals;
and outputting a financial data abnormality reminder when the financial data state is financial data abnormality.
Optionally, the determining the financial data state according to the first result and the second result specifically includes:
when the first result is that the value of the business account receivable is consistent with the value of the business account receivable, and the second result is that the number and the number of the commodities in the after-sales bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill, outputting the financial data state to be that the financial data is normal;
and outputting a financial data state as abnormal financial data when the first result is that the business receivable value is inconsistent with the business actual receivable value or the second result is that the number and the number of the commodities in the after-sales bill are inconsistent with the number and the number of the commodities in the commodity warehouse-out bill.
Optionally, calculating the receivable value of the merchant according to the sales amount of the commodity in the order to be processed, the commodity input-output bill corresponding to the commodity in the order to be processed and the refund value in the after-sales bill, which specifically includes:
determining the number and the number of the commodities actually discharged from the warehouse according to the number and the number of the commodities in the commodity discharging warehouse and the number of the commodities in the commodity discharging warehouse;
calculating to obtain the commodity sales amount total of the order to be processed according to the number and the number of the commodities actually delivered out of the warehouse and the sales amount of the commodities in the order to be processed;
and calculating the value to be received by the merchant according to the commodity sales amount total and the refund value in the after-sales bill.
Optionally, the financial data verification processing method further includes:
and when the financial data state is that the financial data is normal, storing the account receivable value of the merchant, the commodity sales amount total and the refund value in the after-sales bill into the entry of the statistical table correspondingly.
In order to achieve the above purpose, the present invention also provides the following technical solutions:
a financial data verification processing system comprising:
the order data acquisition module is used for acquiring an order to be processed and an after-sales order corresponding to the order to be processed; the commodity sales amount is recorded in the order to be processed; the after-sale bill is recorded with refund numerical value and refund commodity information; the goods returned information comprises the serial numbers and the quantity of goods;
the warehouse data acquisition module is used for acquiring commodity warehouse-in and warehouse-out receipts corresponding to commodities in the order to be processed; the commodity warehouse-in and warehouse-out bill comprises a commodity warehouse-out bill and a commodity warehouse-out bill; the commodity delivery warehouse is characterized in that the commodity delivery warehouse list is recorded with the numbers and the quantity of commodities delivered out of the warehouse; the number and the quantity of the commodities sent to the warehouse are recorded in the commodity warehouse-out bill;
the receivable value calculation module is used for calculating a merchant receivable value according to the sales amount of the commodity in the order to be processed, the commodity input-output bill corresponding to the commodity in the order to be processed and the refund value in the after-sales bill;
the real-time collection value calculation module is used for acquiring the balance record information of the order to be processed from a merchant database and calculating the real-time collection value of the merchant according to the balance record information; the merchant database is a database storing the amount of the balance records of the merchant;
the first verifying and verifying module is used for judging whether the business receivable value is consistent with the business actual receivable value or not to obtain a first result; the first result includes the merchant account number being consistent with the merchant actual account number and the merchant account number not being consistent with the merchant actual account number;
the second verification module is used for judging whether the number and the number of the commodities in the after-sales bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill or not, and obtaining a second result; the second result comprises that the number and the number of the commodities in the after-sales bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill, and the number of the commodities in the after-sales bill are inconsistent with the number and the number of the commodities in the commodity warehouse-out bill;
a financial data state determination module for:
determining a financial data state based on the first result and the second result; the financial data status includes financial data anomalies and financial data normals;
and outputting a financial data abnormality reminder when the financial data state is financial data abnormality.
Optionally, the financial data state determining module specifically includes:
the first result submodule is used for outputting a financial data state as normal when the first result is that the value of the business account receivable is consistent with the value of the business account receivable, and the second result is that the number and the number of the commodities in the after-sales bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill;
and the second result submodule is used for outputting a financial data state as abnormal financial data when the first result is that the business receivable value is inconsistent with the business actual receivable value or the second result is that the number and the number of the commodities in the after-sale bill are inconsistent with the number and the number of the commodities in the commodity warehouse-out bill.
Optionally, the module for calculating the receivable value specifically includes:
the actual delivery commodity determining submodule is used for determining the number and the number of the commodities actually delivered according to the number and the number of the commodities in the commodity delivery bill and the number of the commodities in the commodity delivery bill;
the commodity sales total submodule is used for calculating and obtaining commodity sales total of the order to be processed according to the number and the number of the commodities actually discharged from the warehouse and the sales amount of the commodities in the order to be processed;
and the merchant accounts receivable sub-module is used for calculating the merchant accounts receivable value according to the commodity sales amount total and the refund value in the after-sales order.
Optionally, the financial data verification processing system further comprises:
and the statistics storage module is connected with the financial data state determining module and is used for respectively and correspondingly storing the value which the merchant should receive, the commodity sales amount total and the refund value in the after-sales bill into the entry of the statistics table when the financial data state is that the financial data is normal.
Optionally, the actual receipt value calculation module and the order data acquisition module are both in communication with the merchant database through a data interface.
According to the specific embodiment provided by the invention, the invention discloses the following technical effects:
the invention provides a financial data verification processing method and a financial data verification processing system, which are used for respectively determining a merchant receivable value and a merchant actual receivable value corresponding to a to-be-processed order by combining the to-be-processed order, an after-sales order corresponding to the to-be-processed order and a commodity warehouse-in and warehouse-out bill corresponding to commodities in the to-be-processed order, so as to further perform two judgments: judging whether the value of the commercial company receivable is consistent with the value of the commercial company actual receivable, judging the number and the quantity of the commodity in the after-sales bill, and judging whether the value of the commercial company receivable is consistent with the number and the quantity of the commodity in the commodity warehouse-out bill; and comprehensively determining the financial data state according to the two judging results, so that the to-be-processed order is associated with the commodity in-out-in-warehouse bill in the warehouse, the closed-loop verification of the in-out-warehouse commodity and the real-time receipt is achieved, and the financial data of the merchant is accurately verified.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions of the prior art, the drawings that are needed in the embodiments will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a diagram of a financial data verification process of the present invention;
FIG. 2 is a diagram of a financial data verification processing system of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The invention will be further described in detail with reference to the drawings and detailed description below in order to make the objects, features and advantages of the invention more comprehensible.
Example 1
As shown in fig. 1, the present embodiment provides a financial data verification processing method, including:
step 100, acquiring an order to be processed and an after-sales order corresponding to the order to be processed; the commodity sales amount is recorded in the order to be processed; the after-sale bill is recorded with refund numerical value and refund commodity information; the return commodity information includes the number and quantity of commodities. Specifically, the to-be-processed order and the corresponding after-sales order are obtained from a database of the merchant background. In addition, the order to be processed and the after-sales order corresponding to the order to be processed can be acquired through a manual introduction mode.
Step 200, acquiring commodity input and output documents corresponding to commodities in the order to be processed; the commodity warehouse-in and warehouse-out bill comprises a commodity warehouse-out bill and a commodity warehouse-out bill; the commodity delivery warehouse is characterized in that the commodity delivery warehouse list is recorded with the numbers and the quantity of commodities delivered out of the warehouse; the commodity warehouse-out list is recorded with the numbers and the quantity of commodities sent to the warehouse. Specifically, commodity warehouse-in and warehouse-out receipts are obtained from an ERP enterprise resource planning system, and commodity numbers are recorded in commodity warehouse-out and warehouse-out receipts so as to be convenient for corresponding selection with an order to be processed and an after-sales receipt.
And 300, calculating a merchant receiving value according to the sales amount of the commodity in the order to be processed, the commodity input-output bill corresponding to the commodity in the order to be processed and the refund value in the after-sales bill.
Specifically, step 300 includes:
1) And determining the number and the number of the commodities actually discharged from the warehouse according to the number and the number of the commodities in the commodity discharging warehouse and the number of the commodities in the commodity discharging warehouse. Generally, the number of the commodities with the same number and the corresponding number of the commodities are determined from the commodity warehouse-out bill according to the number of the commodities in the commodity warehouse-out bill, and then the number of the commodities with the same number in the commodity warehouse-out bill is subtracted from the number of the commodities in the commodity warehouse-out bill to calculate.
2) And calculating to obtain the commodity sales amount total of the order to be processed according to the number and the number of the commodities actually delivered out of the warehouse and the sales amount of the commodities in the order to be processed. Specifically, calculation is performed according to a preset calculation rule in ERP to obtain the total commodity sales amount.
3) And calculating the value to be received by the merchant according to the commodity sales amount total and the refund value in the after-sales bill. Specifically, commodity deposit value=commodity sales amount total+refund value in after-sales order.
Step 400, acquiring the balance record information of the order to be processed from a merchant database, and calculating a merchant actual receipt value according to the balance record information; the merchant database is a database storing the amount of the balance records of the merchant. In a specific application, the bill of the merchant can be directly obtained, and the actual collection value of the merchant is calculated through the recorded expense in the bill; such as a payment treasury daily bill, a bank card monthly bill, etc. In addition, in order to more comprehensively cope with various conditions, default values are also arranged inside the system so as to directly determine the actual collection value of the merchant.
And 500, judging whether the business receivable value is consistent with the business actual receivable value or not to obtain a first result. The first result includes the merchant account number being consistent with the merchant actual account number and the merchant account number not being consistent with the merchant actual account number.
Step 600, judging whether the number and the number of the commodities in the after-sales bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill, and obtaining a second result; and comparing the corresponding returned goods with the actual returned goods, thereby determining whether the buyer returned goods are received in the merchant warehouse. The second result comprises that the number and the number of the commodities in the after-sales bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill, and the number of the commodities in the after-sales bill are inconsistent with the number and the number of the commodities in the commodity warehouse-out bill.
Further, it may also be determined whether the number and number of the goods in the goods delivery warehouse are consistent with the number and number of the goods in the order to be processed, so as to determine whether to deliver according to the order when delivering, that is, whether the corresponding delivery goods are consistent with the actual delivery goods.
Through the comparison of the outgoing goods, the actual outgoing goods, the returning goods and the actual returning goods, the logistics process in the ring of the goods entering and exiting the warehouse can be more comprehensively known.
Step 700, determining a financial data state according to the first result and the second result; the financial data status includes financial data anomalies and financial data normals; and outputting a financial data abnormality reminder when the financial data state is financial data abnormality.
Specifically, step 700 includes:
1) When the first result is that the business receivable value is consistent with the business real receivable value, and the second result is that the number and the number of the commodities in the after-sale bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill, outputting a financial data state to be a financial data normal reminding, and storing the business receivable value.
Further, when the financial data state is that the financial data is normal, the merchant receivable value, the commodity sales amount total and the refund value in the after-sales order are respectively and correspondingly stored into the entry of the statistical table, and the specific data type details in the statistical table are settings which can be carried out by the merchant according to the needs and generally comprise the merchant actual receivable value, the merchant receivable value, the type and quantity of the sent commodities and the type and quantity of the commodities remained in the warehouse.
2) And outputting a financial data state as abnormal financial data when the first result is that the business receivable value is inconsistent with the business actual receivable value or the second result is that the number and the number of the commodities in the after-sales bill are inconsistent with the number and the number of the commodities in the commodity warehouse-out bill.
Further, the financial abnormal data are listed, and the reasons for generating the abnormal data are analyzed by merchants and can be divided into two main types, wherein one type is reasonable abnormal, namely the financial abnormal data are in a preset error range; one type is unreasonable anomalies, i.e., financial anomaly data is not within a preset error range.
And for the financial abnormal data corresponding to the reasonable abnormality, recovering the financial abnormal data corresponding to the reasonable abnormality into the financial normal data through a preset adjustment plug-in or an artificial setting adjustment list. For example, because the platform adds extra benefit, when the amount of the real receipt is 30, the corresponding real receipt is only 29, although the amount of the real receipt is inconsistent with the real receipt, the method is based on the additional benefit of the platform, belongs to reasonable exception, and can add one to the real receipt by adjusting a single piece so that the financial data is normal, and the follow-up financial data verification is not affected. The reasons for the reasonable abnormality may be calculation errors in the calculation process, other reasons and the like, and a worker can define a limited range of the reasonable error according to actual needs.
In addition, for financial abnormal data corresponding to large-batch reasonable errors, the plug-in components can be automatically and periodically processed, and manually processed by one key to generate adjustment receipts, and meanwhile, accurate basic accounting data capable of being used for making accounts are formed, including sales income, cost, accounts receivable, commodity sending, inventory commodity, asset value reduction loss and the like.
For the financial abnormal data corresponding to unreasonable abnormality, the whole financial flow needs to be carefully checked, if internal management is involved or the condition of resource loss caused by external reasons is involved, the front-end warehouse and the rear-end warehouse of the business can be searched and tracked, and the reasons for abnormality can be further remedied and adjusted.
Finally, whether manual adjustment is made daily or automatic periodic processing of the plug-in processing, the end result should be consistent. And commodity data (including data in after-market bill and data in commodity warehouse-in and warehouse-out bill) of the previous day are not modified again after the data are acquired and counted on the same day (such as a newly added return list), and newly added modified content falls into the data counting of the next day and is in the data counting and calculating process of the next day. Whether the plug-in is manually adjusted or automatically processed regularly, when the financial data corresponding to the legal abnormality is processed, the adjustment processing bill is reserved, so that the later verification is facilitated, and the subsequent investigation and verification are not influenced.
Example two
As shown in fig. 2, the present embodiment provides a financial data verification processing system, including:
an order data obtaining module 101, configured to obtain an order to be processed and an after-sales order corresponding to the order to be processed; the commodity sales amount is recorded in the order to be processed; the after-sale bill is recorded with refund numerical value and refund commodity information; the return commodity information includes the number and quantity of commodities.
A warehouse data acquisition module 201, configured to acquire a commodity warehouse-in and warehouse-out document corresponding to a commodity in the order to be processed; the commodity warehouse-in and warehouse-out bill comprises a commodity warehouse-out bill and a commodity warehouse-out bill; the commodity delivery warehouse is characterized in that the commodity delivery warehouse list is recorded with the numbers and the quantity of commodities delivered out of the warehouse; the commodity warehouse-out list is recorded with the numbers and the quantity of commodities sent to the warehouse.
And the receivable value calculation module 301 is configured to calculate a merchant receivable value according to a sales amount of the commodity in the order to be processed, a commodity input-output document corresponding to the commodity in the order to be processed, and a refund value in the after-sales order. The module 301 for calculating the receivable value specifically includes a module for determining the actual offloaded commodity, a module for selling and summing up the commodity, and a module for calculating the receivable value of the merchant.
The actual delivery commodity determining submodule is used for determining the number and the number of the commodities in the actual delivery according to the number and the number of the commodities in the commodity delivery bill and the number of the commodities in the commodity delivery bill; the commodity sales total sub-module is used for calculating and obtaining commodity sales total of the order to be processed according to the number and the number of the commodities actually discharged from the warehouse and the sales of the commodities in the order to be processed; and the merchant receiving calculation sub-module is used for calculating the merchant receiving value according to the commodity sales amount total and the refund value in the after-sales order.
The real receipt value calculation module 401 is configured to obtain the receipt record information of the to-be-processed order from a merchant database, and calculate a merchant real receipt value according to the receipt record information; the merchant database is a database storing the amount of the balance records of the merchant.
Further, the actual receipt value calculation module and the order data acquisition module are both communicated with the merchant database through a data interface, so that corresponding data are directly captured from the merchant database.
A first verification module 501, configured to determine whether the value of the business account receivable is consistent with the value of the business account receivable, so as to obtain a first result; the first result includes the merchant account number being consistent with the merchant actual account number and the merchant account number not being consistent with the merchant actual account number.
The second verification module 601 is configured to determine whether the number and the number of the commodities in the after-sales bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill, so as to obtain a second result; the second result comprises that the number and the number of the commodities in the after-sales bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill, and the number of the commodities in the after-sales bill are inconsistent with the number and the number of the commodities in the commodity warehouse-out bill;
a financial data state determination module 701 for:
determining a financial data state based on the first result and the second result; the financial data status includes financial data anomalies and financial data normals;
and outputting a financial data abnormality reminder when the financial data state is financial data abnormality.
Preferably, the financial data state determining module specifically includes:
the first result submodule is used for outputting a financial data state as normal when the first result is that the value of the business account receivable is consistent with the value of the business account receivable, and the second result is that the number and the number of the commodities in the after-sales bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill;
and the second result submodule is used for outputting a financial data state as abnormal financial data when the first result is that the business receivable value is inconsistent with the business actual receivable value or the second result is that the number and the number of the commodities in the after-sale bill are inconsistent with the number and the number of the commodities in the commodity warehouse-out bill.
The financial data verification processing system further comprises:
and the statistics storage module is connected with the financial data state determining module and is used for respectively and correspondingly storing the value which the merchant should receive, the commodity sales amount total and the refund value in the after-sales bill into the entry of the statistics table when the financial data state is that the financial data is normal.
Compared with the prior art, the invention has the following advantages:
(1) According to the invention, the order to be processed, the after-sales order and the commodity in-out-in-warehouse bill are associated to form a closed loop of financial data, and financial data verification is carried out by combining the data of the commodity in-out-warehouse, so that the accurate verification of the financial data is greatly realized, and certain data cannot be missed.
(2) For the situation that the goods are returned to the warehouse after the refund is firstly, particularly under the situation that the order quantity is large, the quantity of the returned and exchanged goods is also large, whether the returned and exchanged goods arrive at the warehouse or not, whether the corresponding goods money is consistent with the refund or not when arriving at the warehouse or not, and the like.
In the present specification, each embodiment is described in a progressive manner, and each embodiment is mainly described in a different point from other embodiments, and identical and similar parts between the embodiments are all enough to refer to each other.
The principles and embodiments of the present invention have been described herein with reference to specific examples, the description of which is intended only to assist in understanding the methods of the present invention and the core ideas thereof; also, it is within the scope of the present invention to be modified by those of ordinary skill in the art in light of the present teachings. In view of the foregoing, this description should not be construed as limiting the invention.

Claims (7)

1. A financial data verification processing method, characterized in that the financial data verification processing method comprises:
acquiring an order to be processed and an after-sales order corresponding to the order to be processed; the commodity sales amount is recorded in the order to be processed; the after-sale bill is recorded with refund numerical value and refund commodity information; the goods returned information comprises the serial numbers and the quantity of goods;
acquiring commodity input and output documents corresponding to commodities in the order to be processed; the commodity warehouse-in and warehouse-out bill comprises a commodity warehouse-out bill and a commodity warehouse-out bill; the commodity delivery warehouse is characterized in that the commodity delivery warehouse list is recorded with the numbers and the quantity of commodities delivered out of the warehouse; the number and the quantity of the commodities sent to the warehouse are recorded in the commodity warehouse-out bill;
calculating a merchant receiving value according to the sales amount of the commodity in the order to be processed, the commodity input-output bill corresponding to the commodity in the order to be processed and the refund value in the after-sales bill; the method specifically comprises the following steps:
determining the number and the number of the commodities actually discharged from the warehouse according to the number and the number of the commodities in the commodity discharging warehouse and the number of the commodities in the commodity discharging warehouse;
calculating to obtain the commodity sales amount total of the order to be processed according to the number and the number of the commodities actually delivered out of the warehouse and the sales amount of the commodities in the order to be processed;
calculating a business account number according to the commodity sales amount total and the refund number in the after-sales bill;
acquiring the balance record information of the order to be processed from a merchant database, and calculating a merchant actual collection value according to the balance record information; the merchant database is a database storing the amount of the balance records of the merchant;
judging whether the business receivable value is consistent with the business actual receivable value or not, and obtaining a first result; the first result includes the merchant account number being consistent with the merchant actual account number and the merchant account number not being consistent with the merchant actual account number;
judging whether the number and the number of the commodities in the after-sales bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill or not, and obtaining a second result; the second result comprises that the number and the number of the commodities in the after-sales bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill, and the number of the commodities in the after-sales bill are inconsistent with the number and the number of the commodities in the commodity warehouse-out bill;
determining a financial data state based on the first result and the second result; the financial data status includes financial data anomalies and financial data normals;
and outputting a financial data abnormality reminder when the financial data state is financial data abnormality.
2. The financial data verification processing method according to claim 1, wherein determining the financial data status according to the first result and the second result specifically comprises:
when the first result is that the value of the business account receivable is consistent with the value of the business account receivable, and the second result is that the number and the number of the commodities in the after-sales bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill, outputting the financial data state to be that the financial data is normal;
and outputting a financial data state as abnormal financial data when the first result is that the business receivable value is inconsistent with the business actual receivable value or the second result is that the number and the number of the commodities in the after-sales bill are inconsistent with the number and the number of the commodities in the commodity warehouse-out bill.
3. The financial data verification processing method according to claim 1, wherein the financial data verification processing method further comprises:
and when the financial data state is that the financial data is normal, storing the account receivable value of the merchant, the commodity sales amount total and the refund value in the after-sales bill into the entry of the statistical table correspondingly.
4. A financial data verification processing system, the financial data verification processing system comprising:
the order data acquisition module is used for acquiring an order to be processed and an after-sales order corresponding to the order to be processed; the commodity sales amount is recorded in the order to be processed; the after-sale bill is recorded with refund numerical value and refund commodity information; the goods returned information comprises the serial numbers and the quantity of goods;
the warehouse data acquisition module is used for acquiring commodity warehouse-in and warehouse-out receipts corresponding to commodities in the order to be processed; the commodity warehouse-in and warehouse-out bill comprises a commodity warehouse-out bill and a commodity warehouse-out bill; the commodity delivery warehouse is characterized in that the commodity delivery warehouse list is recorded with the numbers and the quantity of commodities delivered out of the warehouse; the number and the quantity of the commodities sent to the warehouse are recorded in the commodity warehouse-out bill;
the receivable value calculation module is used for calculating a merchant receivable value according to the sales amount of the commodity in the order to be processed, the commodity input-output bill corresponding to the commodity in the order to be processed and the refund value in the after-sales bill; the receivable value calculation module specifically comprises:
the actual delivery commodity determining submodule is used for determining the number and the number of the commodities actually delivered according to the number and the number of the commodities in the commodity delivery bill and the number of the commodities in the commodity delivery bill;
the commodity sales total submodule is used for calculating and obtaining commodity sales total of the order to be processed according to the number and the number of the commodities actually discharged from the warehouse and the sales amount of the commodities in the order to be processed;
the merchant accounts receivable sub-module is used for calculating merchant accounts receivable values according to the commodity sales amount total and refund values in the after-sales bill;
the real-time collection value calculation module is used for acquiring the balance record information of the order to be processed from a merchant database and calculating the real-time collection value of the merchant according to the balance record information; the merchant database is a database storing the amount of the balance records of the merchant;
the first verifying and verifying module is used for judging whether the business receivable value is consistent with the business actual receivable value or not to obtain a first result; the first result includes the merchant account number being consistent with the merchant actual account number and the merchant account number not being consistent with the merchant actual account number;
the second verification module is used for judging whether the number and the number of the commodities in the after-sales bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill or not, and obtaining a second result; the second result comprises that the number and the number of the commodities in the after-sales bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill, and the number of the commodities in the after-sales bill are inconsistent with the number and the number of the commodities in the commodity warehouse-out bill;
a financial data state determination module for:
determining a financial data state based on the first result and the second result; the financial data status includes financial data anomalies and financial data normals;
and outputting a financial data abnormality reminder when the financial data state is financial data abnormality.
5. The financial data verification processing system of claim 4, wherein the financial data status determination module comprises:
the first result submodule is used for outputting a financial data state as normal when the first result is that the value of the business account receivable is consistent with the value of the business account receivable, and the second result is that the number and the number of the commodities in the after-sales bill are consistent with the number and the number of the commodities in the commodity warehouse-out bill;
and the second result submodule is used for outputting a financial data state as abnormal financial data when the first result is that the business receivable value is inconsistent with the business actual receivable value or the second result is that the number and the number of the commodities in the after-sale bill are inconsistent with the number and the number of the commodities in the commodity warehouse-out bill.
6. The financial data verification processing system of claim 4, wherein the financial data verification processing system further comprises:
and the statistics storage module is connected with the financial data state determining module and is used for respectively and correspondingly storing the value which the merchant should receive, the commodity sales amount total and the refund value in the after-sales bill into the entry of the statistics table when the financial data state is that the financial data is normal.
7. The financial data verification processing system of claim 4, wherein the actual receipt value calculation module and the order data acquisition module each communicate with the merchant database via a data interface.
CN202210823722.1A 2022-07-13 2022-07-13 Financial data verification processing method and system Active CN115222497B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210823722.1A CN115222497B (en) 2022-07-13 2022-07-13 Financial data verification processing method and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210823722.1A CN115222497B (en) 2022-07-13 2022-07-13 Financial data verification processing method and system

Publications (2)

Publication Number Publication Date
CN115222497A CN115222497A (en) 2022-10-21
CN115222497B true CN115222497B (en) 2023-12-22

Family

ID=83612519

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210823722.1A Active CN115222497B (en) 2022-07-13 2022-07-13 Financial data verification processing method and system

Country Status (1)

Country Link
CN (1) CN115222497B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117422576B (en) * 2023-12-19 2024-03-08 青岛巨商汇网络科技有限公司 Business and finance integrated management system and method for commodity sales based on cloud computing

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2018018407A (en) * 2016-07-29 2018-02-01 株式会社丸井 Cancellation processing system
CN110910232A (en) * 2019-11-14 2020-03-24 上海新蕴力电子商务有限公司 Financial reconciliation system and method
CN111080196A (en) * 2019-11-28 2020-04-28 江苏苏宁物流有限公司 Method and system for processing warehouse arrival difference
CN111507798A (en) * 2020-04-15 2020-08-07 汇信软投(佛山)软件科技发展有限公司 Method, system and computer equipment for periodically checking and selling business transaction orders

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2018018407A (en) * 2016-07-29 2018-02-01 株式会社丸井 Cancellation processing system
CN110910232A (en) * 2019-11-14 2020-03-24 上海新蕴力电子商务有限公司 Financial reconciliation system and method
CN111080196A (en) * 2019-11-28 2020-04-28 江苏苏宁物流有限公司 Method and system for processing warehouse arrival difference
CN111507798A (en) * 2020-04-15 2020-08-07 汇信软投(佛山)软件科技发展有限公司 Method, system and computer equipment for periodically checking and selling business transaction orders

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
企业销售过程的内部控制风险分析及其设计;储成兵;;现代农业(第07期);全文 *
金蝶KIS专业版环境下的购销退货处理;游旭初;;财会月刊(第21期);全文 *

Also Published As

Publication number Publication date
CN115222497A (en) 2022-10-21

Similar Documents

Publication Publication Date Title
CN100587743C (en) Method for providing receipt for customer at point of sale and point-of-sale terminal
US8645264B2 (en) Apparatus and methods for verifying a credit applicant's income that enhance a credit applicant's experience
US20090089194A1 (en) Method and Apparatus for Performing Financial Transactions
US20090319421A1 (en) Method and Apparatus for Performing Financial Transactions
CN110458691B (en) Pre-loan risk monitoring method and device
CN115222497B (en) Financial data verification processing method and system
CN111539803A (en) Pledge financing monitoring method, system and computer readable storage medium
US20120317003A1 (en) Automated expense account report generator
TW202305685A (en) Business data evaluating system, method and computer program product
CN110910232B (en) Financial reconciliation system and method
CN112435019A (en) General settlement method, settlement server, system and storage medium for multi-service platform
CN114187084A (en) Method for identifying certificate subjects according to classification of electronic invoice tax
US8505811B2 (en) Anomalous billing event correlation engine
CN109544254B (en) Invoice information processing method, device and system
CN110245957A (en) The method for determining trade background authenticity and assessing enterprise trade background authenticity
CN110874745A (en) Bill return management system
CN117237133A (en) Financial tax data intelligent management method, system and readable storage medium
CN111028026A (en) Invoice matching method and system
CN111402020A (en) Automatic account checking system for enterprise account receivable/payment
US20080086416A1 (en) System and method for processing checks
CN113034150B (en) Refund method for unmanned retail terminal
US20180196843A1 (en) Error detection and correction for enterprise resource planning systems
CN114463100A (en) Order data processing method, device, equipment and storage medium
CN115205000B (en) Account checking method, account checking terminal and account checking system
CN112001705B (en) Accounting and settlement management system for equipment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
CB02 Change of applicant information

Address after: 201106 t4-6f, hongqiaohui, Lane 990, Shenchang Road, Minhang District, Shanghai

Applicant after: Shanghai juhuotong e-commerce Co.,Ltd.

Applicant after: SHANGHAI JUSHUITAN NETWORK TECHNOLOGY Co.,Ltd.

Applicant after: Jiaxing Jushuitan Intelligent Technology Co.,Ltd.

Address before: 201106 t4-6f, hongqiaohui, Lane 990, Shenchang Road, Minhang District, Shanghai

Applicant before: Shanghai juhuotong e-commerce Co.,Ltd.

Applicant before: SHANGHAI JUSHUITAN NETWORK TECHNOLOGY Co.,Ltd.

Applicant before: Jiaxing jushuitan e-commerce Co.,Ltd.

CB02 Change of applicant information
CB03 Change of inventor or designer information

Inventor after: Ma Ke

Inventor after: Liu Mengjun

Inventor after: Luo Haidong

Inventor after: Yan Jialiang

Inventor before: Ma Ke

Inventor before: Liu Mengjun

Inventor before: Luo Haidong

Inventor before: Yan Jialiang

CB03 Change of inventor or designer information
GR01 Patent grant
GR01 Patent grant