(1) Sales revenue
The "Product Sales Revenue" account accounts for the revenue generated from the company's sales of products, including finished products, self-finished products, industrial services, etc.
(2) Cost of sales
The “Product Sales Cost” account accounts for the costs of finished products, self-made semi-finished products and industrial labor services sold by the enterprise.
(3) Sales expenses
The “Product Sales Expenses” account accounts for the expenses incurred by the company in the process of product sales and other processes.
(4) Sales tax
"Product sales taxes and surcharges" account accounting should be composed of sales taxes and surcharges borne by sales of products, provision of industrial services, etc.
(5) Other business income
"Other business income" account accounts for the company's other sales or other business income other than product sales.
(6) Other business expenses
"Other business expenses" account accounts for the cost of non-industrial service income such as material sales, technology transfer, fixed asset leasing, packaging leasing, and transportation related to other business income items.
1. Find duplicate content formula: =IF(COUNTIF(A:A,A2)>1, "Duplicate", "").
2. Use the year and month of birth to calculate the age formula: =TRUNC((DAYS360(H6, "2009/8/30", FALSE))/360,0).
3. Calculation formula from the birth year and month of the entered 18-digit ID number:
=CONCATENATE(MID(E2,7,4),"/",MID(E2,11,2),"/",MID(E2,13,2)).
4. To let the system automatically extract the gender from the entered ID number, you can enter the following formula:
=IF(LEN(C2)=15, IF(MOD(MID(C2,15,1),2)+1."Male","Female), IF(MOD(MID(C2,17, 1),2 )=1,"Male","Female")) "C2" in the formula represents the cell where the ID number is entered.
Product sales quarterly table templateIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Statement of Income and Expenditure,Detailed income structureDownload to get the source file, which you can edit, modify and replace. To download the product sales quarterly table template, go to Huajun Software Park.
it works
it works
it works