Whilst connected with Xero, when a transaction is completed in Unleashed the integration will trigger the export of a matching transaction to update your Xero accounts accordingly, keeping both platforms aligned.
Purchase Orders will update the "Stock on Hand/Current Asset" account in Xero, except for items categorized under the "Never Diminishing Product Type," which will update a specified Purchase Account.
Sales Invoices will update the "Sales Revenue Account."
Sales Shipments & Adjustments will update both the "Stock on Hand/Current Asset" and "Cost of Goods Sold" (COGS).
The core principle is that stock purchased from suppliers is considered a Current Asset until it is sold. Once sold, the cost of the product is then accounted for as Cost of Goods Sold.
Purchases
A Bill to Pay transaction will be created in Xero as and when a Purchase Order is updated to Receipted or Completed status in Unleashed. Separate Bills to Pay will be created in Xero for each Supplier and Cost Date included on a Purchase Order in Unleashed, and will update the following accounts in Xero:
Transaction in Unleashed | Unleashed update | Transaction in Xero | Xero accounts |
Purchase Order Receipted |
| Creates a Bill to Pay. | When the Bill to Pay is at the Approved or Paid status in Xero, the Stock on hand account's value increases by the receipted stock value. |
Purchase Order Completed (no additional costs) | No change to the receipted stock's quantity or value | No transaction is exported to Xero. | No changes to Xero accounts. |
Purchase Order Completed (includes additional costs) | Stock value increases with a "recost" for the previously receipted stock | Creates a Bill to Pay. | A recost journal is created, increasing the Stock on Hand account's value by the additional cost's value. |
Supplier Return Completed |
| Creates a Bill to Pay (credit). | Stock on hand account's value will decrease, based on the returned product's total change in stock value. |
If Use Receipted Goods on Assemblies is enabled in your Company Settings, additional costs added to receipted component stock will not create a recost journal in Xero, and will result in a variance with Xero's Stock on Hand account. To re-align Unleashed's total Stock Value with Xero's Stock on hand total, create a manual stock adjustment in Xero for the value difference.
Sales
To provide flexibility for your inventory management whilst maintaining accuracy with your financial accounting, each Sales Order's progress is managed in two parts; Invoices and Shipments. Invoices manage the pricing and generated revenue of your Sales Orders and as such will integrate with your Sales account in Xero. Whereas Shipments manage the stock movements and the impact the dispatched stock's value has on your current inventory and business's performance. When dispatched, Shipments will therefore remove value from the Stock on Hand account in Xero and add it to your Cost of Goods Sold (COGS) account.
Transaction in Unleashed | Unleashed update | Transaction in Xero | Xero accounts |
Sales Invoice Completed | Sales Revenue increases | Creates a Sales Invoice. |
|
Shipment Dispatched |
| Creates a shipment journal. |
|
Credit Note Completed (Return unticked) | Sales Revenue decreases | Creates a Credit Invoice. |
|
Credit Note Completed (Return ticked) |
|
|
|
Production
Any time your inventory's total stock value changes based on an internally completed transaction, such as; Assemblies, Stock Adjustments or Stock Counts, a matching journal will be created in Xero to update the Stock on Hand account accordingly.
If an Assembly or Disassembly is completed in Unleashed that does not include any Never Diminishing Product (NDP) components or Supplier Costs, no journal will be exported to Xero as there has been no change made to your total stock value.
Transaction in Unleashed | Unleashed update | Transaction in Xero | Xero accounts |
Assembly Completed |
| No transaction is exported to Xero. | No change to Xero accounts. |
Disassembly Completed |
| No transaction is exported to Xero. | No change to Xero accounts. |
Assembly Completed |
| Creates an Assembly journal. |
|
Disassembly Completed |
| Creates an disassembly journal. |
|
Assembly Completed |
| Creates a Bill to Pay. |
|
Stock Adjustment Completed (quantity and value) |
| Creates an Adjustment journal. |
|
Stock Adjustment Completed (quantity only) |
| No transaction is exported to Xero. | No change to Xero accounts. |
Stock Adjustment Completed (value only) |
| Creates an Adjustment journal. |
|
Stock Revaluation Completed |
| Creates an Adjustment journal. |
|
Stock Count Completed |
| Creates an Adjustment journal. |
|