Cross-border e-commerce financial data records are an essential part of building a cross-border e-commerce financial system.
(1) Recording methods for product purchases
Product purchase records mainly involve two aspects of data: one is data directly related to the product, including product name, SKU supplier name, purchase price (which may change each time), purchase quantity, and purchase order freight; the other is data related to the operator or department, including the purchase warehouse (which warehouse of the seller the product enters), the purchaser, the purchase date and the expected arrival date, etc. These data can be organized into a relatively clear Excel spreadsheet.
On the one hand, these data faithfully record the generation of each expense and accurately implement these expenses to specific products. For example, the “purchase order freight” refers to the domestic freight spent on purchasing this batch of products, which can be allocated to each inventory product according to the weight of the product; on the other hand, sorting out information such as the purchase date, expected arrival date, and purchase warehouse can effectively help the purchase staff and warehouse staff to make good work connections. In actual operations, many warehouse staff rely on such product purchase record sheets to arrange their work in an orderly manner.
(2) Method of recording logistics costs
The calculation of logistics costs is to record the package number (or order number of AliExpress), weight, destination, transportation method, tracking number and other data, and then calculate the actual freight for each package based on the transportation method (see its freight quotation table), weight and destination. These data can be organized into a “freight record sheet”.
The freight record sheet shown here does not show complicated calculations of international freight. The only thing that may take up a lot of sellers’ time is the process of weighing the package and calculating the freight according to the destination. This work is very inefficient and will become impossible to complete when the number of orders increases if done manually. However, these problems can be solved with the help of third-party tools of cross-border e-commerce.
(3) Method of recording internal transfer of products
In cases such as “sending products to overseas warehouses” or “borrowing products from the warehouse to the art department for photography”, the ownership of the products will not be transferred. At this time, it is necessary to design a “transfer sheet” for these actions as a financial record.