< Day Day Up > |
Because one of the requirements from the client is to produce income statements, you need to track expenses and put them in general ledger accounts. This means that you need a table to hold general ledger accounts; it would also hold the income accounts used in the services and charges table. Have a form that allows you to put in an effective date, a general ledger account, a description, and an amount. Depending on what the client wants, you might also create asset and liability accounts if they use double-entry accounting. For this project, I would just use income and expense. This section obviously requires some accounting knowledge; look at how this is implemented in the sample database if this section is confusing. |
< Day Day Up > |