What is the reporting difference between the records in ConnectWise (Inventory Reports) and Xero (Inventory Asset / Transaction Reports).




There are 3 main reporting differences between the records in ConnectWise (Inventory Reports) and Xero (Inventory Assets / Transaction Reports).  These differences consists of:
  1. Picking Dates
  2. Invoices Dates / Purchase Order Dates
  3. Incorrect Receiving / Pre-Selling Inventory

Overview:

Wise-Sync:

Wise-Sync will transact the Inventory Value based on the timing of inventory records being posted.  

There is only one interaction that will reduce (or increase) the stock value in Xero, and that is the posting of Invoices (or Purchase Orders) to Xero.  These are dated based on the parameters set in ConnectWise, such as the Invoice Date or the Purchase Ship Date as per the SUPPLIER-INVOICE process.

Meaning:
The timing of the inventory value is based on the Date, so in Xero, the Value is based on the Purchase Bill Date, and the Inventory Transaction (COGS side) is based on the Invoice Date, as this is the date which the inventory journal is created for.

ConnectWise:

On the other hand, ConnectWise has a myriad of ways that Inventory Value can be constructed.  And NONE of them relate to whether or not the record has been posted to the Accounting System. This provides a way of the processes becoming disconnected from a reporting perspective.

Meaning:
ConnectWise Inventory appears to be valued solely based on the 'Picked Date', regardless of any other related records (Purchase Order / Invoice).


Conclusion:


The only way to reduce the variances is to:
  1. Ensure that the products are received into ConnectWise in a timely manner
  2. Ensure that invoices date (when it was actually generated in ConnectWise) is not changed, as this will have an adverse affect on the reporting of Inventory between periods.

Process:
Processes that could be considered to validate Stock on Hand (as per Xero / ConnectWise) would be to complete a stock take and utilise a special purpose 'Stock Take' warehouse to allow the stock to be correctly accounted for.