---
title: Driving reporting excellence through consolidation
description: "Consolidation of financial statements made easy for accountants with our new features: automated eliminations, new elimination reporting formats and FX options."
image: https://blog.spotlightreporting.com/hubfs/Product_updates/3.17_Eliminations/Email_teaser_image_Consolidating_reports.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

# Driving reporting excellence through consolidation

Posted by [Nik George](https://blog.spotlightreporting.com/author/nik-george) on 18 Aug 2016

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

Being able to prepare consolidated reports is a ‘must’ for advisory accountants. Over time, your client’s entity may have grown into a multi-entity global business. Perhaps these entities were originally set-up to minimise risk and reduce tax or they simply diversified into other interests. Whatever the reasons, you now need to be able to prepare consolidated reports based on their group performance and position.

Since May 2012, Spotlight Reporting has helped advisors prepare consolidated reports. Our first release enabled users to consolidate up to five entities and handle multiple currencies. Since then, the entity limit has increased to fifty entities and more currencies were added as our customers needs grew.

Now, we are proud to announce our biggest update to consolidations since it’s inception. We’ve been listening to your feedback and it’s formed an integral part of this release. So what’s new in [Spotlight Reporting](https://www.spotlightreporting.com/product/reporting/)?

### Automated eliminations

You can now tag accounts as intercompany accounts and Spotlight will automatically eliminate these every month. Just click the **Eliminate Accounts** button on the Group Customise Data tab and specify the intercompany account(s) in each entity. If there are any FX differences that arise from the elimination, these will be journaled into a FX adjustment row in the reports.

![Automated_eliminations_in_consolidated_reports_Sotlight_Reporting.png](https://blog.spotlightreporting.com/hs-fs/hubfs/Product_updates/3.17_Eliminations/Automated_eliminations_in_consolidated_reports_Sotlight_Reporting.png?width=600&name=Automated_eliminations_in_consolidated_reports_Sotlight_Reporting.png "Automated_eliminations_in_consolidated_reports_Sotlight_Reporting.png")

### Elimination reporting formats

Of course you still want visibility over what is eliminated, so we have updated the Entity breakdown settings on the profit & loss and balance sheet pages. You can choose between the **Detailed** view which shows the elimination workings (debits, credits, totals before and after elimination) or the **Summarised** option which shows a summarised consolidation. You may like to use the **Detailed** option to check you have eliminated the relevant accounts and then switch to the **Summarised** option when sharing the reports.

![Elimination_Reporting_Formats_Consolidated_Reports_Spotlight_Reporting.png](https://blog.spotlightreporting.com/hs-fs/hubfs/Product_updates/3.17_Eliminations/Elimination_Reporting_Formats_Consolidated_Reports_Spotlight_Reporting.png?width=600&name=Elimination_Reporting_Formats_Consolidated_Reports_Spotlight_Reporting.png "Elimination_Reporting_Formats_Consolidated_Reports_Spotlight_Reporting.png")

### New FX options

Lastly, we’ve added a number of new FX options based on your feedback. You can now view the FX rates used in Spotlight by clicking the **Edit Exchange Rates** button on the Group Settings page. When converting profit & loss values, you can choose between using the:

- Xe.com month-end rate,
- The monthly average rate,
- Or you can enter your own rate.

Balance sheet values can be coverted using the Xe.com month-end rate or your own rate.

![New_FX_options_Exchange_Rate_Consolidated_reports_Spotlight_Reporting.png](https://blog.spotlightreporting.com/hs-fs/hubfs/Product_updates/3.17_Eliminations/New_FX_options_Exchange_Rate_Consolidated_reports_Spotlight_Reporting.png?width=600&name=New_FX_options_Exchange_Rate_Consolidated_reports_Spotlight_Reporting.png "New_FX_options_Exchange_Rate_Consolidated_reports_Spotlight_Reporting.png")

Check out our [1-min release video](https://vimeo.com/176252271) to see the new features in action. To get the most out of our product updates, view our [post-release training webinar.](https://vimeo.com/179975430)

We hope you enjoy the latest release.

[![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)](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