Reconcile with Xero
From the main menu, go to Integration > Integration Store > Xero
Click on Export Data tab
Select the transaction tab you want to review, e.g., Invoices.
Set a date range.
Click Reconcile Transactions. A notification will appear in the top menu bar to confirm when the reconciliation has completed.
Refresh the page.
Reset the date range as previously selected.
Review any transactions that show a non-zero value in the Variance column.
Review any transactions that do not show an Xero hyperlink in the View column
Select Export to manually re-attempt exporting the transaction
🤓 Tip: It is recommended that the above reconciliation process is completed every 1-2 weeks to efficiently keep on track for your end-of-month processes and manage corrections effectively.
Reconcile the receipted stock in assemblies
When the Use Receipted Stock In Assemblies setting is enabled in your Company Settings, it can lead to variances within the Xero Integration when the component product's Stock on Hand reduces to zero before it's Purchase Order is completed. How the Use Receipted Stock In Assemblies functions with the Xero integration is described in the following workflow:
Purchase Order receipted:
A Purchase Order is created and Receipted
The SOH (Stock on Hand) and ALC (Average Landed Cost) for these products are updated, and the Stock On Hand account in Xero is automatically updated accordingly
Assembly completed:
The component products from the receipted Purchase Order are removed from the source warehouse's SOH and used to complete the assembly.
The receipted component product's SOH is now zero.
Additional Costs on the Purchase Order:
Additional Costs are added to the receipted Purchase Order.
The component product is recosted with the Additional Costs, but its ALC is not recalculated whilst there's zero SOH.
Xero Integration:
A Purchase Order Recost Journal is sent to Xero, including the Additional Costs.
This creates a variance as the PO's value increase is now showing in Xero, but the product's SOH value in Unleashed is unchanged.
Important: It is essential to monitor these variances and ensure accurate financial reporting across both platforms.
To reconcile these variances, you can either:
Create a manual adjustment in Xero's SOH account to match Unleashed.
Complete a Stock Revaluation to match Xero's value and delete the subsequently created adjustment journal in Xero.