Reconciliation processes and reports
Overview
Get an overview of processes and reports for reconciling Cin7 Omni with Xero or QuickBooks Online.
Processes for reconciliation
1. Close registers
If you use Cin7 POS, check that you haven’t forgotten to close any of your registers and close them if you have:
From the Sales menu in the navigation, open Close Register.
-
Set the Date filters to:
Type: Payment
Start date: 1st of this month
End date: Today
Select Search.
If you have any results, then you’ve not closed the register on the dates in the Payment Date column. For each date you didn’t close the register:
-
Set the Date filters to:
Type: Payment
Start date and end date: Date you didn’t close the register
Select Search.
Select Close Register and OK to confirm.
Find out more about closing the register.
2. Approve auto-adjustments
Check that no auto-adjustments from your point of sale (POS) are left open. If they are, review and approve them. Find out more about auto-adjustments.
3. Backorder incoming stock
The value of your inventory should match in Omni and Xero or QuickBooks Online.
The value of your Omni inventory, though, depends on the goods you’ve received, while the value of your Xero or QuickBooks Online inventory depends on the goods you’ve paid for.
So, if you’ve paid for only part of a purchase order, you need to create a backorder for the remaining units. Then you can mark the original as
Find out how to create backorders.
4. Check transactions
Your sales orders, credit notes, purchase orders, and supplier credit notes must meet certain conditions for Omni and Xero or QuickBooks Online to keep in sync. Perform these checks each month to find and fix transactions causing discrepancies:
5. Fix sync errors
Transactions that fail to sync to Xero or QuickBooks Online are moved to the Errors tab of your accounting integration’s dashboard. In order to resync these transactions, you must fix the errors first.
Find out how to fix sync errors.
6. Sync transactions
Lastly, sync pending transactions on your Xero or QuickBooks Online integration dashboard:
From the Accounting menu in the navigation, open your Xero or QuickBooks Online integration dashboard.
-
For each tab with transactions to sync (that is, with a red badge):
Open the tab.
-
On each subtab:
Select all transactions.
Select Upload All.
Reports for reconciliation
COGS Breakdown
The COGS Breakdown report shows you the transactions that factor into your cost of goods sold (COGS) in Omni. Use this report to find and fix anomalies causing discrepancies with Xero or QuickBooks Online.
Find out more about the COGS Breakdown report.
Historic Stock Valuation
The Historic Stock Valuation report shows you the stock on hand, the carrying value, and the inventory value of each product in your inventory at any point in time. Use this report to find historical stock levels and valuations in Omni to compare with Xero or QuickBooks Online.
Find out more about the Historic Stock Valuations report.
Stock on Hand Reconciliation
The Stock on Hand Reconciliation report shows you the value of your stock on hand in Omni, as well as the transactions that debited or credited your stock on hand during the current period. Use this report to reconcile your Omni inventory with Xero or QuickBooks Online.
Find out more about the Stock on Hand Reconciliation report.
Sales Orders and Credit Notes
The Sales Orders and Credit Notes report lays out data from your sales orders and credit notes. Use this report to find and fix anomalies causing discrepancies with Xero or QuickBooks Online.
Find out more about the Sales Orders and Credit Notes report.
Purchase Orders and Supplier Credit Notes
The Purchase Orders and Supplier Credit Notes report lays out data from your purchase orders and supplier credit notes. Use this report to find and fix anomalies causing discrepancies with Xero or QuickBooks Online.
Find out more about the Purchase Orders and Supplier Credit Notes report.
Checklists for reconciliation
Download these checklists to keep on hand during reconciliation: