Build a Profit & Loss dashboard using Google Data Studio & Xero in just 12 minutes!

Xero is one of the most popular and well known accounting applications and for good reason.  It doesn’t cost much plus it’s really easy to use.

It also has a great reporting module that gives you everything you need to see your business finances from all angles.

Well, it almost has everything.

Xero doesn’t have many graphs.  

A Google Data Studio dashboard for Xero P&L

We love graphs.

So we’ve taken this matter into our own hands and built a Google Data Studio dashboard that you can download and use.

The dashboard focuses on your P&L and presents your numbers over time to give you a little bit more visibility on how things are evolving.

This is what it looks like:

 

Now, there’s nothing fancy or too technical here.  The Google Data Studio dashboard is simply reading monthly CSV extracts of the P&L that were exported from Xero.  If you want one of these, scroll down.

Are you sure it took 12 minutes to build?

Yep.

Here the video that Fabricio Cardoso created of how we built this from scratch:

Yeah, we know, we know.  The video is only 9 minutes long.

We sped up the last 3 minutes because it was all about formatting and it was super boring to watch.

Can I have my own version?

Heck yeah!

We’ve built this as a template so that you can download it and make it your own.

Follow these steps and you’ll be up and running in a few minutes:

  1. Download this source data
  2. Click here (https://datastudio.google.com/s/jN0vCfK0vcQ) and make a copy (Do this by clicking the “copy” button in the top right hand corner of the screen)
  3. Log into Xero and export your P&L one month at a time and save them to this folder
  4. Update the Google Data Studio data source
  5. Voila

Note: Adult supervision is recommended

You can use this straight out of the box and it should work well for any Xero P&L.  However, every business is unique and your P&L may be a little different from the one we used.

You should also be able to tackle this with just a little bit of experience in Google Data Studio.

Take me to the next level

Like what you see but you want more?  We understand!  We hear that all the time.

Send us an email or DM me and we can arrange a call to talk through what you need.

Share this post