Xledger GL02H export

How to export Cardboard payments, correctly accounted for, to your general ledger in Xledger using the GL02H file export.

What is GL02H?

Cardboard allows you to export your monthly payments as a GL02H file for import into the general ledger of Xledger. The file, when imported into Xledger, will allow you to enter all the payments done with Cardboard into your general ledger, with the following correct accounting codes prefilled for you:

  • Account numbers (kontoplan)
  • Supplier name and number (leverandør)
  • VAT codes (momskode)
  • Project (prosjekt)
  • Department (koststed)
  • GL Object 3 (Xledger-configurable field)
  • GL Object 4 (Xledger-configurable field)

See further down how to configure Cardboard such that these accounting concepts are correctly prefilled.

Export GL02H from Cardboard to Xledger

  • You can find monthly GL02 files it in Cardboard by navigating to Accounting > Export. The files can be downloaded by pressing the button labeled GL02H (Xledger).
  • The resulting file, named "GL02H.csv", should be uploaded into Xledger by navigating to Forsystem > Filimport. Press the Upload file button and select the file you just downloaded from Cardboard; "GL02H.csv". Finally click Last opp.
  • The file should appear as line with "Importdef." set to "Accounting Journal with Subledger (XL Standard w/header (GL02H)", just like so:
Xledger GL02H import
  • Select the check box, press Godkjenn and then Lagre. The file should now have status Klar til kjøring.
  • Now navigate to Forsystem > Importer > Filimportprosessering. Optionally, select E-post and/or GL02H in the Importdef., and then press Bestill jobb.
Xledger GL02H file import processing
  • Now, navigate to Bilagsimport in Oppgaveliste. Here you should be able to inspect the journal entries for any inaccuracies or intended edits.
Xledger bilagsimport
  • In order to import these entries into your general ledger, navigate to Forsystem > Importer > Bilagsimport and click Bestill jobb.

Configure Cardboard for your Xledger accounting

The most important part for a time-saving and efficient export from Cardboard to Xledger is that you configure each subscription in Cardboard with the correct accounting codes from Xledger. These codes can be entered into Cardboard by navigating to Accounting > Settings.

Here is a complete list of where you can find the accounting codes in Xledger for the different configurable fields in Cardboard:

  • Account numbers - Regnskap > Kontoplan and select the correct numerical accounting codes from the Konto column.
  • Supplier - Leverandør > 🔍 Leverandører and select the correct value from the Kode column. This is exported as the subledger number, and populates the X Firma/Person Nr field in Xledger.
  • Project - Administrasjon > Organisasjon -> 🔍 Prosjekter and select the correct value from the Prosjekt # column. This is exported as X GL Object 2 in the resulting GL02H file.
  • Department - Administrasjon > Organisasjon > Koststeder and select he correct value from the Kode column. This is exported as X GL Object 1 in the resulting GL02H file.
  • Sub unit (X GL Object 4, e.g. støtteområde) - Administrasjon > Objekter > Objektsverdier and filter on the object type configured as posting 4 / X GL Object 4.
  • Business unit (X GL Object 3, e.g. organisasjonsenhet) - Administrasjon > Organisasjon > Organisasjonsenheter and select he correct value from the Kode column. This is exported as X GL Object 3 / posting 3 in the resulting GL02 file.

Remember to click the Save button in Cardboard when you have filled in the necessary information.