We're looking for an easier way to view our AR subledger detail. We're spending more time than desired during our AR-> GL reconciliation process due to the fact that the subledger transaction detail is not readily available at all times. Currently we have to run a receivables tie back report that takes ~2 hours plus to view our subledger detail. We have to run these reports by month before having the ability to look at the data and seeing where the AR subledger total is different form the GL total. After pulling all of the data, we must then merge it in an excel book, and create a pivot table to compare GL transaction detail and AR subledger detail to see where the accounts do not balance out. A very time consuming effort. Any thoughts?
