Looking for something?

You will find your answers here!

    Sorry, we didn't find any relevant articles for you.

    Send us your queries using the form below and we will get back to you with a solution.

    How to use Paya Connect Desktop and Paya Exchange to Share Data

    Product

    Paya Connect Desktop (PCD)

    Paya Exchange (PEMS)

    PCD Integrated solutions

    Description

    Paya Exchange is a simple, all-in-one payment management system, where you can connect all forms of payment devices to your accounting software.

    You can connect your credit card payment devices (such as the Ingenico iPP320) and mobile devices using Sage Mobile Payments to Paya Exchange. This allows Paya Exchange to provide you with up-to-date views into your connected payments network.

    Paya Connect Desktop serves as the connection point between your accounting application and Paya Exchange; therefore, you must install and configure it if you want to use Paya Exchange. If you have not yet installed Paya Connect Desktop, click Install Paya Connect Desktop on the Login page of Paya Exchange.


    Resolution

    Configuring Paya Connect Desktop for use with Paya Exchange

    After installing Paya Connect Desktop, you must configure it for use with Paya Exchange. 

    The configuration process consists of:

    • Registering (or pairing) your Paya Connect Desktop installation in Paya Exchange, which will allow you to access your accounting data.
    • Installing and enabling plugins.
    • Select specific General Ledger (GL) accounts for each installed plugin. The plugin configuration process allows you to select which GL accounts you want to make available for selection when you create a connection in Paya Exchange.

    After registering Paya Connect Desktop in Paya Exchange and configuring plugins, you can begin adding devices such as credit card swipers, check readers, shopping cart web pages, and mobile devices running Sage Mobile Payments as components in Paya Exchange. You can then create connection maps in Paya Exchange.


    Registering Paya Connect Desktop in Paya Exchange

    Follow the steps below to register your Paya Connect Desktop installation in Paya Exchange:

    1. Right-click the PCD Icon running in the Microsoft Windows system tray then select Settings to open the Paya Connect Desktop - Settings window.
    2. Expand the Data Exchange menu then click Register.
    3. Enter your Paya Exchange email address in the User name field.
    4. Enter your Paya Exchange password in the Password field.
    5. Click Register to complete the registration process and to add the Paya Connect Desktop installation as a component in Paya Exchange. Do not close the Paya Connect Desktop - Settings window.


    Installing and Configuring plugins

    This section includes a procedure for each available plugin in Paya Connect Desktop. After registering Paya Connect Desktop in Paya Exchange, follow the procedure for the plugin that corresponds to your application.


    Understanding PostBack

    Cash sales and invoice payment connections generate postback transactions from Paya Exchange. If you are installing and configuring the Sage50 (or Sage100) Accounting plugin, the posting method you selected for your company determines how Sage Accounting software handles postback transactions:

    • Real-Time - Transactions that users enter (then save) in Paya Exchange connected applications immediately post to the designated general ledger accounts in the accounting application.
    • Batch - Transactions are saved as a batch that you must manually post in Sage Accounting software. Using this method, you review the batch of transactions then choose the journals to which you want to post the transactions on the Post window (Tasks > System Post).
    • SmartPosting (Recommended) - Available only to Sage Quantum Accounting companies, SmartPosting is a service that automatically searches the accounting application’s database at regular intervals for saved transactions to post to the general ledger accounts.

    If you are installing a plugin on a multi-user workstation, we recommend installing it for only one user (typically the system administrator). This will prevent other users from accessing the general ledger accounts.



    To Install and Configure the Sage50 Plugin

    1. Open Sage50 and connect to the company you want to use with Paya Connect Desktop. Minimize the Sage50 window but keep the application open.
    2. Restore the Paya Connect Desktop – Settings window then expand the Data Exchange menu.
    3. Click Get Plugins to search for available plugins.
    4. Locate the Sage50 plugin that corresponds to your installed version of Sage50.
    5. Click Install to install the Sage50 plugin.
    6. Click Yes to enable the plugin.
    7. Click My Plugins to view your installed plugin.
    8. Click Options to open the Sage50 window.
    9. Click the Please Select your Company link to open the Company window.
    10. Select the company you want to connect to in the Company field then click OK. The Paya Connect Desktop may display an error message. If so, click OK to close the error then click OK to close the Sage50 window.

      Note: Paya Connect Desktop can connect to only one company. Additionally, you cannot change the company selection.

    11. Restore the Sage50 window, where the Third-Party Application Access window displays.
    12. Mark Always Allow access then click OK to close the Third-Party Application Access window.
    13. Optionally, select Maintain Company Information > Posting Method to open the Posting Method window, where you can verify (or change) the selected posting method.
    14. Close Sage50 then restore the Paya Connect Desktop – Settings window.
    15. Click the My Plugins node.
    16. Click Options to open the Sage50 window.
    17. Click the General Ledger journal you want to work on within the left-hand pane. Paya Connect Desktop populates the right-hand pane with the General Ledger numbers in the selected journal.
    18. Mark the Account ID column for each General Ledger account you want to make available for selection when adding a connection in Paya Exchange. Optionally, enter a keyword in the search field to filter the General Ledger accounts.
    19. Click OK to accept your selections and to close the Sage50 window.
    20. Click OK to close the Paya Connect Desktop – Settings window.


    To Install and Configure the Sage100 Plugin

    Before you begin the procedure below, open Sage100 and connect to the company you want to use with Paya Connect Desktop. Minimize the Sage100 window but keep the application open.

    1. Restore the Paya Connect Desktop - Settings window then expand the Data Exchange node.
    2. Click Get Plugins to search for available plugins.
    3. Click Install to install the Sage100 plugin.
    4. Click Yes to enable the plugin.

      Note: If Sage100 is not running, Paya Connect Desktop automatically opens the Sage100 - User Login window, where you must log on to Sage100. 

    5. Click My Plugins to view the installed plugin.
    6. Click Options to open the Sage100 window.
    7. Mark the company that contains the journals you want to make available for selection when adding a connection in Paya Exchange in the Select the companies you want to access in the Paya Exchange group box. Paya Connect Desktop may display an error message. If so, click OK to close the error then click OK to close the Sage100 window.
    8. Restore the Sage100 window, where the Third-Party Application Access window displays.
    9. Mark Always Allow access then click OK to close the Third-Party Application Access window.
    10. Optionally, select Maintain Company Information > Posting Method to open the Posting Method window, where you can verify (or change) the selected posting method.
    11. Close Sage100 then restore the Paya Connect Desktop - Settings window.
    12. Click the My Plugins node.
    13. Click Options to open the Sage100 window.
    14. Mark the journals that contain General Ledger accounts you want to make available for selection when adding a connection in Paya Exchange in the Source Journal List group box.
    15. Mark the Account ID column for each General Ledger account you want to make available for selection when adding a connection in Paya Exchange in the G/L Account List group box.
    16. Optionally, select another company in the Select the Companies you want to access in the Paya Exchange group box then repeat steps 14 and 15 to make general ledger accounts from another company available for selection in Paya Exchange.
    17. Click OK to accept your selections and to close the Options window.
    18. Click OK to close the Paya Connect Desktop - Settings window.


    To Install and Configure the Sage300 Plugin

    1. Restore the Paya Connect Desktop - Settings window then expand the Data Exchange node.
    2. Click Get Plugins to search for available plugins.
    3. Click Install to install the Sage300 plugin.
    4. Click Yes to enable the plugin.
    5. Click My Plugins to view the installed plugin.
    6. Click Options to open the Paya Exchange - Sage300 window.
    7. Mark the company that contains the General Ledger accounts you want to make available for selection when adding a connection in Paya Exchange in the Select Company group box.
    8. Click a journal in the Select Accounts group box to display its General Ledger accounts in the right-hand side of the group box.
    9. Mark the General Ledger accounts you want to make available for selection when creating a connection in Paya Exchange.
    10. Repeat steps 7‐9 as necessary to select additional General Ledger accounts.
    11. Click OK to accept your selections and to close the Paya Exchange - Sage300 window.
    12. Click OK to close the Paya Connect Desktop - Settings window.


    Managing Plugins

    Follow the procedure below to check for plugin updates or to disable a plugin

    To search for and install plugin updates

    1. Right-click the SE icon running in the Microsoft Windows system tray then select Settings to open the Paya Connect Desktop - Settings window.
    2. Expand the Data Exchange node.
    3. Click My Plugins to view your installed plugins.
    4. Click Check for plugin updates in the upper-right hand corner to search for plugin updates.
    5. Click Yes to install each available plugin update.


    To disable a plugin

    1. Right-click the SE icon running in the Microsoft Windows system tray then select Settings to open the Paya Connect Desktop - Settings window.
    2. Expand the Data Exchange node.
    3. Click My Plugins to view your installed plugins.
    4. Click Disable for the plugin you want to disable.
    5. Click OK to accept your changes and to close the Paya Connect Desktop - Settings window.


    Adding a Connection in Paya Exchange

    After configuring the plugin for your accounting software, follow the procedure below to add a connection map in Paya Exchange. 

    1. Go to https://www.sageexchange.com to access Paya Exchange then enter your login credentials in the User Name and Password fields.
    2. Click the Connections tab to open the Connections page.
    3. Click the Accounting Software plugin in the Connections Map section to display the connections map below.
    4. Locate the component you want to connect in the Components section.
    5. Drag and drop the component from the Components section to an empty place on the connections map to open the Connection Type page of the Map Connection window.
    6. Select the connection type in the Select connection type field and then click Next to open the Settings page of the Connection Map window.
    7. Select the appropriate general ledger account numbers and settings for each account:

      Note: The configuration fields vary depending on the selected plugin. If a General Ledger account number is not listed in a field, open Paya Connect Desktop and review the selected general ledger account numbers for the plugin 


    Cash Sale Connections

    • If you are connecting to Sage50 (or Sage100) Cash Sales, select the General Ledger account to which you want to:
    • Debit the total amount in the Total Account field.
    • Credit the subtotal amount in the Subtotal Account field.
    • Credit the tax amount in the Tax Account field, then select how taxes are calculated and posted:
      • No Tax. Do not calculate tax.
      • Tax from Device. Paya Exchange uses only tax amounts provided by the component. No additional calculation is performed.
      • Calculate Tax After Deductions. Calculate tax as a fixed percentage of the total transaction after any other deductions are applied. Enter a tax rate in the Rate field to apply the amount to all transactions.
      • Calculate Tax On Total. Calculate tax as a fixed percentage of the total transaction. Enter a tax rate in the Rate field to apply the rate to all transactions.
    • Credit the tax amount in the Shipping Account field, then select how shipping is calculated and posted to the account:
      • No Shipping. Do not calculate shipping.
      • Shipping From Device. Paya Exchange uses only shipping amounts provided by the component. No additional calculation is performed.
      • Calculate Shipping. Calculates shipping as a fixed percentage of the total transaction. Enter a shipping rate in the Rate field to apply the amount to all transactions.
      • Flat Rate. Calculates shipping as a fixed dollar amount based on the rate entered in the Rate field. This amount will be applied to all transactions.

    Note: The tax and shipping calculations are not added to the transaction amount; conversely, they reduce the transaction total by the rate you enter in the Rate field. If the device captures and reports tax and shipping data, the reported data will override the calculated data.  Paya makes no representations or warranties, expressed or implied, as to the results produced by the operation, except as expressly provided herein. 


    Invoice Payment Connections

    • Select the General Ledger account to which the receipt is deposited in the Cash Account field of the Add Receipt group box.
    • Select the General Ledger account to which the customer payment is deposited in the Cash Account field of the Customer Payment Group box.


    Export Connections

    • Enter a name for the data file in the Name field.
    • Select Daily, Weekly, Monthly, Quarterly, or Annually in the Period field to select when the export occurs after the start date.
    • Enter a date range for the export in the Start Date and End Date fields.

    Note: Click More > Data Files on the Reports page to access your exported data files. 

    • Click Next to establish the connection and to return to the Connections page.


    Viewing Transactions in your Accounting Application

    The type of connection you add to Paya Exchange determines which General Ledger account you must open in your accounting application to view postback transactions:

    • Cash Sales - Open your accounting application and view transactions for your General Ledger account you selected in the Total Account field on the Settings page of the Map Connection window.

    Note: If you selected the Batch posting method for your Sage Accounting company, cash sales postback transactions do not display in the General Ledger account until after batch settlement. 

    When you use Sage Mobile Payments to process a credit card sale (non‐invoice), Sage Mobile Payments will create a corresponding transaction in Sage Accounting for the selected General Ledger account. However, if you process a cash sale, Sage Mobile Payments will not create a corresponding transaction in Sage Accounting. You must manually record the transaction in Sage Accounting for the General Ledger account.

    Tap History in Sage Mobile Payments to review a record of the cash sales you need to enter in Sage Accounting. Additionally, you can log on to My Sage Mobile at https://www.mysagemobile.com to view your cash transactions.

    • Invoice Payments - When you process a payment, Paya immediately creates a receipt in the general ledger account you selected in the Cash Account field within the Add Receipt group box on the Settings page of the Map Connection window. To view the receipt, open your accounting application and view a list of receipts or open the invoice or customer account to which the payment was applied to view the updated balance.


    If you have questions or require additional information, please contact us and we will be in touch with you shortly.



    Was this article helpful?

    Still can't find
    what you are looking for?

    Our award-winning customer care team is here for you.

    Contact Support

    Knowledge Base Software by