Spreadsheet Voucher Processing

The Spreadsheet Voucher workbook lets you enter vouchers offline using Microsoft Excel and then import the vouchers into your PeopleSoft database. It supports regular voucher additions. Once you import the spreadsheet vouchers, the Voucher Build Application Engine process (AP_VCHRBLD) builds and edits the vouchers.

Note:

The spreadsheet voucher process supports Microsoft Excel formats as input. If you use a non-Excel spreadsheet, you must convert the data file to a Microsoft Excel format before importing.

PeopleSoft Voucher Workbook: ExcelUploadforVoucher.xls

The ExcelUploadforVoucher.xls workbook is the PeopleSoft Spreadsheet Voucher Import user interface. You use it to prepare and enter vouchers and import them into your PeopleSoft database.

The ExcelUploadforVoucher.xls workbook contains two worksheets, the Template worksheet and the Data Sheet worksheet. The Template worksheet contains all of the available fields that you can configure for data entry. You can configure the spreadsheet for simple one line express vouchers to complex multiple line purchase order (PO) related vouchers. You enter the transaction data on the Data Sheet worksheet. You can create multiple versions of the Microsoft Excel spreadsheet, all with different templates if required.

Logs are populated in the vchrlog sheet of the Excel Upload for Voucher workbook. Logs being written to the same Excel sheet allows users to use the voucher workbook from any folder or share folders without any access restrictions.

Note:

Users uploading vouchers with Microsoft Excel 2007 must use the file with the .xlsm file type.

Note:

Currently, ExcelUploadforVoucher.xls spreadsheet upload is not supported on macOS.