How does the librarian do the entry and exit accounts on the computer?

You can make an EXCEL file with EXCEL software installed in the computer system, and then input corresponding data and formulas according to different projects and the date of warehousing. The specific manufacturing method is as follows:

1. Open the EXCEL file on the computer. After entering, enter the file header, such as the entry and exit registration form of a company.

2. Then enter the serial number, project name, date, previous balance, current inventory and other information in the cells below.

3. Then enter basic information such as project name and balance data of the previous period.

4. Enter the formula = (C6+E6+G6+I6+K6+M6)-(D6+F6+H6+J6+L6) in the cell below the current inventory, that is, the current inventory is equal to the previous balance figure plus the daily receipt figure minus the daily delivery figure, thus automatically calculating the daily inventory balance.

5. At this time, input can be made according to the actual receipt/issue figures. The system will automatically calculate the inventory balance of the day.

6. Put the mouse in the cell below the current inventory, and drop down the calculation formula. Other items will be automatically calculated by entering numbers according to the formula settings.