Importing Payroll Transactions

To account for salary payments and related transactions, you must import and post financial transactions made by your payroll provider to the general ledger. To do this, you first import a file that you receive from the payroll provider into the General Journal page. Then you map the external accounts in the payroll file to the relevant G/L accounts. Lastly, you post the payroll transactions according to the account mapping.


To use this functionality, an extension for payroll import must be installed and enabled. The Ceridian Payroll and the Quickbooks Payroll File Import extensions are pre-installed in Business Central. For more information, see Customizing Business Central Using Extensions.

To import a payroll file

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter General Journals, and then choose the related link.

  2. In the relevant general journal batch, choose the Import Payroll Transactions action. An assisted setup guide opens.

  3. Follow the steps on the Import Payroll Transactions page.


    In the step about mapping the external payroll records to your G/L accounts, the mappings that you make will be remembered next time the same records are imported. This will save you time as you do not have to manually fill in the Account No. field in the general journal every time you have imported recurring payroll transactions.

    When you choose the OK button in the assisted setup guide, the General Journal page is filled with lines representing the transactions that the payroll file contains and with the relevant accounts prefilled in the G/L Account fields according to mappings you made in the guide.

  4. Edit or post the journal lines as for any other general ledger transactions. For more information, see Post Transactions Directly to the General Ledger.

See Also

Customizing Business Central Using Extensions
Work with General Journals

Find free e-learning modules for Business Central here