In addition to the general Visma.net
prerequisites, there are some specific prerequisites for the Visma.net Expense integration.
License
- A Visma.net Expense licence is required for setting users in Visma.net Expense
- A Visma.net Expense integration product is required in the Business NXT licence to process the claims in Business NXT.
Settings
- Company processing in Company
table
- If Process accounting documents automatically is enabled then documents are processed automatically when they are
received from Visma.net Expense.
- Accounting instances: Incoming accounting documents in Company information table
- It is possible to activate an automatic update of batches by selecting
Direct update. Only batches without errors
can be updated automatically.
- Expense voucher series in Company information table
- Numbers from this series will be used when creating vouchers from those
incoming accounting documents with Origin
2 - Expense.
- Order processing 1: Special processing (invoice) in Company information table
- If Create separate orders from Visma.net Expense is enabled, then the Split processing will be automatically performed on the newly created sales
order. More specifically, new separate orders will be created for each
customer from the initial sales order from Visma.net Expense. If this option is disabled, only one sales order is created for each
processed document. In this case the user can manually trigger the
Split processing in order to created new orders for each customer.
- The user can also manually trigger the Transfer processing in order to move order lines to other existing
orders.
Product mapping for flow Payment in payroll, ERP integration for
re-invoice/bookkeeping
Expense types from Visma.net Expense need to be mapped to products in Business NXT when expenses are being re-invoiced. For booking only payment vouchers with flow
Payment in AutoPay, ERP integration for bookkeeping, tax report through payroll this
mapping is not required. The mapping is done in the Delivery alternative
table.
The corresponding mileage types, daily allowance types and expenses must be mapped in
Sup. prod. no. column in Delivery alternative
table for each product that is used for re-invoicing claims.
It is possible to map Visma.net Expense lines with products in Business NXT only by using the content of the <Type category> tag in the incoming document
table. (see Standard type categories section). Because <Type category> is
quite generic, the content of <Expense type> tag can also be used for product
mapping. The latter provides a more detailed way to categorize products. This is
helpful especially when having to differentiate between similar expense types that
bear different VAT rates. It is recommended to map products always based on
<Expense type>. (see Standard expense types section)
The product prices received from Visma.net Expense are gross prices. Since Business NXT uses net prices on orders by default, gross prices from Visma.net Expense are automatically altered to net prices to avoid double VAT on re-invoicing. In
order to achieve this the VAT rate should be
applied to each individual Product no. This feature can be disabled in Product table via
Processing method flag Do not deduct VAT from Expense price on orders for example for Mileage and Daily allowances.
The Sup. prod. no. column in Delivery alternative
table should contain Visma.net Expense expense types only once.
It is recommended to exempt expense products from warehousing.
The standard
Visma.net Expense type categories are:
Table 1. Standard type categories
| Description |
Type |
| Advanced types, Meal benefits (only for tax reports), Free
fuel on company cars (only taxable), Company paid expenses not
to be reimbursed |
ADVANCED_TYPE |
| Daily allowances, full or partial |
DAILY_ALLOWANCE_TYPE |
| All expense related types, Airline tickets, accommodation,
parking, meals, internet etc. |
EXPENSE_TYPE |
| Flexible daily_allowances, only in use in Sweden as per now -
as this is based on the company creating their own allowance
rules |
FLEXIBLE_DAILY_ALLOWANCE_TYPE |
| Represents the standard or primary mileage type used for
regular travel distances. |
MILEAGE_MAIN_TYPE |
| Represents additional or exceptional mileage type used for
distances beyond the standard allowance. |
MILEAGE_EXTRA_TYPE |
| Night allowances, full or partial |
NIGHT_ALLOWANCE_TYPE |
| Other allowances - like compensation amount - rarely
used |
OTHER_ALLOWANCE_TYPE |
| All threshold related types on cars - that is when an
employee has reached a specific threshold and a new mileage type
kicks in |
THRESHOLD_TYPE |
Expenses can be mapped to more specific categories by expense type that enables
mapping for each expense type in Business NXT. Mapping each expense code enables also more sophisticated VAT handling for each
expense. If expense codes are to be used, there is a possibility to export a list of
expense codes on the expense type configuration page in Visma.net Expense.
Table 2. Daily allowances Norway
| Description |
Code |
Type |
| Domestic - Boardinghouse (without cooking facilities) |
BOARD_HOUSE_DOM |
DAILY_ALLOWANCE_TYPE |
| Domestic 6 -12 hours |
DAY_6H_12H_DOM |
DAILY_ALLOWANCE_TYPE |
| Domestic travel over 12 hours |
DAY_GT_12H_DOM |
DAILY_ALLOWANCE_TYPE |
| Domestic - Hotel |
HOTEL_DOM |
DAILY_ALLOWANCE_TYPE |
| Domestic - Private accommodation |
PRIVATE_DOM |
DAILY_ALLOWANCE_TYPE |
| Domestic - Room (with cooking facilities) |
ROOM_DOM |
DAILY_ALLOWANCE_TYPE |
| Abroad - 6-12 hours |
DAY_6H_12H_ABR |
DAILY_ALLOWANCE_TYPE |
| Abroad - Boardinghouse (without cooking facilities) |
BOARD_HOUSE_ABR |
DAILY_ALLOWANCE_TYPE |
| Abroad - Hotel |
HOTEL_ABR |
DAILY_ALLOWANCE_TYPE |
| Abroad - More than 12 hours |
DAY_GT_12H_ABR |
DAILY_ALLOWANCE_TYPE |
| Abroad - Room (with cooking facilities) |
ROOM_ABR |
DAILY_ALLOWANCE_TYPE |
| Abroad - Private accommodation |
PRIVATE_ABR |
DAILY_ALLOWANCE_TYPE |
| Abroad - Administrative board |
MEALS_ALL_ABR |
DAILY_ALLOWANCE_TYPE |
| Abroad compensation |
COMPENSATION_AMOUNT |
DAILY_ALLOWANCE_TYPE |
| Night allowance |
NIGHT |
NIGHT_ALLOWANCE_TYPE |
Table 3. Car allowances / Mileage types Norway
| Description |
Code |
Type |
| Domestic - Transportation |
TRANSPORT_DOM |
|
| Boat |
BOAT |
MILEAGE_MAIN_TYPE |
| Car |
CAR |
MILEAGE_MAIN_TYPE |
| Car driving abroad |
CAR_ABROAD |
MILEAGE_MAIN_TYPE |
| Electric car |
CAR_ELECTRIC |
MILEAGE_MAIN_TYPE |
| Car driving in Tromso |
CAR_TROMSO_MAIN |
MILEAGE_MAIN_TYPE |
| Forest road or construction road |
FOREST_ROAD |
MILEAGE_EXTRA_TYPE |
| Motorcycle over 125 ccm |
MOTOCYCLE_o125 |
MILEAGE_MAIN_TYPE |
| Moped and motor cycle up to 125 ccm |
MOTOCYCLE_u125 |
MILEAGE_MAIN_TYPE |
| Other means of transport |
OTHER_TRANSP |
MILEAGE_MAIN_TYPE |
| Passenger |
PASS |
MILEAGE_EXTRA_TYPE |
| Snowmobile and ATV |
SNOWMOBILE_ATV |
MILEAGE_MAIN_TYPE |
| Towed vehicle |
TOW |
MILEAGE_EXTRA_TYPE |
| Car threshold |
CAR_THRESHOLD |
|
| Commuter travel |
COMMUTER |
MILEAGE_MAIN_TYPE |
Table 4. Expenses Norway
| Description |
Code |
Type |
| Accommodation |
EXACCOM |
EXPENSE_TYPE |
| Hotel breakfast |
EXBRKFST |
EXPENSE_TYPE |
| Bus |
EXBUS |
EXPENSE_TYPE |
| Car rental |
EXCAR |
EXPENSE_TYPE |
| Ferry / Boat |
EXFERRYBOAT |
EXPENSE_TYPE |
| Fuel |
EXFUEL |
EXPENSE_TYPE |
| Gifts |
EXGIFT |
EXPENSE_TYPE |
| Health service |
EXHEALTH |
EXPENSE_TYPE |
| Broadband / Telecommunication |
EXINTERNET |
EXPENSE_TYPE |
| Meal |
EXMEAL |
EXPENSE_TYPE |
| Newspapers and magazines |
EXNEWSPAPER |
EXPENSE_TYPE |
| Office equipment / accessories |
EXOFFICE |
EXPENSE_TYPE |
| Parking |
EXPARKING |
EXPENSE_TYPE |
| Airline tickets |
EXPLANE |
EXPENSE_TYPE |
| Representation |
EXREPRES |
EXPENSE_TYPE |
| Road toll |
EXROADRTOLL |
EXPENSE_TYPE |
| Social events |
EXSOCEVENT |
EXPENSE_TYPE |
| Taxi |
EXTAXI |
EXPENSE_TYPE |
| Train |
EXTRAIN |
EXPENSE_TYPE |
| Other transport |
EXTRANSPORT |
EXPENSE_TYPE |
Table 5. Daily allowances Sweden
| Description |
Code |
Type |
| Abroad, full day |
DAY_FULL_ABROAD |
DAILY_ALLOWANCE_TYPE |
| Domestic, full day |
DAY_FULL_DOM |
DAILY_ALLOWANCE_TYPE |
| Abroad, full day with end |
DAY_FULL_END_ABROAD |
DAILY_ALLOWANCE_TYPE |
| Domestic, full day with end |
DAY_FULL_END_DOM |
DAILY_ALLOWANCE_TYPE |
| Abroad, full day with start |
DAY_FULL_START_ABROAD |
DAILY_ALLOWANCE_TYPE |
| Domestic, full day with start |
DAY_FULL_START_DOM |
DAILY_ALLOWANCE_TYPE |
| Abroad, half day with end |
DAY_HALF_END_ABROAD |
DAILY_ALLOWANCE_TYPE |
| Domestic, half day with end |
DAY_HALF_END_DOM |
DAILY_ALLOWANCE_TYPE |
| Abroad, half day with start |
DAY_HALF_START_ABROAD |
DAILY_ALLOWANCE_TYPE |
| Domestic, half day with start |
DAY_HALF_START_DOM |
DAILY_ALLOWANCE_TYPE |
| Night allowance |
NIGHT |
NIGHT_ALLOWANCE_TYPE |
| Meal benefit |
EX_MB |
EXPENSE_TYPE |
Table 6. Car allowances / Mileage types Sweden
| Description |
Code |
Type |
| Car |
CAR |
MILEAGE_MAIN_TYPE |
| Company car diesel |
CAR_CO_DIESEL |
MILEAGE_MAIN_TYPE |
| Company car, free fuel |
CAR_CO_FREEFUEL |
MILEAGE_MAIN_TYPE |
| Company car, other |
CAR_CO_OTHER |
MILEAGE_MAIN_TYPE |
| Heavy load |
HEAVY_LOAD |
MILEAGE_EXTRA_TYPE |
| Passenger |
PASS |
MILEAGE_EXTRA_TYPE |
Table 7. Expenses Sweden
| Description |
Code |
Type |
| Accommodation |
EXACCOM |
EXPENSE_TYPE |
| Accommodation without breakfast |
EXACCOM_NO_BREAKFAST |
EXPENSE_TYPE |
| Bridge toll |
EXBRIDGETOLL |
EXPENSE_TYPE |
| Hotel breakfast |
EXBRKFST |
EXPENSE_TYPE |
| Bus |
EXBUS |
EXPENSE_TYPE |
| Car rental |
EXCAR |
EXPENSE_TYPE |
| Ferry / Boat |
EXFERRYBOAT |
EXPENSE_TYPE |
| Fuel |
EXFUEL |
EXPENSE_TYPE |
| Gifts |
EXGIFT |
EXPENSE_TYPE |
| Gifts to colleagues |
EXGIFTS_COLLEAGUES |
EXPENSE_TYPE |
| Gifts to customers |
EXGIFTS_CUSTOMERS |
EXPENSE_TYPE |
| Health service |
EXHEALTH |
EXPENSE_TYPE |
| Broadband / Telecommunication |
EXINTERNET |
EXPENSE_TYPE |
| Meal |
EXMEAL |
EXPENSE_TYPE |
| Newspapers and magazines |
EXNEWSPAPER |
EXPENSE_TYPE |
| Office equipment / accessories |
EXOFFICE |
EXPENSE_TYPE |
| Parking |
EXPARKING |
EXPENSE_TYPE |
| Airline tickets |
EXPLANE |
EXPENSE_TYPE |
| Postage |
EXPOSTAGE |
EXPENSE_TYPE |
| Representation |
EXREPRES |
EXPENSE_TYPE |
| Road toll |
EXROADRTOLL |
EXPENSE_TYPE |
| Social events |
EXSOCEVENT |
EXPENSE_TYPE |
| Taxi |
EXTAXI |
EXPENSE_TYPE |
| Train |
EXTRAIN |
EXPENSE_TYPE |
| Other transport |
EXTRANSPORT |
EXPENSE_TYPE |
Table 8. Daily allowances Finland
| Description |
Code |
Type |
| Domestic - Full day |
DAY_FULL_DOM |
DAILY_ALLOWANCE_TYPE |
| Domestic - Partial day |
DAY_PART_DOM |
DAILY_ALLOWANCE_TYPE |
| Abroad - Full day |
DAY_FULL_ABR |
DAILY_ALLOWANCE_TYPE |
| Abroad - Partial day |
DAY_PART_ABR |
DAILY_ALLOWANCE_TYPE |
| Abroad - no compensation |
NIGHT_NO_COMP_ABR |
NIGHT_ALLOWANCE_RATE |
| Domestic - no compensation |
NIGHT_NO_COMP_DOM |
NIGHT_ALLOWANCE_RATE |
| Night allowance |
NIGHT |
NIGHT_ALLOWANCE_RATE |
| One meal money |
ONE_MEAL_MONEY |
DAILY_ALLOWANCE_TYPE |
| Two meal money |
TWO_MEAL_MONEY |
DAILY_ALLOWANCE_TYPE |
Table 9. Car allowances / Mileage types Finland
| Description |
Code |
Type |
| All terrain quad bike |
ATV |
MILEAGE_MAIN_TYPE |
| Car |
CAR |
MILEAGE_MAIN_TYPE |
| Company car |
CAR_CO |
MILEAGE_MAIN_TYPE |
| Dog on duty |
CAR_DOG |
MILEAGE_MAIN_TYPE |
| Forest road or construction road |
FOREST_ROAD |
MILEAGE_EXTRA_TYPE |
| Moped |
MOPED |
MILEAGE_MAIN_TYPE |
| Motorcycle |
MOTOCYCLE |
MILEAGE_MAIN_TYPE |
| Motorboat over 50 hp |
MOTORBOAT_o50 |
MILEAGE_MAIN_TYPE |
| Motorboat up to 50 hp |
MOTORBOAT_u50 |
MILEAGE_MAIN_TYPE |
| Other means of transport |
OTHER_TRANSP |
MILEAGE_MAIN_TYPE |
| Passenger |
PASS |
MILEAGE_EXTRA_TYPE |
| Snowmobile |
SNOWMOBILE |
MILEAGE_MAIN_TYPE |
| Mobile Canteen |
TOW_CANTEEN |
MILEAGE_EXTRA_TYPE |
| Caravan |
TOW_CARAVAN |
MILEAGE_EXTRA_TYPE |
| Trailer |
TOW_TRAILER |
MILEAGE_EXTRA_TYPE |
| Machinery |
TRANSP_MACH |
MILEAGE_EXTRA_TYPE |
Table 10. Expenses Sweden
| Description |
Code |
Type |
| Accommodation |
EXACCOM |
EXPENSE_TYPE |
| Hotel breakfast |
EXBRKFST |
EXPENSE_TYPE |
| Bus |
EXBUS |
EXPENSE_TYPE |
| Car rental |
EXCAR |
EXPENSE_TYPE |
| Ferry / Boat |
EXFERRYBOAT |
EXPENSE_TYPE |
| Fuel |
EXFUEL |
EXPENSE_TYPE |
| Gifts |
EXGIFT |
EXPENSE_TYPE |
| Broadband / Telecommunication |
EXINTERNET |
EXPENSE_TYPE |
| Meal |
EXMEAL |
EXPENSE_TYPE |
| Newspapers and magazines |
EXNEWSPAPER |
EXPENSE_TYPE |
| Office equipment / accessories |
EXOFFICE |
EXPENSE_TYPE |
| Parking |
EXPARKING |
EXPENSE_TYPE |
| Airline tickets |
EXPLANE |
EXPENSE_TYPE |
| Representation |
EXREPRES |
EXPENSE_TYPE |
| Road toll |
EXROADRTOLL |
EXPENSE_TYPE |
| Social events |
EXSOCEVENT |
EXPENSE_TYPE |
| Taxi |
EXTAXI |
EXPENSE_TYPE |
| Train |
EXTRAIN |
EXPENSE_TYPE |
| Other transport |
EXTRANSPORT |
EXPENSE_TYPE |
If any new codes or types are added in Visma.net Expense there will be unique code that should be copied from the expense type export list
to Delivery alternative
table.