How do I determine if my A/R is in balance?
1. Run the Aged by Total report, choosing today's date to age against.
2. Run the Transaction Audit report, choosing from 01/01/80 thru today's date.
The aging report totals will look like this:
| Allow | 30 | 60 | 90 | Beyond 90 |
| 22.42 | 21.42 | 0.00 | 1.00 | 0.00 |
Note: The Allow amount includes tax.
The Transaction Audit totals will look like this:
| Claim Amount | Taxable Amt | Non-Allowed | Payments | Adjustments |
| 700.00 | 88.00 | 661.58 | 100.00 | -4.00 |
The formula to balance the reports is like this.....
Aging Allow = Audit Claim AMT + Tax - NonAllowed - Payments + Adjustments + Last
Months A/R
In this example it would look like this....
22.42 = 700.00 + 88.00 - 661.58 - 100.00 + (-4.00)
Your Accounts Receivable would be $22.42 and both reports balance to each other.