Joint Venture Distributions Spreadsheet Simplification

Manage joint venture distributions in a simplified spreadsheet. The spreadsheet includes a single worksheet that includes subledger accounting, general ledger, manual, and overhead transactions, as well as additional attributes for each distribution.

Manage Joint Venture Distributions spreadsheet with a single worksheet for subledger accounting, general ledger, manual, and overhead distributions

Joint Venture Distributions VB Excel consolidated into a single tab

New Attributes included in the spreadsheet::

Legal Entity
Source
Journal Number
Account Segments
Original Ownership Definition
Net Distributed Amounts
Expenditure Organization
Expenditure Business Unit
Expenditure Item Date
Stakeholder Reporting Ledger
Stakeholder Reporting Header ID
Stakeholder Reporting Date
Stakeholder Reporting Status

Business Benefit:

This improved spreadsheet helps reduce the time and effort required to review, analyze, audit, and update joint venture distributions.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

Access the new spreadsheet by clicking on the Manage in Excel button from the Joint Venture Distributions work area.

Joint Venture Distributions work area

Alternatively, the new spreadsheet can be accessed from the task Manage Joint Venture Distributions in Spreadsheet in the Functional Setup Manager under the Joint Venture Management functional area.
The previous spreadsheet that has the transactions in different worksheets based on the source (Subledger Distributions, General Ledger Distributions, Overhead Distributions, and Manual Distributions) is available from the task Manage Joint Venture Distributions by Source in Spreadsheet in the Functional Setup Manager under the Joint Venture Management functional area.

Key Resources

For more information, refer to:
- Implementing Joint Venture Management guide and
- Using Joint Venture Management guide.

Access Requirements

Joint Venture Accountant