{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Toolkit Trial Balance","Schedules","Parishioner Report Template","YE Memo & Rest. Definitions"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":88,"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":"Toolkit Trial Balance","index":0,"n_rows":431,"n_cols":15,"rows_kept":431,"cut":false,"hidden":false,"merged":[[299,0,299,2],[291,0,291,8],[290,0,290,8],[33,6,33,7],[33,5,34,5],[39,1,39,7],[0,0,0,3],[16,0,16,3],[1,0,1,3],[12,0,12,3],[13,1,13,3],[14,1,14,3],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,0,9,3],[39,11,39,15],[38,14,38,15],[4,0,4,3],[10,0,10,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[32,0,32,8],[20,1,20,3],[27,0,27,2],[22,10,22,11],[23,10,23,11],[24,10,24,11],[25,10,25,11]]}
["INTRODUCTION",null,null,null,null,null,null,null,null,"Hide this column before distributing"]
["The purpose of this Toolkit is to streamline the preparation of the annual report to the Diocese of Cleveland by minimizing the duplication of data entry and to automate the summarization of the data input to the trial balances below into the report document that will also act as a model financial report that the parish may wish to present to its parishioners.",null,null,null,null,null,null,null,null,"This column contains instructions for the Diocese for use when updating the Trial Balance spreadsheet to ensure that all row and column references are correct."]
[]
["The Toolkit consists of the following tabs:"]
["Toolkit Trial Balance (GREEN TAB)--this is the current tab and provides space to insert the basic financial information using the Diocese's chart of accounts.  You need to insert the requested financial information described below in the respective columns for the following periods (Enter data only in the cells highlighted in yellow or green--do not add any lines to this tab - DO NOT USE CUT AND PASTE):"]
["Column"]
["G","Current year\n    ended",null,"2021-06-30",null,null,null,null,null,"Must change dates each year and ensure column reference is correct"]
["H","Prior year\n    ended",null,"2020-06-30",null,null,null,null,null,"Must change dates each year and ensure column reference is correct"]
["I","Budget for year\n    ending",null,"2022-06-30",null,null,null,null,null,"Must change dates each year and ensure column reference is correct"]
["Schedules (BLUE TAB)--this is the tab for the spreadsheet in which you must enter selected supplemental information required by the Diocese.  At the top of that spreadsheet there is a table that indicates based on the information you have provided on the Toolkit Trial Balance tab the schedules that your parish is required to complete.  Enter data only in the cells highlighted in yellow.  Insert rows as necessary on this tab."]
["Parishioner Report Template (RED TAB)--this tab represents your parish's summary financial financial information for the current fiscal year ended June 30 as well as for the immediately preceding fiscal year and the budget for the coming fiscal year.  The information contained in this tab has been automatically extracted from the information you entered into the Toolkit Trial Balance tab - you should make no entries on the Parishioner Report Template tab.  The Statements of Assets, Liabilities and Fund Balance, and the Statements of Revenues and Expenses for the Church, School and Cemetery, appearing on the Parishioner Report Template tab contain the minimum information that a parish must include in its annual report to its parishioners.  In preparing its annual report to its parishioners from the information on this tab, a parish should delete any Statements of Revenue and Expenses (e.g. School and/or Cemetery) as well as any line items in the statements that are not applicable to the parish and my add line items to the extent the parish deems appropriate to convey the nature of its operations.  Additionally, in reporting to parishioners, a parish may combine any individual line items that do not exceed $5,000 with other line items to keep the amounts reported to relevant amounts.  To the extent that the Accounts Payable and Accrued Expenses includes an amount payable to the Diocese, the parish is encouraged to show that amount separately in its Statement of Assets, Liabilities and Fund Balance."]
[]
["Viewing and printing financial statements included in report to Diocese--your parish's Financial Report to the Diocese consists of the Statement of Assets, Liabilities and Fund Balance and the Statements of Operations for your Church, School and Cemetery that appear below, starting with row 287 and the exhibits from the accompany blue tab.  To view and/or print the respective statements, please press the appropriate button below:",null,null,null,null,null,null,null,null,"Must ensure that row number reference is unchanged"]
[]
[]
[]
["INSTRUCTIONS FOR USE OF TOOLKIT"]
[1,"Entering Parish Identity Information--enter in the cells highlighted in yellow in rows 24 through 31 the parish identity information",null,null,null,null,null,null,null,"Must ensure that row reference is correct"]
[2,"Entering Financial Data--in columns G and H enter the balance sheet and income statement trial balance information for the periods indicated in the respective cells.  In column I enter the budgeted income statement information for the period indicated.  With respect to column I, if your parish does not prepare its budget using the detailed account numbers from the Diocesan chart of accounts, input the data in the caption that most closely describes the nature of the budgeted item.",null,null,null,null,null,null,null,"Must ensure column reference is correct"]
[3,"Derivation of Fund Balance at Beginning of Period--row 62 balance sheet section below requires that the \"Fund balance at the beginning of the period\" be entered in columns G and H.  The \"Fund balance at the beginning of the period\" is the difference between the total assets and total liabilities at the end of the prior period.  This amount is sometimes referred to as net worth or net equity.  If total liabilities exceed total assets, the amount should be entered as a negative number.",null,null,null,null,null,null,null,"Must ensure that row and column references are correct"]
[4,"Determining if Financial Data is in Balance and Completion of Schedules--once it is determined that columns G and H are in balance (see row 37 that indicates whether the respective columns are in balance) and you have entered the budget information for the coming fiscal year in column I, Go to the Schedules tab and complete the schedules required for your parish as indicated by the table at the top of the Schedules spreadsheet.",null,null,null,null,null,null,null,"Must ensure that row and column references are correct"]
[]
[null,null,null,null,null,null,null,"Operating",null,null,"TOAL"]
["NAME OF PARISH",null,null,null,null,null,{"$f":"SUM(I73:I84)-SUM(I94:I158)","v":0},"Parish Budget",{"$f":"I173","v":0},null,"Parish Budget"]
["ADDRESS",null,null,null,null,null,{"$f":"SUM(I176:I188)-SUM(I197:I266)","v":0},"School Budget",{"$f":"I280","v":0},null,"School Budget"]
["CITY, STATE, ZIP CODE",null,null,null,null,null,{"$f":"SUM(I283-SUM(I284))","v":0},"Cemetery Budget",{"$f":"I285","v":0},null,"Cemetery Budget"]
["PARISH NUMBER",null,null,null,null,null,"Deficits will show in red."]
["PERSON TO CONTACT\n  WITH QUESTIONS:"]
[null,"Name"]
[null,"Telephone"]
[null,"Email"]
[]
["USE ONLY THE ACCOUTS PROVIDED BELOW.  DO NOT ADD OTHER ACCOUNTS.  IF YOUR SYSTEM USES ACCOUNTS NOT SHOWN HERE, INCLUDE THE AMOUNTS IN THE CAPTIONS THAT BEST FIT THE CLASSIFICATION YOUR SYSTEM USES.\nEMAIL THIS FILE TO: parishaccounting@dioceseofcleveland.org  DATE DUE:  August 13, 2021"]
[null,null,null,null,null,"Sched\nule\nrefer-\nence","Year Ended June 30,",null,"Budget Year\nEnding\nJune 30,"]
[null,null,null,null,null,null,{"$f":"$D$7","v":"2021-06-30"},{"$f":"$D$8","v":"2020-06-30"},{"$f":"$D$9","v":"2022-06-30"}]
["Spreadsheet audit control tests:",null,null,null,null,null,"Enter data from system","Enter Data from last year's toolkit"]
[null,"Total asset accounts equal total of liability and net worth accounts for period end.  If \"NO\" indicated, determine why and correct.",null,null,null,null,{"$f":"IF(ROUND(G54,2)=(ROUND(G68,2)),\"YES\",CONCATENATE(\"ERROR Off-\",\" \", \"$\", SUM((ROUND(G54,2)-(ROUND(G68,2))))))","v":"YES"},{"$f":"IF(ROUND(H54,2)=(ROUND(H68,2)),\"YES\",CONCATENATE(\"ERROR Off-\",\" \", \"$\", SUM((ROUND(H54,2)-(ROUND(H68,2))))))","v":"YES"}]
[null,"Does beginning fund balance equal ending fund balance from prior year?",null,null,{"$f":"IF(ROUND(H67,2)=ROUND(G62,2),\"YES\",CONCATENATE(\"ERROR   OFF BY\",\" \",ROUND((H67-G62),2)))","v":"YES"},null,null,null,null,null,null,"Designated Collections In - less designated collections out="]
[null,"If not YES and there is an ERROR above- Please explain difference amount:",null,null,null,null,null,null,null,null,null,{"$f":"SUM(ROUND(G90, 2)-ROUND(G167,2))","v":0},{"$f":"IF(L39=0,\"OK\",CONCATENATE(\"ERROR\"))","v":"OK"},null,"IF NOT ZERO\nExplain Below:"]
[null,"Please type in this box………",null,null,null,null,null,null,null,null,null,"Please type in this box….."]
[]
[]
[null,null,null,"Amount Payable to Diocese (from prior year annual report)"]
[null,"Acct","Old\nRpt\nLine","Chart of Accounts Caption","Mapping to Diocesan\nAnnual Report"]
[null,null,null,null," "]
[null,null,null,null,"Use dropdown arrow to right to see components of a caption","Sched-\nule",null,null,null,null,null,"This area may be used for parish notes:"]
["BALANCE SHEET DETAIL ",null,null,null," "]
[null,"0101.00",null,"Cash in bank - checking (Schedule A page 1)","b-Cash (Sch A)","A",0]
[null,"0102.00",null,"Savings and investments (Schedule A page 2)","b-Investments (Sch A)","A"]
[null,"0103.00",null,"Accounts receivable","b-Accounts Receivable"]
[null,"0104.00",null,"Prepaid expenses","b-Other Assets (Sch P)","P"]
[null,"0105.00",null,"Other assets","b-Other Assets (Sch P)","P"]
[null,"0200.00",null,"Fixed assets","b-Other Assets (Sch P)","P"]
[null,null,null,"Total Assets",null,null,{"$f":"SUM(G48:G53)","v":0},{"$f":"SUM(H48:H53)","v":0}]
[null,"0301.00",null,"Accounts payable  (Schedules B and C)","b-Accts Payable and Accrued Exp (Sch C)","C"]
[null,"0302.00",null,"Income received in advance","b-Income Received in Advance","Q"]
[null,"0303.00",null,"Employee withholdings","b-Employee Withholding"]
[null,"0304",null,"Accrued liabilities (Schedule C)","b-Accts Payable and Accrued Exp (Sch C)","C"]
[null,"0305.00",null,"Deferred restricted support","b-Deferred Restricted Support (Sch N)","N"]
[null,"0400.00",null,"Loans, notes and Mortgages Payable (Schedule D)","b-Loans, Notes & Mrtgs Payable (Sch D)","D"]
[null,null,null,"Total Liabilities",null,null,{"$f":"SUM(G55:G60)","v":0},{"$f":"SUM(H55:H60)","v":0}]
[null,"0500.00",null,"Fund balance beginning of fiscal period (Jul 1)","b-Beginning Fund Balance"]
[null,null,null,"Net surplus (deficit) for period as per below"]
[null,null,null,"Church",null,null,{"$f":"G173","v":0},{"$f":"H173","v":0}]
[null,null,null,"School",null,null,{"$f":"G280","v":0},{"$f":"H280","v":0}]
[null,null,null,"Cemetery",null,null,{"$f":"G285","v":0},{"$f":"H285","v":0}]
[null,"0500.00",null,"Ending Fund Balance",null,null,{"$f":"SUM(G62:G66)","v":0},{"$f":"SUM(H62:H66)","v":0}]
[null,null,null,"Total Liabilities and Ending Fund Balance",null,null,{"$f":"G61+G67","v":0},{"$f":"H61+H67","v":0}]
[]
[]
["CHURCH INCOME STATEMENT DETAIL",null,null,null," "]
[null,1000,"OPERATING RECEIPTS",null," "]
[null,1001,1,"Offertory Collections","ch-Offertory Collections"]
[null,1002,2,"Other Collections","ch-Other Collections"]
[null,1004,3,"Bequests, Donations and Restricted Funds","ch-Donations & Bequests"]
[null,1005,4,"Contributions from Parish Organizations","ch-Contributions from Parish Organizations"]
[null,1006,5,"Income from Parish Programs","ch-Income from Parish Programs"]
[null,1007,6,"Income from Teaching Activities","ch-Income from Parish Programs"]
[null,1008,7,"Net Bingo Proceeds","ch-Net Bingo Proceeds"]
[null,1009,8,"Fund-Raising Income","ch-Fund Raising Income (Sch M)","M"]
[null,1010,9,"Investment Income","ch-Investment Income"]
[null,1011,10,"Rental Receipts","ch-Rental Receipts (Sch O)","O"]
[null,1012,11,"Endowment Income","ch-Investment Income"]
[null,1013,12,"Miscellaneous Receipts","ch-Miscellaneous Receipts (Sch E)","E"]
[null,1100,"EXTRAORDINARY RECEIPTS",null," "]
[null,1101,14,"Diocesan Subsidies","ch-Extraordinary Receipts (Sch F)","F"]
[null,1102,15,"Receipts from Sale of Property","ch-Extraordinary Receipts (Sch F)","F"]
[null,1103,16,"Receipts from Insurance Claims","ch-Extraordinary Receipts (Sch F)","F"]
[null,1104,null,"Transfer to (from) school","ch-Intra-Parish Transfers/School Support"]
[null,1106,17,"Diocese Designated Collections Received","ch-Designated Collections"]
[null,1109,18,"Other Extraordinary Receipts","ch-Extraordinary Receipts (Sch F)","F"]
[null,null,null,"Church Revenues",null,null,{"$f":"SUM(G73:G91)","v":0},{"$f":"SUM(H73:H91)","v":0},{"$f":"SUM(I73:I91)","v":0}]
[null,2000,"ADMINISTRATION",null," "]
[null,2001,"21 & 22","Salaries and Other Compensation:","ch-Salaries, Benefits, & Taxes"]
[null,2002,23,"Payroll Taxes and Fringe Benefits","ch-Salaries, Benefits, & Taxes"]
[null,2003,24,"General Administrative Expenses","ch-Parish Office & Administration"]
[null,2004,25,"Rectory Food and Household Supplies","ch-Rectory & Household"]
[null,2005,26,"Staff Development and Training","ch-Parish Office & Administration"]
[null,2006,27,"Publications and Periodicals","ch-Parish Office & Administration"]
[null,2007,28,"Interest Expense","ch-Parish Office & Administration"]
[null,2015,29,"Miscellaneous Expenses","ch-Parish Office & Administration","G"]
[null,2100,"CELEBRATING",null," "]
[null,2101,"31 & 32","Salaries and Other Compensation:","ch-Salaries, Benefits, & Taxes"]
[null,2102,33,"Payroll Taxes and Fringe Benefits","ch-Salaries, Benefits, & Taxes"]
[null,2103,34,"Altar, Sanctuary and Liturgy","ch-Altar, Sanctuary, & Liturgical"]
[null,2104,35,"Spiritual Growth Activities","ch-Altar, Sanctuary, & Liturgical"]
[null,2105,36,"Staff and Parishioner Training","ch-Altar, Sanctuary, & Liturgical"]
[null,2115,37,"Miscellaneous Expenses","ch-Altar, Sanctuary, & Liturgical","G"]
[null,2200,"CARING",null," "]
[null,2201,39,"Salaries and Other Compensation","ch-Salaries, Benefits, & Taxes"]
[null,2202,40,"Payroll Taxes and Fringe Benefits","ch-Salaries, Benefits, & Taxes"]
[null,2203,41,"Christian Service Programs","ch-Community Outreach"]
[null,2205,42,"Staff Development and Training","ch-Community Outreach"]
[null,2206,43,"Administrative Expenses","ch-Community Outreach"]
[null,2215,44,"Miscellaneous Expenses","ch-Community Outreach","G"]
[null,2300,"TEACHING (EXCLUDING ELEMENTARY SCHOOL)",null," "]
[null,2301,46,"Salaries and Other Compensation","ch-Salaries, Benefits, & Taxes"]
[null,2302,47,"Payroll Taxes and Fringe Benefits","ch-Salaries, Benefits, & Taxes"]
[null,2303,48,"PSR Instructional Expenses (K-12)","ch-Religious Education"]
[null,2304,49,"Other Teaching Programs","ch-Religious Education"]
[null,2305,50,"Staff Development and Training","ch-Religious Education"]
[null,2306,51,"Administrative Expenses","ch-Religious Education"]
[null,2307,52,"Volunteer Recognition Expense","ch-Religious Education"]
[null,2308,53,"Teacher Certification Training","ch-Religious Education"]
[null,2309,54,"REO Assessment Fees","ch-Religious Education"]
[null,2310,55,"Memberships and Subscriptions","ch-Religious Education"]
[null,2315,56,"Miscellaneous Expenses","ch-Religious Education","G"]
[null,2400,"STEWARDSHIP AND EVANGELIZING",null," "]
[null,2401,58,"Salaries and Other Compensation","ch-Salaries, Benefits, & Taxes"]
[null,2402,59,"Payroll Taxes and Fringe Benefits","ch-Salaries, Benefits, & Taxes"]
[null,2403,60,"Evangelization Programs","ch-Stewardship & Evangelization"]
[null,2405,61,"Staff Development and Training","ch-Stewardship & Evangelization"]
[null,2406,62,"Administrative Expenses","ch-Stewardship & Evangelization"]
[null,2415,63,"Miscellaneous Expenses","ch-Stewardship & Evangelization","G"]
[null,2500,"PARTICIPATING",null," "]
[null,2501,65,"Salaries and Other Compensation","ch-Salaries, Benefits, & Taxes"]
[null,2502,66,"Payroll Taxes and Fringe Benefits","ch-Salaries, Benefits, & Taxes"]
[null,2503,67,"Participating Activities","ch-Community Outreach"]
[null,2505,68,"Staff Development and Training","ch-Community Outreach"]
[null,2506,69,"Administrative Expenses","ch-Community Outreach"]
[null,2515,70,"Miscellaneous Expenses","ch-Community Outreach","G"]
[null,2600,"PLANT OPERATION",null," "]
[null,2601,72,"Salaries and Other Compensation","ch-Salaries, Benefits, & Taxes"]
[null,2602,73,"Payroll Taxes and Fringe Benefits","ch-Salaries, Benefits, & Taxes"]
[null,2607,74,"Contracted Services","ch-Maintenance, Repairs, & Plant Operating"]
[null,2608,75,"Utilities","ch-Utilities"]
[null,2609,76,"Plant Operation Supplies","ch-Maintenance, Repairs, & Plant Operating"]
[null,2610,77,"Rental of Facilities and Equipment","ch-Maintenance, Repairs, & Plant Operating"]
[null,2611,78,"Replacement of Equipment","ch-Maintenance, Repairs, & Plant Operating"]
[null,2612,79,"Property and Casualty Insurance","ch-Insurance & Property Taxes"]
[null,2613,80,"Vehicle Expenses","ch-Maintenance, Repairs, & Plant Operating"]
[null,2614,81,"Property Taxes","ch-Insurance & Property Taxes"]
[null,2615,82,"Miscellaneous Expenses","ch-Maintenance, Repairs, & Plant Operating","G"]
[null,2700,"OTHER OPERATING DISBURSEMENTS"]
[null,2704,84,"Diocese Assessments","ch-Diocesan Assessments"]
[null,2705,85,"Payments Made to Other Schools","ch-School Support"]
[null,2706,8,"Fund-Raising Expense","ch-Fund Raising Income (Sch M)","M"]
[null,2708,null,"Rental Expense ","ch-Rental Receipts (Sch O)","O"]
[null,3000,"CAPITAL DISBURSEMENTS",null," "]
[null,3001,88,"Land","ch-Capital Expenditures"]
[null,3002,89,"Land Improvements","ch-Capital Expenditures"]
[null,3003,90,"Buildings and Additions","ch-Capital Expenditures"]
[null,3004,91,"Building Remodeling, Improvements and Major Repairs","ch-Capital Expenditures"]
[null,3005,92,"Vehicles, Equipment and Furniture","ch-Capital Expenditures"]
[null,3100,"OTHER EXTRAORDINARY DISBURSEMENTS",null," "]
[null,3105,94,"Insurance Settlements Expenses","ch-Extraordinary Expenses (Sch H)","H"]
[null,3107,95,"Designated Collections Remitted to the Diocese","ch-Designated Collections - Paid"]
[null,3108,96,"Intra-Parish Transfers","ch-Intra-Parish Transfers/School Support"]
[null,3109,97,"Removal of Underground Tanks","ch-Extraordinary Expenses (Sch H)","H"]
[null,3110,98,"Removal of Asbestos","ch-Extraordinary Expenses (Sch H)","H"]
[null,3111,99,"Miscellaneous Extraordinary Disbursements","ch-Extraordinary Expenses (Sch H)","H"]
[null,null,null,"Church  Expenses",null,null,{"$f":"SUM(G94:G171)","v":0},{"$f":"SUM(H94:H171)","v":0},{"$f":"SUM(I94:I171)","v":0}]
[null,null,null,"Net Church Surplus (Deficit)",null,null,{"$f":"G92-G172","v":0},{"$f":"H92-H172","v":0},{"$f":"I92-I172","v":0}]
["SCHOOL INCOME STATEMENT DETAIL",null,null,null," "]
[null,4000,"OPERATING RECEIPTS",null," "]
[null,4001,1,"Tuition","sc-Tuition & Fees"]
[null,4002,2,"Registration and Other Fees","sc-Tuition & Fees"]
[null,4003,3,"Bequests, Donations and Restricted Funds","sc-Donations & Bequests"]
[null,4004,4,"Government Assistance","sc-Government Assistance"]
[null,4005,5,"School-sponsored Food Program","sc-Other Student Receipts"]
[null,4006,6,"Latch-Key Program Receipts","sc-Net Pre-School & Latchkey"]
[null,4007,7,"Pre-School Program Receipts","sc-Net Pre-School & Latchkey"]
[null,4008,8,"Student Services Receipts","sc-Other Student Receipts"]
[null,4009,9,"Fund-raising - Net  Income","sc-Net Fund Raising (Sch M)","M"]
[null,4010,10,"Investment Income","sc-Interest & Endowment Income"]
[null,4011,11,"Rental Receipts (Net)","sc-Other Income (Sch I)","I"]
[null,4012,12,"Endowment Income","sc-Interest & Endowment Income"]
[null,4013,13,"Other Operating Income","sc-Other Income (Sch I)","I"]
[null,4100,"EXTRAORDINARY RECEIPTS",null," ",null," "]
[null,4101,15,"Payments from/(to) Parish","sc-School Support from Parish"]
[null,4102,16,"Diocesan Subsidies","sc-Other Income (Sch I)","I"]
[null,4103,17,"Receipts from Sale of Property","sc-Other Income (Sch I)","I"]
[null,4104,18,"Receipts from Insurance Claims","sc-Other Income (Sch I)","I"]
[null,4109,19,"Other Extraordinary Receipts","sc-Other Income (Sch I)","I"]
[null,null,null,"School  Revenues",null,null,{"$f":"SUM(G176:G194)","v":0},{"$f":"SUM(H176:H194)","v":0},{"$f":"SUM(I176:I194)","v":0}]
[null,5000,"ADMINISTRATION",null," "]
[null,5001,22,"Salaries and Other Compensation","sc-Salaries, Benefits & Taxes"]
[null,5002,23,"Payroll Taxes and Fringe Benefits","sc-Salaries, Benefits & Taxes"]
[null,5003,24,"General Administrative Expenses","sc-Administration"]
[null,5004,25,"OCE Administrative Fees","sc-Administration"]
[null,5005,26,"Bad Debts","sc-Administration"]
[null,5006,27,"Memberships and Subscriptions","sc-Administration"]
[null,5007,28,"Workshops, In-service and Meetings","sc-Administration"]
[null,5008,29,"Faculty Expenses","sc-Administration"]
[null,5009,30,"Public Relations","sc-Administration"]
[null,5010,31,"Gifts and Donations","sc-Administration"]
[null,5015,32,"Miscellaneous Expenses","sc-Administration","J"]
[null,5100,"INSTRUCTIONAL",null," "]
[null,5101,34,"Salaries and Other Compensation","sc-Salaries, Benefits & Taxes"]
[null,5102,35,"Payroll Taxes and Fringe Benefits","sc-Salaries, Benefits & Taxes"]
[null,5103,36,"Instructional Expenses","sc-Instructional"]
[null,5104,37,"Replacement of Instructional Equipment","sc-Instructional"]
[null,5105,38,"Instructional Contracted Services","sc-Instructional"]
[null,5200,"LIBRARY",null," "]
[null,5201,40,"Salaries and Other Compensation","sc-Salaries, Benefits & Taxes"]
[null,5202,41,"Payroll Taxes and Fringe Benefits","sc-Salaries, Benefits & Taxes"]
[null,5203,42,"Library Expenses","sc-Library"]
[null,5204,43,"Audio/Visual Expenses","sc-Library"]
[null,5300,"STUDENT SERVICES",null," "]
[null,5301,45,"Salaries and Other Compensation","sc-Salaries, Benefits & Taxes"]
[null,5302,46,"Payroll Taxes and Fringe Benefits","sc-Salaries, Benefits & Taxes"]
[null,5303,47,"Extracurricular Expenses","sc-Student Services"]
[null,5304,48,"Health Services","sc-Student Services"]
[null,5315,49,"Miscellaneous Expenses","sc-Student Services","J"]
[null,5400,"SCHOOL-SPONSORED FOOD PROGRAM",null," "]
[null,5401,51,"Salaries and Other Compensation","sc-Salaries, Benefits & Taxes"]
[null,5402,52,"Payroll Taxes and Fringe Benefits","sc-Salaries, Benefits & Taxes"]
[null,5403,53,"Food Costs","sc-Student Services"]
[null,5404,54,"Other Food Program Expenses","sc-Student Services"]
[null,5500,"STUDENT TRANSPORTATION",null," "]
[null,5501,56,"Salaries and Other Compensation","sc-Salaries, Benefits & Taxes"]
[null,5502,57,"Payroll Taxes and Fringe Benefits","sc-Salaries, Benefits & Taxes"]
[null,5504,58,"Other Student Transportation Expenses","sc-Student Services"]
[null,5600,"LATCH-KEY EXPENSES",null," "]
[null,5601,6,"Salaries and Other Compensation","sc-Net Pre-School & Latchkey"]
[null,5602,6,"Payroll Taxes and Fringe Benefits","sc-Net Pre-School & Latchkey"]
[null,5603,6,"Other Program Expenses","sc-Net Pre-School & Latchkey"]
[null,5700,"PRESCHOOL EXPENSES",null," "]
[null,5701,7,"Salaries and Other Compensation","sc-Net Pre-School & Latchkey"]
[null,5702,7,"Payroll Taxes and Fringe Benefits","sc-Net Pre-School & Latchkey"]
[null,5703,7,"Other Pre-School Expenses","sc-Net Pre-School & Latchkey"]
[null,5800,"PLANT OPERATION",null," "]
[null,5801,60,"Salaries and Other Compensation","sc-Salaries, Benefits & Taxes"]
[null,5802,61,"Payroll Taxes and Fringe Benefits","sc-Salaries, Benefits & Taxes"]
[null,5807,62,"Contracted Services","sc-Maintenance, Repairs & Plant Operating"]
[null,5808,63,"Utilities","sc-Utilities"]
[null,5809,64,"Plant Operation Supplies","sc-Maintenance, Repairs & Plant Operating"]
[null,5810,65,"Rental of Facilities and Equipment","sc-Maintenance, Repairs & Plant Operating"]
[null,5811,66,"Replacement of Equipment","sc-Maintenance, Repairs & Plant Operating"]
[null,5812,67,"Property and Casualty Insurance","sc-Insurance & Property Taxes"]
[null,5813,68,"School Vehicle Expenses","sc-Maintenance, Repairs & Plant Operating"]
[null,5814,69,"Property Taxes","sc-Insurance & Property Taxes"]
[null,5815,70,"Miscellaneous Expenses","sc-Maintenance, Repairs & Plant Operating","J"]
[null,5900,"FACULTY RESIDENCE",null," "]
[null,5901,72,"Salaries and Other Compensation","sc-Salaries, Benefits & Taxes"]
[null,5902,73,"Payroll Taxes and Fringe Benefits","sc-Salaries, Benefits & Taxes"]
[null,5906,74,"Telephone","sc-Faculty Residence/Convent Costs"]
[null,5907,75,"Contracted Services","sc-Faculty Residence/Convent Costs"]
[null,5908,76,"Utilities","sc-Faculty Residence/Convent Costs"]
[null,5909,77,"Faculty Residence Supplies","sc-Faculty Residence/Convent Costs"]
[null,5910,78,"Rent Expense","sc-Faculty Residence/Convent Costs"]
[null,5911,79,"Furniture and Equipment Replacement","sc-Faculty Residence/Convent Costs"]
[null,5912,80,"Property and Casualty Insurance","sc-Faculty Residence/Convent Costs"]
[null,5913,81,"Faculty Vehicle Expenses","sc-Faculty Residence/Convent Costs"]
[null,5914,82,"Property Taxes","sc-Faculty Residence/Convent Costs"]
[null,5915,83,"Miscellaneous Expenses","sc-Faculty Residence/Convent Costs","J"]
[null,6000,"CAPITAL DISBURSEMENTS",null," "]
[null,6001,86,"Land","sc-Capital Expenditures"]
[null,6002,87,"Land Improvements","sc-Capital Expenditures"]
[null,6003,88,"Buildings and Additions","sc-Capital Expenditures"]
[null,6004,89,"Building Remodeling, Improvements and Major Repairs","sc-Capital Expenditures"]
[null,6005,90,"Vehicles, Equipment and Furniture","sc-Capital Expenditures"]
[null,6006,91,"Faculty Residence","sc-Capital Expenditures"]
[null,6100,"OTHER EXTRAORDINARY DISBURSEMENTS",null," "]
[null,6105,93,"Insurance Settlements Expenses","sc-Extraordinary Expenses (Sch K)","K"]
[null,6109,94,"Removal of Underground Tanks","sc-Extraordinary Expenses (Sch K)","K"]
[null,6110,95,"Removal of Asbestos","sc-Extraordinary Expenses (Sch K)","K"]
[null,6111,96,"Miscellaneous Extraordinary Disbursements","sc-Extraordinary Expenses (Sch K)","K"]
[null,null,null,"School Expenses",null,null,{"$f":"SUM(G197:G278)","v":0},{"$f":"SUM(H197:H278)","v":0},{"$f":"SUM(I197:I278)","v":0}]
[null,null,null,"Net School Surplus (Deficit)",null,null,{"$f":"G195-G279","v":0},{"$f":"H195-H279","v":0},{"$f":"I195-I279","v":0}]
[]
["CEMETERY INCOME STATEMENT DETAIL",null,null,null," "]
[null,null,null,"Cemetery Revenue","Cemetery Revenue",null,0,0,0]
[null,null,null,"Cemetery Expense","Cemetery Expense",null,0,0,0]
[null,null,null,"Net Cemetery Surplus (Deficit)",null,null,{"$f":"G283-G284","v":0},{"$f":"H283-H284","v":0},{"$f":"I283-I284","v":0}]
[]
["SUMMARY TOTALS OF MISCELLANEOUS EXPENSE ITEMS"]
[null,null,null,"Church--consisting of accounts 2015, 2115, 2215, 2315,\n  2415, 2515, and 2615",null,"G",{"$f":"SUMIF($F$73:$F$171,$F288,G$73:G$171)","v":0}]
[null,null,null,"School-consisting of accounts 5015, 5315, 5815, and 5915",null,"J",{"$f":"SUMIF($F$175:$F$284,$F289,G$175:G$284)","v":0}]
[]
["Do not make any changes to information presented below.  The following summarizes the data entered above by financial statement category and constitutes the financial statement section of your parish's financial report to the Diocese.  The applicable data is automatically transferred from below to the \"Parishioner Report Template\" financial statement (red) tab."]
["Annual Financial Report to the Diocese of Cleveland"]
[]
[]
["NAME OF PARISH",null,null,{"$f":"UPPER($D$24)","v":""}]
["ADDRESS",null,null,{"$f":"UPPER($D$25)","v":""}]
["CITY, STATE, ZIP CODE",null,null,{"$f":"UPPER($D$26)","v":""}]
["COMPUTER CONTROL NO.",null,null,{"$f":"$D$27","v":0}]
["FISCAL YEAR ENDED ",null,null,{"$f":"$D$7","v":"2021-06-30"}]
["Person to contact with\n questions:"]
["Name",null,null,{"$f":"$D$29","v":0}]
["Telephone",null,null,{"$f":"$D$30","v":0}]
["E-Mail",null,null,{"$f":"$D$31","v":0}]
[]
[{"$f":"UPPER($D$24)","v":""}]
["ASSET, LIABILITIES AND FUND BALANCE--CHURCH, SCHOOL & CEMETERY"]
[null,null,null,null,null,"Sched-\nule",{"$f":"D7","v":"2021-06-30"},{"$f":"D8","v":"2020-06-30"},{"$f":"D9","v":"2022-06-30"}]
[null,null,null,"ASSETS"]
[null,null,null,"CHECKING, SAVINGS AND INVESTMENTS"]
[null,null,null,"Checking Account Balances (Schedule A)","b-Cash (Sch A)","A",{"$f":"SUMIF($E$46:$E$62,$E310,G$46:G$62)","v":0},0]
[null,null,null,"Savings and Investment Account Balances (Schedule A)","b-Investments (Sch A)","A",0,0]
[null,null,null,"TOTAL CHECKING SAVINGS AND INVESTMENTS (Schedule A)",null,null,{"$f":"SUM(G310:G311)","v":0},{"$f":"SUM(H310:H311)","v":0}]
[null,null,null,"ACCOUNTS RECEIVABLE","b-Accounts Receivable",null,0,0]
[null,null,null,"OTHER ASSETS","b-Other Assets (Sch P)","P",0,0]
[null,null,null,"Total Assets",null,null,{"$f":"SUM(G312:G314)","v":0},{"$f":"SUM(H312:H314)","v":0}]
[null,null,null,"LIABILITIES"]
[null,null,null,"ACCOUNTS PAYABLE AND ACCRUED\n   EXPENSES"]
[null,null,null,"Payable to Diocese of Cleveland (from Schedule B)",null,null,{"$f":"Schedules!E146","v":0},{"$f":"H43","v":0}]
[null,null,null,"Other accounts payable and accrued expenses",null,null,{"$f":"G320-G318","v":0},{"$f":"H320-H318","v":0}]
[null,null,null,"TOTAL ACCOUNTS PAYABLE AND ACCRUED EXPENSES","b-Accts Payable and Accrued Exp (Sch C)","C",{"$f":"SUMIF($E$46:$E$62,$E320,G$46:G$62)","v":0},{"$f":"SUMIF($E$46:$E$62,$E320,H$46:H$62)","v":0}]
[null,null,null,"INCOME RECEIVED IN ADVANCE","b-Income Received in Advance","Q",{"$f":"SUMIF($E$46:$E$62,$E321,G$46:G$62)","v":0},0]
[null,null,null,"EMPLOYEE WITHHOLDING","b-Employee Withholding",null,0,0]
[null,null,null,"DEFERRED RESTRICTED SUPPORT","b-Deferred Restricted Support (Sch N)","N",0,0]
[null,null,null,"LOANS, NOTES AND MORTGAGES PAYABLE\n  (Schedule D)","b-Loans, Notes & Mrtgs Payable (Sch D)","D",0,0]
[null,null,null,"Total Liabilities",null,null,{"$f":"SUM(G320:G324)","v":0},{"$f":"SUM(H320:H324)","v":0}]
[null,null,null,"FUND BALANCE"]
[null,null,null,"FUND BALANCE BEGINNING OF FISCAL YEAR","b-Beginning Fund Balance",null,{"$f":"SUMIF($E$46:$E$62,$E327,G$46:G$62)","v":0},{"$f":"SUMIF($E$46:$E$62,$E327,H$46:H$62)","v":0}]
[null,null,null,"Net surplus (deficit) for period as per below"]
[null,null,null,"Parish",null,null,{"$f":"G370","v":0},{"$f":"H370","v":0}]
[null,null,null,"School",null,null,{"$f":"G398","v":0},{"$f":"H398","v":0}]
[null,null,null,"Cemetery",null,null,{"$f":"G404","v":0},{"$f":"H404","v":0}]
[null,null,null,"Net surplus (deficit) for fiscal year",null,null,{"$f":"SUM(G329:G331)","v":0},{"$f":"SUM(H329:H331)","v":0}]
[null,null,null,"Ending Fund Balance",null,null,{"$f":"G327+G332","v":0},{"$f":"H327+H332","v":0}]
[null,null,null,"Total Liabilities and Ending Fund Balance",null,null,{"$f":"G325+G333","v":0},{"$f":"H325+H333","v":0}]
[]
[{"$f":"UPPER($D$24)","v":""},null,null,null,""]
["CHURCH STATEMENT OF REVENUES AND EXPENSES"]
[null,"Church Revenue",null,null,""]
[null,null,"Offertory Collections",null,"ch-Offertory Collections",null,{"$f":"SUMIF($E$73:$E$171,$E339,G$73:G$171)","v":0},0,0]
[null,null,"Other Collections",null,"ch-Other Collections",null,0,0,0]
[null,null,"Donations & Bequests",null,"ch-Donations & Bequests",null,0,0,0]
[null,null,"Net Bingo Proceeds",null,"ch-Net Bingo Proceeds",null,0,0,0]
[null,null,"Net Fund Raising Income (Schedule M)",null,"ch-Fund Raising Income  (Sch M)","M",{"$f":"G80-G157","v":0},{"$f":"H80-H157","v":0},{"$f":"I80-I157","v":0}]
[null,null,"Income from Parish Programs",null,"ch-Income from Parish Programs",null,{"$f":"SUMIF($E$73:$E$171,$E344,G$73:G$171)","v":0},0,0]
[null,null,"Investment & Endowment Income (Loss)",null,"ch-Investment Income",null,0,0,0]
[null,null,"Rental Receipts",null,"ch-Rental Receipts (Sch O)","O",{"$f":"G82-G158","v":0},{"$f":"H82-H158","v":0},0]
[null,null,"Contributions from Parish Organizations",null,"ch-Contributions from Parish Organizations",null,{"$f":"SUMIF($E$73:$E$171,$E347,G$73:G$171)","v":0},0,0]
[null,null,"Miscellaneous Receipts (Schedule E)",null,"ch-Miscellaneous Receipts (Sch E)","E",0,0,0]
[null,null,"Designated Collections",null,"ch-Designated Collections",null,0,0,0]
[null,null,"Extraordinary Receipts (Schedule F)",null,"ch-Extraordinary Receipts (Sch F)","F",0,0,0]
[null,null,null,"Total Church Revenue",null,null,{"$f":"SUM(G339:G350)","v":0},{"$f":"SUM(H339:H350)","v":0},{"$f":"SUM(I339:I350)","v":0}]
[null,"Church Expenses",null,null,""]
[null,null,"Salaries, Benefits, & Taxes",null,"ch-Salaries, Benefits, & Taxes",null,{"$f":"SUMIF($E$73:$E$171,$E353,G$73:G$171)","v":0},0,0]
[null,null,"Rectory & Household",null,"ch-Rectory & Household",null,0,0,0]
[null,null,"Parish Office & Administration",null,"ch-Parish Office & Administration",null,0,0,0]
[null,null,"Altar, Sanctuary, & Liturgical",null,"ch-Altar, Sanctuary, & Liturgical",null,0,0,0]
[null,null,"Community Outreach",null,"ch-Community Outreach",null,0,0,0]
[null,null,"Religious Education",null,"ch-Religious Education",null,0,0,0]
[null,null,"Stewardship and Evangelization",null,"ch-Stewardship & Evangelization",null,0,0,0]
[null,null,"Utilities",null,"ch-Utilities",null,0,0,0]
[null,null,"Insurance & Property Taxes",null,"ch-Insurance & Property Taxes",null,0,0,0]
[null,null,"Maintenance, Repairs, & Plant Operating",null,"ch-Maintenance, Repairs, & Plant Operating",null,0,0,0]
[null,null,"Diocesan Assessments",null,"ch-Diocesan Assessments",null,0,0,0]
[null,null,"Payments to Other Schools",null,"ch-School Support",null,0,0,0]
[null,null,"Designated Collections",null,"ch-Designated Collections - Paid",null,0,0,0]
[null,null,"Capital Expenditures",null,"ch-Capital Expenditures",null,0,0,0]
[null,null,"Intra Parish Transfers & School Support",null,"ch-Intra-Parish Transfers/School Support",null,{"$f":"G168-G89","v":0},{"$f":"H168-H89","v":0},0]
[null,null,"Extraordinary Expenses (Schedule H)",null,"ch-Extraordinary Expenses (Sch H)","H",{"$f":"SUMIF($E$73:$E$171,$E368,G$73:G$171)","v":0},{"$f":"SUMIF($E$73:$E$171,$E368,H$73:H$171)","v":0},{"$f":"SUMIF($E$73:$E$171,$E368,I$73:I$171)","v":0}]
[null,null,null,"Total Church Expense",null,null,{"$f":"SUM(G353:G368)","v":0},{"$f":"SUM(H353:H368)","v":0},{"$f":"SUM(I353:I368)","v":0}]
[null,"Net Church Surplus (Deficit)",null,null,null,null,{"$f":"G351-G369","v":0},{"$f":"H351-H369","v":0},{"$f":"I351-I369","v":0}]
[]
[{"$f":"UPPER($D$24)","v":""}]
["SCHOOL STATEMENT OF REVENUES AND EXPENSES"]
[null,"School Revenue",null,null,""]
[null,null,"Tuition & Fees",null,"sc-Tuition & Fees",null,{"$f":"SUMIF($E$175:$E$284,$E375,G$175:G$284)","v":0},0,0]
[null,null,"Government Assistance",null,"sc-Government Assistance",null,0,0,0]
[null,null,"Donations & Bequests",null,"sc-Donations & Bequests",null,0,0,0]
[null,null,"Net Fund Raising (Schedule M)",null,"sc-Net Fund Raising (Sch M)","M",0,0,0]
[null,null,"Net Pre-School & Latchkey",null,"sc-Net Pre-School & Latchkey",null,{"$f":"SUM(G181:G182)-(SUM(G235:G237)+SUM(G239:G241))","v":0},{"$f":"SUM(H181:H182)-(SUM(H235:H237)+SUM(H239:H241))","v":0},{"$f":"SUM(I181:I182)-(SUM(I235:I237)+SUM(I239:I241))","v":0}]
[null,null,"Other Student Receipts",null,"sc-Other Student Receipts",null,{"$f":"SUMIF($E$175:$E$284,$E380,G$175:G$284)","v":0},0,0]
[null,null,"School Support from Parish",null,"sc-School Support from Parish",null,0,0,0]
[null,null,"Interest & Endowment Income",null,"sc-Interest & Endowment Income",null,0,0,0]
[null,null,"Other Income (Schedule I)",null,"sc-Other Income (Sch I)","I",0,0,0]
[null,null,null,"Total School Revenue",null,null,{"$f":"SUM(G375:G383)","v":0},{"$f":"SUM(H375:H383)","v":0},{"$f":"SUM(I375:I383)","v":0}]
[null,"School Expenses",null,null,""]
[null,null,"Salaries, Benefits & Taxes",null,"sc-Salaries, Benefits & Taxes",null,{"$f":"SUMIF($E$175:$E$284,$E386,G$175:G$284)","v":0},0,0]
[null,null,"Instructional",null,"sc-Instructional",null,0,0,0]
[null,null,"Library",null,"sc-Library",null,0,0,0]
[null,null,"Utilities",null,"sc-Utilities",null,0,0,0]
[null,null,"Maintenance, Repairs & Plant Operating",null,"sc-Maintenance, Repairs & Plant Operating",null,0,0,0]
[null,null,"Insurance & Property Taxes",null,"sc-Insurance & Property Taxes",null,0,0,0]
[null,null,"Student Services",null,"sc-Student Services",null,0,0,0]
[null,null,"Administration",null,"sc-Administration",null,0,0,0]
[null,null,"Faculty Residence/Convent Costs",null,"sc-Faculty Residence/Convent Costs",null,0,0,0]
[null,null,"Capital Expenditures",null,"sc-Capital Expenditures",null,0,0,0]
[null,null,"Extraordinary Expenses (Schedule K)",null,"sc-Extraordinary Expenses (Sch K)","K",0,0,0]
[null,null,null,"Total School Expense",null,null,{"$f":"SUM(G386:G396)","v":0},{"$f":"SUM(H386:H396)","v":0},{"$f":"SUM(I386:I396)","v":0}]
[null,"Net School Surplus (Deficit)",null,null,null,null,{"$f":"G384-G397","v":0},{"$f":"H384-H397","v":0},{"$f":"I384-I397","v":0}]
[]
[{"$f":"UPPER($D$24)","v":""}]
["CEMETERY STATEMENT OF REVENUES AND EXPENSES"]
[null,"Cemetery Revenue",null,null,"Cemetery Revenue",null,{"$f":"SUMIF($E$175:$E$284,$E402,G$175:G$284)","v":0},0,0]
[null,"Cemetery Expense",null,null,"Cemetery Expense",null,0,0,0]
[null,"Net Cemetery Surplus (Deficit)",null,null,null,null,{"$f":"G402-G403","v":0},{"$f":"H402-H403","v":0},{"$f":"I402-I403","v":0}]
[]
[]
["SUMMARY OF CHANGES IN CASH AND INVESTMENTS CHURCH, SCHOOL & CEMETERY"]
[]
[null,null,null,"Cash and Investments Balance at ",{"$f":"D8","v":"2020-06-30"},null,null,{"$f":"H310+H311","v":0}]
[]
[null,null,null,"Net Surplus (Deficit) for Year"]
[null,null,null,"Church",null,null,{"$f":"G370","v":0}]
[null,null,null,"School",null,null,{"$f":"G398","v":0}]
[null,null,null,"Cemetery",null,null,{"$f":"G404","v":0}]
[null,null,null,"Net Surplus (Deficit) for Year",null,null,null,{"$f":"SUM(G411:G414)","v":0}]
[]
[null,null,null,"Changes in other balance sheet accounts:"]
[null,null,null,"(Increase) Decrease in Accounts Receivable",null,null,{"$f":"H313-G313","v":0}]
[null,null,null,"(Increase) Decrease in Other Assets",null,null,{"$f":"H314-G314","v":0}]
[null,null,null,"Increase (Decrease) Payable to Diocese",null,null,{"$f":"G318-H318","v":0}]
[null,null,null,"Increase (Decrease) Other Accounts Payable and Accrued Expenses",null,null,{"$f":"G319-H319","v":0}]
[null,null,null,"Increase (Decrease) Income Received in Advance",null,null,{"$f":"G321-H321","v":0}]
[null,null,null,"Increase (Decrease) Employee Withholding",null,null,{"$f":"G322-H322","v":0}]
[null,null,null,"Increase (Decrease) Deferred Restricted Support",null,null,{"$f":"G323-H323","v":0}]
[null,null,null,"Increase (Decrease) Loans, Notes and Mortgages Payable",null,null,{"$f":"G324-H324","v":0}]
[]
[null,null,null,"Net changes in other balance sheet accounts",null,null,null,{"$f":"SUM(G418:G425)","v":0}]
[]
[null,null,null,"Cash and Investments Balance at ",{"$f":"D7","v":"2021-06-30"},null,null,{"$f":"SUM(H409:H428)","v":0}]
[null,null,null,null,"If there is an amount in H430 the report is out of balance",null,null,{"$f":"IF(ROUND((G310+G311),2)=ROUND(H429,2),\"OK\",(H429-G312))","v":"OK"}]
[null,null,null,null,"If other than an explained fund balance\nadjustment and cannot be resolved,\n please call the finance office."]

