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
  • Configuration
  • Account receivable
  • Revenue account
  • Owner Code
  • Configured
  • File
  • Format
  • Columns

Was this helpful?

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

Format GL02b

PreviousFormat AR10NextFactoring

Last updated 1 year ago

Was this helpful?

The GL02b is a Xledger file format specifically to be used for accounting data.

This export requires tag groups if the option to set specific account receivable and/or revenue account will be used. Read more about tags .

Configuration

To configure Xledger (GL02b) file export see the common explanation in .

The specific fields that are unique to the GL02b format are the fields "Customer ledger account" and "Owner code".

Account receivable

Select the tag group containing tags corresponding with financial accounts that can be set as account receivable for customers. To use this feature it's required to create a tag group that will contain the accounts that can be selected.

Example of tag used for this:

Note! It's the tag code field that is used by the export, this is required for the export.

Revenue account

Select the tag group containing tags corresponding with financial accounts that can be set as revenue account for customers.

To use this feature it's required to create a tag group that will contain the accounts that can be used.

Example of tag used for this:

Note! It's the tag code field that is used by the export, this is required for the export.

Owner Code

This field is used to identify the your company in Xledger, register your id here. This is a required field.

Configured

Example of a configured export

  • Department from project

  • Tag group "Account receivable" used for named purpose

  • Tag group "Revenue" used for named purpose

  • Owner code registered

File

The file is a CSV file where semi-colon (;) is used as the separator.

Format

  • Date format: yyyymmdd

  • Decimal separator: . (period)

Columns

Description
Column #
Excel Column
Format
Max length
Comment
Mandatory

ImpSystem

1

A

25

Always "GL02b"

No

ImpSystemRef

2

B

25

Always "Moment"

No

Entity

3

C

Entity code

Yes

VoucherType

4

D

8

VoucherType in XLEDGER.NET

Yes

VoucherNo

5

E

nnnn

8

Imported voucher no.

Yes

FiscalYear

6

F

yyyy

4

Accounting period year from Voucher Date

No

PeriodNo

7

G

nn

2

Accounting period month from Voucher Date

No

VoucherDate

8

H

yyyymmdd

Voucher Date

Yes

Account

9

I

25

Account

Yes

AccountLedger

10

J

25

Ledger account

No

Posting1

11

K

25

Cost Center/Department

No

Posting2

12

L

25

Project

No

XGL

13

M

25

Object value for XGL

No

Our Ref (Imp)

14

N

25

Our ref posting value

No

Period Start (Imp)

15

O

Defines start period

No

No of Periods

16

P

Used for periodization

No

Pay Method (Imp)

17

Q

255

Defines payment method

No

Pay Code Int

18

R

No

Pay Doc Code (Imp)

19

S

25

No

Pay Doc Text

20

T

50

No

SubledgerNo

21

U

25

Customer No or Supplier No

No

SubledgerName

22

V

2555

Name of customer/supplier

No

InvoiceDate

23

W

yyyymmdd

Invoice Date

No

InvoiceNo

24

X

50

Invoice Number

No

XIdentifier(KID/OCR)

25

Y

50

KID/OCR

No

DueDate

26

Z

yyyymmdd

Due Date

No

SubledgerBankAccount

27

AA

50

No

PaymentTerms

28

AB

25

No

Text

29

AC

255

Transaction text

No

TaxRule

30

AD

25

Tax rule

Currency

31

AE

25

Currency code

CurrencyAmount

32

AF

nnnn.nn

Amount in selected currency

Amount

33

AG

nnnn.nn

Amount in company currency

Amount 3 (Imp)

34

AH

Amount 4 (Imp)

35

AI

Amount 5 (Imp)

36

AJ

UpdateSubledger

37

AK

n

If set to 1, address field will be updated

SubledgerGroup

38

AL

25

Only used when creating a new subledger

No

CompanyNo

39

AM

25

StreetAddress1

40

AN

255

StreetAddress2

41

AO

255

ZipCode

42

AP

25

Place

43

AQ

255

State

44

AR

50

Country

45

AS

25

BillingStreetAddress

46

AT

255

BillingStreetAddress2

47

AU

255

BillingZipCode

48

AV

25

BillingPlace

49

AW

255

BillingState

50

AX

25

BillingCountry

51

AY

25

Phone

52

AZ

50

Email

53

BA

50

YourRef

54

BB

255

Archive No

55

BC

Allows for defining archive number

Workflow

56

BD

1

0 if voucher will bypass workflow 1 if voucher will enter workflow

Posting 3

57

BE

255

Posting 4

58

BF

255

Posting 5

59

BG

255

Dummy

60

BH

255

not in use

EOL

61

BI

25

Last column, always "x"

here
here