fred0 wrote on Wednesday, June 03, 2009:
If anyone here has any experience with POS workflows when you have inhouse_pharmacy set to true, I’d love to hear how you manage accepting payments for products and billing for insurance on the same encounter and for product only sales. I can’t seem to find a way that works properly.
Here’s my series of tests:
Test 1
1. Add encounter
2. Add CPT & ICD9 and justify on fee sheet
3. Appears in billing view as ready to bill
NOTES - none, worked as expected for basic billing with no product
Test 2
1. Add encounter
2. Add CPT & ICD9 and justify on fee sheet
3. Add co-pay on fee sheet
4. Appears in billing view as ready to bill with COPAY as entered value from fee sheet
NOTES - while this mostly worked as expected, the COPAY entry has no associated payment type (ie - cash, credit card, check, other)
Test 3
1. Add encounter
2. Add CPT & ICD9 and justify on fee sheet
3. Go to checkout form and add partial payment
4. Appears in billing view as billed with COPAY as amount from checkout and an error in red saying, "Note: This code was not entered by an authorized user. Only authorized codes may be uploaded to the Open Medical Billing Network for processing. If you wish to upload these codes, please select an authorized user here."
Test 4
1. Add encounter
2. Add CPT & ICD9 and justify on fee sheet
3. Add non-drug product that is taxable
4. Appears in billing view with only CPT & ICD9 codes and amounts
5. Now, go to checkout and pay amount for product & product tax only
6. Back to billing view, encounter shows as billed, the payment for the product amount & tax is shown as COPAY and the TAX for the product appears as its own item (but doesn’t get added to the HCFA total on print). Also get the error “Note: This code was not entered by an authorized user. Only authorized codes may be uploaded to the Open Medical Billing Network for processing. If you wish to upload these codes, please select an authorized user here.”
NOTES - I tried Test 3 & 4 with a user who had the "Authorized" checkbox first disabled and then again enabled with the same error result. Also tried it as the admin user with the same error result. Besides the error, the use of the checkout popup is NOT AT ALL what I would have expected (see summary below).
Test 5
1. Add encounter
2. Add CPT & ICD9 and justify on fee sheet
3. Add non-drug product that is taxable
4. Appears in billing view with only CPT & ICD9 codes and amounts
5. Go to EOB interface, find & open encounter
6. Services show as 1 line item, products as another. TAX fails to appear at all.
7. Make patient payment for product amount only
8. Back to billing view, encounter now shows only services amount, no taxes, no COPAY as expected but has no record of payment type other than a check number (can’t set credit card/cash/other/etc)
NOTES - This is the one workflow that came anywhere to close to working right. The main failure was the lack of TAX in the EOB interface. The other 2 failures were the lack of payment type in the EOB interface and the fact that it is overly complicated for doing POS checkout at the front counter. And EOB should only be handled by accounting, not the front office.
Test 6 (product only sale)
1. Add encounter
2. Add products to fee sheet (no CPT/ICD9 codes)
3. Appears in as unbilled billing view with no codes or charges
4. Appears in current patient encounters list with no detail or indication of type
5. Use Checkout popup to accept payment
6. Appears in billing view as billed with COPAY and TAX as line items
NOTES - failed as expected per Test 4
Test 7 (product only sale)
1. Add encounter
2. Add products to fee sheet (no CPT/ICD9 codes, no Provider)
3. Appears in as unbilled billing view with no codes or charges
4. Appears in current patient encounters list with no detail or indication of type
5. Does not appear in EOB basic search for open invoices with no other search parameters set
6. Search EOB for All with either date or name set finds invoice but shows no amount in Charge column
7. Open invoice in EOB shows charges but TAX is missing
NOTES - failed as expected per Test 5
Test 7 (Prepay)
1. Add and select new patient
2. Choose Prepay popup
3. Add payment amount and save
4. New encounter created on today’s date as DOS with COPAY of entered prepay amount
Another take:
1. Use Prepay popup for patient with balances due
2. Shows due balances with DOS for each and payment fields
NOTES - Not quite what I expected from the name. We require new patients to pre-pay for their first appointment and usually take these pre-payments several days in advance of the appointment and the name suggested that this would be that kind of function. However, prep-pay in this case seems to mean a patient paying a charge before the insurance check arrives. I’m not really sure why one would use this instead of the EOB interface and why it records the payment as a COPAY.
For my purpose as described here, this doesn’t work since the DOS can’t be set. While it would have been a nice to have, it’s easy enough to use the Comments in the appointment add/edit to note the payment received & details to be added once the appointment is billed.
In summary:
I could not find a way to properly deal with in-house product/drug sales and POS checkout and insurance billing.
While the Checkout popup does provide payment type entry, applying the payment as a COPAY was not what I would have thought it would do. I had expected some way to do POS sales. And at the very least, I would have expected it to enter the payment as A/R and not as a COPAY.
Using the EOB interface applied the payment properly, but was overly complicated for front office (and should only be available to accounting users anyway), didn’t record payment types and didn’t calculate and include tax.
What is needed is a Checkout window that:
1. Allows one to select which line items to pay for at checkout (probably checkboxes to the right of each line item) and calculates the total of those selected items in the amount paid box.
2. Has payment type selection
3. Has COPAY as an optional line item.
4. Calculates tax.
That way, one could accept payments for products while leaving the services to be billed to insurance. Or one could select all for a patient with no insurance who is paying the full amount themselves. The COPAY amount would be added to the amount due/paid in checkout, but separately applied to the insurance billing.
In function, that would mean that the amount paid and payment type would be recorded in ar_activity & ar_session and split up for line items (the way an EOB entry would). If there is a copay set, that value is subtracted from the total and recorded in the billing table as is done by both the fee sheet and the current Checkout popup.
Finally, a product only sale transaction with tax is impossible as far as I can tell.
However, even with a proper POS checkout function, should one want to do a product only sale transaction, the only way to accomplish that is to create an encounter for the sale. Kind of a weird way to do product only sales, but not terrible. A quick way to handle this is to add a calendar category like "Product Only Sale" so that when creating the encounter this category can be used to set it apart from regular appointment encounters.