Create Your Sales Receipt Template Google Docs for Government Effortlessly

Sales receipt template google docs for Government

in this tutorial I will show you a simply and fully functional POS system using Google sheet [Music] as you can see here the search function is very useful it will automatically collapse the list of items upon search and there is an order status [Music] I am currently making transaction ordering in items [Music] foreign [Music] restrictions to avoid system errors just like this assuming we ordered more quantity than the current stocks here is what happens [Music] foreign [Music] now let's check all the ordered items in customer order sheet and the total price on customer order sheet there is cancel new transaction and done buttons you can cancel by item by deleting the row also you can cancel all of the ordered items by clicking the cancel button and all of them will be back or available to stocks in POS dashboard I applied also a restrictions here to avoid system errors such as you can't do another transaction if there is an ongoing transaction [Music] of course maybe a receipt is needed after transaction you can print it on the receipt sheet by pressing Ctrl p [Music] allow me to pause you for a moment if you reached in this part of my video it seems that you like it please give me a favor by liking this video And subscribe thank you and appreciate your support [Music] after transaction all of the ordered items and transaction details will be automatically saved in transaction sheets also on inventory sheet the ordered items will be subtract in available stocks here you can add more stocks and new item [Music] let's add new item and see that the item will be automatically added also in POS dashboard [Music] foreign [Music] foreign [Music] that's all if you like a copy please like this video and comment below don't forget also to subscribe to my channel for more tips and tricks thanks for watching see you in my next video [Music]