cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

11 Comments
Highlighted
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

Highlighted
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?
Highlighted
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
Highlighted
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.

Highlighted
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, 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.

Highlighted
Level 2

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

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!

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

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

Highlighted
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!

Highlighted
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...

Need to get in touch?

Contact us