Suggestion Required - Balance Sheet
Suggestion Required - Balance Sheet
Dear All,
I think this will be an interesting issue for everyone of us. Little confusing and tricky but need some suggestions
Its for a real estate industry, in which we have company as the balancing segment. and a segment for project also involves India localization also. there are more than 100 companies for the company segment and as of now there are few number of projects which will be increasing in the near future.
Requirement is Balance sheet or any financial statements based on the project wise where my secondary tracking segment is not enabled.
Issue we have is only in the procure to pay cycle where we are not able to track the liabilities details as per the project code and whatever is in the tax set up defaults in the TDS and other taxes....
Modules used are - Finance, distribution and property manager
Can anyone suggest a solution for this to take it forward as per the requirement.
I expect some very strong and good suggestion from the guru's who have done some implementations in Real estate industry and your earliest suggestions are highly appreciated.[:(]
Regards,
Anu
I think this will be an interesting issue for everyone of us. Little confusing and tricky but need some suggestions
Its for a real estate industry, in which we have company as the balancing segment. and a segment for project also involves India localization also. there are more than 100 companies for the company segment and as of now there are few number of projects which will be increasing in the near future.
Requirement is Balance sheet or any financial statements based on the project wise where my secondary tracking segment is not enabled.
Issue we have is only in the procure to pay cycle where we are not able to track the liabilities details as per the project code and whatever is in the tax set up defaults in the TDS and other taxes....
Modules used are - Finance, distribution and property manager
Can anyone suggest a solution for this to take it forward as per the requirement.
I expect some very strong and good suggestion from the guru's who have done some implementations in Real estate industry and your earliest suggestions are highly appreciated.[:(]
Regards,
Anu
Hi Anu,
If u have defined project as segment in AFF then there should be no problem as u can get project wise T/B from GL and go for FSG & customized P & L and B/S reports.
Our client almost have the same AFF with co, and project segments etc. and get all liabilities, assets etc. details and fulfill reports requirements using FSG and customized reports from GL module.
Regards,
Aman
If u have defined project as segment in AFF then there should be no problem as u can get project wise T/B from GL and go for FSG & customized P & L and B/S reports.
Our client almost have the same AFF with co, and project segments etc. and get all liabilities, assets etc. details and fulfill reports requirements using FSG and customized reports from GL module.
Regards,
Aman
Hi Admin,
Need some more explanations on it. See my Project Segment is not a balancing segment and Company is the balancing segment and we would like to have all the financial information's out of the system project wise.
So as we can conclude it and I want some more data like how do we do and how we are going to satisfy the requirements. with OU I will be able to do the localization set ups also and the charges account will be based on my project and liability account will default from set up's where as if i dont create the Ou and if i do in single Ou for Multiple projects, there is a possibility of users entering it to the wrong project codes and its very difficult for the users to identify the mistake and time consuming to correct the same.
<b>
Please lets debate on this [?] to some more level so as even a beginner will understand.</b>
If you want I will give my COA structure
Company-LOB-Dept-Account-Sub-A/c-Project-Fut1-Fut2
Where Flexfield Qualifiers are
Company is the Balancing Segment & Intercompany,
Dept - is the Cost Center
Account - Natural Account Segment and Sub - Account is the Dependent Segment of Account.
Regards,
Uma
Need some more explanations on it. See my Project Segment is not a balancing segment and Company is the balancing segment and we would like to have all the financial information's out of the system project wise.
So as we can conclude it and I want some more data like how do we do and how we are going to satisfy the requirements. with OU I will be able to do the localization set ups also and the charges account will be based on my project and liability account will default from set up's where as if i dont create the Ou and if i do in single Ou for Multiple projects, there is a possibility of users entering it to the wrong project codes and its very difficult for the users to identify the mistake and time consuming to correct the same.
<b>
Please lets debate on this [?] to some more level so as even a beginner will understand.</b>
If you want I will give my COA structure
Company-LOB-Dept-Account-Sub-A/c-Project-Fut1-Fut2
Where Flexfield Qualifiers are
Company is the Balancing Segment & Intercompany,
Dept - is the Cost Center
Account - Natural Account Segment and Sub - Account is the Dependent Segment of Account.
Regards,
Uma
-
- Posts: 256
- Joined: Thu Aug 07, 2008 3:48 am
- Location: USA
Uma
There are two ways of Approach.
Scenario 1
If the customer wants Project wise TB, Balance Sheet & Profit / Loss Account. Consider the company carrying multiple projects and Scope is limited to the implementation of Financial and Property.
That s a case, Each Projects should be balancing segment hence reporting is possible either at Child Level or at Parent Level.
If the Project treated as a separate Segment in AFF, then Report of Profit & Loss is possible, however we will not able to generate a Project wise Balance Sheet. (Required for Banking Purpose)
Take an example of two projects are carrying under one company and these two projects are being funded by that company from its common pool, the entry will be,
Company ? LOB ? Common Project- Sub-Accounts (Common Project) -Fut1 ? Fut2 for receiving fund and Distribution entry to each project shall be from the common Account.
Here we cannot generate the Balance sheet for each project since the project is not balanced as such, however we can generate un-reconciled report such as a cash flows to the management.
Scenario 2
If the Project is going to be an OU (Required only when each project is going to be self reliant, the project is being funded by Shareholders to that project, there are more than one Project partners are involved and Projects are kept to be sold fully or partly ( Leasing and Selling or Both).
There is no report available to take by OU as such; nevertheless one Ledger is part of OU.
the sceanrio is only a suggestion and it varies case to case
Babu Venattu Ali
There are two ways of Approach.
Scenario 1
If the customer wants Project wise TB, Balance Sheet & Profit / Loss Account. Consider the company carrying multiple projects and Scope is limited to the implementation of Financial and Property.
That s a case, Each Projects should be balancing segment hence reporting is possible either at Child Level or at Parent Level.
If the Project treated as a separate Segment in AFF, then Report of Profit & Loss is possible, however we will not able to generate a Project wise Balance Sheet. (Required for Banking Purpose)
Take an example of two projects are carrying under one company and these two projects are being funded by that company from its common pool, the entry will be,
Company ? LOB ? Common Project- Sub-Accounts (Common Project) -Fut1 ? Fut2 for receiving fund and Distribution entry to each project shall be from the common Account.
Here we cannot generate the Balance sheet for each project since the project is not balanced as such, however we can generate un-reconciled report such as a cash flows to the management.
Scenario 2
If the Project is going to be an OU (Required only when each project is going to be self reliant, the project is being funded by Shareholders to that project, there are more than one Project partners are involved and Projects are kept to be sold fully or partly ( Leasing and Selling or Both).
There is no report available to take by OU as such; nevertheless one Ledger is part of OU.
the sceanrio is only a suggestion and it varies case to case
Babu Venattu Ali
Hi Babu,
Thanks for the update, and almost this is what is the explanation i expected in this forum... I agree with your contents.
I prefer to go on with the approach 2 as it will not allow the users to enter the tax code details... whenever we enter an invoice or make payments, we can track both the charges and liabilities based on each project.
What is ur comment on this ?
Regards,
Anu
Thanks for the update, and almost this is what is the explanation i expected in this forum... I agree with your contents.
I prefer to go on with the approach 2 as it will not allow the users to enter the tax code details... whenever we enter an invoice or make payments, we can track both the charges and liabilities based on each project.
What is ur comment on this ?
Regards,
Anu
Hi Anu
As you mentioned in the reply, the Tax Code details cannot be entered in Payable module directly and it should come through the PO only.
Since project is linked to a PO we can track the Charge account and Liability Account by project wise. (Assuming that PO item will be charged as direct expense as Destination is Expenses).
Why Project Suites left out in your implmentation[:0]
Regards
Babu Venattu Ali
As you mentioned in the reply, the Tax Code details cannot be entered in Payable module directly and it should come through the PO only.
Since project is linked to a PO we can track the Charge account and Liability Account by project wise. (Assuming that PO item will be charged as direct expense as Destination is Expenses).
Why Project Suites left out in your implmentation[:0]
Regards
Babu Venattu Ali
Who is online
Users browsing this forum: No registered users and 7 guests