Importing from TAS Basic

Importing your accounts from TAS Books

Pearl can import 3 CSV files from your TAS system, so you can start trading in Pearl with minimum hassle

Important things to remember:

  • We don't import historical transactions (other than outstanding invoices)
  • Once you have started running transactions in Pearl, STOP entering into TAS
  • You don't have to switch accounts systems at the end of a year, or even a VAT quarter
  • The Debtors and Creditors import will create contacts with detail address information, but only the customer or supplier total balance. If you need to transfer individual customer or supplier invoices across to Pearl, then ask your accountant for advice.
  • The import matches Customers and Suppliers on the TAS account CODE - eg ABC001
  • Save files as CSV from your TAS system.

 

First up, prepare 3 files:

 

Trial Balance

  1. Go to Accountants » Trial Balance
  2. Choose the current financial year, all periods
  3. Choose the options as shown on the left
  4. Click OK, and save it as "Trial Balance" somewhere you can find it later

 

Customers

  1. Go to File » Export » Customers
  2. Check all six export options
  3. Click Export and save the file as "Customers" in the same place that you saved the Trial Balance

 

Suppliers

  1. Go to File » Export » Suppliers
  2. Check all six export options
  3. Click Export and save the file as "Suppliers" in the same place that you saved the Trial Balance

 

Import TAS suppliers

Now that  you've got all the information you need from TAS, you can just drop the 3 files into Pearl.

Setting up the Opening Trial Balance

  1. Visit Home » Welcome page
  2. Click to upload your Chart of Accounts from TAS
  3. Brwose for your file called "Trial Balance"
  4. Choose to "Delete and rebuild Chart of Accounts..."
  5. Choose to "Import balances..."
  6. Enter a starting invoice number if you like
  7. Import the file!

 

This will bring all balances into Pearl, and set up the Chart of Accounts to match that in TAS. Note that Pearl will transfer the 1100 Sales Ledger Control onto 9997 Debtors opening balance, and 2100 Purchase Ledger Control onto 9998 Creditors opening balance, in preparation for the next steps.

Importing Debtors (Customer balances)

  1. Visit Home » Welcome page
  2. Click to import Debtors/Creditors from TAS
  3. Browse for your "Debtors.csv" file
  4. Choose to yes to create customer records from the customers file
  5. Choose yes to "Add balances..."
  6. Check that "Customers (Debtors)" is set
  7. Import the file!

 

You can check the totals using the Accounts » Customers menu item in Pearl.

Importing Creditors (Supplier balances)

  1. Visit Home » Welcome page
  2. Click to import Debtors/Creditors from TAS
  3. Browse for your "Creditors.csv" file
  4. Choose to yes to create customer records from the suppliers file
  5. Choose yes to "Add balances..."
  6. Check that "Suppliers (Creditors)"  is set
  7. Import the file!

 

All done. Enjoy the power of Pearl :)