ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
General Projects Workbook
2
Use Budget, Project Register, Financial Report, Remaining Funds, and Reconciliation to manage reserve projects for one fiscal year.
3
4
How to use this workbook
5
StepAction
6
1Enter the fiscal year and adopted annual reserve budget on Budget. Retain supporting estimates and funding assumptions.
7
2Document proposals and board approvals in the separate Project Proposal Workbook. Enter approved projects in Project Register, one row per project. Optional proposed rows are excluded from commitments.
8
3Select Fund, Project Type, and Status from dropdowns. Enter the approval date and approved amount / not-to-exceed (NTE). Keep one unique Project ID and link approval records in Notes.
9
4Update each project’s actual fiscal-year expenditures through the Financial Report as-of date. Enter 0 if none. Enter an estimated fiscal-year final cost, vendor, and completion date where applicable.
10
5Enter actual YTD receipts and the as-of date on Financial Report. Project expenditure totals update automatically. Review Remaining Funds for each fund’s remaining spending budget less unspent authorizations.
11
12
Workbook conventions
13
Cell colorMeaning
14
Yellow fill / blue textUnlocked user entries. Input cells remain editable while each worksheet is protected.
15
Green fill / green textLocked formulas and references. Totals update automatically from their source inputs.
16
White cellsLabels, notes, and instructions.
17
18
PRF = pooled reserve fund. SRF = separate reserve fund. Use categories that match association records. This workbook tracks one fiscal year and uses the same reporting date throughout.
19
20
Complete Reconciliation using bank / investment statements and the general ledger for the same date. Enter 0 for no timing items. Investigate differences rather than plugging them.
21
22
Approved but unspent = MAX(0, approved amount minus actual fiscal-year expenditures). Proposed rows have no commitments. Completed or deferred projects retain unused authorizations until the board releases them; record any approved reduction in the amount and Notes.
23
24
For a carried-over project, enter the authorization available at the fiscal-year opening plus any new approvals, and enter only this fiscal year’s expenditures. Estimated final cost uses that same fiscal-year scope. Positive authorization-less-estimate variance is headroom; negative is an expected overrun.
25
26
Keep all reserve expenditures in Project Register, including amounts paid before approval, to reconcile with accounting records. Highlighted fields require review. Retain bids, invoices, approvals, statements, and reserve study support with association records.
27
28
Project Register provides 200 entry rows (11–210). To add more, unprotect the sheet, extend the table and formulas, extend all summary and Financial Report SUMIFS / COUNTIFS ranges, then restore protection. Sheets have no password.
29
30
Estimated Funds Available for Remaining Authorizations uses the annual planned spending budget remaining after actual expenditures, less approved unspent commitments. It does not measure cash available in bank accounts. Review each fund separately even when the total is positive.
31
32
Association applicability
33
Association typeJurisdictionApplicable law / supplement
34
Select association type
35
Before use, identify the association’s legal form and jurisdiction, then confirm the applicable reserve, budget, approval, and disclosure requirements. This general reserve workbook organizes project records but does not establish legal compliance. Timeshare associations require separate statutory and plan-specific review.
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100