Finance | Project Operations, Human Resources, ...

Customize the Excel report generated from "Trail Balance Snapshot"

(1) Share

Report

Posted on by MB-06120911-0

Hello,
Thanks for reading this long post.

I need 03 help, meaning I have a total of 03 questions.
1. How to add Excel columns in the report generated from "Trail Balance Snapshot"?
2. Without downloading the report from D365, if I refresh the "Dynamic Excel add-in", will the report be updated directly in Excel?
3. If I close the "Dynamic 365 Add-ins" in Excel, how can I get the left menu again?

Question 01: How to add Excel columns in the report generated from "Trail Balance Snapshot"?

I am trying to download the Trial Balance for multiple ledgers in one Excel file.

Previously, I downloaded the report from the section "Options"

I follow these steps to get the excel report.

After downloading the Excel report, I am getting the report as below.

Now, when I am downloading the Excel report from "Trail Balance Snapshot", I am getting all the ledger information in one Excel. This is great.

But the problem is that in this report, some columns that were generated in trail balance (highlighted with a red box in the above Excel sheet picture) are missing in this snapshot report.

1. Name
2. Opening balance - Reporting currency
3. Debit - Reporting currency
4. Credit - Reporting currency
5. Ending balance - Reporting currency

From "Trail Balance Snapshot" option, I am following these steps to download the report.

The Excel snapshot below is from "Trail Balance Snapshot". And here you can see 05 columns (highlighted with a red box in the above Excel sheet picture) are missing in the "Trail Balance snapshot" report.

How can I get the missing Columns in the report generated by "Trail Balance Snapshot"?

Question 02: Without downloading the report from D365, if I refresh the "Dynamic Excel add-in", will the report be updated directly in Excel?
If I click on this refresh button, will the report be updated automatically?

Question 03: If I close the "Dynamics 365 Add-ins" in Excel, how can I get the left menu again?

If I close this right menu, then how can I get this menu again?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (7)

Answers (0)

Sort by

André Arnaud de Cal... 303,988 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Moved the question from the FastTrack to the Dynamics 365 Finance forum.

Was this reply helpful? Yes No
André Arnaud de Cal... 303,988 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you please explain the exact navigation steps how you download the information in Excel? You mentioned that you previously downloaded it from the options, but there is no feature on the options for generating an Excel file.

Was this reply helpful? Yes No
MB-06120911-0 4 on at

Like (0)

Report
Copy link

Link copied!

I follow these steps-
1. General Ledger > Inquiries and reports > Trail balance

2. Input the Date range

3. Click on the Calculate balances

4. Click on the "Office Button" in the top right corner marked with a red arrow sign.

5. From "Export to Excel", Click on "Trail balance"

Can you please help to advise regarding questions 02 and 03? Thanks.

Was this reply helpful? Yes No
Suggested answer

Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

"Export to excel" is native functionality in Dynamics that is available on every form and it simply export the current view (columns/rows) as those appear in UI.

if you want some extra rows or a format of your choice you have a few options.

1) use "Open in Excel"

2) Use "Data Import Export Framework"

Was this reply helpful? Yes No
Diego Mancassola 777 on at

Like (0)

Report
Copy link

Link copied!

Hello, these my answer to your questions:

1. How to add Excel columns in the report generated from "Trail Balance Snapshot"? > You have to customize table and class LedgerTrialBalanceFiscalYearSnapshotController

2. Without downloading the report from D365, if I refresh the "Dynamic Excel add-in", will the report be updated directly in Excel?

No, the data is only to consult it not for refreshing

3. If I close the "Dynamic 365 Add-ins" in Excel, how can I get the left menu again?

On Insert > My Add-ins > Duble Click on Microsoft Dyamics addin to open it again

Official documentation here: https://learn.microsoft.com/en-us/dynamics365/finance/general-ledger/general-ledger-account-balances

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 303,988 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks for the clarification. The Options tab was confusing. Export to Excel was sufficient to mention. To add columns when using this task, the grid in Dynamics 365 should be extended with more columns, as mentioned by Sohaib.

Coming back to your questions:

1) For the snapshot and Open in Excel, this depends on the columns available in the snapshot table and data entity. As mentioned by Diego, this requires a customization.

2) As mentioned by Diego, it is rereading the data from Dynamics 365. It will not trigger the recreation of the snapshot data.

3) Depending on your version, there is another place to open the Excel add-in. See the screenshot below where I found the option to open the add-in again.

Home > Add-ins > Microsoft...

Was this reply helpful? Yes No
Suggested answer

Giorgio Bonacorsi 2,232 on at

Like (1)

Report
Copy link

Link copied!
Hello,

The trial balance is not integrated with the Excel add-in. Which columns would you like to add?
The columns currently displayed are those configured in the selected financial dimension set.

Otherwise, here are four alternative paths to create a custom trial balance:

Financial report (easy): Build reports based on your GL needs. Typically used for trial balance reclassification, statutory reporting, or consolidation. https://www.youtube.com/watch?v=AItgn_YIBkg

Business performance analysis (complex): Combine Financial Reports with Power BI. Use forms + Power BI capabilities. https://www.youtube.com/watch?v=gj0geD3VO7E

Cost accounting (complex): Use cost accounting reports if you need to combine financial and statistical data.

Power BI (complex): Export transactions to Power BI and perform your calculations. Leverage existing cubes where available.

Thank you,

Giorgio

Was this reply helpful? Yes No