Hi Derek,
Thanks for the reply.
1. Starting balance is not required. Starting balance would be deposit on transactions section. Without deposit, user cannot add an entry to journals or withdrawal entry to transactions. I couldn't formulate it correctly.
2. No specific reason. Just for SQL queries as I don't know the script for both. It can be one field.
3. Journal entries slightly differ from transactions. However, in essence they both affect to account they belong to as additions or submissions which would make the running balance of the account.
Transaction on Transactions grid will be minimal, while transactions on journal is ongoing on daily basis. Think of journal entries as buying and selling activity, while deposits and withdrawals are providing capital for trading and taking out profit etc from the account.
Please fell free to change anything you see feet.
Adam
God... please help me become the person my dog thinks I am.