{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Cover","Receipts","Exps","Balance Sheet","Cash","Notes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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 Parish 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 fax this to the Chancery when completed. (814) 949-8234."]
[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 finance@dioceseaj.org."]

{"sheet":"Cover","index":1,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[46,0,46,13],[47,0,47,13],[48,0,48,13],[50,0,50,13],[16,0,16,13],[2,0,2,13],[19,0,19,13],[26,0,26,13],[5,2,5,9],[5,11,5,13],[8,2,8,13]]}
[]
[]
["DIOCESE OF ALTOONA-JOHNSTOWN"]
[]
[]
["Church of ",null,null,null,null,null,null,null,null,null,"No."]
[]
[]
["Location"]
[]
[]
[]
[]
[]
[]
[]
["FINANCIAL REPORT FOR PARISHES AND MISSIONS"]
[]
[]
["FROM JULY 1, 20__ TO JUNE 30, 20__"]
[]
[]
[]
[]
[]
[]
["INSTRUCTIONS"]
[]
[]
[]
["1.  This report should reflect only the parish operating checking account activity.  Net income from all"]
[null,"other parish accounts should be transferred to the operating account."]
["2.  Please exclude all cemetery and school accounts from this report."]
["3.  All deeds & abstracts must be on file at the Diocesan Administration Center."]
["4.  Parish records should be kept up to date.  Preserve in Parish files all account books and records."]
["5.  Approval of Parish Finance Council and Bishop is required to buy or sell property."]
["6.  Expenditures of $10,000.00 or more must be approved by the Parish Finance Council."]
["7.  Expenditures of $25,000.00 or more must be approved by the Parish Finance Council and the Bishop."]
[]
[]
["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"]
[]
[]
["Due Date:  September 30th"]
["Mail To:   Diocesan Finance Office"]
["2713 West Chestnut Avenue, Altoona, PA 16601"]

{"sheet":"Receipts","index":2,"n_rows":67,"n_cols":11,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10]]}
["RECEIPTS"]
["FOR THE YEAR ENDED JUNE 30, 20__"]
[]
["ASSESSED RECEIPTS:"]
["ORDINARY RECEIPTS:"]
[null,"REGULAR RECEIPTS:"]
[null,null,"Regular Offertory Collection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,"$"]
[null,null,"Special Collections. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,""]
[null,null,null,"Sub Total - Collections. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,"$",{"$f":"SUM(H7:H8)","v":0}]
[null,null,"Perquisites. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,"$"]
[null,null,"Ordinary Donations. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,""]
[null,null,"Votive Candle Income. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,"$",null,""]
[null,null,"Votive Candle Expense (cannot exceed candle income) . . . . . . . . . . . . . . . . . . . ",null,"(",null,")"]
[null,null,"Votive Candle Net Income (cannot be less than zero) = Candle Income minus Expense. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,"",{"$f":"F12-F13","v":0}]
[null,null,"Misc. Regular Receipts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,""]
[null,null,null,"Sub Total - Other Regular. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  ",null,null,null,null,null,"$",{"$f":"SUM(H10:H15)","v":0}]
[null,null,null,"Total - Regular Receipts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,"$",{"$f":"K9+K16","v":0}]
[]
[null,"AUXILIARY RECEIPTS:"]
[null,null,"Collections from Other Services Income. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,"$"]
[null,null,"Collections from Other Services Expense (can not exceed income). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,"(",null,")"]
[null,null,"Collections from Other Services Net Income (can not be less than zero) = Income - Expense. . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,"",{"$f":"F20-F21","v":0}]
[null,null,"Fundraising Income(Net of Expenses) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,""]
[null,null,"Investment Income Received . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,""]
[null,null,"Rental Income. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,""]
[null,null,"Other Auxiliary Receipts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,""]
[null,null,null,"Total Auxiliary Receipts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,"$",{"$f":"SUM(H22:H26)","v":0}]
[null,null,"TOTAL ORDINARY( Regular Plus Auxiliary) RECEIPTS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,null,"$",{"$f":"K17+K27","v":0}]
[]
[null,"EXTRAORDINARY RECEIPTS:"]
[null,null,"Parish Campaigns or Drives. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,"$"]
[null,null,"Extraordinary Donations and Bequests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,""]
[null,null,"Other Extraordinary Receipts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,""]
[null,null,null,"Total Extraordinary Receipts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,"$",{"$f":"SUM(H31:H33)","v":0}]
[null,null,"TOTAL ASSESSED( Ordinary Plus Extraordinary) RECEIPTS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,"$",{"$f":"K28+K34","v":0}]
[]
["NON-ASSESSED RECEIPTS:"]
[null,null,"Sale of Property . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,"$"]
[null,null,"Catholic Register Subscriptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Diocesan Approved Capital Campaign Receipts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Parish Share of Annual Catholic Appeal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Mass Stipend Transfer Amounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Other Non-Taxable Receipts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,null,null,null,null,"$",{"$f":"SUM(F38:F43)","v":0}]
[null,null,"Mutual Aid Plan Withdrawals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Loan Proceeds . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Non-Parish Share of Annual Catholic Appeal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Transfers from Other Accounts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,null,null,null,null,"$",{"$f":"SUM(F45:F48)","v":0}]
[null,"Diocesan and Other Special Collections"]
[null,null,null,"Catholic Relief Services","$"]
[null,null,null,"Catholic Communications Campaign. . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",""]
[null,null,null,"Catholic Home Missions  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",""]
[null,null,null,"Catholic University . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."," "]
[null,null,null,"Holy Father( Peter's Pence). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",""]
[null,null,null,"Holy Land( Good Friday) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",""]
[null,null,null,"Catholic Charities Collection",""]
[null,null,null,"Minority Groups( Black & Indian Missions)  . . . . . . . . . . . . . . . . . . . . . . . . .",""]
[null,null,null,"Mission Co-Operative Plan. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",""]
[null,null,null,"Retired Priests Medical Collection. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",""]
[null,null,null,"Retirement Fund for Religious . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",""]
[null,null,null,"World Mission Sunday  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",""]
[null,null,null,"Other Collections Not Listed . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",""]
[null,null,null,"     Total Diocesan and Special Collections. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,"$",{"$f":"SUM(F51:F63)","v":0}]
[null,null,"TOTAL NON-ASSESSED RECEIPTS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,"$",{"$f":"SUM(H38:H64)","v":0}]
[]
[null,"TOTAL PARISH RECEIPTS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,"$",{"$f":"K35+K65","v":0}]

{"sheet":"Exps","index":3,"n_rows":85,"n_cols":8,"rows_kept":85,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7]]}
["EXPENDITURES"]
["FOR THE YEAR ENDED JUNE 30, 20__"]
[]
["ORDINARY ACCOUNTS:"]
[null,"PARISH:"]
[null,null,"Salaries of Resident Clergy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,"$"]
[null,null,"Extra Services of Clergy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Priest Medical/Retirement Costs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Lay Salaries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Sanctuary and Sacristy Expenditures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Ordinary Repairs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Votive Candle Expense (excess of Candle Expense over Candle Income) from page 2. . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Other Services Expense (excess of Other Services Expense over Other Services Income) page 2. . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Missions and Novenas. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Magazines, Literature, etc. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Other Incidental Expenses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,null,"Total Parish Expenditures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,"$",{"$f":"SUM(F6:F16)","v":0}]
[]
[null,"RECTORY:"]
[null,null,"Lay Salaries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,"$"]
[null,null,"Cost of Provisions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Furnishings. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Ordinary Repairs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Telephone and Office Expenses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Retreats\\Clergy Conferences\\Education . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Other Incidental Expenses. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,null,"Total Rectory Expenditures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,"$",{"$f":"SUM(F20:F26)","v":0}]
[]
[null,"ALL OTHER SEPARATE BUILDINGS:"]
[null,null,"Religious Salaries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,"$"]
[null,null,"Lay Salaries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Ordinary Repairs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Transportation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Telephone and Office Expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Other Incidental Expenses. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,null,"Total Separate Buildings Expenditures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,"$",{"$f":"SUM(F30:F35)","v":0}]
[]
[null,"RELIGIOUS EDUCATION:"]
[null,null,"Religious Salaries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,"$"]
[null,null,"Lay Salaries . . . . . . . . . . ..  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Lay Payroll Taxes and Benefits. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Transportation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Telephone and Office Expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Books and Supplies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Other Incidental Expenses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,null,"Total Religious Education Expenditures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,"$",{"$f":"SUM(F39:F45)","v":0}]
[]
[null,"GENERAL EXPENSES:"]
[null,null,"Utilities. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,"$"]
[null,null,"Taxes-Real Estate. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Lay Payroll Taxes and Benefits. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Insurance-Property, Liability, Auto and W/C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Other General Expenses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,null,"Total General Items. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,"$",{"$f":"SUM(F49:F53)","v":0}]
[]
[null,"DIOCESAN ASSESSMENTS"]
[null,null,"Cathedraticum Assessment. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,"$"]
[null,null,"Education Evangelization Assessment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,null,"Total Diocesan Assessments. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,"$",{"$f":"SUM(F57:F58)","v":0}]
[]
["EXTRAORDINARY ACCOUNTS:"]
[null,null,"Parish Subsidy to Parochial Schools( For parishes with no school). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,"$"]
[null,null,"Parish Subsidy to Parochial Schools( For parishes with a school). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,null,"Total Parish Subsidy. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,"$",{"$f":"SUM(F62:F63)","v":0}]
[null,"OTHER ACCOUNTS:"]
[null,null,"Purchase of Property & Real Estate. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,"$"]
[null,null,"Construction Costs. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Extraordinary Furnishings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Extraordinary Repairs and Improvements. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Catholic Register Subscriptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,null,null,null,null,null,{"$f":"SUM(F66:F70)","v":0}]
[null,null,"Debt-MAP Principal and Interest . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Debt-Other Principal and Interest. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Mutual Aid Plan Deposits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Foundation Deposits. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Deposits to Savings and Other Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Diocesan and Other Special Collections . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,"Annual Catholic Appeal Remittances . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,"Other Misc. Expenditures (Please explain on the \"Notes\" tab) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
[null,null,null,null,null,null,null,{"$f":"SUM(F72:F79)","v":0}]
[null,null,null,"Total Other Accounts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,"$",{"$f":"H71+H80","v":0}]
[null,null,null,"Total Extraordinary Accounts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,"$",{"$f":"H64+H81","v":0}]
[]
[]
[null,"TOTAL PARISH EXPENDITURES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,"$",{"$f":"H17+H27+H36+H46+H54+H59+H82","v":0}]

{"sheet":"Balance Sheet","index":4,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[37,0,37,6],[0,0,0,6],[2,0,2,6],[4,0,4,6],[29,0,29,2],[30,0,30,2],[31,0,31,2],[1,0,1,6]]}
["PARISH STATEMENT OF FINANCIAL CONDITION"]
["AS OF JUNE 30, 20__"]
["(Excluding all cemetery and school accounts)"]
[]
["ASSETS"]
[]
["CHECKING ACCOUNTS:  Include ALL Parish accounts"]
["Name of Bank","Type of Account","Account Number"]
[null,null,null,"$"]
[]
[]
[]
[null,"Total of Checking Accounts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,"$",{"$f":"SUM(E9:E12)","v":0}]
[]
["DEPOSITS IN SAVINGS ACCOUNTS:  Include ALL Parish accounts"]
["Name of Bank","Account Number","Interest Rate"]
[null,null,null,"$"]
[]
[]
[]
[null,"Total Deposited in Savings Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,"$",{"$f":"SUM(E17:E20)","v":0}]
[null,"Total Cash, Checking & Savings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,"$",{"$f":"G13+G21","v":0}]
[]
["INVESTMENTS & SECURITIES OWNED:"]
["Mutual Aid Plan Deposits, total all parish accounts",null,null,"$"]
["Others - (furnish details)"]
[null,"Total Investments & Securities. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,"$",{"$f":"SUM(E25:E26)","v":0}]
[]
["OTHER ASSETS:"]
[null,null,null,"$"]
[]
[]
[null,"Total of Other Assets. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,"$",{"$f":"SUM(E30:E32)","v":0}]
[]
[null,"TOTAL ASSETS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,"$",{"$f":"G22+G27+G33","v":0}]
[]
[]
["LIABILITIES & NET WORTH"]
[]
["LOANS OWED, as of June 30th:"]
["Mutual Aid Plan( Balance of Principal)",null,null,"$"]
["Others( Explain)"]
[null,"Total Notes Owed. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,"$",{"$f":"SUM(E41:E42)","v":0}]
[]
[]
["UNPAID BILLS, as of June 30th:"]
["Total Diocesan billings( provide detail on next page)",null,null,"$"]
["Other bills owed to vendors or contractors( provide detail on next page)"]
[null,"Total Unpaid Bills. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,"$",{"$f":"SUM(E47:E48)","v":0}]
[]
[null,"TOTAL LIABILITIES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,"$",{"$f":"G43+G49","v":0}]
[]
["NET WORTH OF PARISH - ( Total Assets Less Total Liabilities)  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,"$",{"$f":"G35-G51","v":0}]

{"sheet":"Cash","index":5,"n_rows":63,"n_cols":14,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,0,0,13],[44,1,44,8],[1,0,1,13],[45,1,45,8],[46,1,46,8],[47,1,47,8],[48,1,48,8],[24,0,24,13],[25,0,25,13],[57,1,57,8],[53,1,53,8],[54,1,54,8],[55,1,55,8],[56,1,56,8],[49,1,49,8],[50,1,50,8],[51,1,51,8],[52,1,52,8]]}
["SUMMARY OF CASH"]
["AS OF JUNE 30, 20__"]
[]
[]
[]
["(A)","PARISH OPERATING CHECKING ACCOUNT BALANCE, beginning of fiscal year . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,null,null,"$"]
[]
["(B)","ADDITIONS TO CASH:"]
[null,"1.","Total Receipts (from page 2). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,null,null,"$",{"$f":"Receipts!K67","v":0}]
[]
[null,null,"TOTAL PARISH RECEIPTS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,null,"$",{"$f":"L9","v":0}]
[]
["(C)","REDUCTIONS TO CASH:"]
[null,"1."," Total Parish Expenditures (from page 3). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,null,null,"$",{"$f":"Exps!H85","v":0}]
[]
[null,null,"TOTAL PARISH EXPENDITURES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,null,null,null,null,"$",{"$f":"L14","v":0}]
[]
["(D)","PARISH OPERATING ACCOUNT BALANCE, end of fiscal year . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,null,null,"$",{"$f":"N6+N11-N16","v":0}]
[null,"[ Line D must agree with Operating Checking Balance from page 4] "]
[]
[]
[]
[]
[]
["SUMMARY OF UNPAID BILLS"]
["(Bills received but not yet paid)"]
[]
[]
["(A)","DIOCESAN BILLINGS:"]
[null,"Cathedraticum. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,null,null,null,"$"]
[null,"Cathedraticum Interest. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,null,null,null,""]
[null,"Catholic Register Subscriptions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,""]
[null,"Education Evangelization. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,""]
[null,"Education Evangelization Interest. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,""]
[null,"Lay Pension. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,null,null,null,""]
[null,"Life and Disability. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,""]
[null,"Priest Medical and Retirement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,""]
[null,"Prior ACA Goals. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,""]
[null,"Property, Liability, Workman's Comp, Auto Ins. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,""]
[null,"Other . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,null,null,null,""]
[]
[null,null,"TOTAL DIOCESAN BILLINGS",null,null,null,null,null,null,null,null,null,"$",{"$f":"SUM(L30:L40)","v":0}]
[]
["(B)","OTHER BILLS OWED TO VENDORS OR CONTRACTORS:"]
[null,null,null,null,null,null,null,null,null,null,"$"]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,"TOTAL OTHER BILLS OWED TO VENDORS OR CONTRACTORS",null,null,null,null,null,null,null,null,null,"$",{"$f":"SUM(L45:L58)","v":0}]
[]
[]
["TOTAL UNPAID BILLS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,null,null,null,null,null,"$",{"$f":"N42+N60","v":0}]

{"sheet":"Notes","index":6,"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."]