Import the chart of accounts

Before you can import chart of accounts, you must

• Have a new Accounting business with no transactions or records.
• Have your chart of accounts file saved in comma separated value (CSV) format.
• Use the same column headings and formatting as in the chart of accounts CSV template file.

See Import your chart of accounts

Import customer and supplier records

1. Go to Contacts then on the New Customer drop down, click Import Customers.
2. Click Choose File to locate the file exported from Sage 50, then click Open.
3. On the CSV Format list, choose Sage Instant Accounts. use this for importing from both instant and sage 50.

Click this option if you’re also importing from Sage 50 Accounts.

4. Click Upload.
5. Go to Contacts then on the New Supplier drop down, click Import Suppliers.
6. Repeat steps 2 to 3.

Import products and services

1. Go to Products & Services then on the New Item drop down, click Import Items.
2. Click the relevant option depending on what item types you exported from Sage Accounts, for example, Stock.
3. Click Upload your CSV file then browse to the relevant file you exported earlier, then click Open.
4. Repeat steps 1 to 3 for any other product or service types you have.

Import customer and supplier opening balances

Before you start

Check the following in your exported csv file

• Transaction Reference.

  The reference for the transaction is compulsory.

  Open the CSV file and enter a reference in Column D for any missing references, such O/BAL

• Date format. 

  Make sure the date is in dd/mm/yyyy format

Things to consider:

• Cash Basis VAT scheme

  For VAT registered EU customers or suppliers or contacts outside the EU, the VAT rate defaults to No VAT and the gross value appears in the Net and Total columns.

  This is because VAT on these transactions is accounted for when you create the invoice not when you receive or make the payment.

  If you haven’t yet accounted for the VAT in Sage 50 or Instant, manually adjust your next VAT Return to include the necessary values.

• Your tax codes are automatically matched to those in Sage Accounting

  
  If you’ve amended the tax codes in Sage 50 and Instant, change the VAT rate for the relevant transaction.

• Changing your imported opening balances

  If you change any values when importing opening balances, your trial balance in Sage Accounting may be different to your trial balance from Sage 50 or Instant.
  When entering your nominal opening balances, choose where to post the difference. For example, you may want to post it to Corrections.

Import your customer and supplier opening balances

Enter your other opening balances

Bank opening balances

1. From Settings, then Business Settings, select Opening Balances.
2. Choose Bank.
3. Select the relevant bank account and enter your details.

You may need to create additional bank accounts before you can select them. See Add or edit a bank account

• See Enter an opening balance for a bank account

Nominal ledger opening balances

1. From Settings, then Business Settings, select Opening Balances.
2. Select Nominal Ledger.
3. Choose New Opening Balance, then enter the relevant information.

More Opening balances

[BCB:299:UKI - Personal content block - Dane:ECB]
[BCB:302:UKI - Search override - Accounting UK:ECB]
[BCB:276:UKI - hide back button:ECB]

Step 6 - Check your imported data