Overview
Purpose
This report analyzes monthly transactions for a 13 month accounting range.
This itemized report summarizes the monthly transaction activity of AR and Non-AR transactions. Use this report to compare the totals in active AR for the current month/current year to date with the same month of the previous year/previous year to date.
Category
Financial
Type
Summary
Mode
Accounting
Output Options
Update
Sample Report
(Click the image to enlarge)
Field Definitions
Field | Calculation Formula | Description |
|---|---|---|
| Beginning Balance | UPDATE | |
| Charges Billed | ||
| Cases | ||
| Procedures | ||
| Anesthesia Units | Billed Total Units * Accounting Status | |
| RVU - Work | RVU - (Work * Accounting Status) | |
| Total Expected | Expected * Accounting Status | |
| Payments - Line Items | ||
| Payments - On-Account | ||
| Contractual Write-off | ||
| Insurance Withhold | ||
| Refunds from AR | ||
| Adjustments - Misc | ||
| External Collections | ||
| Net Activity | ||
| Ending Balance | ||
| Payments - Suspense | ||
| Payments - Misc Income | ||
| Refunds Suspense - Misc Income | ||
| Beginning Balance - Ext Coll | ||
| Payments - Ext Coll | ||
| Adjustments - Ext Coll | ||
| Transfers - Ext Coll | ||
| Ending Balance - Ext Coll | ||
| Avg Daily Charges | Charges Billed / Days in Month | |
| Avg Charge/Case | Charges Billed / Cases | |
| Avg Charge/Procedure | Charges Billed / Procedures | |
| Avg Daily Payments | [Sum of Payments - All (Line Items, On-Account, Suspense, Misc Income, Ext Coll)] / Days in Month | |
| Avg Payment/Case | (Payments - Line Items) / Cases | |
| Avg Payment/Procedure | (Payments - Line Items) / Procedures | |
| Gross Collection % | [(Payments - Refunds) * 100] / Billed Charges | |
| Net Collection % | ||
| Bad Debt % | External Collections / Charges Billed | |
| Days in A/R |
Available Report Filters
Option | Type | Required | Description |
|---|---|---|---|
| UPDATE |