Data Viz Done Right

July 20, 2017

Visualizing a Profit & Loss Statement

18 comments
Following my post over the weekend about visualising an income statement, The Information Lab team suggested I have a go at some other finance statements. Yesterday, my visual P&L statement made it's debut on the Death to Spreadsheets webinar that Eva and I hosted.

In the true Tableau spirit, I'd like to share it with everyone. The overall design is very similar to the Income Statement with a few differences/enhancements:

  • The top section serves as a summary with the idea being to give a quick overview. 
  • The bottom section (below the line) are all of the expense categories, which could obviously change based on what a company tracks. 
  • I included BANs for the latest month and the change to prior month. 
  • There's no budget, so the sparklines simply show the raw values.
  • The mobile version only shows the summary section as I couldn't fit all of the expenses within the 4000 pixel height limit and really, who's going to scroll that far anyway?

For this version, I've put together a "how to read" visual to help explain the visualisation.


Ok, so now that you know how to read the viz, here's the full version. Click on the image for the interactive version (or if you're on mobile you will automatically see the mobile version). Scroll a bit farther down for a gif of the mobile version in action.


VIDEO OF MOBILE VERSION


18 comments :

  1. This couldn't have come at a better time! It's the best version of finance dashboard I've seen out there. If you don't mind, I'd love to incorporate this using our company's data.

    ReplyDelete
    Replies
    1. That's great to hear Nurul! The workbook is available for download. Go for it! Let me know how it goes.

      Delete
  2. Andy this is awesome! Thank you for all you do and for being my go to Tableau person/blog for the past 7 years.

    ReplyDelete
    Replies
    1. My pleasure! I appreciate the kind words.

      Delete
  3. Andy Really Great Work and i downloaded the workbook but not able to Open... :(

    ReplyDelete
    Replies
    1. Make sure you have version 10.3 or newer.

      Delete
  4. Hi Andy. I really appreciate your willingness to help people by faithfully and regularly transmitting your knowledge online. Could you show us how apply all of your presentation if the fiscal year starting month is other that January. For example the fiscal year start in July. It seems like Tableau always thinks that January is the start of the YEAR even thou the beginning of the fiscal year is set up from the Default Property as July. So it is some kind of difficult to have a dynamic comparison of year to data and prior year to date.

    ReplyDelete
    Replies
    1. I'd recommend you search the Forums. Surely someone else has come across this before.

      Delete
  5. Nice Work! This reminds me of the dashboard I made for our Revenue Management Team. Here is a link to it with Dummy data.
    https://public.tableau.com/profile/brents4997#!/vizhome/MultiMeasureKPI/RCMSummary

    ReplyDelete
  6. Good job!! Can u create tutorial about this in youtube??

    ReplyDelete
  7. Andy, could you tell me how to see the data source for this workbook? Did you start from a basic income statement and create a data source to use? I want to build this workbook out with my health center's income statement. Thanks for any input.

    ReplyDelete
    Replies
    1. Cody, you can download the workbook and unzip it and you'll see the Excel worksheet I created.

      Delete
  8. Andy, this viz is great. Please put some financial data for makeover monday. It will be great to see and learn how people visualize financial data eg. financial liquidity

    ReplyDelete
    Replies
    1. Thanks! Find me a crappy viz and the data and we'll get it on the schedule.

      Delete
  9. Andy, thank you for making this available. A quick suggestion: many of the measures you show are more meaningful when shown as a percentage of total revenues. For example, an increase in Cost of Goods Sold (COGS) could be a good thing or a bad thing. If COGS are rising more slowly than revenues are rising (i.e. COGS are taking up less of every dollar sold), that's a good thing. If they're rising faster than revenues, however, that's probably a bad thing. This would be reflected in the change in COGS / Revenues.

    In any case, your dashboard has sparked some interesting thoughts for me. Thank you!
    Ben

    ReplyDelete
    Replies
    1. Good idea Ben. It'd be easy enough to take this and use it as a template and just swap out the metrics.

      Delete
    2. Hi Benjamin, you can add a summary Viz of the percentages of total revenue at the top of phone view. Use a Table calculation for both months (Measure values> percent from > Category > Sales) then add the calculations to Measures , calculate the differences and put them on colors to see which percentage increase/decrease since last month.

      Delete