Exporting Accounts Data from TAS V3

This document will help you extract the data from TAS V3. To learn how to import the data see the Importing Accounts & Balances document.

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

Important things to remember:

• We don't import historical transactions (other than outstanding invoices)
• Once you have started running transactions in Brightpearl, 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 Brightpearl, 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 Brightpearl. 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 Brightpearl 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 Brightpearl.

Importing the Data to Brightpearl

Learn about importing