Balancing Worksheet

The Balancing Worksheet summarizes monthly financial transactions by category for a time period you specify. More...More...

You can print the worksheet for a specific month, for a range of specific dates, or for a specific year.

The first section of this report prints the aged receivables from the time period prior to the period you selected. For example, if you entered 08-2008, the report prints the aged receivables from the last closed daysheet in July 2008.

The last section prints the aged receivables from the specified time period, based on the specified time period’s last closed daysheet.

Between these two aged receivables sections are totals for three transaction categories: Charges, Payments, and Adjustments. These totals are transactions from the patient ledgers posted between the dates of the two aged receivables totals. The transactions are categorized and added or subtracted from the previous time period’s aged receivables. The report is in balance if the calculated value of the previous period’s aged receivables, adjusted by the subsequent Charges, Payments, and Adjustments, equals the selected time period’s aged receivables.

Payment plans have been removed from the Charges category and are now listed under the Adjustments category.

Keep the following pointspoints in mind when using the Balancing Worksheet:

Transactions that are posted and adjusted off on the same daysheet are not calculated in the original category, such as Charges, or the corresponding adjustment category, such as Charge Adj.
Transactions included in the Balancing Worksheet are based on the daysheet to which they were posted rather than on the transaction date. For example, transactions that occurred in the previous month but which are included on the current month’s daysheet are not reflected as differences, and do not result in an out-of-balance worksheet. Transactions posted on a computer with a time setting that differs from the server’s time setting do not result in an out-of-balance worksheet.
If the daysheet contains transactions for more than one month, the totals of the affected categories do not match the totals on the Total Summary page of the daysheet in the Month-to-Date section. It is recommended that you close the daysheet on the last day of the month and do not post transactions until the first day of the next month.
The Balancing Worksheet calculates the beginning A/R amounts as of the first closed daysheet in the specified time period, if no balance exists in the previous period.
The Balancing Worksheet tracks late charges and late charge adjustments in the Adjustments section; the daysheet tracks late charges in the Charges section. To more accurately correlate figures, contact your software support provider for assistance.
The Misc Pymt 1 and Misc Pymt 2 items must be in the Payments category in the daysheet to correlate with the Balancing Worksheet.
The Balancing Worksheet Total Adjustment figure cannot be matched directly to a single category in the daysheet. To correlate the reports, add the categories on the Totals Summary page of the daysheet in the Month-to-Date Totals section using this formula: Contract Adj + Charge Adj + Payment Adj + Other Adj + Write-offs + Discounts.

To generate a Balancing Worksheet:

From the main menu, select Reports > Financial > Balancing Worksheet. The Balancing Work Sheet window is displayed.
In the Select Date(s) section, select a date option and type the appropriate date information in the field.
In the Show Detail for section, all options are selected by default. If necessary, deselect the options you do not want to include in the report.
In the Location(s) section, All Locations is selected as the default. To select a specific location, select Single Location and select a location from the drop-down list.
In the Doctor(s) section, All Doctors is selected as the default. To select a specific doctor, select Single Doctor and select a doctor from the drop-down list.
Click OK.