web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

Financial Report Formatting

(1) ShareShare
ReportReport
Posted on by 1,302

Is there any way to update the format of the financial statements (balance sheet, income statement, etc..) so the excel version of the reports (when you export) are more appealing?

  • Suggested answer
    Mustufa Shehreyar Profile Picture
    1,070 on at

    @rcboiler: can you elaborate what you mean by more appealing?

    If it's just the format or column or row positioning, you can use account schedules to create custom financial statements.

  • rcboiler Profile Picture
    1,302 on at

    The excel output for this report is not formatted very well - namely wasted (empty) lines that make the report very difficult to use.  The PDF format is acceptable.

  • Suggested answer
    Mustufa Shehreyar Profile Picture
    1,070 on at

    @rcboiler: As I mentioned before the format is in your hands. i.e. the column and row definitions, in addition to these you have a column named "Show" which can be used to control what fields are shown/hidden on the report.

  • Suggested answer
    Mustufa Shehreyar Profile Picture
    1,070 on at

    I forgot to mention one thing when you edit in excel you will see some extra lines, but when you will print to excel you wont see those extra lines.

  • rcboiler Profile Picture
    1,302 on at

    We must be looking at different reports.  The output (Send To: excel) results look very bad.

  • Mustufa Shehreyar Profile Picture
    1,070 on at

    are you looking at the standard out of box financial statements or is it something you designed yourself? in my case I designed them myself as the standard ones didn't fulfill my client's requirement.

  • Randy Howard Profile Picture
    5 on at

    100% agree!  I have tried building multiple variations of balance sheet reports and income statements and every time it adds blank rows below each row when printing to excel.  Even if the account schedule has the Row No of 1,2,3,4.   It also outputs all of the numbers stored as text which makes it impossible to do any analysis in excel.  And you cant easily convert these via Text to Columns because Business Central reports merge so many different random cells.  One column will be merged but the next will not.  

  • Suggested answer
    Community Member Profile Picture
    on at

    Hello,

    I create some nice Account Schedules with good spacing so I can export to Excel. However, nothing is perfect so I would recommend, as I do for my customers, you use Jet Reports. It is easier and your formatting meets your needs. You get sample B/S and I/S to work with and you are up and running in a few hours.

    pastedimage1630700549694v1.png

    Thanks,

    Steve

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans