Why This Chapter Is Here I dithered for some time before deciding to include this chapter in the current edition of this book.Since the time that I first wrote it, in the mid-1990s, accounting software for personal computers has become much more popular in the marketplace.
The various methods discussed there are needed to fill in the current assets section of the balance sheet.
This chapter focuses on recording transactions in journals, cataloging transactions in ledgers, and summarizing the information in the balance sheet.
A dashboard’s visual nature simplifies complex data and provides an at-a-glance view of current status or performance in real time.
Dashboards are made up of tables, charts, gauges, and numbers.
We’ll also share the best practices for researching and building your dashboard, dashboard dos and don’ts, and common questions about dashboards in Excel.
And, you’ll learn about a new kind of dashboard from Smartsheet, called Sights, and how it can help you do your best work.
Following is the basic structure of a balance sheet: The first three chapters of this book introduced some fundamental concepts, such as accounts, revenues, assets, debits, and credits.
They also discussed some of the functional relationships among these concepts.
I like to just have the first worksheet as the presentation layer — let’s name it Dashboard — and the second worksheets as the data layer — let’s call that Data.
(Note: I abhor many, many things about Excel’s default settings, but, to keep the example as familiar as possible, I’m going to leave those alone.
Dashboards give you unprecedented visibility into your work.