How To: Financial Setup for EC Customers

Khaos Control supports customers trading within the European Union and allows transactions to be processed in foreign currencies, such as Euros.
To ensure VAT, currency conversions, pricing and financial reporting operate correctly, several areas of the system must be configured. This article explains the settings required to set up an EU customer. The example below assumes the customer trades in Euros (€).

Before You Start

Before creating or updating an EU customer, ensure that:
  • The relevant country exists in the Countries table.
  • The required currency and conversion rates have been configured.
  • Current VAT rates have been set up correctly.
  • Any necessary foreign currency bank accounts have been created.

1. Configure the Customer Record

Customer General Tab

Open the [ Customer | General ] tab and configure the following settings:

FieldSetting
EC CompanyTick this checkbox.
Company pays taxTick this checkbox except in exceptional circumstances.
Tax RefEnter the customer's EU VAT registration number where applicable.

If you are supplying goods to a VAT-registered business in another EU country, entering a valid VAT number may allow the supply to be zero-rated for VAT purposes, provided all relevant conditions are met.

Customer Financial Tab

Open the [ Customer | Financial ] tab and set:

FieldSetting
CurrencySelect Euro (€) or the customer's trading currency.

The currency selected here determines how sales orders, invoices and account balances are processed for the customer.

2. Configure System Data

Open the System Data screen and review the following areas.

Countries

Open Countries and confirm the customer's country has been configured correctly.
EU countries contain settings that determine:
  • Whether VAT applies.
  • Whether the country is treated as an EU Member State for VAT reporting purposes.
Most systems are supplied with the ISO-3166 country list already configured.
These settings would normally only need changing if you are:
  • Creating separate regions or territories.
  • Combining countries into reporting zones.
  • Creating custom country definitions for reporting purposes.

Currency and Conversion Rates

Ensure the following have been configured:
Accurate conversion rates are essential for foreign currency transactions and reporting.

Tax Rates

Check that the VAT rates configured in Tax Rates are up to date.

3. Create a Foreign Currency Bank Account

If you receive payments in the customer's currency, create a matching bank account.
Open:
Then follow:
For example, Euro customers would typically be associated with a Euro bank account.

4. Create a Euro Price List

If you regularly trade in Euros, creating a dedicated Euro price list can help maintain consistent pricing.
Open:
Then:
  1. Create a Euro Price List.
  2. Assign the price list to the customer.

Why Use a Euro Price List?

Without a Euro price list, Khaos Control can still calculate prices using current exchange rates. However, if conversion rates fluctuate regularly, customer pricing may vary between orders.
Using a dedicated price list provides consistent pricing regardless of exchange rate changes.

5. Review Sales System Values

Open:
Review the following options.

Charge All Transactions in Native Currency

This option is normally unticked on new systems.
When enabled:
  • Credit card transactions are processed in GBP.
  • Khaos Control converts the customer's currency into GBP during processing.

VAT Based on Delivery Address

This option is normally ticked on new systems.
When enabled:
  • VAT calculations are based on the delivery country.
When disabled:
  • VAT calculations are based on the customer's country instead.

6. Review Pricing System Values

Open:
Check the following option:

SettingRequirement
Force Sales Order Lowest PriceMust not be ticked.

This setting can affect foreign currency pricing and should remain disabled when using customer-specific currency pricing.

Reporting on EU Sales

You can use Sales Summary to analyse sales by country.
You may also wish to review your sales nominal account structure and reporting setup. For further guidance, see:

Important Notes

Country Configuration

Khaos Control is normally supplied with:
  • ISO-3166 countries pre-configured.
  • A UK zone containing:
    • United Kingdom
    • Guernsey
    • Isle of Man
    • Jersey
To verify the country setup, run:
from the main screen's File menu. Any significant country configuration issues will be reported.

Existing Customers Cannot Change Currency

A customer with existing transactions cannot have their currency changed from Sterling to another currency.
If the customer already has activity recorded against their account, you must create a new customer record using the required currency.

VAT Number Validation

Khaos Control does not validate VAT registration numbers entered into the Tax Ref field.
Any value entered will be treated as a VAT number.
To verify VAT registration details independently, you may find the European Commission's VIES VAT validation service useful:
VAT Information Exchange System (VIES)

See Also


Did you find this article helpful?