--- title: It's time to consolidate in the Cloud description: Explore how to make consolidation accurate, regular, achievable and scalable with cutting-edge cloud technologies. image: https://blog.spotlightreporting.com/hubfs/Blog_files/Header_images/Consolidation%20in%20the%20Cloud.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](http://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 # It's time to consolidate in the Cloud Posted by [Richard Francis](http://blog.spotlightreporting.com/author/richard-francis) on 12 Jun 2018 - [Tweet](https://twitter.com/share)   ![Consolidation in the Cloud](https://blog.spotlightreporting.com/hubfs/Blog_files/Header_images/Consolidation%20in%20the%20Cloud.jpg) As businesses grow, it is often inevitable that additional entities will be needed. Typically these will arise from international expansion into new markets or for legal and risk mitigation. Accounting for multi-entity operations requires a lot of stitching together of the various entities’ Profit and Loss and Balance Sheet information. This can be especially tricky if multiple currencies are involved. Consolidation can be a full-time job or a nasty recurring chore for someone in Finance, possibly handled in an Excel Circle of Hell replete with manual transposition risk and outdated reporting options. The usability of the outputs can be less relevant with this approach than the sheer effort to piece together the data each and every month. ### Consolidation should be: - **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. ### Fast creation of advanced consolidated reports [Spotlight Reporting](https://www.spotlightreporting.com/product#reporting) 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 Reporting offers ease of use, speed and clarity. Spotlight Reporting allows you to consolidate up to 50 of related entities – unparalleled functionality in the small and medium-sized business sector. Our seamless imports from Xero, MYOB and QuickBooks products (both cloud and desktop) allow you to get entity data quickly and effectively. With over 50 currencies available in Spotlight, most international operations are covered. Spotlight Reporting also facilitates: 1. Eliminations of intercompany transactions 2. Categorisation of organisations in a group 3. Filtered reports by group organisation Eliminations of intercompany transactions are a necessary step in many consolidated reporting processes. Spotlight Reporting can handle these too, automatically eliminating but also allowing you to create additional elimination debits and credits transparently and easily. ### Aggregation and benchmarking Aggregation and benchmarking does not have to be a costly, slow and manual process. It should be useful, efficient and transparent. We have a specialist product called [Spotlight Multi](https://www.spotlightreporting.com/product#multi) that can handle aggregation and benchmarking for up to five hundred entities. Spotlight Multi facilitates: 1. Effective, clear reporting at head office, franchisor or accountant/CFO level 2. Shareable, understandable reports for franchisees,branches or individual entities 3. Specific, actionable benchmarking, exception reporting and rankings across various KPI’s 4. Cross-border multi-currency conversion 5. Narrative observations, highlights and recommendations for open dialogue on performance improvement. These are just a few highlights that Spotlight Multi can help franchisors and their franchisees with. To see how our franchise clients benefit from Multi, please view our [case study from The Cheesecake Shop](https://vimeo.com/180796913), a large franchise organisation with 200+ shops across Australia and New Zealand.  This chapter was extracted from the "[Consolidations in the Cloud](http://info.spotlightreporting.com/consolidated-reporting)" white paper written by Richard Francis, CA, CEO of Spotlight Reporting. You can download a full version of this free white paper here. [![Consolidation in the Cloud](https://no-cache.hubspot.com/cta/default/1756382/e0be7488-fd09-4a24-88d9-89e165c3f805.png)](https://cta-redirect.hubspot.com/cta/redirect/1756382/e0be7488-fd09-4a24-88d9-89e165c3f805) ### Recent Posts --- ### Posts by Month - [August 2020 (4)](http://blog.spotlightreporting.com/archive/2020/08) - [July 2020 (7)](http://blog.spotlightreporting.com/archive/2020/07) - [June 2020 (7)](http://blog.spotlightreporting.com/archive/2020/06) - [May 2020 (4)](http://blog.spotlightreporting.com/archive/2020/05) - [April 2020 (11)](http://blog.spotlightreporting.com/archive/2020/04) - [March 2020 (12)](http://blog.spotlightreporting.com/archive/2020/03) - [January 2020 (3)](http://blog.spotlightreporting.com/archive/2020/01) - [December 2019 (5)](http://blog.spotlightreporting.com/archive/2019/12) - [November 2019 (4)](http://blog.spotlightreporting.com/archive/2019/11) - [October 2019 (4)](http://blog.spotlightreporting.com/archive/2019/10) - [September 2019 (5)](http://blog.spotlightreporting.com/archive/2019/09) - [August 2019 (4)](http://blog.spotlightreporting.com/archive/2019/08) - [July 2019 (1)](http://blog.spotlightreporting.com/archive/2019/07) - [June 2019 (3)](http://blog.spotlightreporting.com/archive/2019/06) - [May 2019 (4)](http://blog.spotlightreporting.com/archive/2019/05) - [April 2019 (1)](http://blog.spotlightreporting.com/archive/2019/04) - [March 2019 (2)](http://blog.spotlightreporting.com/archive/2019/03) - [January 2019 (2)](http://blog.spotlightreporting.com/archive/2019/01) - [December 2018 (1)](http://blog.spotlightreporting.com/archive/2018/12) - [November 2018 (1)](http://blog.spotlightreporting.com/archive/2018/11) - [October 2018 (1)](http://blog.spotlightreporting.com/archive/2018/10) - [September 2018 (3)](http://blog.spotlightreporting.com/archive/2018/09) - [July 2018 (3)](http://blog.spotlightreporting.com/archive/2018/07) - [June 2018 (2)](http://blog.spotlightreporting.com/archive/2018/06) - [May 2018 (4)](http://blog.spotlightreporting.com/archive/2018/05) - [March 2018 (1)](http://blog.spotlightreporting.com/archive/2018/03) - [January 2018 (4)](http://blog.spotlightreporting.com/archive/2018/01) - [November 2017 (2)](http://blog.spotlightreporting.com/archive/2017/11) - [October 2017 (2)](http://blog.spotlightreporting.com/archive/2017/10) - [September 2017 (3)](http://blog.spotlightreporting.com/archive/2017/09) - [August 2017 (2)](http://blog.spotlightreporting.com/archive/2017/08) - [July 2017 (1)](http://blog.spotlightreporting.com/archive/2017/07) - [June 2017 (4)](http://blog.spotlightreporting.com/archive/2017/06) - [May 2017 (1)](http://blog.spotlightreporting.com/archive/2017/05) - [April 2017 (3)](http://blog.spotlightreporting.com/archive/2017/04) - [March 2017 (4)](http://blog.spotlightreporting.com/archive/2017/03) - [January 2017 (3)](http://blog.spotlightreporting.com/archive/2017/01) - [December 2016 (2)](http://blog.spotlightreporting.com/archive/2016/12) - [November 2016 (4)](http://blog.spotlightreporting.com/archive/2016/11) - [October 2016 (2)](http://blog.spotlightreporting.com/archive/2016/10) - [September 2016 (3)](http://blog.spotlightreporting.com/archive/2016/09) - [August 2016 (5)](http://blog.spotlightreporting.com/archive/2016/08) - [July 2016 (3)](http://blog.spotlightreporting.com/archive/2016/07) - [June 2016 (5)](http://blog.spotlightreporting.com/archive/2016/06) - [April 2016 (1)](http://blog.spotlightreporting.com/archive/2016/04) - [March 2016 (1)](http://blog.spotlightreporting.com/archive/2016/03) - [January 2016 (4)](http://blog.spotlightreporting.com/archive/2016/01) - [December 2015 (2)](http://blog.spotlightreporting.com/archive/2015/12) - [November 2015 (3)](http://blog.spotlightreporting.com/archive/2015/11) - [October 2015 (1)](http://blog.spotlightreporting.com/archive/2015/10) - [September 2015 (1)](http://blog.spotlightreporting.com/archive/2015/09) - [August 2015 (5)](http://blog.spotlightreporting.com/archive/2015/08) - [July 2015 (2)](http://blog.spotlightreporting.com/archive/2015/07) - [June 2015 (3)](http://blog.spotlightreporting.com/archive/2015/06) - [May 2015 (4)](http://blog.spotlightreporting.com/archive/2015/05) - [April 2015 (6)](http://blog.spotlightreporting.com/archive/2015/04) - [March 2015 (4)](http://blog.spotlightreporting.com/archive/2015/03) - [February 2015 (2)](http://blog.spotlightreporting.com/archive/2015/02) - [January 2015 (3)](http://blog.spotlightreporting.com/archive/2015/01) - [December 2014 (1)](http://blog.spotlightreporting.com/archive/2014/12) - [November 2014 (1)](http://blog.spotlightreporting.com/archive/2014/11) - [October 2014 (2)](http://blog.spotlightreporting.com/archive/2014/10) - [August 2014 (5)](http://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