Custom Change your Chart of Accounts Service

Custom Change your Chart of Accounts Service

Customising my Chart of Accounts as to how it should appear in Xero

With this service, you select how you want the Chart of Accounts to appear in Xero, prior to conversion. The full desktop file history will then present in Xero as though it had been run through this new Chart of Accounts.

Notes
Note : You cannot receive the monthly comparatives option if you choose a custom change your Chart of Accounts service.

Creating the custom or standard Chart of Accounts for Xero

To select the desired custom chart of accounts you need a reference .csv file.
  1. The easiest way is to export a chart of accounts from an existing organisation in Xero and use that as the template.
  2. Alternatively, you can download a template from the Xero website or create your own file from scratch.
    1. Chart of Accounts template for AU
    2. Chart of Accounts template for NZ
    3. Chart of Accounts template for US
  3. If you want to create your own file from scratch then:
    1. The file must be in CSV (Comma Separated Values) format with the extension “.csv”.
    2. If you use Microsoft Excel to create the file then any leading zero’s might be removed from account no’s etc. Make sure you format the columns as text or alternatively use a text editor like Notepad.
    3. Maximum 990 Accounts in file (Including header row).
    4. Need at least the following data columns and in this order:
      1. Code (Max 10 char’s)
      2. Name (Max 150 char’s)
      3. Type (Check Xero Account types) 

Loading & mapping the Chart of Accounts

This option can be selected from the normal package selection page. It will add $150 to the cost of your selected conversion package.

Here is more information with screengrabs on how to load and map your Chart of Accounts.

      
Following the conversion, your Action Checklist will contain details of how the Accounts were mapped.
  


Idea
Tips
  1. Automapped accounts are highlighted in green and manually mapped accounts are highlighted in blue.
  2. You can change or undo any mapping by just dragging it back to the left-hand side.
  3. You can multi-select accounts by using the “Shift” or “Ctrl” keys when clicking.
  4. Using the Tabs at the top of the grid to filter the data, makes it easier to find a specific account.

Can you apply report codes as part of this process?

Not at the moment. Once you have customised the chart of accounts please see the options for adding the report codes post-conversion: 
Idea
Option 1: Review & Map accounts - Please see here for assistance 
IdeaOption 2: Import Report codes - if you have used report codes in another organisation you export and import the report codes. Please see here for assistance. 



    • Related Articles

    • Chart of Accounts

      Chart of Accounts All accounts—including bank accounts—are brought into Xero during conversion, regardless of whether they are marked active or inactive in the source. This ensures historical transactions remain intact. If you no longer need certain ...

    • Custom/Non-standard Tax Codes

      Australia Australian accepted tax codes The image below displays the standard tax codes that are accepted by Xero in Australia: The source file will require adjustments if you have used tax codes that are other than 0 and 10% as Xero does not accept ...

    • Updating the Chart of Accounts in Xero

      Updating the Chart of Accounts in Xero The Chart of Accounts can be updated after conversion, and the most efficient way to do this is in bulk. Simply export the chart from Xero, make your updates, and re-import it back into the system. IMPORTANT ...

    • Custom Conversions

      Oversized Desktop Source Files When uploading desktop files our system will read the file size - this the raw size of the file eg. if it has been zipped or compressed (in QuickBooks and Reckon you can back up as a QBB or QBM these are compressed ...

    • Bank Versus Asset/Liability Accounts

      In Xero if you would like to be able to reconcile an account it needs to be a bank account, you don’t have to have linked bank feeds if not required. As such it is an operational decision whether it is a bank account or an asset/liability account. It ...