Custom Chart of Account Service

Custom Chart of Account Service

Customising my Chart of Accounts 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.
This service is only available to Jet Convert Partners.  To see if you are eligible please email solutions@jetconvert.com.

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 695 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

You will be directed via email to your conversion status page where you will be able to browse and select this .csv file.
      
Once you have uploaded the .csv file you will be navigated to the mapping screen. Here you will see:
  1. The unmapped accounts on the left-hand side.
  2. Your uploaded accounts with accounts that have been auto mapped highlighted in green.
  3. An area where you can drag accounts that you can’t map, but want to be created in Xero e.g. a bank account.
  4. If you have report codes in the CSV they will also be converted however reporting name does not convert.
To map accounts just drag the unmapped account/s to the appropriate account on the right. You can also change account type and tax code at this stage.
Once all accounts have been mapped, click the green Start button and your conversion will commence. It takes up to 3 business days to complete the conversion from here.
      
Following the conversion, your Action Checklist will contain details of how the Accounts were mapped.
  


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: 
Option 1: Review & Map accounts - Please see here for assistance 
Option 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 come across in the conversion regardless of their status. This is because there may be transactions associated with these accounts. If you have accounts that you do not want to use you can ...

    • 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 ...

    • Custom Conversions

      Not every file is going to fit into one of our packages, so for this, we can complete custom conversions on a case by case basis. We want to make your life simpler by helping you make the move to Xero therefore we have listed a range of custom ...

    • Updating the Chart of Accounts in Xero

      The Chart of Account information can be updated post-conversion. The most efficient way to update this information is in bulk. This includes exporting the chart of accounts from Xero, updating the details and re-importing this information back into ...

    • Bank Account Mapping

      Bank Account Mapping is available with Insight and Accelerate Packages. Under the Standard Package we convert the chart of account based on the account type in the source file - for example: Bank Account, Credit Card, Paypal - Will be set up as such ...