{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Acctg JE Entry Template","EXAMPLE Acctg JE Entry Template"],"not_rendered":{"charts":0,"images":19,"macros":1,"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":"Acctg JE Entry Template","index":0,"n_rows":227,"n_cols":14,"rows_kept":227,"cut":false,"hidden":false,"merged":[[27,7,46,7],[27,9,46,12],[0,1,0,13],[1,1,1,13],[11,3,11,4],[21,1,23,13],[16,2,16,7],[17,2,17,7],[16,9,16,13],[17,9,17,13],[3,1,9,13],[147,7,196,7],[197,7,226,7],[147,9,196,12],[197,9,226,12],[47,7,96,7],[47,9,96,12],[97,7,146,7],[97,9,146,12]]}
[null,"CSU Pomona"]
[null,"Accounting Revenue & Expense Journal Entry Template (PC)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"F-3843-00 Rev. 01/2021"]
[null,"This form should be used to request a journal entry for non-payroll related revenue and expense transactions.  Macros must be enabled for the form to be accurately completed and submitted on a PC (.xlsm file).\nInstructions: (1) Complete the unlocked cells, highlighted in 'yellow', in Sections I thru III of the form.  If additional rows are needed, click the \"Show/Hide\" buttons on the bottom of the form.  (2) Once data entry is complete, use the \"Save Form\" button if you wish to save a copy of the form for your records.  Or, click the \"Print Form\" button to print a hard copy.  (3) Click the \"Submit Form via E-mail\" button to send the form via e-mail to University Accounting (cppjerequest@cpp.edu).  The form must be submitted as a .xlsm file.  Please attach supporting documentation (print-screens/PDF docs from Dashboards showing entire CFS) with your submission.\n\nFor questions regarding this form, please contact General Accounting at cppjerequest@cpp.edu.  A UAS team member from General Accounting will contact you to assist with your question.\nImportant Note:  Please contact the Budget Office for all salary related adjustments (Accounts 601xxx, 602xxx or 603xxx).  This form should not be used to process budget related moves.  Please utilize Budget's transfer form, which can be found at http://www.cpp.edu/~fas/budget/forms.shtml."]
[]
[]
[]
[]
[]
[]
[]
[null,"Request Date"]
[]
[]
[null,"I. Requestor / Contact Information"]
[]
[null,"Name",null,null,null,null,null,null,"Ext"]
[null,"Dept",null,null,null,null,null,null,"Email"]
[]
[null,"II. Reason for the Request"]
[]
[]
[]
[]
[]
[null,"III. Transaction Information",null,null,null,null,null,null,null,null,null,"Check / Total:",{"$f":"IF(ROUND(SUM(N30:N227),2)=0,\"In Balance\",\"Not Balanced\")","v":"In Balance"},{"$f":"SUM(N30:N227)","v":0}]
[null,"Account\n(6)","Fund\n(5)","Dept\n(5)","Program\n(4)","Class\n(5)","Project\n(5)","Scenario","Line Description\n(30 - Entered in Caps) (Cannot Contain Commas)","Stat","Stat Amt","Open Item","Jrnl Line Ref","Amount"]
[null,"660003","POM01","67700","0602","00000",null,"For Accounting \nUse Only","EXAMPLE - COR POSTAGE DEC 2013","For Accounting \nUse Only",null,null,null,-100]
[null,"660001","UE001","67700","0602","00000",null,null,"EXAMPLE - COR POSTAGE DEC 2013",null,null,null,null,100]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19,null,null,null,null,null,null,"For Accounting \nUse Only",null,"For Accounting \nUse Only"]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69,null,null,null,null,null,null,"For Accounting \nUse Only",null,"For Accounting \nUse Only"]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119,null,null,null,null,null,null,"For Accounting \nUse Only",null,"For Accounting \nUse Only"]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169,null,null,null,null,null,null,"For Accounting \nUse Only",null,"For Accounting \nUse Only"]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]

