I am looking for 2 reports:
1. A report to tie the AA subledger to the General Ledger. In our company, we have several scenarios in which we post retirements/acquisitions with value dates in the past months and post it in the current period (which is open). This causes the balance on the subledger to change as of that value date, which is fine. However I cannot find a standard report to tie the balance to the sub-ledger. The report date on the standard report seems to pick up transactions in the subledger even if they have a future posting date. e.g. Report date 3/31 would pick up transactions that were posted with a value date of 3/15 but a posting date of 8/31. I need a report where I can pull balances by the Posting Date. The auditors need this to ensure that the sub-ledger and G/L are in sync. I am sure this is not an exceptional requirement. Can any one tell me how they handle this?
2. I need a depreciation comparison report where I can compare depreciations of each period in a year side by side. Something that would have all the 12 periods and the total depreciation for say an asset class.