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:
Note: The Allow amount includes tax.
The Transaction Audit totals will look like this:
|Claim Amount||Taxable Amt||Non-Allowed||Payments||Adjustments|
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.