Excel for Health
Posted by Sheri Harris on Friday, April 22, 2011
Under: Medical
Problem
There needs to exist an easier way to be able to incorporate medical billing so that it can be done easier, faster and cheaper. EMR software has enabled billers to do the job as an almost paperless task but there still exists the cumbersome duty to actually collect the money from the insurance company and patients. This can place a strain on medical offices who have to wait in oder to see checks from the insurance company. When problems arise such as resubmitting claims because the insurance company wants to know more about the doctors visit other than the usual diagnosis code or type of visit there is usually a delay in payment. For certain procedures insurance companies want progress or physician notes, referral information ect. Requesting all this information can create an insustry of "duct" tape thus making it difficult for physicians to stay in practice. There is also the issue of someone having to quack it out in posting received payments in order to make sure that every patient has a healthy balance of zero with regard to their account after each visit. There must be an existing universal software to ease this billing problem.
Solution
Medical Office Excel. Medical Office Excel can be used in place of your existing emr billing software by downloading the application from your emr. By using a universal software and simply downloading it onto your emr you will be able to link patient accounts and subsequently produce spreadsheets for each patient for each visit. This means that every patient will have their own Excel data sheet that you can use Excel to create all kinds of graphs, billing and payment inquiries. The ease in doing this is because since Excel is universal, so each insurance company can enter the amounts they are paying for a patient in to their billing database and by being linked to the insurance company with your emr, one can up load all payments to be recieved from their Excel software. This process eliminates the task of posting so it does not need to be done because you have uploaded all of the insurance company payments so that they appear automatically. This saves the biller lots of time. As the emr should be equipped with a way to enter appeals information eg. additional diagnosis, attachment of medical notes ect., making the billing process become less difficult in that once you have your additional information you just press resubmit and you are ready to go. With Medical Office Excel you can also print out separate eob statements to keep a log of what the insurance company has sent. You can also generate daily,weekly, monthly or yearly reports for billing,payment and invoices.
How simple is Excel to use:
You would just use your emr as it is normally used. This would include making sure you have the proper patient demographics and insurance. You will aslo need the proper CPT codes for the type of visit, procedure or service and the diagnosis. The biller or medical staff will go into the Excel software and select the patient they need to bill. This can be done by selecting "batch billing" if you send bills once a week or patient by patient if this is done every day. Once you select the patient in either situation Excel will know how much to bill the patient for as it works with your emr system in knowing the physicians fee schedule and keeping up to date with medicaid, medicare and commercial insurance contract payments for each service provided. Once you check to make sure that everything is correct you press send and everything you need to bill will be sent to the insurance company. By using the status bar page in Excel you can keep track of payments and claims that were sent. The insurance company will then receive your claim and process for payment. Once charges are approved the insurace company will then enter amounts of payment sent for each patient and that payment data can then be uploaded into Excel. In the recieved payments tab of Excel you will be able to keep track of and view all payments made to you. This can also be done by individual patient or batch. An Excel spreadsheet of eob's is provided for each check that is also printable. since the posting is already done by the insurance company, all the biller needs to do is to upload the data into the Excel software. So posting is no longer necessary. All that needs to be done is to verify payments issued to make sure they are correct. That's it! The money can be electronically placed into the medical office's bank account which will eliminate the lost check, wrong address problem and the time it takes to submit all of your collected checks to a bank. If there is a problem with a claim, the excel software will inform you by highlighting the patient and then tell you why a particular claim was denied. To fix the claim you just go into your emr software and click the "correction box" and then type in or check off what corrections and or documents you are including to send along with the "attachments from your emr or word software. This may include letters of appeal, or medical necessity information. Once this is done you just go into your excel software and press"resubmit" and send the claim again. Excel medical software will also tell you what amount the patient is responsible for regarding, duductibles,copayments,coinsurance and out of network payments. By highlighting the amount the patient is responsible for, as this can also be adjusted as the Excel software will assist you in payment corections if necessary, you will automatically be able to print out an invoice to mail or even e-mail to your patients. There is also a tab to keep track of invoices sent. You can also automatically enter a zero balance for patients once they have paid their bill in accordance with their insurance company and it also has a tab for delinquent payments. Excel medical software is the all in one software for your medical office. So you can stop ducking and passing the buck of billing. Keep your office quiet as a lamb. This is one software you won't need excuses to chatter about, so make the grade with Medical Office Excel!
There needs to exist an easier way to be able to incorporate medical billing so that it can be done easier, faster and cheaper. EMR software has enabled billers to do the job as an almost paperless task but there still exists the cumbersome duty to actually collect the money from the insurance company and patients. This can place a strain on medical offices who have to wait in oder to see checks from the insurance company. When problems arise such as resubmitting claims because the insurance company wants to know more about the doctors visit other than the usual diagnosis code or type of visit there is usually a delay in payment. For certain procedures insurance companies want progress or physician notes, referral information ect. Requesting all this information can create an insustry of "duct" tape thus making it difficult for physicians to stay in practice. There is also the issue of someone having to quack it out in posting received payments in order to make sure that every patient has a healthy balance of zero with regard to their account after each visit. There must be an existing universal software to ease this billing problem.
Solution
Medical Office Excel. Medical Office Excel can be used in place of your existing emr billing software by downloading the application from your emr. By using a universal software and simply downloading it onto your emr you will be able to link patient accounts and subsequently produce spreadsheets for each patient for each visit. This means that every patient will have their own Excel data sheet that you can use Excel to create all kinds of graphs, billing and payment inquiries. The ease in doing this is because since Excel is universal, so each insurance company can enter the amounts they are paying for a patient in to their billing database and by being linked to the insurance company with your emr, one can up load all payments to be recieved from their Excel software. This process eliminates the task of posting so it does not need to be done because you have uploaded all of the insurance company payments so that they appear automatically. This saves the biller lots of time. As the emr should be equipped with a way to enter appeals information eg. additional diagnosis, attachment of medical notes ect., making the billing process become less difficult in that once you have your additional information you just press resubmit and you are ready to go. With Medical Office Excel you can also print out separate eob statements to keep a log of what the insurance company has sent. You can also generate daily,weekly, monthly or yearly reports for billing,payment and invoices.
How simple is Excel to use:
You would just use your emr as it is normally used. This would include making sure you have the proper patient demographics and insurance. You will aslo need the proper CPT codes for the type of visit, procedure or service and the diagnosis. The biller or medical staff will go into the Excel software and select the patient they need to bill. This can be done by selecting "batch billing" if you send bills once a week or patient by patient if this is done every day. Once you select the patient in either situation Excel will know how much to bill the patient for as it works with your emr system in knowing the physicians fee schedule and keeping up to date with medicaid, medicare and commercial insurance contract payments for each service provided. Once you check to make sure that everything is correct you press send and everything you need to bill will be sent to the insurance company. By using the status bar page in Excel you can keep track of payments and claims that were sent. The insurance company will then receive your claim and process for payment. Once charges are approved the insurace company will then enter amounts of payment sent for each patient and that payment data can then be uploaded into Excel. In the recieved payments tab of Excel you will be able to keep track of and view all payments made to you. This can also be done by individual patient or batch. An Excel spreadsheet of eob's is provided for each check that is also printable. since the posting is already done by the insurance company, all the biller needs to do is to upload the data into the Excel software. So posting is no longer necessary. All that needs to be done is to verify payments issued to make sure they are correct. That's it! The money can be electronically placed into the medical office's bank account which will eliminate the lost check, wrong address problem and the time it takes to submit all of your collected checks to a bank. If there is a problem with a claim, the excel software will inform you by highlighting the patient and then tell you why a particular claim was denied. To fix the claim you just go into your emr software and click the "correction box" and then type in or check off what corrections and or documents you are including to send along with the "attachments from your emr or word software. This may include letters of appeal, or medical necessity information. Once this is done you just go into your excel software and press"resubmit" and send the claim again. Excel medical software will also tell you what amount the patient is responsible for regarding, duductibles,copayments,coinsurance and out of network payments. By highlighting the amount the patient is responsible for, as this can also be adjusted as the Excel software will assist you in payment corections if necessary, you will automatically be able to print out an invoice to mail or even e-mail to your patients. There is also a tab to keep track of invoices sent. You can also automatically enter a zero balance for patients once they have paid their bill in accordance with their insurance company and it also has a tab for delinquent payments. Excel medical software is the all in one software for your medical office. So you can stop ducking and passing the buck of billing. Keep your office quiet as a lamb. This is one software you won't need excuses to chatter about, so make the grade with Medical Office Excel!
In : Medical