Wasim Akhtar

Database Architect, Designer and Developer
My motto: If you can explain it to me, I can develop it for you!
Skip Navigation Links.
Copyright © 2000-2011
Practical Software Solutions

PSS Logo

Website Updated
23-Nov-2011
 Debt Settlement Manager
Purpose Used to manage all aspects of debt management and settlement by a leading debt settlement company

Description This application offers seemless integration of all activities related to managing and settling credit card debts. It helps track contacts with all parties involved in the settlement process, including clients, their creditors as well as agents representing creditors.

To assist users in quickly accessing a client's account status, they can search by a several different criteria. Multiple search results display a list of clients or their cases, which can be used to drill to the details about any client or their cases.

Follow-up tasks and conversation notes, such as phone calls, about each client and/or their cases are created and tracked to provide a complete history of the account, as well as the current status of every client. Many tasks and notes are automatically generated upon occurrence of key events, such as completion of a settlement or account closure.

Details about settlement offers, as well as counteroffers are tracked. Offers can be generated in bulk or individually, based on each client's trust account balance.

Dozens of pre-filled MS-Word® templates are available to users to save them time in creating documents produced during the normal course of business. These Canned Letters are also tracked to avoid unnecessary duplication.

Electronic Fund Transfers (EFTs) are automatically created based on the amount, frequency (e.g., weekly, semi-monthly or monthly), processing date and need for settlement funds. These EFTs are then submitted to the EFT Clearing House and their processig status posted in the system.

It creates hundreds of offer letters based on funds available in the client trust accounts on that day .

The system also creates and manages settlement payments to creditors and their agents. Payments can be scheduled in any combination of amounts based on the projected availability of funds in a client's trust account.

In short, all elements related to Client Services, Account Services, Settlement Services, Electronic Funds Transfer, Accounts Receivables, as well as Agent Commissions are handled through this application.

Features Following are some of the key features of this application:
  • One form is used to integrate all aspects of a client's account
  • One tab integrates EFTs, Payments and Accounting data
  • Very flexible search capabilities
  • Automatic EFT creation, submission and processing
  • EFT amounts and processing dates can be changed at any time
  • On a client's request, any number of EFTs can be skipped
  • Tasks can be assigned to an individual or a department
  • Tasks in progress are highlited to indicate that it is being worked on
  • Clicking on a Client ID automatically opens that record
  • Clicking on a Creditor or Agent's name automatically opens that case
Components This application comprises of the following main components:
  • Main Menu: Provides integrated search with task summaries
  • Client Form: Holds complete information about a client's account and access to client reports
  • Reports Panel: Provides access to reports for all users
  • Managers Panel: Provides access to reports and features used by managers
  • Admin Panel: Provides access to reports and features used by executives
Details To view more details about this application, click on the following links:

Main Menu Client Form - EFT Tab Canned Letters
Case Details Case List Auto Letters
Admin Panel Managers Panel Reports Panel
Schema

System Requirements Following are the minimum system requirements for this application:
  • Microsoft Access 2000+
  • Microsoft SQL Server 2000+

MS-Access, MS-Word and MS-SQL Server are the Registered Trade Marks of Microsoft Corporation