Importing Data

Introduction

Business Accountz allows you to import data from third party sources (such as Excel or legacy book keeping app) in the form of CSV (Comma Separated Values) files.

You can also import bank and credit card statements files in the following formats:

  • CSV (Comma Separated Values)
  • QIF (Quicken Interchange Format)
  • OFX (Open Financial Exchange)

Selecting the right Import Wizard

Business Accountz has separate import wizards depending on what you are trying to import.

You can access these wizards by going to the ‘File->Import’ menu option.

The import wizards available are:

Foreign Currency Statement

If you have bank accounts held in a foreign currency and would like to import statements from them you can do so using this wizard.

The import wizard is made up of the following steps:

  1. Choose the data file you wish to import
  2. Specify the account the statement is for
  3. Label the columns of your import file Optional Step - might not be needed
  4. Specify date format in file Optional Step - might not be needed
  5. Define ‘From|To|Other Account’ values found in import file
  6. Specify default values
  7. Preview data to be imported

In step 2 you will be asked to specify the currency that the statement is in, then in step 6 you will need to specify the exchange rate between the currency you selected and your base currency in the ‘Currency Rate’ field. This exchange rate will then be used for converting all transactions to the base currency. You can if you wish alter the ‘Currency Rate’ value for individual transactions in the preview screen or after import if required.

Sales Data

If you have historic sales data and can save it in CSV format you can import it into Business Accountz.

As a minimum your data must have the following columns defined:

  • Date
  • Account From
  • Account To
  • Total Amount
  • VAT code

The import wizard is made up of the following steps:

  1. Choose the data file you wish to import
  2. Label the columns of your import file
  3. Specify date format in file Optional Step - might not be needed
  4. Define ‘VAT Code’ values
  5. Define ‘From|To|Other Account’ values found in import file
  6. Define ‘Customer’ values Optional Step - might not be needed
  7. Specify default values
  8. Preview data to be imported

Transfers Data

If you have historic transfer data in CSV, QIF, or OFX format you can import it into Business Accountz.

As a minimum your data must have the following columns defined:

  • Date
  • Account From
  • Account To
  • Total Amount

The import wizard is made up of the following steps:

  1. Choose the data file you wish to import
  2. Label the columns of your import file Optional Step - might not be needed
  3. Specify date format in file Optional Step - might not be needed
  4. Define ‘From|To|Other Account’ values found in import file
  5. Define ‘Customer’ values Optional Step - might not be needed
  6. Define ‘Supplier’ values Optional Step - might not be needed
  7. Specify default values
  8. Preview data to be imported

Purchases Data

If you have historic purchase data and can save it in CSV format you can import it into Business Accountz.

As a minimum your data must have the following columns defined:

  • Date
  • Account From
  • Account To
  • Total Amount
  • VAT code

The import wizard is made up of the following steps:

  1. Choose the data file you wish to import
  2. Label the columns of your import file
  3. Specify date format in file Optional Step - might not be needed
  4. Define ‘VAT Code’ values
  5. Define ‘From|To|Other Account’ values found in import file
  6. Define ‘Supplier’ values Optional Step - might not be needed
  7. Specify default values
  8. Preview data to be imported

Journal Data

If you have historic journal data and can save it in CSV format you can import it into Business Accountz.

As a minimum your data must have the following columns defined:

  • Date
  • Account
  • Amount From (Credit)
  • Amount To (Debit)

The import wizard is made up of the following steps:

  1. Choose the data file you wish to import
  2. Label the columns of your import file
  3. Specify date format in file Optional Step - might not be needed
  4. Define ‘From|To|Other Account’ values found in import file
  5. Specify default values
  6. Preview data to be imported

Products

If you have existing product data and can save it in CSV format you can import it into Business Accountz.

As a minimum your data must have the following columns defined:

  • Name

The import wizard is made up of the following steps:

  1. Choose the data file you wish to import
  2. Label the columns of your import file
  3. Define ‘VAT Code’ values Optional Step - might not be needed
  4. Define ‘Currency’ values Optional Step - might not be needed
  5. Specify default values
  6. Preview data to be imported

Customers

If you have existing customer data and can save it in CSV format you can import it into Business Accountz.

As a minimum your data must have the following columns defined:

  • Name

The import wizard is made up of the following steps:

  1. Choose the data file you wish to import
  2. Label the columns of your import file
  3. Define ‘Country’ values Optional Step - might not be needed
  4. Define ‘From|To|Other Account’ values found in import file Optional Step - might not be needed
  5. Specify default values
  6. Preview data to be imported

Suppliers

If you have existing supplier data and can save it in CSV format you can import it into Business Accountz.

As a minimum your data must have the following columns defined:

  • Name

The import wizard is made up of the following steps:

  1. Choose the data file you wish to import
  2. Label the columns of your import file
  3. Define ‘Country’ values Optional Step - might not be needed
  4. Define ‘From|To|Other Account’ values found in import file Optional Step - might not be needed
  5. Specify default values
  6. Preview data to be imported

Other Import (Bank/Credit Card Statement)

If you can download statements from your on-line bank or credit card provider you can import them into Business Accountz using this wizard.

This wizard only supports importing statements for your base currency. If you have a statement from a foreign bank or credit card please use the Foreign Currency Statement import wizard instead.

The import wizard is made up of the following steps:

  1. Choose the data file you wish to import
  2. Specify the account the statement is for Optional Step - might not be needed
  3. Label the columns of your import file Optional Step - might not be needed
  4. Specify date format in file Optional Step - might not be needed
  5. Define ‘From|To|Other Account’ values found in import file
  6. Specify default values
  7. Preview data to be imported