Spreadsheet: a98cd881-812f-4f80-b708-c8a6fdcca686
Sheet: Final Closeout

CHAPTER: |  |  |  |  |  |  |  |  |  | Account #: |  |  |  |  |  |  | The chapter name is mapped from the OA Budget Planning-Report worksheet cell "OA Budget Planning-Report Sheet'!B5"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The chapter account # is mapped from the OA Budget Planning-Report worksheet cell "OA Budget Planning-Report Sheet'!B7"
CALCULATING ACTUAL REVENUE
 |  |  |  |  |  |  | Quantity |  |  | Cost |  |  | Total
 | Ordeal Candidates |  |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | The number of registrants by attendee category is entered into cells "H5" to "H11"
 | Elangomats |  |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | The fee/cost is mapped from the Estimated Budget worksheet
 | Members |  |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | cells "H5" through "H11"
 | Members (Day Only) |  |  |  |  |  |  | x | $ |  | = | $
 | Feast Only |  |  |  |  |  |  | x | $ |  | = | $
 |  |  |  |  |  |  |  | x | $ |  | = | $
 |  |  |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | [NAME] is entered as follows
 |  |  |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | The description of the Miscellaneous Income in cells "B12" to "B13"
 |  |  |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | As a quantity of "1" in cells "H12" to "H13"
 | Late Fee |  |  |  |  |  |  | x | $ |  | = | $ |  |  |  |  | The amount received in cells  "K12" to "K13"
 | REVENUE |  |  |  |  |  |  |  |  |  |  | $ |  |  |  |  | The categories of revenue are automatically totaled and the Total Revenue is calculated in cell "N15"
