They should have appropriate forms for both clients and staff in order to make clients know that their complaints will be taken seriously and there will be follow-up. Choose from over a hundred different planner templates and tracking templates for Microsoft Excel. Payroll Management Template. SPC for Excel is used in over 60 countries internationally. KPI Dashboard Excel templates are the graphical representations to track the key data points for maximizing the performance of the business. This employee records the immediate action that he/she takes, the employee's name, and the date he/she contacted the customer. Complaint registered (what is the complaint? A customer can simply fill in this complaint form by giving details of what he felt disturbing in product or service of the company. UP Template Version : 11/30/06 Page of Project Name: National Center: Project Manager Name: Project Description: 1/1/2006 1/1/2006 1/1/2006 • ID: A unique ID number used to identify the issue in the issue tracking log. This allows the institution to adequately monitor their branches and determine where and how they can improve their customer service. This is often done by the Customer Service Manager. Most do not provide a good method of analyzing the results using SPC, but with most you can export the data to Excel to do the analysis. For example, for a distribution company, you might have codes such as: These codes require a person to select a reason for a customer complaint. Learning from mistakes is key for growth, both professionally and personally. Developing the Customer Complaint Process, Analyzing the Results: Number of Complaints, An Example of the Misuse of SPC in Health Care. A customer complains via some medium (e.g., phone, e-mail, fax). The time it takes to close a customer complaint should be tracked using a control chart. This is a simple Issue Tracker template. An individuals control chart can be used to monitor the results. 10+ Complaint Log Templates in DOC | Excel | PDF. The employee receiving the complaint records the information as follows: The complaint then should be sent to the employee who is responsible for taking care of the problem immediately. Best KPI dashboard templates hold good control in increasing the productivity of an organization. A customer will complain about something. Issue-tracking template. What is Issue Tracking Spreadsheet, This is an Excel Complain Issue Tracker through which you can keep a complete record of your customer or marketing, operation or any other thing. A critical feature of any CRM system is to track communications with customers, plan follow-up contacts, update the lead status, and after gaining a customer, schedule future communication that will help you keep them as a customer.Tracking sales is also an important part of CRM..