Skip to content
logo Knowledgebase

Import company data into TASBooks

Created on  | Last modified on 

Summary

To save time entering company data such as customer or supplier records into TASBooks, you can import data using a Comma Separated files (*.csv) or a Text (*.txt) file.

Description

You may want to do this for a number of reasons, for example importing information from another system or to save time by importing records as a batch.

Resolution

Records you can import

You can import the following information into TASBooks:

  • Customer records and groups.
  • Supplier records and groups.
  • Product records and groups.
  • Nominal groups.
  • Nominal Chart of Accounts records.

You can also import transactions into TASBooks by following a different process.

 

Before you import

Before you start importing transactions into TASBooks, you must take a backup of your data and have a CSV or TXT file that contains the transactions you want to import.

The import file

You must enter the following information on your file in the correct order.

 

Import your data
  1. From the TASBooks Company Manager, select the company you want to import transactions into.
  2. From the menu bar, click Company, then click Import Data.
  3. Enter the login details of a supervisor user, then click Authenticate, then click Next.
  4. Select the type of import from the drop-down menu.
  5. Click Browse, then locate and select the import file, then click Open.
  6. Click Next.
  7. Enter the delimiter you want to use to separate the fields. For example, a CSV file would use select Comma.
  8. Select First Record Holds Field Names if your file contains a row for headings.
  9. Click Next, enter a name for your mapping, then click Next.
  10. Choose how you want to map each field on the import file in TASBooks. You must map at least the mandatory fields shown at the bottom of the window.
  11. Click Next.
  12. Select how you want the import to proceed if certain situations occur, then click Next.
  13. Click Import.
  14. If required, click View Import Log File to print out the import log.
  15. Click Finish.

 

Bespoke training is available now

Alongside your existing support options within your subscription, you can also purchase bespoke training sessions with a product expert, tailored to your needs.

Find out more

Image