Configure the export of Payroll journal entries

You can export the journal entries in Profit to another financial software package. For this purpose you have to select an export format at the employer level.

Note:

AFAS no longer supports and maintains the export definitions for Exact Globe, AFAS DOS, Multirecord, Fuma, Accountview, FIS or Triathlon. If an export definition no longer works, we do not change it anymore and you have to switch to a different method for generating journal entries. You can choose from:

  • Analysis based on the data collection Employee journal entry

    In this analysis, you determine for yourself which fields you want to see, and in what order.

  • Export definition Profit export

    You use this to generate a file in Profit that you cannot change. You adjust the import in your other system.

To configure the export of Payroll journal entries:

  1. Go to: HR / Organisation / Employer.
  2. Open the employer’s properties.
  3. Go to the tab: Journalising.
  4. In consultations with your consultant, select the appropriate export definition.

    The following export format is used for the Profit export export definition. The number of positions per field is fixed and, where necessary, will be padded using spaces:

    Note:

    When you export to Exact, only the first and second dimensions are exported.

    Description

    Start position

    Number of positions

    Profit field

    Type

    Journal

    1

    6

    Journal

    Alphanumerical

    Ledger account

    7

    16

    Account number

    Numerical

    Debit/Credit

    23

    1

     

    D/C

    Amount

    24

    15

     

    Decimal separator: dot

    Description

    39

    40

    Text for journal entry

     

    Voucher date

    79

    6

    Voucher date

    ddmmyy

    Empty text

    85

    10

     

     

    1st dimension

    95

    16

    Allocation axis 1

     

    2nd dimension

    111

    16

    Allocation axis 2

     

    3rd dimension

    127

    16

    Allocation axis 3

     

    4th dimension

    143

    16

    Allocation axis 4

     

    5th dimension

    159

    16

    Allocation axis 5

     

    Empty text

    175

    6

     

     

    Empty text

    181

    1

     

     

    Empty text

    182

    3

     

     

    Empty text

    185

    6

     

     

    Empty text

    191

    3

     

     

    Empty text

    194

    15

     

     

    Number of journal entries

    209

    10

     

     

    Empty text

    219

    8

     

     

    Empty text

    227

    3

     

     

Directly to

  1. Configure the Payroll journalising
  2. Journalise automatically or manually
  3. Journalise to another environment
  4. Configure the export of journal entries