Sorry to not have updated everyone sooner. We have been hard at work here on a lot of exciting things for iBank. This is going to be my last post about reports so I need to cover my last two topics. The first topic is drilling down through reports to get to more detailed data… and eventually to a transaction that you can edit!

One of the most common things we are asked about the current charts is, “Where did that come from?” With our forthcoming reporting engine we have a great way to answer that: “Click on it and see.” We have greatly enhanced the ability to drill down on the data presented in a report. You can even get back to the actual transactions that made up that piece of the report. From there you can even edit them! Here is an example of an expense pie chart. You can move the mouse over the legend or the pie slices and it will turn into a hand and highlight what it hovers over. In this case I have it over Entertainment (notice that the corresponding slice in the pie chart is also highlighted).

I want to know more about my Entertainment spending because it seems too high. So I click on it, which will then show me a table of all the transactions which contribute to the Entertainment slice of the pie (I have only shown some of them below).

From this table I can see a transaction on 12/13/09 from amazon. That was really a camera that was a gift to my wife, which is not an entertainment expense. So now I can click on that row in the table. and a new window will popup with that transaction selected and ready to edit. I can change the category to Gifts and hit save. The transaction is removed from the table, and when I hit back to get to the pie chart it also reflects the new value. Now why are my Gifts expenses so high…

The second topic that I would like to cover is what new reports will be offered. For the first release with the new reporting engine we are going to offer the following high-level reports:

• Income & Expense – A summary of your income and expenses over a given period of time.
• Net Worth – This will show everything you own minus everything you owe. This will include security values if those
• Portfolio Summary – This is a list of all your security holding on a given date along with gain/loss information.
• Investment Summary – This gives and overview of you investments by asset type and risk. It shows realized and unrealized gains for the selected time period and returns on investment by account.
• Payee Summary – This report will show a list of all the payees for the selected time period and the totals paid to/received from each.
• U.S. Tax – This report will show your income and expenses in your taxable categories along with any investment activity that may be taxable.
• Debit/Liability – This report shows all of your debts, the different time tables to pay them off and some suggested accelerated payment plans.

Now as usual I can’t promise when this will be available. But I can say that we have begun testing this with customers outside the company. Once we work out any issues that they find, we will be going for a more public beta. Expect to hear more about this in my next post.

Thanks,

James

• Author
• Recent Posts

Follow IGG

James Gillespie

Chief Software Architect at IGG Software, Inc.

The head of IGG's technology team, James Gillespie has been a Mac developer for some two decades. He spent much of that time with Intuit, where he created consumer financial software for projects ranging from tax software and mortgage qualification applications to high-volume websites for businesses and consumers. Based in San Diego, James is married, with one son, and the brother of IGG's founder, Ian Gillespie.

Follow IGG

Latest posts by James Gillespie (see all)

• Direct Access 2 and Open Banking Support in the UK and EU - February 17, 2021
• A chunk of sync update - June 27, 2014
• 2013 In Review - December 17, 2013