{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cash Receipt Form","Instructions","Update XML","modCashReceiptMacros"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"modCashReceiptMacros","index":3,"reason":"part_missing"}],"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":"Cash Receipt Form","index":0,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,1,52,2],[39,7,39,8],[49,8,49,10],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[44,7,44,8],[45,7,45,8],[43,2,43,3],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[36,7,36,8],[41,2,41,3],[41,4,41,5],[34,7,34,8],[35,7,35,8],[38,7,38,8],[37,7,37,8],[38,2,38,3],[38,4,38,5],[39,2,39,3],[39,4,39,5],[40,2,40,3],[40,4,40,5],[24,9,25,10],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[45,2,45,3],[45,4,45,5],[44,2,44,3],[44,4,44,5],[42,2,42,3],[42,4,42,5],[43,4,43,5],[37,2,37,3],[37,4,37,5],[35,2,35,3],[36,2,36,3],[27,2,27,3],[36,4,36,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[31,4,31,5],[29,2,29,3],[35,4,35,5],[30,2,30,3],[34,4,34,5],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[30,4,30,5],[32,4,32,5],[33,4,33,5],[26,4,26,5],[25,2,25,3],[25,4,25,5],[26,2,26,3],[28,2,28,3],[24,1,24,5],[24,6,25,8],[7,3,7,4],[7,1,7,2],[9,1,9,4],[8,1,8,4],[16,1,16,2],[13,3,13,4],[10,1,10,4],[11,1,11,4],[17,1,17,2],[6,5,17,10],[18,5,19,10],[16,3,16,4],[17,3,17,4],[23,8,23,10],[22,8,22,10],[20,5,20,7],[22,5,22,7],[20,8,20,10],[14,3,14,4],[15,3,15,4],[14,1,15,2],[6,1,6,2],[6,3,6,4],[12,1,12,2],[12,3,12,4],[13,1,13,2]]}
[]
[]
[]
[]
[]
[]
[null," THE UNIVERSITY OF MICHIGAN-DEARBORN",null,"SHORT CODE (6 characters)"]
[null,"CASH RECEIPT TICKET"]
[null,"FULL NAME AND CONTACT INFORMATION OF PREPARER"]
[]
[null,"JOURNAL REFERENCE "]
[]
[null,"DATE",null,"PHONE NUMBER"]
[]
[]
[]
[null,"BUSINESS UNIT",null,"DESCRIBE NATURE OF RECEIPT (30 char)"]
[null,"UMICH"]
[null,null,null,null,null,"FOR STUDENT ACCOUNTS OFFICE USE ONLY"]
[]
[null,"Account","Fund","DeptID","Program","Class",null,null,"Project/Grant"]
[]
[]
[]
[null,"Additional Description: (Departmental Use Only)",null,null,null,null,"Checks",null,null,"Cash"]
[null,"Item #","Item Date:",null,"Item Description"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[null,"Form 6957 Rev 10/10/2020"]
[null,"http://www.umich.edu/~finops",null,null,null,null,"$",null,null,"$"]
[]
[null,null,null,null,null,"TOTAL DEPOSIT","$"]
[null,"CRT FORM COPIES MAY BE PROVIDED BY YOU TO BE STAMPED WHEN DELIVERED IN PERSON"]
[null,"Student Accounts 1187UC                                            4901 Evergreen Rd                                                     Dearborn, MI 48128"]

{"sheet":"Instructions","index":1,"n_rows":50,"n_cols":2,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,"The following instructions are for the preparation of a Cash Receipt Ticket only."]
[]
[null,"Funds Being Deposited To A University Chartfield Account:"]
[]
[null,"All funds collected by any department of the University are to be deposited to a University Chartfield with a Shortcode and Account code that can be used with it."]
[]
[null,"Deposits to multiple Chartfield /Shortcode combinations requires separate Cash Receipt Tickets for each Chartfield /Shortcode."]
[]
[null,"Delivery to the Student Account's Office:"]
[null,"All deposits can be mailed through inner office mail to: Student Accounts 1187 University Center 4901 Evergreen Road Dearbo rn , Ml 48128."]
[null,"Drop box is available at North side of the University Center 24/7."]
[]
[null,"Deposit funds in Timely Manner:"]
[null,"All receipts should be deposited with the Student Account's Office as expeditiously as possible."]
[]
[null,"Cash Receipt Ticket Form: Can be found under Student Account's Website - Forms - Cash Receipt Ticket"]
[]
[]
[null,"Preparation of The Cash Receipt Ticket:"]
[]
[null,"-SHORTCODE (6 characters) you can look it up on Dearborn Chartfield (https://umdearborn.edu/faculty-staff/financial-services/dearborn-chartfield-lookup)."]
[]
[null,"-Name of Preparer: Enter full name. This will assist the Student Account's Office to contact the preparer if necessary."]
[]
[null,"-Campus Address to Send Receipt: This will make sure receipt of your deposit gets back to you."]
[]
[null,"-Date: Use the date it is prepared"]
[]
[null,"-Phone Number: Enter the number at which the preparer can be reached"]
[]
[null,"-Journal Reference-optional (10 characters)"]
[null,"Formerly known as Department Reference Number. This field is used by the department preparing the ticket as the means of identifying the particular cash receipt when it appears on the Statement of Activity. The department may use this as their own coding system."]
[]
[null,"-Describe Nature of Receipt (30 characters): Enter an adequate description of the transaction up to 30 characters. This description will appear on the Statement of Activity."]
[]
[null,"-Chartfield Combination: Enter the appropriate Chartfield combination that the deposit will be credited to. Making sure the Account Code, Short Code and Chartfield are compatible with each other."]
[]
[null,"-Check Amount: List each check separately. Listing check number, date of check, name and amount of check.  Do not send in stub of the check-that is for your records. Stamp it on the back and write the shortcode in. If you don't have a stamp, just write your shortcode on back of check."]
[null,"Note: If the funds are to be split between Chartfield combinatinations, enter the total amount of checks to be deposited to this specific Chartfield combination."]
[]
[null,"-Cash Amount: enter the total amount of cash to be deposited"]
[]
[null,"Note: If the funds are to be split between Chartfield combinations, enter the total amount of cash to be deposited to this specific Chartfield combination."]
[]
[]
[null,"If the funds are split between Chartfield combinations, the \"TOTAL DEPOSIT\" for all Cash Receipt Tickets must equal the total amount of the funds deposited,"]
[]
[null,"Only send check, cash and cash receipt ticket. Do not send any other paper work. Make sure to make copy of cash receipt ticket for your records."]
[]
[null,"Once Student Accounts processes your Cash Receipt Ticket we will send the receipt to address listed on ticket."]

{"sheet":"Update XML","index":2,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["id","ns1:filename","ns1:lastupdate"]
["jebasic","jebasic.xls","08-17-2005"]
["cashrcpt","cashrcpt.xls","08-17-2005"]
["jrnlload","jrnlload.xlt","08-17-2005"]