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:
|
Charge Ending Date
|
Charges after this date will be ignored
|
Payment Date Type
|
Payment Date to examine:
|
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.
|