Harmony integrates with Sage 50 (also known as Sage 50cloud, previously known as Simply Accounting).
Prerequisites:
- Have posted the payroll you want to export from Harmony
- Have created your account codes/numbers in Sage 50
Solution:
I. Setting Up Your GL Export Interface
- In Harmony, navigate to the Payroll module.
- Navigate to Admin Settings > Interfaces > GL Export Interfaces.
- Find “SAGE50** - Sage 50”. Toggle this to activate it and set it as your default export interface.
II. Define Your GL Account Numbers/Names
- In Harmony Payroll, navigate to Payroll Setup > General Ledger Setup > Account Setup.
- Define your debit/credit account numbers for each department and/or payroll category that you have identified in your application.
- Click the save icon at the top right of this window to save your changes.
III. Define Your GL Account Structure
- In Harmony Payroll, navigate to Payroll Setup > General Ledger Setup > Structure.
- You can either create a new structure, or modify the pre-existing one that comes default in Harmony. By default, the structure is “Category GL” only. If you require departments code and/or department GL account numbers, you can make this change.
IV. Export Your Payroll / GL Entries
- In Harmony Payroll, navigate to Processing > Create GL Records.
- Select the appropriate filters for “Payroll Group” and “Filter by”.
- Click the refresh icon to pull up a list of employees according to your filters.
- Select the employees you want to create GL records for.
- Click “Create”. A document icon will appear next to your employees’ names. Click this icon to view their GL record.
- Select the employees you want to export. Ensure that the correct GL Export Interface is selected in the far right dropdown list and click “Export”.
- Enter the "Reference" as required.
- Click “Export”. Your file should now be downloaded to your browser’s default downloads folder. Use this file to import into Sage 50.