cancel
Showing results for 
Search instead for 
Did you mean: 
lindsay3
Level 1

What are the steps to record an insurance payment paid on behalf of a patient to a medical provider. How do I specify that the payment came from an insurance company?

What about for checks or direct deposits received from specific insurance companies or government payors on behalf of patients/beneficiaries... the QBO user (a Single Member LLC medical provider) clicks on the "Receive Payment" within he specific customer invoice (while selecting either Check or Direct Deposit which usually goes to A/R), is there a way to attributes that payment to an A/R account that is created called Blue Cross Insurance Claim Account or Medicare Claim Account?  I'm not sure how to properly properly account for the transaction or whether it can even be done, but I hope someone from QBO can advise (step by step) what the correct way is.  Also, what if a medical provider bills $90 per service, the patient pays a $10 copay and the insurance pays $78.53. Because the contract rate is $88.53, how do you clear the remaining $1.47 so that you can satisfy/show the invoice as paid?   


Solved
Best answer October 19, 2018

Best Answers
Rustler
Level 15

What are the steps to record an insurance payment paid on behalf of a patient to a medical provider. How do I specify that the payment came from an insurance company?

You can create new a/r accounts, but for some reason QBO will not allow you to use them --obviously a disconnect here during development

QB is really not designed for medical billing, medical billing software would be a good investment long term

The write off between billed and approved should to be handled by a credit memo, create a non inventory item which posts to a sales income discount account, and use that on a credit memo.  In receive payments, apply the credit memo to the invoice and receive the payment

QB operates on the customer level, the concept of multiple customers (patient, primary ins, secondary ins) paying one invoice is hard to track.  QB does not care who pays a part of an invoice, but for medical billing you need to know who paid what when and for who, and you can not track that in QBO.  Class or location can not be used for payments, nor can an item..

View solution in original post

14 Comments 14
Rustler
Level 15

What are the steps to record an insurance payment paid on behalf of a patient to a medical provider. How do I specify that the payment came from an insurance company?

You can create new a/r accounts, but for some reason QBO will not allow you to use them --obviously a disconnect here during development

QB is really not designed for medical billing, medical billing software would be a good investment long term

The write off between billed and approved should to be handled by a credit memo, create a non inventory item which posts to a sales income discount account, and use that on a credit memo.  In receive payments, apply the credit memo to the invoice and receive the payment

QB operates on the customer level, the concept of multiple customers (patient, primary ins, secondary ins) paying one invoice is hard to track.  QB does not care who pays a part of an invoice, but for medical billing you need to know who paid what when and for who, and you can not track that in QBO.  Class or location can not be used for payments, nor can an item..

lindsay3
Level 1

What are the steps to record an insurance payment paid on behalf of a patient to a medical provider. How do I specify that the payment came from an insurance company?

Rustler- Thanks for your response.  In terms of QuickBooks Online Plus, I'm reading there is a way to use "class tracking" to categorize any transaction with an additional field (that this could be used for insurance companies and it would be useful for running reports).  I cannot figure out where to activate "class tracking" or even the steps to accomplish using it.  Can you or someone out there help?
Rustler
Level 15

What are the steps to record an insurance payment paid on behalf of a patient to a medical provider. How do I specify that the payment came from an insurance company?

if you invoice the customer ...
a location tag will only track and report on the total amount
a class tag is used on each line item, tracking and reporting each amount

But when you use receive payments, that is not a transaction in QB, so no class or location tracking can be attached
allisontax
Level 1

What are the steps to record an insurance payment paid on behalf of a patient to a medical provider. How do I specify that the payment came from an insurance company?

Hi Lindsey,

 

Did you figure out how to track insurance claim payments?  I am having the same issue.

MaryLandT
Moderator

What are the steps to record an insurance payment paid on behalf of a patient to a medical provider. How do I specify that the payment came from an insurance company?

Hi there, allisontax,

 

I'm here to help track the insurance claim payments in QuickBooks Online.

 

You need to create an account to help categorize this entry. I suggest consulting this with your accountant to know what specific type of account to set up.

 

Create a new account

  1. Go to the Gear icon at the top right.
  2. Select Chart of Accounts under Your Company.
  3. Click New.
  4. Choose an Account and Detail Type.
  5. Enter the name of the account in the Name field.
  6. Add a Description when necessary.
  7. Click Save and Close.
    newbankaccount.PNG

