Understanding Spreadsheet Journal Import

This table lists the file that PeopleSoft provides for the spreadsheet journal import user interface.

In addition to this file, the Microsoft XML library file, MSXML6.DLL, must be installed on your workstation. This file is delivered as part of the shared features for Microsoft Office. Microsoft Office must be configured to use Visual Basic.

You must set up Microsoft Excel to accept macros, by navigating to select Tools, then select Macro, then select Security, then select and selecting Medium or Low on the Security Level tab.

To import journals from the spreadsheet, your system administrator must grant you permission to the following web libraries:

• WEBLIB_SOAPTOCI

• WEBLIB_GC

The ExcelToCI-GC.xls workbook enables you to enter journals using Microsoft Excel and then import the journals into your PeopleSoft EPM database. Integration between the workbook and Peoplesoft Global Consolidations is accomplished by using the GC_JOURNAL_ENTRY component interface. You use the ExcelToCI-GC.xls workbook to prepare and enter journals, group and manage journals in journal sheets, and import them into PeopleSoft Global Consolidations (GC) using various pages, dialog boxes, and buttons. The workbook contains one or more journal sheets, and each journal sheet can contain one journal. You can use the worksheet for both manual and recurring journals.

The first time you open the ExcelToCI-GC.xls file, you access the Home page. The Home page contains buttons that enable you to:

• Define connection parameters to enable communication with the PeopleSoft EPM database.

• Map the Global Consolidation ledger template fields to the worksheet.

• Define journal defaults.

• Edit, copy, delete and create new journal worksheets.

• Import journal worksheets into Global Consolidations.

• Review messages about the import process.

You use the Journal Sheet page to enter a journal. The layout of the journal header fields and journal lines are built based on the mappings you define when you map the Global Consolidation ledger template fields to the worksheet. You insert rows to include additional journal lines. Once the journal is complete, you click the Import button to import the journal.

After you import a journal, you must run the Journal Post process in Global Consolidations to edit and post the journal.