Accounting Application

I am managing a complicated system of accounts and would like to get some advice about how to best organize a coda for these accounts so that individuals can get monthly updates about their accounts.

I am interested in using this because it can automate a lot of monthly emails and potentially save some headache.

How would you structure a coda to operate like an accounting platform with multiple accounts where every month money will go and end out of the account? We are taking out a an administrative fee (a % of money coming in every month) and I want individuals to get an email each month about how much is in the account an how much came out and where it went to.