Light Center, Final Project 6 $799,399.76 38,608.44 0,791.32 Accounting Services lab caps lock shift 4 5...

Transcribed Image Text:

Light Center, Final Project 6 $799,399.76 38,608.44 0,791.32 Accounting Services lab caps lock shift 4 5 Q W E R A S D F N 36 m control option command T Y 0 C V B Trans. 54 JJ The bank statement has arrived. Record the service charges in the cash payments journal and the interest in the cash receipts journal. Complete a bank reconciliation for Bright Ideas Light Center as of the date the statement is received. See page 74. You can assume that all of the November deposits and checks have cleared. Refer to Lesson 14 for the steps to reconcile an account. Also, make the appropriate adjustments to the checkbook. First Steamboat Bank Statement from November 15, 20XX to December 15, 20XX H Beginning Balance $18,525.88 Plus 27 Deposits 84,116.12 Minus 45 Withdrawals 73,434.80 Ending Balance 29,207.20 Deposits Date Amount 11-16 $3,448.82 Commercial deposit 11-18 2,894.65 Commercial deposit 11-19 3,764.14 Commercial deposit 11-20 3,021.63 Commercial deposit 11-21 3,789.55 Commercial deposit 11-22 3,644.16 Commercial deposit 11-23 2,457.58 Commercial deposit 11-25 3,384.86 Commercial deposit 11-26 2,336.65 Commercial deposit 11-27 4,533.72 Commercial deposit 11-28 3,006.39 Commercial deposit 11-29 3,283.76 Commercial deposit 11-30 2,213.35 Commercial deposit Description Date Amount 12-1 2,113.53 12-2 4,283.67 12-3 3,036.93 12-4 3,345.72 12-5 3,236.56 12-6 3,348.68 12-8 2,547.85 12-9 3,446.61 12-10 3,897.55 12-11 3,012.36 12-12 3,674.41 12-13 2,984.56 Description 12-15 3,382.49 Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit 14 Other deposits 12-15 $25.94 Interest 0201801QZ01A-53 fab caps lock shift #3 02 Q W A N SA $ 4 BES % 5 E R S D F 36 control option command Bright Ideas Light Center, Final Project T 6 G C V E Checks Date 11-15 Amount $11,917.53 Check Number Date Amount Check Number 256 11-30 22.80 279 11-16 532.50 259* 11-30 3,665.61 280 11-17 668.42 257 12-2 2,800.53 281 11-17 4,085.00 258 12-2 568.42 282 11-17 50.50 260 12-4 128.98 287* 11-18 1,571.75 263* 12-4 5,085.00 283 11-18 120.00 264* 12-4 352.50 284 11-19 289.42 261 12-5 289.89 286+ 11-19 130.22 262 12-5 1,971.75 288 11-19 352.92 265 12-7 120.00 289 11-20 82.92 266 12-7 389.95 290 11-21 1,208.43 270* 12-8 4,856.76 292+ 11-21 5,003.42 267 12-8 56.99 293 11-22 56.99 268 12-11 282.42 296* 11-22 203.42 269 12-11 189.99 294 11-23 302.56 271 12-12 1,008.42 295 11-23 256.55 272 12-12 254.55 297 11-23 64.82 276 12-12 2,794.96 299+ 11-24 2,840.24 273 12-13 2,128.53 300 11-24 2,242.62 274 12-15 11,813.10 302+ 11-25 852.59 275 11-28 380.87 277 11-29 662.40 278 + Denotes break in sequence * Denotes break in order Service charge summary 12-15 $752.56 Credit card processing fee 12-15 25.00 Monthly bank service charge 0201801QZ01A-53 15 Accounting Services Bank Reconciliation Ending Bank Amount Balance: Outstanding Deposits: Total Deposits Outstanding Checks: shift First Steamboat Bank Bank Reconciliation Amount Date Amount Z C V B 96 alt control option Ending Checkbook Balance: Check number Add interest: command Total Checks Adjusted Bank Balance: Less Bank Service Charges Adjusted Checkbook Balance: 74 I 0201801QZ01A-53 Light Center, Final Project 6 $799,399.76 38,608.44 0,791.32 Accounting Services lab caps lock shift 4 5 Q W E R A S D F N 36 m control option command T Y 0 C V B Trans. 54 JJ The bank statement has arrived. Record the service charges in the cash payments journal and the interest in the cash receipts journal. Complete a bank reconciliation for Bright Ideas Light Center as of the date the statement is received. See page 74. You can assume that all of the November deposits and checks have cleared. Refer to Lesson 14 for the steps to reconcile an account. Also, make the appropriate adjustments to the checkbook. First Steamboat Bank Statement from November 15, 20XX to December 15, 20XX H Beginning Balance $18,525.88 Plus 27 Deposits 84,116.12 Minus 45 Withdrawals 73,434.80 Ending Balance 29,207.20 Deposits Date Amount 11-16 $3,448.82 Commercial deposit 11-18 2,894.65 Commercial deposit 11-19 3,764.14 Commercial deposit 11-20 3,021.63 Commercial deposit 11-21 3,789.55 Commercial deposit 11-22 3,644.16 Commercial deposit 11-23 2,457.58 Commercial deposit 11-25 3,384.86 Commercial deposit 11-26 2,336.65 Commercial deposit 11-27 4,533.72 Commercial deposit 11-28 3,006.39 Commercial deposit 11-29 3,283.76 Commercial deposit 11-30 2,213.35 Commercial deposit Description Date Amount 12-1 2,113.53 12-2 4,283.67 12-3 3,036.93 12-4 3,345.72 12-5 3,236.56 12-6 3,348.68 12-8 2,547.85 12-9 3,446.61 12-10 3,897.55 12-11 3,012.36 12-12 3,674.41 12-13 2,984.56 Description 12-15 3,382.49 Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit Commercial deposit 14 Other deposits 12-15 $25.94 Interest 0201801QZ01A-53 fab caps lock shift #3 02 Q W A N SA $ 4 BES % 5 E R S D F 36 control option command Bright Ideas Light Center, Final Project T 6 G C V E Checks Date 11-15 Amount $11,917.53 Check Number Date Amount Check Number 256 11-30 22.80 279 11-16 532.50 259* 11-30 3,665.61 280 11-17 668.42 257 12-2 2,800.53 281 11-17 4,085.00 258 12-2 568.42 282 11-17 50.50 260 12-4 128.98 287* 11-18 1,571.75 263* 12-4 5,085.00 283 11-18 120.00 264* 12-4 352.50 284 11-19 289.42 261 12-5 289.89 286+ 11-19 130.22 262 12-5 1,971.75 288 11-19 352.92 265 12-7 120.00 289 11-20 82.92 266 12-7 389.95 290 11-21 1,208.43 270* 12-8 4,856.76 292+ 11-21 5,003.42 267 12-8 56.99 293 11-22 56.99 268 12-11 282.42 296* 11-22 203.42 269 12-11 189.99 294 11-23 302.56 271 12-12 1,008.42 295 11-23 256.55 272 12-12 254.55 297 11-23 64.82 276 12-12 2,794.96 299+ 11-24 2,840.24 273 12-13 2,128.53 300 11-24 2,242.62 274 12-15 11,813.10 302+ 11-25 852.59 275 11-28 380.87 277 11-29 662.40 278 + Denotes break in sequence * Denotes break in order Service charge summary 12-15 $752.56 Credit card processing fee 12-15 25.00 Monthly bank service charge 0201801QZ01A-53 15 Accounting Services Bank Reconciliation Ending Bank Amount Balance: Outstanding Deposits: Total Deposits Outstanding Checks: shift First Steamboat Bank Bank Reconciliation Amount Date Amount Z C V B 96 alt control option Ending Checkbook Balance: Check number Add interest: command Total Checks Adjusted Bank Balance: Less Bank Service Charges Adjusted Checkbook Balance: 74 I 0201801QZ01A-53