TAC HRTAC HR
A woman working on two laptops connected on one desk, with a man at a desk in the background
Microsoft Dynamics 365
Accounting and ERPPayroll journal as an Excel file

Integration with Microsoft Dynamics 365: Payroll Journals Ready for Accounting

The integration with Microsoft Dynamics 365 in TAC HR hands your finance team a payroll journal produced from the closed run and shaped by your chart of accounts. Three features stand behind it: the xlsx accounting journal export, a read-only API, and signed webhooks.

01Overview

Requirements

What does your company get from the Dynamics 365 integration?

  • A journal from final numbers: the entry comes only from a closed run, so it matches what the payslips paid.
  • Your account names: accounts in the entry carry the names your company set in its chart.
  • Fast review in a spreadsheet: the accountant opens the file and checks lines and totals before moving ahead.
  • Events to follow: signed webhooks include "employee joined or left" and "payroll paid", received by your developer or vendor.

Operational example

A company running Dynamics 365 closes the March run. The accounting lead downloads the journal file and checks total earnings against the monthly payroll report, then loads the file into her system the way her vendor approved. That evening a "payroll paid" event arrives at the endpoint her company's developer set up, and it records the month's status.

02What syncs

Where your data lands

What does the integration build on?

  • Accounting journal export (xlsx)The payroll journal on the company's chart of accounts
  • Read-only APIScoped keys
  • Signed webhooksEvents for employees, requests, payroll and rejected punches

How the file enters Dynamics 365 is a decision for your company and its vendor.

How does it connect to payroll and reports?

A run is calculated with separate items and appears in monthly payroll reports with the company's branding, exportable to Excel. The journal is the finance-facing copy of that same run, so a month never has two sets of numbers.

When does the integration help most?

  • When you have a vendor or developerthey receive the webhooks or read data through the API.
  • When month-end has strict deadlinesfinance starts from a ready file on closing day.
  • When reviewing monthly costpayroll reports and the journal file come from the same run, so they never conflict.
  • When the company expandsnew branches join the run, and the journal file keeps its shape.
03Setup steps

The setup, start to finish

Five steps from the system's own screens. What happens outside it, such as uploading a file or loading it into another system, is in your company's hands.

  1. 1The chart of accountsUnder “Accounts and extra allowances” you enter each account's code and name as it is in Dynamics 365.Then press “Save accounts”, and the journal is built on them.
  2. 2Run payrollCreate it from “Create payroll run”, or let the draft be created automatically on the day you set.Review each employee's lines before sending.
  3. 3Approve the runSend it with “Send for approval”, then “Approve run”, along your company's approval chain.Once approved, the journal for the run opens.
  4. 4Review the journalThe page shows total debit and credit and the entry lines by account code and name.Compare the total earnings with the monthly report under “Payroll reports”.
  5. 5Download the file and load it into Dynamics 365Press “Download Excel” and the entry comes out on your chart of accounts; loading it is up to your company and provider.For automatic follow-up, your developer adds a “New read key” or a “New subscription” under “Integrations”.
04FAQ

Asked before implementation

Does the entry follow our chart of accounts?

Yes. The entry is built on the company's chart of accounts.

Can our developer read employee data?

Through the read API with scoped keys, limited to what the company grants.

Is another company's data visible to us?

Each company's data is isolated from every other company, and only authorized users see it.

Ready to integrate?

Start with a trial run

Request a demo to see the journal from a closed run, and read about payroll and pricing.