Last updated 12/01/2021
If there is an issue with a Sales Order, it will not be imported into your Accounting System and instead cause an 'error'. It's good practice to fix all errors as soon as they occur, but some may have slipped through the net.
To find orders that have caused an error:
If the explanation of the errors and how to solve them is unclear, search our help articles.
It goes without saying that if you have dispatched goods, you'll want to invoice your customers as soon as possible. It is worth checking however that there are no orders that have been dispatched without being invoiced. These can be found by changing the Status filter to 'Dispatched but not Invoiced'.
Once you've checked your Sales Order list, just double-check that all Sales Orders have been imported into Xero - this can easily by found by going to the Xero module and looking at the figure in brackets next to the Import Orders link.
For more information see Importing Sales Orders to Xero.
Like with Sales Orders, Purchase Orders will also receive errors if there are issues when importing to your Accounting System. Common reasons for this are due to tax rates or exchange rates being inconsistent between Cin7 and your Accounting System. Like above, filter for Errors.
Have you only partially received some orders? If you have paid for part of some orders, make sure you create a back order in Cin7, allowing you to close off the received part of an order and leave the rest of the items in an Open order.
A partially received Purchase Order will increase your inventory in Cin7, but if it is not imported to your Accounting System it will not increase the Inventory Account there.
Learn how to Back Order items by viewing our Creating a Back Order for Purchases article.
Have all Credit Notes been completed correctly and imported? These transactions are often overlooked but they may alter your inventory account.
When the stock has been returned into the Inventory, make sure the Credit Note reflects this.
More information on Credit Notes can be found in the Credits section.
If you use the Point of Sale, auto-adjustments may have been created for you to account for stock errors. For more information on this see our Auto Adjustments article. Approve all auto-adjustments and import them to your Accounting System.
It is important to import adjustments into your Accounting System - if there are adjustments values in Cin7 that are not recorded in your Accounting System, you will never be able to balance your inventory.
If you - or your staff - have forgotten to Close the register for a day or multiple days you'll have payments in your Accounting System that haven't been applied to an invoice.
To find out if you have missed any Close Registers:
If you find any unclosed registers, remember to import the resulting payment batches to Xero after closing them.
Finally, make sure you have updated all your COGS. Cin7 makes regular updates to a monthly COGS journal; more information in our article Cost of Goods Sold (COGS).
Make sure you have updated all COGS before attempting to balance your Accounting System with Cin7.