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 can 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 that 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:
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.
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
- 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
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:
- Departments.
- Locations.
- Classes.
- Projects.
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.
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.
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 will 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 will 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 are using locations, classes, projects, 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 have completed all the mappings, you are now ready to export a journal.
Once you have completed a pay run, you will be able to export a journal to the Sage Intacct journals. You can export a journal by following these steps:
- Once you have created and completed your pay run, click Finalise pay run from the Pay run actions tab.
-
In the Finalise pay run dialogue, select Export journals to Sage Intacct now.
-
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.
Comments
Article is closed for comments.