{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Cover","Receipts","Exps","Balance Sheet","Cash","Food Srv Report","Notes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["Instructions for completing the School 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.  "]
[null,"However, if Food Service activity is included in the operating account, those totals need to be manually entered."]
[6,"Since this is an electronic form, please print out the \"Cover\" sheet for signatures of the "]
[null,"  Pastor, Principal, and School Chair.  Please send to the Finance department."]
[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":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[[21,4,21,13],[48,0,48,13],[2,0,2,13],[8,0,8,13],[12,0,12,13],[5,0,5,13],[28,12,28,13],[43,0,43,13],[44,0,44,13],[45,0,45,13],[46,0,46,13]]}
[]
[]
["DIOCESE OF ALTOONA-JOHNSTOWN"]
[]
[]
["ELEMENTARY SCHOOLS"]
[]
[]
["ANNUAL FINANCIAL REPORT"]
[]
[]
[]
["FROM JULY 1, 20___ TO JUNE 30, 20___"]
[]
[]
[]
[]
[]
[]
[]
[]
["SCHOOL NAME"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"SIGNATURES",null,null,null,null,null,null,"DATE"]
[]
[]
["PRINCIPAL___________________________________________________",null,null,null,null,null,null,null,null,null,null,null,"_________________"]
[]
[]
["PASTOR______________________________________________________",null,null,null,null,null,null,null,null,null,null,null,"_________________"]
[]
[]
["SCHOOL COUNCIL CHAIR_____________________________________",null,null,null,null,null,null,null,null,null,null,null,"_________________"]
[]
[]
[]
[]
[]
["Due Date:  September 30"]
["Mail To:   Diocesan Finance Office"]
["2713 West Chestnut Avenue, Altoona, PA  16601"]
["finance@dioceseaj.org"]

{"sheet":"Receipts","index":2,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,0,1,5],[0,0,0,5]]}
["RECEIPTS"]
["FOR THE YEAR ENDED JUNE 30, 2020"]
[]
["SUBSIDIES"]
["Parish Subsidy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,"$"]
["Subsidy from Other Parishes( please list each parish). . . . . . . . . . . . . . . . . .",null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,"Sub Total - Parish Subsidy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,"$",{"$f":"SUM(D5:D12)","v":0}]
[]
["OTHER RECEIPTS"]
["Student Tuition. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,"$"]
["Delinquent Tuition . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
["Scholarship, Grants & Endowments. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
["Fundraising by Parent Organizations( Net of Expenses). . . . . . . . . . . . . . . .",null,""]
["Fundraising by School( Net of Expenses) . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
["Donations and Bequests. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
["Athletic Programs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
["Rental Income. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
["Investment Income Received . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
["Sale of Supplies. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
["E-Rate Receipts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
["Special Collections. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,""]
["Miscellaneous Income(provide details below). . . . . . . . . . . . . . . . . . . . . . . . . .",null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[]
[]
[null,"Sub Total - Other Receipts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,"$",{"$f":"SUM(D15:D33)","v":0}]
[]
[null,"TOTAL RECEIPTS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,"$",{"$f":"F13+F34","v":0}]

{"sheet":"Exps","index":3,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9]]}
["EXPENDITURES"]
["FOR THE YEAR ENDED JUNE 30, 2020"]
[]
[]
["OFFICE AND ADMINISTRATIVE"]
["Lay Salaries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,"$"]
["Lay Payroll Taxes and Benefits. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  .",null,null,null,null,null,""]
["Religious Stipends and Compensation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,""]
["Telephone Expense. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,""]
["Contracted Administrative Costs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,""]
["Materials and Supplies. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,""]
["Special Collection Remittances. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,""]
["Other Administrative Expense. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,""]
[null,"Sub Total - Office & Administrative Expenses. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,"$",{"$f":"SUM(H6:H13)","v":0}]
[]
["INSTRUCTIONAL",null,null,null,null,"Academic",null,"Religious"]
["Lay Salaries . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,""]
["Religious Stipends and Compensation . . . . . . . .",null,null,null,""]
["Library and Audiovisual . . . . . . . . . . . . . . . . . . .",null,null,null,""]
["Instructional Materials. . . . . . . . . . . . . . . . . . . . .",null,null,null,""]
["Technology Costs. . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,""]
["Staff Development. . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,""]
["Student Activities. . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,""]
["Other Instructional Expenses. . . . . . . . . . . . . . . .",null,null,null,""]
[null,"Sub Totals . . . . . . . . . . . . . . . . . . . . . . .",null,null,"",{"$f":"SUM(F17:F24)","v":0},null,{"$f":"SUM(H17:H24)","v":0}]
[null,"Sub Total - Instructional Expenses. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,null,"$",{"$f":"F25+H25","v":0}]
[]
["OPERATIONS AND BUILDING MAINTENANCE"]
["Lay Salaries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,"$"]
["Utilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,""]
["Insurance-Property, Liability, Auto & W/C. . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,""]
["Materials and Supplies. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,""]
["Contracted Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,""]
["Furniture and Equipment( under $1,000.00) . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,""]
["Rental Fees for Use of Outside Facilities. . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,""]
["Repairs and Improvements"]
["Other Operations and Building Maintenance . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,""]
[null,"Sub Total - Operations and Maintenance. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,null,"$",{"$f":"SUM(H29:H37)","v":0}]
[]
["CAPITAL EXPENDITURES"]
["Purchase of Property and Real Estate. . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,"$"]
["Extraordinary Repairs and Improvements . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,""]
["Technology Equipment. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,""]
["Other Capital Expenditures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,""]
[null,"Sub Total - Capital Expenditures",null,null,null,null,null,null,"$",{"$f":"SUM(H41:H44)","v":0}]
[]
["PAYMENTS ON LOANS"]
["Debt - MAP Principal & Interest . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,"$"]
["Debt - Other Principal & Interest. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  .",null,null,null,null,null,""]
[null,"Sub Total - Loan Payments. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,null,"$",{"$f":"SUM(H48:H49)","v":0}]
[]
[null,"TOTAL EXPENDITURES. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,null,null,"$",{"$f":"J14+J26+J38+J45+J50","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],[3,0,3,6],[1,0,1,6]]}
["STATEMENT OF FINANCIAL CONDITION"]
["AS OF JUNE 30, 2020"]
[]
["ASSETS"]
[]
["CHECKING ACCOUNTS:  Include ALL School accounts"]
["Name of Bank","Type of Account","Account Number",null,"June 30th Balance"]
[null,null,null,"$"]
[]
[]
[]
[]
[null,"Total of Checking Accounts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,"$",{"$f":"SUM(E8:E12)","v":0}]
[]
["DEPOSITS IN SAVINGS ACCOUNTS:  Include ALL School 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 of all accounts",null,null,"$"]
["Others - (furnish details on Notes Tab)"]
[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 SCHOOL - ( Total Assets Less Total Liabilities)  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,"$",{"$f":"G35-G51","v":0}]

{"sheet":"Cash","index":5,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,0,0,7],[27,0,27,7],[28,0,28,7],[1,0,1,7]]}
["SUMMARY OF CASH"]
["AS OF JUNE 30, 2020"]
[]
[]
[]
["(A)","SCHOOL OPERATING CHECKING ACCOUNT BALANCE, beginning of fiscal year . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,"$"]
[]
["(B)","ADDITIONS TO CASH:"]
[null,"1.","Total School Receipts (from page 2). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,"$",{"$f":"Receipts!F36","v":0}]
[null,2,"Total Food Service Receipts if included in the operating checking account . . . . . . .",null,"$"]
[null,3,"Transfers from other accounts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,"$"]
[]
[null,null,"TOTAL ADDITIONS TO CASH. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,"$",{"$f":"SUM(F9:F11)","v":0}]
[]
["(C)","REDUCTIONS TO CASH:"]
[null,"1.","Total School Expenditures (from page 3). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,"$",{"$f":"Exps!J52","v":0}]
[null,2,"Total Food Service Expenditures if included in operating checking account . . . . . . .",null,"$"]
[null,3,"Transfers to other accounts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,"$"]
[]
[null,null,"TOTAL REDUCTIONS TO CASH . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,"$",{"$f":"SUM(F16:F18)","v":0}]
[]
["(D)","SCHOOL OPERATING ACCOUNT BALANCE, end of fiscal year . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,null,null,"$",{"$f":"SUM(H6+H13-H20)","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,"Lay Pension. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,"$"]
[null,"Life and Disability. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,""]
[null,"Property, Liability, Workman's Comp, Auto Ins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,""]
[null,"Technology Support, Equipment, and Software Costs . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,""]
[null,"Other. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,""]
[]
[null,null,"TOTAL DIOCESAN BILLINGS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,"$",{"$f":"SUM(F33:F37)","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,"TOTAL OTHER BILLS OWED TO VENDORS OR CONTRACTORS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,"$",{"$f":"SUM(F42:F56)","v":0}]
[]
[]
["TOTAL UNPAID BILLS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,null,null,null,null,"$",{"$f":"H39+H58","v":0}]

{"sheet":"Food Srv Report","index":6,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4]]}
["FOOD SERVICE"]
["SUPPLEMENTAL REPORT"]
["AS OF JUNE 30, 2020"]
[]
[]
[]
["Income"]
["Government Subsidies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ","$"]
["Receipts from Non-Government Sources. . . . . . . . . . . . . . . . . . . . . . . . . . . ","$"]
[]
["Total Food Service Income. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,"$",{"$f":"SUM(C8:C9)","v":0}]
[]
[]
["Expenditures"]
["Lay Salaries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ","$"]
["Lay Payroll Taxes and Benefits. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ","$"]
["Food Purchases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ","$"]
["Milk Purchases. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ","$"]
["Cafeteria Supplies( non-food) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .","$"]
["Other Food Service Expense . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ","$"]
[]
["Total Food Service Expenditures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,null,"$",{"$f":"SUM(C15:C20)","v":0}]

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