Orthodontics+Payment+Plans

The purpose of this excel spreadsheet is to put in data quickly for new patients so that way we can give them fees for new braces in a matter of minutes. I created this excel spreadsheet so that way time wasn't wasted while patients were waiting. If you wanted to use an approach such as this one all you would have to do is insert the cost of the braces in cell B16. Once information is entered in that cell other cells will begin to calculate. The only cells that you would have to fill out would include: fee patient is charged (by insurance company), less promised insurance benefit (how much insurance will pay), less initial payment due at first visit (patients first charge), and the monthly charges for the patient. You only have to insert this in the metal column.