Great, thank you.

Is it true also that if I run a customer transaction listing in AR for all customers and all transaction types for a month, this should be the same as the net change to my control account in the GL for that month? (that seems to be the case but I want to confirm).

Also, when I ran a customer transaction listing (Current and Historical Trans by Date) and selected all transaction types for the fiscal year, the total of this report is different from the change in Aged AR Trial balance from one year end date to the other. I would have expected that the total customer transactions for the period should equal the net change in AR trial balance for the period - any ideas why they would not match?

Specific details:

A - AR trial balance - calculated as of March 31, 2008 = 43,215.17
B - AR trial balance - calculated as of March 31, 2009 = 73468.49
Net change in AR trial balance fiscal 2008/09 (difference between A and B above) = 30,253.32 (increase in AR balance)

Customer Transactions (Current and historical) for all customers and all transaction types from April 1/08 through Mar 31/09 = $-34590.73 (original amount - decrease) and $49371.57 (current amount - increase). I would have expected that the total customer transactions for the period ($-34590.73)should have equalled the change in AR trial balance for that period (30,253.32). Based on the customer transaction totals, it would seem that my AR should have decreased by 34590.73 whereas per the aged TB it actually increased by 30253.32. What am I missing??

Also, am I correct in using the original transaction amount rather than the current amount? My understanding is that the current amount is the amount that is still unapplied, therefore if a transaction was posted as $375, with 100 applied, the original amount is $375 and the current amount is $275 - is that correct?

Thanks! PS..... love the picture!