Set Up A Free Maintenance Ticketing System [Templates Included]

Every business, no matter how big or small, has to deal with a certain level of operational issues. More often than not, those operational issues are a direct consequence of malfunctioning or broken physical assets and infrastructure.

Be it a leaking HVAC, broken bulldozer, or a conveyor belt issue that stopped the production line, the fastest approach to solving asset management problems is by using an efficient maintenance ticketing system.

Now, for a ticketing system to be considered “efficient”, it has to be digital. In an ideal scenario, a business would invest in a CMMS or fleet management software as both solutions have ticketing systems as one of their core features.

Unfortunately, a paid solution is not an option for everyone at this moment. For those organizations, we created a free maintenance ticketing system based on Google Sheets.

In continuation of this article, we will outline how we developed our templates for those that want to create their own.

For everyone else, feel free to just download our ticketing guide below. It contains the templates you need and detailed instructions on how to use them.

    Download our Ticketing Guide & Templates

    Quickly set up a ticketing system using Google Sheets. Includes everything you need to make a simple custom system that works for you.

    The life cycle of a maintenance ticket

    The life journey of a standard maintenance ticket goes something like this:

    1. Equipment (mis)use results in an equipment malfunction.
    2. Someone reports the problem by submitting a maintenance ticket/request.
    3. The maintenance manager/planner/supervisor reviews the ticket and assigns it to a maintenance technician.
    4. The maintenance technician comes to diagnose and correct the issue.
    5. When the asset/item has been fixed, the ticket is closed and the maintenance requester has been notified that the issue has been corrected (if needed).

    You can see the same process outlined in the image below.

    work-order management process
    Creating a ticketing system in Microsoft Excel or Google Sheets for such a simple process sounds easier than it is. This is because things don’t always go according to plan. Some tickets are declined, some work has to be delayed, some other unique situation might arise. The ticketing system has to be simple to use, but still offer a way to manage those deviations from the standard process. Above anything, the ticketing system has to be a useful tool for everyone involved, not an additional burden.

    Why did we use Google Sheets for our templates?

    We ended up using Google Sheets for the following reasons:

    • It’s free. The only thing you need to edit a document is a free Gmail account.
    • It’s easy to use. It doesn’t take much training to learn how to select a field and write some text in it.
    • It’s cloud-based. Anyone with the link can access the templates and see the changes in real-time. This is key for team collaboration.
    • It’s editable. Different organizations have different workflows. Maintenance managers and supervisors can add/remove certain fields and columns based on their needs.
    • It has useful formulas. We can automate certain actions and even build simple reports by using available formulas.
    • It allows you to give different levels of access. Some workers should only be able to view the documents while others should be able to both view and edit. Google Sheets allows you to give different levels of access to different people.

    These templates are not a replacement for a CMMS system. However, we are aware that not all organizations are ready to adopt CMMS software but are nonetheless in dire need to better organize their maintenance activities.

    This type of barebone maintenance ticketing system can be a temporary solution for:

    • smaller maintenance teams (up to 10 or so people)
    • maintenance teams that do not have any kind of ticketing system in place
    • maintenance teams that still rely on sticky notes, chalkboard, or smartboards
    • maintenance teams that want to be more organized but do not yet have the capabilities to implement a modern CMMS

    Requirements for implementing a digital maintenance ticketing system

    Regardless of the simplicity of this maintenance ticketing system, you can’t just spring it upon the employees and say that “starting today, you need to use this system”. That’s a recipe for disaster.

    Switching from chalkboard and sticky notes to a digital system has to be closely followed by appropriate workflow changes. And we all know how resistant to change a maintenance department can be.

    To make this transition as smooth as possible, here are a few things you should have in place before you implement a digital maintenance ticketing system.

    Getting the necessary buy-ins

    You should search for approval and commitment from three different parties:

    1. top management
    2. the maintenance team
    3. maintenance requesters

    It is unwise to make bigger changes in any department without the blessing from top management. Usually, that is because you want to ensure appropriate funding for the project at hand. While we are talking about a free maintenance ticketing system here, you might need to invest in mobile devices or a wifi network to make full use of it. Additionally, workflow changes will cause an adjustment period which is bound to result in some loss of productivity in the short-term. So, it makes sense to make your plans clear to the people in charge of the maintenance budget.

    One concern with implementing any kind of maintenance software is that maintenance techs are never going to fully adopt it. If you have technicians that are not using or are misusing the solution, you might as well go back to sticky notes. To ensure everyone gets on board, discuss the implementation a few weeks in advance. Show which problems you are trying to eliminate and why this is the way to do it. Lastly, set new workflows in collaboration with the technicians to ensure they make sense in practice and won’t create any bottlenecks.

    The last party you should get the buy-in from are the people who report maintenance problems and create maintenance tickets. Instead of picking up the phone or sending an email, they will now have access to a Google Sheet which they can use to report their maintenance problem and track the progress of their work request. For this to work, they should actually use the prepared template.

    Basic understanding of Google Sheets (advanced if you’re creating templates from scratch)

    To use the templates we provide with this article, you only need to have a very basic understanding of Google Sheets/Microsoft Excel. Selecting a field to write a comment is the only action a technician or maintenance requester needs to know. This should be easy to explain even to someone who has never seen a spreadsheet in their life.

    As a maintenance manager or facilities manager that will manage the templates, it is helpful to have more experience with creating advanced formulas and calculations, especially if you want to heavily edit provided templates or create your own from scratch.

    Mobile devices

    The advantage of digital maintenance tickets is that they can be accessed anytime and from anywhere, as long as you have a device that is connected to the internet. To make full use of the new system, it is advisable to equip workers with mobile devices. This way, they will be able to close work orders, leave completion notes, and plan their next maintenance activity without the need to constantly go back to that one computer terminal available on the plant floor.

    If you ever switch to a CMMS, the benefits of having mobile maintenance software will become even more exaggerated.

    The basic functionality you need (even in a free maintenance ticketing system)

    For a maintenance ticketing system to work properly, you need to have a straightforward and efficient way to receive and manage tickets. Ideally, you should also be able to generate a few basic reports.

    The templates we created were guided by these notions. If you opt-in for our free templates which you can find at the beginning of this article, you will get two Google Sheets. One is designed for receiving tickets, and the other one is used to manage work orders and generate reports.

    Here is a sneak peek into how they work.

    Receiving maintenance tickets template

    You need one place to hold all of the maintenance requests that come in. This way, it is unlikely you’ll lose any and it will be easier to notice duplicated maintenance requests.

    We decided to have a separate sheet for submitting maintenance requests so you can share the link to this document with everyone who might need to submit a maintenance ticket.

    Here is how the “Submit ticket” template looks like in use:

    submit maintenance ticket template
    You have all of the standard info like date, problem description, and contact info. We also added a column that informs the maintenance requester about the status of their ticket. We think it is a neat addition, but you can delete that column – if the maintenance planner/supervisor/manager can’t keep it up-to-date, there isn’t much sense in having it at all.

    Managing maintenance tickets template

    Managing maintenance tickets can be done in a few different ways. We designed the templates so they can be used to schedule all maintenance operations, not just address incoming maintenance service requests. In that sense, this aims to be more of a work order management system than just a maintenance ticketing system.

    In the template, we included the following fields:

    • Ticket ID: Serves as a unique identifier (ID) for each ticket. It auto-fills after you enter “name of the task”.
    • Name of the task: Give each ticket a name for an easier overview of assigned work.
    • Work description: A place to write a description of the work that needs to be performed.
    • Technician: A drop-down list you can use to select a technician you want to assign the work to.
    • Due date: Set a due date by which the assigned ticket/Work Order should be completed.
    • Priority level: Choose a priority level for the ticket. It helps technicians decide which work needs to be done first.
    • Status of the ticket: A drop-down list where you can select the current status of the ticket.
    • Completion notes: Here technicians and/or supervisors can leave any important notes regarding the work that was just completed.
    • Completion date: Marks the completion date for the assigned work order. Auto-fills after the status of the ticket is changed to “Completed”.
    • Type of work: Choose which type of work (reactive or preventive) is to be performed. It is used in the reporting section.
    • Completed in time?: This field auto-fills after checking if the ticket was completed on time or not. It will show as “Yes” or “No” after the ticket is marked as completed. We had to implement this field to be able to calculate the Work Compliance percentage in the reporting section.

    We wanted to automate the process as much as possible. This is why we incorporated a few different drop-down lists and created formulas to auto-fill certain fields. If you plan to develop your own templates, you should look to do the same. After all, the end goal is to make the maintenance department as efficient as possible.

    Here’s how the template looks like in practice (this is all in one row but we had to split it into 2 screenshots to make them readable):

    maintenance ticketing system templatemanaging maintenance tickets

    Generating maintenance reports

    With these kinds of templates, reporting will be limited. We were able to create three custom reports based on the data used in the table:

    • Breakdown of task priority: A simple report that shows how urgent are the maintenance tasks you assign on average. It’s nothing special but some might find it useful.
    • Breakdown of type of work: A report that shows how many of your tasks were planned (part of routine or preventive maintenance) and how many were unplanned (reactive). It also shows how many total tasks you have performed so far.
    • Total work compliance percentage: Overall work compliance shows the percentage of tasks that were completed on time.

    maintenance reports template
    There might a way to generate more useful maintenance reports. However, that usually means expanding the ticket management template with additional fields. We believe the average user will not have the need for that. However, a great thing about these templates is that you can adjust them according to your needs.

    CMMS is the ultimate maintenance ticketing software

    We sincerely hope that some of you will be able to put this free maintenance ticketing system to good use. That being said, spreadsheets can only get you so far. They are a great step forward, but can’t be a long-term solution. Eventually, you will need to switch to a mobile CMMS if you wish to maximize operational efficiency, reduce maintenance costs, and hit your maintenance KPIs.

    For those that feel ready to make that switch sooner rather than later, we invite you to play around with Limble CMMS and explore its features (without any commitment). To do that, here are your options:

    • SCHEDULE A DEMO: Contact us and someone on our team will give you a walkthrough and get you familiar with all of the major features.
    • TRY OUR SELF DEMO: Clicking on this button will refresh your browser tab and load a simulated test environment where you check how Limble works at your own pace.
    • START A FREE TRIAL: You can sign-up for a free 30-day trial to evaluate if Limble CMMS is a good fit for your organization.

    Do you have any questions about Limble or about the templates we presented in this article? Have some suggestions on how they could be improved? Do not hesitate to start a discussion in the comment section below!

    What is EAM?

    Need a maintenance solution that supports your enterprise needs? The first step in understanding what is EAM software and how it can help you to streamline your asset maintenance strategy.

    An enterprise asset management (EAM) combines software, systems, and services to integrate data to optimize the maintenance operations and keep assets operating at their maximum capacities throughout their lifecycles.

    Investing in the right EAM system brings multiple benefits to organizations as it decreases asset downtime and reduces the costs associated with reactive maintenance. That increases the efficiency of maintenance teams and makes it easier to organize data. Large organizations that leverage enterprise maintenance management systems tend to a significant increase in operations ROI. Depending on the level of complexity of the organization’s assets, it becomes impossible to manage maintenance without enterprise asset management software.

    Let’s get into more details of what maintenance managers must know about EAM:

    What is EAM?

    Enterprise Asset Management software (EAM) is a platform that allows organizations to effectively generate and organize assets data, and with that, effectively manage their physical assets and infrastructure.

    With an EAM, maintenance managers and technicians can easily assess real-time asset data during all phases of the asset lifecycle, which allows for educated decision-making when it comes to optimal machine repair and replacement time.

    Assets data is pulled from different sources and departments through built-in sensors, maintenance activity logged in, failure history, and more.

    Most EAM providers offer highly customizable solutions, that connect different modules, including work order management, inventory management, spare parts tracking, preventive maintenance management and some even offer predictive maintenance capabilities.

    Predictive maintenance capabilities allow enterprises to take a proactive and non-invasive approach to maintenance activities. It leverages the Internet of Things (IoT), big data, and machine learning to collect asset data and form predictive models. Data gathered from machines is analyzed using AI techniques. The information provided helps maintenance teams enhance efficiency, perform corrective maintenance, and maximize investments in their assets.

    The ultimate goal of enterprise asset maintenance software is to eliminate manual work that can be automated, improve maintenance professionals’ communication, and support cost-effective managerial decision-making.

    The best software options providers offer the system for desktop, tablet, and mobile devices.

    Main Functions of an Enterprise Asset Management Software

    An effective EAM software performs many key functions, including:

    • Reporting and Analytics
    • Work Order Management
    • Asset Lifecycle Management
    • Vendor Management
    •  Enterprise Resource Planning (ERP)
    • Labor Management
    • Safety Regulation
    • Centralized Database

    Difference Between CMMS and EAM

    Enterprise asset management software (EAM) is often associated with a computerized maintenance management system (CMMS), but they are not the same.

    While a CMMS focuses on maintenance, EAM takes a comprehensive approach to asset management. This means that EAM systems incorporate multiple business functions and departments while CMMS is used mostly by the maintenance team.

    A CMMS without enterprise capabilities starts tracking assets after they have been purchased and installed. On the other hand, an EAM system starts asset tracking with design and installation.

    EAM is a thorough asset lifecycle management approach that supports asset performance from acquisition to disposal.

    Who Benefits from an EAM Software

    EAM software is frequently used by organizations that have outgrown their CMMS system. Many CMMS providers, such as Limble CMMS, offer EAM extensions, which makes it easier to transition.

    If your organization hasn’t been leveraging a CMMS software yet, and you are trying to decide whether you should start with a CMMS or go straight to an EAM system, think about the number of assets you would need to track, how complex the asset information would be, and ho many different locations and departments would be involved in the process.

    It’s likely a good idea to leverage an EAM system if your organization has:

    – hundreds of physical assets

    – a large team of maintenance professionals

    – complex systems and operations across multiple sites

    If you have relatively small maintenance operations and need to automate work orders, records, inventory, and spare parts management, then a CMMS without EAM capabilities may be the best solution for you. That’s because a CMMS with the basic functionalities will cost less and will already support your needs.

    Some industries that tend to benefit the most from effective operations in the supply chain and maintenance include manufacturing companies, oil & gas organizations, energy companies, fleet management, healthcare companies, food service companies, transportation companies, property management companies, national and state parks, organizations operating in the aerospace, manufacturing companies, hospitality organizations, warehouses, automotive companies, and other types of institutions.

    Why is an EAM System Important

    Without a powerful system to help maintenance managers assess and organize information, it becomes challenging to understand the best way to organize a maintenance scheduling for each asset. That’s because data is rarely available in these cases. And if it is, it’s not up to date or easy to find.

    In a small company’s context, that can already become a huge problem. After all, making wrong decisions regarding when it is the optimal time to perform maintenance can have significant impacts on production and operation costs.

    On a larger scale, it is impossible to effectively manage assets without leveraging quality data. Therefore, high-functional asset management is required for asset-intensive organizations that want to succeed. EAM solutions help organizations make the best out of company-wide assets and have greater control over multiple facilities by allowing them to:

    • Maintain all asset information in one place. Using a CMMS along with an EAM makes it possible for the maintenance team to access real-time information about any asset, in any location — all from a centralized dashboard. Managers can look at historical data, current operating data, maintenance activities scheduled, and more.
    • Prevent machine failure in scale. The best EAM software providers offer preventive maintenance and predictive maintenance modules, which help to keep equipment in a stable operating condition and avoid reactive maintenance.
    • Optimize asset usage and extend their life span. EAM software can compile and showcase historical and real-time machinery information through the use of IIoT sensors. This data can be used to dictate how assets are being utilized to extend their reliability, availability, and usable life.
    • Integrated assets and connected data. All assets are connected through artificial intelligence (AI), which gives management continuous insight into the current state of all assets. EAM system can aggregate this information and data coming from other departments to make more informed decisions.
    • All-in-one software capabilities. While EAM solutions can integrate current applications, many have the capability to combine all maintenance management modules into one system. That establishes a single technology system across the organization, which makes training easier and increases productivity.

    Ready to Upgrade Your Asset Management?

    If you need a solution that provides a holistic view of your organization’s assets throughout their entire lifecycle, you must look for enterprise asset management software. Modern EAM will provide all the functionalities you need to manage physical assets from design, commission, or procurement, through to operation, maintenance, disposal, and replacement.

    At an enterprise-level, it is critical to standardize your maintenance with itemized tasks workflow automation.

    If you need further insights on the particularities of an enterprise asset management software solution, how it differs from a standard CMMS software, and how your specific company can benefit from them, book a demo with one of our team members.

    At Limble CMMS, we strive to deliver customized solutions based on clients’ needs. For this reason, we have different plans tailored for a variety of company sizes.

    Regardless of whether you have few assets or hundreds of assets to manage, you can’t afford to neglect data and automation.