CN112149398B

CN112149398B - System for quickly generating profit-facilitating report forms of e-commerce and enterprise

Info

Publication number: CN112149398B
Application number: CN202011015711.8A
Authority: CN
Inventors: 马科; 邵宝康; 骆海东
Original assignee: Shanghai Jushuitan Network Technology Co ltd
Current assignee: Shanghai Jushuitan Network Technology Co ltd
Priority date: 2020-09-24
Filing date: 2020-09-24
Publication date: 2022-02-08
Anticipated expiration: 2040-09-24
Also published as: CN112149398A

Abstract

The invention discloses a system for quickly generating an e-commerce enterprise profit-making report, which improves the working efficiency and the accuracy and the integrity of data, solves the problem of data delay of the traditional financial report, and meets the data requirements of risk early warning and operation decision making of an e-commerce operator. The technical scheme is as follows: the system provides a report form for quickly estimating the operation profits for the user, improves the timeliness and the accuracy of user data analysis, is beneficial to the client to know the operation condition of the enterprise in time and make operation decisions better. In addition, the system of the invention designs different cost processing flows aiming at different cost projects, can be compatible with different service scenes and is more suitable for service practice. Meanwhile, the modes of pre-extraction and the like are included in calculation when the cost occurs, so that the accuracy and the integrity of cost processing are further improved, and the operation data are more reasonable.

Description

System for quickly generating profit-facilitating report forms of e-commerce and enterprise

Technical Field

The invention relates to an e-commerce enterprise financial statement system, in particular to a system capable of quickly generating an e-commerce enterprise profit-clearing statement.

Background

The electric business enterprises need to quickly and timely know the operation conditions of the stores, and the major operation risk caused by the large amount of orders is avoided. The mode of the conventional financial report form at the beginning of the next month does not meet the requirements of operational analysis and risk early warning timeliness, and a plurality of merchants try to collect and count data from a plurality of links of each system in the modes of excel and the like, so as to summarize and issue a timely operational reference report form. But due to the reasons of huge order quantity, numerous data source apertures and the like, merchants have difficulty in accurately counting operating profits in time and have low efficiency.

Disclosure of Invention

The following presents a simplified summary of one or more aspects in order to provide a basic understanding of such aspects. This summary is not an extensive overview of all contemplated aspects, and is intended to neither identify key or critical elements of all aspects nor delineate the scope of any or all aspects. Its sole purpose is to present some concepts of one or more aspects in a simplified form as a prelude to the more detailed description that is presented later.

The invention aims to solve the problems and provides a system for quickly generating an e-commerce enterprise profit-clearing report, which can realize quick statistics and query of the operation profits of e-commerce merchants, can issue an operation profit reference report the next day, greatly improves the working efficiency and the accuracy and the integrity of data compared with the report issued by partial merchants through manual processing modes such as excel and the like, can be used as an important filling of a traditional accounting system for the e-commerce enterprise management report requirements, solves the problem of data delay of the traditional financial report, and meets the data requirements of risk early warning and decision-making operation of e-commerce operators.

The technical scheme of the invention is as follows: the invention discloses a system for quickly generating profit-sharing report forms of electronic commerce and enterprise businesses, which comprises a parameter self-defining module and an operation data processing module, wherein the parameter self-defining module comprises:

the parameter self-defining module is used for defining parameters, and the defined parameters comprise refund calibers, estimated refund rates and expense item value-taking schemes;

and the operation data processing module is used for acquiring order data, after-sales order data and expense data, taking the payment amount data in the order as income according to the structure of the accounting profit list, taking the refund amount in the after-sales order or calculated by the estimated refund rate as an income deduction item, automatically acquiring corresponding cost price from the commodity data list according to the commodity details in the order and the after-sales order, taking the cost price as a cost and cost deduction item, acquiring data from each expense source list as expense through an expense item value-taking scheme, and calculating to generate an operation profit list.

According to an embodiment of the system for rapidly generating the profit-and-profit statement of the electronic commerce and the enterprise, the parameter customizing module selects the refund caliber according to the refund progress.

According to an embodiment of the system for rapidly generating the profit-and-profit statement of the electric and commercial enterprises, the parameter customization module sets different expense item value schemes according to the properties of different expense items.

According to an embodiment of the system for rapidly generating the profit-and-moisture statement of the e-commerce enterprise, the expense data acquired by the operation data processing module comprise daily accounts, pre-proposed bills, public expense allocation, platform expense data, express delivery expense and consumable expense generated by the ERP system according to user configuration rules, and user import data.

According to an embodiment of the system for rapidly generating the electric business profit-making and profit-moistening statement, the operation profit statement comprises income, cost, expense and operation profit.

