Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The president of The Parkview Company suspects the bookkeeper is embezzling cash from the company. She asks you, confidentially, to look over the bank reconciliation

The president of The Parkview Company suspects the bookkeeper is embezzling cash from the company. She asks you, confidentially, to look over the bank reconciliation that the bookkeeper has prepared to see if you discover any discrepancies between the books and the bank statement. She provides you with the Cash account from the general ledger, the bank statement, and the bank reconciliation as of December 31. Data table Bal 12/1 Bank Statement for December 31 Deposits Dec 1 $ 3,750 $ 1,277 8 1,400 16 4,170 24 2,325 Interest 31 8 58 EFT 31 Total deposits 9,238 Checks and other debits: No. 1880 555 No. 1882 125 No. 1883 465 No. 1884 1,283 No. 1885 1,344 No. 1886 700 No. 1887 2,435 No. 1888. 1,022 No. 1889 420 NSF 145 720 EFT Bal 12/31 Total checks and other debits Explanations: EFT-electronic funds transfer, NSF-nonsufficient funds (9,214) $ 3,774 Print Done - Data table Parkview Company Bank Reconciliation December 31 Bank Balance, 12/31 $ 3,774 Balance, 12/31 Books $ 10,574 Add: Add: Deposits in transit 3,190 Subtotal 6,964 EFT receipt from customer Interest revenue Less: Subtotal 58 8 10,640 Outstanding checks Less: No. 1560 189 Book error 4,000 No. 1901 832 NSF check 145 168 (1,189) No. 1902 EFT payment of utilities 720 (4,865) $ Adjusted bank balance 5,775 5,775 Adjusted book balance Print Done Data table General Ledger Cash Bal 12/1 6,193 Cash receipt 12/7 1,400 Cash receipt 12/15 4,170 Cash receipt 12/23 6,325 Cash receipt 12/30 690 No. 1884 1,283 No. 1885 1,344 No. 1886 700 No. 1887 2,435 No. 1888 1,022 No. 1889 420 No. 1901 832 No. 1902 168 Bal 12/31 10,574 Print Done More info You learn from the November bank reconciliation that the following checks were outstanding on November 30: No. 1560 for $189, No. 1880 for $555, No. 1882 for $125, and No. 1883 for $465. There was one deposit in transit on November 30 for $1,277. An examination of the actual deposit slips revealed no bank errors. Assume the cash deposit of $2,325 on December 24 is the correct amount. The January bank statement showed that a $690 deposit cleared the bank on January 2. Print Done First prepare the corrected bank reconciliation. (Include the balances at December 31 in each of the addition subtotal calculations. If an input field is not used in the table, leave the field empty; do not select a label or enter a zero. Abbreviations used: EFT = electronic funds transfer; NSF = non-sufficient funds) Parkview Company Bank Reconciliation (Corrected) Bank Balance, 12/31 Add: December 31 Books Balance, 12/31 Add: Subtotal Less: Subtotal Less: Adjusted bank balance Adjusted book balance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting 111

Authors: Carl S. Warren

1st Edition

1111065624, 978-1111065621

More Books

Students also viewed these Accounting questions