Last updated 03/01/2019
Once you have created your Alternative GL Accounts, and applied Tracking Categories, you will need to decide how to assign them.
The ultimate goal here is to set up a logical system so that the line items you import into Xero are coded to the desired accounts and tracking categories.
You will find documented below each possible way of automating Alternative GL Account assignments. It is also possible to manually override Alternative GL Accounts, and we have documented this as well.
Because it is only possible to assign one Alternative GL Account to a line item, Cin7 has a system of prioritization, explained at the bottom of this page.
You can apply Alternative GL Accounts to individual products. To do this you must have first turned on the accounting options for the product page. To do this:
To add an Alternative GL Account to a product:
When adding a product with an Alternative GL Account to a transaction, the specified account will automatically appear in the Account column of the line item.
You can apply Alternative GL Accounts to individual customers or vendors.
When adding a customer or vendor with an Alternative GL Account to a transaction, the specified account will automatically appear in the Alternative GL Account dropdown in the Customer details of the transaction.
This means that unless otherwise specified, all products within this transaction will be coded to the customer's Alternative GL Account.
You can apply Alternative GL Accounts so that sales from different branches are coded to corresponding branch accounts within Xero. This is particularly useful if you have multiple retail stores.
To apply an Alternative GL Account at a branch level:
Each sale is coded based on the branch. This happens at the time of import - so unlike products or contacts above, it is not visible in the actual transactions. Branch level Alternative GL Accounts are applied unless otherwise defined at the customer or product level. See priorities below.
You may choose to assign Alternative GL Accounts manually at the time of sale, either to override automatic assignments or just to apply the Alternative Accounts on a case by case basis.
There are two places you can do this:
To apply an Alternative GL Account to an entire order, click on the Alternative GL Accounts dropdown and choose from the list. This will send all line items in the order to a specific account unless and line item accounts have been chosen (see below).
In a transaction, you can choose an Alternative GL Account for each line item by clicking into the Account column and then selecting from the dropdown list that appears.
When an Alternative GL Account is applied in multiple places, the GL Account that is ultimately applied is decided by the priority below (1 being the highest):
Let's say you have assigned Customer X to the GL Account '222'. You also assigned Product Y to GL Account '333' prior to this. When you sell Product Y to Customer X account '333' will be applied, because ultimately the line item has a higher priority.
This may happen if your account names are too long; the best thing to do is use a naming scheme that allows you to easily see the right account from the first few characters e.g. "1 - Retail Sales". The account name in Cin7 is unrelated to Xero's account name so can be anything you like.