BAS Case Study - March 2023
SUN NY STATE BANK
INCOME AND EXPENSE REPORT CONDENSED
PAGE 2
CURRENT MONTH ---------------------------------- ---
YEAR TO DATE ------------------------------------
LAST YEAR --------------------------
ACCOUNT NUMBER DESCRIPTION 90456000 CASH ADVANCE FEE INCOME 90458000 CREDIT LIFE INSURANCE INCOME 90467100 ATM INTERCHANGE INCOME 90467200 ATM TERMINAL SURCHARGE INCOME 90467300 ATM SERVICE FEES 90476000 LIFE INSURANCE INCOME 90480000 OTHER NONINTEREST INCOME 90480500 GIFT CARD INCOME
CURRENT
BUDGET
$ VAR
CURRENT
BUDGET
$ VAR
ACTUAL
$ VAR
62.25 0.00
86
24-
576.01
1,032
456-
617.22
41-
0
0
0.00
0
0
1.98
2-
9,605.65 2,596.00 1,821.40 3,395.48 852.68 185.00
10,823 2,676 1,813 3,401 1,262
1,217-
128,070.94 33,278.00 22,292.84 40,117.70 10,148.10 263.00 9,219.26 4,510.56 17,679.70 276,437.66 2.00
129,843 32,145 21,789 40,000 15,243 25,000 2,399 24,000 28,925 331,719 600
1,772- 1,133
122,051.92 32,456.00 22,609.09 40,092.83 14,057.62 23,126.12 38,588.02 20,687.25 325,010.52 345.00 0.00
6,019
80-
822 316-
8
504 118
6-
25
409- 135
5,095-
3,910-
50
337-
82-
90488000 OREO GAINS 90490000 SECURITY GAINS 90494000 LOAN SALE GAINS
0.00 0.00 0.00
2,087
2,087-
15,781- 2,397- 19,489- 11,245- 55,281-
13,907- 38,586- 4,511 3,008-
199
199-
2,750 2,415 28,847
2,750-
90495000 MORTGAGE SERVICING INCOME
1,558.67 22,917.31
856-
OTHER NON-INTEREST INCOME
5,930-
48,573
TOTAL NON-INTEREST INCOME
38,188.05
41,546
3,358-
425,967.80
484,096
58,128-
465,256.13
39,288
TOTAL INCOME
310,598.09
339,208 28,610-
3,489,722.75
3,747,178
257,455-
3,568,279.47
78,557
EXPENSE 90510000 INTEREST EXPENSE-NOW 90510500 INTEREST EXPENSE-CLUB
8,927.35 2,576.23 11,503.58
4,872 2,411 7,283 1,394 3,520 4,189 3,924 1,684 1,273 1,710 6,217 24,638 403 324
4,055
111,901.82 28,442.80 140,344.62 1,837.54 8,595.65 39,700.14 70,117.04 19,826.81 19,688.74 19,424.52 18,235.17 53,939.55 251,365.16 391,709.78 382,532.54 472,992.46 267,479.15 128,970.24 1,251,974.39 0.00
57,342 28,379 85,721 4,729 16,446 41,470 49,323 46,168 19,769 3,832 15,000 20,130 62,459 279,326 365,047 362,391 562,257 355,570 129,369
54,560
54,611.44 27,026.89 81,638.33 4,503.40 15,662.31 39,496.17 46,974.32 43,969.14 18,827.69 3,649.93 4,618.74 64,067.74 241,803.05 323,441.38 398,136.04 544,903.57 374,902.73 135,780.47 1,453,722.81 33.61
57,290 1,416 58,706 2,666- 7,067- 23,143 24,142- 204
165
64
INTEREST ON TRANSACTION ACCO
4,221
54,624 2,891- 7,850- 1,770- 20,794 26,341- 3,832- 4,425 1,895- 8,519- 27,961- 26,663 20,142 89,265- 88,091- 80-
90511000 INTEREST EXPENSE-MONEY MARKET 90513500 INTEREST EXP - PREMIER MM SAV 90514000 INTEREST EXPENSE-SAVINGS 90516000 INTEREST EXP - CD'S <= 250K 90516100 INTEREST EXP - CD > 250K 90516500 INTEREST EXP - IRA <= 250K 90516600 INTEREST EXP - IRA > 250K 90520500 INTEREST EXP - FED FUNDS PRCH 90525000 INTEREST EXP - OVERNIGHT BRWG 90527000 INTEREST EXP - FHLB ADVANCE
270.82 620.06
132- 774- 374-
3,145.67 5,677.23 1,704.13 1,546.94
1,488 2,220-
137- 324-
861
0.00
3,650-
3,766.36
2,493 1,710- 1,300- 2,990-
14,806 18,202 10,128
0.00
4,916.60 21,647.81 33,151.39 46,026.00 43,417.00 61,696.36- 10,579.88 38,326.52
INTEREST ON NONTRANSACTION ACC
9,562
INTEREST EXPENSES
31,921
1,230
68,268 15,604- 71,911- 107,424- 6,810- 201,748-
90530000 OFFICER & ADMIN SALARIES 90531000 EMPLOYEE SALARIES
30,202 15,824
46,841
3,424-
90532000 BENEFITS
29,618 91,314-
90534000 DEFERRED COMPENSATION EXPENSE
10,529
51
399-
SALARIES-EMPLOYEE BENEFITS
117,190 78,863-
1,409,587
157,613-
Made with FlippingBook Online newsletter creator