Importing Debtor Contributions (Ezidebit)

Debtor Contributions Bulk Import

A custom data import process allows you to import Debtor Contributions via a CSV file.

This process is currently configured for Ezidebit settlement file formats, which are sourced from the settlement file via your Ezidebit gateway.

Payments are matched to Debtors via the Ezidebit 'ClientContactRef' which matches the Job Short Name entered in Insol 6.

To import a debtor contribution receipts file

1. Navigate to the Practice (using the LHS practice menu).

2. Click the Import/Export Data toolbar.
   

3. Select the "Import Custom Data" menu item.
   The import option dialogue appears.
   

4. Select the import option.

5. Click Next
   You will be prompted to select an import file type.

6. Select the file import type

   • Select the "Ezidebit csv file" option.
     

   • Select "File to Import"
     The select file dialogue appears and you will be prompted to locate a file.
     

7. Select the file and click "Open"
   The file is selected.

8. Click "Next"
   The import filter appears.
   

9. Filters

   Chose the filter options:

   • Select the trust account

   • Select the option for the treatment of dishonour fees
     By default any dishonour fees will be allocated to an expense in each relevant job, which will reduces the funds available for distribution.

10. Click "Finish" to Import the data.
    The receipts are now imported.

Validation

The import spreadsheet columns and data are validated before the import process begins.  For instance, if the spreadsheet has already been imported

Similarly, if any of the debtors cannot be identified (i.e. the job short name does not match with the "Client Contact ref" in the spreadsheet then a validation warning will appear.

The import also validates other data, including:

• missing settlement dates
• missing Client Contact references
• incorrect or missing dishonour codes 
• no contribution records for the debtors
• inactive contribution records

Imported entries

Take note of the following aspects of the entries are processed:

• Payer fees are not recorded, the net amount is allocated as a debtor contribution.

• A detailed receipt to the grouped "Deposits and payments" account (in the practice). The receipt is coded to the account "Debtor Contributions (Voluntary)" and allocated to the latest open debtor contribution matched to the job. The Ezidebit "ClientContactRef" is matched to the Job Short Name.

• A grouped receipt is created in the trust account. This represents to total of the entire Ezidebit import.

• When selecting the default filter option, dishonour fees are created as trust account entries allocated to the job.

• A contribution is entered under "Entry from Trust" in the Job.

• A realisation charge expense and liability payable is created based on the amount settled.

• The # job short code is referenced in the memo field of each imported transaction.
  

• The amount representing each job's balance is displayed on the memo of each imported transaction.

Note

See the "Trust account audit report".