--- title: Your Ultimate Guide to Consolidations with Spotlight description: New to consolidations in Spotlight and not sure where to start? We’ll walk you through the basics so you know what to expect along the way. image: https://blog.spotlightreporting.com/hubfs/Featured%20Image.png --- [![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 # Your Ultimate Guide to Consolidations with Spotlight Posted by [Paul Gray](https://blog.spotlightreporting.com/author/paul-gray) on 13 Sep 2019 - [Tweet](https://twitter.com/share) New to consolidations in Spotlight and not sure where to start? We’ll walk you through the basics so you know what to expect along the way. *![Spotlight Consolidation](https://blog.spotlightreporting.com/hs-fs/hubfs/Spotlight%20Consolidation.jpg?width=678&name=Spotlight%20Consolidation.jpg)* You’ve no doubt heard of consolidation. It’s a part of effective management and essential to providing insightful information to all stakeholders to keep a business scaling. If you’ve never used a tool like Spotlight to do consolidations, how do you know what to do, where to do it, and what steps to take? And what’s the difference between doing it in a spreadsheet and Spotlight? Lucky for you, our team at Spotlight has consolidations down pat, and we want to share our expert-level experience with you. So put on your learning hat (you have one of those, right?), and let’s get consolidating. ### **Part 1: Why Consolidation?** First things first*,* consolidation serves three simple but *exact* purposes (already familiar with the ‘why’ of consolidations? *Skip to* [*Part 2*](https://blog.spotlightreporting.com/your-ultimate-guide-to-consolidations-with-spotlight#part2)*):* 1. Consolidations empower stakeholders to get a complete overview of the overall group 2. Consolidation = less paperwork. There’s less effort involved in assessing the overall group's financial health, i.e. you don’t have to prepare a set of reports for each entity! 3. Consolidation cuts out all transactions that occur between entities and the parent company. These things essentially cancel each other out. Eliminating these transactions gives a simplified view of business performance. Our CEO and CA, Richard Francis, advocates that consolidation needs to regular, achievable, and scalable. Let’s break that down: - Regular: stakeholders should see regular, up-to-date and accurate information for decision-making. - Achievable: if consolidated accounting was less time-intensive, it would be both cost-effective and a win-win for preparer and consumer. - Scalable: as entities or currencies are added, they should be able to be easily folded into the existing reporting framework. | **#SpotlightTip:** Our CEO and CA, Richard Francis has written a white paper that does a deep dive into consolidation. It’s free! Download it [here](https://info.spotlightreporting.com/consolidated-reporting). | | --- | Sounds easy, right? Depending on yours or your client’s business model, consolidation can quickly become complicated using traditional methods – we’re talking spreadsheets here, with their manual transposition risk and outdated reporting options. To make consolidation easier on you, we're going to walk you through the basics of creating a consolidated report in Spotlight, including the process for importing data, through to visualising and sharing your first report. --- ### **Part 2: Using Spotlight for Consolidations** Spotlight was developed to not only provide faster creation of advanced management reports – great for the CFO, CEO Board and/or Advisor – but to present beautiful, understandable outputs. For those needing consolidation functionality, Spotlight’s products offer ease of use, speed and clarity. #### 1. Making sense of Spotlight Multi vs. Spotlight Reporting Before we get started, let’s talk about the differences between the two Spotlight products that can be used for consolidation: - Spotlight Reporting was designed for company consolidations. You can use it to consolidate up to 50 entities, and to create consolidated and entity comparative Profit and Loss and Balance Sheet reports. - Spotlight Multi is more suited for franchises and not-for-profits which need to consolidate up to 500 entities. Along with creating consolidated Profit and Loss and Balance Sheet reports, you can also rank/benchmark the entities and highlight underperforming entities. | **#SpotlightTip**: Want to see the difference between a Spotlight Reporting and Spotlight Multi Report? Download a [Spotlight Multi](https://info.spotlightreporting.com/spotlight-multi-sample-report) or [Spotlight Reporting](https://info.spotlightreporting.com/spotlight-reporting-sample-report) sample report. | | --- | #### 2. Building your first report Building your first report can be daunting, but trust us, it’s easy. Matt Kekena, our Training and Education Manager, put together a great how-to video (3-min) taking you through the steps to build a consolidated report that will delight your stakeholders. I recommend watching this video and then jumping right in. And like everything in Spotlight, you can start by adding an organisation. It’s sort of like making your bed, right? No matter what else you do (or don’t) get done after, you at least did that... > #### The ability to automate and generate consolidated accounts in a real-time environment without the need to continuously export data to Excel and manipulate really saves time, especially in Asia where we work across multiple currency environments. There's less room for error and clients can benefit from well-structured and simplified reporting. No more Excel spreadsheets. *– Paul Gardner, Fresh Accounting* #### 3. Level-up with Spotlight features We’ve got a few tricks up our sleeve to enhance your consolidated reports. Take a look: - Spotlight will complete **multi-currency conversions** when working in a multi-currency consolidated report. We use XE.com to do conversions in Spotlight. You can view and edit the exchange rates that Spotlight uses for converting organisations with different currencies into the group report currency. [Watch video](https://vimeo.com/287006026) - When you work with a group of companies, there may be situations where one company within the group sells to or buys from another. If you want to adjust your reports to account for these inter-company transactions, you can do this automatically in Spotlight using **Eliminations**. [Watch video](https://vimeo.com/287006026) - You can use **categories to filter** consolidated reports and compare entities with certain traits. For example, if you run a group report consisting of entities located around the world, you might then want to run a comparative P&L for USA branches only. [Watch video](https://vimeo.com/290189819) #### 4. Preview and share Step back and take a look at your work. 👏 The insights that can be derived from a consolidated report are extensive. For example, you can use Spotlight Multi to benchmark entities’ key financial and non-financial metrics. You’ll find lots of quality, actionable insights. Now it’s time to share your report. Don’t forget to stamp your logo on and [customise your report cover](https://blog.spotlightreporting.com/branded-reporting-for-advisory-success) to get all the “wows.” ![multi small image](https://blog.spotlightreporting.com/hs-fs/hubfs/multi%20small%20image.png?width=1007&name=multi%20small%20image.png) --- ### **Part 3: Resources to help you succeed** [Here’s a handy list of resources to help you succeed with consolidation in Spotlight Reporting:](https://info.spotlightreporting.com/spotlight-multi-sample-report) 1. [**Spotlight Advanced Training Video, feat. Consolidation**](https://info.spotlightreporting.com/spotlight_reporting_advanced_webinar)Our Spotlight experts have put together these videos, which are loaded with handy tips and best practice advice. 2. [**White paper: Consolidation in the Cloud**](https://info.spotlightreporting.com/consolidated-reporting-for-accountants-ppc-0) This white paper is for accountants who prepare consolidated reports for clients, a Board, franchisor or franchisees. 3. [**Consolidation Tips Webinar Recording**](https://vimeo.com/200752640)Let our Education and Training Manager take you through an in-depth look at consolidation. 4. [**Spotlight Multi Sample Report**](https://info.spotlightreporting.com/spotlight-multi-sample-report) For franchises, not for profits and industry specialists, Spotlight Multi allows you to aggregate, rank and benchmark. --- ### **Part 4: Hear from the consolidation pros** #### **The Cheesecake Shop** Ken is Executive Director of The Cheesecake Shop, a large franchise organisation with 200 shops across Australia and New Zealand. Ken needed a group consolidation tool that could benchmark and rank his shops across his entire network. Spotlight Multi was the only solution. Seamlessly import data from Xero, Multi made reporting 'a piece of cake!' #### **San Churro** Learn how Xero and Spotlight Reporting became the perfect combination for Franchise group San Churros to deliver their reporting requirements. Jacqui from San Churros explains how connecting Spotlight to all their Franchise Xero organisations removed their pain points and achieved a new level of reporting efficiency. #### **Fresh Accounting** Find out how Paul Gardner, the founder and CEO of Fresh Accounting, utilises the Spotlight suite of products to gain a significant competitive advantage over other accounting firms and provide excellent service to his clients in dynamic and highly competitive Hong Kong. [**![Powered By Spotlight - Fresh Accounting](https://blog.spotlightreporting.com/hs-fs/hubfs/Powered%20By%20Spotlight%20-%20Fresh%20Accounting.jpg?width=1200&name=Powered%20By%20Spotlight%20-%20Fresh%20Accounting.jpg)**](https://blog.spotlightreporting.com/paul-gardner-fresh-accounting) **[![Sample Report (Multi)](https://no-cache.hubspot.com/cta/default/1756382/9d8d0bac-abf8-495a-bfaf-e8a488941aab.png)](https://cta-redirect.hubspot.com/cta/redirect/1756382/9d8d0bac-abf8-495a-bfaf-e8a488941aab)** ### 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 ```json { "@context" : "https://schema.org", "@type" : "VideoObject", "contentUrl" : "https://1756382.fs1.hubspotusercontent-na1.net/hubfs/1756382/Consolidations%20Walk-through.mp4", "dateModified" : "2022-05-23T23:22:15.824Z", "duration" : "PT3M21S", "height" : 1080, "name" : "Consolidations Walk-through", "thumbnailUrl" : "https://api-na1.hubapi.com/filemanager/api/v3/files/thumbnail-redirect/12815788194?portalId=1756382&size=medium", "uploadDate" : "2019-09-09T22:18:14.120Z", "width" : 1920 } ``` ```json { "@context" : "https://schema.org", "@type" : "VideoObject", "contentUrl" : "https://1756382.fs1.hubspotusercontent-na1.net/hubfs/1756382/Partner%20Success_%20The%20Cheesecake%20Shop.mp4", "dateModified" : "2022-05-23T23:22:16.977Z", "duration" : "PT1M55S", "height" : 1080, "name" : "Partner Success_ The Cheesecake Shop", "thumbnailUrl" : "https://api-na1.hubapi.com/filemanager/api/v3/files/thumbnail-redirect/12815796364?portalId=1756382&size=medium", "uploadDate" : "2019-09-09T22:48:20.307Z", "width" : 1920 } ``` ```json { "@context" : "https://schema.org", "@type" : "VideoObject", "contentUrl" : "https://1756382.fs1.hubspotusercontent-na1.net/hubfs/1756382/Spotlight%20Reporting%20%2B%20Xero%20-%20the%20essential%20accounting%20and%20reporting%20toolkit%20at%20San%20Churro.mp4", "dateModified" : "2022-05-23T23:22:28.452Z", "duration" : "PT1M45S", "height" : 1080, "name" : "Spotlight Reporting + Xero - the essential accounting and reporting toolkit at San Churro", "thumbnailUrl" : "https://1756382.fs1.hubspotusercontent-na1.net/hubfs/1756382/Spotlight%20Reporting%20%2B%20Xero%20-%20the%20essential%20accounting%20and%20reporting%20toolkit%20at%20San%20Churro.mp4/medium.jpg?t=1653348148452", "uploadDate" : "2019-09-09T21:29:22.743Z", "width" : 1920 } ```