The specific operation steps are as follows:

1. Enter the material name, date, issue, receipt and balance information in the first line. As shown in the figure:

2. Use the formula = receipt quantity+receipt quantity+? -Number of issues.-Number of issues? , enter a good formula and click Enter. For the following materials, just drag and drop the lower left corner of the calculated balance cell to generate the same formula.

Remarks: As long as the information such as material name, stock-in and stock-out information is clearly written in the general warehouse inventory form, it can be seen at a glance, and the purpose of making the form has been achieved.