Accounts Receivable Audit Report

 Top  Previous  Next

The Accounts Receivable Audit Report presents aged accounts receivable balances for all practices within a company (database).  It runs much like the Accounts Receivable Report.  However, you may define a series of "target" percentages of the aging break-down.  For example, you feel that 15%-25% of your receivable should be 0 to 30 days old and 20%-30% should be 31-60 days old, etc.  The percentages selected by a user the first time they run the report are remembered and filled in by the system the next time the anyone runs the report.  If different percentages are needed they will need to be updated the next time a user runs the report.  When the aging breakdown is performed, the percentage in any given aging category is within the target range, the amounts will print in black, if the percentage falls below the target range the amounts will print in green, and if the percentage is above the target range the amount will print in red.  In addition the report contains a column for "AR Days", which is calculated as follows: Total charges for last 90 days divided by 90 = Avg. charges per day.  AR Balance divided by Avg. charges per day = AR Days.  Total charges for the last 90 days is shown on the first column of the report.

 

 

The Accounts Receivable Audit Report 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

Report A/R 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 Date
•Posted Date
•Closeout Date
•Entered Date

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

Payment Ending Date

Payments after this date will be ignored

Target A/R Percentages

Enter the target A/R Percentages for each aging category.

Report Under Primary

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

Report Under Current

Report activity 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.

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 Task 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.