The database to store data about personal finances.
The base should allow to track transactions on all accounts.
Similar to Microsoft Money but a much simpler.
I have some accounts. The base should allow to enter each single transaction. For example when I make a transfer from my bank account to pay for a purchased book. The account MYBANKACCOUNT should be decreased and the LITTLEPAYMENTS account should be increased by the price.
I want to have the report about history of each account and all transactions and balance after each transaction.
I want to have teh total raport which can make a raport on any combination of accounts.
(The whole base track all accounts - the accounts of mine and outside accounts as well. I would like to have the ability to select any combination of accounts to track - for exampe all accounts belonging to me - just to track my total amount of money as a summ of all my accounts)
I would like to the base has the ability to track also my investments accounts. I mean stock accounts as well as derivates accounts.
The base should have ability to update the value of my investment at any time just by entering current price of stocks.
Each change of value of stocks should be tracked as a pseudotransaction with a special appreciacion account.
The reports on accounts should be possible to select any time interval. The transactions should have the detailed data information including hour minutes and seconds.
The base should allow to change data already entered and inserting transactions that was made in history (as a correction for example)
Some graphic raports would be nice - for example circle chart representing the amount on each account in any given moment in time.
Also a graph representing changes on the value of account (or any set of accounts) in time. (the same raport as text version but graphical)
In attachment you can see a sketch of the base (which may be used as a starting piont for you when you will be making the base or just as a starting piont to discussion)
In attachment there is also sketch of forms and reports I would like to have.