According to one embodiment of the system for rapidly generating the electric business profit-making and moist statement, the business profit statement is displayed daily, displayed according to a single platform or multiple platforms, and displayed by a single shop or multiple shops, and the expense data is generated according to different expense item value schemes configured by the user and is listed by profit statement items.

According to an embodiment of the system for rapidly generating the profit-cleared statement of the e-commerce and the enterprise, the operation data processing module comprises an order data processing unit, an after-sale order data processing unit and a cost processing unit, wherein:

the order data processing unit is used for calculating income cost according to the order data;

the after-sale bill data processing unit is used for taking the corresponding refund amount as the deduction item of the income cost to participate in calculation according to the refund caliber selected by the user;

and the expense processing unit is used for acquiring data from each expense source table as expenses through the expense item value-taking scheme based on an expense value-taking scheme set by a user in the parameter definition module, and calculating and generating the operation profit table.

According to one embodiment of the system for rapidly generating the profit-and-profit statement of the electronic commerce and the enterprise, in the after-sales order data processing unit, under the condition that the user selects the refund caliber to be counted in real time according to the order, data in the actually-generated after-sales order is set as after-sales data for reducing the income cost; under the condition that the user selects the refund caliber to be counted by a pre-estimated value, calculating the estimated refund rate according to the actual range selected by the user, and reducing the income cost according to the estimated refund rate; and under the condition that the user selects statistics in a mixed mode, simultaneously participating in calculation in the two modes.

Compared with the prior art, the invention has the following beneficial effects: the system of the invention provides a report form for quickly estimating the operation profits for the user, improves the timeliness and the accuracy of user data analysis, is beneficial to the client to know the operation condition of the enterprise in time and make operation decisions better. In addition, the system of the invention designs different cost processing flows aiming at different cost projects, can be compatible with different service scenes and is more suitable for service practice. Meanwhile, the modes of pre-extraction and the like are included in calculation when the cost occurs, so that the accuracy and the integrity of cost processing are further improved, and the operation data are more reasonable.

Drawings

The above features and advantages of the present disclosure will be better understood upon reading the detailed description of embodiments of the disclosure in conjunction with the following drawings. In the drawings, components are not necessarily drawn to scale, and components having similar relative characteristics or features may have the same or similar reference numerals.

Fig. 1 is a schematic diagram illustrating an embodiment of the system for rapidly generating the electric business and enterprise profit-moist report according to the present invention.

Detailed Description

The invention is described in detail below with reference to the figures and specific embodiments. It is noted that the aspects described below in connection with the figures and the specific embodiments are only exemplary and should not be construed as imposing any limitation on the scope of the present invention.

Fig. 1 illustrates the principle of an embodiment of the system for rapidly generating the electric business enterprise profit-moistening report according to the present invention. Referring to fig. 1, the system of the present embodiment includes: the system comprises a parameter self-defining module and an operation data processing module.

The parameter self-defining module is used for defining various parameters, and the parameters comprise: refund caliber, estimated refund rate, expense item value scheme and the like. The user can select the refund caliber according to the refund progress through the parameter self-defining module, and can also set different expense item value-taking schemes according to the properties of different expense items.

In the selection of the refund caliber, statistics according to a mixed mode (the estimated value statistics is combined with the order real-time statistics), statistics according to the estimated value statistics and order real-time statistics can be selected. For the pre-evaluation statistical mode, in an actual service scene, a recent payment order has refund possibility, but actual refund does not occur, in order to quickly estimate the profit of recent transaction, a user uses the refund rate of a period of history as the estimated refund rate, and on the premise of considering the timeliness of data, the data accuracy is improved.

In the aspect of setting the expense item value scheme according to the property of the expense item, because different customer services are different and the individual difference between the expense item and the service content is large, in order to better meet the requirements of different customers, the system provides the user to set the expense value scheme (the expense value scheme is a profit list item in the transverse direction and is listed as an expense source (the expense source comprises daily account, a pre-proposed bill, system acquisition expense and the like), whether the expense enters a current scheme report form and an entering mode is determined by checking the profit list item and the expense source, and a plurality of expense value schemes can be configured according to different service conditions), so that the expense can be better valued according to the property of the profit item.

