How to do the warehouse receipt and issue accounting document?

1, create a new worksheet, and enter the contents of the inventory account into the table.

2. Merge and center the cells with the heading "Inventory" to enter and exit the table. Font changed to Song Ti, 20 and bold.

3. Merge and center the cells where "Last month's balance, this month's collection, this month's issue and this month's balance" are located.

4. Put all the words in the middle.

5. Add a border to the whole table.

6. Add the formula "Amount = Quantity * Unit Price" to the amount. The form has been completed. Save it.