In order to balance the ledger to the customer aged summary report you have to check several items. 1) You may have moved a client to an inactive status and they may have had a balance owing. 2) The customer aged report makes up 2 ledger accounts: the linked accounts receivable account and the prepaid sales/deposit account. 3) When running the customer aged report ensure you have the proper dating for the report, have included all clients and lastly ensure you are using the default template rather than the last used report options template.

For the data inconsistencies with the account reconciliation I would assume the ledger balance is different than the amount in the reconciliation module when it was setup. I will need more info on the message you received saying there were data inconsistencies and more info on the account reconciliation and your ledger to truly answer your question.

Hope this helps!

I tried all your suggestions on the A/R issue and I keep getting all the same amount differences.  

As for the account reconciliation issue, the message I am getting is "Data inconsistences have been detected" and there is a * in the total credits section at the bottom of the report.

Have you ever unlinked the A/R account? If you have, you may have items in the ledger which may not be in the aged A/R. My last suggestion is are you using the 1st menu item when you pull up Reports then A/R, then Aged A/R (do not use the 2nd menu item for the actual aged A/R; it only shows what is outstanding due from the customer as of the date shown) .

For the account reconciliation issue I would have to look at your data to determine what the problem is. Unfortunately, I charge for this service.

Hope this helps!