Processing -> Client -> Receipt Import

The User must have access under the Role. 
The Security option is available under the Processing Section of the Role  Processing: Client: Import Receipt

The Receipt Import process can import a file and record the amount in the file (receipt deductions) against loan instalments which are due.  Be careful: the process can be executed more than once. 

Processes is running on a daily basis (CAT) : 05:00, 07:00, 09:30, 11:00. 12:30, 15:30, 17:10

To use this process:

• The process must be activated on the Security Role Setups.
• The legal entity bank account must be set up
  • The Payroll File Layout(s) must be set up
  • The receipt event must be set up, Event setup will look as follows:
    • Description: eg. Receipt Import Event (This is the Event display name)
    • Transaction Description : eg. Receipt Import Event (This is the description that will reflect on the client transactions)
    • Dr: Specify the account where the Payment is reflecting, eg. Bank account, CashBox
    • Cr: This will always be the Client Control Account (6620 -0000)
    • Event Attribute: Specify the type of receipt, eg. Cash Receipt, EFT Receipt,

The process will ask for the following:

• Effective Date : Enter the date on which the receipts must effect the interest. The Effective Date will indicate the date used for interest calculation purposes.
• Transaction Date : Enter the date on which the receipt must reflect on the general ledger.  The Transaction Date should be the date on which the transaction was recorded. 
• Select a File :  Select the file that must be imported to process the receipt on the loan instalments due. 
• Bank Account : Select the legal entity's bank account that must be debited.  The debtor (borrower/client) will be credited.

The Negative Receipt Amount won't be recorded in the Receipt Import Process.  If there is a Negative Receipt in die File it will be written to the Receipt Import Log.
Make sure your import file do not have any formulas or VLOOKUP

Receipt entries with negative amounts will reverse the receipt if a receipt transaction with exactly the aame amount can be found. The next step will be to search for and reverse the receipt being disputed.

If the Linking Colomn is the e.g. Account Number and your file format is in Excel - format the colomn in a text field.  Hightlight the Cell > Go to Format Cellls > under the Number change it to Text.

Cancel-button: You will return to the previous page without the process being executed

Finish-button: The function will process the file