{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["NG Form","JE - TUF USE ONLY"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"NG Form","index":0,"n_rows":62,"n_cols":10,"rows_kept":62,"cut":false,"hidden":false,"merged":[[56,1,56,6],[3,6,3,7],[54,1,54,6],[12,4,12,6],[53,1,53,9],[55,1,55,6],[12,1,12,2]]}
[]
[null,"NON-GIFT DEPOSIT FORM"]
[]
[null,"REQUIRED FIELDS:",null,null,null,null,"REVENUE CODES: (Enter appropriate Code on Line 1 below)"]
[null,null,"Date ==>",null,null,null,"Ticket Sales ==>","02-4302-0"]
[null,null,"Project #  ==>",null,null,null,"Research Grant Payment  ==>","02-4152-0"]
[null,null,"Project Name ==>",null,null,null,"Memberships/Dues ==>","02-4354-0"]
[null,null,"Program Director Name ==>",null,null,null,"Royalities ==>","02-4356-0"]
[null,"Cash Checks or ACH?  Yes or No using drop down menu ==>",null,null,null,null,"Fees (conference, seminar, etc.) ==>","02-4202-0"]
[null,null,null,null,null,null,"Special Events ==>","02-4402-0"]
[]
[]
[null,"Detailed Purpose Description (Required) ==>"]
[]
[null,"Checks must be made payable to TU Foundation"]
[null,"Revenue Code \n(Type or Copy in the white space below a revenue code referenced above in Yellow)","Date","CR"," $$ Amount","Journal","Payor Name","5-Digit\nProject #\n(NO ENTRY)","Check # or Last 4 of Credit Card #"]
[1,null,{"$f":"IF(E17>0,+$E$5,\"\")","v":""},{"$f":"IF(E17>0,\"C\",\"\")","v":""},null,{"$f":"IF($E$9=\"Yes\",\"Miscellaneous Cash Receipts\",\"Credit Card Cash Receipts\")","v":"Credit Card Cash Receipts"},null,{"$f":"IF(E17>0,+$E$6,\"\")","v":""},null,1]
[2,{"$f":"IF(E18>0,+$B$17,\"\")","v":""},"","",null,{"$f":"IF($E$9=\"Yes\",\"Miscellaneous Cash Receipts\",\"Credit Card Cash Receipts\")","v":"Credit Card Cash Receipts"},null,"",null,2]
[3,"","","",null,"Credit Card Cash Receipts",null,"",null,3]
[4,"","","",null,"Credit Card Cash Receipts",null,"",null,4]
[5,"","","",null,"Credit Card Cash Receipts",null,"",null,5]
[6,"","","",null,"Credit Card Cash Receipts",null,"",null,6]
[7,"","","",null,"Credit Card Cash Receipts",null,"",null,7]
[8,"","","",null,"Credit Card Cash Receipts",null,"",null,8]
[9,"","","",null,"Credit Card Cash Receipts",null,"",null,9]
[10,"","","",null,"Credit Card Cash Receipts",null,"",null,10]
[11,"","","",null,"Credit Card Cash Receipts",null,"",null,11]
[12,"","","",null,"Credit Card Cash Receipts",null,"",null,12]
[13,"","","",null,"Credit Card Cash Receipts",null,"",null,13]
[14,"","","",null,"Credit Card Cash Receipts",null,"",null,14]
[15,"","","",null,"Credit Card Cash Receipts",null,"",null,15]
[16,"","","",null,"Credit Card Cash Receipts",null,"",null,16]
[17,"","","",null,"Credit Card Cash Receipts",null,"",null,17]
[18,"","","",null,"Credit Card Cash Receipts",null,"",null,18]
[19,"","","",null,"Credit Card Cash Receipts",null,"",null,19]
[20,"","","",null,"Credit Card Cash Receipts",null,"",null,20]
[21,"","","",null,"Credit Card Cash Receipts",null,"",null,21]
[22,"","","",null,"Credit Card Cash Receipts",null,"",null,22]
[23,"",{"$f":"IF(E39>0,+$E$5,\"\")","v":""},"",null,"Credit Card Cash Receipts",null,"",null,23]
[24,"","",{"$f":"IF(E40>0,\"C\",\"\")","v":""},null,"Credit Card Cash Receipts",null,"",null,24]
[25,{"$f":"IF(E41>0,+$B$17,\"\")","v":""},"","",null,"Credit Card Cash Receipts",null,"",null,25]
[null,"DEPOSIT TOTAL:",null,null,{"$f":"SUM(E17:E41)","v":0}]
[null,"Less: Amounts Returned to Program  Director:",null,null,null,null,"<== Foundation Use Only"]
[null,"ADJUSTED DEPOSIT TOTAL:",null,null,{"$f":"+E42+E43","v":0}]
[]
[null,"Foundation Use ONLY"]
[]
[null,"FORM INSTRUCTIONS:"]
[null,"1. You must write the project number in the upper left hand corner of ALL checks.  This assists us when checks are returned by our bank for Non-sufficient funds."]
[null,"2. NEVER write full credit card numbers on this form.  Credit card #'s must be physically brought to our office for processing."]
[null,"3. Submit 2 copies, as follows:"]
[null,"       a. An electronic copy via email (in Excel) to the following email address: TUFCR@towson.edu"]
[null,"       b. A hard paper copy to the Foundation Office, along with the checks and cash for deposit"]
[null,"           NOTE: Electronic versions will be imported directly to our accounting system, exactly as you type the information, for your use when reviewing your\n                     reports in NXT"]
[null,"4. Complete a separate form for:"]
[null,"       a. each tender type, i.e. checks, cash, credits cards, ACH"]
[null,"       b. each revenue type, i.e. Ticket Sales, Royalties, etc."]
[null,"5. Typing is permitted ONLY in White spaces.  The form is designed to will automatically complete all remaining required information"]
[]
[null,"NOTE:  Cash Receipts from Government entities are not considered gifts and should be processed on a Non-Gift Deposit Form"]
[]
[null,"Revised 4/24/2023"]

{"sheet":"JE - TUF USE ONLY","index":1,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'NG Form'!B17","v":0},{"$f":"+'NG Form'!C17","v":""},{"$f":"+'NG Form'!D17","v":""},{"$f":"+'NG Form'!E17","v":0},{"$f":"+'NG Form'!F17","v":"Credit Card Cash Receipts"},{"$f":"MID(L1,1,60)","v":"0 - 0"},{"$f":"+'NG Form'!H17","v":""},null,{"$f":"+'NG Form'!G17","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},{"$f":"CONCATENATE(I1,J1,K1)","v":"0 - 0"}]
[{"$f":"+'NG Form'!B18","v":""},{"$f":"+'NG Form'!C18","v":""},{"$f":"+'NG Form'!D18","v":""},{"$f":"+'NG Form'!E18","v":0},{"$f":"+'NG Form'!F18","v":"Credit Card Cash Receipts"},{"$f":"MID(L2,1,60)","v":"0 - 0"},{"$f":"+'NG Form'!H18","v":""},null,{"$f":"+'NG Form'!G18","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},{"$f":"CONCATENATE(I2,J2,K2)","v":"0 - 0"}]
[{"$f":"+'NG Form'!B19","v":""},{"$f":"+'NG Form'!C19","v":""},{"$f":"+'NG Form'!D19","v":""},{"$f":"+'NG Form'!E19","v":0},{"$f":"+'NG Form'!F19","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H19","v":""},null,{"$f":"+'NG Form'!G19","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B20","v":""},{"$f":"+'NG Form'!C20","v":""},{"$f":"+'NG Form'!D20","v":""},{"$f":"+'NG Form'!E20","v":0},{"$f":"+'NG Form'!F20","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H20","v":""},null,{"$f":"+'NG Form'!G20","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B21","v":""},{"$f":"+'NG Form'!C21","v":""},{"$f":"+'NG Form'!D21","v":""},{"$f":"+'NG Form'!E21","v":0},{"$f":"+'NG Form'!F21","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H21","v":""},null,{"$f":"+'NG Form'!G21","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B22","v":""},{"$f":"+'NG Form'!C22","v":""},{"$f":"+'NG Form'!D22","v":""},{"$f":"+'NG Form'!E22","v":0},{"$f":"+'NG Form'!F22","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H22","v":""},null,{"$f":"+'NG Form'!G22","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B23","v":""},{"$f":"+'NG Form'!C23","v":""},{"$f":"+'NG Form'!D23","v":""},{"$f":"+'NG Form'!E23","v":0},{"$f":"+'NG Form'!F23","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H23","v":""},null,{"$f":"+'NG Form'!G23","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B24","v":""},{"$f":"+'NG Form'!C24","v":""},{"$f":"+'NG Form'!D24","v":""},{"$f":"+'NG Form'!E24","v":0},{"$f":"+'NG Form'!F24","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H24","v":""},null,{"$f":"+'NG Form'!G24","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B25","v":""},{"$f":"+'NG Form'!C25","v":""},{"$f":"+'NG Form'!D25","v":""},{"$f":"+'NG Form'!E25","v":0},{"$f":"+'NG Form'!F25","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H25","v":""},null,{"$f":"+'NG Form'!G25","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B26","v":""},{"$f":"+'NG Form'!C26","v":""},{"$f":"+'NG Form'!D26","v":""},{"$f":"+'NG Form'!E26","v":0},{"$f":"+'NG Form'!F26","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H26","v":""},null,{"$f":"+'NG Form'!G26","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B27","v":""},{"$f":"+'NG Form'!C27","v":""},{"$f":"+'NG Form'!D27","v":""},{"$f":"+'NG Form'!E27","v":0},{"$f":"+'NG Form'!F27","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H27","v":""},null,{"$f":"+'NG Form'!G27","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B28","v":""},{"$f":"+'NG Form'!C28","v":""},{"$f":"+'NG Form'!D28","v":""},{"$f":"+'NG Form'!E28","v":0},{"$f":"+'NG Form'!F28","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H28","v":""},null,{"$f":"+'NG Form'!G28","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B29","v":""},{"$f":"+'NG Form'!C29","v":""},{"$f":"+'NG Form'!D29","v":""},{"$f":"+'NG Form'!E29","v":0},{"$f":"+'NG Form'!F29","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H29","v":""},null,{"$f":"+'NG Form'!G29","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B30","v":""},{"$f":"+'NG Form'!C30","v":""},{"$f":"+'NG Form'!D30","v":""},{"$f":"+'NG Form'!E30","v":0},{"$f":"+'NG Form'!F30","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H30","v":""},null,{"$f":"+'NG Form'!G30","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B31","v":""},{"$f":"+'NG Form'!C31","v":""},{"$f":"+'NG Form'!D31","v":""},{"$f":"+'NG Form'!E31","v":0},{"$f":"+'NG Form'!F31","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H31","v":""},null,{"$f":"+'NG Form'!G31","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B32","v":""},{"$f":"+'NG Form'!C32","v":""},{"$f":"+'NG Form'!D32","v":""},{"$f":"+'NG Form'!E32","v":0},{"$f":"+'NG Form'!F32","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H32","v":""},null,{"$f":"+'NG Form'!G32","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B33","v":""},{"$f":"+'NG Form'!C33","v":""},{"$f":"+'NG Form'!D33","v":""},{"$f":"+'NG Form'!E33","v":0},{"$f":"+'NG Form'!F33","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H33","v":""},null,{"$f":"+'NG Form'!G33","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B34","v":""},{"$f":"+'NG Form'!C34","v":""},{"$f":"+'NG Form'!D34","v":""},{"$f":"+'NG Form'!E34","v":0},{"$f":"+'NG Form'!F34","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H34","v":""},null,{"$f":"+'NG Form'!G34","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B35","v":""},{"$f":"+'NG Form'!C35","v":""},{"$f":"+'NG Form'!D35","v":""},{"$f":"+'NG Form'!E35","v":0},{"$f":"+'NG Form'!F35","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H35","v":""},null,{"$f":"+'NG Form'!G35","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B36","v":""},{"$f":"+'NG Form'!C36","v":""},{"$f":"+'NG Form'!D36","v":""},{"$f":"+'NG Form'!E36","v":0},{"$f":"+'NG Form'!F36","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H36","v":""},null,{"$f":"+'NG Form'!G36","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B37","v":""},{"$f":"+'NG Form'!C37","v":""},{"$f":"+'NG Form'!D37","v":""},{"$f":"+'NG Form'!E37","v":0},{"$f":"+'NG Form'!F37","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H37","v":""},null,{"$f":"+'NG Form'!G37","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B38","v":""},{"$f":"+'NG Form'!C38","v":""},{"$f":"+'NG Form'!D38","v":""},{"$f":"+'NG Form'!E38","v":0},{"$f":"+'NG Form'!F38","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H38","v":""},null,{"$f":"+'NG Form'!G38","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B39","v":""},{"$f":"+'NG Form'!C39","v":""},{"$f":"+'NG Form'!D39","v":""},{"$f":"+'NG Form'!E39","v":0},{"$f":"+'NG Form'!F39","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H39","v":""},null,{"$f":"+'NG Form'!G39","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B40","v":""},{"$f":"+'NG Form'!C40","v":""},{"$f":"+'NG Form'!D40","v":""},{"$f":"+'NG Form'!E40","v":0},{"$f":"+'NG Form'!F40","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H40","v":""},null,{"$f":"+'NG Form'!G40","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[{"$f":"+'NG Form'!B41","v":""},{"$f":"+'NG Form'!C41","v":""},{"$f":"+'NG Form'!D41","v":""},{"$f":"+'NG Form'!E41","v":0},{"$f":"+'NG Form'!F41","v":"Credit Card Cash Receipts"},"0 - 0",{"$f":"+'NG Form'!H41","v":""},null,{"$f":"+'NG Form'!G41","v":0}," - ",{"$f":"+'NG Form'!$E$13","v":0},"0 - 0"]
[]
[]
[]
[]
[]
[]
["Yes"]
["No"]