"fidelity" report aka When was money deposited

Derek Atkins warlord at MIT.EDU
Mon Feb 28 11:03:59 EST 2011


Hi,

"Andy Den Tandt" <adtlist_qsd at adtsoft.eu> writes:

> Hey,
>
>  
>
> I am looking for a report that for all my savings account displays when
> money was deposited there. A withdrawal reverses the previous deposits up to
> that amount. It's about how the banks calculate the 'fidelity-interest' so I
> want to select the savings account with the least opportunity cost in case
> of a withdrawal.
>
>  
>
> Here is an example. Suppose one account has a history like
>
> Time      Amount
>
> T1           +1000 eur
>
> T2           -100 eur
>
> T3           +500 eur
>
> T4           +200 eur
>
> T5           -100 eur
>
> T6           -400 eur
>
> The current balance is 1100 eur The report I am looking for
>
> Time      Amount
>
> T1           900 eur
>
> T2           200 eur
>
>  
>
> I didn't find an existing report that shows what I need L I also didn't find
> a way to export multiple accounts to CSV for processing elsewhere.
>
> I would appreciate any ideas on how to generate such a report for multiple
> accounts.

Learn scheme and write the report you need.  I'm afraid that's the only
way right now if you want it integrated into GnuCash.  Your other option
would be to use a SQL backend in 2.4.x and then use some SQL-based
reporting.  Or you can try to run a Transaction Report, export it (as
HTML), import that into OOo Calc and then run a report from there.

> Andy

Good Luck,

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-user mailing list