Dynamics Community Forum Thread Details

Reconciling FA to GL

How can I reconcile my accumulated depreciation in FA versus in GL if there is an instance of Summarize Financial on old previous years. Client has mentioned that this discrepany has happened a few years back and are still unreconciled until to date.

The challenge is I am unable to trace where is the discrepancy from as the details of the FA activities has been removed as a result of running the Summarize Financial routine in FA

Thinking of removing all related data and uploading a new set of beginning balance based on a certain cut off. If going this pathway, what are the implications moving forward? Are there any implications on the Depreciation Expense account in GL?

Thank you in advance for your responses.

As you mention, the details are gone, so trying to rebuild them is next to impossible... But depending on how and when the Summarize was run, you still do have useful information available to you.

From the book, you have the values that you can compare to the details (including the summarized detail) to find the asset that is not reconciled correctly. This should be helpful...

The other approach is to break apart your reconciliation into the pre and post summarization points.

I am assuming there is no backup for the data before this routine was completed - That would just make this too simple.

To reconcile you look at each GL transaction amount in the GL and compare it to the FA tables - for post summarization - just to make sure all those are correct.

I hope this helps a little...

Good Luck...

Quick Links

Leaderboard