{"sheet":"EXAMPLE Acctg JE Entry Template","index":1,"n_rows":227,"n_cols":14,"rows_kept":227,"cut":false,"hidden":false,"merged":[[47,7,96,7],[47,9,96,12],[0,1,0,13],[1,1,1,13],[3,1,9,13],[11,3,11,4],[16,2,16,7],[16,9,16,13],[17,2,17,7],[17,9,17,13],[21,1,23,13],[27,7,46,7],[27,9,46,12],[97,7,146,7],[97,9,146,12],[147,7,196,7],[147,9,196,12],[197,7,226,7],[197,9,226,12]]}
[null,"CSU Pomona"]
[null,"Accounting Revenue & Expense Journal Entry Template (PC)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"F-3843-00 Rev. 02/17"]
[null,"This form should be used to request a journal entry for non-payroll related revenue and expense transactions.  Macros must be enabled for the form to be accurately completed and submitted on a PC (.xlsm file).\nInstructions: (1) Complete the unlocked cells, highlighted in 'yellow', in Sections I thru III of the form.  If additional rows are needed, click the \"Show/Hide\" buttons on the bottom of the form.  (2) Once data entry is complete, use the \"Save Form\" button if you wish to save a copy of the form for your records.  Or, click the \"Print Form\" button to print a hard copy.  (3) Click the \"Submit Form via E-mail\" button to send the form via e-mail to University Accounting (cppjerequest@cpp.edu).  The form must be submitted as a .xlsm file.  Please attach supporting documentation (print-screens/PDF docs from Dashboards showing entire CFS) with your submission.\n\nFor questions regarding this form, please contact General Accounting at cppjerequest@cpp.edu. A UAS team member from General Accounting will contact you to assist with your question.\nImportant Note:  Please contact the Budget Office for all salary related adjustments (Accounts 601xxx, 602xxx or 603xxx).  This form should not be used to process budget related moves.  Please utilize Budget's transfer form, which can be found at http://www.cpp.edu/~fas/budget/forms.shtml."]
[]
[]
[]
[]
[]
[]
[]
[null,"Request Date",null,"2017-02-14"]
[]
[]
[null,"I. Requestor / Contact Information"]
[]
[null,"Name","Michelle Cardona",null,null,null,null,null,"Ext",2154]
[null,"Dept","University Accounting Services",null,null,null,null,null,"Email","mdcardona@cpp.edu"]
[]
[null,"II. Reason for the Request"]
[]
[null,"TO CORRECT ACCOUNT USED FOR TRAINING RELATED ACTIVITY"]
[]
[]
[]
[null,"III. Transaction Information",null,null,null,null,null,null,null,null,null,"Check / Total:",{"$f":"IF(ROUND(SUM(N30:N227),2)=0,\"In Balance\",\"Not Balanced\")","v":"In Balance"},{"$f":"SUM(N30:N227)","v":0}]
[null,"Account\n(6)","Fund\n(5)","Dept\n(5)","Program\n(4)","Class\n(5)","Project\n(5)","Scenario","Line Description\n(30 - Entered in Caps) (Cannot Contain Commas)","Stat","Stat Amt","Open Item","Jrnl Line Ref","Amount"]
[null,"660003","POM01","67700","0602","00000",null,"For Accounting \nUse Only","EXAMPLE - COR POSTAGE DEC 2013","For Accounting \nUse Only",null,null,null,-100]
[null,"660001","UE001","67700","0602","00000",null,null,"EXAMPLE - COR POSTAGE DEC 2013",null,null,null,null,100]
[1,"660090","POM01","63900","0509","00000",null,null,"ACADEMIC IMPRESSIONS",null,null,null,null,-1095]
[2,"660009","POM01","63900","0509","00000",null,null,"ACADEMIC IMPRESSIONS",null,null,null,null,1095]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19,null,null,null,null,null,null,"For Accounting \nUse Only",null,"For Accounting \nUse Only"]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69,null,null,null,null,null,null,"For Accounting \nUse Only",null,"For Accounting \nUse Only"]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119,null,null,null,null,null,null,"For Accounting \nUse Only",null,"For Accounting \nUse Only"]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169,null,null,null,null,null,null,"For Accounting \nUse Only",null,"For Accounting \nUse Only"]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]