First, make the details of the purchase receipt document in the excel table, and input the text content. The details can be adjusted as needed.

Then make the purchase price correspond to the purchase in the table. If tax is included, the price and tax can be charged separately.

Then do the bill details, and you can summarize the bill quantity and amount on a monthly basis.

You can add the summary of "Inventory Balance" on the right side of the month, and deduct the number and amount of accounts from the entered inventory.

end

abstract

Make the details of the purchase receipt document in the excel table, enter the text content, and then make the purchase price corresponding to the purchase in the table.

Then make a detailed bill. You can summarize the invoiced quantity and amount by month. You can add "Inventory Balance" summary on the right side of the month, and deduct the invoiced quantity and amount from the entered inventory.