0 1

Spreadsheet is a commonly used office software, which is relatively easy to operate. So we choose spreadsheets to make computer ledgers. First, we enter the spreadsheet software interface and make the title name of the computer general ledger.

02

After naming the computer account book, we set the number of the computer account book.

03

After setting the serial number of the computer ledger, we add the user or department of the computer ledger. This setting makes it easy to find the current location of the computer.

04

Set the brand of the computer after setting the user department of the computer ledger. With the brand of computer, you can find computers by category.

05

After setting the brand of the computer, set the factory code of the computer. This factory code is the unique identification code of the computer.

06

After setting the factory code, set the computer model. According to the model of the computer, you can find the model parameters of the computer.

07

After setting the computer model, set the purchase date. The purchase date is used for reconciliation of the financial department.

08

After setting the purchase completion date, set the purchase amount. The purchase amount is convenient for the financial department and the asset management department to record.

09

After setting the purchase amount, set the user. It is convenient to record the use and storage of computer assets.

10

After setting up users, set up asset management department. Asset management department is the key to physical inventory with users.

1 1

After all the above settings are completed, we enter the computer equipment. Through the completion of computer information input, a preliminary computer ledger management is formed.

Special tips

Spreadsheet has the function of query and classification, which is convenient for managing computer ledger.