Months End Accounts Receivable Roll Forward "Closing Statement":
This spreadsheet tracks all financial transactions by call type including revenue posted cash, discounts, deductibles, and refunds. This spreadsheet also calculates what the current AR aging report balance should be. The spreadsheet balance and the AR aging balance are compared and the difference is calculated as a variance. We also provide a cell in which a calculated DSO (days sales outstanding) number is presented. The method used to calculate the DSO is an exhaustion method.