ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Florida Projects Workbook
2
A practical Florida reserve-fund recordkeeping template for annual budgeting, year-to-date reporting, and reconciliation. Use it with the separate Florida Proposal / AFE Workbook and the Florida Primer.
3
4
How to use this workbook
5
StepAction
6
1Use the separate Project Proposal Workbook to document proposals and board approvals. Enter one row per project on Project Register.
7
2Complete Budget for one fiscal year. In Project Register, record the fund, status, approval, authorized FY amount, and actual expenditures through the reporting date.
8
3Enter the reporting date and actual receipts on Financial Report. Project Register supplies expenditures automatically.
9
4Review Remaining Funds for unspent commitments and incomplete project records. Reconcile bank and general ledger balances for the same date.
10
5Retain bids, invoices, approvals, statements, and reserve study support with association records.
11
12
Workbook conventions
13
Cell colorMeaning
14
Yellow fill / blue textUser entry or input
15
Green fill / green textFormula linked or calculated in this workbook
16
White cellsLabels, notes, or instructions
17
18
SIRS = Structural Integrity Reserve Study reserves where Florida law requires it; TRS = traditional / non-SIRS reserves used here for other reserve components. Select the association’s legal form on Budget. That selection identifies the organization; it does not determine which Florida reserve, budget, approval, or disclosure requirements apply. Confirm requirements under current law, the governing documents, and the applicable reserve study. This workbook is a recordkeeping aid, not a legal or accounting opinion.
19
20
Project Register has 200 entry rows (8–207). All its rows are height 20 except the title row. The report tabs provide the summaries, so no summary table is repeated on Project Register.
21
22
This is a blank template. Enter the fiscal year, budget, projects, and reporting-date actuals; no project examples or prior-year balances are carried into it.
23
24
Yellow cells are editable; green cells calculate. Select Fund, Project Type, Status, Include in report, and Report Category from the dropdowns. Select Yes to include the project in the linked expenditure and commitment reports.
25
26
Actual FY expenditures must cover the same reporting date as Financial Report. Enter 0 for a project with no expenditure, and leave unknown amounts blank. Missing actuals show Incomplete once a reporting date is entered.
27
28
Approved but unspent equals MAX(0, approved FY amount minus actual FY expenditures). Proposed projects have zero approved commitments. Missing limits, actuals, or uncertain status show Incomplete. Record release of unused authorizations before removing them.
29
30
For carried-over projects, enter the authorization available at the year opening plus new FY approvals and only this year’s expenditures. Record prior-year payments, cash transfers, and accounting scope in Notes to avoid double-counting.
31
32
Formula cells calculate automatically; yellow cells identify user inputs and green cells identify formulas. The Project Register includes 200 entry rows (8–207). To add rows, extend the table, formulas, dropdowns, and report ranges, then verify the added rows.
33
34
35
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