Following versions of Balance Sheet and Income Statement reports are available:

  • BALANS-DEF – Balance Sheet overview
  • BALANS-DET – Balance Sheet Detailed (with G/L accounts listed)
  • RESULT-DEF – Income Statement overview
  • RESULT-DET – Income Statement Detailed (with G/L accounts listed)

After a new G/L account is created in Business Central you need to add it in Balance Sheet or Income Statement Reports.

In Searchbox type Account schedules and then choose the related link

1.png

Adding G/L account in Balance Sheet Detailed report

When you open Account Schedule list mark BALANS-DET report

Select Process/Edit Account Schedule

2.png

Where you will place G/L account depends of G/L account number and the column “Totaling” e.g.

20* means this row includes G/L accounts starting with 20 => from 200000 to 209999

285*..289* includes G/L accounts starting with 285 till accounts starting with 289 => from 285000 to 288999

440*|442*..445* includes G/L accounts starting with 440 or G/L accounts starting with 442 till G/L accounts starting with 445 => from 440000 to 440999 or from 442000 to 444999

Example: Adding G/L account 400000

– Select line Handelsvorderingen, with Totaling 40*

3.png

– On the top of the page select Insert/Insert G/L Accounts…

4.png

– In G/L Account List select the G/L Account you want to add, in this example 400000

– G/L Account is now added

– You need to add G/L Account number in Description field

5.png

              G/L Account added

6.png

         G/L Account Number added in Description field

– Select line with added G/L Account and on the upper menu select Process/Indent until it is aligned with all the other G/L Accounts listed

7.png

Adding G/L account in Income Statement Detailed report

When you open Account Schedule page mark RESULT-DET report

Select Process/Edit Account Schedule

8.png

Select the line where you are adding G/L Account

On the upper menu select Insert/Insert G/L Accounts…

9.png

– In G/L Account List select the G/L Account you want to add

– G/L Account is now added and you need to type its number in Description field

– Select line with added G/L Account and on the upper menu select Process/Indent until it is aligned with all the other G/L Accounts listed

– When you have added G/L Account in Income Statement make sure you have checked following:

  • for added G/L Accounts in column Show choose “If Any Column Not Zero”

10.png

  • for added Income G/L Accounts (starting with 7*) check Column “Show Opposite Sign”

11.png

Tags: