# Sun Realm switches complicated spreadsheet reporting for ground breaking Insight solution generating time savings of over 30% Author: Pal Sinha, Barnali Author URL: https://financedigest.com/author/pal-sinha-barnali Published: 2018-03-14 Category: NEWS Category URL: https://financedigest.com/category/news Meta Title: Revolutionise Your Local Authority Contracts with Insight Meta Description: Revolutionise your local authority contracts with Sun Realm's award-winning technology solution. Say goodbye to manual data entry and streamline your URL: https://financedigest.com/sun-realm-switches-complicated-spreadsheet-reporting-for-ground-breaking-insight-solution-generating-time-savings-of-over-30html ![undefined](https://prod.superblogcdn.com/site_cuid_cm5qst7v3003gwirgwqtxn8i8/images/fd140318-2-1736842920873-compressed.jpg) _Insight ticks all the boxes for Open Book contracts with local authorities_ Sun Realm is a leading supplier of heating services in Luton and the surrounding areas and in its’ 45 years of trading, it has built a strong business dealing with private and public sector clients. In its dealings with local authorities, the company has seen an increasing demand for complete transparency and ‘Open Book’ contracts are now very much the norm. The incumbent highly complex and manual spreadsheet [reporting system](https://www.financedigest.com/tesla-reports-two-new-fatal-crashes-involving-driver-assistance-systems.html "Tesla reports two new fatal crashes involving driver assistance systems") was not built to sustainably deliver the processing and flow of data required for these contracts. Huge amounts of time were being burned on manual data entry and endless copying and pasting. Sun Realm was applying considerable effort to supply the full [valuation](https://www.financedigest.com/plywood-market-to-reach-a-valuation-of-us-115-bn-by-2028-comprehensive-research-report-by-fmi.html "Plywood Market to reach a valuation of US$ 115 Bn by 2028 – Comprehensive Research Report by FMI") reports incorporating breakdowns of fixed price installations as well as the quarterly full Open Book reports. The risk of error presented an ongoing challenge and any holes in the [monthly reporting](https://www.financedigest.com/whatsapp-bans-2-4-million-indian-accounts-in-july-monthly-report.html "WhatsApp bans 2.4 million Indian accounts in July – monthly report") would trigger queries that required further investigation. John Montgomery, [Operations Director](https://www.financedigest.com/white-bullet-appoints-stuart-dickinson-as-director-of-advertising-operations-and-client-success.html "White Bullet appoints Stuart Dickinson as Director of Advertising Operations and Client Success") of Sun Realm looked long and hard for a solution that could help solve the problem as he was spending over 30% of his time copying and pasting between spreadsheets. The system was so complex with multiple checks and deep background knowledge required that he could not outsource any of the operation to his office administration team. A solution was found following a chance conversation between John and a business acquaintance who introduced Sean Blencowe, CEO of [Green Light](https://www.financedigest.com/teslas-long-delayed-german-gigafactory-gets-conditional-green-light.html "Tesla’s long-delayed German gigafactory gets conditional green light") Change (GLC) to Sun Realm. GLC was working on the development of an application that solves the endemic problem of spreadsheets [faced by so many companies and which is costing businesses](https://www.financedigest.com/saving-on-water-bills-more-than-just-a-drop-in-the-ocean-for-businesses-facing-the-cost-of-living-crisis.html "Saving on water bills: More than just a drop in the ocean for businesses facing the cost-of-living crisis") thousands of man hours a year. Working in partnership with and using award winning technology developed by Synapse, a technology [company that counts](https://www.financedigest.com/factbox-companies-count-the-cost-of-ditching-russia.html "Factbox – Companies count the cost of ditching Russia") amongst its customers a leading UK high street bank and a well-known Swedish global retailer, Green Light Change has come up with a radically different solution to the spreadsheet problem: Insight PBF (Planning, Budgeting and Forecasting) platform. Insight natively connects spreadsheets to a powerful, enterprise application so that everyone can still work from within Excel™, but now they are connected. Spreadsheets are preserved and their historic limitations overcome. Real-time integrated views drive strong team cohesion, increase efficiency and build trusted up-to-the minute [reports with the level of integrity local authority contracts demand](https://www.financedigest.com/pharmaceutical-contract-sales-outsourcing-market-statistics-demand-and-forecasts-to-2031-examined-in-new-research-report.html "Pharmaceutical Contract Sales Outsourcing Market Statistics, Demand and Forecasts to 2031 Examined in New Research Report"). Sun Realm [implemented Insight in late 2015 and the company](https://www.financedigest.com/why-are-companies-implementing-crypto-payments.html "Why are companies implementing crypto payments?") has not looked back. John Montgomery says the timesavings are enormous. “I have been able to put over a [day a week](https://www.financedigest.com/transitioning-into-a-4-day-week.html "Transitioning into a 4 day week") back in my diary. Prior to implementing Insight, I would have to enter and manually collate [information from our installation reports and then manually cross check it with our booking and accounting systems](https://www.financedigest.com/the-cardiovascular-information-systems-market-is-expected-to-grow-on-a-persistent-note-in-the-future.html "The Cardiovascular Information Systems Market is expected to grow on a persistent note in the future"). That wasn’t a good use of my time. Now, the process is much cleaner and I’ve saved yet more time by confidently outsourcing [work to our office](https://www.financedigest.com/are-businesses-using-cybersecurity-as-a-scapegoat-for-a-desperate-return-to-office-working.html "Are Businesses Using Cybersecurity As A Scapegoat For A Desperate Return To Office Working?") team.” Up to the minute, trusted information is absolutely critical in dealing with public sector contracts and because the [Insight system](https://www.financedigest.com/test-automation-systems-for-powertrain-dynamometer-market-to-reach-worth-of-us-1-20-bn-by-2031-tmr-insights.html "Test Automation Systems for Powertrain Dynamometer Market to reach worth of US$ 1.20 Bn by 2031, TMR Insights") is very resistant to errors, Sun Realm has complete confidence in the integrity of the data. John estimates that the [quality is ’70 per cent’ improved](https://www.financedigest.com/av-power-conditioners-market-will-gain-traction-over-2026-owing-to-improvements-in-audio-and-video-quality.html "AV Power Conditioners Market Will Gain Traction Over 2026 Owing To Improvements In Audio And Video Quality") and the number of queries from the Local Authority has decreased sharply as the data provided by Insight is so reliable. John says: “The elimination of ‘copy & paste’ [errors has greatly improved the quality and consistency of our reporting](https://www.financedigest.com/metro-bank-former-top-bosses-fined-over-reporting-error.html "Metro Bank, former top bosses fined over reporting error"), increasing overall confidence in the accuracy and transparency of our Open Book system”. The next stage, ‘Phase 2’, will see the [company explore the use of Smartphones in the field and sophisticated analytics shown on easy to understand](https://www.financedigest.com/understanding-company-debt-finance.html "Understanding company debt finance") dashboards. These will make it easier to pick out [trends and provide in-depth cost & revenue analysis](https://www.financedigest.com/automated-liquid-handling-systems-market-global-leading-companies-analysis-revenue-trends-and-forecasts-2027.html "Automated Liquid Handling Systems Market Global Leading Companies Analysis, Revenue, Trends and Forecasts 2027"). John concludes by saying: “Insight automates the monthly [reporting and has totally changed](https://www.financedigest.com/u-n-climate-change-report-sounds-code-red-for-humanity.html "U.N. climate change report sounds ‘code red for humanity’") the way we view ‘Open Book’ contracts. They are no longer onerous as Insight connects the data and provides the holistic view that we were missing. The Insight team are consistently responsive, helping us shape the solution to best meet our needs.” --- This blog is powered by Superblog. Visit https://superblog.ai to know more. ---