Payroll Import

The payroll import feature allows you to quickly transfer payroll data from external systems into the General Journal in Business Central. The process is simple, intuitive, and available directly from the journal view.

Supported File Formats

You can import data from two file types:

Excel Files

  • Format: .xlsx or .xls
  • Row 1: column headers (e.g. Posting Date, G/L Account No., Description, Debit Amount, Credit Amount, Dimensions...)
  • Row 2 and below: data to import
  • Recommended encoding: UTF-8

CSV Files

  • Text format: .csv
  • Field separator: semicolon (;)
  • Row 1: column headers
  • Row 2 and below: data
  • Encoding: UTF-8

Data Structure

Your file should contain the following columns (header names can vary, content matters):

Column Description Type Required
Posting Date Transaction date Date Optional*
Line Type Account type (leave empty for G/L) Text Optional
Document No. Document number Code[20] Optional*
G/L Account No. General Ledger account number Code[20] Required
Description Transaction description Text[50] Required
Debit Amount Debit side amount Number Optional
Credit Amount Credit side amount Number Optional
Dimension Value 1 First dimension value code Code[20] Optional
Dimension Value 2 Second dimension value code Code[20] Optional
Dimension Value 3 Third dimension value code Code[20] Optional

If not provided in the file, values will be taken from settings or entered during import.

Dimension Setup

Before your first import, configure dimensions in N24 Core Extension Setup:

Payroll_Import_Setup

In the Payroll Import section, set:

  • Payroll Dimension 1
  • Payroll Dimension 2
  • Payroll Dimension 3

All three dimensions must be configured. If not, the system will display a message and allow you to quickly go to settings.

How to Import Data

Start the import from the General Journal:

Payroll_Import_Run

Import Steps:

  1. In the General Journal, select the action N24C | Import Payroll (Excel) or N24C | Import Payroll (CSV)
  2. Choose the file to import
  3. If needed, set default values (date, document, dimensions)
  4. The system will automatically recognize headers and allow you to map fields
  5. Confirm import – data will be added to the journal

Export Sample File

You can generate a sample Excel file with the correct structure:

  1. Go to N24 Core Extension Setup
  2. In the Payroll Import section, click Export sample file
  3. You will receive a file with sample data and headers