Introduction

TRDB has been designed and developed for Finance Brokers and Credit Providers who need an efficient and easy-to-use tool to calculate and monitor their commissions both for their consultants and general brokerage and strictly adhering to the standards and regulations as set out in the Finance Brokers Control Act 1975 Section 44(1) and (2).

TRDB is a Microsoft Access (97-xp) application running on most standard PC’s under Microsoft Office versions 97 – xp.

It has been developed and fully field-tested with a local credit provider (CreditForce, contact: Rodney Hansen) since middle of 2003 and has proven to be a reliable and intelligent tool for all their trailer and commission management requirements.

Menus and Options

Maintenance TRDB has facilities to maintain data such as: borrowers and their details lenders and their rates consultants and their commission rates and split % where applicable lookup codes (e.g. loan groups, lender categories) used in reports/statistics for grouping Transaction Processing TRDB’s main interface is a powerful but friendly transaction entry and processing screen which allows to: Import lenders CSV trailer files which are processed in full, i.e lender and borrower are identified via the loan numbers, commissions are calculated and compared against the trailer paid and warning flags are shown where limits are exceeded Handles variable payment periods of a lenders Allows consultant’s commission to be split Handles partial commissions (e.g. when account management fees are part of the payment and thus not subjected to the act) Identifies new loans automatically Allows manual entries for nominated lenders/period Allows to replace a consultant within a period Shows and reports transactions by lender and period Shows all new loans for a batch Shows overpaid/underpaid commissions Allows transaction recording against multiple companies (within your organisation) Reporting TRDB produces comprehensive reports to assist in monitoring and tracing commissions and lender payments as follows: - Consultants summary by consultant, period Lenders transaction summary by lender, year and month (also shown as charts) Transaction summary by loan group Organisation excess commission payments report Consultants excess commission payments report Sample screens: Click on links to see image Transaction entry and processing screen Example of a transaction report

Commission Calculator

Calculates and verifies maximum client rate and commission based on loan amount, base rate, terms and other lender parameters and the 5% per annum maximum commission allowed. It will display a warning when the loan commission exceeds the maximum allowed, and will only allow to print an ‘approved‘ detail sheet when the (current) 5% rule is satisfied.

Shortlist
The shortlist allows to view and edit existing entries, also to add and delete entries.

Important: the ‘subjected’ amount means the amount subjected to the 5% rule, ie no brokerage to be taken into account. A detailed loan setup with separate amounts for warranty, insurance can be entered in the details screen (see 2.) see screenshot

Apart from a general ‘Find’ button (binoculars), this screen allows to search for applicant, application number and lender, and also allows to filter for approved and unapproved entries. An entry is ‘approved’ when the client rate/commission are under 5% limit. Hardcopies of the shortlist can be printed using the Preview/Print buttons.

Details screen
This screen contain the complete loan application figure setup and lender/calculation parameters which can be varied according to lender requirements. Currently two different calculation formulas are being used (for Esanda and GE). Additional formulas can be added if required.

In order to check and optimise a commission calculation, the relevant amounts are entered, including lender parameters (e.g. %Overs), and the rate increments (steps for calculation) one wants to use to optimise the result. For instance, a 0.01 step will result in a calculated optimal client rate to a hundredth of a percent. Clicking the ‘Optimise client rate’ will calculate the optimal maximal rate, and a prompt appears if the user wants to save this value in the client rate field above. As soon as the current commission amount is lower than the ‘Maximal commission’ (=5% p.a. of the subjected amount) the ‘Approved’ tick box will be ticked and the Preview and Print buttons will be undimmed and the details sheet can be printed to be filed. Any client rate lower than the ‘optimal’ rate is allowed in order to get the application approved, naturally.

Pricing and Contacts

TRDB Single-user version:	$ 1800 + GST (MS Access not included)
TRDB Network version: (multi-user)	$ 2500 + GST (MS Access not included)
Installation: included
Warranty: 12 months
Training: 4 hours of detailed training are included.
Customisation can be provided and will be quoted on request.
Contact:	Angie Hayes Phone: 08-8981 1432 Mobile: 0438014669