End of month procedures
Overview
There are some simple tasks you can complete in order to keep your Cin7 Omni account in good shape and balanced with your accounting integration. Ideally these tasks are done once a month.
Check for sales orders errors
If there is an issue with a Sales Order, it will not be imported into your accounting integration 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:
From the left navigation, select Accounting then your integration (e.g. Xero dashboard or QuickBooks Online dahsboard).
From the main tab section select the Error tab, select Invoices subtab.
Check dispatched sales orders
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'.
Check that all sales orders are imported
Go to your accounting integration and look at the import list to double-check that all Sales Orders have been imported into your accounting integration (Xero or QuickBooks Online).
Check purchase order errors
Like with Sales Orders, Purchase Orders will also receive errors if there are issues when importing to your accounting integration. Like above, filter for Xero or QuickBooks errors.
Check purchase orders are fully received or backordered
If you have paid for part of some orders, make sure you create a back order in Cin7 Omni, 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 Omni, but if it is not imported to Xero it will not increase the Inventory Account there.
Learn how to Back Order items by viewing our Creating a Back Order for Purchases article.
Import credit notes
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.
Approve auto-adjustments
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 integration.
Import all adjustments
It is important to import adjustments into your accounting integration - if there are adjustments values in Cin7 Omni that are not recorded, you will never be able to balance your inventory.
Check for unclosed registers
If you - or your staff - have forgotten to Close the register for a day or multiple days you'll have payments in your accounting integration that haven't been applied to an invoice.
To find out if you have missed any Close Registers:
From the Left Navigation, select Sales, then Close Register.
-
In the Close Register module, change the date to span from as far back as necessary to today.
If you see any transactions that haven't been closed, note down the dates of these transactions.
Filter again by the specific days of your unclosed transactions to close each of those missing days as you normally would.
If you find any unclosed registers, remember to import the resulting payment batches to Xero after closing them.
Import monthly COGS
Finally, make sure you have updated all your COGS. Cin7 Omni makes regular updates to a monthly COGS journal.
Make sure you have updated all COGS before attempting to balance your accounting integration with Cin7 Omni. Check the COGS journal is dated at month end to ensure all transactions have been included.
Find out how to sync COGS with Xero and sync COGS with QuickBooks Online.
FAQs
Where can I find an Account Receivable report in Cin7 Omni?
Cin7 Omni has a report called Sales Invoices with Payment Owing which shows a list of Sales Orders that have been imported to your accounting system and have no payment allocated to it.
To view the Sales Invoices with Payment Owing Report:
From the left menu, click Admin & Reports.
Click on Standard Reports.
Under the Finance Section of the reports.
Click on Sales Invoices with Payment Owing report.
Please ensure to click on the Update Paid Invoice link in your Accounting software prior to looking at this report.