Working with the ARCHIBUS Enhanced Global Feature Set

Global business operations need to efficiently manage daily transactions in multiple local currencies, and to convert these transaction costs to a single currency that provides a consolidated overview of costs across the entire organization.

To enable clear cost data reporting, the Enhanced Global Feature Set automates VAT tax percentage assignments that vary between countries and cost categories. The automation allows for handling exceptions or exemptions that you enter for a specific cost, or for all costs associated with a lease.

The feature set also enables you to examine statistics by automatically summarizing costs entered in multiple Payment Currencies to your organization's Budget Currency. ARCHIBUS provides the flexibility to examine costs without VAT, or externally with VAT, as many reports enable you to select the VAT cost types and currency to use in the report. For those reports that are intended for internal analysis, VAT costs are not included as these reports are not designed to analyze external payments such as VAT.

Currency Types

To track and report on costs in multiple currencies, ARCHIBUS enables you to work with the following currency types:

For example, each company within an organization can keep its own set of cost transactions in whatever payment currency it chooses. For multinationals, this means that US businesses can keep their accounts in dollars, an Italian subsidiary can use Euros, and United Kingdom operations can work in pounds. On an organizational level, any currency can be chosen to be the Budget Currency for consolidation of costs for reporting and benchmarking.

What is VAT?

Value-added tax (VAT) is a consumption tax levied on the value added to goods and services at each stage of their production and distribution. VAT is a tax on a transaction calculated as a percentage of the base cost for that transaction. For example, if the base cost is 100 and VAT% = 20%, the total cost is 120.

VAT is collected via a system of partial payments whereby VAT-registered businesses deduct from the VAT they have collected the amount of tax they have paid to other taxable persons on purchases for their business activities. For this reason, the amount of value-added tax that you pay is the cost of the product or service minus all taxes previously paid on it.

For example, for an orange juice maker, if VAT rates are 10% and orange juice costs $5.00 per gallon, the orange juice maker would charge $5.50 per gallon for the orange juice with $0.50 being collected as VAT Amount Income. The orange juice maker owes this VAT Amount Income to the government. However, the orange juice maker can subtract taxes previously paid to the orange grower when he purchased the oranges. Let's say the orange farmer charged $0.20 VAT for the oranges needed to make a gallon of orange juice. This means the orange juice maker would have a $0.30 tax liability per gallon of orange juice sold ($0.50 - $0.20 or Amount Income - VAT minus Amount Expense - VAT).

Since a business owes some percentage on the price of the product minus all taxes previously paid on the good, you need to know:

Value Description
Base Cost The price of a product minus all taxes previously paid for the product. The base cost is used to calculate the VAT
VAT Amount The value-added tax calculated for this Base Cost.
Total Cost The Base Cost + VAT amount

Knowing the VAT that you previously paid enables you to get tax credit for that amount.

How ARCHIBUS Automates VAT

ARCHIBUS automates the process of allocating VAT to costs while incorporating the different VAT regulations that create exceptions and exemptions. Since VAT percent varies by cost category and by country, your ARCHIBUS Administrator enters default VAT percents for specific cost categories and countries. The applications use this VAT percent to calculate the VAT amount, unless you enter an exception for a specific cost or an exemption for all costs associated with a lease.

After calculating the VAT Amount based on the VAT Percent and the Base Cost that you enter in the cost record, the application calculates the Total Costs and stores all these amounts in your Payment Currency and in the Budget Currency. The Budget Currency amounts can be used when you generate reports at the organization level.

The ARCHIBUS VAT and multicurrency features provide the cost estimations needed for budgeting purposes, but are not intended to offer the accuracy needed to replace your corporate financial accounting system. Your financial accounting systems should provide the following functionality:

Schema that Supports Multiple Currencies

The following schema fields support the ARCHIBUS Enhanced Global Feature Set:

Setting up the Enhanced Global Feature Set

The ARCHIBUS Administrator does the following to set ARCHIBUS applications to use the Enhanced Global Feature set:

Task Learn More

By default, the following application parameters are set to enable the ARCHIBUS Enhanced Global Feature Set. To disable these features, the ARCHIBUS Administrator can change these settings using the System Administration / ARCHIBUS Administrator - Application Configuration / Edit Application Parameters task.

The following application parameters control the ARCHIBUS Enhanced Global Feature Set:

  • AbCommonResources-AbCommonResources-BudgetCurrency. This parameter designates your Budget Currency. There is only one Budget Currency for each project. If the parameter is not defined, or if the value does not exist in the ARCHIBUS Currencies table, the ARCHIBUS core sets its value to the currency of the default application server locale.
  • AbCommonResources-ConvertAreasAndLlengthsToUserUnits. By default it is set to "1" to enable multiple area units (Metric or Imperial) per project. Setting this parameter to "0" disables multiple area units.

  • AbCommonResources-EnableVATandMultiCurrency. Enable VAT and multicurrency. These features are enabled by default. To disable these features, you set the application parameter to "0." Setting the parameter to "1" enables the features. Enabling VAT and multicurrency adds the ARCHIBUS security group so that users can access these features.

Note: To ensure data integrity, once you set the Budget Currency it is not recommended to change it. If you change the Budget Currency, cost transaction records entered using the previous Budget Currency will not have their Budget Currency values updated to the new currency. Similarly, you should not enable or disable VAT and multi-currency midstream. If you do, you will need to update pre-existing records using the Smart Client to bring them into conformity with the current (enabled vs disabled) setting.

The ARCHIBUS Administrator also defines the following:

  • The currencies you use for cost transactions and for your organization's budget.
  • Currency exchange rates. Enter the factors used to convert currencies.
  • VAT percent values by cost category and country. The system uses this default percentage to calculate VAT unless you manually override this percentage.
  • The Locale field in each user's User Profile. The currency associated with the Locale you enter determines the User Default Currency for the user. This currency is used by default when a user enters new cost transactions or generates reports.

    Note: The ARCHIBUS Users table's Locale field is an enumerated list; LOCALE (afm_users.locale) values need to match user locale values in the afm-config.xml file. The afm-config.xml file is also used to obtain the user country, based on the user LOCALE setting. Ensure that the afm-config.xml file contains the Locales associated with the currencies and countries you want to use.

  • User Display Unit of Measure field in the User Profile for each user. This controls the unit of measure (Metric or Imperial) that the user will see for area fields.

 

 

Copyright © 1984-2019, ARCHIBUS, Inc. All rights reserved.