• Contents

Setting up Alternative GL Accounts

Last updated 21/11/2021

Alternative General Ledger (GL) Accounts can be used to refine how your Sales Orders are imported into Xero.

Overview

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.

Creating Alternative GL Accounts

To create an Alternative GL Account:

  1. Take note of the account code in your Xero chart of accounts.
  2. Log in to Cin7 as an Administrator.
  3. Click on your name, top right, then click Settings.
  4. From the Accounting Menu, click Alternative GL Accounts.
  5. Select Add New.
  6. Fill in the fields, as per the reference below.
  7. Click Update.

Field Reference

Field Required? Description
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.