Financial Analysis (GL vs Subledger)

(2) Share

Report

Posted on by KB-07011540-0

Looking to connect with someone or a company on approach to ledger financial analysis vs. subledger. We went live with D365 in October 2023, one of the changes we made was reducing the number of accounts we have in our chart of accounts and pushing analysis to subledger where we have more detail like project, procurement category/item, vendor etc. Prior to D365, we would bring subledger attributes, like project and PO number or other detail through to the GL and analyze everything from the GL. Our company is focused on the P&L and likes to start with the GL account. It continues to be a challenge and here is an example why:

1. We start with the GL but the amounts in that account could be a summation of GL entries, and subledger entries from purchasing and AP. People would have to combine three reports to get all the detail.

Looking to see what others do and if they have run into this.

Thanks!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (2)

Answers (0)

Gaurangkumar Jani 4,534 User Group Leader on at

Like (0)

Report

Hi there,

Let's connect on LinkedIn, I will try if I can help.

Thanks,

CA Gaurangkumar Jani

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 19,856 Most Valuable Professional on at

Like (0)

Report

Hı,

There are varıous ways to reconcile and report.

It depends on the parameters but you can use the Managemet Reporter(MR. Fınancıla Reports) or you can use the reconcılıatıon reports.

I always advıse to use dımensıons lıke customer/vendor etc for reportıng purposes as well rather than the GL accounts.

Was this reply helpful? Yes No