Sunday, March 21, 2010

New Day Sheet Report Sorts Out Insurance Payments

The Day Sheet is a report of all transactions for the day. It is an extremely powerful report which is able to show totals for any time period.

The Day Sheet can show totals for:

Billing Providers
Treatment Providers
Charges
Payments
- Subdivided by Checks, Cash, Credit Cards, and Electronic Payments
Adjustments

The Day Sheet is also capable of viewing these totals for any date range, so if you wanted to see:

1) what money Dr. Jones billed and took in last week, last month, or even last year, or

2) what amount did you receive in American Express payments last month

the Day Sheet is where you would get the answer.

The Day Sheet is also capable of limiting the data to a single billing provider, treatment provider, treatment location or insurance carrier.

However, now the Day Sheet is capable of showing you subtotals for any date range by insurance carrier (also subtotaled by Billing Provider and Treatment Provider).

There may be several circumstances where this might be helpful.

1) Let's say you have entered your transactions for the day, and find that your Day Sheet for today does not match your deposit.

Previously, you might have to go through your payments entered one by one and make sure they were entered correctly.

Now, but sorting the Day Sheet by insurance carrier, all you need do is make sure each insurance check matches the total for that carrier on the Day Sheet. The one that doesn't match is the one with the error.

2) At the end of each year, each insurance carrier sends you a 1099 (or similar income summary for the year). Just print out (or preview in PDF format) a summary of the Day Sheet for last year and compare the totals.

3) Maybe you are considering no longer participating in an insurance plan. By checking your totals for previous years, you can calculate how that might impact your practice.

So, remember, the Day Sheet is actually a transaction log of any date range you choose, with many options to show this data in a variety of formats. Most times, when you are looking for totals, the Day Sheet has the answer.