LogoLogo
  • The Moment Knowledge Base
  • Moment
  • My Pages
    • My Settings
    • Time
      • Timesheet
      • Hours Report
      • Time balance
      • Absence Overview
      • Absence Report
      • Planned absence
    • My overview
    • My Tasks
      • My Task Board
    • Project Management
      • To be invoiced
      • Project Report
      • Hours report
      • Invoices
    • My Travel & Expense
      • New Expense
      • Claims
    • Project Expenses
    • Education
    • Organization
    • My Stats
    • Menu items
  • Tasks
    • Planning
    • Recurring tasks
    • Tasks report
  • Customers
    • Overview
    • Customer profile page
    • Contacts and mailing lists
    • Invoicing settings for individual customers
  • Offers
    • How to activate the offer module in Moment
    • Sending offers from Moment
    • How do hours in activities from an offer show in Moment's capacity overview?
  • Quality
    • Checklists
      • Working with checklists
      • Importing checklist templates
      • Control column
      • Checklist Report
    • Nonconformities
      • Action types
      • Categorize with tags
      • Impact
    • Routines
    • Project reviews
    • Evaluations
    • Risk management
    • Risk report
    • Settings
    • How can Moment support ISO certification for your company?
  • Projects
    • Overview
      • On map
      • Status
    • Dashboard
    • Report
    • Price Lists
    • Forecast
    • How to setup hours approval in Moment
    • Project Roles
    • Projects Main Page
    • Template projects
    • Activities
      • How to copy activities, move hours from one activity and deleting activities.
    • Project plan
      • Project Plan features
      • Budgeted costs and revenue in Moment's Project Plan
      • Accrual report
    • Expenses
    • Price Model
      • Price model: Hourly rates
      • Price model: Fixed price
      • Price model: Subscription
    • Invoice settings
    • Profit Factor
      • Calculated profit factor
      • Fixed profit factor
    • Products
    • How to keep track of costs in non billable-projects
  • Resources
    • HR (Pro)
      • Configuration
      • Reports
    • Co-workers
      • Schedule
      • New user (co-worker)
        • First time login in Moment for new users
      • Access Rights
      • Education
      • Hourly rates
      • Licenses
      • 📆Absence Approval based on tags
      • How to register furloughing (permitteringer) in Moment?
      • Why do my co-workers and I have too many/few banked hours?
      • How to add co-workers to projects between two partner companies
    • Resource Planner
    • Reservations
    • Capacity
  • Finances
    • Invoices
      • Payment ID
        • Payment ID Examples
      • Credit invoices in Moment
      • Updating the invoice summary.
      • Can't export invoices to an external accounting system
      • Splitting invoices between two customers
    • Project expenses
    • Product sales
    • Subscriptions
    • To be invoiced
      • Invoice draft approval
      • Common problems that prevent invoicing
    • Payments and write off
      • Customer has paid an invoice twice/OCR file has been read twice
    • Customer ledger
    • Payment reminders
    • Invoicing in advance (A-konto)
    • OCR files (KID in Norway)
    • E-invoicing
      • Countries
        • Norway
        • Sweden
        • Iceland
        • Denmark
          • Background info and technical details
      • PEPPOL BIS Billing 3.0 (EHF 3.0)
      • Addresses / PEPPOL ID
  • Company
    • Hours overview
    • Absence
    • Timesheet status
    • Hours and vacation balance
    • Billable time report
    • Performance
    • Files
    • Logs
    • Forecast
    • Holidays
    • Export invoices
  • Setup
    • Access control
      • Settings for Role Based Access Control
    • Tags
    • Travel & Expense
      • T&E configuration
        • Expense types
          • Norway
            • 2022
            • 2023
            • 2024
    • Notifications
      • Export invoices
  • Moment - By topic
    • How to setup and test Moment
    • Education
      • Setup
      • Registration
      • Reporting
    • Partner Companies
    • Moment FAQ
      • Security
    • Integrations
      • Real-time integrations
        • 24SevenOffice
        • Azets
        • Business Central
          • Configuration
            • Business Central App
            • Business Central
            • Moment
          • Data flow
        • Business Central Payments
        • CatalystOne
        • DK+
        • DnB Regnskap
        • Fiken
          • Authorization
        • Fortnox
          • OAuth 2 authorization
        • Fortnox Payments
        • PowerOffice Go
        • SharePoint
          • Configuration
            • Azure Active Directory
              • Postman
            • SharePoint
              • Content Type
                • Activity
                • Year
                • Period
                • Tags
        • Sparebank1 Regnskap
        • Tripletex
          • VAT Settings
          • Cost category names
        • Uni Economy
        • Uniconta
        • Uniconta Payments
        • Visma e-conomic
          • Incoming expenses
          • Demo
        • Visma e-conomic Payments
        • Xledger
      • File exports
        • Accounting system
          • DK
          • Duett
          • Dynamics C5
          • eFina
          • InfoEasy
          • Mamut
          • SIE 4
          • Uni Economy
            • Import central
          • Uni Micro
          • Visma Business
          • Visma DI Systems
          • Visma Global
          • Visma Scenario
          • Visma.net
          • Xero
            • Xero templates
          • Xledger
            • Format AR10
            • Format GL02b
          • Factoring
            • SG Finans
              • File content
            • Sparebank1 factoring
        • Wage system
          • Hogia Lön
          • Huldt & Lillevik Lønn
          • Visma Lønn
        • Export templates
          • Template editor
            • Create template
            • Edit template
              • Content
            • Test template
          • Customers
          • Expenses (Claims)
          • Hours (Time records)
          • Projects
          • Custom template
      • File import
        • Integration/file import
          • SoMe Ad Expenses
            • Configuration
            • Import
            • Ad providers
            • Technical description
          • Visma Document Center
            • SFTP configuration
            • Visma Document Center CSV file
        • Moment Importer
        • Object import/update
          • Import
        • Tools
          • Checklist
          • Expenses from file
          • Import expenses
      • Other systems
        • Ambita
        • Holte
        • JIRA
        • MAKS
        • RecMan
      • SSO
        • Google
        • Microsoft
      • Webhooks
        • Claims
        • Customers
        • Invoices
        • Offers
        • Projects
      • Known issues
        • Tripletex
        • 24SevenOffice
        • General
          • Invoice not transferred due to VAT code
  • Change Log
  • For developers
    • API
      • Authorization
        • Postman
      • Rate limit
      • How to use the API
      • How to get the your data
        • projects/projectRegisteredHoursReport
        • timeRecords/getReport
      • Moment API Swagger
  • ProjectHelp
    • ProjectHelp Support