Examples are as follows: for the daily expenses in the stores, the expenses can be recorded by a journal mode (journal: information such as the expenses manually registered by the user, the remarks for removing money and the like, a profit list item (the profit list item is an expense item configured by the user in a customized classification mode, contains codes and characters, is similar to an accounting subject, supports multiple stages, such as main items and detailed items), a expense generation object store, a listing mode and the like) such as the promotion expenses generated by the stores and the like; for the fee of post-settlement of the order following such as the bill issue fee, the fee can be pre-paid by a pre-bill drawing mode (the pre-bill is used for generating fee pre-drawing, for example, a certain proportion of commissions are generated in order deal, and commission fee can be automatically calculated and generated by a formula configuration of the order deal amount multiplied by the commission proportion); for a multi-store merchant, part of the fees are generated uniformly and need to be distributed among the stores, and the fees can be distributed in a public fee distribution mode (public fee distribution: for example, monthly hydropower fees need to be distributed in 3 sub-organizations (for example, stores) of the merchant, and the fees can be automatically calculated and generated into an inquiry report according to a fixed amount or proportion or the respective order amount of the stores), such as hydropower fees and house rents. For the bill following occurrence, namely the consumption of payment of the commission fee and the like, the value can be selected to be taken along with the order form.

The operation data processing module is used for acquiring order data, after-sales order data and expense data, wherein the expense data comprises daily accounts (user records), pre-bill-drawing (user configuration), public expense allocation (user configuration), platform expense data (cleaning in bill data), express delivery expense, consumable expense and other data generated by the ERP system according to user configuration rules, other data imported by a user and the like. The operation data processing module takes the payment amount data in the order as income according to the structure of an accounting profit list (income-cost-expense as profit), takes the refund amount (defined according to parameters) in the after-sales list or calculated by the refund rate as income deduction items, simultaneously automatically obtains corresponding cost price from a commodity data list according to the commodity details in the order and the after-sales list as cost and cost deduction items, obtains data from each expense source list as expense through the value-taking scheme of the expense items, calculates and generates an operation profit list for timely reference analysis, wherein the operation profit list comprises income, cost, expense and operation profit (similar to the profit structure of an accounting report, namely income-cost-expense), the profit report can be displayed according to day, and can be displayed according to a single platform or multiple platforms (the platform refers to Taobao cat, Jingdong, Tokyo, and the like operation profit) Multiple sets, etc.) single shop or multiple shops are displayed together, and the expense data can be generated according to different value schemes configured by users and listed in rows by profit list items.

The operation data processing module comprises an order data processing unit, an after-sales order data processing unit and a cost processing unit.

The order data processing unit calculates revenue costs based on the order data, typically by order pay time statistics. The order data processing unit provides the revenue cost that the user can inquire about the payment order generation by a certain day (e.g., yesterday).

And the after-sale bill data processing unit takes the corresponding refund amount as the deduction item of the income cost to participate in calculation according to different refund calibers selected by the user. In this embodiment, the after-sales order data processing unit performs corresponding statistics according to the refund caliber selected by the user in the parameter customization module: if the user selects the refund caliber to be counted in real time according to the order, the after-sales data for reducing the income cost is the data in the actually generated after-sales order; if the refund caliber selected by the user is counted by the estimated value, the income cost is reduced according to the estimated refund rate after the refund rate is estimated according to the actual range selected by the user; if statistics in a mixed mode is selected, the two modes participate in the calculation at the same time.

The expense processing unit obtains data from each expense source table as expenses through the expense item value-taking scheme based on an expense value-taking scheme (such as daily account, pre-bill, public expense allocation, system acquisition expense and the like) set by a user in the parameter definition module, and calculates and generates an operation profit table for timely reference analysis. The system acquisition costs include those from: the method comprises the steps that the order delivery express delivery cost calculated according to express delivery freight calculation rules in an ERP system is automatically obtained and generated into a report; platform cost (the cost in each platform bill in the system) is the cost classified and summarized processing of the bill automatically pulled by the system after the system obtains the right for the authorized bill interface of the merchant, or the classified and summarized processing of the bill imported by the merchant.

While, for purposes of simplicity of explanation, the methodologies are shown and described as a series of acts, it is to be understood and appreciated that the methodologies are not limited by the order of acts, as some acts may, in accordance with one or more embodiments, occur in different orders and/or concurrently with other acts from that shown and described herein or not shown and described herein, as would be understood by one skilled in the art.

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

The various illustrative logical blocks, modules, and circuits described in connection with the embodiments disclosed herein may be implemented or performed with a general purpose processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other programmable logic device, discrete gate or transistor logic, discrete hardware components, or any combination thereof designed to perform the functions described herein. A general purpose processor may be a microprocessor, but in the alternative, the processor may be any conventional processor, controller, microcontroller, or state machine. A processor may also be implemented as a combination of computing devices, e.g., a combination of a DSP and a microprocessor, a plurality of microprocessors, one or more microprocessors in conjunction with a DSP core, or any other such configuration.

