{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Cover","I-S","B-S","Cash - Statistics","Notes","Attachment"],"not_rendered":{"charts":0,"images":0,"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":"Instructions","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["Instructions for completing the Cemetery Annual Report"]
[]
[1,"Save this form to a disk or hard drive first, before entering any information."]
[2,"Each page of the report is broken down by the \"Tabs\" at the bottom. \"Cover\" \"Receipts\"etc."]
[null,"Click on any tab to enter the financial information."]
[3,"Figures can only be entered in the blue boxes on the tabs."]
[4,"If you need to add additional information, enter this in the \"Notes\" tab at the end. "]
[5,"The total receipts and expenditures will automatically carry forward to the Summary of Cash.  "]
[6,"Since this is an electronic form, please print out the \"Cover\" sheet for signatures of the "]
[null,"  Pastor and Finance Council Chairman.  Please emial this to Joseph Bytella - jbytella@dioceseaj.org -  when completed. (814) 317-2614."]
[7,"Please print a copy for your records when finished by clicking on the \"Print Report\" Button below."]
[8,"Please return the completed form( saved file) to Joseph Bytella jbytella@dioceseaj.org."]

{"sheet":"Cover","index":1,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[15,0,15,13],[1,4,1,13],[3,4,3,13],[5,4,5,13],[7,4,7,13],[13,0,13,13],[47,0,47,13],[46,0,46,13],[48,0,48,13],[50,0,50,13],[18,0,18,13],[25,0,25,13]]}
[]
["Cemetery ID Number:"]
[]
["Name of Cemetery:"]
[]
["Name of Parish:"]
[]
["Location of Parish:"]
[]
[]
[]
[]
[]
["DIOCESE OF ALTOONA-JOHNSTOWN"]
[]
["ANNUAL REPORT OF CEMETERY OPERATIONS"]
[]
[]
["FROM JULY 1, 2018 TO JUNE 30, 2019"]
[]
[]
[]
[]
[]
[]
["INSTRUCTIONS"]
[]
[]
[]
["1.  Please mail completed reports by August 16th to the Finance Office, 2713 West Chestnut Ave., Altoona, PA 16601 OR e-mail to Joseph Bytella -  jbytella@dioceseaj.org"]
["2.  Multiple cemeteries in one parish may be consolidated in one report if separate records are not kept for"]
[null,"individual cemeteries."]
["3.  All deeds & plot plans must be on file at the Diocesan Administration Center."]
["4.  Cemetery bank accounts must be separate from parish accounts."]
["5.  Perpetual Care Funds are to be kept in Trust that allows only investment earnings to be used for operations."]
["6.  All expenditures of $25,000.00 or more must be approved by the Bishop."]
["7.  Each year the Cemetery Committee is to prepare a budget for review by the Parish Finance Council."]
["8.  Please attach list of Cemetery Committee members."]
[]
[]
["Date",null,null,null,null,"Signed",null,null,null,null,null,null,null,"Pastor or"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Parish Administrator"]
["Date",null,null,null,null,"Signed",null,null,null,null,null,null,null,"Chairman"]
[null,null,null,null,null,null,null,null,null,null,null,null,"of the Finance Council"]
[]
[]
[]
["Mail To:   Diocesan Finance Office"]
["2713 West Chestnut Avenue, Altoona, PA 16601"]

{"sheet":"I-S","index":2,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11],[37,2,37,5],[38,2,38,5],[40,2,40,5],[15,2,15,5],[16,2,16,5],[17,2,17,5],[18,2,18,5],[19,2,19,5],[39,2,39,5]]}
["ANNUAL RECEIPTS & EXPENDITURES"]
["Until June 30 2020"]
[]
[]
["CASH RECEIPTS:",null,null,null,null,null,null,null,"ORDINARY FUND",null,null,"PERPETUAL CARE FUND"]
[]
[null,"1.","Investment Income - Perpetual Care Fund",null,null,null,null,null,null,null,"$"]
[null,"2.","Other Perpetual Care Funds Received"]
[null,"3.","Sales of Graves and Plots",null,null,null,null,"$",1775]
[null,"4.","Foundation/Permit Fees"]
[null,"5.","Investment Income - Ordinary",null,null,null,null,null,4149]
[null,"6.","Annual Care Charges"]
[null,"7.","Grave Opening Charges",null,null,null,null,null,2495]
[null,"8.","Misc Receipts:"]
[null,null,"Description:  (attach schedule if necessary)"]
[]
[]
[]
[null,null,"Envelope collections"]
[null,null,null,null,null,null,null,null,6847]
[]
[null,null,null,"TOTAL CASH RECEIPTS",null,null,null,"$",{"$f":"SUM(I9:I20)","v":15266},null,"$",{"$f":"SUM(L7:L9)","v":0}]
[]
[]
[]
["CASH EXPENDITURES:"]
[]
[null,"1.","Salaries & Payroll Taxes/Benefits",null,null,null,null,"$",630]
[null,"2.","Fees to Open/Close Graves"]
[null,"3.","General Maintenance",null,null,null,null,null,3765]
[null,"4.","Lawn Maintenance",null,null,null,null,null,14550]
[null,"5.","Machine Maintenance"]
[null,"6.","Office Expenses"]
[null,"7.","Returned Graves"]
[null,"8.","Cemetery Improvements and Development"]
[null,"9.","Misc Expenditures:"]
[null,null,"Description:  (attach schedule if necessary)"]
[]
[]
[]
[]
[]
[null,null,null,"TOTAL CASH EXPENDITURES",null,null,null,"$",{"$f":"SUM(I28:I41)","v":18945}]
[]
[]
["Excess ( Deficit) for Ordinary Fund",null,null,null,null,null,null,"$",{"$f":"I22-I43","v":-3679}]

