There’s always more you can do with ReportWORQ. Once that initial monthly board book or daily flash report becomes automated our customers find many more opportunities for ReportWORQ to empower finance and business teams.
I needed to send 270 individual P&L reports to over 40 recipients. My challenge was to provide not only individual reports, but also summarized reports by entity, supporting transactional detail, as well as commentary on action items based on analysis of the data. ReportWORQ helped me take this chore from 5 days to just 10 minutes!! Honestly, it’s that good.
– Director of FP&A – Barnardo’s, Children’s Charity
Key features that made this possible:
- Existing Excel reports were connected to ReportWORQ, nothing new had to be created.
- All aspects of the email message were made to look personal and proper, including signature, logo and commentary.
- Commentary was based on report data and included charts and visualizations.
- Reports were filtered, summarized, grouped and zero suppressed without manual manipulation.
- ReportWORQ satisfied a key requirement which was to include supporting transactional data along with the P&L
Implementing ReportWORQ allowed me to leverage my personal Excel experience to build a reporting process that is reliable and easily maintainable.
P&L DIST VIDEO
EXAMPLE EMAIL MESSAGE
EXAMPLE P&L REPORT
AAA Northeast reduced their time to close using ReportWORQ
ReportWORQ allowed AAA Northeast to automate the build of a complex packet of reports which included Actual vs. Budget and Trend data for 50 lines of business. The presentation and ordering of the data was critical to meet the needs of the President and Executive Vice Presidents that rely on this format. The challenge for AAA Northeast was that a simple request such as a single Journal Entry would result in an entire day of rebuilding the reporting packets. With ReportWORQ, AAA Northeast can now iterate through data adjustments without the lag time which has been a contributing factor in reducing the number of days to close.
Hear how ReportWORQ enables our many Insurance clients
On a monthly basis, our team creates a 50-to-200-page financial briefing book for internal consumption by the executive team. The purpose is to highlight movements between actual, forecast, budget and ratios as well as high level commentary to the changes; allowing the executive staff to make informed decisions when managing the business. The report structure is very much constant with the data being the variable. With ReportWORQ, turnaround time for this deliverable has decreased considerably. Key to this success is the ability to make changes to the underlying data without having to recreate the document.
– Director, Financial Technology Team & ReportWORQ customer since 2016
INFOGRAPH BRIEFING BOOK
AAA CASE STUDY + VIDEO
Financial statements are notoriously difficult to read. However, what other instrument can be used to share critical financial data with the business side of the company? How about a financial Newsletter!
For recipients who are not P&L savvy, ReportWORQ enables you to produce critical financial highlights which can be shared easily via a distributed newsletter. Effortlessly include charts and visuals, as well as automated commentary based on formulas identifying key callouts. No longer are you dependent on the recipient opening the attachment, this information can be shared via email, PDF, and collaboration worksites such as Microsoft TEAMS and Slack. Given how automated this process is, communication can be done monthly, weekly, or even daily.
In addition to briefing books, which are used for either regulatory or managerial reporting and can range anywhere from 50 to 200 pages, there is a need to summarize data into a presentation format. During any executive leadership discussion, presentation material providing a summarized format of the briefing book is a must. Products such as PowerPoint enable the user to embed or link workbooks, but this is not always the most efficient process. You do not necessarily want to share the entire workbook, nor worry about links which could easily break when moving documents. Furthermore, if using the copy/paste option, minor changes to data could result in major rework.
ReportWORQ is your personal robot for copy/pasting data from Excel files to PowerPoint
- Source data, individual words, screenshots, and charts from multiple Excel reports
- Use replaceable variables in the PowerPoint slides to automate commentary
- Formatting is applied in the presentation, where data comes from the Excel reports.
- Autogenerate multiple presentation files based on a different business entities
- Utilize all your Excel skills without fragile linked or embedded files
Face it, not every contributor belongs in your Planning Analytics or Adaptive systems. There are many scenarios where you have a large number of users who need to enter a small amount of data. For example, there are those 600 R&D project managers who need to report workforce hours or the East Coast sales group who just need to enter a few quick numbers via Google Doc while on the road. Why deal with supporting user account permissions or supplying specialized training?
The Writeback license is a perfect conduit for sending files, receiving files back and loading the data. There is no manual compilation of spreadsheets, it is fully automated. The input form is dynamic based on data, and easily maintainable. Spreadsheet formulas are locked, so no need to worry about failing macros. The process can run as a Windows Service, allowing you to run this from a Rest API, TI process or chore, or you can schedule within ReportWORQ . And finally, ReportWORQ provides an easy-to-read screen showing history returned input forms, load status as well as a downloadable log.