Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Trial Balance

Hi Experts,

Trial Balance , Balance sheet an P & L Template.

What are basic and main scenario i need to know for creating above template.



Former Member
Former Member replied

Hi Karthi

When creating a report template, it is best to copy from the chart of accounts, as entering all the accounts and structures manually can be a lengthy process. To do this click on "Generate Chart of Account Template", and this will populate the template with the standard layout. Now you can move accounts to different titles by changing the "Parent Article" field or change the display sequence by choosing "Loc. on Tree".

You can also determine whether an account must be a liability or asset for balance sheet templates. To do this, click on an active account (not title) and select Transfer Accounts with Negative Sign. For example your bank account is an asset account, but you are in overdraft with the bank at the reporting date. This indicator will move it from assets to the specified Group and title under liabilities.

You can also use the Dummy title and Hide Accounts functions to simplify the layout of the report, or simply hide accounts you don't want displayed. When you run a financial report, you automatically get a level 1 to 5 display selection. When you expand to level 5 for example, you get all the titles repeated, making the report longer. By hiding these titles the report will be shorter and easier to read on screen.

You can create as many templates for each report as you need, and each user can choose his or her layout when running the report by changing from Chart of Accounts to Template Name.

Let me know if you need more details.

Kind regards

Peter Juby

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question