Payment Worksheet

 Top  Previous  Next

Payments are typically entered in "batches".  A batch of payments may be for a date from a lock box, or for an EOB, or for all self-pay payments from the lock box, or some other batching methodology.  However, once the payments are entered, the batch needs to be "balanced".  This involves checking a report of the payments in the batch against the original documents for the payments and ensuring that the total payments and total adjustments balance between the report and the original documents.  This process ensures that all payments and adjustments are entered, that they will balance to the bank deposit.

 

The Payment Worksheet request form is a tabbed dialog that consists of a General tab, a Sorting tab, and a Selection tab.

 

General Tab

 

Task Name

Task Name displayed in the Task Viewer

Sequence By

Indicates the sequence to print details on the report (within primary sorts):

•Entry Order
•Patient Name

 

Include Interest Payments and Adjustments Only

Selects only those payments and adjustments that are flagged as Interest codes on Payment Types or Adjustment Types Setup.

 

Un-Posted

Indicates that the Worksheet is to be run against unposted payments for a batch or all batches

 

Batch No

Batch number (blank for all) to run for unposted payments

 

Released Batches Only

When running the report in Un-Posted mode, you may select only batches that have been released for posting.

 

Include Unposted Reversals

When running the report in Un-Posted mode, you may select unposted reversals.

 

Posted Date

Indicates that the Worksheet is to be run against posted visits for a posted date range

From Date

When running the report in Posted Date mode, enter the beginning date of the posted date range

 

Thru Date

When running the report in Posted Date mode, enter the ending date of the posted date range

 

Cube Data

Indicates if report results should be output to a data cube

 

Generate Standard Report

Indicates if report results should be output to a formatted report

 

Run Now

Indicates in the report should be run immediately

 

Schedule

indicates that the report should be scheduled to run at a future time

 

Schedule Button

invokes the Task Schedule Wizard to guide the user through setting the report run date(s) and time(s)

 

 

 

Sorting Tab

 

The Sorting tab consists of two lists.  The first list is comprised of the available sort fields for the report and the second list is comprised of the fields that have been selected as sort fields.  The fields in the second list may be sequenced in any order.  The report will sort the data into the sequence defined and perform a "break" on the sort field as well.

 

Selecting Sort Options:

 

Right-Arrow Button

Click on item to be selected in the left-hand list and press the right-arrow button.

Drag-and-Drop

Click on the item to be selected in the left-hand list and while holding the mouse button down, "drag" the item to the right-hand list and release the mouse button.

Double-Click

Double-click on the item to be selected in the left-hand list.

 

 

De-Selecting Sort Options:

 

Left-Arrow Button

Click on item to be de-selected in the right-hand list and press the left-arrow button.

Drag-and-Drop

Click on the item to be de-selected in the right-hand list and while holding the mouse button down, "drag" the item to the left-hand list and release the mouse button.

Double-Click

Double-click on the item to be de-selected in the right-hand list.

 

 

 

 

Selection Tab

 

Frequently when a report is run, you only wish to see data meeting certain criteria.  The Selection tab consists of a list of fields they you may use to include or exclude specific data values from the report.  For example, you may wish to run a report for just a certain physician or excluding a certain location.

 

By clicking on the checklist for the appropriate field (physicians, facilities, etc.) you may then select to include or exclude certain values from the respective tables.  The limit to the number of specific values you can select is limited to your ability (or willingness) to enter them.  While there is a theoretical limit to the number of selections you can make, you will run out of patience before MedSuite runs out of room to save them.  Muli-Selections work with standard Windows keyboard functionality.  CTRL+Click to select one at a time, SHIFT+Click to select a range of maintenance files.