Overview
A journal service is a tool that allows you to connect your accounting software with your payroll platform so that you can capture journal entries in your chart of accounts. If you use Sage Intacct for your accounting software and journal service, and Employment Hero for your payroll, you would simply connect Sage Intacct with your Employment Hero payroll platform via the accounting integration feature.
After connecting your Sage Intacct and EH Payroll platforms together, and setting up your chart of accounts, you can post-payroll journals automatically into Sage Intacct upon finalising a pay run, eliminating the need for manual data import/exports or CSV uploads. You will also notice with this export feature we format the data to reflect automatically your Sage Intacct reporting layouts.
Note: This feature is available for Standard and Premium payroll plans.
Initial set up and configuration
From within your Sage Intacct account, complete the following set up:
Subscribe to Web Services- Company > Subscriptions.
- Find Web Services and click on it to Subscribe.
- Ignore the warning about additional charges.
- Company > Company Info.
- Click EDIT.
- Click on the Security tab.
- Go to the section labeled Web Services authorizations.
- Add the Sender ID: employmentheroMPP
Important
Instructions vary slightly depending on the client defining their security as Role-Based or User-Based.
If you want to create a user with User-Based security, please go to the next accordion item: Create User with User-Based security.
Create a Role
- Company > Roles.
- Click ADD.
- Input a Name.
- Click SAVE.
- Click on the necessary Permissions for each applicable module.
- Click SAVE.
Create Web Service User
- Company > Web Services user.
- Click NEW.
- Input values for these fields:
- User ID.
- Last name.
- First name.
- Email address.
- Make sure the User Type = Business User.
- Click on the Roles information tab.
- Select the Role created in the prior step.
- Click SAVE.
- Ignore any warning that there will be a charge for creating the User.
Create User with User-Based security
Important
Instructions vary slightly depending on the client defining their security as Role-Based or User-Based.
If you want to create a user with Role-Based security, please go to the previous accordion item: Create User with Role-Based security.
Create Web Service User
- Company > Web Service User.
- Click NEW.
- Input values for these fields:
- User ID.
- Last name.
- First name.
- Email address.
- Make sure the User Type = Business User.
- Click SAVE.
Add permissions to that new user
- Sage Intacct will return to the list of Web Service Users.
- Find your Web Service User and click on Subscriptions.
- Click on the necessary Permissions for each applicable module listed below:
- Company - list/view access to Entities, Departments, Locations and Channel.
- General Ledger - list/view access to Accounts and list/view/add/edit/delete access to Journals.
- Accounts Payable - list/view access to Tax Detail.
- Click SAVE.
Getting started
Connect your Sage Intacct platform to Employment Hero Payroll
- Log into your Employment Hero Payroll platform.
- Click the Business Settings menu.
- Click the Payroll Settings submenu.
- Under Business Management, click Integrations.
- Locate the Sage Intacct logo and click the Add button.
- Fill in your Company Id, User Id and User Password.
- Click the Connect to Sage Intacct button.
- Once you have connected to Sage Intacct you will have the option to select which entity you would like to send your payroll journal to. The default option is top level but you can click on the drop down list, select the entity you wish to connect your payroll file to.
- Click the Save button.
NB: Once you have entered your login credentials, the user ID will be truncated and the password hidden and it will not be stored.
Data management
Locations, classes and departments
To set up location specific settings which can be mapped to employees, you can:
- Click the Business Settings menu.
- Click the Payroll Settings submenu.
- Under Pay Run Settings, click Locations.
- Click the Import button.
- Click the Import Sage Intacct Locations button.
For each location, you have the option to assign these dimensions from within your Sage Intact file:
- Classes
- Departments
- Locations
The purpose of assigning these dimensions to your locations is to then assign the locations to your employees, and the pay run totals will be amalgamated and flow through to your dimensions in Sage Intacct with your pay run journal.
Please refer to the Locations support article for more information.
Once you have configured your pay run option, the next step is to set up your chart of accounts by going to the payroll settings tab on the payroll dashboard, click on 'Chart of accounts' under the business settings heading.
Importing your accounts from Sage Intacct
You can import your payroll accounts directly from Sage Intacct for use in payroll. To do this, you can:
- Click the Business Settings menu.
- Click the Payroll Settings submenu.
- Under Business Settings, click Chart of Accounts.
- Click the Import Accounts button.
- As you are already connected to Sage Intacct a list of accounts will show and you can then enable the accounts that you would like to use in the chart of accounts mapping. You can enable the required accounts by clicking on the toggle button as shown below:
- Click the Save Accounts List button to save the configuration.
Configuring your accounts
Once you have imported and saved the required Sage Intacct accounts, you can map them within the Chart of accounts page. To do this, you can:
- Click the Business Settings menu.
- Click the Payroll Settings submenu.
- Under Business Settings, click Chart of Accounts.
- Click Default Accounts.
You'll see a list of transaction types that need to be mapped to a Sage Intacct account. The Sage Intacct accounts appear in the drop down list next to the transaction type. You can select the same account for multiple transaction types.
NB: When you map your default GL accounts, you'll notice that there is an option to Split by location. This allows you to write a transaction line per location to the journal for the same account. This is particularly useful if you're using locations, classes or departments within Sage Intacct.
Further information on location specific account mapping can be found in the Mapping GL Accounts support article.
NB: If you are using a nominal account from your chart of accounts which has disallow direct posting selected in Sage Intacct, your journal will error if you try to allocate payroll funds to this account.
Once you've completed all the mappings, you are now ready to export a journal.
Exporting your pay run journal to Sage Intacct
Once you've completed a pay run, you'll be able to export a journal to the Sage Intacct journals. You can export a journal by following these steps:
- Once you've created and completed your pay run, click Finalise pay run from the Pay run actions tab.
-
In the Finalise pay run dialog, ensure Export journals to Sage Intacct now is selected:
-
Click Finalise pay run and your journal will be exported.
You will find your journals with the journal page in Sage Intacct in the Payroll Journal folder. Click the view transactions link to find all of your pay run journals.
If you need to edit your pay run, when you finalise you can export the journal again and it will override the previous journal. Likewise, if you need to delete the pay run your journal will automatically be deleted from Sage Intacct.