Sage 300 ERP Bank Interface Seamless
The following steps will guide you through the process of exporting your bank data from Clarity, and importing the data into Sage.
Clarity Export:
*Ensure you have posted all payroll information.*
Steps:
- Go to Payroll > Export > Export to Bank Services Special.
- Enter the appropriate settings in Bank services parameters tab:
- Bank Code: This is the bank code in Sage. This bank code has to exist
- Statement Date: Date of the statement.
- Stock Code: Check Stock Code in the Bank record in Sage
- System Manager Version: Version of the system manager. Note: If you are using 5.6A, enter 56A (do not include the '.') or if you are using 5.3, just enter 53
- Status: outstanding (3) or printed (9). For versions later than 5.3A, this has to be 3
- If records exported with printed (9) status then Sage user can post them and the status will be changed to outstanding
- If records exported with outstanding (3) status, Sage will treat these entries as posted entries and Sage user will not be able to post them - User ID and password: These have to be entered in capital letters.
- Company ID: Company ID in Sage.
- Click on Next and select the items from the list to be exported and then click Export.
Note: Only information that has not been previously exported will be included. If you wish to re-export data, you can do so using the ‘Export to Bank Service Special’ function (which is date-controlled).