1. Open the Excel office software. First, we enter the name and content (that is, the header) of the inventory/in and out inventory report.

2. Below the beginning inventory, incoming inventory, outgoing inventory, and inventory, the quantity and amount must be indicated.

3. Select the beginning inventory, right-click Insert and select Insert 1 column. Fill in the quantity and amount,

4. Then merge and center the two cells of the beginning inventory.

5. In order to beautify the table, we can frame the content part and center all the text horizontally.

6. Merge and center the cells at the report name.

7. Add quantity and amount items to the incoming inventory, outgoing inventory, and inventory according to the steps of the beginning inventory.

8. Then merge cells for other items. The report is basically completed.