Visma Document Center CSV file

Below is a description of the various columns in the file. Each row must contain a project number, if the project number does not exist in Moment the expense will be skipped. There will not be any notification of skipped expenses due to missing project number.

Format

Moment support two different file formats, depending on the type of decimal separator used.

Deccimal separator	Quotation marks	Column separator
Comma	Required on all columns	Comma
Period	Only required on text columns	Comma

For both options the first row, labels, should always use quotation mark for each column.

Encoding

Files should be encoded as UTF-8.

Columns

The file to be used must contain the following columns, columns with name in bold are required.

Header	Name	Description	Format
JNo	Journal Number
EntNo	Entity Number	To identify an expense if there are more than one with same Journal No
WfId	Visma ID	Visma Document Center document ID
Sup	Supplier Number
actor.Nm	Supplier Name
AcNo	Financial Account Number	This number must exist in the account setup in Moment
VoNo	Voucher Number	(Bilagsnummer)
VoDt	Voucher Date	(Bilagsdato)	YYYYMMDD (No separators)
ValDt	Validation Date	(Valueringsdato)	YYYYMMDD (No separators)
VoTp	Voucher Type	(Dokument type)
Txt	Text	Description and Title in Moment
Cur	Currency	(Valuta)	See "Currency codes" section
ExRt	Exchange Rate	Company currency will be 100	Default 100
CurAm	Currency Amount	Amount in currency	See "Format" section
AcAm	Company	Amount in company currency	See "Format" section
Qty	Quantity	Always 1
R1	Dimension 1
R2	Dimension 2	Project The project number must existing in Moment, otherwise the expense will be ignored.
EntAm	Entity Amount		See "Format" section
Bas	Price		See "Format" section
VatAm	VAT Amount		See "Format" section
TxCl	Tax Class	(Avgiftsklasse)	0 if not provided
TxCd	Tax Code	(Avgiftskode)	0 if not provided
VatRt	VAT Rate	The VAT Rate for the row	See "VAT rates" section
SrcTp	Source Type
InvoNo	Invoice Number	Suppliers invoice number

Currency codes

You must verify that the currency codes below are set in your Visma installation (standard) Support both Visma codes and ISO-4217 codes.

Currency	Code	ISO-4217
USD	1	840
GBP	44	826
DKK	45	208
SEK	46	752
NOK	47	578
EUR	999	978

Only the listed currencies are supported. If the currency for the invoice is not found in this list, the row will be skipped and you will be notified by email about this issue.

VAT rates

Typical VAT rates are listed here

Description	Rate
No VAT	0
Low VAT rate	12
Medium VAT rate	15
High VAT rate	25