---
title: Top 5 Spotlight Handy Tips and Tricks
description: You probably have the basics of Spotlight down already, but there’s far more handy features you can utilise to enhance your productivity.
image: https://blog.spotlightreporting.com/hs-fs/file-4070758286-jpg/blog-files/product_sr_consolidate-p21-1.jpg
---

[![Return to homepage](https://blog.spotlightreporting.com/hubfs/Brand_attributes/spotlight%20reporting%20logo.svg "Return to homepage")](https://www.spotlightreporting.com/)

- [Solutions](https://spotlightreporting.com/our-solutions/)
- [Product](http://spotlightreporting.com/product/)
- [Pricing](http://spotlightreporting.com/pricing/)
- [Resources](http://spotlightreporting.com/resources/)
- [Our team](http://spotlightreporting.com/our-team/)
- [Blog](https://blog.spotlightreporting.com)
- [Free trial](http://go.spotlightreporting.com/Member/Signup)

[Login](https://go.spotlightreporting.com/Member/Login?ReturnUrl=%2f)

# Blog

Keep up to date with all industry news, special events and thought leadership

# Top 5 Spotlight Handy Tips and Tricks

Posted by [Gayatri Wood](https://blog.spotlightreporting.com/author/gayatri-wood) on 22 May 2015

- [Tweet](https://twitter.com/share)

You probably have the basics of Spotlight down already, but there’s far more handy features you can utilise to enhance your productivity. We asked Matt our new support specialist based in the UK, to answer some frequently asked questions..

### **1. How do I consolidate interdepartmental spending?**

Utilising importing Excel Spreadsheets will help you with this. It’s a great feature for many reasons including importing a standard chart of accounts into Spotlight to get things going, even with no data having been entered into the spreadsheet. If you were to download our Excel template and then import it having made no changes to it, then you have a whole host of headings under customise data that you wouldn’t have there otherwise. This is particularly useful for those who are doing group consolidations and have created an organisation for the sole purpose of eliminations. For example, interdepartmental spending between companies can be amended to show a zero figure in the group report, where you can manually enter this data to be used in Spotlight. There is a video that goes in depth about this that you can take a look at [here.](https://vimeo.com/91390687)

****[![Product_SR_Consolidate-P21 (1)](https://blog.spotlightreporting.com/hs-fs/file-4070758286-jpg/blog-files/product_sr_consolidate-p21-1.jpg?width=697&height=321&name=product_sr_consolidate-p21-1.jpg)](https://blog.spotlightreporting.com/hs-fs/file-4070758286-jpg/blog-files/product_sr_consolidate-p21-1.jpg)****

### **2. How do I overwrite or amend data in Spotlight?**

With the Excel import you can overwrite data in Spotlight if amendments need to be made rather than having to manually edit it, which would be time consuming. Using our Excel template, you can enter the figures you want to overwrite for whatever data type, you then can amend the import date in Spotlight when choosing the saved file to import which will bring in the new figures and overwrite the old for that period of time. Just ensure that ensuring the date is formatted correctly (for e.g. Jan-14) and also make sure that you are importing the correct date range for your amendments otherwise you might inadvertently overwrite data that you had not intended to remove. If you want to learn more about our Excel template, you can take a look [here](https://vimeo.com/627492) where we go more indepth.

### **3. Do I have to keep importing categories?**

Another useful feature of the Excel import is that you can import 'account type' categories initially and you will not have to import these categories again as they will be saved in Spotlight for future use. This is great if you’re doing month on month imports of say your balance sheet from an accounting program for that particular organisation. The tab at the bottom of your Excel spreadsheet needs to be renamed as either ‘actuals’ or ‘budget’ depending on the data being entered. Spotlight will automatically point out this error if the import has failed. If you’re interested in details on the categories you can list to import, you can find out more [here](http://help.spotlightreporting.com/KnowledgeBase/ExcelImport-Account‘): If you want a summary of the format of using your own spreadsheet check [this](http://help.spotlightreporting.com/KnowledgeBase/ExcelImport-Usingyourownspreadsheet)out.

*Tip: Spreadsheets have to be saved in the .xlsx format to import into Spotlight. When you have imported a spreadsheet, make sure you select from the drop down box the source of your data when in the 'customise data' screen to view the Excel data in Spotlight. This applies to the above three points.*

### **4. I’ve customised my Report or Dashboard, do I have to do that everytime I want to send one out?**

There is no reason for having to recreate the layout, titles, formats, charts and the way information is displayed in Spotlight every time you want to create a report or dashboard. When you have everything just the way you like it, you’re able to save this as a template. A template is a great way to establish continuity of information that is both useful and relevant to your individual organisations and also consistency throughout your organisation for your clients. The template can be named accordingly and used across all of your organisations that you have setup in Spotlight Reporting. You can manage your templates in the settings on the main page of your Spotlight account, if you need to rename or delete them you can do so from here as well like in the screenshots below:

****[![Template location](https://blog.spotlightreporting.com/hs-fs/file-4070758311-png/blog-files/template-location-700x302.png?width=700&height=302&name=template-location-700x302.png)](https://blog.spotlightreporting.com/hs-fs/file-4070758311-png/blog-files/template-location-700x302.png)****

### ****[![template settings](https://blog.spotlightreporting.com/hs-fs/file-4070758326-png/blog-files/template-settings-700x217.png?width=700&height=217&name=template-settings-700x217.png)](https://blog.spotlightreporting.com/hs-fs/file-4070758326-png/blog-files/template-settings-700x217.png)****

### **5. Can I set targets with my clients and be able to visualise their performance?**

The KPI target score card is a very useful summary you can display in your report or dashboard that allows you to measure financial performance against the non-financial data most pertinent to that client. Spotlight automatically calculates the various sections as a default, all you need to do is add the target data. You can add the targets for these under ‘customise data’ and ‘KPI/targets’. To add your target data, you can 'add account' to add your own customised KPI categories and manually edit the actual and target details for each category you've created. This allows you to easily visually the holistic performance of the business and what areas of the business are affecting the financial performance. You can even customise the chart to change the date range and also add and remove KPI categories from being displayed on the scorecard.

To check out how you can get started and have this chart feature in your report click [here](https://vimeo.com/76300165).

[![Product_SR_KPI-P31](https://blog.spotlightreporting.com/hs-fs/file-4070758341-jpg/blog-files/product_sr_kpi-p31-700x652.jpg?width=700&height=652&name=product_sr_kpi-p31-700x652.jpg)](https://blog.spotlightreporting.com/hs-fs/file-4070758341-jpg/blog-files/product_sr_kpi-p31-700x652.jpg)

### Recent Posts

---

### Posts by Month

- [August 2020 (4)](https://blog.spotlightreporting.com/archive/2020/08)
- [July 2020 (7)](https://blog.spotlightreporting.com/archive/2020/07)
- [June 2020 (7)](https://blog.spotlightreporting.com/archive/2020/06)
- [May 2020 (4)](https://blog.spotlightreporting.com/archive/2020/05)
- [April 2020 (11)](https://blog.spotlightreporting.com/archive/2020/04)
- [March 2020 (12)](https://blog.spotlightreporting.com/archive/2020/03)
- [January 2020 (3)](https://blog.spotlightreporting.com/archive/2020/01)
- [December 2019 (5)](https://blog.spotlightreporting.com/archive/2019/12)
- [November 2019 (4)](https://blog.spotlightreporting.com/archive/2019/11)
- [October 2019 (4)](https://blog.spotlightreporting.com/archive/2019/10)
- [September 2019 (5)](https://blog.spotlightreporting.com/archive/2019/09)
- [August 2019 (4)](https://blog.spotlightreporting.com/archive/2019/08)
- [July 2019 (1)](https://blog.spotlightreporting.com/archive/2019/07)
- [June 2019 (3)](https://blog.spotlightreporting.com/archive/2019/06)
- [May 2019 (4)](https://blog.spotlightreporting.com/archive/2019/05)
- [April 2019 (1)](https://blog.spotlightreporting.com/archive/2019/04)
- [March 2019 (2)](https://blog.spotlightreporting.com/archive/2019/03)
- [January 2019 (2)](https://blog.spotlightreporting.com/archive/2019/01)
- [December 2018 (1)](https://blog.spotlightreporting.com/archive/2018/12)
- [November 2018 (1)](https://blog.spotlightreporting.com/archive/2018/11)
- [October 2018 (1)](https://blog.spotlightreporting.com/archive/2018/10)
- [September 2018 (3)](https://blog.spotlightreporting.com/archive/2018/09)
- [July 2018 (3)](https://blog.spotlightreporting.com/archive/2018/07)
- [June 2018 (2)](https://blog.spotlightreporting.com/archive/2018/06)
- [May 2018 (4)](https://blog.spotlightreporting.com/archive/2018/05)
- [March 2018 (1)](https://blog.spotlightreporting.com/archive/2018/03)
- [January 2018 (4)](https://blog.spotlightreporting.com/archive/2018/01)
- [November 2017 (2)](https://blog.spotlightreporting.com/archive/2017/11)
- [October 2017 (2)](https://blog.spotlightreporting.com/archive/2017/10)
- [September 2017 (3)](https://blog.spotlightreporting.com/archive/2017/09)
- [August 2017 (2)](https://blog.spotlightreporting.com/archive/2017/08)
- [July 2017 (1)](https://blog.spotlightreporting.com/archive/2017/07)
- [June 2017 (4)](https://blog.spotlightreporting.com/archive/2017/06)
- [May 2017 (1)](https://blog.spotlightreporting.com/archive/2017/05)
- [April 2017 (3)](https://blog.spotlightreporting.com/archive/2017/04)
- [March 2017 (4)](https://blog.spotlightreporting.com/archive/2017/03)
- [January 2017 (3)](https://blog.spotlightreporting.com/archive/2017/01)
- [December 2016 (2)](https://blog.spotlightreporting.com/archive/2016/12)
- [November 2016 (4)](https://blog.spotlightreporting.com/archive/2016/11)
- [October 2016 (2)](https://blog.spotlightreporting.com/archive/2016/10)
- [September 2016 (3)](https://blog.spotlightreporting.com/archive/2016/09)
- [August 2016 (5)](https://blog.spotlightreporting.com/archive/2016/08)
- [July 2016 (3)](https://blog.spotlightreporting.com/archive/2016/07)
- [June 2016 (5)](https://blog.spotlightreporting.com/archive/2016/06)
- [April 2016 (1)](https://blog.spotlightreporting.com/archive/2016/04)
- [March 2016 (1)](https://blog.spotlightreporting.com/archive/2016/03)
- [January 2016 (4)](https://blog.spotlightreporting.com/archive/2016/01)
- [December 2015 (2)](https://blog.spotlightreporting.com/archive/2015/12)
- [November 2015 (3)](https://blog.spotlightreporting.com/archive/2015/11)
- [October 2015 (1)](https://blog.spotlightreporting.com/archive/2015/10)
- [September 2015 (1)](https://blog.spotlightreporting.com/archive/2015/09)
- [August 2015 (5)](https://blog.spotlightreporting.com/archive/2015/08)
- [July 2015 (2)](https://blog.spotlightreporting.com/archive/2015/07)
- [June 2015 (3)](https://blog.spotlightreporting.com/archive/2015/06)
- [May 2015 (4)](https://blog.spotlightreporting.com/archive/2015/05)
- [April 2015 (6)](https://blog.spotlightreporting.com/archive/2015/04)
- [March 2015 (4)](https://blog.spotlightreporting.com/archive/2015/03)
- [February 2015 (2)](https://blog.spotlightreporting.com/archive/2015/02)
- [January 2015 (3)](https://blog.spotlightreporting.com/archive/2015/01)
- [December 2014 (1)](https://blog.spotlightreporting.com/archive/2014/12)
- [November 2014 (1)](https://blog.spotlightreporting.com/archive/2014/11)
- [October 2014 (2)](https://blog.spotlightreporting.com/archive/2014/10)
- [August 2014 (5)](https://blog.spotlightreporting.com/archive/2014/08)

see all

### Subscribe for Email Updates

[![Return to homepage](https://blog.spotlightreporting.com/hubfs/Brand_attributes/spotlight%20reporting%20logo.svg "Return to homepage")](https://www.spotlightreporting.com/)

- Our Company
- [Our Team](https://www.spotlightreporting.com/our-team/)
- [Careers](https://www.spotlightreporting.com/careers/)

- Solutions
- [Advisor](https://www.spotlightreporting.com/our-solutions/#advisor)
- [Owner & CFO](https://www.spotlightreporting.com/our-solutions/#owner-cfo)
- [Franchise](https://www.spotlightreporting.com/our-solutions/#franchise)
- [Not for Profit](https://www.spotlightreporting.com/our-solutions/#not-for-profit)

- Resources
- [Special Events](https://www.spotlightreporting.com/resources/#special-events)
- [Partner Success Centre](https://psc.spotlightreporting.com)
- [Webinars](https://www.spotlightreporting.com/resources/#webinars)
- [Help Centre](https://www.spotlightreporting.com/resources/#help-centre)
- [Blog](https://blog.spotlightreporting.com/)
- [White paper](https://www.spotlightreporting.com/resources/#white-paper)

- Plans
- [Basic](https://www.spotlightreporting.com/pricing/)
- [Super VCFO](https://www.spotlightreporting.com/pricing/)
- [Owners & CFOs](https://www.spotlightreporting.com/business-plans/)
- [Franchise](https://www.spotlightreporting.com/business-plans/)
- [Not For Profit](https://www.spotlightreporting.com/business-plans/)

- [LinkedIn Created with Sketch. LinkedIn](https://www.linkedin.com/company/spotlight-reporting-limited)
- [Facebook Created with Sketch. Facebook](https://www.facebook.com/Spotlight-Reporting-380174365420847/?fref=ts)
- [Twitter Created with Sketch. Twitter](https://twitter.com/spotlightrep?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor)
- [Vimeo Created with Sketch. Vimeo](https://vimeo.com/spotlightreporting)

© Spotlight Reporting 2018