My inventory balance does not match Cin7's inventory balance. What do I do?

I'm trying to reconcile my accounts, and my Cin7 inventory balance doesn't appear to match my Xero balance. How do I go about finding the problem?

Answer

After diligently keeping your Cin7 account in line, it can be really frustrating to find your inventory doesn't balance between Cin7 and Xero!

We get asked this question a lot, and there are some simple things you can do to problem solve why there is a mismatch.

1) First, make sure you have imported everything into Xero, using the Xero module

It probably goes without saying, but unless you have imported all your transactions to Xero, Cin7 will never balance with Xero. So make sure you have visited the Xero module and imported Contacts, Suppliers, Sales Orders, Purchase Orders, Credits, Adjustments and COGS.

2) Make sure you have followed end of month good practice.

At the end of each month there are some simple checks and balances you can follow to keep your account ship-shape. All of which is outlined in our End of Month document. This will tidy up your Cin7 account and make sure you are balancing to a tidy account.

Still doesn't match? Next we need to use a report to problem-solve.

3) Use the Stock On Hand Xero Reconciliation Report 

This can be found in the Standard Reports module, from the Accounts Admin menu, called Stock On Hand Xero Reconciliation. This report will show, month by month, Purchase Orders, COGS and Stock Adjustments that have happened.

It may not be enough just to look at these values - more than likely you will need to compare the line items in this report with the line items in Xero. The best way to do this is find the earliest month that stock doesn't balance between the two systems, and download the CSV file of Purchases, Adjustments and COGS. In a spreadsheet copy and paste these values, and the values from a similar export from Xero, and compare line by line. This is easiest done by sorting each list from smallest value to largest value. If you're a bookkeeper you'll know the drill.

You're looking for discrepancies - for instance maybe someone has coded a Purchase in Xero to your Stock on Hand account that wasn't entered into Cin7. Small things like this can really confuse things.

It will really pay dividends to keep on top of all of this on a monthly basis - saving it all for the end of financial year is a really good way to stress yourself out!

If you've tried all of the above and still have questions, please contact support and let them know what you've tried in order to figure out the problem, we'll be happy to set you on the right track.

8/21/2017 - Daniel