Once done, make a bank deposit and categorize it under the account created above. Here's how:

 

  1. Click the + New button at the left navigation bar.
  2. Select Bank deposit under Other.
    bankdeposit.PNG
  3. From the Account drop-down▼menu, choose the account you want to deposit the money into.
  4. Enter the name of the payee in the Received from field.
  5. Select the insurance account created above in the Account field.
  6. Enter the Amount.
  7. Click Save and close.
    makeabankdeposit.PNG

You can refer to the record and make bank deposits to learn more about the process.

 

Let me know if you have follow-up questions, and I'll get back with the information you need.

ozdavis
Level 3

What are the steps to record an insurance payment paid on behalf of a patient to a medical provider. How do I specify that the payment came from an insurance company?

I had the same issue and decided to setup the patients as a sub-customers of the insurance company and select the option to Bill with parent. It works like a charm!

 

Here is the screen-shot under customer setup:

Capture.JPG

LedgerHero
Level 1

What are the steps to record an insurance payment paid on behalf of a patient to a medical provider. How do I specify that the payment came from an insurance company?

Oh that's smart, I like that! Well done!

mhauptman
Level 1

What are the steps to record an insurance payment paid on behalf of a patient to a medical provider. How do I specify that the payment came from an insurance company?

What was the end result/recommendation to write off the amount over the contracted allowable amount in the online version?  Can you apply a write off simultaneously when recording the insurance payment? 

Dspeedy
Level 1

What are the steps to record an insurance payment paid on behalf of a patient to a medical provider. How do I specify that the payment came from an insurance company?

I like the sub-customer idea, if they are your clients. If a provider has someone outside the office doing the bookkeeping with QBO, I'm not sure this method would work....HIPAA and all. Any other thoughts of how to accomplish this?

AileneA
QuickBooks Team

What are the steps to record an insurance payment paid on behalf of a patient to a medical provider. How do I specify that the payment came from an insurance company?

Hi there, @Dspeedy

 

Thank you for reaching out to the Community. We can use class tracking to help you track the insurance payment in QuickBooks.  

 

Although, you can associate it to a customer or sub-customer. Just make sure your Class Tracking feature is turned on for the Class column to show up. 

 

On the other hand, class and location tracking monitors income, expenses, and reports for different segments or locations of the business.  

 

Please see these support articles for more details: 

 

 

Leave a comment below if you need anything else, I’m always ready to help. Have a good one!

Noway-Jose
Level 1

What are the steps to record an insurance payment paid on behalf of a patient to a medical provider. How do I specify that the payment came from an insurance company?

Yeah... totally shouldn’t be inputting client data in QB. They refuse to issue a BAA. Get practice management software and do it right. 

https://quickbooks.intuit.com/learn-support/en-us/insurance-and-medical-benefits/is-quickbooks-onlin...

HJ-Nesca
Level 1

What are the steps to record an insurance payment paid on behalf of a patient to a medical provider. How do I specify that the payment came from an insurance company?

Hi Mary,

Quick question... will this allow identify (track & generate a report) who paid a particular of an invoice and when?

 

Thanks for the input!

- Henry

Ryan_M
Moderator

What are the steps to record an insurance payment paid on behalf of a patient to a medical provider. How do I specify that the payment came from an insurance company?

Hi @HJ-Nesca,

 

I'll handle this query for you. 

 

The steps provided by my peer @MaryLandT above is for insurance claim payments. As for your concern, I'd like to point you to the post made by Rustler above. In case you missed it, the option to track who paid what portion of an invoice, and also when, is unavailable at this time. 

 

I suggest you consult your bookkeeper or accountant on how it's best to proceed with your earlier query. It's so you can ensure your books stay accurate. 

 

You may also keep an eye on this page: The QuickBooks Blog. It lists all of QBO's new features, as well as improvements each month. It also comes with a short description for each, so you'll become familiar with them in no time. 

 

Direct other questions you may have in the comments below. I'll be sure to get back to you. 

SenseAbilitiesPediatricTherapy
Level 1

What are the steps to record an insurance payment paid on behalf of a patient to a medical provider. How do I specify that the payment came from an insurance company?

I setup all the insurance carriers as the primary customers and I have 1 "patient" called NONE that I am using to track patient payments.  Because of HIPAA you cannot individually identify patients and treatment charges in QB or QBO and I do not do this.

 

But, my method allows me to track Accounts Receivable by Insurance carrier.  I am currently posting Co-pays as discounts for now, until I find a better way.


Elias

Need to get in touch?

Contact us