This article has moved to a new home. View the updated version

How does Xero interact with Neto Inventory?



Summary of transactions between Neto & Xero

Below is the list of transactions that can be made between the platforms.

Purchases

Neto Xero
Purchase Order Fully Received Draft Bill (Purchase)
Supplier Adding supplier in Neto adds the supplier as a contact in Xero. The contact will be marked as a supplier when you purchase from that supplier to create and complete a purchase order

Inventory

Neto Xero
Stock Adjustments Stock Journal, A journal is created in Xero. These journals are created in the form of a Bill with the total balance of 0, i.e. Debit expense 100 and Credit inventory 100
Cost Revaluation Manual stock adjustment of type cost revaluation is pushed across Xero as stock adjustment.
Stock take A journal is created in Xero. These journals are created in the form of a Bill with the total balance of 0.

Sales

Neto Xero
Completed sale order Draft Receivable (Sales) and a Stock Journal to account for COGS. i.e. Debit COGS 100 and Credit inventory 100
Customers If you are using batching to send the invoices and payments from Neto to Xero, then it will be exported to one customer in Xero and if batching is off then customer from Neto is created in Xero when sale invoice is exported.
Credit A credit note for the customer is created in Xero but you need to manually apply overpayments / credits that have been applied to invoices in Neto to related invoices in Xero.

Integration between Neto and Xero

Neto Xero
Purchases are created in Neto for a stock value and quantity. They are in sent or fully received status in Neto. Once in Sent or fully received, a bill is sent to Xero depending on the configuration. This is both for the reconciliation of payment and the Xero stock on hand account, which updates with the stock value. Note: Value of stock will be created in inventory asset when the bill is created in Xero.
Invoices are raised in Neto for sales. Once sales invoices are completed, the stock is removed from Neto and an invoice is sent to Xero; this is used for the payment reconciliation. And a COGS (Cost of Goods Sold) journal is sent, which moves the stock value sold from your Stock on Hand account to your Costs of Goods Sold account.
Suppliers and customers are created/updated in Neto. You can also import customer and supplier data into Neto from Xero. You can import customers / suppliers from Xero to Neto.

Reconciling Neto and Xero

If the values in the Stock on Hand asset in Xero is different to the Stock Valuation Report in Neto, then simply follow each step outlined below in order:

  1. Look at when the two values last matched.

  2. Ensure transactions from Neto are processed in Neto and approved in Xero. From the Neto dashboard, you will see your failed exports. You can check the export log for more information. Inside Xero you will need to make sure all your Accounts Payable / Purchase drafts from Neto are approved.

  3. If it is not matching by now, then you should run a ‘Account Transactions’ report inside Xero for your Stock on Hand account. Every single transaction being made to this account should be from Neto so anything being posted from elsewhere will cause a variance. The report can be found under ‘All Reports’ in Xero

  4. If you still find the discrepancy, then kindly check the export log in Neto and make sure there are no errors and if there is any missing transaction then you need to re-export the data from Neto to Xero

  5. If these steps do not help in finding the variance, then you may need to make an adjustment in Xero and monitor the balances going forward. To make sure you have the right stock figure do a stock-take in Neto and confirm the costs are correct. Once you have done that you can run a stock valuation report and get the correct stock figure. You can then make the relevant changes in Xero to make them match up.


  • Last Modified: 28/09/2017 Neto Version: 6.8