Finance | Project Operations, Human Resources, ...

Day wise trial balance sheet for across the all legal entities

(1) Share

Report

Posted on by Akkati Suresh

We have 40 legal entities, client have to submit daily bank reconciliation statement for all companies, they are asking bank closing balances everyday across all legal entities in single report.

in D365 we can't run TB across all legal entities, also we can't generate same in Management reporter.

please suggest is any why to get this done.

Akkati Suresh

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Ties Philippi 962 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Akkati,

You should be able to achieve this with management reporter ( or financial reporter nowadays), could you please tell us what problems you are running into when setting this up in MR?

Best regards

Ties

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Akkati,

I agree with Ties.

Why do you doubt that you cannot achieve this with the management reporter?

Best regards,

Ludwig

Was this reply helpful? Yes No
Akkati Suresh 25 on at

Like
a
(0)

Report
Copy link

Link copied!

In the management report it is don't allow me to run daywise balances, if it possible please share any documents

Was this reply helpful? Yes No
Akkati Suresh 25 on at

Like
a
(0)

Report
Copy link

Link copied!

In management reporters it doesn't allow me to run daywise balances, if I'm missing please share me the steps to get this done

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Akkati,

In the MR you have the option to define a start and end date for each of the columns that hold financial values. This allows you getting a 'daily' trial balance. Note: Those from and to date values do not have to be defined in an absolute manner but can also be defined relative so that you do not have to design the column structure new for each month. Would be great if you could give it a try and let us know if any other help is needed.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Ties Philippi 962 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Akkati

Like Ludwig said, there is ample documentation for this. An example;

stoneridgesoftware.com/.../

Best regards

Ties

Was this reply helpful? Yes No
Akkati Suresh 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank Lundwing,

I have tried this, in this feature some limitation are there, it is considering only specific day transactions, it doesn't gives as on day closing balance.

so i have to add two more columns to get the closing balance as on specific day, i have to set up this for 365 days.

We require a tool or any report to generate closing balances of 40 legal entities bank accounts.

Was this reply helpful? Yes No
Suggested answer

Ties Philippi 962 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Akkati,

What is the posting process at this company, because for this you could also just create a pretty simple setup (so not the setup I linked before) based on the Year to Date transactions.

So Row definition would be:

Bank account A

Bank account B

Bank account C

etc...

Column definition would be:

Legal Entity A | Legal Entity B | Legal Entity C | etc | Sum of all Legal Entities

Column setup for Periods Covered is YTD, and Legal Entity A to XYZ is set to NP for Print Control. In Sum of all Legal entities a range sum is added which would show all bank balances neatly in one column.

Depending on run time of the report (should not be too long) I would schedule the report to run at 23:45 daily. This would give you the closing balance of that day of the listed accounts (off course you could run it in the middle of the night as well, but it kind of feels more like an opening balance then :D).

Best regards,

Ties

Was this reply helpful? Yes No