To export the journals you will need to set up a chart of accounts and link the journal to an online accounting software. To do this you will need to go to Payroll Settings > Business Management > Integrations.
The list of integrations available are pictured above. The integrations which are fully automated are Xero, Quickbooks Online, FreshBooks, Zoho Books and Microsoft Dynamics 365 Business Central.
You can create a general export in a specified file format which you can upload into Sage, NetSuite and NetSuite OneWorld, or a provider of your choice using the File Export or Detailed File Export if you have a different accounting software.
For the purpose of this example we are going to go through connecting to Xero.
- Go to 'Payroll Settings' > 'Business Management' > 'Integrations'.
- Go to 'Xero' and click 'Add'.
Once you have selected 'Xero', Click the 'Connect to Xero' button:
You will then be transferred to the Xero website in order to choose an organisation and authorise your business to have access to your data
Accounting Integration
In order to continue using Xero as the accounting system for your payroll data, you’ll need to complete a couple more steps.
Once you are connected you need to select which business you want to send your payroll journal to.
Then you need to choose whether you want to export your pay run data as a manual journal or accounts payable invoice.
If you choose to export your data as a manual journal, you can also specify whether or not it is posted as a draft journal.
Now that you have enabled the accounting service you need to set up a chart of accounts. To do this you need to click on Chart of Accounts on the left hand side of the screen or you can click on the highlighted text that says: Now that you have an accounting service enabled you can "Set up a Chart of Accounts".
Now that the journals have been linked we can import our nominal codes by clicking on the 'Import Accounts' button pictured below:
Once you have imported the accounts you will be able to see all of the nominals for this business:
You can toggle the codes that you are going to use and scroll to the bottom of the page and press 'Save'. With the nominal codes now imported you can set up the chart of accounts. If you click on the Default Accounts you can configure the accounts by clicking on the accounts and selecting the correct codes of where you want it mapped to. Once you have completed that you will need to press save and then configure the pay categories and the deduction categories.
Splitting by location
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 per line per location to the journal for the same account. This is particularly useful if you are using locations, classes or tracking categories. If you want to split your GL by location and allocate the transactions to a different GL account you can define location specific accounts. These accounts will work in exactly the same way as the primary accounts, however they will only apply to the location they are specified for.
To watch a YouTube video of Exporting Journals to your Accounting System with Director Pays please click here.