Creditors Reconciliation

<< Click to Display Table of Contents >>

Navigation:  Modules > Financial Management > Accounts Payable >

Creditors Reconciliation

Overview

This web 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 perform all application functions.

 

Navigation Path

Financial Management → Accounts Payable → Creditors Reconciliation

 

Typical Users

Payables staff (creditors clerks)

 

Risk Factors

It is highly recommended to use this application in conjunction with generate payments to ensure only reconciled accounts are eligible for payment.

 

Function

When the application is opened you will view the following creditors reconciliation screen:

 

Complete the selection criteria and click on the 'Load' button to view existing recons or to create a new recon.  If a recon exists for the selected supplier, it will be displayed in the grid.

 

The 'Documentation' button will open the Doc Vault and allows you to view any attachments:

 

The 'Actions' button gives you the following 'Edit', 'Delete' and 'Print' options:

 

Edit – Allows you to edit the corresponding recon:

 

Only certain fields will be available for amendment.

 

 

Switch between lines using the 'Deduct Recon Items: On Statement, not in Ledger' and 'Add Recon Items: In Ledger, not on Statement' buttons.

 

The 'Add line' button allows you to add lines to the recon:

 

Select one of the following options - Withholding VAT, Payments not reflected on statement, Invoices not processed:

 

Complete the detail on the deduct recon items screen as required:

 

The line will be added to the recon.  Lines can be edited or deleted using the buttons at the end of each line.

The recon summary will display the balance difference.

The 'Copy' button allows you to copy items from another recon.

 

The 'Post' button will post the recon.

 

You will receive the following confirmation message:

 

 

Delete – Allows you to delete the existing recon:

 

Print – Generates a print preview of the corresponding recon in a new tab:

 

Use the 'Search Criteria' button to select a different supplier.

 

The 'New Creditors Reconciliation' button allows you to start a new reconciliation.  Users can add recon item lines & produce a balanced reconciliation for a selected period.

 

Complete the fields as required and add the lines for the recon.