1 / 12

Spreadsheet Upload Workflow

Spreadsheet Upload Workflow. Journal entered in Spreadsheet Upload and Imported to PeopleSoft. Send email to PSFinancials@towson.edu , include the journal number and description. Journal is reviewed. Fails Budget Checking.

Pat_Xavi
Download Presentation

Spreadsheet Upload Workflow

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spreadsheet Upload Workflow Journal entered in Spreadsheet Upload and Imported to PeopleSoft Send email to PSFinancials@towson.edu , include the journal number and description Journal is reviewed Fails Budget Checking Passes Combo Edits, no errors and passes Budget Check, journal gets posted, process complete. Fails combo edits (Incorrect chartfield strings) Budget Office receives the budget exceptions report and review, override journal and contact necessary departments. Fin Services sends email with corrections that need to be made. Journal will be budget checked and posted most likely in overnight process. Department makes budget adjustments to correct override. Journal needs to be edited and imported again.

  2. Opening the Journal Spreadsheet file: If you have MicroSoft Office 2007: When opening the journal upload file you may get a journal screen, (possibly the last journal you worked on or blank journal) and the program seems like its frozen. It won’t allow you to click on anything. If this happens you should see this bar: Click on Options… , you will then see this screen pop up: Select the Enable this content option and click OK. Your screen will then unfreeze and it will automatically take you to the Journal Upload menu page.

  3. Opening the Journal Spreadsheet file: If you have MicroSoft 2003 you may experience this window when opening the journal upload file, if so click Enable Macros.

  4. Journal Spreadsheet Upload Menu Page When using the Spreadsheet Upload for the FIRST time click Setup.

  5. Spreadsheet Journal Upload Setup Before using the Spreadsheet Upload for the FIRST time you must click Setup to define your default settings. Business Unit will be TOWSN All fields must be Upper Case. Message Options will already be selected for you. Be sure to have the correct address which is: http://fsprodweb1.towson.edu:8080/xmllink/FS9PRD/ Ledger Group will be ACTUALS. Select a journal source as a default from the list provided. Most likely a journal source you will use most often. Enter your user ID here also. JWEIL Your User ID is the same User ID used to log into PeopleSoft Financials. This option MUST be selected.

  6. After clicking OK on the Setup page this box will appear: ALWAYS select Yes.

  7. When you are ready to create a new journal click on New. This box will appear, give the journal a name, each journal must have a unique individual name. You CAN NOT name a journal the same as another journal. The name of the journal is for your use, it will not be seen in PeopleSoft

  8. Spreadsheet Journal Upload Tools Import button: Click to import the journal to PeopleSoft. Edit Journal Header Home button: Takes you back to the home page where you can access Setup, New, Edit and more. Copy Select a Journal: Journal Header: Click to enter a Description and to enter the correct Journal Source. Change Import Status Add a line Delete a Journal Delete multiple lines Delete a line Add multiple lines This function will not be used, it is to verify amounts in foreign currency

  9. To begin entering your journals click on the Journal Header button every time you create a journal. Only click this button ONCE, DO NOT add another header. JMHALL Most of the information should default in from the Journal Setup. Enter a Description, this description will show up in PeopleSoft. 30 characters from this field carry over to PeopleSoft. If necessary change the Journal source according to the type of journal you are entering. Always include a reference, this should be your User ID or first initial last name. This is how we can identify who entered the journal. THIS FIELD MUST BE FILLED IN!!

  10. To begin entering lines in the journal, click on the Add Lines button or Add Multiple Lines Button and begin entering information. Add Multiple lines Add a line

  11. When you have created the journal and you are ready to import, click the Import button: This box will appear, enter your User ID and Password, then click OK to import

  12. After a successful import you will see this box. It says 1 journal was imported, it gives you the journal ID, the journal date, your name and the description. Email PSFinancials@towson.eduwith this information. Journal Description Journal Date Journal ID Your name

More Related