12.7. Expense Entry

 < 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 > 


    Integrating Excel and Access
    Integrating Excel and Access
    ISBN: 0596009739
    EAN: 2147483647
    Year: 2005
    Pages: 132

    Similar book on Amazon

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net