Submitted by viking on 2019/03/12 16:30
I am thinking about trying to replace Quicken with IQ to keep track of transactions in a few Bank accounts. Has anyone attempted to do this?

I would have one Grid for each account and a Summary Grid showing the current balance in each account. The account Grids would have the transactions sorted by date and I need to automatically have IQ calculate a running total of the transactions and display in a balance column.

One of the issues is how to automatically create a running Total in each account. It is trivial in Excel, but in IQ there is no way to know the item ID of the previous item (i.e. the item with an earlier or same date). Has anyone created a Grid with an automatically calculated running total?

Another issue is how to capture the last transaction of each account to put that on the summary page (Grid). Anyone have any ideas?
 

Comments

Hi Viking !
 
Welcome back !!
 
I would create a grid to enter the transactions (either manually or imported from your bank account web site)
  1. The basic information would be shown as columns: Description, date, amount, transaction type, account, etc
  2. Create an External Link file (Grid > ODC file). You'll be prompted to make the grid visible to other apps. Click Yes
  3. Open Excel and open the ODC file you created (it will be in the same folder as your IQBase)
  4. Add a column for the Balance and enter the proper equation
  5. Save the Excel file
The link is live, so any change in the IQBase will be visible to Excel. Right-click on the Excel table and select Refresh to retrieve the updated IQBase data
 
In Excel, you can create additional pages and to show a Pivot table / chart to summarize data if you want. You just need to leave the IQ table area clear, as the sync will overwrite these cells (as data grows)
 
 
HTH !
 
Pierre_Admin
IQ Designer