Small and medium business | Business Central, N...

Income statement report

(7) Share

Report

Posted on by Honey98

290

Hi Team,

I'm running the income statement report where it shows me blank and all the data has been posted in the system. Can anyone tell me where am I doing wrong why it's coming blank?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Dhiren Nagar 2,530 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Check following setups.

1- Accounting period. Make sure accounting periods are defined correctly.

2- Check if G/L Account have Account Category defined properly.

3- Check if the period for which you have applied data filter has any transactions posted in it.

I hope this helps.

Regards,

Dhiren.

Was this reply helpful? Yes No
Suggested answer

Sathish M. 18 on at

Like (0)

Report
Copy link

Link copied!

Hi,
In the Accounting Periods, you may not define the new fiscal year. Once you define it in the Accounting Periods, you will get the correct output in the report.

Please find the screenshot for your reference.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,840 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Navigate to the Financial Statement and make sure the Row Definitions and Column Definitions are correct.

This pulls the data from Financial Statement configuration and if the setup and line column definition wont fall in place then it wont show the data.

Once this is good check the filters applied.

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 9,106 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi,

Blank income statement in BC usually points to a setup issue rather than missing data. Even if transactions are posted, the report won’t show anything unless the account schedule and filters are aligned.

Here’s what to check:

Account Schedule Setup
The income statement pulls data from an Account Schedule, not directly from the G/L.
Go to Account Schedules and open the one linked to your report.
Confirm that:

Rows are defined with valid Totaling formulas (e.g., 4..9 for income accounts)

Each row has a Row Type (e.g., Net Change, Balance at Date)

The schedule is assigned to the correct Column Layout

Column Layout Configuration
Open the Column Layouts page and check the layout used in your report.
Make sure:

The Date Filter is set correctly

The Column Type is appropriate (e.g., Net Change, Balance)

The Show Column field is enabled

Date Filter on Report Request Page
When running the report, check the Date Filter field.
If the filter doesn’t match your fiscal period or posted entries, the report will return blank.
Try removing the filter or setting it to a broader range (e.g., 01/01/2025..12/31/2025)

G/L Account Assignment
If your G/L accounts are not included in the totaling formulas of the account schedule, they won’t appear.
Review your chart of accounts and confirm that income and expense accounts are covered.

Posting Groups and Dimensions
If you’re using dimensions or custom posting groups, make sure the account schedule includes them.
Use the Filter fields to include relevant dimensions (e.g., Department, Project)

Helpful Reference
Design financial reports using account schedules
Troubleshooting blank financial reports
Solved: Can't See Financial Statements

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 97,897 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, It looks like the same question.

Income Statement Report Not Showing Data in Business Central

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 21,573 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hope this helps: https://community.dynamics.com/forums/thread/details/?threadid=ec14af02-edc8-45d3-8fd4-4298e108f4f1

https://learn.microsoft.com/en-us/dynamics365/business-central/bi-troubleshoot-financial-reports

https://learn.microsoft.com/en-us/dynamics365/business-central/finance-financial-reporting-view-a-report

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 10,862 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello ,

This usually happens when your G/L Accounts aren’t included correctly in the Account Schedule setup used by the Income Statement. Even if data is posted, the report will be blank if (a) the G/L accounts don’t have Income Statement as their Account Category / Account Type, (b) the accounts aren’t mapped to the correct Account Schedule lines, or (c) the report is run with a date range that doesn’t match the posting dates or fiscal year setup. Also double-check that the Income/COGS/Expense accounts are not blocked, and that the Account Schedule column is using Net Change, not Balance at Date. In most cases, the root cause is missing or incorrect Account Schedule line definitions, not missing postings.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No