A transaction settlement system for agricultural product wholesale market and a settlement method thereof
Patent Information
- Application Number
- CN202611246631.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2026-08-17
- Publication Date
- 2026-09-25
AI Technical Summary
农产品市场行情波动频繁,货物入库时预设的贸易方式在结算时经常需要根据实际销售情况与供应商协商调整(如一般贸易转为受托代销或保底分成结算),但现有系统中贸易方式一旦在入库环节设定即被固化于整条业务链,无法在最终结算时进行转换匹配,导致系统功能与业务需求严重脱节
通过以柜号或批次号为唯一追踪标识并贯穿采购入库、销售出库、费用归集、损耗确认及代收收入记录的全业务流程,实现了同一批次货物全部关联数据的自动归集与统一核算,结合贸易结算单的数据引入、追溯调整与差异计算功能,支持结算入库金额、结算销售金额、结算费用金额、结算领料金额及结算代收收入金额分别相对于原始金额的灵活调整并自动生成调整差异,同时依托佣金计算单元从六种佣金计算方式中择一计算应付佣金、分成计算单元从两种分成计算方式中择一计算应付分成,进而实现九种结算方式(含三种基本结算及六种转换结算)的灵活选择与自动计算,有效解决了现有系统贸易方式与结算方式绑定固定、结算单价变动无法追溯调整、业务数据分散难以归集以及佣金和分成计算策略单一的技术问题;在此基础上,校验模块在销售出库时对贸易方式与柜号关联贸易方式进行匹配校验,避免结算成本与费用核算的错乱,费用支出单和代收收入单支持在同一单据中将多个费用或收入项目分别关联至不同柜号或批次号,且受托代销方式下进销存单据成本不参与成本核算而其他两种方式按正常贸易方式核算,进一步保障了成本核算的准确性与费用分摊的灵活性;最终通过会计凭证自动生成模块按预设会计科目自动生成对应会计凭证,实现了从业务数据归集、灵活结算到财务记账的财务一体化全流程自动化与可追溯,显著降低了农产品批发企业结算错误率与人工核算成本,为管理层提供了准确、及时的决策数据支持。
Smart Images

Figure CN122820331A_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the technical field of transaction settlement systems for agricultural wholesale markets, and in particular to a transaction settlement system and settlement method for agricultural wholesale markets. Background Technology
[0002] As a crucial hub connecting agricultural producers and consumers, agricultural wholesale markets are experiencing a continuous increase in transaction volume and complexity. Starting from the source of production or the import stage, agricultural products must pass through multiple trade and distribution links, including wholesalers, distributors, and retailers, before finally reaching the consumer. Within this complete distribution chain, each trade link primarily employs three trading methods based on different cooperation models, risk-sharing methods, and profit-sharing mechanisms: Firstly, general trade, where wholesalers or distributors buy goods from suppliers and then sell them themselves, bearing their own profits and losses; secondly, guaranteed minimum profit sharing, where both parties agree on a guaranteed minimum cost price, and after the sale is completed, the profit after deducting the agreed costs and expenses from the sales revenue is distributed according to an agreed ratio; thirdly, consignment sales, where wholesalers act only as agents to sell goods on behalf of suppliers, receiving a commission based on a certain percentage of the sales amount, and the supplier bears all income, costs, expenses, and price fluctuation risks during the sales process.
[0003] In practice, the above three trade methods often face the following technical problems and practical difficulties: I. Lack of flexible conversion mechanism for trade and settlement methods. Agricultural product market prices fluctuate frequently, and the trade methods preset when goods are put into storage often need to be adjusted with suppliers based on actual sales (such as general trade being converted to consignment sales or guaranteed profit sharing settlement) during settlement. However, in the existing system, once the trade method is set at the warehousing stage, it is fixed in the entire business chain and cannot be converted and matched at the final settlement, resulting in a serious disconnect between system functions and business needs.
[0004] Second, the settlement unit price cannot be adjusted retrospectively. Agricultural products have obvious non-standard characteristics. The two parties agree on the purchase unit price when the goods are put into storage, but due to changes in appearance, quality, freshness, etc. during the actual sales process, it is often necessary to retrospectively adjust the storage unit price or the sales unit price at the time of settlement. After the existing inventory management system stores the storage unit price as a fixed benchmark data, it is impossible to retrospectively adjust the historical unit price and synchronously update the associated inventory management data and cost accounting results.
[0005] Third, there is a lack of an automatic data aggregation mechanism for batch-based business data. Each batch of goods, from warehousing to completion of sales, involves various business transactions such as procurement, sales, warehousing costs, handling fees, refrigeration fees, quarantine fees, transportation losses, quality losses, and the allocation of prepaid expenses. This data is scattered across different departments and documents. The existing system lacks an automatic aggregation mechanism centered on the same batch (cabinet number). During settlement, finance personnel must manually search and summarize data from multiple tables, which is highly susceptible to errors due to omissions or duplications.
[0006] IV. The commission and profit-sharing calculation strategies are too simplistic. Under the consignment sales model, commissions can be calculated in various ways, such as as a percentage of sales revenue, a percentage of the net amount after deducting costs and expenses, or a fixed value per item or per unit. Under the guaranteed profit-sharing model, profit-sharing can be calculated as a percentage of the remaining balance after deducting costs and expenses or a percentage of the remaining balance after further deducting commissions. The existing system only supports a fixed percentage model and cannot select and combine multiple calculation strategies according to different settlement scenarios.
[0007] While some agricultural product inventory management software exists on the market, most only support a single trade method, have fixed trade and settlement mechanisms, and lack automatic batch aggregation and traceability adjustment functions, failing to meet the aforementioned complex and ever-changing business needs. The vast majority of agricultural product wholesale enterprises still rely on Excel spreadsheets for manual accounting, making it difficult to guarantee data accuracy and timeliness. Summary of the Invention
[0008] To overcome the shortcomings mentioned above, this invention aims to provide a technical solution that addresses the aforementioned problems. This invention uses the container number or batch number as a full-process tracking identifier, enables flexible switching between nine settlement methods through trade settlement documents, and supports traceability adjustments to settlement prices, batch association and aggregation of multiple types of business data, and the combination and selection of various commission and revenue-sharing calculation strategies.
[0009] A transaction settlement system for agricultural wholesale markets includes: The cabinet number / batch number management module is used to create a unique cabinet number or batch number for each batch of goods and use this cabinet number or batch number as a tracking identifier for the entire process of goods from warehousing to settlement. The trade method preset module is used to set the trade method corresponding to each container number or batch number when purchasing and receiving goods. The trade method includes a variety of predefined trade methods. The data association inventory record module is used to associate purchase orders, purchase receipts, purchase invoices, sales orders, consignment sales orders, sales delivery orders, sales invoices, expense reports, material requisition forms, and collection receipts with the corresponding cabinet numbers or batch numbers for recording, so as to obtain the receipt amount, sales amount, expense amount, material requisition amount, and collection receipt amount associated with each cabinet number or batch number. The trade settlement document generation module is used to import the warehouse entry amount, sales amount, expense amount, material requisition amount and collection income amount associated with the cabinet number or batch number selected by the operator, calculate the settlement amount payable according to the settlement method selected by the operator, and generate a trade settlement document. The settlement methods are varied, including the default settlement method and the conversion settlement method when changing from one trade method to another.
[0010] Preferably, the trade methods include general trade, guaranteed revenue sharing, and consignment sales; the default settlement methods include general trade settlement, guaranteed revenue sharing settlement, and consignment sales settlement, and the conversion settlement methods include general trade to guaranteed revenue sharing settlement, general trade to consignment sales settlement, guaranteed revenue sharing to general trade settlement, guaranteed revenue sharing to consignment sales settlement, consignment sales to general trade settlement, and consignment sales to guaranteed revenue sharing settlement.
[0011] Preferably, the trade settlement statement generation module includes: The data import unit is used to import the inbound amount, sales amount, expense amount, material requisition amount, and cash-on-delivery income amount associated with the selected cabinet number or batch number into the corresponding fields of the trade settlement form. Adjust the data entry unit to receive the settlement amount for warehousing, the settlement amount for sales, the settlement amount for expenses, the settlement amount for material requisition, and the settlement amount for revenue collected on behalf of others, which are entered by the operators. The difference calculation unit is used to calculate the differences between the settlement amount and the amount received, the differences between the settlement amount and the amount sold, the differences between the settlement amount and the amount of expenses, the differences between the settlement amount and the amount of material requisition, and the differences between the settlement amount and the amount of revenue collected on behalf of others, and generates the differences in settlement amount received, settlement amount sold, settlement amount of expenses, settlement amount of material requisition, and settlement amount of revenue collected on behalf of others.
[0012] Preferably, the trade settlement document generation module calculates the amount payable in the following manner: The trade settlement statement generation module calculates the commission payable to the system operator based on one of the following six methods selected by the operator: Method 1: Sales amount × commission rate; Method 2: (Sales revenue - Losses - Expenses) × Commission rate; Method 3: (Sales revenue - Cost) × Commission rate; Method 4: (Sales revenue - Cost - Losses - Expenses) × Commission rate; Method 5: Calculate commission per piece × commission value; Method Six: Calculate commission per counter × commission value; The trade settlement statement generation module calculates the share payable to the counterparty based on one of the following two methods selected by the operator: Method 1: (Sales Amount - Cost - Losses - Expenses) × Profit Sharing Ratio; Method 2: (Sales amount - Cost - Loss - Expenses - Commission payable to system operator) × Revenue sharing ratio; The trade settlement document generation module calculates the payable settlement amount according to one of the following nine methods, based on the settlement method selected by the operator: General trade settlement: Amount payable = Difference between settlement and warehouse receipt amount; Guaranteed revenue sharing settlement: Settlement amount payable = Difference between settlement and inbound amount + Revenue sharing payable to the counterparty - Commission payable to the system operator; Consignment sales settlement: Amount payable = Settlement sales amount + Settlement collection income amount - Settlement fee amount - Settlement material requisition amount - Commission payable to system operator; General trade to guaranteed revenue sharing settlement: Settlement amount payable = difference in settlement and warehousing amount + revenue sharing amount payable to the counterparty - commission amount payable to the system operator; Settlement for general trade consignment sales: Amount payable = Settlement sales amount + Settlement collection income amount - Settlement fee amount - Settlement material requisition amount - Commission payable to system operator - Warehouse entry amount; Guaranteed profit sharing converted to general trade settlement: Amount payable for settlement = Difference between settlement and warehouse receipt amount; Guaranteed commission transfer to consignment sales settlement: Settlement amount payable = Settlement sales amount + Settlement collection income amount - Settlement fee amount - Settlement material requisition amount - Commission payable to system operator - Warehouse entry amount; Consignment sales converted to general trade settlement: Amount payable = Amount received upon settlement; Consignment sales with guaranteed commission settlement: Settlement amount payable = Settlement amount received + Commission payable to counterparty - Commission payable to system operator.
[0013] Preferably, it also includes a verification module, which is used to verify whether the trade method selected by the operator matches the associated trade method of the selected cabinet number or batch number when the goods are sold and shipped. If they do not match, the shipping operation is blocked and an error is prompted.
[0014] Preferably, when the trade method set at the time of purchase and warehousing is consignment sales, the cost data of each purchase and sales document associated with the counter number or batch number is not included in the cost accounting; when the trade method set at the time of purchase and warehousing is general trade or guaranteed profit sharing, the cost data of each purchase and sales document associated with the counter number or batch number is accounted for according to the normal trade method.
[0015] Preferably, the expense payment slip supports selecting multiple expense items in the same document, with each expense item associated with a cabinet number or batch number; the collection receipt slip supports selecting multiple revenue items in the same document, with each revenue item associated with a cabinet number or batch number.
[0016] Preferably, it also includes an automatic accounting voucher generation module, which is used to automatically generate corresponding accounting vouchers according to the business nature of the purchase receipt, purchase invoice, sales delivery note, sales invoice, expense payment note, collection receipt, payment note, accounts receivable / payable reconciliation note and trade settlement note, and in accordance with the accounting principles of current accounting standards.
[0017] A method for transaction settlement in agricultural wholesale markets, generated through the aforementioned agricultural wholesale market transaction settlement system, includes the following steps: S1: Establish a unique container number or batch number for each batch of goods; S2: When purchasing and receiving goods, set the trade method for the cabinet number or batch number. The trade method includes three types: general trade, guaranteed profit sharing and consignment sales. S3: Link the purchase order, purchase receipt, purchase invoice, sales order, consignment order, sales delivery order, sales invoice, expense payment order, material requisition order, and collection receipt to the corresponding cabinet number or batch number for recording, so as to obtain the receipt amount, sales amount, expense amount, material requisition amount, and collection receipt amount associated with each cabinet number or batch number. S4: During settlement, based on the cabinet number or batch number selected by the operator, import the inbound amount, sales amount, expense amount, material requisition amount and collection amount associated with that cabinet number or batch number; S5: Receive the settlement amount for warehouse entry, settlement amount for sales, settlement amount for expenses, settlement amount for material requisition, and settlement amount for revenue collected on behalf of others entered by the operator, and calculate the various adjustment differences; S6: Calculate the amount payable based on the final settlement method selected by the operator from the nine settlement methods; S7: Generate a trade settlement statement and have it confirmed by both parties to the transaction.
[0018] Preferably, in step S6, the commission amount payable to the system operator, the share payable to the counterparty, and the settlement amounts payable for the nine settlement methods are all calculated in the manner described above.
[0019] Preferably, the method further includes step S8: automatically generating corresponding accounting vouchers according to the business nature of the purchase order, purchase receipt, purchase invoice, sales order, consignment sales order, sales delivery order, sales invoice, expense payment order, collection receipt, payment receipt, reconciliation order, and trade settlement order, based on preset accounting subjects.
[0020] Preferably, a computer-readable storage medium is provided, on which a computer program is stored, which, when executed by a processor, implements the above-described method for transaction settlement in agricultural wholesale markets.
[0021] Compared with the prior art, the beneficial effects of the present invention are: By using the cabinet number or batch number as the unique tracking identifier and spanning the entire business process from procurement receipt, sales shipment, expense collection, loss confirmation, and collection revenue recording, the system achieves automatic collection and unified accounting of all related data for the same batch of goods. Combined with the data import, traceability adjustment, and difference calculation functions of trade settlement documents, it supports flexible adjustments to the settlement receipt amount, settlement sales amount, settlement expense amount, settlement material requisition amount, and settlement collection revenue amount relative to the original amount, and automatically generates adjustment differences. Simultaneously, relying on the commission calculation unit, it selects one of six commission calculation methods to calculate the payable commission, and the profit-sharing calculation unit selects one of two profit-sharing calculation methods to calculate the payable profit-sharing. This enables flexible selection and automatic calculation of nine settlement methods (including three basic settlements and six conversion settlements), effectively solving the problems of fixed binding between trade and settlement methods, inability to trace and adjust settlement unit price changes, and business data in existing systems. The system addresses the technical challenges of fragmented and difficult-to-collect data, as well as the simplistic commission and revenue-sharing calculation strategies. Building upon this, the verification module matches and verifies the trade method with the associated counter number during sales shipments, preventing errors in settlement costs and expense accounting. Expense payment slips and collection receipts support linking multiple expense or revenue items to different counter numbers or batch numbers within the same document. Furthermore, under the consignment sales method, the cost of inventory and sales documents is not included in cost accounting, while the other two methods are accounted for according to normal trade methods, further ensuring the accuracy of cost accounting and the flexibility of expense allocation. Finally, the automatic accounting voucher generation module automatically generates corresponding accounting vouchers according to preset accounting subjects, achieving full-process automation and traceability of financial integration from business data collection and flexible settlement to financial accounting. This significantly reduces the settlement error rate and manual accounting costs for agricultural wholesale enterprises, providing management with accurate and timely decision-making data support.
[0022] Additional aspects and advantages of the invention will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. Attached Figure Description
[0023] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.
[0024] Figure 1 This is a flowchart of the settlement method of the present invention. Detailed Implementation
[0025] The technical solutions in the embodiments of the present invention will be clearly and completely described below. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.
[0026] like Figure 1 As shown, the following uses a fruit wholesale market as an application scenario and combines nine specific transaction settlement embodiments to further describe the present invention in detail. For ease of understanding, each embodiment uses the same batch of imported cherries (counter number: xxxxxxxxxx, product code: xxxxx, specification: JJ grade, unit: box, approximately 5kg per box) as an example. Before settlement, the data association inventory record module has associated all business documents, including purchase orders, purchase receipts, purchase invoices, sales orders, consignment sales orders, sales delivery orders, sales invoices, expense reports, material requisition forms, and collection receipts, with the corresponding counter number xxxxxxxxxx.
[0027] The basic data for this batch of goods procurement and warehousing is as follows (all amounts in the following examples are tax-exclusive, and tax rates and amounts are not considered in the calculation): 1000 boxes received, warehousing amount of 200,000 yuan (i.e., warehousing unit price of 200 yuan / box), 998 boxes sold (2 boxes were due to goods loss), sales amount of 299,400 yuan (i.e., sales unit price of 300 yuan / box). Related expenses amount to 6,000 yuan (including handling fees, refrigeration fees, etc., recorded through expense expense slips), and related collection income amount to 1,000 yuan (such as packaging material recycling income, recorded through collection income slips). Related material requisition amount is 50 yuan (auxiliary material consumption, recorded through material requisition slips with a checkmark); additionally, 400 yuan for the loss of 2 boxes of goods is not included in the material requisition amount in the trade settlement slip and is directly recognized as inventory loss.
[0028] In each embodiment, the differences in settlement amount for warehousing, sales amount, expense amount, material requisition amount, and revenue amount are all the corresponding settlement amount minus the original amount.
[0029] The following examples correspond to nine settlement methods, ranging from general trade settlement to consignment sales with guaranteed profit sharing.
[0030]
Example 1
[0031] Both parties signed a sales contract when the cherries were received into the warehouse. The wholesaler purchased the goods outright, and the trade method was set as general trade in the purchase order through the trade method preset module. The warehouse receipt amount was 200,000 yuan (the accounting entries added inventory and accounts payable to suppliers during the purchase receipt), and the warehouse receipt price was 200 yuan per box. During the sales process, the market conditions were basically consistent with expectations. Of the 1,000 boxes, 998 boxes were actually sold, and 2 boxes were due to normal loss. The sales amount was 299,400 yuan, which was recorded as sales revenue for the wholesaler, and the sales price was 300 yuan per box. During the sales period, handling fees, refrigeration fees, etc., totaling 6,000 yuan, were recorded as sales expenses of the wholesaler. Additionally, packaging material recycling revenue of 1,000 yuan was recorded as other business revenue of the wholesaler. Auxiliary material consumption costs of 50 yuan (recorded through a material requisition form with an accounting mark) were also recorded as sales expenses of the wholesaler. At the end of the period, when transferring the cost of goods sold, 998 boxes sold normally corresponded to 199,600 yuan transferred to the cost of goods sold, while 2 boxes of loss, corresponding to 400 yuan, were recognized as inventory losses and recorded as non-operating expenses of the wholesaler, totaling 200,000 yuan, consistent with the total cost of goods received. According to the accounting process, all revenues, costs, and expenses need to be transferred to the current year's profit, automatically generating the corresponding financial statements.
[0032] During settlement, the operator selects the cabinet number (xxxxxxxxxx) in the system. The data import unit of the trade settlement document generation module automatically imports the associated warehouse receipt amount (200,000 yuan), sales amount (299,400 yuan), expense amount (6,000 yuan), collection amount (1,000 yuan), and auxiliary material consumption amount (50 yuan) into the corresponding fields of the trade settlement document. Both parties confirm that since the actual warehouse receipt quality is basically consistent with the agreement, there is no need to adjust the warehouse receipt unit price and sales unit price. The operator confirms through the adjustment input unit that the settled warehouse receipt amount equals the warehouse receipt amount of 200,000 yuan, the settled sales amount equals the sales amount of 299,400 yuan, the settled expense amount equals the expense amount of 6,000 yuan, the settled collection amount equals the collection amount of 1,000 yuan, and the settled material consumption amount equals the material consumption amount of 50 yuan. The difference calculation unit calculates that all settlement differences are zero, with the settlement warehouse receipt amount difference = 200,000 yuan - 200,000 yuan = 0 yuan.
[0033] The system automatically identifies the selected container number as associated with "general trade." The operator selects "general trade settlement" in the "Settlement Method" column of the trade settlement form. The system automatically calculates the supplementary settlement amount according to the general trade settlement formula (settlement amount payable = difference between settlement and warehouse entry amount). In this embodiment, the supplementary settlement amount is 0 yuan, meaning the wholesaler has already paid 200,000 yuan at the general trade price upon warehouse entry. Since the settlement warehouse entry amount data has not been adjusted, and according to the accounting principle of this trade method being self-financing, other income, costs, and expenses are not related to the original supplier, so no adjustment amount needs to be calculated, and no additional payment or recovery is required from the supplier. Both parties settle according to the original general trade method. After the operator confirms that everything is correct, the system generates a trade settlement form and locks in subsequent transactions for that container number or batch number. Both parties sign to confirm, completing the settlement process for that batch of transactions.
[0034] This embodiment represents the most basic settlement model in this invention, applicable to standardized settlement scenarios where no price adjustments or changes in the trade method occur during the transaction process.
[0035]
Example 2
[0036] When the cherries were received into the warehouse, both parties agreed on a minimum cost price of 200 yuan per box (corresponding to a warehouse receipt amount of 200,000 yuan, which increased inventory and accounts payable to suppliers during the purchase and warehouse receipt process). The trade method preset module in the purchase and warehouse receipt order set a minimum cost-sharing arrangement, with the wholesaler responsible for sales and the final profit distributed according to the agreed ratio of 50% to 50% between the wholesaler and the supplier. During the sales process, the market conditions were largely consistent with expectations, with sales amounting to 299,400 yuan, recorded as wholesaler sales revenue (out of a total of 1000 boxes, 998 boxes were actually sold, with 2 boxes being normal losses). Expenses amounting to 6,000 yuan were recorded as wholesaler sales expenses. Income collected on behalf of others amounting to 1,000 yuan was recorded as wholesaler other business income. Material requisition amounting to 50 yuan (auxiliary material consumption) was recorded as wholesaler sales expenses. The loss of 2 boxes, corresponding to a cost of 400 yuan, was recognized as an inventory loss and recorded as a non-operating expense, totaling 200,000 yuan, consistent with the total cost of goods received. According to the accounting process, all revenues, costs, and expenses need to be transferred to the current year's profit, automatically generating the corresponding financial statements. All settlement amounts are consistent with the original amounts, and all differences are zero. Specifically, the difference in settlement amount received is 200,000 yuan - 200,000 yuan = 0 yuan.
[0037] During settlement, the operator selects the container number xxxxxxxxxx in the system. The data import unit of the trade settlement document generation module automatically imports all data associated with that container number. Both parties confirm through negotiation that no adjustments are needed. The operator confirms through the adjustment entry unit that all settlement amounts equal the original amounts, and the difference calculation unit calculates that the difference in the settled warehouse amount is 0 yuan. The system automatically populates the associated trade method as "guaranteed minimum revenue sharing" based on the selected container number. The operator selects "guaranteed minimum revenue sharing settlement" in the "Settlement Method" column of the trade settlement document. The system calculates the revenue sharing amount according to the revenue sharing calculation method: Profit = Sales amount 299,400 yuan - Cost 200,000 yuan - Expenses 6,000 yuan - Material requisition 50 yuan + Collection income 1,000 yuan = 94,350 yuan. The operator selects method one (profit × revenue sharing ratio) from the two revenue sharing methods. The system calculates the revenue sharing amount payable to the counterparty (supplier) = 94,350 yuan × 50% = 47,175 yuan. Since this embodiment does not involve the calculation of consignment commission, the commission amount payable to the system operator (wholesaler) is zero.
[0038] The system automatically calculates the payable settlement amount according to the guaranteed minimum cost settlement formula (payable settlement amount = difference between settlement and warehouse receipt amount + payable share to the counterparty - payable commission to the system operator): 0 yuan + 47,175 yuan - 0 yuan = 47,175 yuan. This means that the wholesaler has already paid 200,000 yuan at the guaranteed minimum cost price upon warehouse receipt. No adjustments were made to the data at settlement; only the supplier's due profit share of 47,175 yuan needs to be paid. This profit share will be included in the wholesaler's current period costs and transferred to the current year's profit at the end of the period. The system generates a trade settlement statement, which is then confirmed by both parties to complete the settlement.
[0039] This embodiment applies to standard guaranteed revenue sharing transactions where the trade method has not changed, and focuses on demonstrating the application process of the revenue sharing calculation strategy in the system.
[0040]
Example 3
[0041] When the cherries are received into the warehouse, both parties agree to conduct the transaction through consignment sales. The trade method is set as consignment sales in the purchase receipt via the trade method preset module. The supplier entrusts a wholesaler to sell the goods on their behalf, and the wholesaler receives a commission of 5% of the sales amount. In this embodiment, the wholesaler does not bear the risk of price fluctuations or costs during the sales process; these risks are borne by the supplier. Therefore, the warehouse receipt cost under the consignment sales method is not included in the wholesaler's cost accounting. Furthermore, other sales revenue, collection revenue, prepaid expenses, and prepaid auxiliary material expenses related to this cabinet number or batch number are recorded in the supplier's accounts receivable / payable or accounts payable / payable, and are unrelated to the wholesaler's profit or loss.
[0042] During settlement, the operator selects the container number xxxxxxxxxx in the system. The data import unit of the trade settlement form generation module automatically imports all data associated with that container number: 1000 boxes received (unit price 0, not included in cost accounting; the system only calculates the increase in inventory, no need to calculate accounts payable to suppliers), sales amount 299,400 yuan, expenses 6,000 yuan, collection income 1,000 yuan, and material requisition 50 yuan (all recorded in the supplier's collection and advance accounts). According to the accounting principle of this trade method, the wholesaler does not need to transfer income, cost, and expense data at the end of the period. After confirmation by both parties, no adjustments have been made to the data, and all differences are zero. The system automatically populates the associated trade method as "consignment sales" based on the selected container number. The operator selects "consignment sales settlement" in the "Settlement Method" column of the trade settlement form and selects "Method 1 (sales amount × commission rate)" in the commission calculation method, manually entering a commission rate of 5%.
[0043] The system automatically calculates the payable settlement amount according to the consignment settlement formula (payable settlement amount = settled sales amount + settled collection income amount - settled expenses amount - settled material requisition amount - commission payable to the system operator). Specifically, the commission payable to the system operator (wholesaler) = 299,400 yuan × 5% = 14,970 yuan (this commission income is recorded in the wholesaler's other business income and profit / loss account). The payable settlement amount = 299,400 yuan + 1,000 yuan - 6,000 yuan - 50 yuan - 14,970 yuan = 279,380 yuan. This result means that the wholesaler should pay the counterparty (supplier) 279,380 yuan, which is the net amount of the supplier's total sales revenue after deducting all costs, expenses, and commission. The system generates a trade settlement statement, and the settlement is completed after confirmation by both parties.
[0044] This embodiment is applicable to agency transaction scenarios where wholesalers act only as resellers and do not bear the risk of goods price fluctuations.
[0045]
Example 4
[0046] When the batch of cherries was purchased and put into storage, the trade method was set as general trade through the preset trade method module, with the wholesaler buying the goods outright for 200,000 yuan. However, due to delays in sea freight during transportation, the freshness of the cherries decreased, resulting in poor quality upon actual sale. The final sales amount was 180,000 yuan, causing a loss for the wholesaler. If the settlement were made according to the original general trade method, the wholesaler would bear all the losses alone. To avoid the wholesaler suffering significant losses due to the price plunge, both parties agreed to change the trade method from "general trade" to "guaranteed cost sharing" at the time of settlement, meaning that the supplier would share the losses with the wholesaler based on a guaranteed cost price.
[0047] During settlement, the operator selects cabinet number xxxxxxxxxx. The data import unit of the trade settlement document generation module automatically imports the original data associated with that cabinet number: Inbound amount 200,000 yuan (accounting processing added inventory goods and accounts payable to suppliers during purchase inbound), sales amount 180,000 yuan (accounting processing recorded as wholesaler's sales revenue), expenses 6,000 yuan (accounting processing recorded as wholesaler's sales expenses), collection income 800 yuan (accounting processing recorded as wholesaler's other business income), and auxiliary material consumption fee 50 yuan (recorded through a material requisition form with an accounting mark) (accounting processing recorded as wholesaler's sales expenses). After negotiation, both parties adjusted the data entry unit to maintain the settled inbound amount at 200,000 yuan, while the remaining settlement amounts remained consistent with the original amounts. The difference calculation unit calculated the settlement inbound amount difference as 200,000 yuan - 200,000 yuan = 0 yuan.
[0048] The system automatically identifies the associated trade method as "general trade" based on the selected container number. The operator selects "General Trade to Guaranteed Profit Sharing Settlement" in the "Settlement Method" column of the trade settlement form. The system calculates the profit (actually a loss) according to the profit sharing calculation method: Loss = Sales Amount 180,000 RMB - Cost 200,000 RMB - Expenses 6,000 RMB - Material Requisition 50 RMB + Collection Income 800 RMB = -25,250 RMB. Both parties agree on a loss sharing ratio of 60% for the wholesaler and 40% for the supplier. The system selects profit sharing method one (profit × profit sharing ratio) and calculates the profit sharing amount payable to the counterparty (supplier) as -25,250 RMB × 40% = -10,100 RMB (the negative value indicates the supplier's share of the loss). This portion of the loss borne by the supplier must be deducted from the wholesaler's current costs.
[0049] The system automatically calculates the payable settlement amount according to the general trade to guaranteed revenue sharing settlement formula (payable settlement amount = difference in settlement and warehousing amount + revenue sharing amount payable to the counterparty - commission amount payable to the system operator): 0 yuan + (-10,100 yuan) - 0 yuan = -10,100 yuan. This means that the wholesaler paid 200,000 yuan at the general trade price upon warehousing. Due to the change in trade method to guaranteed revenue sharing at settlement, the supplier should bear a loss of 10,100 yuan, which will be returned to the wholesaler. Therefore, the supplier's actual receivable is 189,900 yuan (200,000 yuan - 10,100 yuan). The system generates a trade settlement statement, and the settlement is completed after confirmation by both parties.
[0050] This embodiment fully demonstrates that when market conditions change adversely, the system allows for a flexible conversion of the trade method from "general trade" to "guaranteed profit sharing" during the settlement process.
[0051]
Example 5
[0052] When the batch of cherries was purchased and put into storage, the trade method was set as general trade through the preset trade method module, and the wholesaler bought the goods outright for 200,000 yuan. However, after the goods arrived at the port, inspection revealed that some cherries were not sweet enough and were too soft, resulting in market acceptance far below expectations. Even with a significant price reduction, the wholesaler struggled to sell them, and the final sales amount was only 180,000 yuan, resulting in a severe loss for the wholesaler. After negotiation, both parties agreed to change the trade method from "general trade" to "consignment sales" at the time of settlement. The wholesaler will only receive a commission based on the sales amount, and all losses incurred during the sales process will be borne by the supplier.
[0053] During settlement, the operator selects the cabinet number xxxxxxxxxx, and the data import unit of the trade settlement document generation module automatically imports the original data: Inbound amount 200,000 yuan (accounting processing added inventory goods and accounts payable to suppliers during purchase inbound), sales amount 180,000 yuan (accounting processing recorded as wholesaler's sales revenue), expenses 7,000 yuan (accounting processing recorded as wholesaler's sales expenses), collection income 900 yuan (accounting processing recorded as wholesaler's other business income), and auxiliary material consumption fee 50 yuan (recorded through a material requisition form with an accounting mark) (accounting processing recorded as wholesaler's sales expenses). Both parties confirm that all settlement amounts are consistent with the original data, and all differences are zero. The difference in the settlement inbound amount is 200,000 yuan - 200,000 yuan = 0 yuan. The system automatically populates the associated trade method as "general trade" based on the selected counter number. The operator selects "general trade to consignment settlement" in the "settlement method" column of the trade settlement form, and selects "method one (sales amount × commission rate)" in the commission calculation method. The commission rate is 5%. The system calculates the commission payable to the system operator (wholesaler) as RMB 180,000 × 5% = RMB 9,000. The accounting treatment is recorded in the wholesaler's other business income account.
[0054] The system automatically calculates the payable settlement amount according to the general trade consignment settlement formula (payable settlement amount = settlement sales amount + settlement collection amount - settlement fee amount - settlement material requisition amount - commission payable to the system operator - warehousing amount): 180,000 yuan + 900 yuan - 7,000 yuan - 50 yuan - 9,000 yuan - 200,000 yuan = -35,150 yuan. This means that the net consignment amount (180,000 + 900 - 7,000 - 50 - 9,000 = 164,850 yuan) minus the 200,000 yuan warehousing amount already calculated according to general trade terms is -35,150 yuan. In other words, the wholesaler should deduct 35,150 yuan from the supplier's payable amount. The system generates a trade settlement statement, and the settlement is completed after confirmation by both parties.
[0055] This example demonstrates how, when a wholesaler suffers significant losses due to a severe deterioration in product quality, the system supports converting general trade into consignment sales settlement, allowing the supplier to bear all losses from the price decline.
[0056]
Example 6
[0057] When the cherries were purchased and put into storage, the trade method was preset using the trade method module as a guaranteed profit sharing arrangement, with a guaranteed cost price of 200,000 yuan and profits split 40% between the supplier and 60% between the wholesaler. However, after the goods were launched, coinciding with the Mid-Autumn Festival and National Day holidays, market demand was strong, and the final sales amount reached 350,000 yuan, far exceeding expectations. The wholesaler proposed to change the settlement method from "guaranteed profit sharing" to "general trade," demanding settlement on a buy-out basis and no longer sharing the excess profits with the supplier.
[0058] After negotiation between both parties, the supplier agreed to change the settlement method to general trade. During settlement, the operator selected container number xxxxxxxxxx in the system. After negotiation, the settlement amount was adjusted from 200,000 yuan to 220,000 yuan (adjustment for quality and market premium) by adjusting the input unit. The difference calculation unit calculated the difference in settlement amount as 220,000 yuan - 200,000 yuan = 20,000 yuan.
[0059] The system automatically identifies the associated trade method as "minimum guarantee and revenue sharing" based on the selected container number. The operator then selects "Minimum guarantee and revenue sharing to general trade settlement" in the "Settlement Method" column of the trade settlement form. The system automatically calculates the payable settlement amount as 20,000 yuan according to the formula (payable settlement amount = difference between settlement and inbound amount). This means that the wholesaler has already paid 200,000 yuan at the minimum guarantee cost price upon inbound. Due to an increase of 20,000 yuan in the settlement inbound amount, the wholesaler needs to pay an additional 20,000 yuan to the counterparty (supplier) for quality and market premium (the wholesaler will record this difference in current period costs). The system generates a trade settlement form, and the settlement is completed after confirmation by both parties.
[0060] This example demonstrates that when market conditions are favorable, the system supports converting guaranteed profit sharing into general trade settlement.
[0061]
Example 7
[0062] When the cherries were purchased and put into storage, the trade method preset module indicated a guaranteed minimum cost and profit sharing, with a guaranteed cost price of 200,000 yuan and profits split 50 / 50 between the supplier and the wholesaler. However, the goods were delayed due to a typhoon during transportation, resulting in a significant decline in the quality of some cherries. The final sales amount was only 210,000 yuan, which was insufficient for the wholesaler to cover the guaranteed cost. After urgent negotiations, both parties agreed to abandon the guaranteed minimum cost and profit sharing method and switch to a consignment sales method for settlement. The supplier would bear all sales losses, and the wholesaler would only receive a commission based on a certain percentage.
[0063] During settlement, the operator selects the cabinet number xxxxxxxxxx, and the data import unit of the trade settlement document generation module automatically imports the original data: Inbound amount 200,000 yuan (accounting processing added inventory goods and accounts payable to suppliers during purchase and warehousing), sales amount 210,000 yuan recorded as wholesaler's sales revenue, expenses 8,000 yuan recorded as wholesaler's sales expenses, collection income 700 yuan recorded as wholesaler's other business income, and auxiliary material consumption fee 50 yuan (recorded through a material requisition form with an accounting mark) recorded as wholesaler's sales expenses. Both parties confirm that all settlement amounts are consistent with the original data, and all discrepancies are zero. The system automatically populates the associated trade method as "minimum guarantee and commission" based on the selected counter number. The operator selects "minimum guarantee and commission to consignment settlement" in the "settlement method" column of the trade settlement form, and selects "method four (sales amount - cost - loss - expense) × commission rate" in the commission calculation method. The commission rate is 5%. The system calculates the commission base = 210,000 yuan - 200,000 yuan - 50 yuan - 8,000 yuan = 1,950 yuan. The commission amount payable to the system operator (wholesaler) = 1,950 yuan × 5% = 97.5 yuan.
[0064] The system automatically calculates the payable settlement amount according to the guaranteed commission-based consignment settlement formula (payable settlement amount = settlement sales amount + settlement collection amount - settlement fee amount - settlement material requisition amount - commission payable to the system operator - warehousing amount): 210,000 yuan + 700 yuan - 8,000 yuan - 50 yuan - 97.5 yuan - 200,000 yuan = 2,552.5 yuan. This means the wholesaler should pay the supplier an additional 2,552.5 yuan, representing the difference between the 200,000 yuan already recorded as payable and the supplier's revenue. The system generates a trade settlement statement, and the settlement is completed after confirmation by both parties.
[0065] This example demonstrates how the system supports flexibly converting guaranteed commission to consignment settlement when the quality of goods deteriorates significantly.
[0066]
Example 8
[0067] When the cherries were purchased and put into storage, the trade method was set as consignment sales through the preset trade method module, with the wholesaler only receiving a 5% commission on sales. However, after the goods hit the market, production in the main producing areas was reduced, resulting in a shortage of supply and a sales price far exceeding expectations, ultimately reaching 400,000 yuan. The wholesaler felt that receiving only a percentage commission based on consignment sales was unreasonable, and after negotiation, both parties decided to change the trade method from "consignment sales" to "general trade" at the time of settlement.
[0068] During settlement, the operator selects the cabinet number xxxxxxxxxx in the system. After negotiation, both parties adjust the settlement amount to 220,000 yuan by adjusting the data entry unit. Since the original consignment cost was 0 yuan, the difference calculation unit calculates the settlement amount difference as 220,000 yuan - 0 yuan = 220,000 yuan. The system automatically populates the associated trade method as "consignment" based on the selected cabinet number. The operator selects "Consignment to General Trade Settlement" in the "Settlement Method" column of the trade settlement form. The system automatically calculates the payable amount as 220,000 yuan according to the formula for consignment to general trade settlement (payable settlement amount = settlement amount). This result means that the wholesaler should pay 220,000 yuan to the other party (supplier) (this amount is recorded in the wholesaler's current costs in the accounting process), and the system will not calculate commission. The system generates a trade settlement form, and the settlement is completed after confirmation by both parties.
[0069] This example demonstrates how the system supports converting consignment sales into general trade settlement when market conditions far exceed expectations.
[0070]
Example 9
[0071] When the cherries were purchased and put into storage, the trade method was set as consignment sales through the preset trade method module, with the wholesaler receiving a 5% commission on sales. However, after the goods arrived and were inspected, the quality was found to be excellent, and the market supply was tight at the same time. The wholesaler hoped to obtain higher profits through a profit-sharing arrangement. After negotiation, the supplier agreed to change the trade method from "consignment sales" to "guaranteed profit-sharing" at the time of settlement. That is, based on a guaranteed cost price of 200,000 yuan, the profit would be distributed between the supplier (40%) and the wholesaler (60%), and no further commission would be calculated.
[0072] During settlement, the operator selects the container number xxxxxxxxxx, and the data import unit of the trade settlement form generation module automatically imports the original data: Quantity received: 1000 boxes (unit price: 0, not included in cost accounting; the system only calculates the increase in inventory, no need to calculate accounts payable to suppliers; settlement amount is calculated as 200,000 yuan), sales amount: 320,000 yuan, expenses: 5,000 yuan, collection income: 1,200 yuan, material requisition: 50 yuan (all recorded in the supplier's collection and advance accounts). According to the accounting principle of this trade method, the wholesaler does not need to transfer revenue, cost, and expense data at the end of the period. Both parties confirm that all settlement amounts are consistent with the original data, and all differences are zero. The system automatically populates the associated trade method as "consignment sales" based on the selected container number. The operator selects "consignment sales to guaranteed profit sharing settlement" in the "Settlement Method" column of the trade settlement form. The system calculates the profit sharing as follows: Sales amount 320,000 yuan - Cost 200,000 yuan - Expenses 5,000 yuan - Material requisition 50 yuan + Collection income 1,200 yuan = 116,150 yuan. The profit sharing amount payable to the counterparty (supplier) under the first profit sharing method is calculated as follows: 116,150 yuan × 40% = 46,460 yuan.
[0073] The system automatically calculates the payable settlement amount according to the consignment sales to guaranteed minimum profit sharing settlement formula (payable settlement amount = settlement and warehousing amount + payable to the counterparty - payable to the system operator commission amount): 200,000 yuan + 46,460 yuan - 0 yuan = 246,460 yuan. This amount is recorded in the wholesaler's current period costs. This result means that the wholesaler should pay the counterparty (supplier) 246,460 yuan (including the guaranteed minimum purchase price of 200,000 yuan and the profit sharing of 46,460 yuan). The system generates a trade settlement statement, and the settlement is completed after confirmation by both parties.
[0074] This example demonstrates how the system supports converting consignment sales into a guaranteed revenue-sharing settlement when wholesalers wish to obtain higher profits.
[0075] General Implementation Description The above nine embodiments correspond to nine settlement methods, covering all combinations of the three default settlement methods and six conversion settlement methods. In practical applications, all embodiments follow the following unified system operation procedure: Step 1: Data Preparation and Association. The system establishes a unique identifier for each batch of goods through the cabinet number / batch number management module, sets the trade method during procurement and warehousing through the trade method preset module, and associates all business documents with the corresponding cabinet number or batch number through the data association inventory record module.
[0076] Step two, settlement statement generation and data import. The operator selects the cabinet number or batch number to be settled, and the data import unit of the trade settlement statement generation module automatically imports all inbound amounts, sales amounts, expense amounts, material requisition amounts, and collection income amounts associated with that cabinet number into the corresponding fields of the trade settlement statement.
[0077] Step 3: Retrospective Adjustment and Discrepancy Calculation. Based on the agreed-upon results from both parties, the operator enters the settlement amounts into the adjustment input unit. The discrepancy calculation unit automatically calculates the differences between each settlement amount and the original amount.
[0078] Step four: Confirm the trade method and select the settlement method. The system automatically displays the trade methods associated with the selected container number, and the operator selects the final settlement method from nine options.
[0079] Step 5: Commission and Revenue Sharing Calculation. When consignment sales are involved, choose one of the six commission calculation methods to calculate the commission amount payable to the system operator (wholesaler); when guaranteed revenue sharing is involved, choose one of the two revenue sharing calculation methods to calculate the revenue sharing amount payable to the counterparty (supplier).
[0080] Step Six: Calculation of Accounts Payable. The system automatically calculates the accounts payable amount based on the selected settlement method and the corresponding formula.
[0081] Step 7: Confirmation and Locking. After the operator verifies that everything is correct, the document is submitted for confirmation by both parties. Once confirmed, the system will lock the trade settlement document.
[0082] Step 8: Automatic generation of accounting vouchers. The automatic accounting voucher generation module automatically generates corresponding accounting vouchers based on the nature of the trade settlement statement and in accordance with the accounting principles of current accounting standards, completing the fully automated processing from business settlement to financial accounting.
[0083] Through the above process, this invention enables flexible conversion between trade and settlement methods during the transaction settlement process of agricultural wholesale markets, traceable adjustment of settlement unit prices, batch association and collection of multiple types of business data, and combination selection of various commission and profit-sharing calculation strategies. It effectively solves various problems existing in the prior art and significantly improves the accuracy, flexibility and efficiency of transaction settlement in agricultural wholesale markets.
[0084] It will be apparent to those skilled in the art that the present invention is not limited to the details of the exemplary embodiments described above, and that the invention can be implemented in other specific forms without departing from the spirit or essential characteristics of the invention. Therefore, the embodiments should be considered in all respects as exemplary and non-limiting, and the scope of the invention is defined by the appended claims rather than the foregoing description. Thus, it is intended that all variations falling within the meaning and scope of equivalents of the claims be included within the present invention.
Claims
1. A transaction settlement system for agricultural wholesale markets, characterized in that, include: The cabinet number / batch number management module is used to create a unique cabinet number or batch number for each batch of goods and use this cabinet number or batch number as a tracking identifier for the entire process of goods from warehousing to settlement. The trade method preset module is used to set the trade method corresponding to each container number or batch number when purchasing and receiving goods. The trade method includes a variety of predefined trade methods. The data association inventory record module is used to associate purchase orders, purchase receipts, purchase invoices, sales orders, consignment sales orders, sales delivery orders, sales invoices, expense reports, material requisition forms, and collection receipts with the corresponding cabinet numbers or batch numbers for recording, so as to obtain the receipt amount, sales amount, expense amount, material requisition amount, and collection receipt amount associated with each cabinet number or batch number. The trade settlement document generation module is used to import the warehouse entry amount, sales amount, expense amount, material requisition amount and collection income amount associated with the cabinet number or batch number selected by the operator, calculate the settlement amount payable according to the settlement method selected by the operator, and generate a trade settlement document. The settlement methods are varied, including the default settlement method and the conversion settlement method when changing from one trade method to another.
2. The transaction settlement system for agricultural product wholesale markets according to claim 1, characterized in that, Trade methods include general trade, guaranteed revenue sharing, and consignment sales; default settlement methods include general trade settlement, guaranteed revenue sharing settlement, and consignment sales settlement; conversion settlement methods include general trade to guaranteed revenue sharing settlement, general trade to consignment sales settlement, guaranteed revenue sharing to general trade settlement, guaranteed revenue sharing to consignment sales settlement, consignment sales to general trade settlement, and consignment sales to guaranteed revenue sharing settlement.
3. A transaction settlement system for agricultural product wholesale markets according to claim 2, characterized in that, The trade settlement document generation module includes: The data import unit is used to import the inbound amount, sales amount, expense amount, material requisition amount, and cash-on-delivery income amount associated with the selected cabinet number or batch number into the corresponding fields of the trade settlement form. Adjust the data entry unit to receive the settlement amount for warehousing, the settlement amount for sales, the settlement amount for expenses, the settlement amount for material requisition, and the settlement amount for revenue collected on behalf of others, which are entered by the operators. The difference calculation unit is used to calculate the differences between the settlement amount and the amount received, the differences between the settlement amount and the amount sold, the differences between the settlement amount and the amount of expenses, the differences between the settlement amount and the amount of material requisition, and the differences between the settlement amount and the amount of revenue collected on behalf of others, and generates the differences in settlement amount received, settlement amount sold, settlement amount of expenses, settlement amount of material requisition, and settlement amount of revenue collected on behalf of others.
4. A transaction settlement system for agricultural product wholesale markets according to claim 3, characterized in that, The trade settlement document generation module calculates the payable settlement amount in the following manner: The trade settlement statement generation module calculates the commission payable to the system operator based on one of the following six methods selected by the operator: Method 1: Sales amount × commission rate; Method 2: (Sales revenue - Losses - Expenses) × Commission rate; Method 3: (Sales revenue - Cost) × Commission rate; Method 4: (Sales revenue - Cost - Losses - Expenses) × Commission rate; Method 5: Calculate commission per piece × commission value; Method Six: Calculate commission per counter × commission value; The trade settlement statement generation module calculates the share payable to the counterparty based on one of the following two methods selected by the operator: Method 1: (Sales Amount - Cost - Losses - Expenses) × Profit Sharing Ratio; Method 2: (Sales amount - Cost - Loss - Expenses - Commission payable to system operator) × Revenue sharing ratio; The trade settlement document generation module calculates the payable settlement amount according to one of the following nine methods, based on the settlement method selected by the operator: General trade settlement: Amount payable = Difference between settlement and warehouse receipt amount; Guaranteed revenue sharing settlement: Settlement amount payable = Difference between settlement and inbound amount + Revenue sharing payable to the counterparty - Commission payable to the system operator; Consignment sales settlement: Amount payable = Settlement sales amount + Settlement collection income amount - Settlement fee amount - Settlement material requisition amount - Commission payable to system operator; General trade to guaranteed revenue sharing settlement: Settlement amount payable = difference in settlement and warehousing amount + revenue sharing amount payable to the counterparty - commission amount payable to the system operator; Settlement for general trade consignment sales: Amount payable = Settlement sales amount + Settlement collection income amount - Settlement fee amount - Settlement material requisition amount - Commission payable to system operator - Warehouse entry amount; Guaranteed profit sharing converted to general trade settlement: Amount payable for settlement = Difference between settlement and warehouse receipt amount; Guaranteed commission transfer to consignment sales settlement: Settlement amount payable = Settlement sales amount + Settlement collection income amount - Settlement fee amount - Settlement material requisition amount - Commission payable to system operator - Warehouse entry amount; Consignment sales converted to general trade settlement: Amount payable = Amount received upon settlement; Consignment sales with guaranteed commission settlement: Settlement amount payable = Settlement amount received + Commission payable to counterparty - Commission payable to system operator.
5. A transaction settlement system for agricultural product wholesale markets according to claim 1, characterized in that, It also includes a verification module, which verifies whether the trade method selected by the operator matches the associated trade method of the selected cabinet number or batch number when the goods are shipped out. If they do not match, the shipment operation is blocked and an error is displayed.
6. A transaction settlement system for agricultural product wholesale markets according to claim 2, characterized in that, When the trade method set at the time of purchase and warehousing is consignment sales, the cost data of each purchase and sales document associated with that cabinet number or batch number will not be included in cost accounting. When the trade method set at the time of purchase and warehousing is general trade or guaranteed revenue sharing, the cost data of each purchase, sales and inventory document associated with that cabinet number or batch number is calculated according to the normal trade method.
7. A transaction settlement system for agricultural product wholesale markets according to claim 1, characterized in that, The expense payment slip allows you to select multiple expense items in the same document, with each expense item associated with a cabinet number or batch number; the collection receipt slip allows you to select multiple revenue items in the same document, with each revenue item associated with a cabinet number or batch number.
8. A transaction settlement system for agricultural product wholesale markets according to claim 1, characterized in that, It also includes an automatic accounting voucher generation module, which is used to automatically generate corresponding accounting vouchers based on the nature of the business, such as purchase receipts, purchase invoices, sales delivery notes, sales invoices, expense expense notes, collection receipts, payment notes, accounts receivable / payable reconciliation notes, and trade settlement notes, and to automatically generate corresponding accounting vouchers according to the accounting principles of current accounting standards by pre-setting matching accounting subjects.
9. A method for transaction settlement in agricultural wholesale markets, generated by any one of claims 1-8 in a transaction settlement system for agricultural wholesale markets, characterized in that... Includes the following steps: S1: Establish a unique container number or batch number for each batch of goods; S2: When purchasing and receiving goods, set the trade method for the cabinet number or batch number. The trade method includes three types: general trade, consignment sales and guaranteed profit sharing. S3: Link the purchase order, purchase receipt, purchase invoice, sales order, consignment order, sales delivery order, sales invoice, expense payment order, material requisition order, and collection receipt to the corresponding cabinet number or batch number for recording, so as to obtain the receipt amount, sales amount, expense amount, material requisition amount, and collection receipt amount associated with each cabinet number or batch number. S4: During settlement, based on the cabinet number or batch number selected by the operator, import the inbound amount, sales amount, expense amount, material requisition amount and collection amount associated with that cabinet number or batch number; S5: Receive the settlement amount for warehouse entry, settlement amount for sales, settlement amount for expenses, settlement amount for material requisition, and settlement amount for revenue collected on behalf of others entered by the operator, and calculate the various adjustment differences; S6: Calculate the amount payable based on the final settlement method selected by the operator from the nine settlement methods; S7: Generate a trade settlement statement and have it confirmed by both parties to the transaction.
10. A method for transaction settlement in agricultural wholesale markets according to claim 9, characterized in that, In step S6, the commission amount payable to the system operator, the share payable to the counterparty, and the settlement amount payable for the nine settlement methods are all calculated in accordance with the method described in claim 4.
11. A method for transaction settlement in agricultural wholesale markets according to claim 9, characterized in that, It also includes step S8: Based on the business nature of the purchase order, purchase receipt, purchase invoice, sales order, consignment sales order, sales delivery order, sales invoice, expense payment order, collection receipt, payment receipt, reconciliation statement, and trade settlement statement, the corresponding accounting vouchers are automatically generated by pre-setting matching accounting subjects in accordance with the accounting principles of current accounting standards.