Problem in Report Templetes of User defined COA

[Former Member]

Hi

I have user defined Chart of Account.That means i have to prepare templetes for each reports such as Balance sheet, P/L statement, trial balance.But im not able to get how to prepare it.There is option of just naming the titles and active accounts.

1.what name to give them.upto how much level we have to make

that templete?upto last level or upto title accounts(second last level)?

2.how these names will link with codes of title accounts or others in Chart of account?

Means how it will fetch the value on what basis?as we cant give G/L code.

Im preparing first time templete of user defined COA.so please give solution in detail.

Thanks

[Former Member]

Hi

I am not sure .Why do you think you need to create all ?

SAP default report should be fine for user defined too.Unless you donot like the structure you can use financial report template to create your own . Please check this thread if you need to create your own .

Thank you

Bishal

[Former Member]

In user defined COA there is no standard report.

[Former Member]

Hi Krishna,

The simplest way to create Financial Report Templates is to give a name to each template and click on the "Generate Chart of Accounts Template" button available in the lower right hand screen. This will create the template in the same order of the Chart of Accounts.

If you want to have your financial report in a format very different form you Chart of Accounts, then you can customise the Financial template. For this you need to link the Active accounts and this is possible only at level 4 (the lowest level) of the template. You need to create chicld accounst upto level 4 and then double click on it or right mouse click and you'll find a link for "Account Category -Details". This is where you need to link up your Active accounts.

One good practice is to leave the Show missing accounts check box ticked - this will show any account which are missed out in your template when you actually generate the report.

Hope the explanation helps.

Regards,

Hamsa

[Former Member]

It is same for all three reports i.e P/L , Trial Balance, balance sheet?

or there is some diffrence b/w them?

Thanks

[Former Member]

These 3 reports have different report layouts. They will be different. However, Balance Sheet and Trial Balance are alike.

[Former Member]

Hi Krishna,

The Template creation logic is the same for all 3 reports except for TB, there pre-exists a default template and there is no check for missing accounts for TB.

Regards,

Hamsa

[Former Member]

Define CoA should be accountants' duty. All businesses can have their own CoA to fit their special accounting process.

To answer your question:

1. Name must reflect what the accounts purposes are. As for how much levels, that all depends on their needs. There are no clear cut here.

2. Not sure what you mean. Please ask one question in one post to make the reply easier.

Thanks,

Gordon

[Former Member]

the COA has been prepared by the accountant.now only report templetes are left.i know name reflects the purpose for which account is made.i will give

the name as it was in COA in the report temp.do i have to mention only title accounts in the template or also the active accounts?

Thanks

[Former Member]

How these names in the report template will be effected because there is no link of these names in the report template with the accounts in the COA on which effect is taking place.

[Former Member]

Yes. You only need the title account. No need and not possible to include active account. The later can be showed on the report because they are on the sub level of title accounts.