We record all payments into the Excel Deposit spreadsheet which is saved under each month.
Here is a sample of the Daily Deposit spreadsheet: Daily Deposit
Be sure to save this as a “read only” file so you must do “save as” so the master is never overwritten.
Save as today’s date in _____________ with the correct year/month
This spreadsheet has five worksheets – one for each day of the week.
Select the correct day, and enter the date and your name in the correct areas and SAVE.
You will fill each section (cash, checks in office, checks in mail, etc) as you enter them in the Dentrix ledger. You can check spreadsheet frequently, especially after finishing each section marked, to make sure that it matches Dentrix deposit report. This way you will quickly catch your own errors, rather than waiting till everything is finished.
This figure should equal the Total Deposit listed on your Excel worksheet for the day
This is the process for entering the payments:
1. Make sure the name is correct on “Pay to the order of” line.
2. Stamp the back of all checks with the endorsement stamp
Click> Settle> Enter code 00000000 >click through the rest of the prompts
To record cash, personal checks, credit cards and paper insurance checks
If this is a pre-payment, you’ll have to choose the doctor and apply to his/her account.
How to Deposit an Unsigned Check
1. Type “lack of signature guaranteed” on the back
2. Below this, stamp with HealthPark deposit stamp
3. Below the stamp write your name and title
This guarantees we will take the check back as a charge against our account if it’s not honored.
Our check endorsement stamp should be in the top one and one-half inch of the check. This is the same as the ‘Pay to the order of…’ on the other side.
ENTERING INSURANCE PAYMENTS – paper checks mailed to us.
Our Dentrix system has the ability to update the amount that an insurance company pays on treatment. This is very helpful when estimating insurance coverage for future treatment for someone else with the same insurance coverage. In order for this to work, we must update the payments as they are made by an insurance company. We do this on each individual claim that we receive from an insurance company, by utilizing the following steps:
Do not update when entering a payment w/deductible
When entering Orthodontist insurance payments, enter patient chart # or zz (space) last name, first
Remember this – when entering payments for our orthodontist – whether it is a personal payment or an insurance payment if you find any balance at all that is showing at owed to Dr – AND YOU ARE IN A REGULAR ACCOUNT, NOT AN ORTHO ACCT – you need to stop, do not enter the payment, but assess the situation. Check to see what charge has been entered for Dr on this regular account. IT IS NOT CORRECT, AND YOU NEED TO CORRECT IT. See if you can figure out who actually did the treatment or adjustment that got charged out to Dr. i.e. – did he get charged for a periodic exam – this has happened several times that the hygienist clicks on the orthodontist instead of the general dentist – who is the doctor they actually want and her name is the one above our orthodontist.
When you determine who the charge should have gone to, IF IT IS IN THE SAME MONTH, then if there is no insurance, change the provider from the orthodontist to the correct provider and enter the payment. If there is a claim delete the insurance claim and then change the provider from Dr to the correct provider, make a new claim, and then enter the payment. If you can’t figure out who the correct provider is – put the payment aside and ask one of the secretaries to help you determine the correct provider, even if this takes a day or two, and then enter the payment when it has been corrected. This will save A TON OF TIME if you do it this way, since fixing it on the back end is VERY time consuming.
Correcting a payment posted to ortho instead of a regular account or vice versa (posted to a regular account instead of ortho.
In this situation, you will not do an internal transfer to correct the posting error, as this will cause a debit/credit situation on both accounts and then you would need to do external provider transfers on both accounts, which just causes more work. Here is what you do.
If the 50.00 payment is posted to the ortho acct of John Jones instead of his regular acct.
In either of these situations, it is still a lot of work to correct, no matter how you do it, so the important thing here is to really watch these accounts to eliminate these errors and minimize the correction work.
ENTERING INSURANCE ELECTRONIC PAYMENTS
To view Superior EOB’s paid by direct deposit www.superiordental.com
Click on red box: Get Connected at the lower left. Next screen – again click on Get Connected
This is the login screen: need Username and password.
There is an account for each provider:
Here are their user names:
The password is:
Next click log on
The next screen has several options on the blue bar.
Check eligibility (by SSN) Check claim status (by SSN)
Vouchers (EOB’s paid) Request EOB (by claim number or date range)
To view and/or print the EOB, click on the one that says VOUCHERS. The next screen will show the last six payments. Click on the PDF file listed by the check date that you want to see. The password to open the PDF file is:
To set up a new doctor account for viewing EOB’s:
Will need user name: use doc’s name in lower case
Email address – it needs to be a unique address for each doc account but doesn’t have to be a real email address. I have used email@example.com and then just added a number i.e. (firstname.lastname@example.org) to differentiate (Superior’s requirement). I used lsmith1 through lsmith4.
You will also need the doctor’s: Tax ID number (or social security number if they don’t have a Tax ID number)
NPI numberLast 4 digits of their dental license number. After you have submitted this, it takes several hours for Superior to authorize this account before you can actually use it.
Emdeon Electronic INS Payments – Guardian and Dental Care Plus
Process payments for multiple insurance carriers:
Dental Care Plus and Guardian Life
Payment Manager Website:
Each tax ID number has a separate account w/ username and password:
PASSWORD needs changed often on this site!! Aggravating…
We need to access the website to find our electronic payments. We will not be sent any notification that we have a payment. The only way to check is on our online banking w/ PNC to show payments posted by Dental Care Plus or Guardian. These can occur on any day of the month.
To check for payments and print the EOB’s:
Direct Patient Debits
Some patients chose to have us debit a recurring amount from their bank accounts weekly or monthly rather than sending us a check or using a credit card. We set up these through the ACH section of our banking, and enters these on the correct dates in Dentrix. You will find these when you run the Dentrix deposit report for credit cards and electronic payments. You will list these on the Excel deposit worksheet under Electronic Insurance Checks. Enter the patient’s name to the right of the amount.
Check patient account balance when entering payments. If the balance is zero, do not enter the payment without checking why the patient is paying if they have no balance. Are they paying for treatment that is yet to be done, or did we miss entering a charge, or did someone put incorrect patient account # on payment? Always enter the payment under the head of household’s main number. All contracts will be set up under the head of household in the main database, so if a payment comes and is not in the blue envelope denoting contract, it will let you know on the screen if you always enter the payment under the head of household.
If a check is returned for insufficient funds enter the adjustment code – NSF and charge the dentist who the previous check was going to. Also charge a $15.00 bookkeeping charge to the account for the same dentist. Then call the bank to check if there are now enough funds to cover the check. If so, enter the check again as a payment. If the check comes back a second time, again enter the NSF adjustment and $15.00 bookkeeping charge, print a statement and send with check to patient.
If you receive an unsigned check don’t return it. Write “over” on the signature line. On the back write, “lack of signature guaranteed” along with our stamp and the doctor’s signature.
Entering payment for folks who have been written off or sent to collections
When you enter a payment and see the alert pop up that shows “Written off $45.00” you should open this alert and change the content. Change the subject to “Past Write off” or “Past Collections” and the content you can add “Paid write off $45 – must pay in full in advance for future appointments” or “Paid collections $200 – must pay in full in advance for future appointments”.
Payments made to the Office that are not our patients:
Electronic deposit and specialist – enter into Insurance Adj account and wait till end of the month to write one check.
Credit card or Cash payment made without Chart # or Name – enter into Unclaimed funds acct and add to excel daily sheet. We’ll account for it at a later date.
Patient Financing Program Payments – Care Credit GE Capital
Care Credit (GE Capital) deposit electronic payments to our checking account.
Website, ID & Password:
(Click on Reports, then Daily Funding – enter date range to get full report of pt names, totals, service charge and amount to be posted to our checking acct. Also shows date posted.)
END OF DAY
After all money is entered
– click office manager icon
– click day sheet
– click deposit slip
– click payment types
– highlight all types of electronic payments>Print
– highlight 8 items that go to bank>Print 1
– Add up totals of all Dentrix items – should match totals of both Deposit Slips-Electronic and Bank (physical deposit)
– add up yellow cash slips to verify cash
– fill out deposit slip
– endorse all checks if not already done
– count all cash for deposit