Tips for using private kindergarten account details
Private kindergarten account detailsHow to fill it out?
The first point is that the names of the subjects in the detailed accounts need to be established in accordance with the accounting system regulations and the existing management system of the enterprise. If the accounting system has clear restrictions on the name of a certain detailed account, we should follow the county official’s rules when establishing the detailed accounts. If there is no clear fixed account name, we also need to establish the account name based on the principles of accounting regulations and refer to the existing management needs of the enterprise.
Second point, there are three main formats of subsidiary accounts, three-column format, multi-column format and quantity-amount format. When we create a subsidiary account, we need to set up the corresponding style of the subsidiary account according to the needs of property and material management.
The third point is that in order to facilitate the use and reordering of account pages, most detailed accounts are in the form of loose-leaf account books. Since the account pages summarized in loose-leaf accounts are often scattered, we need to bind the detailed accounts into a volume in a timely manner.
General tips for private kindergarten account details form 1:SUM function (mathematics)
In daily work and study, SUM is an extremely widely used function and can be learned as an entry-level function. Therefore, overall, the SUM function is not difficult but has a wide range of applications. But don’t underestimate SUM just because it is simple. It also has some little-known tricks! 1. Cumulative sum as shown below, which is the sales performance of a certain company every day and requires the calculation of the daily cumulative amount.
For example, enter the formula in cell D2: =SUM(C$2:C2), press the Enter key to complete and fill downwards.
Note: At this time, C$2 must lock the row mark, so that a reference area from the second row to the downward row will be generated during the pull-down process.
2:Sum with qualified cells
The sum of merged cells has always been a troublesome problem for novices.
Select the cell range D2:D13, then enter the formula in the formula editing bar: =SUM(C2:C13)-SUM(D3:D14), and then press Finish. Note: Be sure to pay attention to the range of the second SUM function. Misplaced, otherwise an error will be reported.
3: Sum of cells with subtotals
How to sum cells with subtotals? In cell C9, enter the formula: =SUM(C2:C8)/2 and press Enter to complete.
The process of subtotaling and summing are used here to repeatedly calculate the above data, so dividing by 2 can get a non-repeating result, which is exactly the desired result.
Recommended by the editor of Huajun Software Park
Private kindergarten account detailsIt is a very practical form, and most of the forms to be filled in are for general purposes. If you happen to need a detailed account statement for a private kindergarten, please download it quickly. also,Financial plan fund comparison statistics table,work scheduleIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works