What is Accounting integration?
Accounting integration helps you post your pay run transactions into Intacct. This saves time and reduces the potential for any inaccuracies in your data.
Select the pay components you use in Payroll and map them to your Intacct general ledger (GL) accounts. Export your payroll transactions each pay period, ready to import into Intacct.
Before you start
You need an active subscription to integrate with Sage Intacct.
During the set up, enter the Intacct GL accounts into Sage Payroll.
To learn how to view your Intacct GL accounts using the chart of accounts report, read our Intacct general ledger accounts article **link**
Complete the set up and then a pay run before exporting payroll journals to Sage Intacct.
Set up Intacct integration
Select Accounting, then Set up Sage Intacct integration.
In the Map payment types window, enter the Sage Intacct GL account number you use to record the payments to your employees, then select Next.
📎 NOTE: You must enter a GL account number for each payment method.
In the Map pay components window, enter the Intacct GL account numbers for any pay components you use in Sage Payroll.
For each pay component, enter the GL account number once, as a Credit or a Debit, then select Next.
Repeat this for each pay component type you use in Payroll.📌 TIP: Access the different pay component types using the tabs on the left of the window:
Earnings
Deductions
Additions
Tax
On the Review and complete window, check that all GL account numbers are entered correctly.
Select Edit, If you need to change any GL account numbers.
Select Complete when you've mapped each pay component you use in Payroll.
Your integration set up is complete.
You can export a journal file from Payroll when you complete your pay runs.
If you've not completed your first pay run, select Start your first pay run.
For help completing a pay run, read our Process a pay run article.
Edit Intacct integration settings
If you add a new pay component which was not mapped as part of the initial set up:
Select Accounting.
In the Payroll journal summary section, the pay run preview shows pay components that need to be mapped with a Map now status.
Edit the mapped components to add the GL Account number to the new component.
Export payroll journal file
When you complete a pay run, export a payroll journal file that can be imported into Intacct.
Select Accounting to view the Accounting integration window.
On this window, you will find:
Completed pay runs
The table shows:
The pay run date range.
Pay group name.
Type - for example, Payment or Payroll.
Status - for example, Exported or Ready for export.
You can search for specific pay runs by entering dates, types or status of a pay run in the search field.
Payroll journal details
Displays a summary of the pay run selected in the table.
Payroll journal summary
Displays a list of the pay components used in this pay run.
The Intacct GL account numbers the journals will be posted to.
An option to Edit payroll journal.
Export journal
Displays the name the export file will be given and the option to export.
By default, exported files will be saved to your downloads folder.
For help importing the journal file into Intacct, read the Import general ledger journal entries article.
Set up Accounting integration - Sage Accounting
If you use Sage Accounting instead of Sage Intacct, you can seamlessly integrate Payroll and Accounting.
To set up integration with Accounting, Read our Integrate with Accounting article.
📎NOTE: You can link Payroll and Accounting companies that use the same Sage account.
Please check the companies you want to link are accessed using the same Sage account login.