Clarity integrates with several accounting/financials systems. In this article, we will go over how to set up your general ledger within Clarity. If you are using a system that we do not currently integrate with, please contact us! It is possible that it is listed under a different name, or it is compatible with our standard export interface. We also welcome new integrations to be built!
Table of Contents:
Pre-Requisites
- Know what financials system you are using & confirmed with Paymate that Clarity is integrated with it
- Know your chart of accounts / general ledger accounts
- Have posted at least one payroll
Setting Up Your General Ledger Accounts
- In Clarity, navigate to Setup > General Ledger Settings > G/L Accounts > 'List' tab.
- Double-click on the department that you want to add general ledger accounts for. You will automatically be redirected to the department's 'GL Accounts' tab.
- Enter the correct account numbers into the corresponding "Debit Account Number" and "Credit Account Number" columns.
- Click the checkmark icon to save your changes.
- Repeat steps 2 through 4 for each department that you have a general ledger account for.
Selecting Your Default General Ledger Interface
- In Clarity, navigate to Setup > Preferences > 'Interfaces' tab.
- In the General Ledger Settings section, select your "Default Export Interface" from the dropdown field.
- You can also optionally checkmark any of the other checkboxes: "Use code finder", "My GL accounts are same for all department(s)", "Use GL accrual method", "Always show units in cost allocation".
- Click the checkmark icon at the top-right corner of the window to save your changes.
Exporting Your General Ledger Entries
Note: You will only be able to export your general ledger entries if you have posted the payroll and committed it to history!
Steps:
- Navigate to Payroll > Export > Export to G/L Special.
- Head to the Method tab.
- Select the correct Export Method.
- Navigate to the 'Export Parameters' tab.
- Select the correct Groups to Include.
- Select the correct Date Range.
- Navigate to the 'Preferences' tab.
- Select the correct Application of Date Range.
- Select the Destination of where you would like to export the file and enter the "Export File Name". If the integration is seamless, you do not need to enter this information (it will specify in the name of the GL export if it is seamless).
- Select the correct "Batch Date".
- Apply any Controls as required.
- Navigate to the 'GL Parameters' tab.
- Enter any additional parameters as required, such as any "Memo" or how you want to identify your employees.
- Click "Next →" to continue. You will be brought to the 'Paycards List' tab.
- Select the paycards you want to export. If you want to include already-exported paycards, checkmark the appropriate checkbox. If you want to include non-exported paycards, check the appropriate checkbox.
- Click "Preview" to preview the file that will be created, or click "GL Report" to view the GL report.
- Click "Export" to export the file. Your file will be downloaded to the destination you set in step #8 above.
Note: You can open your exported file in Notepad to verify the information in there. Even if the exported file is a .CSV file, we strongly recommend using Notepad, as opening the file in Microsoft Excel can alter the data.
Tip: If you are using the standard GL detail export interface, the exported file will include the cheque/check number. If you are using the standard GL summary export interface, the exported file will not include the cheque/check number.