"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