I am trying to write a small accounting application. So, could you suggest a way to save entries so that it will be easy to get reports...
At present, I am creating a debitside table and a creditside table for each personal account, real account,and nominal accounts, then entering the debit side account name in the creditside table and the credit side accout name in the debit side table. And, I save the tablenames (account names) in a table and then calculate the total of each account via while loop and then display the balance. The problem occurs when there are multiple debits/credits in a posting.
Am I doing correctly...Is there a better way to saving the posting?