Accounts Receivable

Top  Previous  Next

At its core, MedSuite maintains the accounts receivable balance for all accounts.  It is therefore necessary to periodically produce a report of the accounts receivable balances and the ages of the balances.  The Accounts Receivable report may be requested for totals only, with patient detail only, or with charge detail.  All of the detail level reports produce totals within the requested sort breaks.  Therefore, if an Accounts Receivable report were run by Plan and Physician for totals only, the report produced would print an aged total for each plan and physician.

 

Accounts receivable may be requested by charge posted date or service date and payment posted date, remit (deposit) date, or entered date.  The accounts receivable is generally run with an "as of" date.  The default is "as of now".  However, it is likely that the report will be generally run "as of" the end of the past month, past quarter, or past year.

 

The Accounts Receivable 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.

Print Totals Only

Print totals only with breaks

Print Patient Detail

Print patient-by-patient totals with sort totals

Print Charge Detail

Print charge-by-charge totals with patient totals and sort totals

Report AR Balances for Pending Claims

Indicates whether the report should Include, Exclude, or report Only balances for accounts with claims that have not filed due to Pending provider ID numbers.

Charge Date Type

Charge Date to examine:

Service
Posted
Closeout
Entered
Accounting
Accounting - Previous
Accounting - Current

Charge Ending Date

Charges after this date will be ignored

Payment Date Type

Payment Date to examine:

Remit Date
Posted Date
Closeout Date
Entered Date
Accounting
Accounting - Previous
Accounting - Current

Payment Ending Date

Payments after this date will be ignored.

Age of Final Aging Column (Over XXX)

Configures the report to define the last two aging columns on the report.  The first five columns will always report 0-30, 31-60, 61-90, 91-120, and 120-150.  The last two columns will be reported as follows:

180 - Report 151-180 and Over 180
360 - Report 151-360 and Over 360

Report Under Primary Plan

Report balances under the primary insurance plan (or Self) if the report is sorted by plan.

Report Under Current Plan

Report balances under the current insurance plan (or Self) if the report is sorted by plan.

Report Self Pay AR Balances

Indicates whether the report should Include, Exclude, or report Only self pay balances.  Selecting the Include option will include any accounts at the self-pay level in the report.  The Exclude option will not report any accounts without insurance, accounts with balances after insurance has paid, nor any accounts where the insurance is set to not wait for payment and the charges are at the self pay level.  The Only option will report only balances at the self pay level, whether they had insurance or not.

Report Billed Amount

Aging totals are based on the charge amount and any payments or adjustments applied.

Report Allowed Amount

Aging totals are based on the expected (allowed) amount.  Charges at the current level report the expected amount.  Charges not at the current level report the charge amount less actual payments and adjustments.

Credit Balance Accounts

Indicates how credit balance accounts are handled on the report.  Credit Balance Accounts can be Included in the report, Excluded from the report, or selected as the Only Accounts to be included in the report.

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.