What is the balance sheet?
The balance sheet reflects the accounting statements of all assets, liabilities and owners 'equity conditions of all assets, liabilities, and owners' rights in a certain date (such as the end of the month, the end of the quarter, and the end of the year). "This balance formula, according to certain classification standards and a certain order, appropriately arranges the specific items of assets, liabilities, and owners' equity of a specific date. It shows that the economic resources owned or controlled by an enterprise at a specific date, the existing obligations and owners of the owner of the net assets are required.
How to prepare a blank template for balance sheets?
1. Fill in the list directly: Fill in the list according to the general account subject.
2. Calculating column: Calculate the list based on the balance of the general account subject.
3. Calculate the column: Calculate the list based on the balance of the detailed account subject.
4. Calculating analysis: Calculate the column based on the analysis of the balance of the general ledger subject and the detailed account subject.
1: Multi -condition count
Requirements: The number of people who are produced by the statistical and statistical departments and are mainly operated by their posts
The formula is:
= Countifs (B2: B9, F2, C2: C9, G2)
In the statistical condition area of the Countifs function, the number of cells that meet multiple specified conditions. The conventional usage is:
= Countifs (Condition area 1, specified condition 1, condition area 2, specified condition 2 ...)
2: Condition search
The VLOOKUP function has always been the existence of Volkswagen's lover. The syntax of the function is:
Vlookup (Who wants to find, where to find, return the content of the first column, find it precisely or approximate)
To check what positions of the employee name in the F5 cell.
= Vlookup ($ F $ 5, $ B $ 1: $ D $ 10, 2,0)
When using this function, you need to pay attention to the following points:
1. The 4th parameter is generally found in accurate matching by 0 (or fasle).
2. The column number in the 3rd parameter cannot be understood as the actual column number in the worksheet, but the specified column of the return value in the search range.
3. If the data type of the finding value is inconsistent with the data type of the data area, the error value will be returned.
4. The search value must be located in the first column in the query area.
The blank template of the balance sheet is a very practical form, and most of them are used in the form. If you just need the asset -liability table blank template, come and download it. also,Provincial government centralized procurement directory,Invoice signing statistical formIt is also a good software, please click to download the experience!
it works
it works
it works