/
Clarity - Sage 300 ERP Bank Interface Seamless

Clarity - Sage 300 ERP Bank Interface Seamless

Feb 10, 2023

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:

  1. Go to Payroll > Export > Export to Bank Services Special.

  2. Enter the appropriate settings in Bank services parameters tab:

    1. Bank Code: This is the bank code in Sage. This bank code has to exist

    2. Statement Date: Date of the statement.

    3. Stock Code: Check Stock Code in the Bank record in Sage

    4. 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

    5. 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   

    6. User ID and password: These have to be entered in capital letters.

    7. Company ID: Company ID in Sage.

  3. 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).