Posts

Profit & Loss Report with Links to Supporting Sub-ledger Reports Example

What is a Profit & Loss Report with Links to Supporting Sub-ledger Reports?

Financial statements with links to sub-ledger reports are considered self-service analysis reports and are often used by managers and accountants to provide users with easy answers to their questions. Some of the key functionality in this type of report is that it allows the user to click on the hyperlinked account numbers seen in the first column. These links will open a different report that provides granular details about the figure seen in the financial statement. Examples of such reports can be a sales report explaining a revenue figure or an accounts payable report explaining the details behind an expense figure. You find an example of this type of report below.

Purpose of Profit & Loss Reports with Links to Supporting Sub-ledger Reports

Companies and organizations use Profit & Loss Reports with Links to Supporting Sub-ledger Reports to give their users direct drill-down to detailed sub-ledger transactions to answer their questions. When used as part of good business practices in a Financial Planning & Analysis (FP&A) Department, a company can improve its speed of decision-making as well as reduce the chances that managers have to contantly ask accountants to go back to the ERP system to explain figures in financial statements.

Profit & Loss Reports with Links to Supporting Sub-ledger Report Example

Here is an example of a Profit & Loss Report with hyperlinks to underlying sub-ledger transaction reports.

Profit & Loss Report with Links to Supporting Sub-ledger Reports Example

Profit & Loss Report with Links to Supporting Sub-ledger Reports Example

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: Executives, Department Heads and Financial Managers.

Other Reports Often Used in Conjunction with Profit & Loss Reports with Links to Supporting Sub-ledger Reports

Progressive Financial Planning & Analysis (FP&A) Departments sometimes use several different Profit & Loss Reports with Links to Supporting Sub-ledger Reports, along with balance sheets, cash flow reports, transaction analysis reports and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

financial planning analysis blog

The rapid growth of Microsoft’s Dynamics 365 Business Central (D365 BC) cloud ERP system comes with investments in add-on app solutions by independent software vendors (ISVs)For example, Progressus is a company as described above and has a project solution for D365 BC. With Progressus, small and mid-sized companies receive easy-to-configure and advanced project accounting functionality in the cloud. 

However, as all project-centric business managers know, good transactional systems also need proper financial planning and analysis tools. In today’s highly competitive market, this can be the difference between success and failure.  As successful project-based companies invest in new cloud-based ERP systems like D365 BC and add advanced project apps like Progressus, a natural next step after the implementation is to look for an integrated and flexible reporting and planning solutionA reporting and planning software like Solver can operate down to the detailed field and dimension level in the Progressus tables inside the ERP system.  

Project Reports for D365 and the Progressus App

Lately, most companies prefer pre-integrated solutions. Due to this, Solver partnered with Progressus and now the corporate performance management solution delivers an out-of-the box integration to both Dynamics 365 Business Central and Progressus. Solver not only provides D365 BC customers with a strong financial reporting and budgeting software for general ledger and sub-ledger data, but it also now extends this functionality into all the project detail provided by Progressus. 

Customer Benefits:

  • Pre-built integration to Dynamics 365 and Progressus tables
  • Pre-built Progressus Project reports
  • Full report writer with Excel design
  • Optional Budgeting module
  • Multi-tenant Azure Cloud Platform
  • Pre-built Power BI integration for interactive Dashboards

However, as with any reporting solution, pre-built report templates speed up deployment when can be used as a starting point. 

Solver offers a number of project-focused reports for Progressus including:  

  • Benchmarking
  • Project Manager Benchmarking
  • Project Capacity by
    • Customer Group and Resource
    • Department and Resource
    • Customer Group and Resource
  • Project Detail by Customer
  • Project List
  • Resource Detail
  • Actual vs Budget Variance

 

project capacity

project 2

Both solutions are independently integrated to Microsoft Dynamics 365 Business Central. After the partnership between the two companies, they decided to configure a joint integration. With the rapid growth in popularity of cloud ERP software like D365 BC, one of the next big cloud drivers is that ISVs, such as Progressus and Solver, work together to give customers elegant integrations across both standard ERP data as well as transactions originating from ISV add-ins to the ERP systems. This eliminates many of the custom integrations that are configured in the old on-premise platforms.

Technology is driving major industry changes into the next decade. Project managers and executives will need and demand complete insight to their data to drive faster and better decisions. Cloud-based ERP vendors and ISVs are making good strides to make this happen!

Payroll-Now-Blog-Picture-1200×675
award-best-work-la-2019

This article focuses on the future of Dynamics GP Users and their Reporting and Budgeting tools.

Photo taken from Shutterstock.

Photo taken from Shutterstock.

Why are many companies still keeping their Dynamics GP ERP system on-premise when there is a cloud option available? Some may not know the options to migrate to the cloud. Others may feel safer using a more traditional platform. Microsoft just changed the whole game for Microsoft Dynamics Enterprise Resource Planning (ERP) users. A true cloud version of Microsoft Dynamics, Microsoft Dynamics 365, officially released this November 1st. Dynamics 365 lets companies combine CRM, ERP and Microsoft Office capabilities into the next generation of business applications in the cloud. This Azure-hosted Dynamics service seems to be the true future for many Dynamics GP customers. Therefore, if your company is slowly making its way to the cloud, and on premise tools are most likely developed less progressively, eventually moving to Dynamics 365 or other CRM/ERP tools seems a pretty interesting alternative. This article focuses on the steps your company will need to take when your ERP is moving to the cloud.
Read more

This article will discuss financial report writers in today’s marketplace for manufacturing organizations looking to expand their SAP Business One experience.

 
ManufacturingReporting_PLHave you used a Fitbit before to track your fitness activity, diet and sleep? If you have specific fitness goals to be healthier and the Fitbit carries all the features and functionalities you need, this tracker is perfect because it describes in detail an event, situation or occurrence. Similarly, a financial report writer collects and presents financial data so that it can be analyzed. Reporting is the necessary prerequisite of analysis. Reporting makes data understandable and ready for accurate and efficient analysis so you can better reach your company goals. This article will discuss your options for features and functionalities that third party solutions are offering for your SAP Business One (SAP B1) system, specifically zooming in on data management and analysis in manufacturing companies.
Read more

This article discusses the modern, dynamic, and business user friendly financial reporting options available for Healthcare organizations using Sage 100.

It has been a while since I have blogged, and in that time, I have had several great opportunities to talk to finance and accounting professionals, as well as executives, about their Business Intelligence (BI) and Corporate Performance Management (CPM) needs.  Some of these conversations happened at BI360 Focus 2016, some of these manifested as one-off conversations, and one even occurred on a flight to Portland.  Lately though, it seems like I have not only been in conversation with more healthcare professionals, but I’ve also found myself personally and professionally curious about this industry.  The healthcare industry seems to be one of the most complex and regulated sectors – and for good reason obviously, but the effect it has on financial reporting requires sophisticated, yet business user friendly BI tools.  The best financial reporting tools for Sage 100 users offer Healthcare-specific data management that produces the necessary financial reporting and/or dashboards.
This blog article will focus on modern financial reporting with Sage 100.  I’ll first discuss the bigger picture of what you should be looking for to achieve your financial reporting and analytical objectives.  Then, I’ll zoom in on the financial reporting modules delivered by certain, more dynamic products that can enable Healthcare organizations to produce traditional financial statements, meet regulations, and present information to key stakeholders and decision-makers.
Read more

This article focuses on finding an improved solution for a bad software implementation.

Photo taken from Pixabay.

Photo taken from Pixabay.

We all wish for a successful software implementation, but information system projects frequently fall short or even fail. Many software implementations can be challenging, and only a few companies today achieve highly successful software implementations on their first try. Usually, the reason for failure or a bad budget implementation has little to do with the actual software itself. In this article, we will explore the seventh installment of our budget series: how to fix a bad budget software implementation.
Read more

This article focuses on best practices to improve your budget process.

budget better
Think about all of the time and energy your company allocates to budgeting. Managers often scramble to collect financial data from multiple sources in consistent formats. Rather than aiding the process as they should, differing technology tools only add to the manual process. I feel incredibly overwhelmed just thinking about it, but these 12 best practices have helped immensely. This article will explore 12 best practices anyone can implement to improve the quality of his/her budget to stay on track now and into the future.
Read more

This article will explore financial reporting features and functionalities in today’s solutions for manufacturing organizations looking to expand their Sage 100 experience.

manufacturingforsage100reporting

In today’s business world, Business Intelligence (BI) and analytics are becoming the modern way of turning valuable company data into rich decision-making for a company’s future. Navigating through BI is much like maneuvering through the wilderness without a map or a compass. It can get overwhelming, but I’m here to help. This article will focus on what users should know about in modern reporting solutions to improve your Sage 100 experience, specifically zooming in on manufacturing data management and analysis.
Read more