Powered by GitBook
On this page
  • Export configuration
  • File
  • Format
  • Field descriptions
  • Contact
  • Customer no.
  • Department
  • Gross
  • Interest invoicing
  • Period/Accounting year
  • StdReg_xxx.xls
  • VAT

Was this helpful?

  1. Moment - By topic
  2. Integrations
  3. File exports
  4. Accounting system

Mamut

PreviousInfoEasyNextSIE 4

Last updated 3 years ago

Was this helpful?

Mamut is a Norwegian accounting system, now part of Visma.

Mamut uses a standard format for their files, this is also a format many other accounting systems has support for.

Export configuration

Configuration of export is to be done following the standard .

Mamut has 3 additional fields to be configured:

  • Accounting project: Select if project is to be included and how to get project information

  • Voucher code for invoices: Define the code used for invoices. Default 1

  • Voucher code for credit notes: Define the code used for credit notes. Default 3

Set these fields as needed and save.

File

The file produced is a CSV file using ";" (semi-colon) as separator. The number in the Max length column is give to inform about max number of characters allowed.

The file is according to the GBAT10 format, the standard format for Mamut.

Description

Column

Number

Column

in Excel

Max

length

Comment

Required

Identification

0

A

6

Always: GBAT10

Yes

Voucher no.

1

B

8

Numeric.

Voucher date

2

C

8

Date

Yes

Voucher type

3

D

3

Yes

4

E

2

Numeric (no decimals)

Yes

5

F

4

Numeric (no decimals)

Yes

Account

6

G

4

Numeric (no decimals)

Yes

7

H

5

Yes

Balance

8

I

15

Numeric (two decimals)

Yes

9

J

9

Numeric (no decimals)

Yes*

Supplier no.

10

K

9

Numeric (no decimals)

Yes*

11

L

30

String

Yes**

Address

12

M

200

String

Postal code

13

N

30

String

Postal place

14

O

30

String

Invoice no.

15

P

25

String

KID

16

Q

30

String

Due date

17

R

8

Date

<N/A>

18

S

[Blank]

Bank account

19

T

20

String

Description

General ledger

20

U

100

String

Description Ledger

21

V

100

String

22

W

1

Numeric

Project

23

X

6

24

Y

4

Payment terms

25

Z

4

26

AA

1

String

GrossSum

27

AB

20

Numeric (three decimals)

*For ledger vouchers **For ledger vouchers

Format

  • Date format: YYYYMMDD

  • Decimal separator: . (period)

Field descriptions

Contact

Defined if the contact is new or existing contact should be updated.

Customer no.

Customer number must be stated when comparing using numbers.

Department

Departments must exist in Mamut prior to the import.

Gross

This field can have one of the following status for a voucher

  • Blank: The line will be imported with value from Balance

  • T (True): The line will be imported with GrossSum (incl. VAT)

  • F (False):The line will not be imported. Example: a separate vat-voucher line that should be ignored in import

Interest invoicing

This field can have one of the following status for a voucher

  1. No interest invoicing

  2. Always

  3. Only above 30 days

Period/Accounting year

The accounting year and period must exist in Mamut prior to the import.

StdReg_xxx.xls

StdReg_xxx.xls is a reference to a file that can be exported in your Mamut software, this contains your specific standard values.

VAT

With regards to vat. there are two alternative methods for import.

  • Import separate vat-line for each voucher VAT code should be set to 1 (no vat) on all rows. Do not include the last two fields in the file as this will result in errors.

  • Import gross sum and let Mamut calculate vat. (Recommended) To use this method make sure the last two fields are used. Gross is set to either T or F (see more about Gross above) GrossSum is numeric with three decimals and shall have the gross sum (incl. vat). Set VAT code to 1 on the 1510 rows and relevant VAT code on e.g. 3010 rows.

Numeric ()

Code

Numeric ()

Numeric ()

Numeric ()

Numeric ()

StdReg_xxx.xls
Period
Accounting year
VAT
StdReg_xxx.xls
Customer no.
Contact
Interest invoicing
StdReg_xxx.xls
Department
StdReg_xxx.xls
StdReg_xxx.xls
Gross
configuration