Sheets
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Item | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | Average | Low | High | Plan | Used | Share |
| 2 | Income | |||||||||||||||||||
| 3 | Salary | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $4,400 | $51,600 | $4,300 | $4,200 | $4,400 | $51,600 | 100% | |
| 4 | Freelance | $600 | $0 | $850 | $400 | $0 | $1,200 | $300 | $0 | $950 | $500 | $700 | $1,100 | $6,600 | $550 | $0 | $1,200 | $6,000 | 110% | |
| 5 | Interest | $12 | $12 | $13 | $13 | $14 | $14 | $15 | $15 | $16 | $16 | $17 | $18 | $175 | $15 | $12 | $18 | $160 | 109% | |
| 6 | Refunds | $0 | $0 | $0 | $640 | $0 | $0 | $0 | $0 | $0 | $0 | $85 | $0 | $725 | $60 | $0 | $640 | $500 | 145% | |
| 7 | Total income | $4,812 | $4,212 | $5,063 | $5,253 | $4,214 | $5,414 | $4,715 | $4,415 | $5,366 | $4,916 | $5,202 | $5,518 | $59,100 | $4,925 | $58,260 | 101% | |||
| 8 | ||||||||||||||||||||
| 9 | Housing | |||||||||||||||||||
| 10 | Rent | $1,650 | $1,650 | $1,650 | $1,650 | $1,650 | $1,650 | $1,650 | $1,650 | $1,650 | $1,650 | $1,650 | $1,650 | $19,800 | $1,650 | $1,650 | $1,650 | $19,800 | 100% | |
| 11 | Renters insurance | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $216 | $18 | $18 | $18 | $220 | 98% | |
| 12 | Repairs | $0 | $120 | $0 | $0 | $45 | $0 | $0 | $210 | $0 | $0 | $0 | $60 | $435 | $36 | $0 | $210 | $500 | 87% | |
| 13 | Furniture | $0 | $0 | $340 | $0 | $0 | $0 | $0 | $0 | $0 | $180 | $0 | $0 | $520 | $43 | $0 | $340 | $600 | 87% | |
| 14 | Cleaning supplies | $22 | $18 | $25 | $20 | $19 | $24 | $21 | $18 | $23 | $20 | $26 | $30 | $266 | $22 | $18 | $30 | $260 | 102% | |
| 15 | Total housing | $1,690 | $1,806 | $2,033 | $1,688 | $1,732 | $1,692 | $1,689 | $1,896 | $1,691 | $1,868 | $1,694 | $1,758 | $21,237 | $1,770 | $21,380 | 99% | 50% | ||
| 16 | ||||||||||||||||||||
| 17 | Utilities | |||||||||||||||||||
| 18 | Electricity | $96 | $88 | $74 | $61 | $55 | $68 | $92 | $95 | $70 | $62 | $79 | $98 | $938 | $78 | $55 | $98 | $950 | 99% | |
| 19 | Gas | $118 | $104 | $86 | $52 | $31 | $22 | $20 | $21 | $34 | $66 | $95 | $121 | $770 | $64 | $20 | $121 | $750 | 103% | |
| 20 | Water | $38 | $38 | $39 | $41 | $44 | $52 | $58 | $57 | $46 | $40 | $38 | $38 | $529 | $44 | $38 | $58 | $520 | 102% | |
| 21 | Internet | $60 | $60 | $60 | $60 | $60 | $60 | $60 | $60 | $60 | $60 | $60 | $60 | $720 | $60 | $60 | $60 | $720 | 100% | |
| 22 | Phone | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $52 | $52 | $52 | $561 | $47 | $45 | $52 | $560 | 100% | |
| 23 | Total utilities | $357 | $335 | $304 | $259 | $235 | $247 | $275 | $278 | $255 | $280 | $324 | $369 | $3,518 | $293 | $3,500 | 101% | 8% | ||
| 24 | ||||||||||||||||||||
| 25 | Food | |||||||||||||||||||
| 26 | Groceries | $410 | $385 | $420 | $395 | $430 | $405 | $440 | $425 | $398 | $415 | $432 | $470 | $5,025 | $419 | $385 | $470 | $5,000 | 101% | |
| 27 | Farmers market | $0 | $0 | $0 | $35 | $60 | $85 | $95 | $90 | $70 | $40 | $0 | $0 | $475 | $40 | $0 | $95 | $450 | 106% | |
| 28 | Restaurants | $140 | $95 | $160 | $120 | $180 | $210 | $240 | $195 | $150 | $130 | $170 | $260 | $2,050 | $171 | $95 | $260 | $2,000 | 103% | |
| 29 | Coffee | $38 | $34 | $40 | $36 | $33 | $30 | $28 | $31 | $37 | $39 | $41 | $44 | $431 | $36 | $28 | $44 | $420 | 103% | |
| 30 | Lunches | $110 | $120 | $115 | $105 | $118 | $98 | $80 | $85 | $112 | $120 | $116 | $95 | $1,274 | $106 | $80 | $120 | $1,300 | 98% | |
| 31 | Total food | $698 | $634 | $735 | $691 | $821 | $828 | $883 | $826 | $767 | $744 | $759 | $869 | $9,255 | $771 | $9,170 | 101% | 22% | ||
| 32 | ||||||||||||||||||||
| 33 | Transport | |||||||||||||||||||
| 34 | Transit pass | $99 | $99 | $99 | $99 | $99 | $99 | $99 | $99 | $99 | $99 | $99 | $99 | $1,188 | $99 | $99 | $99 | $1,200 | 99% | |
| 35 | Bike repairs | $0 | $0 | $45 | $0 | $80 | $0 | $0 | $25 | $0 | $0 | $60 | $0 | $210 | $18 | $0 | $80 | $250 | 84% | |
| 36 | Taxis | $42 | $30 | $18 | $25 | $12 | $20 | $35 | $15 | $22 | $38 | $45 | $60 | $362 | $30 | $12 | $60 | $300 | 121% | |
| 37 | Train tickets | $0 | $85 | $0 | $0 | $140 | $0 | $260 | $0 | $0 | $95 | $0 | $180 | $760 | $63 | $0 | $260 | $800 | 95% | |
| 38 | Car share | $0 | $0 | $55 | $0 | $0 | $90 | $120 | $75 | $0 | $0 | $0 | $40 | $380 | $32 | $0 | $120 | $400 | 95% | |
| 39 | Total transport | $141 | $214 | $217 | $124 | $331 | $209 | $514 | $214 | $121 | $232 | $204 | $379 | $2,900 | $242 | $2,950 | 98% | 7% | ||
| 40 | ||||||||||||||||||||
| 41 | Health | |||||||||||||||||||
| 42 | Gym | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $540 | $45 | $45 | $45 | $540 | 100% | |
| 43 | Pharmacy | $24 | $31 | $18 | $12 | $15 | $9 | $14 | $11 | $20 | $26 | $33 | $28 | $241 | $20 | $9 | $33 | $240 | 100% | |
| 44 | Dentist | $0 | $0 | $120 | $0 | $0 | $0 | $0 | $0 | $0 | $120 | $0 | $0 | $240 | $20 | $0 | $120 | $250 | 96% | |
| 45 | Glasses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $310 | $0 | $0 | $0 | $310 | $26 | $0 | $310 | $300 | 103% | |
| 46 | Total health | $69 | $76 | $183 | $57 | $60 | $54 | $59 | $56 | $375 | $191 | $78 | $73 | $1,331 | $111 | $1,330 | 100% | 3% | ||
| 47 | ||||||||||||||||||||
| 48 | Leisure | |||||||||||||||||||
| 49 | Books | $32 | $18 | $45 | $22 | $27 | $15 | $40 | $36 | $24 | $30 | $19 | $64 | $372 | $31 | $15 | $64 | $350 | 106% | |
| 50 | Music | $11 | $11 | $11 | $11 | $11 | $11 | $11 | $11 | $11 | $11 | $11 | $11 | $132 | $11 | $11 | $11 | $132 | 100% | |
| 51 | Cinema | $24 | $12 | $30 | $18 | $12 | $36 | $24 | $30 | $12 | $18 | $24 | $36 | $276 | $23 | $12 | $36 | $260 | 106% | |
| 52 | Gifts | $0 | $45 | $0 | $30 | $60 | $0 | $0 | $25 | $0 | $40 | $90 | $320 | $610 | $51 | $0 | $320 | $600 | 102% | |
| 53 | Travel | $0 | $0 | $0 | $0 | $180 | $0 | $1,250 | $420 | $0 | $0 | $0 | $240 | $2,090 | $174 | $0 | $1,250 | $2,000 | 105% | |
| 54 | Hobbies | $35 | $20 | $60 | $28 | $15 | $40 | $22 | $30 | $55 | $18 | $26 | $45 | $394 | $33 | $15 | $60 | $400 | 99% | |
| 55 | Total leisure | $102 | $106 | $146 | $109 | $305 | $102 | $1,347 | $552 | $102 | $117 | $170 | $716 | $3,874 | $323 | $3,742 | 104% | 9% | ||
| 56 | ||||||||||||||||||||
| 57 | Total expenses | $3,057 | $3,171 | $3,618 | $2,928 | $3,484 | $3,132 | $4,767 | $3,822 | $3,311 | $3,432 | $3,229 | $4,164 | $42,115 | $3,510 | $42,072 | 100% | |||
| 58 | Net | $1,755 | $1,041 | $1,445 | $2,325 | $730 | $2,282 | -$52 | $593 | $2,055 | $1,484 | $1,973 | $1,354 | $16,985 | $1,415 | -$52 | $2,325 | |||
| 59 | Savings rate | 36% | 25% | 29% | 44% | 17% | 42% | -1% | 13% | 38% | 30% | 38% | 25% | 29% | ||||||
| 60 |
Budget: 775 numbers · sum 809584.48 · mean 1044.63 · sd 4846.93recalc: 0 of 333 formulas · 1 round · 43.5 ms