Setting up a billing database.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to set up a simple billing database which works off a form to
check off medical procedures, which in turn calculates (I assume from a
pricing table) the medical services provided. For example:
Dog1 - was neutered (check) and received a rabies shot (check)
From that information, I'd like a report that can calculate what the cost
was by Dog1 or a total by date.
The number of pricing objects is limited. (about 20).
Any suggestions?
 
Orders Management Database Template:

http://office.microsoft.com/en-us/templates/TC010185481033.aspx?CategoryID=CT011366681033

Has a list of products (procedures), with prices associated with them. Has
a list of customers (clients, pets). Could probably be modified fairly
easily (though you will have to modify queries, forms and reports when you
modify the fields in a table). Under adding/deleting customers, there is a
tab that lets you see a summary of when they have been in, with an order
number for cross-referencing. There are also several reports already
created. It also allows you to put in a discount and sales tax rate.
 
Back
Top