Setting up a billing database.

C

Charlie

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

mnature

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top