Overview
This application enables users to compare a supplier’s monthly statement (external document) to the supplier’s closing balance in DeltaERP for a selected period, identify and analyse differences and, if needed, make required corrections.
Supplier reconciliation detail and summary reports are available from this application and can be (re)printed for each period upon completion of the reconciliation process.
Only users with access level 3/Other will be able to view all tabs and perform all application functions.
Function
Recon Detail tab
When the application is opened you will view the following:
By default, the Recon Detail tab will be the active tab when the application is opened. The 
button gives you the following options:
The New option allows you to start a new reconciliation. Users can add recon item lines & produce a balanced reconciliation for a selected period.
Select a supplier using the picker. You will receive the following confirmation message:
Select the following detail relating to the recon:
In order to copy reconciling items, select the tick box available.
If a recon exists for the selected supplier, the fields will be populated as follows after selecting the supplier:
The Period drop-down gives you the following options:
All periods available to recon will be displayed here for selection. Alternatively, you can select to start a new reconciliation.
Status refers to the status of the reconciliation e.g. Captured.
GP (General Payments) Run Date allows you to select a using the date picker.
All the amounts relating to the selected supplier will be displayed in the grid on the right, indicating the following:
The Deduct Recon Items and Add Recon Items tabs determine where a line is added to:
If you click on the 
button you will have the following options:
Deduct Recon Items: On Statement, not in Ledger:
Invoices not processed (no GRV processed)
Invoices not processed (GRV processed)
Extract from the system:
Manual Capture
Payments not reflected on statement
Withholding VAT
Add Recon Items: In Ledger, not on Statement:
Add Recon Items: In Ledger, not on Statement:
Other
Adjustments to be made by Supplier
Invoices processed not on statement
Lines can be selected from each tab and edited or deleted using the 
and 
buttons.
The 
button allows you to attach supporting documentation.
Ensure that you are viewing the correct tab before uploading documents. Documents uploaded will be attached to the active tab.
Once all the details have been entered and confirmed, click on the 
button to complete the recon.
The 
button gives you the following options:
Complete the selection criteria and click on the 
button to generate a report preview.
Extended Detail (Including System Trans) Report Example
Short Detail Report Example
Detail Report Example
Summary Report Example
Incomplete supplier reconciliations Report Example
View Suppliers Approved Status tab
Indicates the latest reconciliation period in which supplier was approved or rejected for payment.
Complete the filter criteria to display the data in the grid:
The 
button allows you to export the data to a Microsoft Excel spreadsheet for future use/reference.
Recon Statistics tab
This tab allows you to populate the grid with information relating to reconciliations.
Complete the selection criteria as required and click on the 
button to retrieve the information:
To include ageing and suppliers with zero balances, tick the available boxes.