CALCULATING ACTUAL EXPENSES
 | Food |  |  | [attach all original receipts] |  |  |  |  |  | Cost
 |  |  |  |  |  |  |  |  | $
 |  |  |  |  |  |  |  |  | $
 |  |  |  |  |  |  |  |  | $
 |  |  |  |  |  |  |  |  | $
 |  |  |  |  |  |  |  |  | $
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | Each receipt for Food is listed in cells "C18" to "C28"
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | and the corresponding receipt total is listed in cells "K18" to "K28"
 |  |  |  |  |  |  |  |  | $
 |  |  |  |  |  |  |  |  | $
 |  |  |  |  |  |  |  |  | $
 |  |  |  |  |  |  |  |  | $
 |  | TOTAL ACTUAL FOOD COSTS |  |  |  |  |  |  |  |  |  | $ |  |  |  |  | The Total Actual Foods Cost is totaled in cell "N29"
 | Postage |  |  | [attach all original receipts] |  |  |  |  |  | Cost
 |  |  |  |  |  |  |  |  | $
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | Each receipt for Postage is listed in cells "C31" to "C34"
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | and the corresponding receipt total is listed in cells "K31" to "K34"
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | The Total Actual Postage Cost is totaled in cell "N35"
 |  | TOTAL ACTUAL POSTAGE COSTS |  |  |  |  |  |  |  |  |  | $
 | Printing |  |  | [attach all original receipts] |  |  |  |  |  | Cost
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | Each receipt for Printing is listed in cells "C37" to "C40"
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | and the corresponding receipt total is listed in cells "K37" to "K40"
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | The Total Actual Printing Cost is totaled in cell "N41"
 |  |  |  |  |  |  |  |  | $
 |  | TOTAL ACTUAL PRINTING COSTS |  |  |  |  |  |  |  |  |  | $
 | Awards |  |  | [attach all original receipts] |  |  |  |  |  | Cost
 |  |  |  |  |  |  |  |  | $
 |  |  |  |  |  |  |  |  | $
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | Each receipt for Awards is listed in cells "C43" to "C48"
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | and the corresponding receipt total is listed in cells "K43" to "K48"
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | The Total Actual Awards Cost is totaled in cell "N49"
 |  |  |  |  |  |  |  |  | $
 |  | TOTAL ACTUAL AWARDS COSTS |  |  |  |  |  |  |  |  |  | $
 | Ceremonies |  |  | [attach all original receipts] |  |  |  |  |  | Cost
 |  |  |  |  |  |  |  |  | $
 |  |  |  |  |  |  |  |  | $
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | Each receipt for Ceremonies is listed in cells "C51" to "C56"
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | and the corresponding receipt total is listed in cells "K51" to "K56"
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | The Total Actual Ceremonies Cost is totaled in cell "[NAME]"
 |  |  |  |  |  |  |  |  | $
 |  | TOTAL ACTUAL CEREMONIES COSTS |  |  |  |  |  |  |  |  |  | $
 | Health & Safety |  |  |  | [attach all original receipts] |  |  |  |  | Cost
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | Each receipt for Health & Safety is listed in cells "C59" to "C62"
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | and the corresponding receipt total is listed in cells "K59" to "K62"
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | The Total Actual Facility/Site Infrastructure Cost is totaled in cell "N63"
 |  |  |  |  |  |  |  |  | $
 |  | TOTAL ACTUAL HEALTH & SAFETEY COSTS |  |  |  |  |  |  |  |  |  | $
 | Facility/Site Infrastructure |  |  |  | [attach all original receipts] |  |  |  |  | Cost
 |  |  |  |  | Facility Usage Fee |  |  |  | $ |  |  |  |  |  |  |  | 679"
 |  |  |  |  | Port-a-John(s) |  |  |  | $ |  |  |  |  |  |  |  | and the corresponding receipt total is listed in cells "K65" to "K69"
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | NOTE: if the facility Usage Fee and/or the Port-a-John(s) cost are not a "reimbursement"
 |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  | then the dollar amount is listed under "Checks issued by Council Finance Office
 |  |  |  |  |  |  |  |  | $
 |  | TOTAL ACTUAL FACILITY/SITE INFRASTRUCTURE COSTS |  |  |  |  |  |  |  |  |  | $ |  |  |  |  | The Total Actual Facility/Site Infrastructure Cost is totaled in cell "N70"
 | Total Disbursement (Reimbursements)
 |  | TOTAL ACTUAL DISBURSEMENTS (REIMBURSEMENTS) |  |  |  |  |  |  |  |  |  | $ |  |  |  |  | The Actual Total of Disbursements (Reimbursements) equal balance in cell "Reimbursements-Refunds'!M101"
 | Checks issued by Council Finance Office
 |  |  |  |  | Facility Usage Fee |  |  |  | $
 |  |  |  |  | Port-a-John(s) |  |  |  | $ |  |  |  |  |  |  |  | The Actual Total of Invoices to be paid by Council Finance Office
 |  |  |  |  |  |  |  |  | $
 |  |  |  |  |  |  |  |  | $
 |  | Total Refund Checks paid by Council Finance Office |  |  |  |  |  |  |  |  |  | $ |  |  |  |  | The Actual Total of Refunds to be paid by Council Finance Office
 |  | TOTAL ACTUAL CHECKS FROM COUNCIL FINANCE OFFICE |  |  |  |  |  |  |  |  |  | $
 | Ordeal Candidates |  |  |  | Quantity |  | Cost |  |  | Total |  |  |  |  |  |  | The event specific supplies are mapped as follows
 |  | [NAME]Regular) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]Regular) quantity calculated as indicated in the comment attached to cell"F81" and Cost is mapped from "Consignment!D12"
 |  | [NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]) quantity calculated as indicated in the comment attached to cell "F82" and Cost is mapped from "Consignment!D13" and totaled automatically
 |  | O/A Handbook |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O/A Handbook quantity calculated as indicated in the comment attached to cell"F83" and Cost is mapped from "Consignment!D14" and totaled automatically
 |  | Amangamek-Wipit Flap |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amangamek-Wipit Flap quantity calculated as indicated in the comment attached to cell"F84" and Cost is mapped from "Consignment!D15" and totaled automatically
 |  |  |  |  |  | x |  | = | $ |  |  | $ |  |  |  |  | The Total Ordeal Candidates Cost is totaled in cell "N85"
 | Brotherhood Candidates |  |  |  | Quantity |  | Cost |  |  | Total
 |  | [NAME] (Regular) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (Regular) quantity calculated as indicated in the comment attached to cell "F87" and Cost is mapped from "Consignment!D16" and totaled automatically
 |  | [NAME] (Long) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (Long) quantity calculated as indicated in the comment attached to cell "F88" and Cost is mapped from "Consignment!D17" and totaled automatically
 |  |  |  |  |  | x |  | = | $ |  |  | $ |  |  |  |  | The Total Brotherhood Candidates Cost is totaled in cell "N89"
 | Elangomats |  |  |  | Quantity |  | Cost |  |  | Total
 |  | Elangomat Patch |  |  |  | x |  | = | $ |  |  | $ |  |  |  |  | Elangomat Patch quantity is calculated as indicated in the comment attached to cell"F91" and Cost is mapped from "Consignment!D18" and totaled automatically
 | Insurance Recovery |  |  |  | Quantity |  | Cost |  |  | Total |  |  |  |  |  |  | The event Liability Insurance Recovery is mapped as follows
 |  | Ordeal Candidates / Elangomats / Members |  |  |  | x |  | = | $ |  |  |  |  |  |  |  | The quantity is mapped from the sum of cells "H5", "H6", and "H7" and the Cost is mapped from cell "Estimated Budget'!H65" and totaled automatically
 |  | No Shows Ordeal Candidates / Elangomats / Members |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The number of "no shows" are entered in cell "F94" (i.e. pre-registrations that do not attend the event)
 |  | Non-members
 |  | Members (Day Only) |  |  |  | x |  | = | $ |  |  |  |  |  |  |  | The quantity is mapped from cell "H8"and the Cost is mapped from cell "Estimated Budget'!P87" and totaled automatically
 |  | Feast Only |  |  |  | x |  | = | $ |  |  | $ |  |  |  |  | The quantity is mapped from cell "H9"and the Cost is mapped from cell "Estimated Budget'!H8" and totaled automatically
 | Dues |  |  |  | Quantity |  | Cost |  |  | Total |  |  |  |  |  |  | The event OA Dues is mapped as follows
 |  | Candidates O/A Dues |  |  |  | x |  | = | $ |  |  | $ |  |  |  |  | The quantity is mapped from cell "H5"and the Cost is mapped from cell "Estimated Budget'!H64" and totaled automatically
 |  | No Shows Candidates |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The number of ordeal candidate "no shows" are entered in cell "F100" (i.e. pre-registrations that do not attend the event)
 |  | TOTAL ACTUAL EXPENSES |  |  |  |  |  |  |  |  |  | $ |  |  |  |  | The Total Actual Expenses is mapped as the "SUM(N72:N100)"
 |  | TOTAL ACTUAL REVENUE |  |  |  |  |  |  |  |  |  | $ |  |  |  |  | The Total Actual Revenue is mapped from cell "N15"
 |  | DIFFERENCE |  |  |  |  |  |  |  |  |  | $ |  |  |  |  | The difference automatically calculated as the  surplus Revenue over Expenses (Positive)
 |  | For Honor Chapter consideration (all Levels) difference cannot be negative |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Surplus Revenue over Expenses (Positive) or the deficit of Expenses over Revenue (Negative)
TRANSFER FIGURES TO THE ORDER of the ARROW "ACTIVITY BUDGET PLANNING/REPORT SHEET"