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
• You cannot have the same contact both a customer and a supplier in Pearl. If you have this situation in TAS, you'll need to amend the CODE and COMPANY NAME for the customer/supplier in the relevant import files so that Pearl creates two unique contacts.
• Save files as CSV from your TAS system.

First up, prepare your files:

	Trial Balance Go to Nominal » Reporting » Print Trial Balance Choose the current financial year Starting period 0 and Ending period 12 Include zero balance lines and year-to-date figures Choose to print to disk Click OK, and save it as "TB134" somewhere you can find it later
	Customers Go to Sales » Customer reports » Export Customer details Check all the options match those on the screenshot to the left. Click Export and save the file as "Customers" in the same place that you saved the Trial Balance
	Suppliers Go to Purchases » Supplier reports » Export Supplier  details Check all the options match those on the screenshot to the left. Click Export and save the file as "Suppliers" in the same place that you saved the Trial Balance
	Debtors report Go to Sales » Sales Ledger Report » Print Aged Debtors report Check all the options match those on the screenshot to the left (Use today for the Aged Debt Date) Choose to print the file to Disk Save it somewhere handy. It will probably be called "TB3242.csv"
	Creditors report Go to Purchase » Purchase Ledger Report » Print Aged Creditors report Check all the options match those on the screenshot to the left (Use today for the Aged Creditor Date) Choose to print the file to Disk Save it somewhere handy. It will probably be called "TB3342.csv"

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

Import step 1 : Setting up the Opening Trial Balance

1. Visit Home » Welcome page
2. Click to upload your Chart of Accounts from TAS 3
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.

Import step 2 : Customers

1. Visit Home » Welcome page
2. Click to upload your Customers/Contacts from TAS 3
3. Brwose for your customers file
4. Import the file!

Import step 3 : Suppliers

1. Visit Home » Welcome page
2. Click to upload your Suppliers from TAS 3
3. Brwose for your customers file
4. Import the file!

Import step 4 :  Debtors (Customer balances)

1. Visit Home » Welcome page
2. Click to import Debtors/Creditors from TAS 3
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.

Import step 5 : Creditors (Supplier balances)

1. Visit Home » Welcome page
2. Click to import Debtors/Creditors from TAS 3
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 :)

Here's what the TAS sample company Debtors looks like once it's in Pearl: