• Home
  • Industries
    • Catering
    • Facilities Management
    • Lifts
    • Electrical
    • Plumbing and Heating
    • HVAC
    • Generators
    • Building Services
    • Fire and Security
    • Doors, Gates and Barriers
    • Grounds Maintenance
    • Roofing
  • Features
    • Asset Management
    • Bespoke Certificates
    • CRM
    • Customer Portals
    • Electrical Certificates
    • Diary
    • F-Gas
    • Fleet Management
    • Gas Certificates
    • Invoicing
    • Job Management
    • Job Scheduling
    • Manager Portal
    • Mobile Job Sheets
    • Planned Maintenance
    • Print Templates
    • Purchase Orders
    • Quoting
    • Reporting
    • Service Incidents
    • Stock Control
    • Third Party Integrations
  • Products
    • Clik Service
    • Clik Remote
    • Clik Jobs
    • NICEIC Cert Software
    • Clik Cert Electrical
    • Clik Cert
    • Clik Cert (Field)
    • Clik AC Calc
    • Clik Training
  • Pricing
  • Case Studies
  • Blog
  • Newsletters
  • Support
Contact Us Try for FREE
  • Home
  • Industries
    • Catering
    • Facilities Management
    • Lifts
    • Electrical
    • Plumbing and Heating
    • HVAC
    • Generators
    • Building Services
    • Fire and Security
    • Doors, Gates and Barriers
    • Grounds Maintenance
    • Roofing
  • Features
    • Asset Management
    • Bespoke Certificates
    • CRM
    • Customer Portals
    • Electrical Certificates
    • Diary
    • F-Gas
    • Fleet Management
    • Gas Certificates
    • Invoicing
    • Job Management
    • Job Scheduling
    • Manager Portal
    • Mobile Job Sheets
    • Planned Maintenance
    • Print Templates
    • Purchase Orders
    • Quoting
    • Reporting
    • Service Incidents
    • Stock Control
    • Third Party Integrations
  • Products
    • Clik Service
    • Clik Remote
    • Clik Jobs
    • NICEIC Cert Software
    • Clik Cert Electrical
    • Clik Cert
    • Clik Cert (Field)
    • Clik AC Calc
    • Clik Training
  • Pricing
  • Case Studies
  • Blog
  • Newsletters
  • Support
return to Support Centre

Importing Quotes Via CSV

Creating Quotes CSVs

Before you can import your quotes, you will need to create a quote CSV.

There are two ways of creating quote CSVs in Clik Service.

The first way is to go to Tools > CSV Import > Quotes.

Go to Create CSV Template > Standard Quote Template and choose somewhere to save it.

When it is saved, open the CSV and it will look like the image below.

Then fill in the columns. Each line is the information needed for each quote.

If you are not sure what a column is, scroll down to the bottom of this page to see a breakdown of each one.

The second way of creating a CSV would only be used if you already have a system that holds your quotes. Most systems allow you to extract into a CSV file, which can be saved into Excel.

Instead of using our default CSV templates as we did above, you can map the fields from the CSV template that your current system produces to Clik Service and use them again any time you want. This will stop copy/pasting into the Clik CSV files and save you some time.

To learn how to do this please see this video tutorial.

 

Importing Into Clik Service

Once you have created the CSV, you are now ready to import it into Clik Service.

To do this go to Tools > CSV Import > Quotes.

Click on ‘Import’.

Find your CSV and click ‘Open’. It will list all the quotes down the side. You can check are happy with them and then click ‘Save’. This will save them into Clik Service.

 

Quote Columns Explained

Field

Expected Format

Notes

Customer Text Enter the company name here.
Account Code Text Or enter the company Account Code here. Use either Customer or Account Code to link the Quotes to the customer.
Quote Date Date Using DD/MM/YYYY format, for example, 31/12/2020.
Prefix Text
Title Text
Due By Date Using DD/MM/YYYY format, for example, 31/12/2020.
Our Ref Text Enter either Our Ref or Customer Ref, these values are used to identify duplicate quotes and also to link all of the line items to the quote.
Customer Ref Text Enter either Our Ref or Customer Ref, these values are used to identify duplicate quotes and also to link all of the line items to the quote.
Category Text Quote category, you can edit or add the categories within the Clik Service settings.
Status Text Quote status, you can edit or add the statuses within the Clik Service settings.
Revision Text
Responsible User Text This should be the first name, space, surname of the responsible staff member as stored in the Clik Service staff settings.
Quote Address Site Ref Text Enter the site reference used (within Clik Service) for the address you wish to use.
Location Address Site Ref Text Enter the site reference used (within Clik Service) for the address you wish to use.
Carriage Number Enter the carriage value, currency symbol is not required.
Carriage Tax Code Number Enter the required tax code as shown in Clik Settings, leave blank to use default tax code.
Callout Charge Number Enter the callout value, currency symbol is not required.
Callout Tax Code Number Enter the required tax code as shown in Clik Settings, leave blank to use default tax code.
Prospect Percent

All Quote Line Items

Expected Format

Notes

Item Date Date Using DD/MM/YYYY format, for example, 31/12/2020.
Item Type Text Enter either Time, Material or Misc.
Description Text
Tax Code Number Enter the required tax code as shown in Clik Settings, leave blank to use default tax code.

Time Items

Expected Format

Notes

