Business dashboard template: BANK CASH FLOW (TRX)

dashboard template for tableau on Corporate Finance Cash Flow Bank Cash Flow (Trx) cockpit

Providea workbookcontaining at least7 attributes

Geta ready-to-use,best-in-marketBANK CASH FLOW (TRX) dashboard

Bank Cash Flow (Trx) Home

Get a Home Page for your Bank Cash Flow (Trx) dashboard

Bank Cash Flow Cockpit

Get a quick overview of your bank accounts cash flow

Cash Flow & Balance

Visually assess the impact of your cash flow on your final balance

Transactions details

Get an overview of your Debit and Credit Amounts by Transaction Type and analyze your data at transaction level of detail

7 required attributes

Bank
Account #
Transaction #
Transaction Date
Transaction Type
Credit Amount
Debit Amount
...add your own attributes!

11 KPIs

4 dashboard pages

Required Attributes

To get your Bank Cash Flow (Trx) dashboard, you need to provide a Tableau workbook file with (at least) the following 5 attributes (the name of your attributes can differ):

Bank Name of the Bank
Account # Account Number
Transaction # Transaction Unique Identifier
Transaction Date Date of the transaction (Date used for time-series analysis)
Transaction Type Type of the transaction
Credit Amount Credit Amount [positive values expected; Null expected if Debit Transaction]
Debit Amount Debit Amount [positive values expected; Null expected if Credit Transaction]

KPIs

Your Bank Cash Flow (Trx) dashboard will contain 11 KPIs

Cash Flow"Total Debit Amount" minus "Total Credit Amount"
Total DebitTotal amount of Debit Transactions
Total CreditTotal amount of Credit Transactions
Daily Cash FlowAverage Cash Flow per day"
Daily DebitAverage Debit Amount per day"
Daily CreditAverage Credit Amount per day"
Avg Debit TransactionAverage amount of Debit Transactions
Avg Credit TransactionAverage amount of Credit Transactions
TransactionsNumber of Transactions
Debit TransactionsNumber of Debit Transactions
Credit TransactionsNumber of Credit Transactions

Dashboard Pages & Data Visualizations

Your Bank Cash Flow (Trx) dashboard will contain 4 pages

Home

Bank Cash Flow (Trx) Home

Get a Home Page for your Bank Cash Flow (Trx) dashboard

Cockpit

Bank Cash Flow Cockpit

Get a quick overview of your bank accounts cash flow

Cash Flow Analytics

Cash Flow & Balance

Visually assess the impact of your cash flow on your final balance

Transactions details

Get an overview of your Debit and Credit Amounts by Transaction Type and analyze your data at transaction level of detail

Creating your BANK CASH FLOW (TRX) dashboard Step-by-Step

You want to get a clear understanding on your Bank Cash Flow (Trx) results? You want to build a Tableau dashboard to better understand your Bank Cash Flow (Trx) data?

Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Bank Cash Flow (Trx) data in less than 5 minutes!

Bank Cash Flow (Trx) dashboard Live Demo

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your Bank Cash Flow (Trx) data (whether it comes from: ERP, database, Excel, CSV file...)

You must retrieve at least the following attributes (it is ok if the names don't match, and it is better to add additional attributes to analyze):

Bank Name of the Bank
Account # Account Number
Transaction # Transaction Unique Identifier
Transaction Date Date of the transaction (Date used for time-series analysis)
Transaction Type Type of the transaction
Credit Amount Credit Amount [positive values expected; Null expected if Debit Transaction]
Debit Amount Debit Amount [positive values expected; Null expected if Credit Transaction]

2nd STEP: Upload your Tableau workbook file

On LinPack-for-Tableau.com, select 'create dashboard from template: Bank Cash Flow (Trx)' and upload your Tableau workbook (note: your data is NOT uploaded).

Collapse All Expand All