在英国电信,快速的,基于标准的收入计算——带着一丝乐趣

英国电信根据严格的IFRS 15标准,使用Anaplan计算3200万客户的收入

观看视频 联系我们

BT Group—the UK’s largest mobile carrier, with 32 million customers—needed a better way to report revenue in a way that met IFRS 15 standards. By using Anaplan as a scalable platform for financial reporting, they cut process time dramatically, improved data retention for analysis—and had some fun doing it.\r\n"}}" id="text-878fbcc7e6" class="cmp-text">
英国最大的移动运营商BT集团(拥有3200万用户)需要一种更好的方式来报告收入,以符合IFRS 15标准。通过使用Anaplan作为一个可扩展的财务报告平台,他们极大地缩短了处理时间,提高了用于分析的数据保留率——并且从中获得了一些乐趣。

anplan一直是提高效率的关键,它让我们获得了以前无法获得的数据。
James Mash,会计和财务控制经理

93%

更快的月收入计算

1

一个人用不到一小时的时间计算出月收入

30.

可用于分析的数据有数百万行(还在不断增加)



Reporting revenue at telecom giant BT Group changed fundamentally when IFRS 15 kicked in on January 1, 2018. The new accounting standard revamped how companies account for income from customer contracts, and with 32 million mobile customers—more than any other UK mobile carrier—BT has a lot of contracts.

\r\n

“None of our financial systems were able to manage this,” recalls James Mash, BT’s Accounting and Financial Control Manager. Mash’s team tried to calculate revenue to the new standard with spreadsheets, but the monthly task took four accountants between four and six hours. The company wanted to release figures the morning after month’s end, but Mash couldn’t reliably meet that deadline.

\r\n

“We needed an all-in-one solution,” Mash recalled—not a dozen cumbersome spreadsheets built on fragile macros. People from BT’s “Making Finance Brilliant” finance innovation program suggested he try Anaplan.

\r\n

Mash and his colleagues created an IFRS 15 reporting solution in 16 weeks. “Building something useful within that space of time is incredibly valuable for a business like BT, where IT projects can take two to three years,” he says.

\r\n

The Anaplan solution is much faster and more reliable than what it replaced. Monthly revenue figures are now calculated by one person in less than an hour—a time saving greater than 93%.

\r\n

The benefits go beyond speed. The new solution is auditable for Sarbanes-Oxley compliance, and handles BT’s voluminous point-of-sale data with ease. To keep the old system running, some 800,000 lines of data had to be filtered down to 250,000 each month, so a lot of detail was lost. The Anaplan solution holds more than 30 million lines of data (and growing) with no performance issues. “Anaplan has been key to building efficiencies and allowing us to get numbers that we weren’t able to before,” Mash notes.

\r\n

IFRS 15 revenue calculation is an unusual Anaplan use case, Mash admits, but it illustrates the platform’s flexibility. “Anaplan is like a big modular calculator that’s capable of crunching vast volumes of data,” he says. “It fills a gap that none of the other tools I’ve used before does.”

\r\n

Not only that; it’s a joy to work with. “Anaplan is fun for me, as a model builder and data analyst, to use,” he says. His enthusiasm is shared across BT, where teams including call center planning, OpEx planning, forecasting, and the fibre broadband business all use Anaplan and are exploring ways to connect plans to deliver even greater value.

\r\n"}}" id="text-91691920cb" class="cmp-text">

2018年1月1日IFRS 15生效后,电信巨头英国电信集团的营收报告发生了根本性变化。新的会计准则修订了公司如何核算客户合同收入,英国电信拥有3200万移动客户——比任何其他英国移动运营商都多——有很多合同。

英国电信的会计和财务控制经理詹姆斯•马什回忆说:“我们的财务系统都无法应对这种情况。”马什的团队试图用电子表格计算新标准的收入,但每月的任务需要四名会计花费四到六个小时。该公司希望在月底的第二天早上公布数据,但Mash无法在最后期限前完成。

“我们需要一个一体化的解决方案,”Mash回忆道,而不是一打建立在脆弱宏上的繁琐电子表格。英国电信“让金融辉煌”金融创新项目的人员建议他试试Anaplan。

