• Blog / Cloud Bookkeeping Blog /

• How to account for wastage, breakage and write-offs in Vend POS and Xero integrated systems

Sometimes inventory amounts need to be adjusted without making a sale due to write-offs, breakage, wastage or consumption of your own inventory. This blog post is created for people that are running Vend POS and Xero integration, and from time to time need to do stock level adjustments. We at aVers are using the following procedure as Vend and Xero synchronise stock level information.

Go to main menu then to Products then to Stock Control

Click Inventory Count

Click + New Inventory Count

Count name will be created out of Outlet Name, Start Date and Time. You can edit start date and time if it needs to be adjusted. Please add the type of adjustment at the end (e.g. wastage).

Select Partial Count, it will allow you to choose particular products or product categories that need to be adjusted.

In this example, we will choose product type ‘Pies’. Then click Save.

Now you can go product by product to adjust the new count, or you can use a barcode scanner.

Change the quantity to the updated number to reflect the breakage, shrinkage or wastage, and click Count.

When you finished adjusting the stock, click Review Count.

Now you can go through all tabs to ensure that it all makes sense. When you are finished, click Complete and then Submit.

Then click Create CSV Report and Download CSV Report.

Please email the file to aVers Bookkeeping team (accounts@avers.com.au). We will run a little script programmed by our team on the file in order to turn it into journal adjustment in Xero for you.

IMPORTANT: Your purchase price needs to be accurate in Vend in order for the adjustment to work accurately in Xero.

Subscribe by email and instantly get FREE Illustrated eBook. Adequate ‘positive’ cash flow is essential for the survival of any business, yet this is something that over 50% of small business owners struggle to manage.