My plan is to create an Accounting System for small charities using the python language, tkinter and sqlite. I have used gnucash in my own charity: beesanctuarymovement.org and wish to create my own program with features not present in gnucash such as creating a receipts and payments account report, and a statement of assets and liabilities as described in the charity treasurer's handbook. Small charities do not buy or sell on credit; so there is no need for a sales and purchase ledger. They do however need bank/cash transactions to be subdivided by fund.

If you are familiar with gnucash split entry transactions, that is the feature I wish to copy. There is a one to many relationship between journal table which contains information specific to every transaction; and the ledger which has a foreign key Tran_id which refers to the journal.

I wish to create a form which joins the Journal and Ledger tables. The sum of all amounts in the ledger table for all lines which share tran_id should add up to zero ( or equivalently in accounting jargon all credits equal all debits.

My plan is this form (or grid) should display all ledger rows (joined with journal info) for a specific account_id. Clicking on any row in this table should allow you to edit the full transaction in situ.

Sorry if you don't understand the gist of this. It is very hard to explain bookkeeping in an understandable way given the current constraints. The form (grid) should display a running balance of the specified account, and this is not stored in the sql tables, instead it will be calculated by panda and displayed in the sheet.

I have done a lot of research, and I believe combining panda and tksheet is the best way to do what I want.