-->
    Register   |  Login
    Search

    Goodbye Manual Processes, Hello Productivity

    Case study Contents

    The Story

    Who are Addlestone Keane, and what do they do?

    What were the customer's goals?

    What were the customer's needs?

    Follow up - The time and efficiency savings

    What does the customer say?

    The Solution - Technically speaking 

    Task Details - Step by step guides


    The Story

    David Evans

    David Evans, 

    Director

    Addlestone Kean Solicitors

    Shauna Appleby, 

    Accounts

    Addlestone Kean Solicitors
    Richard Briggs

    Richard Briggs, 

    Software Engineer

    Lean Software Ltd
    Simon Stell

    Simon Stell, 

    Managing Partner

    LCF Law Solicitors

    Lean Software Ltd were recommended to Addlestone Kean by Bradford based company LCF Law in the UK.  LCF Law have used Lean Software consistently over a number of years to help with their own data processing goals.

    David Evans, Partner at Addlestone Kean Solicitors, turned to Lean Software Ltd and interviewed Richard Briggs founder of Lean Software - who proposed the new Excel Database Tasks (EDT)  based system as described in this case study.  Confident in the company's own software, Richard estimated the described activity (Importing and Processing Debt payments, Reporting and data Cleansing) could be delivered in just 10 days using the EDT software.

     

    Who are Addlestone Keane, what do they do?

    Addlestone Keane are a commercial law firm based in the City centre of Leeds, UK.  Part of their operation handles debt collection for their large commercial clients.

    A significant number of debt repayment transactions appear on the company's current bank account statement on a daily basis - a system was required to (as far as possible) automate the accounts handling of the payments-in and payments-out from the debt department on a daily basis.

     

    What were the customer's goals?

    Existing office procedures consisted of a largely manual process of manually entering every transaction against the debtors record, these records are held in a Case Management System called Partner for Windows, based on SQL Server supplied by Tikit PLC.  This being a time consuming and error prone process.

    David Evans had a vision of automating the entire existing process, but despite previous IT company's efforts achieving the goal remained elusive.  The system required interwoven special conditions that proved too challenging for previous automation attempts and software.

     

    What were the customer's needs?

    Crucially as system was required where a user could confirm matching and processing, no fully automated process without user interaction could ever be used.

    Lean Software promised EDT could deliver these requirements - 

    • To import (with user interactive validation) a daily CSV (comma separated value) transaction file, downloaded from the client's bank website
    • Credit transactions usually (but not always) contain one of two different reference numbers styles, each had to be matched using complex SQL to a debtor record and presented to the user as a match list for the user to confirm or edit the match
    • On allocation the system would automatically post a debtor payment credit to the debtors matter to the SQL database of the Case Management system Partner for Windows
    • A system of then authorising payments out to the company they are collecting money for was required.   Special fairly complex rules existed as to when payments out should be made.
    • Payments-out had to group payments-in together for particular lender-departments and create an amalgamated cheque request in the SQL Case Management system
    • Several integrated reports were required, data from the reports had be easily saved as Excel, Word , or PDF format
    • a special 'Data Cleansing' task was required to sort out historical mistyped data where invalid client references are stored

     Can you think of any software that could possibly handle all of this complexity, yet be really user friendly and the solution be delivered in just 10 days?

    We don't think you will be able to - but now you can - Welcome to Excel Database Tasks (EDT)  Version 4.0 ...


    The solution - Technically speaking

    Here we look at EDT Software and show you how each requirement was met - and highlight features of the EDT software that provide such a smart solution.

    Here is a screen shot of the main EDT application - as seen by the end user - a simple Tree View allows the user to select teh desire task in this particular solution.

     

    Transaction processing menu : 

     

    System Admin Menu :

     Bear in mind this is just an example of one company's needs - once you realise how powerful the EDT software is - particularly when working with SQL Stored Procedures - there is no limit but the imagination as what EDT can do in terms of processing batches of data.  

     Remember Lean Software can handle building the EDT Tasks for you if you require.

     

    Task Details - Step by step guides

    Read technical detailed instructions for creating each of the Tasks & SQL code involved :

    Click on any task for details ..

     

    DATA PROCESSING TYPE TASKS

    TASK 1 - Import Daily Bank Transactions

    TASK 2 - Allocate Credit Transactions, Post Credits

    TASK 3 - Amalgamated Transactions, Post Credits

    TASK 4 - Authorise Payments Out

    TASK 5 - Payments Out by Cheque, Post Client Debits

     

    REPORTS TYPE TASKS

    Payments by Cheque Number

     

    DATA CLEANSING TYPE TASKS

    Data Cleansing - fix invalid Clients Refs

     

     

     

    Feedback Comments
    Feedback

    Your Contact Information

    Your Feedback