{"sheet":"B-S","index":3,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11]]}
["ASSETS & LIABILITIES"]
["As of June 30, 2020"]
[]
[]
["CURRENT ASSETS OF CEMETERY:"]
[]
[null,"Cash in Bank:"]
[null,null,"Ordinary Fund",null,null,null,null,"$",7348]
[null,null,"Perpetual Care Fund"]
[null,null,null,"TOTAL",null,null,null,null,null,null,"$",{"$f":"SUM(I8:I9)","v":7348}]
[null,"Investments (attach schedule):"]
[null,null,"Ordinary Fund"]
[null,null,"Perpetual Care Fund"]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,{"$f":"SUM(I12:I13)","v":0}]
[null,"Loans Receivable:"]
[null,null,"Parish"]
[null,null,"Others (attach schedule)"]
[null,null,null,"TOTAL",null,null,null,null,null,null,null,{"$f":"SUM(I16:I17)","v":0}]
[null,"Other Assets:  (attach schedule)"]
[]
[null,null,null,null,"TOTAL ASSETS OF CEMETERY",null,null,null,null,null,"$",{"$f":"SUM(L10:L19)","v":7348}]
[]
[]
[]
[]
["LIABILITIES OF ORDINARY FUNDS:"]
[]
[null,"Unpaid Bills",null,null,null,null,null,"$",0]
[null,"Loans Payable:"]
[null,null,"To Parish"]
[null,null,"Others (attach schedule)"]
[null,"Other Short Term Debts"]
[]
[null,null,null,null,"TOTAL LIABILITIES",null,null,null,null,null,"$",{"$f":"SUM(I28:I32)","v":0}]

