-
Requirement 1. Prepare the
DunlapDunlap
Automotive bank reconciliation at
MarchMarch
3131?,
20162016.
Prepare the Bank side of the bank? reconciliation, then prepare
the Book side of the bank reconciliation. ?(Include the balances
at
MarchMarch
3131
in each of the addition subtotal calculations. If a box is not
used in the? table, leave the box? empty; do not select a label or
enter a? zero.)
Dunlap Automotive
Bank Reconciliation
March 31, 2016
Bank:
Add:
Subtotal
Less:
Check No.
Books:
Add:
Subtotal...
-
excel format
Learning Objective 6 P8-33B Preparing a bank reconciliation and journal entries The May cash records of Donald Insurance follow: 1. Adjusted Balance $17,580 Cash Payments Check No. Cash Credit 1416 $ 890 Cash Receipts Date Cash Debit May 4 $ 4,230 520 530 1,950 1,840 1417 120 1418 1419 1420 1421 1422 630 1,090 1,420 900 670 Donald's Cash account shows a balance of $17,750 at May 31. On May 31, Donald Insurance received the following bank statement:...
-
Internal Cod Learning Objective PS-27A Preparing a bank reconciliation and journal entries The Decembarcach w Duben ce for 1. Adjusted Balance $18.00 Cash Receipts Cash Payments Date Cash Debit Check No Cash Credit Dec 4 $4200 $310 500 1418 1.900 1419 1420 Davidson Cash account shows a balance of $17,450 at December 31. On December 31. Davidson Insurance received the following bank stanement $ 14,100 Bank Statement for December Beginning Balance Deposits and other Credits De 1 EFT 350 Der...
-
Please explain your answer. Thank you!
Learning Objective 6 P7-27A Preparing a bank reconciliation and journal entries The December cash records of Davidson Insurance follow: 1. Adjusted Balance $18,025 Cash Receipts Cash Payments Check No Cash Credit Date Dec. 4 9 Cash Debit $ 4,240 550 $ 810 1416 1417 180 600 1418 630 17 1419 1,900 1,860 1420 1,390 1,490 700 1421 1422 600 Davidson's Cash account shows a balance of $17,450 at December 31. On December 31, Davidson...
-
P8-27A Preparing a bank reconciliation and journal entries The December cash records of Davidson Insurance follow Davidson's Cash account shows a balance of $17,450 at December 31. On December 31, Davidson Insurance received the following bank statement: Explanations: BC-bank collection; EFT-electronic funds transfer; NSF-nonsufficient funds checks; SC-service charge Additional data for the bank reconciliation follow: a. The EFT credit was a receipt of rent. The EFT debit was an insurance payment. b. The NSF check was received from a customer. c. The $1,400 bank collection was for a...
-
P7-27A Preparing a bank reconciliation and journal entries The December cash records of Davidson Insurance for Learning Objective 1. Adved Balance 5 Cash Receipts Date Cash Debit Dec 4 $4,240 Cash Payments Check No. $ 810 1417 Cash Credit 1416 630 1.900 1,860 1418 1419 1420 1421 1422 1,390 1,490 700 600 Davidson's Cash account shows a balance of $17.450 at December 31. On December 31. Davidson Insurance received the following bank statement NSF PIZ $ 14,100 550 9.040 Bank...
-
Additional data for the bank reconciliation follow: (Click the icon to view the additional information.) The December cash records of Buffy Insurance follow: .: (Click the icon to view the checkbook.) Buffy's Cash account shows a balance of $17,040 at December 31. On December 31, Buffy Insurance received the following bank statement: E: (Click the icon to view the December bank statement.) Read the requirements. Requirement 1. Prepare the bank reconciliation of Buffy Insurance at December 31, 2018 Data Table...
-
Additional data for the bank reconciliation follow (Click the icon to view the additional information.) The December cash records of Devin Insurance follow: (Click the icon to view the checkbook.) Devin's Cash account shows a balance of $17,440 at December 31. On December 31, Devin Insurance received the following bank statement: (Click the icon to view the December bank statement.) Read the requirements. Requirement 1. Prepare the bank reconciliation of Devin Insurance at December 31, 2018. Prepare the bank portion...
-
Requirements Prepare the bank reconciliation for Wilderness Associates at October 31, 2018. a. Format appropriate cells with dollar signs, underlines, and double underlines. Use Excel formulas to calculate subtotals and totals. b. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values to be subtracted. 2 Journalize the entries based on the bank reconciliation a. For dollar amounts, use cell references on bank reconciliation b. Enter all amounts as positive values. Do not...
-
Problem 4-3A Prepare the bank reconciliation and record cash
adjustments (LO4-5)
[The following information applies to the questions displayed
below.]
The cash records and bank statement for the month of May for
Diaz Entertainment are shown below.
Cash Account Records May 1, 2021, to May 31, 2021 Cash Balance May 31, 2021 $5,340 Cash Balance Cash May 1, 2021 + Receipts $5,400 $11,440 Cash Receipts Date Desc. 5/3 Sales 5/10 Sales 5/17 Sales 5/24 Sales 5/31 Sales Amount $ 1,340...
excel format
Learning Objective 6 P8-33B Preparing a bank reconciliation and journal entries The May cash records of Donald Insurance follow: 1. Adjusted Balance $17,580 Cash Payments Check No. Cash Credit 1416 $ 890 Cash Receipts Date Cash Debit May 4 $ 4,230 520 530 1,950 1,840 1417 120 1418 1419 1420 1421 1422 630 1,090 1,420 900 670 Donald's Cash account shows a balance of $17,750 at May 31. On May 31, Donald Insurance received the following bank statement:...
Internal Cod Learning Objective PS-27A Preparing a bank reconciliation and journal entries The Decembarcach w Duben ce for 1. Adjusted Balance $18.00 Cash Receipts Cash Payments Date Cash Debit Check No Cash Credit Dec 4 $4200 $310 500 1418 1.900 1419 1420 Davidson Cash account shows a balance of $17,450 at December 31. On December 31. Davidson Insurance received the following bank stanement $ 14,100 Bank Statement for December Beginning Balance Deposits and other Credits De 1 EFT 350 Der...
Please explain your answer. Thank you!
Learning Objective 6 P7-27A Preparing a bank reconciliation and journal entries The December cash records of Davidson Insurance follow: 1. Adjusted Balance $18,025 Cash Receipts Cash Payments Check No Cash Credit Date Dec. 4 9 Cash Debit $ 4,240 550 $ 810 1416 1417 180 600 1418 630 17 1419 1,900 1,860 1420 1,390 1,490 700 1421 1422 600 Davidson's Cash account shows a balance of $17,450 at December 31. On December 31, Davidson...
P7-27A Preparing a bank reconciliation and journal entries The December cash records of Davidson Insurance for Learning Objective 1. Adved Balance 5 Cash Receipts Date Cash Debit Dec 4 $4,240 Cash Payments Check No. $ 810 1417 Cash Credit 1416 630 1.900 1,860 1418 1419 1420 1421 1422 1,390 1,490 700 600 Davidson's Cash account shows a balance of $17.450 at December 31. On December 31. Davidson Insurance received the following bank statement NSF PIZ $ 14,100 550 9.040 Bank...
Additional data for the bank reconciliation follow: (Click the icon to view the additional information.) The December cash records of Buffy Insurance follow: .: (Click the icon to view the checkbook.) Buffy's Cash account shows a balance of $17,040 at December 31. On December 31, Buffy Insurance received the following bank statement: E: (Click the icon to view the December bank statement.) Read the requirements. Requirement 1. Prepare the bank reconciliation of Buffy Insurance at December 31, 2018 Data Table...
Additional data for the bank reconciliation follow (Click the icon to view the additional information.) The December cash records of Devin Insurance follow: (Click the icon to view the checkbook.) Devin's Cash account shows a balance of $17,440 at December 31. On December 31, Devin Insurance received the following bank statement: (Click the icon to view the December bank statement.) Read the requirements. Requirement 1. Prepare the bank reconciliation of Devin Insurance at December 31, 2018. Prepare the bank portion...
Requirements Prepare the bank reconciliation for Wilderness Associates at October 31, 2018. a. Format appropriate cells with dollar signs, underlines, and double underlines. Use Excel formulas to calculate subtotals and totals. b. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values to be subtracted. 2 Journalize the entries based on the bank reconciliation a. For dollar amounts, use cell references on bank reconciliation b. Enter all amounts as positive values. Do not...
Problem 4-3A Prepare the bank reconciliation and record cash
adjustments (LO4-5)
[The following information applies to the questions displayed
below.]
The cash records and bank statement for the month of May for
Diaz Entertainment are shown below.
Cash Account Records May 1, 2021, to May 31, 2021 Cash Balance May 31, 2021 $5,340 Cash Balance Cash May 1, 2021 + Receipts $5,400 $11,440 Cash Receipts Date Desc. 5/3 Sales 5/10 Sales 5/17 Sales 5/24 Sales 5/31 Sales Amount $ 1,340...