Excel credit scoring spreadsheet for effective credit control

£25.00 GBP

Approx. 31 EUR / 40 USD

On completion click
Return to Merchant
to download template

Credit Controller

Credit Controller Lite is an Excel based credit control template. It includes 14 credit elements scored on actual, average and trend values based on Altman's Z score creditworthiness index. Each element used in credit scoring can be individually tuned to match your own credit policy. This compares with the 27 elements of the full version Credit Controller, which makes the Lite Edition less flexible but easier and faster to tune and deploy. As with the full version, credit scoring can be adjusted to give more or less emphasis to actual, average or trend values in accordance with your own opinion of how each should be weighted.

Once tuned to conform with your organisations credit policy, Credit Controller will consistently recommend credit limits in a predictable and coherent fashion. This allows senior staff to delegate credit appraisals to less qualified employees. By automating the credit appraisal process, senior staff can concentrate on credit request rejected by Credit Controller. Consequently, by filtering out problem and higher risk credit requests, the vast majority of requests for credit can be approved automatically.

Product Features

  • Familiar and intuitive Excel interface.
  • Only key financial elements required, keeping data entry time to a minimum (less than 10 minutes).
  • Automatically highlights possible data entry errors.
  • Context sensitive user help text and user guide.
  • Automatically recommends a credit limit, payment conditions and payment method based on a credit risk assessment.
  • Provides the means to cross reference information from various sources and quantify it to produce systematic and objective decisions.
  • Print reports for distribution or archiving.
  • Save each credit request for future reference.
  • E-mail the decision process to those involved.
  • Problem areas are highlighted for quick analysis and assessment.
  • Mini graphs show key trends and credit scores.
  • Four stage decisions process:
  • 1. Limit requested by salesman.
  • 2. Credit Controller suggests an appropriate limit.
  • 3. The credit manager recommends a limit.
  • 4. Financial Director approves final limit.
  • If the credit limit requested is equal to or less than the limit suggested by Credit Controller the request could be approved automatically, speeding up the decision process and saving management time for other tasks.
  • Credit Controller can be tuned to your own company's credit policy and method of assessing credit risk. The tuning section has password restricted access for security purposes.
  • Multilingual facility enables easy translation into a second language. Users can switch between English and their own language.

Spreadsheet Screen Shots

Based on Excel, Credit Controller has a familiar menu and is easy to use

Familiar Excel Interface

Familiar and intuitive Excel interface with tabs for easy navigation.

Credit Controller is multi-lingual

Multi-Lingual

Multi-lingual support. Currently in English and Portuguese but the Language Dictionary permits users to enter a second language of their choice. The Language Dictionary can also be used to change text labels to descriptions that are more appropriate to your own organisation.

Context sensitive help text helps credit analysis for non-financial managers

Context Sensitive Help Text

Context sensitive help text helps credit analysis for non-financial managers (in English).

Add credit data into the customer credit report

Collect Credit References

The credit data you have obtained from your normal sources, such as credit rating agencies, banks and suppliers is entered into the customer's information worksheet.

The credit report also scores your own collection experience with the customer

Add Your Own Debt Collection Experience

Add your own experience, if any, in collecting debts from this customer.

Add information from banks and suppliers into the credit report

Check Other Sources

Enter more subjective criteria about the creditworthiness of your customer from conversations with banks, credit rating agencies and the customer's suppliers.

Credit Controller scores the data and suggests a credit limit and the conditions of sale

Credit Score Calculated Automatically

Credit Controller scores the data and suggests a credit limit and the conditions of sale. If the suggested limit is lower than that needed for the sale, management has the option of weighing risk versus reward and approving their own limits, providing a consistent and systematic approach to credit risk analysis.

You can tune Credit Controller to your own company's specific credit policy

Tuning Credit Control

You can tune Credit Controller to your own company's specific credit policy. Once tuned Credit Controller can be placed in 'operational mode', restricting user access only to areas relevant to them

Top of Page