Running Totals

[twodogron]

:?: Can anyone tell me if there is a way of creating "running totals" in iCash in either Queries or Reports, or do I have to export the Transactions into a Spreadsheet :?:

 

[stanbusk]

What do you mean with "running totals"?

 

[twodogron]

What do you mean with "running totals"?

Normally there would be a Column to the far right hand side of the Register with the "running total' of the entered transactions...... this would normally correspond to the running total on the Paper Statement provided by the Bank.

I have just imported 4251 (QIF) transactions and find that the end balance on the offending Bank Account varies in iCash by minus 69.10.

Without a "running total" column it will probably be necessary to check EVERY transaction from 1 thru to 4251 individually before I can find the offending entry....

Can you suggest a way in iCash where I can create an accurate "running total" of all Transactions please ?

 

[stanbusk]

I recommend you to use the 'Account Statement' report in the report panel. You have a balance/running total on each line. It is what I use to detect errors myself.

 

[twodogron]

Thank you for that suggestion, I must admit I never realised that Report was there, it would have been useful...........

I did get around my problem (before your reply) a couple of days ago by exporting the Account Transactions into an Excel Spreadsheet... I say Excel but I actually use Apple's own "Numbers" spreadsheet which read the export OK.....

One small problem I found when exporting the iCash transactions into a spreadsheet was that the export treated all "transfer" transactions as Positive even though some are obviously Negatives, I had to manually correct these in the Spreadsheet before creating and formulating a Running Balance column......

However, it's no problem now as I've managed to find the offending entry and my Accounts now balance accurately..

Thanks for your reply..