...

Guidelines to yearend procedures for IBM Cognos Controller Guideline

by user

on
Category: Documents
1

views

Report

Comments

Transcript

Guidelines to yearend procedures for IBM Cognos Controller Guideline
Guideline
Guidelines to yearend procedures
for IBM Cognos Controller
Product(s): IBM Cognos 8
Area of Interest: Financial Management
Guidelines to yearend procedures for IBM Cognos Controller
2
Copyright and Trademarks
Licensed Materials - Property of IBM.
© Copyright IBM Corp. 2009
IBM, the IBM logo, and Cognos are trademarks or registered trademarks of
International Business Machines Corp., registered in many jurisdictions worldwide.
Other product and service names might be trademarks of IBM or other companies. A
current list of IBM trademarks is available on the Web at
http://www.ibm.com/legal/copytrade.shtml
While every attempt has been made to ensure that the information in this document
is accurate and complete, some typographical errors or technical inaccuracies may
exist. IBM does not accept responsibility for any kind of loss resulting from the use of
information contained in this document. The information contained in this document
is subject to change without notice.
This document is maintained by the Best Practices, Product and Technology team.
You can send comments, suggestions, and additions to [email protected]
Adobe, the Adobe logo, PostScript, and the PostScript logo are either registered
trademarks or trademarks of Adobe Systems Incorporated in the United States,
and/or other countries.
Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft
Corporation in the United States, other countries, or both.
Guidelines to yearend procedures for IBM Cognos Controller
3
Contents
1
INTRODUCTION ............................................................................................ 4
1.1
1.2
1.3
PURPOSE ................................................................................................................ 4
APPLICABILITY ......................................................................................................... 4
EXCLUSIONS AND EXCEPTIONS ..................................................................................... 4
2
CREATING NEW SUBMISSIONS .................................................................... 4
2.1
CREATE NEW SUBMISSIONS FROM THE UPCOMING YEAR, FOR EACH PERIOD .............................. 4
3
MOVEMENT ACCOUNTS................................................................................. 6
3.1
FOR THE MOVEMENT ACCOUNTS, COPY THE CLOSING BALANCES INTO NEXT YEAR’S OPENING
BALANCES ........................................................................................................................... 6
4
COPYING OF JOURNALS ............................................................................... 7
4.1
COPY JOURNALS FROM PREVIOUS YEAR LAST PERIOD TO THE NEW YEAR FIRST PERIOD ................ 7
5
COPY HISTORICAL RATES ............................................................................ 9
6
LOCK THE YEAR ENDING PERIOD............................................................... 10
Guidelines to yearend procedures for IBM Cognos Controller
4
1 Introduction
1.1 Purpose
This document will provide information on handling year-end processes
within controller.
1.2 Applicability
Controller 8.1 or higher.
1.3 Exclusions and Exceptions
There are no known exclusion or exceptions at the time this document
was produced.
2 Creating New Submissions
2.1 Create new submissions from the upcoming year, for
each period
•
•
•
•
•
In Maintain/Submission/Define
Click Add row
Enter the new period (YYMM), actuality, Date and OB Actuality
If periods are divided into several submissions define what form set
to use for each submission.
Repeat for each period of the year (use expand button)
Guidelines to yearend procedures for IBM Cognos Controller
5
Guidelines to yearend procedures for IBM Cognos Controller
6
3 Movement Accounts
3.1 For the Movement Accounts, copy the closing balances
into next year’s Opening Balances
•
•
In Company/Copy-Opening Balances for Reported Values
Select Actuality, Period to copy to, enter the Top Level group and
check the Include Subgroups check box.
Guidelines to yearend procedures for IBM Cognos Controller
4 Copying of Journals
4.1 Copy journals from previous year last period to the
new year first period
•
•
In Company/Copy-Company Journals between periods
Select the companies and the period to copy from/to
7
Guidelines to yearend procedures for IBM Cognos Controller
•
8
Also for group journals, select Group/Copy/Group Journals between
periods
-NBWhen copying them you will get a question if you would like to transfer
copy without year ending rules: answer no. Base on this answer, for
the journal entries with movement accounts, Controller will replace the
movement account with the OB account.
Consider, Fixed, reversing and temporary journals, also consider which
journal types need copying, create a closing version including all
journal types that should be copied.
Guidelines to yearend procedures for IBM Cognos Controller
5 Copy historical rates
•
Select Group/Copy/Historical rates between periods
•
Select All companies and currency codes, select the from and to
period
9
Guidelines to yearend procedures for IBM Cognos Controller
6 Lock the year ending period
•
•
•
In Maintain/Period Locking/Change Multi-Period locking
Check the Lock check box for the previous year period
Ensure that the Unlock all period check box is unchecked.
10
Fly UP