Payment Spreadsheet Upload

Overview

Payment Spreadsheet Upload may be used by authorized users to manually upload spreadsheets into PDP for processing. This functionality supports quickly processing multiple payments without having to create vendor or payee records. Payee information is masked to unauthorized users. 

Uploading a spreadsheet

•  Select Payment Spreadsheet Upload. 

• Click the Choose File button. Navigate to the file you want to upload and click Open.
•  Enter a file identifier that is up to 9 characters in length. This entry is a unique identifier for your file.
•  Click the Add button to upload the file to PDP.
  • If PDP detects a problem that prevents an upload of the file, the system displays an error message.
  • If the upload is successful, the page displays a message indicating that the file was successfully saved. 
• The payments are available via Search for Payment, their status will be OPEN and they be included the next time Format Checks/ACH is run. 

Payment Spreadsheet Format

Download the template located here: PDP_PaymentSpreadsheetUpload 

Following is the format and a sample file is shown below. 

Required	Data Element	Sample Value	Data Type	Length min/max
Yes	Campus	BL	String	2/2
Yes	Unit	KUAL	String	1/4
Yes	Sub Unit	DV	String	1/4
Yes	Date	7/21/2010 10:30	date and time	(must be unique for each file or file with be viewed as a duplicate)
Yes	COA	BL	String	1/2
Yes	Account Number	1024700	String	8/8
No	Sub Account		String	1/5
Yes	Object Code	5000	String	4/4
No	Sub Object Code		String	1/6
Yes	Payee Name	Black Tree Service	String	1/40
Yes	Employee Or Vendor	V	String	1/1
Yes	Address line 1	102 Nest Lane	String	1/55
No	Address line 2		String	0/55
No	Address Line 3		String	0/55
Yes	City	East Lansing	String	1/45
No	State	MI	String	0/30
No	Zip	48823	String	0/20
Yes	Payment Date	5/2/2013	Date	MM/dd/yyyy
Yes	Source Doc	777777	String	1/14
No	Check Stub Notes	Payment or Service	String	0/90
Yes	Amount	10.25	Decimal
Yes	Payee Name	Snicker, Sue	String	1/40
Yes	Employee Or Vendor	V	String	1/1
Yes	Address line 1	101 Hill Street	String	1/55
No	Address line 2		String	0/55
No	Address Line 3		String	0/55
Yes	City	East Lansing	String	1/45
No	State	MI	String	0/30
No	Zip	48823	String	0/20
Yes	Payment Date	05/02/2013	Date	MM/dd/yyyy

Spreadsheet Sample