Consolidate transactions on export to Xero
Cin7 Core allows monthly and daily consolidation of sale invoices/credit notes, payments, COGs journals, and money tasks for your connected sales channels. This helps to avoid processing limitations from Xero.
Important information
(Amazon users only) If Xero sync mode on Amazon setup is Sync individual sales, sales from Amazon can still be consolidated from Xero integration. If Xero sync mode on Amazon setup is Consolidate as settlement report, this will take priority over consolidation settings of Xero integration (this will not affect consolidation modes for other sales channels). Please see Handling Amazon Settlement Fees and Charges for more information.
In daily consolidation mode, Cin7 Core will consolidate the available invoices and credit notes. etc at the time the sync is executed for that specific day. In the case of more transactions occurring on the same day after the sync and consolidation, these will be consolidated into another document for the same day.
In monthly consolidation mode, Cin7 Core will not sync any consolidate documents to Xero until it is the end of the current month. Auto and manual sync will continue to sync any other related transaction data that does not fall within the consolidation mode.
Product reference data will always be synced to Xero regardless of consolidation mode. Customer contact data can be optionally synced to Xero.
Cin7 Core supports consolidating sales invoices and credit notes with different exchange rates. The average exchange rate for all the transactions over the consolidated period will be used for the consolidated invoice or credit note.
Supplier deposits cannot be consolidated. Customer credits will be consolidated as payments if used to make payments for sale invoices, or consolidated as money tasks if used as prepayment or created via a refund.
If Customer credits were used to make payments for sale invoices - then this transaction will be created as a payment
Create money credits through a refund in sale or prepayment - then this transaction will be created as money task
Cin7 Core does not support consolidating purchase invoices, service purchases, purchase credit notes and payments related to purchases.
Enable consolidation
You need to enable consolidation on export before you can see any other consolidation options.
Select Integrations from the main menu, then Xero.
Go to Consolidate on export.
Enable Xero summary details to display consolidation options.
Consolidate sale invoices and credit notes
You can consolidate sale invoices and credit notes for a sales channel daily, monthly, not at all, or turn off channel sync.
All sale invoices and credit notes from selected sales channels for the consolidated period, that have the same date or month, currency, tax inclusive/exclusive indicator and store will be joined into a single invoice or credit note.
Consolidated documents are exported to Xero on synchronization with the name format "SO-<Date>/<Month>-<ShopType>(<ShopName>)-<UniqueNumberForThisDateShopTypeAndShopName>". E.g.: "SO-2019/04/26-Shopify(MyShop)-1".
Select Integrations from the main menu, then Xero.
Go to Consolidate on export, then Consolidate sale invoice and credit notes.
Select consolidation period.
Add one or more sales channels to consolidate.
-
Select a grouping mode to summarize transactions for reconciliation:
- By account: All sales (products, services and additional charges) are grouped into a single invoice line item and single credit note line item based on the account, unit price equals the total invoice value of consolidated invoice/credit notes for the period.
By products and services: Sale invoice and credit note lines during the consolidation period are grouped according to the product or service SKU (additional charges will have their own SKU line). This is the default grouping option.
By product category: Sale invoice and credit note lines are grouped according to product categories. A single invoice/credit note is created for the consolidation period consolidating all transactions and grouping the invoice/credit note total by product category. Additional charges will displayed on a separate line.
By Xero tracking category: This grouping option requires Xero Tracking Categories. If a transaction has a tracking category, it will be grouped into an invoice line for that tracking category. Transactions that do not have a tracking category will be consolidated under a generic line item All sales - Products or All sales - Services.
Save your changes.
Sync customer contacts
Product reference data and supplier contact details will always be exported to Xero with any consolidation method. You can choose if you would like to also export customer contact details.
Select Integrations from the main menu, then Xero.
Go to Consolidate on export, then Consolidate sale invoice and credit notes.
-
Select your customer contact sync option:
Enable Sync customer contacts to sync contact details related to customer contacts.
Disable to use a single contact, Cin7 Core sales consolidation, for all consolidated sales exported to Xero.
Cin7 Core will always export supplier contact references to Xero regardless of grouping method or consolidation mode.
Consolidate payments
You can consolidate payments for a sales channel daily, monthly, not at all, or turn off channel sync. The payment consolidation period cannot be greater than the sale invoice consolidation period.
Payments with the same currency, date/month, and account are grouped together.
Once consolidated payment transactions have been synced with Xero, you will not be able to make any changes to documents or sales.
Select Integrations from the main menu, then Xero.
Go to Consolidate on export, then Consolidate payments.
Select consolidation period.
Add one or more sales channels to consolidate.
Save your changes.
Consolidate journals
You can consolidate journals daily, monthly, not at all. You can also turn off channel sync for COGs journals.
Select Integrations from the main menu, then Xero.
Go to Consolidate on export, then Consolidate journals.
Select consolidation period.
Add one or more sales channels to consolidate.
Choose how to consolidate your journal entries:
All journals: All COGS transactions will be consolidated into a single journal per sales channel. All other journal entries with the same currency, date/month, are exported to Xero as a single journal entry for the consolidation period. (purchase manual journals, assembly journals, etc.).
Only COGS journals: All COGS transactions will be consolidated into a single journal per sales channel. All other journal entries will be synced separately to Xero without consolidation.
Save your changes.
Consolidate money tasks
You can consolidate money tasks (send money, receive money) daily, monthly, not at all.
All money tasks with the same bank account code, date, and tax inclusive/exclusive status are exported to Xero as a single entry for the consolidation period. Cin7 Core does not export money task reference data to Xero for consolidated money tasks.
Select Integrations from the main menu, then Xero.
Go to Consolidate on export, then Consolidate sale invoice and credit notes.
Select consolidation period.
-
Select which money tasks to consolidate:
- Only receive money: Groups all receive money tasks into a single money task. Spent money tasks will be synced separately without consolidation.
Only spent money: Groups all spent money tasks into a single money task. Receive money tasks will be synced separately without consolidation.
Consolidate receive and spent money tasks: Groups both received and spent money tasks into a single task. Task will be receive money if total is positive and spend money if total is negative.
Save your changes.
Editing consolidated transactions
Once a consolidated invoice has been synced do Xero, you can no longer:
edit invoice lines
delete invoice lines
edit additional charges lines
delete additional charges lines
You can:
Add new payment
Change invoice memo
You cannot change or delete payment lines in Cin7 Core after a payment has been synced with Xero.
This is applicable across simple sale, advanced sale, service sale and credit notes.
View and export consolidated transactions
View all consolidated transactions (sale invoice, sale credit note, sale invoice payment, sale credit note refund, COGS (invoice), COGS (credit note), sale manual journal, journal) with the corresponding consolidated transaction number in Xero. Non-consolidated transactions are not shown here, but can be viewed in the Xero sync history. Failed, skipped, or pending consolidation items are not shown on this page.
Select Integrations from the main menu, then Xero.
Go to Consolidate on export, then any tab.
Click View consolidated transactions.
Look for a specific transaction record by typing either the record's document number in Cin7 Core or consolidated number in Xero of the following items in the Search bar. Transactions can also be filtered according to transaction type.
You can click any of the column names on the page to automatically sort the sales records in ascending or descending order. If applicable, click the navigation buttons at the bottom to navigate between pages. Click Export to export this filtered view as a CSV file.