O'Reilly logo

Building Dashboards with Microsoft Dynamics GP 2016 - Second Edition by Mark Polino, Belinda Allen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Building a balance sheet

The first statement we'll build is a simple balance sheet. The balance sheet is critical because it shows us what the business owns, what it owes, and what it is worth. Our final result should look similar to the following screenshot:

Building a balance sheet

Tip

This is a final reminder that we will use the simplest elements first and adopt some alternate, although still simple, methods to make the reports easier to use and consume as we progress through this chapter.

Let's begin building our balance sheet with some general report information using basic Excel:

  1. Open a blank Excel workbook and save it as FinancialStatements.xlsx.
  2. In cell D3, enter

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required