How To: Financial Setup for EC Customers
Table Of Contents
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:
| Field | Setting |
|---|---|
| EC Company | Tick this checkbox. |
| Company pays tax | Tick this checkbox except in exceptional circumstances. |
| Tax Ref | Enter 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.
For more information, see How the Tax Ref affects the EC Tax Register.
Customer Financial Tab
Open the [ Customer | Financial ] tab and set:
| Field | Setting |
|---|---|
| Currency | Select 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:
- Create a Euro Price List.
- 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:
| Setting | Requirement |
|---|---|
| Force Sales Order Lowest Price | Must 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)