Definition:
The definition of report retrieval formula is based on the relationship between report and account book, items in report, and report and other systems. Computerization of accounting is a key step to realize automatic processing of report data. The retrieval formula mainly solves the data source of accounting statements and automatically calculates and generates the data of various items in accounting statements.
Common formula definitions mainly include:
(1) Use the accounting function to extract data from the account.
Generally, there are functions to retrieve amount data, such as opening balance, current amount, accumulated amount and ending balance, and there are also accounting functions to retrieve quantity data. When defining these functions, you usually need to specify the corresponding account code, accounting period, amount direction, account set and other parameters.
(2) Use statistical or mathematical functions to obtain numbers.
Such as counting function, summation function, average function, maximum function, minimum function, etc.
(3) Calculate and read data directly. This kind of data calculation is mainly aimed at some general addition and subtraction items, such as subtotal, total, etc., and directly uses the expressions of combined units and operation symbols.
Use the formula wizard to define the operation steps of fetching formula:
Steps:
The first step is to select the cell for which you want to define the data retrieval formula.
Step 2, execute the formula wizard function and enter the formula wizard interface.
Step 3, according to the guidance of the formula wizard, set the data source and data retrieval conditions of the project item by item.
Step 4: After setting according to the guidance of the wizard, click OK to return to the report operation interface.
Step 5: Automatically generate the formula for fetching data according to the set conditions, and display it in the formula editing bar.
Step 6: Click OK to define the formula in the formula editing column into the selected cell, and the retrieval formula is successfully defined.
Precautions:
In manual mode, report data is calculated and filled in manually by the preparer according to relevant accounting data. Under computerized accounting, the report module processes data through predefined formulas and automatically generates report data.