Creating a Supplier Payment Reconcilation

A supplier payment reconciliation is an Import of a Supplier Statement in the form of a Excel spreadsheet of all records of Transactions that have been purchased from a supplier. 

Before you can commence with the Extract of the Supplier Payment Reconcilation please ensure you have the following information from the supplier on the spreadsheet:

• Statement from the Supplier in either a Excel or CSV format
• Save the spreadsheet in a folder on your PC
• Ensure the following 3 fields are on the spreadsheet from the supplier : Date, Supplier Invoice, Value
   

1. In the navigation panel, double-click Relationships then Supplier Transactions.

2. Click Payment Reconciliation, then click New. The Supplier Payment Reconciliation window displays.

    

    Show Me

   

3. Enter header details for the payment reconcilation 
   
   • Select the supplierid
   • Enter a description to best describe the reconciliation
   • Click on Save
   • Then Click on Import Statement 
   • Go to the folder where the spreadsheet from the supplier is saved
   • Click on Open

   • A Pop up window will appear with the number of transaction and number of reconciled transactions

      Show Me

     

   • Click on OK to preview the data that has been imported and matched from the spreadsheet selected.

      Show Me

     

   • This process extracts the data that is on the Excel Spreadsheet and Matches it to the Data within readysell. If the supplier invoice that is on the spreadsheet does not match was it is readysell the flag 'Matched' if OFF.
   • Click on Save Button or Save and Close Button.