Fix discrepancies with Xero

Fix discrepancies with Xero

Overview

Find out what causes discrepancies between Cin7 Omni and Xero and how to fix them.

Discrepancies are difference between Cin7 Omni and Xero. There are two main types:

  • Discrepancies in totals

  • Discrepancies of voided transactions

If you have discrepancies, you’ll see a red badge on the Discrepancies tab on your Xero integration dashboard – you’ll find sales order discrepancies listed on the Sales Order Discrepancies subtab and purchase order discrepancies on the Purchase Order Discrepancies subtab.

Since either Omni or Xero will be inaccurate, you must fix discrepancies promptly to keep your records straight. You may need to log in to Omni as an administrator or unlock closed financial periods in Xero.

Fix discrepancies in totals

A discrepancy in totals is a difference in the total of a sales or purchase order in Cin7 Omni and its matching invoice or bill in Xero.

For example, when the tax rate of a sales order doesn’t match the tax rate of its invoice, or when a line item’s unit cost on the purchase order doesn’t match its unit cost on the bill, the totals will differ and create a discrepancy.

On the Discrepancies tab of your Xero integration dashboard, discrepancies in total say Totals Differ in the Discrepancy column. The total difference is shown in the Difference column and each exact total is given in the Cin7 Omni Total column and Xero Total column.

Most discrepancies in totals are caused by having manually changed details on either transaction, such as:

  • Tax rates

  • Discounts

  • Exchange rates

  • Unit quantities

  • Unit costs or prices

To fix a discrepancy, review every factor in the transactions’ totals in Omni and Xero. Update either Omni or Xero so the totals are the same. Save your changes and then refresh your Xero integration dashboard.

Fix discrepancies of voided transactions

Discrepancies of voided transactions are caused when a Xero invoice or bill that matches an Omni sales or purchase order gets voided. These discrepancies say Voided in Xero in the Discrepancy column on the Discrepancies tab of your Xero integration dashboard.

To fix such a discrepancy, you must void the matching sales or purchase order in Omni.

Optionally, you can then recreate and resync the sale or purchase order:

  1. Open the voided sale or purchase order.

  2. Select Go To Admin.

  3. From the Actions menu, select Create New Version A, B, C.

  4. Apply payments (if any).

  5. Select Approve.

  6. Sync the sale or sync the purchase with Xero.

Fix other discrepancies

Other types of discrepancies, such as transactions having different invoice dates, aren’t listed on the Discrepancies tab but may show up in reports. You must fix these too.

Was this article helpful?

Have more questions? Submit a request