Solved

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?

Forum|Forum|7 years ago
October 19, 2018
4 replies
0 views

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?

QuickBooks Online

Best answer by Rustler

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

RustlerAnswer

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

A

arkvalleyinfoAuthor

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?

A

allisontax

Hi Lindsey,

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

MaryLandT

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

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

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

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

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.

H

HJ-Nesca

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

R

Ryan_M

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.

O

ozdavis

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:

L

LedgerHero

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

M

mhauptman

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?

Sign up

Login with SSO

Login to the community

Login with SSO