How it Works: Accelerate and Automate Reports with ReportWORQ

Replace Manual Reporting Processes with Reliable, Scalable Automation

Use Cases: How It Works for Our Customers

ReportWORQ replaces manual Excel-based reporting processes with automation, making information actionable and accessible enterprise wide. This solution was built specifically to enable finance teams with an easy-to-use, maintainable and supported solution for report distribution. Long gone are the days of unreliable Excel VBA macros and unwieldy scripting languages.

How We Helped Barnardo’s Australia With Report Bursting

Barnardo’s was able to connect all their existing Excel reports to ReportWORQ, saving a lot of time! Reports were filtered by profit center and emailed to 300+ recipients monthly. All aspects of the email message were fully personalized, including signature, logo, and data-driven commentary. Commentary was based on live report data and includes charts and visualizations.

Reports are filtered, summarized, grouped, and zero suppressed without manual manipulation.

Play Video
Play Video

Report Bursting

Use Report Bursting to send out reports in bulk, getting valuable information into the hands of the people who need it quickly. ReportWORQ was built for fast and reliable bulk report distribution. Like a Mail-Merge for Enterprise Reporting, ReportWORQ allows companies to reuse existing Excel reports as templates to be updated and distributed to users at the push of a button or on a scheduled cadence. ReportWORQ places reports where people spend their time, whether that’s Email, Google Sheets, SharePoint, Microsoft Teams, Slack or someplace else.

ReportWORQ Input Forms Collect Data For The Planning Process

“ReportWORQ has been a staple to automate our monthly distributions for Departmental P&L Reports and Accounts Receivable Aging Reports. Now that we’ve added Writeback support to our license, we’re building more efficient automation and workflow into our Latin America planning process. With ReportWORQ we were able to distribute updated planning templates for each region to load contributions back into the system. Previously this process required manual tracking and data entry by a single person. The pilot was a success, and we have big plans to integrate this into our US Sales Planning process next year.”

- A Global Medical Device Manufacturer | ReportWORQ customer since August 2019

Play Video
ReportWORQ-Input-Example-450x315

Input Forms

Planning systems such as Anaplan, IBM Planning Analytics and Workday Adaptive Planning provide feature-rich web-based interfaces for finance users to enter data. However, not every contribution needs to be done directly in the planning system. For example, an existing business process for project managers may involve reporting workforce hours in a Google Sheet or Excel file. While most planning systems provide mechanisms for loading data from databases and files, they lack in the workflow and automation to collect those data sources and execute the load process. This is where ReportWORQ is an ideal solution for organizations who want to collect data from systems and people and automate the bulk uploading of data.

How We Helped AAA Northeast With Briefing Books

ReportWORQ allowed AAA Northeast to simplify their report-build for a complex reporting package, which included Actual vs. Budget and Trend data for over 20 lines of business. Presentation and order of the data were critical requirements and separate report-builds had to be generated for each line of business. What was previously a tedious manual task during the time-crunch of close is now an automated solution which runs every month (and whenever needed) and takes only minutes to produce.

Briefing_Books_Info_img
Play Video

Briefing Books

Briefing Book support simplifies report-builds, reducing the number of reports needed and distributing them more quickly. ReportWORQ will refresh, combine and collate many reports into a single complex briefing book or executive summary packet to help prepare documents for financial close, board presentations and financial review.

How We Helped a Financial Technology Customer Publish a Weekly Newsletter

With ReportWORQ’s vast data source support, newsletters can also include data outside of the planning system, such as headcount, accounts receivable, and sales highlights. You can effortlessly organize charts and visuals, as well as data-driven commentary to produce an easy-to-read dashboard right in the body of a scheduled email message.

"ReportWORQ helped us identify and solve a new reporting challenge: How do you ensure the most relevant information makes it to your stakeholder and doesn’t get lost in the noise of nightly systematic emails? We partnered with the ReportWORQ team to expand and create highly curated, dynamic daily newsletters which summarized the key operating metrics for our leadership team, including sales volume, revenue, profitability and even headcount metrics. The flexibility of using Excel while maintaining a professional look of an HTML-based email is extremely powerful and has transformed our team!"

- An international financial tech company

How We Help Customers Create PowerPoint Board Presentations

Play Video

During any executive leadership discussion, presentation material that provides a summarized format of the briefing book is a must. ReportWORQ refreshes data and updates embedded text, charts, and screenshots throughout your presentation template. Products that enable users to embed or link workbooks, such as PowerPoint, fall short of the needs that Finance users require to be efficient, accurate and reliable. With ReportWORQ you don’t have to worry about embedded confidential data or volatile links that could easily break when moving documents.

 

This powerful mechanism enables you to combine the best features of Excel, PowerPoint, your planning system, and external data sources to automate the creation and distribution of accurate and compelling PowerPoint Board presentations.

Where does the data come from?

ReportWORQ provides native, out-of-the box support with tight integration for data sources.

IBM Planning Analytics (PAfE)

ReportWORQ‘s rich and native support for IBM Planning Analytics (on-premise or cloud) means you can reuse your existing Perspectives & PAfE reports right out the box and leverage powerful native features such as dynamic reports, MDX, alternate hierarchies and attributes.

 

SQL ODBC Support

ReportWORQ integrates with any SQL-based ODBC or OLEDB provider such as Microsoft SQL Server, DB2 or even other Excel files. This game-changing feature means you can easily attach transactional or drill data from external systems along with a planning report, enabling business users to see a full picture. Writeback support to SQL-based sources also opens a myriad of use cases for collecting commentary and adjustments.

 

Anaplan

The Anaplan Excel Add-in makes it easy to extract data to Microsoft Excel for formatting and reporting. ReportWORQ enhances this experience by allowing you to adjust filters, sort and suppress data and then bring visualizations and commentary about this data directly into an email message for delivery.

 

Workday Adaptive Planning

ReportWORQ supports Workday Adaptive Planning OfficeConnect reports out-of-the-box and enables you to automate several elements of the report and to build reporting templates for consistent delivery across the business. ReportWORQ’s integration allows you to easily automate relative time periods, filters and leverage attributes. Beyond OfficeConnect, ReportWORQ also allows you to sort and filter reports, create matrix reports, report on modeled data and create Input Forms so that users can contribute updates directly in Excel files.

 

What Does ReportWORQ Integrate With?

ReportWORQ integrates with other systems that you use for report distribution and automating jobs.

Distribution

Email

Email

Google Sheets

Google Sheets

SharePoint

SharePoint

Slack

Slack

Teams

Teams

Network File System

Network File System

Google Drive & Cloud File Services

Google Drive & Cloud File Services

Automation

Workato

Workato

Email Input Forms

Email Input Forms

IBM Turbo Integrator (TI)

IBM Turbo Integrator (TI)

REST API

REST API

Interested in the technical details about these integrations? Contact us

Take Advantage of a Free Trial and Demo of ReportWORQ

Try out ReportWORQ for 30 days through a no-obligation free trial. All participants receive a demonstration and full customer support during the trial.