Hi, Lisa.

Keeping track of invoices for your customers is a straightforward database design. Basically, you need two tables:
- The invoice table that contains the invoice Basic information, Date, Customer, Delivery Address, notes, etc.
- The second table is the Invoice Detail table. Which will contain line items of the invoice. It will have information like what invoice it belongs to, quantity, description, price, etc.

Can you elaborate on what you mean by runing balance of available funds?

I like this topic please keep me in the loop.   I do Govt contracts as COR and I have some understanding.  Do you track individual line items by cost or are you looking to at the peroid of performance?  Most of mine are firm fix price so I just count the invoice and dedut from total cost of the contract till its gone or time limit is done.  I can talk on this but I used Ricks ABCD and mod it to meet my needs as this aslo has a document organizer in which you can add docs and have them moved to a folder and on aclick of a button open a selected file.   Save me hours of looking for things in my HD.   I recomend the ABCD