Custom Chart of Accounts Service

Custom Chart of Accounts 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

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



After the source data has been fullt extracted you will be directed via email to your conversion status page where you will be able to browse and select your .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 ...

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

    • How do I delete accounts in Xero that I don't need?

      Xero allows you to both delete and archive accounts in the "Chart Of Accounts". We find that it is better to archive accounts instead of deleting them since this function allows you to restore the account if ever needed in the future. We recommend ...

    • Using Xero

      Paid Bill or Invoice Showing an Amount Due You may find that an invoice/bill is showing as unpaid even though there should be $0 amount due. All of your reports are displaying the correct balances but when you view this particular invoice/bill it ...