Accounts receivable statistics table

(1) All credit sales business should be logged into the detailed ledgers of relevant customers correctly, timely and in detail, and the credit status of each customer should be reflected at any time. If necessary, special sales journals can be set up to reflect the credit sales situation;
(2) The entire process of credit sales business should be divided into divisions of labor, such as registering detailed accounts, filling in credit bills for credit customers, delivering or mailing bills to credit customers, and handling cash received by customers, etc. Special personnel should be assigned to take charge;
(3) The detailed accounts should be reconciled with the general ledger on a regular basis.

​​ 1. Sum: =SUM(K2:K56) Sum the area from K2 to K56;
2. Average: =AVERAGE(K2:K56) Find the average of the area K2 K56;
3. Ranking: =RANK(K2,K$2:KS56) ranks the results of 55 students;
​​ 4. Level: =IF(K2>=85, "Excellent", IF(K2>=74, "People", IF(K2>=60, "Pass", "Fail")))
5. Semester overall evaluation: =K2*0.3+M2*0.3+N2*0.4 Assume that column K, column M and column N respectively store the three grades of students: "usual overall evaluation", "midterm" and "final";
​ ​ 6. Highest score: =MAX(K2:K56) Find the highest score in the K2 to K56 area (55 students);
​​ 7. Minimum score: =MIN(K2:K56) ——- Find the lowest score in the K2 to K56 area (55 students);

The accounts receivable statistics table is a very practical form, and most of the forms are for general purposes. If you happen to need to download the Excel form of the accounts receivable statistics table, please download it quickly.Work log sheet,Interview evaluation formIt is also a good software. Welcome to click to download and experience it!