It may be possible. Could you please provide a packaged workbook with some sample data and an idea of the exact format that you're looking for?
Find attached the excel data that i need to use.
1. CT2 -> This is our accounting entries at ERP system.
2. Balance_Sheet_model -> This is the final report that ERP provides for analytical reviews.
If you need more informations, please contact me.
I am unable to open your ct2.xlsx file, but i saw balance_sheet_model.xlsx. With Tableau you can achieve these reports very easily. If these fields are already available then with just some drag & drop you can create the reports. If these fields are coming with some calculations then with Tableau calculated field option, you can achieve the same. You can learn more about Tableau from here: http://kb.tableausoftware.com/
I have checked your data. Yes this is doable with some calculations. You are developing it by yourself or looking for someone to develop this for you? If you want to learn Tableau go through this link Knowledge Base | Tableau Software
If you will face any problem, let us know.
If you are looking for someone to develop this for you, you can contact me at email@example.com
I'm developing this by myself. I'm a accountant consultant and it will be very helpful for my analysis. I would like some help in order to start this workbook.
Do you have some idea ? I'm using Tableau for 1 month yet, and don't have to much experience with Tableau yet.
If you can help with some tips, i will be very thankful.
This is a grouping exercise, ie you need to group the accounts first (I believe 'Cta' in your file) the way the balance sheet groups them.
You can do this with a vlookup in Excel or in Tableau doing
- put 'cta' in the Rows shelf
- select a few items
- right click and select group
My preference is doing it at the source data, that way you can use the source data in another tableau file if needed
When you have done this, please upload the file in this forum with these groupings done so that we can continue, and I can help you to achieve your goal
Then you will encounter some issues with the credit positions (they will show negative). The balance sheet does not usually show negatives. You will need to show one column called say 'Amount' (Debit - Credit)
Remember, all the profit and loss accounts need to be grouped in the 'Retained Earnings' section in the balance sheet
See you soon and keep questions coming
1 of 1 people found this helpful
Just a word of warning to the folks here...I've worked with a couple of balance sheets and have talked with a couple of other hardcore Tableau users about them, and balance sheets can be really hard to get right in Tableau and maintain on an ongoing basis. They can start out sort of simple, but then when you start getting into business rules and alternative forms of viewing things can get really painful.
Here are the issues that I've observed:
- On the data end, sometimes the underlying data has no timestamps or sequential identifiers and is dependent on the actuall order of the data. The data source and Tableau will (according to their internal logic) re-order that data, making it hard to maintain a proper order for the data when it lacks anything to sort by.
- Any solution is going to require table calculations in order to carry balances from one row (a balance entry) to the next. The results of table calculations are dynamically computed every time someone opens the viz, which has a number of impacts.
* The addressing and partitioning of table calculations is dependent on the dimensions in the view. Every time someone is building a new view, they have to make sure they get the addressing and partitioning right to end up with accurate balances, and it's really easy to mess those up.
* The sort issue doesn't end with the data, the table calculations need to have the correct sort order set up every time as well to return accurate results.
* In order to maintain balances from a start point, you have to make sure your data has that start point in it and it doesn't get filtered out in some way. In larger cases this can cause performance issues because Tableau has to bring in thousands and thousands of records to have enough data to compute a prior balance to get a current balance.
* There may be business rules about how/when overall balances are computed (like intraday, end of day, end of month balances) that require additional dimensions to be part of the partitioning and that can make the table calculations even more complex.
All of this is not to say "It can't be done." nor "Don't do it", I'm just trying to sound a note of caution that this may be more work than you may think.
Would you mind to post any sample of a Balance Sheet / Income Statement / Cash flow statement ?
I am a newbie, and I am struggling with the balance sheet as well . . . perhaps for different reasons. I have a mock balance sheet report that I have formatted, and I am trying to calculate simple ratios for practice. For example, Assets / Liabilities. My goal is to save these as KPI's, but I am stuck. I cannot get to the level where I can SUM the Assets (fall under Class in Dimensions) and SUM the Liabilities (also under Class in Dimensions). I have attached an excel file for your review (if you are willing to take a look). I just need a nudge in the right direction. Is this an LOD issue? Am I just missing something super basic?
I could not find any attachment.
I got it figured out. Thank you for responding.
The problem was not in formatting the data, but in setting up dimensions. A IIF table calculation was created to separate out assets from liabilities and then new measures were made (the same way basically) to create ratios.