Docstoc

Upload-Template

Document Sample
Upload-Template Powered By Docstoc
					e2bcde65-711b-4a2b-bf5f-82d0b1505755.xls

11/28/2009

A B 1 Prepared by first name: For every transaction 2 enter "TI" 3 TI 4 TI

C

D Last name: Sender Type CC CC

E

F Title:

G

H I J Date Prepared: Secondary Cost Element 926660 926660

K

L Phone #:

M Email: Receiver Type CC CC

N

O P

Q

R

Tranaction number Sender Fund 00001 1040000000 00002 1040000000

Sender Cost Object # 4009999999 4009999999

AMOUNT Sender will get credit Receiver will get debit Receiver Fund 100.05 1048000000 100.3 1048000000

Receiver Cost Object # 4800000000 4800000000

Text (50 characters) Text information goes here Enter add'l info here

Line Item Date 02/28/2007 02/28/2007

Page 1 of 4

e2bcde65-711b-4a2b-bf5f-82d0b1505755.xls Instructions INSTRUCTIONS:

11/28/2009

1. Worksheet Preparation Line one: Enter your full first name in cell C1 and your full last name in cell E1 Line one: Enter your title in cell G1 Line one: Enter the date when you prepared this sheet in cell K1 in YYYYMMDD format. Example: 20061127 Line one: Enter your ten digit phone number in cell M1 without dashes. Example: 4105024444 Line one: Enter your e-mail in cell Q1. Example: johnsmith@jhu.edu Line two: It is column heading line- do not change it. Line three: Delete this line (do delete row) before sending this Excel file. This line is an example line. Line four: Delete this line (do delete row) before sending this Excel file. This line is an example line. Column A: Enter "TI" for every transaction line, as it is shown in example in lines 3 and 4. Column B: Enter 5 digits long sequential numbers. Include leading zeros. Example: 00001, 00002, 00003, 00004, 00005, etc. The maximum limit of transaction lines (TI lines) per each upload file is 498. If you need to post more than 498 transaction lines, create another upload file following the same instructions. Column C: Enter 10 digits long Sender Fund if not derived. If Sender Fund is derived, leave this cell blank. Column D: Enter Sender Cost Object type either "CC", "IO" or "WBSE". "CC" for Cost Center "IO" for Internal Order "WBSE" for Work Breakdown Structure Element Column E: Enter Sender Cost Object number: For CC- Cost Center, enter 10 characters For IO - Internal Order, enter 8 characters For WBSE - Work Breakdown Structure Element, enter up to 24 characters Column F: Leave it blank Column G: Leave it blank Column H: Enter Secondary Cost Element. Column I: Leave it blank Column J: Leave it blank Column K: Enter amount, decimal is necessary, but no commas are necessary. Exp: 15000.55 The sender receives a credit and receiver receives a debit. If the amount entered is a negative number, the sender receives a debit and receiver receives a credit. This is how to record a Revenue allocation. Column L: Enter 10 digits long Receiver Fund if not derived. If Receiver Fund is derived, leave this cell blank. Column M: Enter Receiver Cost Object type either "CC", "IO" or "WBSE". "CC" for Cost Center "IO" for Internal Order "WBSE" for Work Breakdown Structure Element Column N: Enter Receiver Cost Object number: For CC- Cost Center, enter 10 characters For IO - Internal Order, enter 8 characters For WBSE - Work Breakdown Structure Element, enter up to 24 characters Page 2 of 4

e2bcde65-711b-4a2b-bf5f-82d0b1505755.xls Instructions Column O: Leave it blank Column P: Leave it blank

11/28/2009

Page 3 of 4

e2bcde65-711b-4a2b-bf5f-82d0b1505755.xls Instructions Column Q: Enter descriptive information up to 50 characters to appear on SAP BW reports. It should include: description of an expense, the month, the date(if applicable) and the year. Examples: Mailing for Radiology 1106 Copy for Cardiology 1106 Support salary for J. Smith 1106 Work Order 1217206-3042670 1106 The information provided in this column should be sufficient to track back to the source documents for all line items in this upload for the reporting and audit purposes. Therefore, keep all source documents available to support all line items on this upload. Column R: Enter the last day of the month you are processing for in format MM/DD/YYYY. Example: On February 2, you prepared a spreadsheet to be processed in January, enter 01/31/2007. 2. Saving the worksheet Name and save this Excel file as: Sender's (who gets credit) Business AreaDepartment name_Invoice(charge) descriptionMMYY Note: separate department and Invoice description by underscore. For revised files, add "R" and the number at the end of the file. Examples: 480MDC_Inventory1106.xls 480Copy1106.xls 170Pediatrics_Work Orders1106.xls Examples of revised files: 480MDC_Inventory1106R1.xls 480MDC_Inventory1106R2.xls

11/28/2009

for the first revision for the second revision

3. E-mailing the worksheet for Inter-Entity and JHU Intra-Entity transactions: For inter-entity and JHU Intra-Entity transactions, please e-mail this Excel file as an attachment to the Inter-Entity e-mail box: InterEntity@jhu.edu and copy (cc) this e-mail to the person/s on the opposite side of the transaction/s. For example: if you work for JHU, copy (cc) to JHHS counterpart person/s, and reverse. If you have any questions regarding the inter-entity and JHU intra-entity upload, please call the Inter-Entity Customer Service at 443-997-2481 4. E-mailing the worksheet for JHHS Intra-Entity transactions: For JHHS intra-entity transactions, please e-mail this Excel file as an attachment to the JHHS Controlller's Office and copy (cc) this e-mail to the person/s on the opposite side of the transaction/s.

Page 4 of 4


				
DOCUMENT INFO
Shared By:
Tags: Uploa, d-Tem
Stats:
views:34
posted:11/28/2009
language:English
pages:4
Description: Upload-Template