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.
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.
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)
ExRt
Exchange Rate
Company currency will be 100
Default 100
CurAm
Currency Amount
Amount in currency
AcAm
Company
Amount in company currency
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
Bas
Price
VatAm
VAT Amount
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
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.
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
No VAT
0
Low VAT rate
12
Medium VAT rate
15
High VAT rate
25
Last updated