{"sheet":"Schedules","index":1,"n_rows":757,"n_cols":8,"rows_kept":757,"cut":false,"hidden":false,"merged":[[11,4,11,5],[741,0,741,3],[742,0,742,3],[743,0,743,3],[744,0,744,3],[745,0,745,3],[746,0,746,3],[740,0,740,3],[756,0,756,3],[755,0,755,2],[748,0,748,3],[749,0,749,3],[750,0,750,3],[751,0,751,3],[752,0,752,3],[753,0,753,3],[747,0,747,3],[687,0,687,4],[691,0,691,3],[692,0,692,3],[693,0,693,3],[694,0,694,3],[695,0,695,3],[708,0,708,3],[735,0,735,4],[739,0,739,3],[702,0,702,3],[703,0,703,3],[704,0,704,3],[711,0,711,3],[713,0,713,4],[714,0,714,4],[717,0,717,3],[718,0,718,3],[736,0,736,4],[705,0,705,3],[706,0,706,3],[707,0,707,3],[696,0,696,3],[697,0,697,3],[698,0,698,3],[246,0,246,3],[609,0,609,4],[610,0,610,4],[611,0,611,4],[612,0,612,4],[203,0,203,3],[242,0,242,3],[309,0,309,4],[358,0,358,4],[231,0,231,3],[217,0,217,4],[223,0,223,2],[228,0,228,3],[542,0,542,4],[451,0,451,4],[452,0,452,4],[442,0,442,3],[540,0,540,4],[501,0,501,4],[474,0,474,3],[475,0,475,3],[488,0,488,3],[252,0,252,3],[250,0,250,3],[280,0,280,3],[271,0,271,3],[320,0,320,3],[284,0,284,3],[274,0,274,3],[291,0,291,3],[292,0,292,3],[293,0,293,3],[276,0,276,3],[281,0,281,3],[275,0,275,3],[282,0,282,3],[272,0,272,3],[295,0,295,3],[296,0,296,3],[317,0,317,3],[318,0,318,3],[319,0,319,3],[314,0,314,3],[286,0,286,3],[306,0,306,4],[356,0,356,4],[350,0,350,3],[193,0,193,4],[195,0,195,4],[212,0,212,3],[211,0,211,3],[215,0,215,3],[240,0,240,3],[262,0,262,4],[204,0,204,3],[198,0,199,3],[247,0,247,3],[243,0,243,3],[248,0,248,3],[244,0,244,3],[245,0,245,3],[249,0,249,3],[253,0,253,3],[260,0,260,4],[202,0,202,3],[224,0,224,3],[221,0,221,4],[229,0,229,3],[251,0,251,3],[543,0,543,4],[511,0,511,3],[264,0,264,4],[448,0,448,3],[450,0,450,4],[445,0,445,3],[441,0,441,3],[285,0,285,3],[290,0,290,3],[287,0,287,3],[288,0,288,3],[294,0,294,3],[283,0,283,3],[321,0,321,3],[322,0,322,3],[323,0,323,3],[301,0,301,3],[312,0,313,2],[312,3,313,3],[308,0,308,4],[324,0,324,3],[298,0,298,3],[299,0,299,3],[300,0,300,3],[10,0,10,2],[11,0,11,2],[12,0,12,2],[14,0,14,2],[544,0,544,4],[541,0,541,4],[535,0,535,3],[534,0,534,3],[504,0,504,3],[465,0,465,3],[466,0,466,3],[467,0,467,3],[472,0,472,3],[470,0,470,3],[471,0,471,3],[515,0,515,3],[516,0,516,3],[517,0,517,3],[518,0,518,3],[519,0,519,3],[520,0,520,3],[521,0,521,3],[522,0,522,3],[537,0,537,2],[270,0,270,3],[289,0,289,3],[315,0,315,3],[316,0,316,3],[0,0,0,4],[2,2,2,4],[3,2,3,4],[122,0,122,3],[146,0,146,3],[4,2,4,4],[5,2,5,4],[6,2,6,4],[75,0,75,4],[28,0,28,4],[76,0,76,4],[124,0,124,4],[32,0,32,4],[8,0,8,4],[121,0,121,2],[126,0,126,4],[29,0,29,4],[125,0,125,4],[30,0,30,4],[31,0,31,4],[261,0,261,4],[266,0,267,2],[279,0,279,3],[538,0,538,3],[232,0,232,3],[233,0,233,3],[234,0,234,3],[235,0,235,3],[236,0,236,3],[241,0,241,3],[325,0,325,3],[297,0,297,3],[361,3,362,3],[263,0,263,4],[273,0,273,3],[254,0,254,3],[266,3,267,3],[258,0,258,3],[277,0,277,3],[278,0,278,3],[342,0,342,3],[255,0,255,3],[268,0,268,3],[269,0,269,3],[149,0,149,4],[150,0,150,4],[225,0,225,3],[151,0,151,4],[163,0,163,3],[164,0,164,3],[165,0,165,3],[205,0,205,3],[545,0,545,4],[361,0,362,2],[310,0,310,4],[510,0,510,3],[230,0,230,3],[304,0,304,3],[194,0,194,4],[196,0,196,4],[210,0,210,3],[209,0,209,3],[208,0,208,3],[237,0,237,3],[238,0,238,3],[239,0,239,3],[222,0,222,4],[207,0,207,3],[220,0,220,4],[162,0,162,3],[166,0,166,3],[167,0,167,3],[168,0,168,3],[183,0,183,3],[171,0,171,3],[172,0,172,3],[206,0,206,3],[201,0,201,3],[218,0,218,4],[219,0,219,4],[169,0,169,3],[170,0,170,3],[173,0,173,3],[174,0,174,3],[326,0,326,3],[327,0,327,3],[328,0,328,3],[329,0,329,3],[330,0,330,3],[331,0,331,3],[332,0,332,3],[333,0,333,3],[334,0,334,3],[335,0,335,3],[336,0,336,3],[337,0,337,3],[338,0,338,3],[339,0,339,3],[340,0,340,3],[341,0,341,3],[347,0,347,3],[348,0,348,3],[349,0,349,3],[307,0,307,4],[352,0,352,2],[359,0,359,4],[345,0,345,3],[390,0,390,3],[343,0,343,3],[365,0,365,3],[366,0,366,3],[346,0,346,3],[383,0,383,3],[372,0,372,3],[373,0,373,3],[374,0,374,3],[375,0,375,3],[376,0,376,3],[377,0,377,3],[369,0,369,3],[363,0,363,3],[357,0,357,4],[364,0,364,3],[344,0,344,3],[353,0,353,3],[355,0,355,4],[370,0,370,3],[371,0,371,3],[423,0,423,3],[424,0,424,3],[367,0,367,3],[378,0,378,3],[379,0,379,3],[393,0,393,3],[394,0,394,3],[395,0,395,3],[396,0,396,3],[397,0,397,3],[398,0,398,3],[388,0,388,3],[389,0,389,3],[380,0,380,3],[381,0,381,3],[382,0,382,3],[384,0,384,3],[385,0,385,3],[386,0,386,3],[387,0,387,3],[368,0,368,3],[404,0,404,4],[443,0,443,3],[444,0,444,3],[405,0,405,4],[407,0,407,4],[406,0,406,4],[400,0,400,2],[403,0,403,4],[425,0,425,3],[426,0,426,3],[411,0,411,3],[412,0,412,3],[413,0,413,3],[414,0,414,3],[415,0,415,3],[410,0,410,3],[401,0,401,3],[416,0,416,3],[417,0,417,3],[418,0,418,3],[419,0,419,3],[420,0,420,3],[439,0,439,3],[497,0,497,4],[500,0,500,4],[421,0,421,3],[422,0,422,3],[468,0,468,3],[427,0,427,3],[428,0,428,3],[429,0,429,3],[430,0,430,3],[431,0,431,3],[432,0,432,3],[438,0,438,3],[457,0,457,3],[458,0,458,3],[435,0,435,3],[433,0,433,3],[434,0,434,3],[456,0,456,2],[461,0,461,3],[462,0,462,3],[454,0,454,4],[436,0,436,3],[453,0,453,4],[440,0,440,3],[459,0,459,3],[463,0,463,3],[473,0,473,3],[469,0,469,3],[437,0,437,3],[391,0,391,3],[392,0,392,3],[503,0,503,2],[464,0,464,3],[489,0,489,3],[490,0,490,3],[482,0,482,3],[483,0,483,3],[484,0,484,3],[485,0,485,3],[486,0,486,3],[487,0,487,3],[476,0,476,3],[477,0,477,3],[478,0,478,3],[479,0,479,3],[480,0,480,3],[481,0,481,3],[495,0,495,3],[9,5,9,6],[189,0,189,2],[214,0,214,2],[257,0,257,2],[303,0,303,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[24,0,24,2],[22,0,22,2],[177,0,177,3],[185,0,185,3],[186,0,186,3],[187,0,187,3],[148,0,148,4],[190,0,190,3],[226,0,226,3],[175,0,175,3],[176,0,176,3],[227,0,227,3],[684,0,684,2],[662,0,662,4],[26,0,26,2],[528,0,528,3],[529,0,529,3],[530,0,530,3],[491,0,491,3],[492,0,492,3],[513,0,513,3],[178,0,178,3],[179,0,179,3],[180,0,180,3],[181,0,181,3],[182,0,182,3],[27,0,27,2],[532,0,532,3],[533,0,533,3],[154,0,154,3],[155,0,155,3],[156,0,156,3],[157,0,157,3],[158,0,158,3],[159,0,159,3],[160,0,160,3],[680,0,680,3],[523,0,523,3],[524,0,524,3],[525,0,525,3],[526,0,526,3],[527,0,527,3],[9,7,9,8],[682,0,682,3],[23,0,23,2],[25,0,25,2],[506,0,506,3],[507,0,507,3],[499,0,499,4],[531,0,531,3],[514,0,514,3],[161,0,161,3],[508,0,508,3],[509,0,509,3],[498,0,498,4],[512,0,512,3],[505,0,505,3],[460,0,460,3],[494,0,494,2],[13,0,13,2],[675,0,675,3],[676,0,676,3],[677,0,677,3],[678,0,678,3],[699,0,699,3],[700,0,700,3],[701,0,701,3],[733,0,733,2],[734,0,734,3],[723,0,723,3],[724,0,724,3],[710,0,710,2],[725,0,725,3],[726,0,726,3],[727,0,727,3],[728,0,728,3],[729,0,729,3],[730,0,730,3],[731,0,731,3],[719,0,719,3],[720,0,720,3],[721,0,721,3],[722,0,722,3],[679,0,679,3],[35,2,35,4],[552,2,552,4],[592,0,592,4],[605,0,605,2],[582,0,582,2],[690,0,690,2],[661,0,661,4],[664,0,664,2],[665,0,665,3],[666,0,666,3],[688,0,688,4],[585,0,585,2],[634,0,634,2],[657,0,657,2],[667,0,667,3],[668,0,668,3],[685,0,685,3],[669,0,669,3],[670,0,670,3],[671,0,671,3],[681,0,681,3],[672,0,672,3],[673,0,673,3],[674,0,674,3],[615,0,615,1],[616,0,616,1],[617,0,617,1],[618,0,618,1],[619,0,619,1],[620,0,620,1],[621,0,621,1],[622,0,622,1],[623,0,623,1],[624,0,624,1],[625,0,625,1],[626,0,626,1],[627,0,627,1],[628,0,628,1],[629,0,629,1],[630,0,630,1],[631,0,631,1],[632,0,632,1],[638,0,638,1],[639,0,639,1],[640,0,640,1],[641,0,641,1],[642,0,642,1],[643,0,643,1],[644,0,644,1],[645,0,645,1],[646,0,646,1],[658,0,658,3],[647,0,647,1],[648,0,648,1],[649,0,649,1],[650,0,650,1],[651,0,651,1],[652,0,652,1],[653,0,653,1],[654,0,654,1],[655,0,655,1]]}
[]
[]
["NAME OF PARISH",null,{"$f":"UPPER('Toolkit Trial Balance'!$D$24)","v":""}]
["ADDRESS",null,{"$f":"UPPER('Toolkit Trial Balance'!$D$25)","v":""}]
["CITY, STATE, ZIP CODE",null,{"$f":"UPPER('Toolkit Trial Balance'!$D$26)","v":""}]
["PARISH NUMBER",null,{"$f":"'Toolkit Trial Balance'!D27","v":0}]
["FISCAL YEAR ENDED ",null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"}]
[]
["This section of the Tool Kit is used to provide supplemental information regarding what is included in the related item in the Trial Balance tab and should be completed only after completion of the Trial Balance tab.  Complete the schedules indicated as directed below:"]
[null,null,null,"Is schedule\nrequired for your Parish?","Is schedule\ncomplete? ","(An amount in column E or at bottom of schedule indicates an error- please review)",null,"If parish inserts rows- GoTo will not work or will fall short of destination"]
["SCHEDULE A - CHECKING, SAVINGS AND INVESTMENT\n    ACCOUNT INFORMATION",null,null,"YES",{"$f":"IF(D11=\"YES\",  F123, \"N/A\")","v":"OK"}]
["SCHEDULE B - PAYABLE TO DIOCESE",null,null,"YES",{"$f":"IF(AND(E146='Toolkit Trial Balance'!G318,'Toolkit Trial Balance'!H430=\"OK\"), \"OK\", \"ERROR-SchB & H430TB must both = OK (unless due to an explained fund balance adj\")","v":"OK"}]
["SCHEDULE  C - DETAIL OF ACCOUNTS PAYABLE\n    AND ACCRUED EXPENSES",null,null,{"$f":"IF('Toolkit Trial Balance'!G320<>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF(D13=\"YES\", E191, \"N/A\")","v":"N/A"}]
["SCHEDULE  D - DETAIL OF LOANS, NOTES AND \n    MORTGAGES PAYABLE",null,null,{"$f":"IF('Toolkit Trial Balance'!G324<>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF(D14=\"YES\", E216, \"N/A\")","v":"N/A"}]
["SCHEDULE E - CHURCH MISCELLANEOUS\n    RECEIPTS ",null,null,{"$f":"IF('Toolkit Trial Balance'!G348<>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF(D15=\"YES\", E259, \"N/A\")","v":"N/A"}]
["SCHEDULE F - CHURCH EXTRAORDINARY\n    RECEIPTS (if total > $5,000)",null,null,{"$f":"IF('Toolkit Trial Balance'!G350>5000,\"YES\",\"NO\")","v":"NO"},{"$f":"IF(D16= \"NO\", IF(A305=\" \", \"N/A\", \"ERROR SEE SCHEDULE\"), IF(AND(D16=\"YES\", E305=\"OK\"), \"OK\", E305))","v":"N/A"}]
["SCHEDULE G - CHURCH MISCELLANEOUS EXPENSES \n    (if aggregate total of accounts  2015, 2115, 2215, \n     2315, 2415, 2515, and 2615 is > $5,000)",null,null,{"$f":"IF('Toolkit Trial Balance'!G288>5000,\"YES\",\"NO\")","v":"NO"},{"$f":"IF(D17=\"NO\",IF(A354=\" \", \"N/A\", \"ERROR SEE SCHEDULE\"), IF(AND(D17=\"YES\", E354=\"OK\"), \"OK\", E354))","v":"N/A"}]
["SCHEDULE H - CHURCH EXTRAORDINARY\n    EXPENSES (if total > $5,000)",null,null,{"$f":"IF('Toolkit Trial Balance'!G368>5000,\"YES\",\"NO\")","v":"NO"},{"$f":"IF(D18=\"NO\",IF(A402=\" \",\"N/A\",\"ERROR SEE SCHEDULE\"),IF(AND(D18=\"YES\",E402=\"OK\"),\"OK\",E402))","v":"N/A"}]
["SCHEDULE I - SCHOOL OTHER INCOME\n    (if total > $5,000)",null,null,{"$f":"IF('Toolkit Trial Balance'!G383>5000,\"YES\",\"NO\")","v":"NO"},{"$f":"IF(D19=\"NO\", IF(A449=\" \", \"N/A\", \"ERROR SEE SCHEDULE\"), IF(AND(D19=\"YES\", E449=\"OK\"), \"OK\", E449))","v":"N/A"}]
["SCHEDULE J - SCHOOL MISCELLANEOUS\n    EXPENSES (if aggregate total of accounts\n    5015, 5315, 5815, and 5915 is > $5,000)",null,null,{"$f":"IF('Toolkit Trial Balance'!G289>5000,\"YES\",\"NO\")","v":"NO"},{"$f":"IF(D20=\"NO\",IF(A496= \" \", \"N/A\", \"ERROR SEE SCHEDULE\"), IF(AND(D20=\"YES\", E496=\"OK\"), \"OK\", E496))","v":"N/A"}]
["SCHEDULE K - SCHOOL  EXTRAORDINARY\n    EXPENSES (if total > $5,000)",null,null,{"$f":"IF('Toolkit Trial Balance'!G396>5000,\"YES\",\"NO\")","v":"NO"},{"$f":"IF(D21=\"NO\",IF(A539=\" \",\"N/A\", \"ERROR SEE SCHED\"),IF(AND(D21=\"YES\",E539=\"OK\"),\"OK\",E539))","v":"N/A"}]
["SCHEDULE L - BANK ACCOUNT BALANCES\n    OF PARISH-AFFILIATED ORGANIZATIONS",null,null,"YES",{"$f":"IF(AND(C550=\"N\", E586=0),\"N/A\",(IF(AND(C550=\"y\", E586>0),\"OK\",\"PLEASE REVIEW/CORRECT\")))","v":"PLEASE REVIEW/CORRECT"}]
["SCHEDULE M -PARISH FUNDRAISING",null,null,{"$f":"IF('Toolkit Trial Balance'!G343<>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF(D23=\"YES\", E636, \"N/A\")","v":"N/A"}]
["SCHEDULE M -SCHOOL FUNDRAISING",null,null,{"$f":"IF('Toolkit Trial Balance'!G378<>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF(D24=\"YES\", E659, \"N/A\")","v":"N/A"}]
["SCHEDULE N - DEFERRED RESTRICTED SUPPORT",null,null,{"$f":"IF('Toolkit Trial Balance'!G59<>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF(D25=\"YES\", E686, \"N/A\")","v":"N/A"}]
["SCHEDULE O -PARISH RENTAL RECEIPTS",null,null,{"$f":"IF('Toolkit Trial Balance'!G346<>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF(D26=\"YES\", E712, \"N/A\")","v":"N/A"}]
["SCHEDULE P -OTHER ASSETS DETAIL",null,null,{"$f":"IF('Toolkit Trial Balance'!G314<>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF(D27=\"YES\", E735, \"N/A\")","v":"N/A"}]
["SCHEDULE Q -INCOME RECEIVED IN ADVANCE ",null,null,{"$f":"IF('Toolkit Trial Balance'!G321<>0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF(D28=\"YES\", E757, \"N/A\")","v":"N/A"}]
[]
["SCHEDULE A - CHECKING, SAVINGS AND INVESTMENT ACCOUNT INFORMATION AS OF"]
[{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"}]
["Include all accounts active during the year - including $0 balance and closed accounts."]
["(Add rows as necessary using menu)"]
["CASH IN BANK - CHECKING ACCOUNTS (ACCOUNT 0101):"]
["Bank Account Name  ","Bank Name","Acct Number\n(Last 4 digits)","Restricted?","Amount"]
["CHURCH",null,"U- unrestricted\nT - Temporarily Restricted\nP- Permanently Restricted\nUse Multiple lines if needed for one account"]
[null,null,null,null,0,{"$f":"IF(AND((E37<>0), (ISBLANK(D37))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
[null,null,null,null,0,{"$f":"IF(AND((E38<>0), (ISBLANK(D38))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
["Total Church Checking Accounts",null,null,null,null,{"$f":"SUM(E37:E53)","v":0}]
[]
["ELEMENTARY SCHOOL"]
[null,null,null,null,0,{"$f":"IF(AND((E56<>0), (ISBLANK(D56))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
[null,null,null,null,0,{"$f":"IF(AND((E57<>0), (ISBLANK(D57))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
["    Total Elementary School Checking Accounts",null,null,null,null,{"$f":"SUM(E56:E68)","v":0}]
[]
["CEMETERY CHECKING ACCOUNTS"]
[null,null,null,null,null,{"$f":"IF(AND((E71<>0), (ISBLANK(D71))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
[null,null,null,null,0,{"$f":"IF(AND((E72<>0), (ISBLANK(D72))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
["Total Cemetery Checking Accounts",null,null,null,null,{"$f":"SUM(E70:E73)","v":0}]
["TOTAL CHECKING ACCOUNT BALANCES",null,null,{"$f":"\"--total carried to following page\"","v":"--total carried to following page"},null,{"$f":"SUM(F53:F73)","v":0}]
[]
[]
["SCHEDULE A - CHECKING, SAVINGS AND INVESTMENT ACCOUNT INFORMATION - Continued"]
[]
["TOTAL CHECKING ACCOUNT BALANCES",null,null,{"$f":"\"--from preceding page\"","v":"--from preceding page"},null,{"$f":"F74","v":0}]
[]
["SAVINGS AND INVESTMENTS (ACCOUNT 0102):"]
["CHURCH"]
[null,null,null,null,0,{"$f":"IF(AND((E83<>0), (ISBLANK(D83))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
[null,null,null,null,0,{"$f":"IF(AND((E84<>0), (ISBLANK(D84))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
["Total Church Savings and Investment Accounts",null,null,null,null,{"$f":"SUM(E82:E97)","v":0}]
[]
["ELEMENTARY SCHOOL"]
[null,null,null,null,0,{"$f":"IF(AND((E100<>0), (ISBLANK(D100))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
[null,null,null,null,0,{"$f":"IF(AND((E101<>0), (ISBLANK(D101))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
["    Total Elementary School Savings & Investment Accounts",null,null,null,null,{"$f":"SUM(E99:E108)","v":0}]
["CEMETERY"]
[null,null,null,null,0,{"$f":"IF(AND((E110<>0), (ISBLANK(D110))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
[null,null,null,null,0,{"$f":"IF(AND((E111<>0), (ISBLANK(D111))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
["Total Cemetery Savings & Investment Accounts",null,null,null,null,{"$f":"SUM(E109:E117)","v":0}]
[]
[]
["TOTAL SAVINGS AND INVESTMENTS",null,null,null,null,{"$f":"SUM(F97:F119)","v":0}]
[]
["TOTAL PARISH CHECKING, SAVINGS AND\n     INVESTMENT ACCOUNTS ",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},null,{"$f":"F79+F120","v":0}]
[{"$f":"IF(F122='Toolkit Trial Balance'!G312,\" \",\"ERROR - TOTAL SHOULD EQUAL\")","v":" "},null,null,null,null,{"$f":"IF((ROUND(F122,2))=(ROUND('Toolkit Trial Balance'!G312,2)),\"OK\",'Toolkit Trial Balance'!G312)","v":"OK"}]
[]
[]
["SCHEDULE B - PAYABLE TO DIOCESE"]
[{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"}]
["PAYABLE TO DIOCESE"]
["DIOCESE ASSESSMENTS"]
["Regular assessments"]
["   Unpaid balance beginning of fiscal year"]
["   Assessments for current fiscal year",null,null,null,{"$f":"'Toolkit Trial Balance'!G155","v":0}]
["   Assessments paid during fiscal year in CASH (enter as a negative number)"]
["   Unpaid balance end of fiscal year (should match invoice frm Diocese)",null,null,null,{"$f":"SUM(E131:E133)","v":0},null,"<--enter dio 6/30 inv balance"]
["Assessment inherited from closed parish(es)",null,null,null,0,null,{"$f":"IF((E134=F134), \" \", \"Investigate difference\")","v":" "}]
["OTHER AMOUNTS OWED TO DIOCESE AT YEAR-END"]
["   Loans or notes payable to Diocese (including Parish Assistance Loans)",null,null,null,0]
["   Health Insurance",null,null,null,0]
["   Pension",null,null,null,0]
["   Workers' Compensation Insurance (and Unemployment Comp)",null,null,null,0]
["   Life and Disability Insurance",null,null,null,0]
["Property Insurance (Diocesan Master Insurance Program)",null,null,null,0]
["Diocesan collections payable",null,null,null,0]
["   Other amounts owed to Diocese ",null,null,null,0]
[]
["TOTAL PAYABLE TO DIOCESE AT ",null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},null,{"$f":"SUM(E134:E145)","v":0}]
["Total automatically posted to Schedule C"]
[]
[]
["SCHEDULE  C - DETAIL OF ACCOUNTS PAYABLE AND ACCRUED EXPENSES"]
[{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"}]
["(Add rows as necessary using menu)"]
[]
["ACCOUNTS PAYABLE AND ACCRUED EXPENSES"]
["PAYABLE TO DIOCESE (automatically posted from Schedule B)",null,null,null,{"$f":"E146","v":0}]
["STIPEND LIABILITY",null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
["TOTAL ACCOUNTS PAYABLE AND ACCRUED\n    EXPENSES AT",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E155:E189)","v":0}]
[{"$f":"IF(E190='Toolkit Trial Balance'!G320,\" \",\"ERROR - TOTAL SHOULD EQUAL\")","v":" "},null,null,null,{"$f":"IF((ROUND(E190,2))=(ROUND('Toolkit Trial Balance'!G320, 2)),\"OK\",'Toolkit Trial Balance'!G320)","v":"OK"}]
[]
[]
["SCHEDULE  D - DETAIL LOANS, NOTES AND MORTGAGES PAYABLE"]
[{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"}]
[{"$f":"IF(D14=\"NO\",\"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE\",\" \")","v":"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE"}]
["(Add rows as necessary using menu)"]
[]
["Please indicate in the space below the name of the lender, the type of loan (e.g., mortgage, unsecured loan, etc.) the interest rate, payment terms and date (at least month and year) of the final payment.",null,null,null,"Principal Amount\nof Loan at"]
[null,null,null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"}]
[]
["SBA PPP LOAN AMOUNT DUE",null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
["TOTAL LOANS, NOTES AND MORTGAGES PAYABLE AT",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E202:E214)","v":0}]
[{"$f":"IF(Schedules!E215='Toolkit Trial Balance'!G324,\" \",\"ERROR - TOTAL SHOULD EQUAL\")","v":" "},null,null,null,{"$f":"IF((ROUND(E215,2))=(ROUND('Toolkit Trial Balance'!G324,2)),\"OK\",'Toolkit Trial Balance'!G324)","v":"OK"}]
[]
[]
["SCHEDULE E - CHURCH MISCELLANEOUS RECEIPTS"]
[]
[{"$f":"IF(D15=\"NO\",\"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE\",\" \")","v":"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE"}]
["(Add rows as necessary using menu)"]
[]
["DETAIL OF CHURCH MISCELLANEOUS RECEIPTS\n    FOR YEAR ENDED ",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"}]
["ROOTED IN FAITH - FORWARD IN HOPE, parish share received",null,null,null,0]
["ROOTED IN FAITH - FORWARD IN HOPE, grants",null,null,null,0]
["OFFERTORY ENHANCEMENT  REBATE",null,null,null,0]
["HEART OF A SHEPHERD INCOME",null,null,null,0]
["KNIGHTS OF COLUMBUS MEDIA GRANT",null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
["TOTAL CHURCH MISCELLANEOUS RECEIPTS\n    FOR YEAR ENDED",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E225:E257)","v":0}]
[{"$f":"IF(Schedules!E258='Toolkit Trial Balance'!G348,\" \",\"ERROR - TOTAL SHOULD EQUAL\")","v":" "},null,null,null,{"$f":"IF((ROUND(Schedules!E258,2))=(ROUND('Toolkit Trial Balance'!G348,2)),\"OK\",'Toolkit Trial Balance'!G348)","v":"OK"}]
[]
[]
["SCHEDULE F - CHURCH EXTRAORDINARY RECEIPTS"]
["(Provide detail of this category if total greater than $5,000)"]
[{"$f":"IF(D16=\"NO\",\"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE\",\" \")","v":"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE"}]
["(Add rows as necessary using menu)"]
[]
["DETAIL OF CHURCH EXTRAORDINARY RECEIPTS\n   FOR YEAR ENDED ",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"}]
[]
["SBA PPP LOAN FORGIVENESS INCOME  1109.xx",null,null,null,0]
["EMPLOYEE RETENTION CREDIT INCOME",null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
["TOTAL CHURCH EXTRAORDINARY RECEIPTS\n   FOR YEAR ENDED",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E268:E303)","v":0}]
[{"$f":"IF(Schedules!E304='Toolkit Trial Balance'!G350,\" \",IF(AND(D16=\"NO\",Schedules!E304=0),\" \",\"ERROR - TOTAL SHOULD EQUAL\"))","v":" "},null,null,null,{"$f":"IF(D16=\"YES\", IF((ROUND(Schedules!E304,2))=(ROUND('Toolkit Trial Balance'!G350,2)),\"OK\",'Toolkit Trial Balance'!G350), CONCATENATE(\"N/A less than $5k - Amount = $\", 'Toolkit Trial Balance'!G350))","v":"N/A less than $5k - Amount = $0"}]
[]
[]
["SCHEDULE G - CHURCH MISCELLANEOUS EXPENSES"]
["(Provide detail of this category if aggregate total of accounts\n    2015, 2115, 2215, 2315, 2415, 2515, and 2615 is greater than $5,000)"]
[{"$f":"IF(D17=\"NO\",\"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE\",\" \")","v":"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE"}]
["(Add rows as necessary using menu)"]
[]
["DETAIL OF CHURCH MISCELLANEOUS EXPENSES\n    FOR YEAR ENDED ",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"}]
[]
["OFFERTORY ENHANCEMENT EXPENSE",null,null,null,0]
["HEART OF A SHEPHERD EXPENSE",null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
["TOTAL CHURCH MISCELLANEOUS EXPENSES\n    FOR YEAR ENDED",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E314:E352)","v":0}]
[{"$f":"IF(Schedules!E353='Toolkit Trial Balance'!G288,\" \",IF(AND(D17=\"NO\",Schedules!E353=0),\" \",\"ERROR - TOTAL SHOULD EQUAL\"))","v":" "},null,null,null,{"$f":"IF(D17=\"YES\",IF((ROUND(Schedules!E353,2))=(ROUND('Toolkit Trial Balance'!G288,2)),\"OK\",'Toolkit Trial Balance'!G288),CONCATENATE(\"N/A less than $5k - Amoutn = $\",'Toolkit Trial Balance'!G288))","v":"N/A less than $5k - Amoutn = $0"}]
[]
[]
["SCHEDULE H - CHURCH EXTRAORDINARY EXPENSES"]
["(Provide detail of this category if total greater than $5,000)"]
[{"$f":"IF(D18=\"NO\",\"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE\",\" \")","v":"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE"}]
["(Add rows as necessary using menu)"]
[]
["DETAIL OF CHURCH EXTRAORDINARY EXPENSES\n    FOR YEAR ENDED ",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"}]
[]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
["TOTAL CHURCH EXTRAORDINARY EXPENSES \n    FOR YEAR ENDED",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E363:E400)","v":0}]
[{"$f":"IF(Schedules!E401='Toolkit Trial Balance'!G368,\" \",IF(AND(D18=\"NO\",Schedules!E401=0),\" \",\"ERROR - TOTAL SHOULD EQUAL\"))","v":" "},null,null,null,{"$f":"IF(D18=\"YES\",IF((ROUND(Schedules!E401,2))=(ROUND('Toolkit Trial Balance'!G368,2)),\"OK\",'Toolkit Trial Balance'!G368),CONCATENATE(\"N/A less than $5k - Amount $\",'Toolkit Trial Balance'!G368))","v":"N/A less than $5k - Amount $0"}]
[]
[]
["SCHEDULE I - SCHOOL OTHER INCOME"]
["(Provide detail of this category if total greater than $5,000)"]
[{"$f":"IF(D19=\"NO\",\"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE\",\" \")","v":"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE"}]
["(Add rows as necessary using menu)"]
[]
["DETAIL OF SCHOOL OTHER INCOME FOR YEAR ENDED ",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"}]
["INCLUSION COORDINATOR GRANTS",null,null,null,0]
["SBA PPP LOAN FORGIVENESS INCOME (only Schools with stand alone reports)",null,null,null,0]
["EMPLOYEE RETENTION CREDIT INCOME",null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
["TOTAL SCHOOL OTHER INCOME FOR YEAR ENDED",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E410:E447)","v":0}]
[{"$f":"IF(Schedules!E448='Toolkit Trial Balance'!G383,\" \",IF(AND(D19=\"NO\",Schedules!E448=0),\" \",\"ERROR - TOTAL SHOULD EQUAL\"))","v":" "},null,null,null,{"$f":"IF(D19=\"YES\",IF((ROUND(Schedules!E448,2))=(ROUND('Toolkit Trial Balance'!G383,2)),\"OK\",'Toolkit Trial Balance'!G383),CONCATENATE(\"N/A less than $5k - Amount = $\",'Toolkit Trial Balance'!G383))","v":"N/A less than $5k - Amount = $0"}]
[]
[]
["SCHEDULE J - SCHOOL MISCELLANEOUS EXPENSES"]
["(Provide detail of this category if aggregate total of accounts\n    5015, 5315, 5815, and 5915 is greater than $5,000))"]
[{"$f":"IF(D20=\"NO\",\"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE\",\" \")","v":"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE"}]
["(Add rows as necessary using menu)"]
[]
["DETAIL OF SCHOOL MISCELLANEOUS EXPENSES\n    FOR YEAR ENDED ",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
["TOTAL SCHOOL MISCELLANEOUS EXPENSES\n    FOR YEAR ENDED",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E457:E494)","v":0}]
[{"$f":"IF(Schedules!E495='Toolkit Trial Balance'!G289,\" \",IF(AND(D20=\"NO\",Schedules!E495=0),\" \",\"ERROR - TOTAL SHOULD EQUAL\"))","v":" "},null,null,null,{"$f":"IF(D20=\"YES\",IF((ROUND(Schedules!E495,2))=(ROUND('Toolkit Trial Balance'!G289,2)),\"OK\",'Toolkit Trial Balance'!G289),CONCATENATE(\"N/A less than $5k Amount = $\",'Toolkit Trial Balance'!G289))","v":"N/A less than $5k Amount = $0"}]
[]
[]
["SCHEDULE K - SCHOOL EXTRAORDINARY EXPENSES"]
["(Provide detail of this category if total greater than $5,000)"]
[{"$f":"IF(D21=\"NO\",\"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE\",\" \")","v":"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE"}]
["(Add rows as necessary using menu)"]
[]
["DETAIL OF SCHOOL EXTRAORDINARY EXPENSE\n    FOR YEAR ENDED ",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
["TOTAL SCHOOL EXTRAORDINARY EXPENSES\n    FOR YEAR ENDED",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E504:E537)","v":0}]
[{"$f":"IF(Schedules!E538='Toolkit Trial Balance'!G396,\" \",IF(AND(D21=\"NO\",Schedules!E538=0),\" \",\"ERROR - TOTAL SHOULD EQUAL\"))","v":" "},null,null,null,{"$f":"IF(D21=\"YES\",IF((ROUND(Schedules!E538,2))=(ROUND('Toolkit Trial Balance'!G396,2)),\"OK\",'Toolkit Trial Balance'!G396),CONCATENATE(\"N/A less than $5k - Amount = $\",'Toolkit Trial Balance'!G396))","v":"N/A less than $5k - Amount = $0"}]
[]
[]
["SCHEDULE L - BANK ACCOUNT BALANCES OF PARISH-AFFILIATED ORGANIZATIONS\nAS OF"]
[{"$f":"'Toolkit Trial Balance'!D7","v":"2021-06-30"}]
["Include all accounts active during the year - including $0 balance and closed accounts."]
["(Add rows as necessary using menu)"]
[]
["CASH IN BANK - CHECKING ACCOUNTS"]
[]
[]
["Are there groups or organizations to report? (Y/N)"]
["( If YES Complete section below)",null,null,null,"Reconciled Balance"]
["   Organization Name","   Bank Name","  Account Number\n(Last 4 digits)","Restricted?",{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"}]
[null,null,"U- unrestricted\nT - Temporarily Restricted\nP- Permanently Restricted\nUse Multiple lines if needed for one account"]
[null,null,null,null,0,{"$f":"IF(AND((E554<>0), (ISBLANK(D554))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
[null,null,null,null,null,{"$f":"IF(AND((E555<>0), (ISBLANK(D555))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[]
["TOTAL PARISH-AFFILIATED CHECKING ACCOUNTS AT",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E554:E566)","v":0}]
[]
[]
["SAVINGS AND INVESTMENTS:"]
[null,null,null,null,0]
[null,null,null,null,0,{"$f":"IF(AND((E572<>0), (ISBLANK(D572))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
[null,null,null,null,0,{"$f":"IF(AND((E573<>0), (ISBLANK(D573))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
["   "]
["TOTAL PARISH-AFFILIATED SAVINGS AND\n    INVESTMENT ACCOUNTS AT",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E572:E582)","v":0}]
[]
[]
["TOTAL ACCOUNT BALANCES OF PARISH-AFFILIATED\n    ORGANIZATIONS AT   ",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E567,E583)","v":0}]
[]
["(The above list should include the balance of the accounts of all Parish organizations such as PTA, Men's Club, "]
["Athletic Association and others that use the Parish Federal Tax Identification Number for banking purposes.  While not part of the "]
["formal Parish records, it is important for the Pastor and others to have a record of the various bank accounts and maintain "]
["surveillance over the financial activities of these organizations.)"]
[]
["The following accounts below operate for the benefit of the parish/school BUT DO NOT USE THE PARISH TAX INDENTIFICATION NUMBER and are not under the Parish's direct control.\n   such as -- OUTSIDE FOUNDATIONS, TRUSTS and SVDP"]
[]
[null,null,null,null,0,{"$f":"IF(AND((E595<>0), (ISBLANK(D595))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
[null,null,null,null,0,{"$f":"IF(AND((E596<>0), (ISBLANK(D596))),  \"ERROR-Fill out Col D\", \" \")","v":" "}]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[null,null,null,null,0," "]
[]
["TOTAL ACCOUNT BALANCES OF OUTSIDE ACCOUNTS",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E595:E604)","v":0}]
[]
[]
[]
["SCHEDULE M - CHURCH AND SCHOOL FUNDRAISING"]
[{"$f":"IF(D23=\"NO\",\"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE\",\" \")","v":"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE"}]
["(DO NOT add rows to this area)"]
[]
["CHURCH FUNDRAISING FOR THE YEAR ENDED",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"}]
["Fund Raising Event",null,"Income","Expense","Net "]
[null,null,0,0,{"$f":"C616-D616","v":0}]
[null,null,0,0,{"$f":"C617-D617","v":0}]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,{"$f":"C629-D629","v":0}]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[]
["TOTAL PARISH FUNDRAISING FOR THE YEAR ENDED  ",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E616:E634)","v":0}]
[null,null,{"$f":"IF(E636= \"OK\", \" \", \"ERROR - TOTAL SHOULD EQUAL\")","v":" "},null,{"$f":"IF((ROUND(E635,2))=(ROUND('Toolkit Trial Balance'!G343,2)), \"OK\", 'Toolkit Trial Balance'!G343)","v":"OK"}]
["SCHOOL FUNDRAISING FOR THE YEAR ENDED",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"}]
["Fund Raising Event",null,"Income","Expense","Net "]
[null,null,0,0,{"$f":"C639-D639","v":0}]
[null,null,0,0,{"$f":"C640-D640","v":0}]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,{"$f":"C646-D646","v":0}]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[]
["TOTAL SCHOOL FUNDRAISING FOR THE YEAR ENDED ",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E639:E657)","v":0}]
[{"$f":"IF(E658='Toolkit Trial Balance'!G378,\" \",\"ERROR - TOTAL SHOULD EQUAL\")","v":" "},null,null,null,{"$f":"IF((ROUND(E658,2))=(ROUND('Toolkit Trial Balance'!G378,2)),  \"OK\", 'Toolkit Trial Balance'!G378)","v":"OK"}]
[]
[]
["SCHEDULE N - DEFERRED RESTRICTED SUPPORT"]
[{"$f":"IF(D25=\"NO\",\"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE\",\" \")","v":"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE"}]
[]
["DEFERRED RESTRICTED SUPPORT FOR THE YEAR ENDED",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},"Amount"]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
["TOTAL DEFERRED RESTRICTED SUPPORT  FOR YEAR ENDED",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E666:E684)","v":0}]
[{"$f":"IF(E685='Toolkit Trial Balance'!G59,\" \",\"ERROR - TOTAL SHOULD EQUAL\")","v":" "},null,null,null,{"$f":"IF((ROUND(E685,2))=(ROUND('Toolkit Trial Balance'!G59,2)), \"OK\", 'Toolkit Trial Balance'!G59)","v":"OK"}]
[]
["SCHEDULE O - PARISH RENTAL RECEIPTS"]
[{"$f":"IF(D26=\"NO\",\"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE\",\" \")","v":"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE"}]
["Note: School rental Income is in Schedule I"]
["PARISH RENTAL RECEIPTS FOR THE YEAR ENDED",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},"Receipts"]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
["TOTAL PARISH RENTAL RECEIPTS FOR YEAR ENDED",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E692:E710)","v":0}]
[{"$f":"IF(E711='Toolkit Trial Balance'!G346,\" \",\"ERROR - TOTAL SHOULD EQUAL\")","v":" "},null,null,null,{"$f":"IF((ROUND(E711,2))=(ROUND('Toolkit Trial Balance'!G346,2)), \"OK\", 'Toolkit Trial Balance'!G346)","v":"OK"}]
[]
["SCHEDULE P - OTHER ASSETS DETAIL"]
[{"$f":"IF(D5=\"NO\",\"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE\",\" \")","v":" "}]
[]
["OTHER ASSETS AS OF",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},"Amount"]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
["TOTAL OTHER ASSETS AS OF",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E718:E733)","v":0}]
[{"$f":"IF(E734='Toolkit Trial Balance'!G314,\" \",\"ERROR - TOTAL SHOULD EQUAL\")","v":" "},null,null,null,{"$f":"IF((ROUND(E734,2))=(ROUND('Toolkit Trial Balance'!G314,2)),\"OK\",'Toolkit Trial Balance'!G314)","v":"OK"}]
["SCHEDULE Q - INCOME RECEVIED IN ADVANCE"]
[{"$f":"IF(D28=\"NO\",\"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE\",\" \")","v":"YOUR PARISH IS NOT REQUIRED TO PREPARE THIS SCHEDULE"}]
[]
["INCOME RECEIVED IN ADVANCE  AS OF",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},"Amount"]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
["TOTAL INC REC'D IN ADVANCE AS OF",null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"SUM(E740:E755)","v":0}]
[{"$f":"IF(E756='Toolkit Trial Balance'!G321,\" \",\"ERROR - TOTAL SHOULD EQUAL\")","v":" "},null,null,null,{"$f":"IF((ROUND(E756,2))=(ROUND('Toolkit Trial Balance'!G321,2)),\"OK\",'Toolkit Trial Balance'!G321)","v":"OK"}]

{"sheet":"Parishioner Report Template","index":2,"n_rows":128,"n_cols":4,"rows_kept":128,"cut":false,"hidden":false,"merged":[[1,0,1,3],[121,0,121,3],[0,7,1,15],[6,2,6,3],[122,1,122,2],[41,1,41,2],[5,0,5,3],[86,1,86,2],[4,0,4,3],[40,0,40,3],[85,0,85,3]]}
[]
[{"$f":"UPPER('Toolkit Trial Balance'!$D$24)","v":""}]
[]
[]
["STATEMENT OF ASSETS, LIABILITIES AND FUND BALANCE"]
["CHURCH, SCHOOL & CEMETERY"]
[null,null,"Balance at June 30,"]
[null,null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"'Toolkit Trial Balance'!$D$8","v":"2020-06-30"}]
["ASSETS"]
["CHECKING, SAVINGS AND INVESTMENTS"]
["Checking Account Balances",null,{"$f":"'Toolkit Trial Balance'!G310","v":0},{"$f":"'Toolkit Trial Balance'!H310","v":0}]
["Savings and Investment Account Balances",null,{"$f":"'Toolkit Trial Balance'!G311","v":0},{"$f":"'Toolkit Trial Balance'!H311","v":0}]
["TOTAL CHECKING SAVINGS AND INVESTMENTS",null,{"$f":"SUM(C11:C12)","v":0},{"$f":"SUM(D11:D12)","v":0}]
["ACCOUNTS RECEIVABLE",null,{"$f":"'Toolkit Trial Balance'!G313","v":0},{"$f":"'Toolkit Trial Balance'!H313","v":0}]
["OTHER ASSETS",null,{"$f":"'Toolkit Trial Balance'!G314","v":0},{"$f":"'Toolkit Trial Balance'!H314","v":0}]
["TOTAL ASSETS",null,{"$f":"SUM(C13:C15)","v":0},{"$f":"SUM(D13:D15)","v":0}]
["LIABILITIES"]
["ACCOUNTS PAYABLE AND ACCRUED EXPENSES"]
["Payable to Diocese of Cleveland",null,{"$f":"'Toolkit Trial Balance'!G318","v":0},{"$f":"'Toolkit Trial Balance'!H318","v":0}]
["Other accounts payable and accrued expenses",null,{"$f":"'Toolkit Trial Balance'!G319","v":0},{"$f":"'Toolkit Trial Balance'!H319","v":0}]
["TOTAL ACCOUNTS PAYABLE AND ACCRUED EXPENSES",null,{"$f":"SUM(C19:C20)","v":0},{"$f":"SUM(D19:D20)","v":0}]
["INCOME RECEIVED IN ADVANCE",null,{"$f":"'Toolkit Trial Balance'!G321","v":0},{"$f":"'Toolkit Trial Balance'!H321","v":0}]
["EMPLOYEE WITHHOLDING",null,{"$f":"'Toolkit Trial Balance'!G322","v":0},{"$f":"'Toolkit Trial Balance'!H322","v":0}]
["DEFERRED RESTRICTED SUPPORT",null,{"$f":"'Toolkit Trial Balance'!G323","v":0},{"$f":"'Toolkit Trial Balance'!H323","v":0}]
["LOANS, NOTES AND MORTGAGES PAYABLE",null,{"$f":"'Toolkit Trial Balance'!G324","v":0},{"$f":"'Toolkit Trial Balance'!H324","v":0}]
["TOTAL LIABILITIES",null,{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D21:D25)","v":0}]
[]
["FUND BALANCE"]
["FUND BALANCE BEGINNING OF FISCAL YEAR",null,{"$f":"'Toolkit Trial Balance'!G327","v":0},{"$f":"'Toolkit Trial Balance'!H327","v":0}]
["Net Surplus (Deficit) for Fiscal Year"]
["Parish",null,{"$f":"'Toolkit Trial Balance'!G329","v":0},{"$f":"'Toolkit Trial Balance'!H329","v":0}]
["School",null,{"$f":"'Toolkit Trial Balance'!G330","v":0},{"$f":"'Toolkit Trial Balance'!H330","v":0}]
["Cemetery",null,{"$f":"'Toolkit Trial Balance'!G331","v":0},{"$f":"'Toolkit Trial Balance'!H331","v":0}]
["Net surplus (deficit) for fiscal year",null,{"$f":"SUM(C31:C33)","v":0},{"$f":"SUM(D31:D33)","v":0}]
["FUND BALANCE, END OF FISCAL YEAR",null,{"$f":"C29+C34","v":0},{"$f":"D29+D34","v":0}]
[]
["TOTAL LIABILITIES AND FUND BALANCE",null,{"$f":"C26+C35","v":0},{"$f":"D26+D35","v":0}]
[]
[]
[]
["STATEMENT OF CHURCH REVENUE AND EXPENSES"]
[null,"Actual Year Ended June 30,",null,"Budget\nYear Ending\nJune 30,"]
[null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"'Toolkit Trial Balance'!$D$8","v":"2020-06-30"},{"$f":"'Toolkit Trial Balance'!$D$9","v":"2022-06-30"}]
["CHURCH REVENUE"]
[]
["Offertory Collections",{"$f":"'Toolkit Trial Balance'!G339","v":0},{"$f":"'Toolkit Trial Balance'!H339","v":0},{"$f":"'Toolkit Trial Balance'!I339","v":0}]
["Other Collections",{"$f":"'Toolkit Trial Balance'!G340","v":0},{"$f":"'Toolkit Trial Balance'!H340","v":0},{"$f":"'Toolkit Trial Balance'!I340","v":0}]
["Donations & Bequests",{"$f":"'Toolkit Trial Balance'!G341","v":0},{"$f":"'Toolkit Trial Balance'!H341","v":0},{"$f":"'Toolkit Trial Balance'!I341","v":0}]
["Net Bingo Proceeds",{"$f":"'Toolkit Trial Balance'!G342","v":0},{"$f":"'Toolkit Trial Balance'!H342","v":0},{"$f":"'Toolkit Trial Balance'!I342","v":0}]
["Net Fund Raising Income",{"$f":"'Toolkit Trial Balance'!G343","v":0},{"$f":"'Toolkit Trial Balance'!H343","v":0},{"$f":"'Toolkit Trial Balance'!I343","v":0}]
["Income from Parish Programs",{"$f":"'Toolkit Trial Balance'!G344","v":0},{"$f":"'Toolkit Trial Balance'!H344","v":0},{"$f":"'Toolkit Trial Balance'!I344","v":0}]
["Investment & Endowment Income (Loss)",{"$f":"'Toolkit Trial Balance'!G345","v":0},{"$f":"'Toolkit Trial Balance'!H345","v":0},{"$f":"'Toolkit Trial Balance'!I345","v":0}]
["Rental Receipts",{"$f":"'Toolkit Trial Balance'!G346","v":0},{"$f":"'Toolkit Trial Balance'!H346","v":0},{"$f":"'Toolkit Trial Balance'!I346","v":0}]
["Contributions from Parish Organizations",{"$f":"'Toolkit Trial Balance'!G347","v":0},{"$f":"'Toolkit Trial Balance'!H347","v":0},{"$f":"'Toolkit Trial Balance'!I347","v":0}]
["Miscellaneous Receipts",{"$f":"'Toolkit Trial Balance'!G348","v":0},{"$f":"'Toolkit Trial Balance'!H348","v":0},{"$f":"'Toolkit Trial Balance'!I348","v":0}]
["Designated Collections",{"$f":"'Toolkit Trial Balance'!G349","v":0},{"$f":"'Toolkit Trial Balance'!H349","v":0},{"$f":"'Toolkit Trial Balance'!I349","v":0}]
["Extraordinary Receipts",{"$f":"'Toolkit Trial Balance'!G350","v":0},{"$f":"'Toolkit Trial Balance'!H350","v":0},{"$f":"'Toolkit Trial Balance'!I350","v":0}]
[]
["TOTAL CHURCH REVENUE",{"$f":"SUM(B46:B58)","v":0},{"$f":"SUM(C46:C58)","v":0},{"$f":"SUM(D46:D58)","v":0}]
[]
["CHURCH EXPENSES"]
[]
["Salaries, Benefits, & Taxes",{"$f":"'Toolkit Trial Balance'!G353","v":0},{"$f":"'Toolkit Trial Balance'!H353","v":0},{"$f":"'Toolkit Trial Balance'!I353","v":0}]
["Rectory & Household",{"$f":"'Toolkit Trial Balance'!G354","v":0},{"$f":"'Toolkit Trial Balance'!H354","v":0},{"$f":"'Toolkit Trial Balance'!I354","v":0}]
["Parish Office & Administration",{"$f":"'Toolkit Trial Balance'!G355","v":0},{"$f":"'Toolkit Trial Balance'!H355","v":0},{"$f":"'Toolkit Trial Balance'!I355","v":0}]
["Altar, Sanctuary, & Liturgical",{"$f":"'Toolkit Trial Balance'!G356","v":0},{"$f":"'Toolkit Trial Balance'!H356","v":0},{"$f":"'Toolkit Trial Balance'!I356","v":0}]
["Community Outreach",{"$f":"'Toolkit Trial Balance'!G357","v":0},{"$f":"'Toolkit Trial Balance'!H357","v":0},{"$f":"'Toolkit Trial Balance'!I357","v":0}]
["Religious Education ",{"$f":"'Toolkit Trial Balance'!G358","v":0},{"$f":"'Toolkit Trial Balance'!H358","v":0},{"$f":"'Toolkit Trial Balance'!I358","v":0}]
["Stewardship & Evangelization",{"$f":"'Toolkit Trial Balance'!G359","v":0},{"$f":"'Toolkit Trial Balance'!H359","v":0},{"$f":"'Toolkit Trial Balance'!I359","v":0}]
["Utilities",{"$f":"'Toolkit Trial Balance'!G360","v":0},{"$f":"'Toolkit Trial Balance'!H360","v":0},{"$f":"'Toolkit Trial Balance'!I360","v":0}]
["Insurance & Property Taxes",{"$f":"'Toolkit Trial Balance'!G361","v":0},{"$f":"'Toolkit Trial Balance'!H361","v":0},{"$f":"'Toolkit Trial Balance'!I361","v":0}]
["Maintenance, Repairs, & Plant Operating",{"$f":"'Toolkit Trial Balance'!G362","v":0},{"$f":"'Toolkit Trial Balance'!H362","v":0},{"$f":"'Toolkit Trial Balance'!I362","v":0}]
["Diocesan Assessments",{"$f":"'Toolkit Trial Balance'!G363","v":0},{"$f":"'Toolkit Trial Balance'!H363","v":0},{"$f":"'Toolkit Trial Balance'!I363","v":0}]
["Payments to Other Schools",{"$f":"'Toolkit Trial Balance'!G364","v":0},{"$f":"'Toolkit Trial Balance'!H364","v":0},{"$f":"'Toolkit Trial Balance'!I364","v":0}]
["Designated Collections",{"$f":"'Toolkit Trial Balance'!G365","v":0},{"$f":"'Toolkit Trial Balance'!H365","v":0},{"$f":"'Toolkit Trial Balance'!I365","v":0}]
["Capital Expenditures",{"$f":"'Toolkit Trial Balance'!G366","v":0},{"$f":"'Toolkit Trial Balance'!H366","v":0},{"$f":"'Toolkit Trial Balance'!I366","v":0}]
["Intra Parish Transfers & School Support",{"$f":"'Toolkit Trial Balance'!G367","v":0},{"$f":"'Toolkit Trial Balance'!H367","v":0},{"$f":"'Toolkit Trial Balance'!I367","v":0}]
["Extraordinary Expenses",{"$f":"'Toolkit Trial Balance'!G368","v":0},{"$f":"'Toolkit Trial Balance'!H368","v":0},{"$f":"'Toolkit Trial Balance'!I368","v":0}]
[]
["TOTAL CHURCH EXPENSES",{"$f":"SUM(B63:B79)","v":0},{"$f":"SUM(C63:C79)","v":0},{"$f":"SUM(D63:D79)","v":0}]
[]
["NET CHURCH SURPLUS (DEFICIT)",{"$f":"B59-B80","v":0},{"$f":"C59-C80","v":0},{"$f":"D59-D80","v":0}]
[]
[]
[]
["STATEMENT OF SCHOOL REVENUE AND EXPENSES"]
[null,"Actual Year Ended June 30,",null,"Budget\nYear Ending\nJune 30,"]
[null,{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"'Toolkit Trial Balance'!$D$8","v":"2020-06-30"},{"$f":"'Toolkit Trial Balance'!$D$9","v":"2022-06-30"}]
["SCHOOL REVENUE"]
[]
["Tuition & Fees (Includes Tuition Assistance)",{"$f":"'Toolkit Trial Balance'!G375","v":0},{"$f":"'Toolkit Trial Balance'!H375","v":0},{"$f":"'Toolkit Trial Balance'!I375","v":0}]
["Government Assistance",{"$f":"'Toolkit Trial Balance'!G376","v":0},{"$f":"'Toolkit Trial Balance'!H376","v":0},{"$f":"'Toolkit Trial Balance'!I376","v":0}]
["Donations & Bequests",{"$f":"'Toolkit Trial Balance'!G377","v":0},{"$f":"'Toolkit Trial Balance'!H377","v":0},{"$f":"'Toolkit Trial Balance'!I377","v":0}]
["Net Fund Raising",{"$f":"'Toolkit Trial Balance'!G378","v":0},{"$f":"'Toolkit Trial Balance'!H378","v":0},{"$f":"'Toolkit Trial Balance'!I378","v":0}]
["Net Pre-School & Latchkey",{"$f":"'Toolkit Trial Balance'!G379","v":0},{"$f":"'Toolkit Trial Balance'!H379","v":0},{"$f":"'Toolkit Trial Balance'!I379","v":0}]
["Other Student Receipts",{"$f":"'Toolkit Trial Balance'!G380","v":0},{"$f":"'Toolkit Trial Balance'!H380","v":0},{"$f":"'Toolkit Trial Balance'!I380","v":0}]
["School Support from Parish",{"$f":"'Toolkit Trial Balance'!G381","v":0},{"$f":"'Toolkit Trial Balance'!H381","v":0},{"$f":"'Toolkit Trial Balance'!I381","v":0}]
["Interest & Endowment Income",{"$f":"'Toolkit Trial Balance'!G382","v":0},{"$f":"'Toolkit Trial Balance'!H382","v":0},{"$f":"'Toolkit Trial Balance'!I382","v":0}]
["Other Income",{"$f":"'Toolkit Trial Balance'!G383","v":0},{"$f":"'Toolkit Trial Balance'!H383","v":0},{"$f":"'Toolkit Trial Balance'!I383","v":0}]
[]
["TOTAL SCHOOL REVENUE",{"$f":"SUM(B91:B99)","v":0},{"$f":"SUM(C91:C99)","v":0},{"$f":"SUM(D91:D99)","v":0}]
[]
["SCHOOL EXPENSES"]
["Salaries, Benefits & Taxes",{"$f":"'Toolkit Trial Balance'!G386","v":0},{"$f":"'Toolkit Trial Balance'!H386","v":0},{"$f":"'Toolkit Trial Balance'!I386","v":0}]
["Instructional",{"$f":"'Toolkit Trial Balance'!G387","v":0},{"$f":"'Toolkit Trial Balance'!H387","v":0},{"$f":"'Toolkit Trial Balance'!I387","v":0}]
["Library & Technology",{"$f":"'Toolkit Trial Balance'!G388","v":0},{"$f":"'Toolkit Trial Balance'!H388","v":0},{"$f":"'Toolkit Trial Balance'!I388","v":0}]
["Utilities",{"$f":"'Toolkit Trial Balance'!G389","v":0},{"$f":"'Toolkit Trial Balance'!H389","v":0},{"$f":"'Toolkit Trial Balance'!I389","v":0}]
["Maintenance, Repairs & Plant Operating",{"$f":"'Toolkit Trial Balance'!G390","v":0},{"$f":"'Toolkit Trial Balance'!H390","v":0},{"$f":"'Toolkit Trial Balance'!I390","v":0}]
["Insurance & Property Taxes",{"$f":"'Toolkit Trial Balance'!G391","v":0},{"$f":"'Toolkit Trial Balance'!H391","v":0},{"$f":"'Toolkit Trial Balance'!I391","v":0}]
["Student Services",{"$f":"'Toolkit Trial Balance'!G392","v":0},{"$f":"'Toolkit Trial Balance'!H392","v":0},{"$f":"'Toolkit Trial Balance'!I392","v":0}]
["Administration",{"$f":"'Toolkit Trial Balance'!G393","v":0},{"$f":"'Toolkit Trial Balance'!H393","v":0},{"$f":"'Toolkit Trial Balance'!I393","v":0}]
["Faculty Residence/Convent Costs",{"$f":"'Toolkit Trial Balance'!G394","v":0},{"$f":"'Toolkit Trial Balance'!H394","v":0},{"$f":"'Toolkit Trial Balance'!I394","v":0}]
["Capital Expenditures",{"$f":"'Toolkit Trial Balance'!G395","v":0},{"$f":"'Toolkit Trial Balance'!H395","v":0},{"$f":"'Toolkit Trial Balance'!I395","v":0}]
["Extraordinary Expenses ",{"$f":"'Toolkit Trial Balance'!G396","v":0},{"$f":"'Toolkit Trial Balance'!H396","v":0},{"$f":"'Toolkit Trial Balance'!I396","v":0}]
[]
["TOTAL SCHOOL EXPENSES",{"$f":"SUM(B104:B114)","v":0},{"$f":"SUM(C104:C114)","v":0},{"$f":"SUM(D104:D114)","v":0}]
[]
["NET SCHOOL SURPLUS (DEFICIT)",{"$f":"B101-B116","v":0},{"$f":"C101-C116","v":0},{"$f":"D101-D116","v":0}]
[]
[]
[]
["STATEMENT OF CEMETERY REVENUE AND EXPENSES"]
[null,"Actual Year Ended June 30,",null,"Budget\nYear Ending\nJune 30,"]
[" ",{"$f":"'Toolkit Trial Balance'!$D$7","v":"2021-06-30"},{"$f":"'Toolkit Trial Balance'!$D$8","v":"2020-06-30"},{"$f":"'Toolkit Trial Balance'!$D$9","v":"2022-06-30"}]
["CEMETERY REVENUE",{"$f":"'Toolkit Trial Balance'!G402","v":0},{"$f":"'Toolkit Trial Balance'!H402","v":0},{"$f":"'Toolkit Trial Balance'!I402","v":0}]
["CEMETERY EXPENSE",{"$f":"'Toolkit Trial Balance'!G403","v":0},{"$f":"'Toolkit Trial Balance'!H403","v":0},{"$f":"'Toolkit Trial Balance'!I403","v":0}]
[]
["NET CEMETERY SURPLUS (DEFICIT)",{"$f":"B125-B126","v":0},{"$f":"C125-C126","v":0},{"$f":"D125-D126","v":0}]

{"sheet":"YE Memo & Rest. Definitions","index":3,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"TO OPEN ALL PAGES OF MEMO"]
[null,null,null,null,null,null,null,null,null,null,"right click on memo "]
[null,null,null,null,null,null,null,null,null,null,"choose Document Object (or Acrobat Document Object)"]
[null,null,null,null,null,null,null,null,null,null,"choose open"]