Engineer Text This should be the first name, space, surname of the engineer as stored in the Clik Service staff settings.
Hours Duration Decimal Number Enter the decimal value for hours duration.
Cost Rate Decimal Number Enter the cost rate without currency symbol.
Charge Rate Decimal Number Enter the charge rate without currency symbol.
Travel Duration Decimal Number Enter decimal value for travel duration.
Travel Cost Rate Decimal Number Enter the cost rate without currency symbol.
Travel Charge Rate Decimal Number Enter the charge rate without currency symbol.
Mileage Number Enter the number of miles travelled.
Mileage Cost Rate Decimal Number Enter the mileage rate (per mile) without currency symbol.
Mileage Charge Rate Decimal Number Enter the mileage rate (per mile) without currency symbol.

Material & Misc Items

Expected Format

Notes

PartRef Text If you include a part reference, the import will look for the material item within your products. If the item is found it will use the price and cost on record. If you provide a part reference and it is not found in your products, no price or cost will be set (you will see a warning message confirming this on importing).
Quantity Number
Price Each Number Enter price without currency symbol.
Cost Each Number Enter cost without currency symbol.
Markup Discount Number Enter a positive (markup) or negative (discount) value.
Commission Rate Number Enter commission percentage.
Clik Service

Clik Service

Importing Data

CSV Mapping [Video]
Clik Service

Clik Service

Sites & Equipment

Importing Equipment Via CSV

Quotes

  • Creating Standard Quotes [Video]
  • Converting Quotes
  • Creating Quotes From a Sales Enquiry [Video]
  • Quote Templates [Video]
  • Adding Equipment to Quotes [Video]
Show more

Ask Tech a Question

Did you find what you were looking for? Don’t worry if not, you can get in touch with our tech support team.

Contact Tech Support
PERSONALISED LEARNING

A Training Masterclass From Our Experts

You’ve got the software. Now get the expert knowledge straight from the experts. If you want to know more about Clik Service or the NICEIC Cert Software, maybe you want to drill down into a specific module, or a run-through for a new engineer, we’ll walk and talk you through it in the way that suits you.

4.4

  • Products
    • Clik Service
    • Clik Jobs
    • Clik Remote
    • NICEIC Cert Software
    • Clik Cert
    • View All Products
  • Features
    • CRM
    • Invoicing
    • Job Management
    • Job Scheduling
    • Quoting
    • View All Features
  • Industries
    • Air Conditioning
    • Electrical
    • Facilities Management
    • Fire & Security
    • Plumbing
    • View All Industries
  • Support
    • Training
    • Service Status
    • Contact Tech Support
    • Software Updates Coming Soon
  • About
    • Blog
    • News
    • Privacy
    • Terms
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept All”, you consent to the use of ALL the cookies. However, you may visit "Cookie Settings" to provide a controlled consent.
Cookie SettingsAccept All
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
__cfruidsessionThis cookie is set by the provider Cloudflare. This cookie is used for load balancing and for identifying trusted web traffic.
__hssrcsessionThis cookie is set by Hubspot. According to their documentation, whenever HubSpot changes the session cookie, this cookie is also set to determine if the visitor has restarted their browser. If this cookie does not exist when HubSpot manages cookies, it is considered a new session.
__stripe_mid1 yearThis cookie is set by Stripe payment gateway. This cookie is used to enable payment on the website without storing any patment information on a server.
__stripe_sid30 minutesThis cookie is set by Stripe payment gateway. This cookie is used to enable payment on the website without storing any patment information on a server.
AWSALBCORS7 daysThis cookie is used for load balancing services provded by Amazon inorder to optimize the user experience. Amazon has updated the ALB and CLB so that customers can continue to use the CORS request with stickness.
cookielawinfo-checkbox-advertisement1 yearThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Advertisement".
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
JSESSIONIDsessionUsed by sites written in JSP. General purpose platform session cookies that are used to maintain users' state across page requests.
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
CookieDurationDescription
__hssc30 minutesThis cookie is set by HubSpot. The purpose of the cookie is to keep track of sessions. This is used to determine if HubSpot should increment the session number and timestamps in the __hstc cookie. It contains the domain, viewCount (increments each pageView in a session), and session start timestamp.
__zlcmid1 yearThis cookie is used by Zendesk live chat and is used to store the live chat ID.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
CookieDurationDescription
__hstc1 year 24 daysThis cookie is set by Hubspot and is used for tracking visitors. It contains the domain, utk, initial timestamp (first visit), last timestamp (last visit), current timestamp (this visit), and session number (increments for each subsequent session).
CONSENT16 years 4 monthsThese cookies are set via embedded youtube-videos. They register anonymous statistical data on for example how many times the video is displayed and what settings are used for playback.No sensitive data is collected unless you log in to your google account, in that case your choices are linked with your account, for example if you click “like” on a video.
hubspotutk1 year 24 daysThis cookie is used by HubSpot to keep track of the visitors to the website. This cookie is passed to Hubspot on form submission and used when deduplicating contacts.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
CookieDurationDescription
IDE1 year 24 daysUsed by Google DoubleClick and stores information about how the user uses the website and any other advertisement before visiting the website. This is used to present users with ads that are relevant to them according to the user profile.
test_cookie15 minutesThis cookie is set by doubleclick.net. The purpose of the cookie is to determine if the user's browser supports cookies.
VISITOR_INFO1_LIVE5 months 27 daysThis cookie is set by Youtube. Used to track the information of the embedded YouTube videos on a website.
YSCsessionThis cookies is set by Youtube and is used to track the views of embedded videos.
yt-remote-connected-devicesneverThese cookies are set via embedded youtube-videos.
yt-remote-device-idneverThese cookies are set via embedded youtube-videos.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
CookieDurationDescription
m2 yearsNo description available.
SAVE & ACCEPT
Powered by CookieYes Logo