|
|
Charge, Collection and Accounts Receivable Analysis Tool
Martin R. Hudson, CPA MedicalGPS, LLC
PRICE: 69.95
Type of Product: Download
The Charge, Collection and Accounts Receivable Analysis tool calculates various percentages: adjustments and bad debts to gross charges, collections to gross charges, collections to net revenue, days of revenue in A/R, along with many other comparisons and ratios. These calculations allow the Financial or Business Manager to understand trends, set goals and expectations of revenue and cash collections, and better manage the organizations accounts receivable.
Click Here to View the Tutorial
- Provides current and twelve month average account activity analysis.
- Collections vs. Gross Charges and Net Revenue.
- Contractual Adjustments and Bad Debts vs. Gross Charges.
- Net Revenue vs. Gross Charges.
- Days in Accounts Receivable.
- The Charge, Collection and Accounts Receivable Analysis tool is an excel template and requires Microsoft Excel 2000 or newer.
Click the image to see a larger version.
|