Working with Spreadsheet Payments and Direct Journals

The spreadsheet payment and direct journal upload process supports MicroSoft Excel input formats. If you use a non-Excel spreadsheet, you must convert the data to an Excel format before importing.

Spreadsheet Payments

When you import spreadsheet payments and they go through the edit process, the Payment Loader Application Engine process loads the payment data into the payment application tables.

The ExcelUploadforDeposits.xls workbook is the Microsoft Excel data input tool. You use it to prepare and enter payments and import them into your PeopleSoft database.

These worksheets make up the ExcelUploadforDeposits.xls workbook:

• Template worksheet: contains all of the available fields that you can configure for data entry. You enter the transaction data on the Data Sheet worksheet. You can create multiple versions of the Microsoft Excel workbook, each with different templates if required.

• Data Sheet worksheet: supports CHK, EFT, ACH, CC, GE and WIR payment methods.

• Import Log worksheet: to view the payment data logs.

Spreadsheet Direct Journals

The spreadsheet direct journal upload process enables you to enter a group of direct journals in spreadsheet format and upload in a batch.

Integration Broker loads the data from the excel spreadsheet into the excel payment upload tables on the application server. All editing is done in the existing application engine excel upload edit program (AR_EXCL_EDIT).

The edit program provides edits specifically for direct journals and applies ChartField inheritance and security rules. The process loads the data into the payment staging tables. If there are no edit errors, the Payment Load process moves the data from the payment staging tables to the deposit, payment and direct journal accounting entry tables. Any edit errors can be corrected by deleting the spreadsheet in the Excel Upload Error Correction component and making the corrections directly in the excel spreadsheet. After the correction, the data must be uploaded again.

The workbook, ExcelUploadforDirectJournalDeposits.xlsm, includes the deposit, payment and direct journal accounting entries. The template is similar to the existing template for excel payment upload but will include accounting entry lines for direct journals. The spreadsheet will only do format type editing and some fields are required such as business unit.