Setup in Business NXT

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.