Menu

Blog

Versatile Tableau #2: Can you use Tableau to re-create your bank statements?

For some strange reason, I am (or was, they changed it now) not allowed to download the bank statements for my saving account. Because of some super-secret stuff, I can’t reveal here, I did need them. So, my question is, “can Tableau re-create my bank statements and fool the government? **Evil laugh**”.

So, what does it look like on the website of my bank?Bank statements

Pretty straight forward, right? In the top you can select your account, you see the current balance, and the rest of the page shows an overview of all the transactions.

Let’s re-create.

First step, data! Fortunately, I can download all the transactions in a comma separated file. The website even keeps track on which transactions have been downloaded already and which not. This means I only get the delta…perfect. This dataset, however, does not contain headers, so I need to assign the right labels to the right columns. But once that is done, I’m good to go.

Let’s connect Tableau to the file. First, I create the transactions overview. Again, this is pretty straight forward, as the labels are already correct. Just drag in, date, counter account, description, and amount. The result looks like this.
First view

Notice that the amount is always positive. It is necessary to create a calculation based on Debit/Credit to multiply the amount by -1 when it’s “Debit” to make sure is all adds up correctly.Amount calculation

Also, I noticed the date is not repeated every transaction. To repeat the date, just create an index() calculation, add it as the first column, and hide it. You can also use that same index() calculation on the filter shelve to show, for example, the last 20 transactions. Format the rest of the columns, and look at the result.Formatted view

Almost there, just need to add the ‘Debit’ and ‘Credit’ images to the view. Add ‘D/C’ to shapes, assign the correct shapes, and the transactions list is (almost) identical to the one on the website.

To show total balance, add a new worksheet with only the amount on there. Make sure you use the calculated one because else, there will be a really high balance. Filter on the bank account and, again, format it. Done and ready to put the dashboard together.

The end-result

Time to think about the end result. The base layout of the dashboard will probably look something like this.Dashboard layout

Now let’s put it all together, and re-create the bank statement. Use layout containers, they make building Tableau dashboards a lot easier. Show the title, change if necessary, and format. Add the total balance view, and show the account filter on the dashboard (make sure to set it to filter all sheets), and format. Add transaction sheet, and done! The final result in Tableau looks like this.Final dashboard

So, can you use Tableau for your Bank statements? My verdict: YES!

Leave a Reply

Your email address will not be published. Required fields are marked *