Last updated 21/11/2021
When you configure your Xero integration, you will choose one default revenue account to which you will import sales.
It is likely that you use more than one revenue account. In Cin7 you can set up Alternative GL Accounts, and apply them in different ways to achieve more detailed accounting.
This article explains how to set up Alternative GL Accounts and then how to use them.
Tracking codes can also be added for further detail - these are explained in a separate article - Setting up Tracking Categories and Locations.
To create an Alternative GL Account:
|Active||Yes||Controls whether the Alternative GL Account is active. Choose between On or Off.|
|Sort||Yes||The number by which the accounts will be sorted. This affects the positioning of the option when it shows in Cin7's dropdown list.|
|Name||Yes||The Name that will appear in the Cin7's dropdown list to select this code. It makes sense to make this the same as the Account name in Xero.|
|Account Number||No||The Xero account code. If blank the default account will be applied to the transaction.|
|COGS Account Number||No||If you would like the COGS for sales with this Alternative GL Account applied to be put in an account other than the default COGS account, enter the Xero account code here.|
|Tracking Categories Name||No||Add a Tracking Categories Name to apply Xero Tracking to sales with this Alternative GL Account applied. The text must match the Tracking Categories name in Xero exactly. For more information see Setting up Xero Tracking Categories.|
|Tracking Categories Option||No||Add a Tracking Categories Option to apply Xero Tracking to sales with this Alternative GL Account applied. The text must match the Tracking Categories name in Xero exactly. For more information see Setting up Xero Tracking Categories.|
|Xero Tax Types Codes||No||If a tax rate applies that is different to the default system tax rate, then you must enter it here. The code must be taken from the Tax Type Column in Xero's Documentation. For example: for Tax on Sales, enter 'OUTPUT'.|
|Purchases or Sales||Yes||Choose which type of transaction this Alternative GL Account should apply to. Setting it to Sales will have this option available in Sales Orders and Credit Notes, if you select Purchases this option will be available in Purchase Orders and Supplier Credit Notes.|
|Tax Rate||No||This is the percentage tax rate that should be applied to sales that have this Alternative GL Account applied. For 15% enter '15'. If blank, the default system tax rate will be applied.|
We really appreciate your feedback.