The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied directly in hardware, in a software module executed by a processor, or in a combination of the two. A software module may reside in RAM memory, flash memory, ROM memory, EPROM memory, EEPROM memory, registers, hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art. An exemplary storage medium is coupled to the processor such the processor can read information from, and write information to, the storage medium. In the alternative, the storage medium may be integral to the processor. The processor and the storage medium may reside in an ASIC. The ASIC may reside in a user terminal. In the alternative, the processor and the storage medium may reside as discrete components in a user terminal.

In one or more exemplary embodiments, the functions described may be implemented in hardware, software, firmware, or any combination thereof. If implemented in software as a computer program product, the functions may be stored on or transmitted over as one or more instructions or code on a computer-readable medium. Computer-readable media includes both computer storage media and communication media including any medium that facilitates transfer of a computer program from one place to another. A storage media may be any available media that can be accessed by a computer. By way of example, and not limitation, such computer-readable media can comprise RAM, ROM, EEPROM, CD-ROM or other optical disk storage, magnetic disk storage or other magnetic storage devices, or any other medium that can be used to carry or store desired program code in the form of instructions or data structures and that can be accessed by a computer. Any connection is properly termed a computer-readable medium. For example, if the software is transmitted from a web site, server, or other remote source using a coaxial cable, fiber optic cable, twisted pair, Digital Subscriber Line (DSL), or wireless technologies such as infrared, radio, and microwave, then the coaxial cable, fiber optic cable, twisted pair, DSL, or wireless technologies such as infrared, radio, and microwave are included in the definition of medium. Disk (disk) and disc (disc), as used herein, includes Compact Disc (CD), laser disc, optical disc, Digital Versatile Disc (DVD), floppy disk and blu-ray disc where disks (disks) usually reproduce data magnetically, while discs (discs) reproduce data optically with lasers. Combinations of the above should also be included within the scope of computer-readable media.

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

Claims

1. The utility model provides a system for generate moist report form of electric business enterprise profit fast which characterized in that, the system includes parameter custom module, management data processing module, wherein:

the parameter self-defining module is used for defining parameters, and the defined parameters comprise a refund caliber, a pre-estimated refund rate and a cost item value scheme, wherein the parameter self-defining module is used for setting different cost item value schemes according to the properties of different cost items;

the operation data processing module is used for acquiring order data, after-sales order data and expense data, taking the payment amount data in the order as income according to the structure of the accounting profit table, taking the refund amount in the after-sales order or calculated by the estimated refund rate as income deduction item, meanwhile, according to the commodity details in the order and the after-sales order, the corresponding cost price is automatically obtained from the commodity data table and is used as a cost and cost reduction item, obtaining data from each expense source table as expense through an expense item value-taking scheme, calculating to generate an operation profit table, wherein the operation profit list is displayed by day, by single platform or multiple platforms, and by single shop or multiple shops, the fee data is generated according to different fee item value schemes configured by users and listed by profit list items, the profit list item is a fee item configured by user-defined classification, and the item comprises codes and characters;

wherein the operation data processing module comprises an order data processing unit, an after-sale order data processing unit and a cost processing unit, wherein:

the expense processing unit is used for acquiring data from each expense source table as expenses through the expense item value-taking scheme based on an expense value-taking scheme set by a user in the parameter definition module, and calculating and generating an operation profit table; the method is characterized in that a user sets a cost dereferencing scheme by himself, wherein the cost dereferencing scheme is characterized in that the profit list item is arranged in the transverse direction, the expense source is arranged in the column, whether the expense enters a current scheme report form or an entering mode is determined by checking the profit list item and the expense source, and a plurality of cost dereferencing schemes can be configured according to different business conditions;

in the after-sales order data processing unit, under the condition that a user selects a refund caliber to be counted in real time according to an order, data in an actually generated after-sales order is set as after-sales data for reducing income cost; under the condition that the user selects the refund caliber to be counted by a pre-estimated value, calculating the estimated refund rate according to the actual range selected by the user, and reducing the income cost according to the estimated refund rate; and under the condition that the user selects statistics in a mixed mode, simultaneously participating in calculation in the two modes.

2. The system for rapidly generating the profit-cleared statement of electric business enterprises according to claim 1, wherein the parameter customizing module selects the refund aperture according to the refund progress.

3. The system for rapidly generating the profit-cleared statement of electric business and enterprise according to claim 1, wherein the charge data acquired by the business data processing module comprises daily accounts, pre-bill, public charge sharing, platform charge data, express delivery charge and consumable charge generated by the ERP system according to user configuration rules, and user import data.

4. The system for rapidly generating the electric business enterprise profit-profit sharing form according to claim 1, wherein the operation profit form includes income, cost, expense and operation profit.