SkyREPORT tackles repetitive tasks across Toyota’s treasury operations

3 June 2013

Toyota Financial Services (TFS) runs Wallstreet Suite v7.1 within its North American treasury and manages unsecured long and short-term debt issuance for the region in all major currencies. The on-going challenge for Michael Valmidiano, TFS’ treasury systems and project manager, and his team is to ensure treasury has accurate, up-to-date data whenever it needs it, however it needs it.

Today they are using SkyREPORT, the advanced financial reporting, fully automated testing, reconciliation and integration platform from SkySparc, to automate some key tasks, saving time and increasing the accuracy and quality of handling detailed data changes. “We originally took SkyREPORT for its reporting capabilities, but the functionality has developed so much since then,” comments Valmidiano. “It’s really changing the way we look at tasks and adding huge value for us.”

“When we introduced a Commercial Paper program for a Canadian subsidiary, we used SkyREPORT to automatically load some 200 transactions – it was fast, but also more reliable and more systematic than manual loading. And we also used SkyREPORT to test the data,” explains Valmidiano. This success encouraged Valmidiano to tackle other repetitive and resource-intensive tasks within his team. SkySparc Professional Services configured SkyREPORT to automate some key deliverables: loading and testing of static data for asset-backed securities; uploading fixing quotes to Wallstreet Suite for amortizing swaps and bond transactions and automating the migration and testing of new treasury products from the test to the production environment.

TFS can now run key repetitive processes automatically, without manual work. Specialist treasury staff no longer need to spend time mapping the data for each process on every occasion. Valmidiano estimates the department is already saving considerable time by using SkyREPORT for these new tasks, and he expects much greater savings in the future, when more activities are automated. Also, by automating the tasks, the types of errors that occur as a result of repetitive, manual data loading are eliminated, improving the overall quality of data and associated business process.

“SkyREPORT is adding considerable value through saving time and valuable treasury resource, and also by improving the reliability and accuracy of repetitive data processing,” he says. “I’m really impressed with the way SkySparc has developed SkyREPORT; it’s a really valuable tool, and we’re just at the beginning of what it can do for us.”

Become a bobsguide member to access the following

1. Unrestricted access to bobsguide
2. Send a proposal request
3. Insights delivered daily to your inbox
4. Career development