1. Home
  2. Quicken Personal Finance
  3. Doctor Bills

Doctor Bills

This gotta be already forumed to dead, I just can't find it.

I am just starting to deal with a major medical issue and already see that I have lousy insurance. Since my insurance will not be paying the majority or the bills I need a way to track them.

Each visit to the Doctor gives me a seperate statement for the Hospital and a seperate invoice for every doctor the looked in on me.

So a visit may show up as: Hospital Statement: $1000. Dr z $200 Dr x $165 Dr c $125

The Hospital Bill get paid to a Corporation and the Doctors all get paid by sending a check to the "Doctor Associates"

I may alway see Dr z but I might never see the other doctors again. I will be seeing many many doctor over the next few years.

The bills will be paid by my insurance company. I will pay co-pay, I will also pay unapproved procedures and there will be billing adjustments.

I'vee got a lot to track and I am allready finding bills going to collection before they have been properly dealt with by insurance. If I've got my ducks in a row I hope to be able to speak to the Hospital reps, the doc's reps and of course the bill collectors reps.

My question, can I track this with Quicken 2005 Deluxe? Remember, 1 Hospital Bill - Multiple payees Multiple Doctor Bills Multiple payees and my part is paying with one check across multiple bills.

Do I need Premier Home and Business2006 to get the detailed A/P functionality?

Thanks

Reply to
coolmiata
Loading thread data ...

I use a Microsoft spreadsheet to keep a handle on this sort of thing. My problems are compounded by being eligible for Medicare. It sometime takes forever to get all the proper information. Doctors and hospitals are notorious for getting billing, insurances, etc. completely screwed up. I don't pay any bill until I am sure everything has been done properly. I keep everything outstanding in a file folder, separated by event. Be prepared to have a few nasty phone conversations with billing clerks!

Reply to
Centrekid

I also think an Excel spreadsheet would be the way to go. It will give you the ability to automatically create subtotals by date of service ID's (i.e a subtotal at each change in service ID) which is what I think you will want to do. Could be as simple as just 4 columns for ID, date of service, description and $ amount where charges are + and payments by you or insurance company are - so subtotal will show net outstanding for that ID. The ID field is just a number that you assign that uniquely defines a related set of charges, e.g services billed by Dr. X on Date y. Then as activity takes place, e.g. payment by you to a doctor is made just insert a row with the ID corresponding to that Doctor/date of service, paid check # xxx as the description, and $ amount as negative number.

Bob L.

Reply to
Bob L.

Check out Quicken Medical Expense Manager.

Product info:

formatting link
User discussion forum:
formatting link
03

Reply to
Mike B

Two ideas here.

  1. You could do a split transaction for the total bill, each line of the split could be the same category "medical:doctor" but put the name of the doctor in the memo field and their respective amount of the bill.

  1. This would be the same as #1 except creating a class for each doctor and then splitting in that way. This way would allow for better subtotaling/ sorting but your number of classes would grow.

Reply to
Art Matz

Mike, Thanks, I hadn't noticed this before. I will be looking at it closely tonight.

Reply to
coolmiata

Dick Weaver usually has some good things to say on subjects like this. Since he has not spoken up yet, I suggest you search the archives at Google: for starters, search for "medical" and author "Dick Weaver".

Reply to
John Pollard

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.