Balancing Worksheet Summary

Run the Balancing Worksheet Summary report to obtain a summary of the production, collection, and adjustment transactions that appear on one or more final Balancing Worksheet reports for any range of dates or final report numbers. For each transaction type, the report includes the number of posted transactions and the average and total amounts for that type. The report is designed to be printed at the end of each month to include all transactions entered for that month. However, it can be used for any desired range of dates.

This report defines a transaction date as the date of the Balancing Worksheet report on which it was included. Although it is sometimes possible to post-date or back-date transactions, they always appear on the next Balancing Worksheet report. This allows you to reconcile specific Balancing Worksheet reports with your Balancing Worksheet Summary.

Run This Report

Open the Report - ViewPoint main menu > Practice Reports > Financial > Balancing Worksheet Summary.
Report Settings Select the options to use for choosing records and generating this report. Choose carefully, as your selections will affect which data is included in the report.

First & Last Report Dates or Numbers - Enter the first and last transaction dates to include, or specify a range of Balancing Worksheet report numbers to include.

Office - Choose to include only the records for a specific office, or include the records for all office locations in your practice.

Doctor - Choose to include only the records for a specific doctor, or include the records for all doctors in your practice.
Output Options - After selecting the report settings, click Ok to continue to your output choices. See "Manage Record Selection & Output" for details.

More Information

Report Sections - This report has multiple sections, each summarizing transactions from the range of final reports you selected to include. All sections include the transaction description, total number of each type of transaction, average amount of each type of transaction, and total amount for each type of transaction. Each section ends with a sum of all transactions in that section. See "Balancing Worksheet" for details about each section.

Report Summary - The end of the Balancing Worksheet Summary calculates your total production, collection, and accounts receivables balance for the range of final reports you selected to include. See "Balancing Worksheet" for details about how each type of transaction is calculated.