Mash和他的同事在16周内创建了IFRS 15报告解决方案。他说:“对于BT这样的企业来说,在这么短的时间内构建一些有用的东西是非常有价值的,因为IT项目可能需要两到三年的时间。”

anplan解决方案比它所取代的解决方案更快、更可靠。每月收入数据现在由一个人在不到一小时的时间内计算出来,节省了超过93%的时间。

好处不仅仅在于速度。新的解决方案符合萨班斯-奥克斯利法案的规定,可以轻松处理BT的大量销售点数据。为了保持旧系统的运行,每月必须将大约80万行数据过滤到25万行,因此丢失了大量细节。ananplan解决方案拥有超过3000万行数据(而且还在不断增加),没有任何性能问题。马什指出:“Anaplan是提高效率的关键,它让我们获得了以前无法获得的数据。”

马什承认,IFRS 15收入计算是一个不寻常的Anaplan用例,但它说明了平台的灵活性。他说:“Anaplan就像一个大型模块化计算器,能够处理大量数据。”“它填补了我以前用过的其他工具都无法填补的空白。”

不仅如此;和它一起工作很愉快。他说:“作为一名模型构建者和数据分析师,使用anplan对我来说很有趣。”他的热情在整个英国电信都得到了体现,包括呼叫中心规划、运营支出规划、预测和光纤宽带业务在内的团队都在使用Anaplan,并正在探索如何将计划连接起来,以实现更大的价值。


James Mash, Accounting & Financial Control Manager, BT: Some time ago, a new financial reporting standard was introduced called IFRS 15. It was a complete change to the way we needed to recognize revenue. None of our systems were able to manage this.

\r\n

We initially created a spreadsheet solution to fulfill that standard. This solution would take four full-time employees about six to eight hours on workday one to come to our required number. It was very painful. We needed an all-in-one solution that would get us from receiving our data to being able to create our outputs.

\r\n

The Anaplan solution that we came up with now only requires one person and it can take them as little as an hour to come to that same number.

\r\n

Anaplan so far has been the only tool that we've looked at that would actually be capable of doing what we needed to do. Our original spreadsheet solution couldn't actually retain the history of our data, so we would lose a lot of detail there. Our Anaplan solution currently contains a roundabout 30 million lines of data, and growing.

\r\n

We went from planning the model to having a working solution after roundabout 16 weeks. Going from project life cycles that can last two to three years to something that can take 16 weeks is incredibly valuable to a business like BT.

\r\n

On a personal note, I really enjoy using Anaplan. It's actually quite a fun tool for me as a model builder and a data analyst to use, especially when you're working with large volumes of data. So, it's been really key for us in building efficiencies and allowing us to get to numbers that we weren't able to get to before.

\r\n"}}" id="text-d6aadeaff6" class="cmp-text">

英国电信会计与财务控制经理James Mash:一段时间前,新的财务报告准则IFRS 15被引入。这完全改变了我们确认收入的方式。我们的系统都无法处理这个问题。

我们最初创建了一个电子表格解决方案来满足这个标准。这个解决方案需要四名全职员工每天工作六到八小时才能达到我们所要求的数量。非常痛苦。我们需要一个一体化的解决方案,使我们能够从接收数据到创建输出。

我们现在提出的anplan解决方案只需要一个人,他们只需要一个小时就能得到同样的数字。

到目前为止,anplan是我们研究过的唯一一个能够真正做到我们需要做的事情的工具。我们最初的电子表格解决方案实际上无法保留数据的历史,因此我们会丢失很多细节。我们的Anaplan解决方案目前包含大约3000万行数据,而且还在不断增加。

大约16周后,我们从计划模型到拥有一个可行的解决方案。从持续两到三年的项目生命周期到16周的时间,对BT这样的企业来说是非常有价值的。

就我个人而言,我非常喜欢使用Anaplan。作为一个模型构建者和数据分析师,它实际上是一个非常有趣的工具,特别是当你处理大量数据时。所以,这对我们提高效率非常关键,让我们能够达到以前无法达到的数字。

英国电信
英国电信
Baidu