{"sheet":"Cash - Statistics","index":4,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,10],[28,0,28,10]]}
["SUMMARY OF CASH BALANCE"]
[]
[null,null,null,null,null,null,null,"ORDINARY FUND",null,null,"PERPETUAL CARE"]
["Beginning Balance, July 1, 2019",null,null,null,null,null,"$",12684,null,"$"]
["Add:"]
["Receipts for the Year, per Annual Report",null,null,null,null,null,null,{"$f":"'I-S'!I22","v":15266},null,null,{"$f":"'I-S'!L22","v":0}]
["Deduct:"]
["Expenditures for the Year, per Annual Report",null,null,null,null,null,"(",{"$f":"'I-S'!I43","v":18945},")"]
["Add or (Deduct):"]
["Bank Transfers between Ordinary/Perpetual",null,null,null,null,null,null,0,null,null,0]
["Bank Transfers to/from Parish accounts",null,null,null,null,null,null,0,null,null,"  "]
["Ending Balance, June 30, 2018",null,null,null,null,null,"$",{"$f":"H4+H6-H8+H10+H11","v":9005},null,"$",{"$f":"K4+K6+K10+K11","v":{"$error":"#VALUE!"}}]
[]
[]
["If the information is available, please report the following data:"]
[]
["FIXED ASSETS:  (Original Cost Less Depreciation)"]
[]
["Land (Original Cost)",null,null,null,null,null,null,null,null,"$"]
["Improvements  (Roads, Buildings, Site Development, etc.)"]
["Vehicles"]
["Other Machines and Tools"]
["Office Equipment"]
["Other Assets"]
[]
["TOTAL FIXED ASSETS",null,null,null,null,null,null,null,null,"$",{"$f":"SUM(K19:K24)","v":0}]
[]
[]
["GENERAL STATISTICS"]
[]
["1.","Number of Internments during this Fiscal Year",null,null,null,null,null,null,null,null,32]
["2.","Purchase Price per Grave"]
[null,"a)","perpetual care amount",null,null,null,null,null,null,"$"]
[null,"b)","plot sale amount",null,null,null,null,null,null,"$"]
["3.","Is there an Operating Budget for the next Fiscal Year?"]
["4.","Number of Acres in Cemetery"]
["5.","Is the Cemetery at or near full capacity?"]
[null,"Do you have a plan to expand the cemetery?"]
[null,"If yes, please attach a brief explanation"]
["6.","How is maintenance provided?  (Select from list)"]
[]
[]
[]
["7.","Is there a Mausoleum?"]
[null,"a)","age of building (in years)"]
[null,"b)","number of cypts"]
[null,"c)","is it at or near capacity?"]
[null,"d)","average sale price per crypt?"]
[null,null,"(I)","perpetual care amount",null,null,null,null,null,"$"]
[null,null,"(II)","crypt amount",null,null,null,null,null,"$"]
[]
["8.","Do you plan to withdrawal any savings from the MAP Trust in the next 12 months?"]
[null,null,"If so, how much?",null,null,null,null,null,null,"$"]

{"sheet":"Notes","index":5,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Please enter any notes below as additional information to the report."]

{"sheet":"Attachment","index":6,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,5,35,9],[14,8,14,9],[10,8,10,9],[12,8,12,9],[26,5,26,9],[19,1,19,9],[20,1,20,9],[21,1,21,9],[22,1,22,9],[27,5,27,9],[28,5,28,9],[32,5,32,9]]}
["Diocese of Altoona-Johnstown"]
["Attachment to Cemetery Report for June 30, 2019"]
[]
[]
["Questions regarding Mausoleums are being raised throughout"]
["Pennsylvania by Cemetery Commissions.  These questions are serious"]
["enough to prompt a study in our Diocese.  The Following questions are"]
["to be answered only by Pastors/Committes who presently have"]
["mausoleums:"]
[]
[1,"What is the total number of crypts in your mausoleum(s)?"]
[]
[2,"How many crypts are not yet sold?"]
[]
[3,"Does you mausoleum feature an inside chapel or meditation room?",null,null,null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[4,"What complaints or concerns, if any, regarding your mausoleum have surfaced"]
[null,"from either your cemetery staff or families who have purchased burial"]
[null,"rights/crypts?"]
[]
[]
[]
[]
[]
[5,"Please report here the amount of money spent this past year on your mausoleum:"]
[]
[null,"(A)","Maintenance",null,"$"]
[null,"(B)","Repair to the structure",null,"$"]
[null,"(C)","Improvements",null,"$"]
[]
[6,"What repairs or improvements to your mausoleum do you forsee?:"]
[]
[null,"(A)","This coming year:"]
[null,null,"   Estimated cost:",null,"$"]
[]
[null,"(B)","In the next five years:"]
[null,null,"   Estimated cost:",null,"$"]