{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["EXPENSE REPORT FORM","ACCOUNT CODES","DEPARTMENT"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":1,"defined_names":6,"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":"EXPENSE REPORT FORM","index":0,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[30,10,30,11],[31,10,31,11],[28,9,28,11],[20,2,20,4],[21,2,21,4],[24,2,24,4],[25,2,25,4],[28,0,28,7],[66,0,66,7],[0,2,0,4],[7,6,8,7],[6,6,6,7],[16,0,16,7],[10,6,10,7],[46,0,46,7],[17,2,17,4],[18,2,18,4],[19,2,19,4],[3,0,3,1],[4,0,4,1],[2,4,2,7],[22,2,22,4],[23,2,23,4]]}
[]
[]
[null,null,null,null,"Employee Reimbursement Request "]
["901 Orange Grove Road",null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2022-01-07"}]
["Charleston, SC 29407"]
[]
[null,null,null,null,null,null,"TOTAL EXPENSE"]
["NAME:",null,null,null,null,null,{"$f":"H27+H44+H60","v":0}]
["STREET:"]
["CITY:"]
["STATE:",null,null,null,null,null,"For Accounting Use Only"]
["ZIP:",null,null,null,null,null,"Vendor #"]
["DEPARTMENT:",null,null,null,null,null,"System # "]
[]
[]
[null,null,null,null,"FUND",1,"COST CENTER"]
["MILEAGE LOG - 6501"]
["DATE","DESTINATION","PURPOSE OF TRIP",null,null,"MILES","RATE","AMOUNT"]
[null,null,null,null,null,null,0.58499999999999996,{"$f":"+F19*G19","v":0}]
[null,null,null,null,null,null,{"$f":"+$G$19","v":0.58499999999999996},{"$f":"+F20*G20","v":0}]
[null,null,null,null,null,null,{"$f":"+$G$19","v":0.58499999999999996},0]
[null,null,null,null,null,null,0.58499999999999996,0]
[null,null,null,null,null,null,0.58499999999999996,0]
[null,null,null,null,null,null,0.58499999999999996,0]
[null,null,null,null,null,null,0.58499999999999996,{"$f":"+F25*G25","v":0}]
[null,null,null,null,null,null,0.58499999999999996,{"$f":"+F26*G26","v":0}]
[null,null,null,null,null,{"$f":"SUM(F19:F26)","v":0},{"$f":"+G19","v":0.58499999999999996},{"$f":"SUM(H19:H26)","v":0}]
[]
["TRAVEL EXPENSES"]
[null,null,null,"AIRFARE","MEALS","LODGING","MISC."]
["DATE","ESTABLISHMENT","PURPOSE",6507,6508,6509,6550,"TOTAL"]
[null,null,null,null,null,null,null,{"$f":"SUM(D32:G32)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D33:G33)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"SUM(D32:D43)","v":0},0,0,0,{"$f":"SUM(H32:H43)","v":0}]
[]
[]
["OTHER EXPENSES"]
["DATE","Vendor","PURPOSE","ACCOUNT NAME","ACCOUNT CODE","BUSINESS PURPOSE","EMPLOYEE CODE","AMOUNT"]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D49,'ACCOUNT CODES'!A:B,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"ISERROR(I49)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D50,'ACCOUNT CODES'!A:B,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"ISERROR(I50)","v":true}]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D51,'ACCOUNT CODES'!A:B,2,FALSE)","v":{"$error":"#N/A"}},true]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D52,'ACCOUNT CODES'!A:B,2,FALSE)","v":{"$error":"#N/A"}},true]
[null,null,null,null,{"$f":"IF(J53=FALSE,I53,\" \")","v":" "},null,null,null,{"$f":"VLOOKUP(D53,'ACCOUNT CODES'!A:B,2,FALSE)","v":{"$error":"#N/A"}},true]
[null,null,null,null," ",null,null,null,{"$f":"VLOOKUP(D54,'ACCOUNT CODES'!A:B,2,FALSE)","v":{"$error":"#N/A"}},true]
[null,null,null,null," ",null,null,null,{"$f":"VLOOKUP(D55,'ACCOUNT CODES'!A:B,2,FALSE)","v":{"$error":"#N/A"}},true]
[null,null,null,null," ",null,null,null,{"$f":"VLOOKUP(D56,'ACCOUNT CODES'!A:B,2,FALSE)","v":{"$error":"#N/A"}},true]
[null,null,null,null," ",null,null,null,{"$f":"VLOOKUP(D57,'ACCOUNT CODES'!A:B,2,FALSE)","v":{"$error":"#N/A"}},true]
[null,null,null,null," ",null,null,null,{"$f":"VLOOKUP(D58,'ACCOUNT CODES'!A:B,2,FALSE)","v":{"$error":"#N/A"}},true]
[null,null,null,null," ",null,null,null,{"$f":"VLOOKUP(D59,'ACCOUNT CODES'!A:B,2,FALSE)","v":{"$error":"#N/A"}},true]
[null,null,null,null,null,null,null,{"$f":"SUM(H49:H59)","v":0}]
[]
["EMPLOYEE SIGNATURE:"]
[]
[]
["MANAGER APPROVAL:"]
[]
["PLEASE SEND APPROVED REPORT TO ACCOUNT PAYABLES"]

{"sheet":"ACCOUNT CODES","index":1,"n_rows":129,"n_cols":4,"rows_kept":129,"cut":false,"hidden":false,"merged":[]}
["Account Name ","Account #","Definition Reminder","Business Purpose"]
["Advertising ",6212,"Advertising charges"]
["Aid to Pregnant Women ",7615,"cost associated with specific ministry work"]
["Allowance for Autos  ",6506,"stipend to cover employee's use of individual car"]
["Assistance to Catholic Organiz  ",7502,"Used for financial assistance to catholic organizations outside of the diocese"]
["Auditing - Prof Services ",6202,"Auditing fees "]
["Auto - Gas, Repairs, Maint  ",6502,"gas, repairs i.e. flat tires, maintenance i.e. oil changes on diocesan owned cars"]
["Auto - Insurance  ",6505,"Insurance on diocesan owned cars"]
["Auto Mileage Reimbursement  ",6501,"employee mileage reimbursement only"]
["Background Investigations  ",6235,"Used primarily by Child Protection Services for background investigations"]
["Bank Fees-Charges ",6250,"Fees charged by bank for services or products.  i.e. check or deposit slip orders"]
["Bishop's Business Meals-functi  ",6422,"This account is only in the Bishop's cost center to cover meals with others, not used for the Bishop's residence"]
["Black Ministry  ",7606,"cost associated with specific ministry work"]
["Board/Committee Meetings  ",6417,"cost associated with hosting board or committee meetings i.e. supplies and materials or food"]
["Bond Issuance Costs  ",6208,"Cost associated with the bond - only used in D & L"]
["BSA Goal Sharing  ",6990,"Used for BSA rebates to parishes","required"]
["Campus Ministry Support  ",7625,"Campus Ministry Cost Center only","required"]
["Cathedral  ",6828,"Used for BSA monies to Cathedral","required"]
["Cathedral of St. John the Bapt  ",6928,"Financial assistance to Cathedral of St. John the Baptist","required"]
["Catholic Charities Diocese of  ",6906,"Financial assistance to catholic charities","required"]
["Christmas Party  ",6421,"This account is only in the Bishop's cost center to cover the cost of the Christmas party"]
["Columbia Hispanic Catholic Min  ",6982,"Financial assistance to Columbia Hispanic Catholic Ministry","required"]
["Computer Consulting  ",6209,"Consulting services, mainly for accounting software - used by finance"]
["Computer Licensing Fees ",6313,"Software licensing, i.e. Serenic, Blackbaud, Quickbooks"]
["Computer Maintenance-Upgrade  ",6706,"Upgrades to computer systems/software. Used primarily by computer services"]
["Computer Supplies  ",6308,"Cases for laptop, cables, mouse, ink, software"]
["Conferences and Meetings  ",6405,"fees for employees to attend conference, usually annual conferences - does not include airfare or lodging"]
["Connectivity Charges  ",6606,"Internet charges"]
["Counseling  ",6260,"Counseling services to be paid in specific circumstances as determined by the Office of Finance"]
["Curriculum Development ",6315,"Used for expenses in developing a curriculum plan for schools or programs"]
["Deanery Coordinator Expenses  ",6442,"Only used by catholic youth ministries for deanery youth coordinators"]
["Deanery Youth Boards  ",6448,"Only used by catholic youth ministries for special deanery events such as rallies, retreats, etc."]
["Diocesan Donations  ",7504,"Donations made by the Diocese to outside charities"]
["Diocesan School Financial Assi  ",6902,"Used for financial assistance to schools","Entity code/Business Purpose required"]
["DIOCESAN sponsored RETREATS ",6406,"rental of facility, supplies associated with the leadership workshops, cost associated with guest speakers (fees, travel, stipends) - *use business purpose assigned","may be required"]
["Direct Assistance to Individua ",7501,"Used for financial assistance provided directly to an individual"]
["DOC sponsored CONFERENCES-Meet ",6430,"This is for conferences and meetings that the DOC sponsors includes any expenses for supplies or facility rentals associated with the conference or meeting.","may be required"]
["DOC sponsored youth conference ",6420,"rental of facility, supplies associated with Diocesan Conferences, cost associated with guest speakers (fees, travel, stipends)","required"]
["Dominican Sisters, Ridgeville  ",6970,"Financial assistance to Dominican Sisters, Ridgeville  ","required"]
["Donor Recognition  ",6440,"Used by Stewardship office for recognition of any donors"]
["Educational Assistance  ",7507,"This account is used for grants and scholarships","required"]
["Educational Books and Fees  ",6317,"Used books and any additional fees for training or educational classes - not tuition"]
["Equipment-Repairs Maintenance  ",6703,"Repairs on equipment"]
["Evangelization Team  ",6457,"This account is only used by Catholic Youth Ministry"]
["Florist Bills  ",6307,"Florist "]
["Franciscan Center ",6910,"Financial assistance to Franciscan Center ","required"]
["Funeral Costs",6233,"Used by priest assistance/priest personnel to pay costs associated with priest funerals"]
["Groceries",6319,"Used by Drexel House and Bishop's house for grocery expense"]
["Grounds Maintenance-Landscapin  ",6814,"lawn service, irrigation service and landscaping etc"]
["Health Care Assistance ",7508,"Should be used if we pay health care for someone outside of the diocese"]
["Health Ins Broker-Consulting ",6252,"Used only by Finance office for insurance consulting services"]
["Holy See Financial Support  ",6463,"Only used by Chancery Office for annual CANON 1271 payment"]
["Household Expense ",6316,"Used for cleaning supplies, linens, etc."]
["In-kind Rent ",6870,"Used for donated facilities rent"]
["Internal BSA - General  ",6911,"Used for transfer of funds to the endowment","required"]
["Late Fees",6251,"Fees charged for past due invoices"]
["Machine-Equipment Rental  ",6702,"Rental of equipment "]
["Mailing Service ",6211,"Services used for bulk mailings - mainly Stewardship office"]
["Membership Dues  ",6461,"professional membership dues"]
["Migrant Ministry",7614,"cost associated with specific ministry work"]
["Minor Equipment  ",6701,"Equipment less than $5,000 with a useful life of more than one year"]
["National-World youth events",6424,"rental of facility, supplies associated with the National Youth Conference, cost associated with guest speakers (fees, travel, stipends) - Youth Ministry only - *use business purpose assigned"]
["Native American Ministry ",7608,"cost associated with specific ministry work"]
["News Wire Services",6213,"Used by Miscellany Office only"]
["Office Supplies ",6302,"Any supplies used for the function of an office.  i.e. paper, pens, folders"]
["Our Lady of the Valley Daughte  ",6972,"Financial assistance to Our Lady of the Valley, Daughters of Charity","required"]
["Parish Financial Assistance-Su  ",6901,"Used for financial assistance to parishes","Entity code/Business Purpose required"]
["Parish Life Facilitator  ",6908,"Used for financial assistance to parishes for parish life facilitator","required"]
["Pastoral Assistance ",6238,"Settlements to individuals to be paid in specific circumstances as recommended by legal counsel and Office of Finance."]
["Payroll Processing Fees",6230,"Paycor fees"]
["Personnel Recruiting  ",6513,"cost associated with hiring - in Human Resources cost center only"]
["Photographers & journalists  ",6226,"Used by Miscellany Office only"]
["Post Abortion Ministry ",7619,"cost associated with specific ministry work"]
["Postage",6305,"All postage including postage machines leases and service contracts"]
["Priest Retirement  ",6912,"Used for transfer of funds to priest retirement","required"]
["Printing and Stationery  ",6304,"Used for copier expense or outside coping or printing services, stationery"]
["Professional Services - Acctng ",6203,"Accounting services not related to the audit"]
["Professional Services - Legal",6206,"Legal fees (can change name to Professional Services - Legal)"]
["Professional Services - Other  ",6205,"professional services other than legal and accounting i.e. consulting fees"]
["Program Supplies  ",6320,"Supplies used for specific programs","required"]
["Project San Pedro ",7610,"cost associated with specific ministry work"]
["Prop Ins Claims (CMRS)  ",6809,"This account is for insurance claims that are paid out.  This is not insurance"]
["Property Ins Chancery  ",6807,"Property Insurance paid by DOC"]
["Property Rent ",6801,"This account is used to pay rent"]
["Property Taxes  ",6808,"Property Taxes paid by DOC"]
["Psychological evaluation ",6224,"Used for evaluation services"]
["Publication  ",6303,"This account is for newspaper subscriptions, books or any other kind of periodicals"]
["Publishing Costs  ",6214,"Used by Miscellany & Publications Office only"]
["Purchased Services ",6804,"pest control, cleaning service, trash service, etc"]
["Recognition",6329,"Used to recognize any employee or committee member with a gift, award, etc."]
["Regime Fees  ",6838,"Used for regime fees and HOA fees."]
["Regional Meetings  ",6427,"costs associated with hosting a regional meeting"]
["Religious Celebrations  ",6401,"Used for ordinations, Chrism mass, etc.","required"]
["Religious Supplies ",6301,"Used for any supplies used in a religious celebration.  i.e. wine, wafers, candles, etc."]
["Repairs & Maintenance  ",6803,"must be related to building repairs & maintenance"]
["Respect Life Ministry  ",7604,"cost associated with specific ministry work"]
["Retreats  ",6402,"cost for an employee to attend a retreat, generally a registration fee, not including travel costs"]
["Sales-Use Tax ",6335,"sales tax"]
["School Planning Consultant ",6204,"Catholic Schools Office use only"]
["Security Service  ",6810,"Sonitrol"]
["Seminars ",6403,"fees charged for employee to attend seminars"]
["Service/Maintenance Contracts  ",6704,"Contracts on equipment and software"]
["Shipping Expense (Rome)  ",6318,"Shipping/postage expense to shipping things to Rome"]
["St. Ann's Outreach Center, Kin  ",6915,"Financial assistance to St. Ann's Outreach Center","required"]
["St. Cyprian's Outreach Program  ",6907,"Financial assistance to St. Cyprian's outreach program ","required"]
["Staff meetings  ",6458,"Used for staff meeting to include food or anything needed for meeting."]
["Subsidy - Diocesan sponsored O  ",6904,"Used for financial assistance to diocesan sponsored organizations ","required"]
["Supplies - Miscellaneous Expen  ",6350,"Miscellaneous supplies not accounted for in other supply accounts.  This should not be a catch all"]
["Supplies, Non-Office ",6310,"Supplies used to make repairs or for the function of the building. i.e. light bulb, toilet paper, paper towels, kitchen supplies, etc."]
["Telephone  ",6605,"All phone charges. i.e. cell, fax, business"]
["Temporary Help  ",6228,"cost associated with temporary employees i.e. employee's hired to short term project (2 or 3 months), employee's hired to fill positions during maternity leave or illness"]
["Training-Education  ",6471,"Used for one-day trainings or in-service training that may be required. i.e. Software training, management training","may be required"]
["Travel - Airfare",6507,"airfare only - for employees and diocesan representatives"]
["Travel - Lodging ",6509,"hotel rooms - for employees and diocesan representatives"]
["Travel - Meals  ",6508,"meals while traveling - for employees and diocesan representatives"]
["Travel - Miscellaneous ",6550,"travel expenses that do not fit in the other categories i.e.. parking fees, tolls, cab fare"]
["Travel for Penal Judges ",6515,"cost associated with Penal Judges travel for tribunal cases"]
["Tribunal Appeals  ",6216,"Used by Tribunal Office only"]
["Tuition, Room & Board ",6223,"Used for seminarians, priests and any diocesan employee attending semester classes"]
["Unallocated Credit Card Charge ",6351,"Used as a place holder for credit card expenses not yet identified"]
["USCCB ",6462,"Only used by Chancery office for quarterly assessment"]
["USCCB Screening Audit ",6246,"Used by Child Protection Office for their audit by USCCB"]
["Utilities  ",6802,"This account will include all utilities to include electric, cable, water, etc."]
["Vatican Fees",6231,"Used only by Tribunal to record expenses paid to the Vatican"]
["Video Production  ",6219,"Used by Stewardship office but can be used for any video project "]
["Vietnamese Ministry ",7607,"cost associated with specific ministry work"]
["Workshops--In-Service  ",6416,"costs associated with diocesan sponsored workshops i.e. rental of facility, supplies associated with the workshop, cost associated with guest speakers (fees, travel, stipends) - *use business purpose assigned","may be required"]
["Young Adults ",7626,"cost associated with specific ministry work-only used by Catholic Youth Ministry"]
["Youth Ministry Program  ",7603,"cost associated with specific ministry work"]

{"sheet":"DEPARTMENT","index":2,"n_rows":73,"n_cols":3,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["Department","Fund","Cost Center"]
["Apostolate of the Sea",1,270]
["Archives",1,601]
["Bishop",18,608]
["Bishop's House",18,612]
["Campaign For Human Development",20,517]
["Campus Ministries",1,106]
["Campus Ministry Administration",1,105]
["Capital Campaign Expenses",1,631]
["Carter May Home/St Joseph Residence",20,506]
["Catechesis & Evangelization",1,306]
["Catholic House for Men",1,211]
["Catholic Schools Office",1,319]
["Catholic Youth Ministries",1,122]
["Central Office-Charities",20,609]
["Chancery Office",1,603]
["Child Protection Services",1,611]
["Coastal Office-Charities",20,637]
["Computer Services",1,622]
["D&L",5,618]
["Dio Celebratns/Mstr Of Ceremony",1,208]
["Diocean Property Overhead",1,620]
["Diocesan Insurance Program",1,701]
["Diocesean Endowment Due To Others",1,107]
["Echo House",20,521]
["Ecumenical ",1,104]
["Family Life",1,313]
["Finance Office",1,604]
["Financial Services",1,648]
["General Assistance",1,114]
["General Catholic Charities",20,503]
["Greenville Immigration",20,526]
["Hilton Head Immigration",20,530]
["Hispanic Ministries",1,108]
["Holy Cross Cemetery",1,802]
["Human Resources ",1,619]
["Indian & Black",1,113]
["International Ministries",1,129]
["Kingstree Shrine",1,220]
["Liaison For Religious",1,627]
["Lowcountry Deanery Office",20,638]
["Media Spokesperson",1,166]
["Midlands Office-Charities",20,610]
["Miscellany",1,703]
["Mt. Pleasant Immigration Services",20,523]
["Multi Ethnic Ministries",1,119]
["Myrtle Beach Immigration",20,520]
["New Chancery",1,600]
["Office Of Prayer & Worship",1,206]
["Office Of Publications And Information",1,103]
["Pastoral Assistance",1,207]
["Pastoral Masses",1,111]
["Pee Dee Regional Office",20,617]
["Permanent Diaconate",1,205]
["Piedmont Office-Charities",20,613]
["Piedmont Senior Care Initiative",20,562]
["Priest Continuing Education & Ongoing Formation",1,210]
["Priest Personnel",1,623]
["Priest Post Graduate Studies",1,209]
["Priest Retirement",25,266]
["Priest Retreats",1,221]
["Priests' Assistance",1,203]
["Prison Ministries",20,555]
["Research & Planning",1,614]
["Retired Bishop",18,629]
["Seminarian",1,202]
["Social Ministries",1,120]
["St Lawrence Cemetery/St. Peter's",1,801]
["Stewardship & Development",1,607]
["Tribunal",1,102]
["Vicar General's Office",1,605]
["Vocations",1,204]
["Young Adult Ministry",1,123]