Skip to Content
FORENSIC RECONCILIATION GUIDE

How to Fix Unleashed Stock on Hand vs. Xero Balance Sheet Drift

The step-by-step forensic guide for UK Financial Controllers, Finance Directors, and Xero accountants facing un-reconciled inventory variances at month-end.

The 4 Root Causes of Stock-to-Ledger Drift

1. Manual Journals to Xero Account 630

Bookkeepers or external accountants posting write-offs, supplier invoices, or opening adjustments directly into the Xero Inventory Asset account without a matching Unleashed stock adjustment.

2. Stuck Integration Dashboard Queue

Transactions silently failing to export from Unleashed due to archived Xero tracking categories, closed accounting periods, or tax mapping errors.

3. Negative Stock Sales (MAC Distortion)

Dispatching orders before purchase receipts are completed forces Unleashed into negative stock with estimated costs, creating un-synced retrospective cost variances.

4. Landed Cost Date Mismatches

Freight and customs duty invoices allocated in Unleashed across previously sold stock post into Xero with differing transaction dates, breaking month-end cut-offs.

Kontroll's 5-Day Month-End Lock Protocol

Day Action Item Responsible Role Output / Deliverable
Day 1 Dispatch Cut-Off & Queue Purge Warehouse Ops Zero pending dispatches in Unleashed
Day 2 Integration Dashboard Error Audit Finance Manager All stuck journals exported to Xero
Day 3 Negative Stock & Landed Cost Clearance Inventory Controller Negative stock SKUs returned to >= 0
Day 4 Reconciliation Run: SOH vs Account 630 Financial Controller Variance isolated to exact transactions
Day 5 Reversing Journal & Xero Lock Date Set Finance Director General Ledger locked; clean audit trail
FIXED-PRICE 48-HOUR DIAGNOSTIC

Unleashed + Xero Stock-to-Ledger Sync Audit

Stop losing days every month-end. Our certified Scottish specialists forensically reconcile your historical transaction log, eliminate negative stock distortions, and provide exact reversing journals.

£495 + VAT
| 100% credited against future systems sprints or migrations
Book 48-Hour Sync Audit
Registered Office: 5 South Charlotte Street, Edinburgh, Scotland, EH2 4AN (SC654061) · +44 131 454 9051 · hello@kontroll.co.uk

Frequently Asked Questions

The divergence typically stems from four root causes: manual journals posted directly to the Xero inventory account, stuck transactions in the Unleashed export queue, negative stock sales distorting moving-average COGS, and mismatched landed cost transaction dates.

When items are sold with zero or negative stock recorded, Unleashed defaults to temporary or estimated costs. When the actual supplier PO arrives later at a different cost, historical journals are not automatically retrofitted in Xero, leaving an unreconciled valuation gap.

We recommend a strict 5-day month-end cut-off: clear the Unleashed Integration Dashboard queue, execute physical cycle counts, post reversing reconciliation journals, and set the Xero Period Lock Date to prevent manual entries.

The 48-hour fixed-price audit analyzes transaction logs, reconciles Stock on Hand valuation against Xero GL Account 630, identifies negative stock items, and delivers exact reversing journal entries.

Yes. Kontroll credits 100% of the £495 audit fee against any subsequent remediation package, systems optimization sprint, or Odoo 19 migration.