A supplier payment reconciliation is an extract of an Excin Readysell records a payment for goods that have been purchased from a supplier. Once the payment has been entered and allocated, a supplier remittance can be sent to the supplier.
Before you can commence with the Extract of the Supplier Payment Reconcilation please ensure you have the following information from the supplier:
- Statement from the Supplier in either a Excel or CSV format
- Save spreadsheet in a folder on your PC
- Ensure the following 3 fields are on the spreadsheet from the supplier : Date, Supplier Invoice, Value
- In the navigation panel, double-click Relationships then Supplier Transactions.
Click Payment Reconciliation, then click New. The Supplier Payment Reconciliation window displays.
Expand title Show Me 
- 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
Expand title Show Me 
Click on OK to preview the data that has been imported and matched from the spreadsheet selected.
Expand title 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.