Budget
Download or load a spreadsheet, or build salary lines from hours and rates. Those wages become the annual amount on the matching trial-balance account.
No spreadsheet has been loaded yet. The blank template lists every support and expense account. Fill it in and load it back to replace a budget or start a new one.
Annual amounts for FY2027 are paced across fy2027 year to date. A favorable variance is more support than pace, or less spending than pace. Open the variance analysis · Five-year forecast.
Salary schedule
Hours times rate becomes wages. Lines under one trial-balance account add to that account's annual budget. Expand an account to edit the roles; compress it to keep only the total. With focus on an account, Right expands and Left collapses. E or = expands all, C or − collapses all, unless you are typing in a field.
Wages $0.00
Financial position
Year-end planned balances. Statements pace these from the opening balance so a September report is compared to 25% of a July fiscal year, not the full year-end target.
| Account | Year-end budget |
|---|---|
| 1000 Checking — Harbor Community BankAssets | |
| 1010 Savings — reserve & endowmentAssets | |
| 1100 Pledges receivableAssets | |
| 1200 Grants receivableAssets | |
| 1500 Equipment, netAssets | |
| 2000 Accounts payableLiabilities | |
| 2100 Accrued payrollLiabilities | |
| 2200 Refundable advancesLiabilities | |
| 3000 Net assets without donor restrictionsNet assets | |
| 3100 Net assets with donor restrictions — purposeNet assets | |
| 3200 Net assets with donor restrictions — perpetualNet assets |
Support & revenue
| Account | Annual | Pace | Actual | Variance |
|---|---|---|---|---|
| 4000 Contributions — individuals | $4,438.36 | $1,950.00 | ($2,488.36) | |
| 4010 Contributions — foundations | $9,863.01 | $15,000.00 | $5,136.99 | |
| 4020 Contributions — corporations | $4,931.51 | $10,000.00 | $5,068.49 | |
| 4030 Contributions — congregations | $1,232.88 | $0.00 | ($1,232.88) | |
| 4100 Grants & contracts | $34,520.55 | $63,500.00 | $28,979.45 | |
| 4200 Program service fees | $4,931.51 | $5,540.00 | $608.49 | |
| 4300 In-kind contributions | $3,452.05 | $3,400.00 | ($52.05) | |
| 4400 Investment income | $616.44 | $620.00 | $3.56 |
Expenses
| Account | Annual | Pace | Actual | Variance |
|---|---|---|---|---|
| 6000 Salaries — programFrom the salary schedule | $230,000.00 | $56,712.33 | $56,100.00 | $612.33 |
| 6010 Salaries — managementFrom the salary schedule | $50,000.00 | $12,328.77 | $11,400.00 | $928.77 |
| 6020 Salaries — fundraisingFrom the salary schedule | $28,000.00 | $6,904.11 | $6,600.00 | $304.11 |
| 6100 Program supplies & food | $5,917.81 | $4,100.00 | $1,817.81 | |
| 6200 Client assistance | $4,438.36 | $3,400.00 | $1,038.36 | |
| 6300 Occupancy & utilities | $12,821.92 | $13,212.00 | ($390.08) | |
| 6400 Office & administration | $1,479.45 | $826.00 | $653.45 | |
| 6500 Printing & postage | $1,109.59 | $890.00 | $219.59 | |
| 6600 Professional fees | $2,958.90 | $1,800.00 | $1,158.90 | |
| 6700 Scholarships & stipends | $4,438.36 | $4,500.00 | ($61.64) | |
| 6800 Insurance | $1,232.88 | $1,180.00 | $52.88 | |
| 6900 In-kind goods distributed | $3,452.05 | $3,400.00 | $52.05 | |
| 6910 Technology | $739.73 | $210.00 | $529.73 |