Kitty Wilkinson records her weekly cash flow for her business. The below are her records for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Kitty Wilkinson records her weekly cash flow for her business. The below are her records for the month of May 2023 May 1 May 2 May 5 May 6 May 7 May 8 May 10 May 15 May 16 May 19 May 23 May 25 May 29 May 30 Opening balances, overdrawn bank balance at the bank $11,890, Cash balance $2,300 Cash sales amounted to $25,690. Deposited cash in the bank, $25,000 Paid Purchases by cheque $10,470 Cashier with draws $2,000 cash from bank for business use. Owner withdraws cash from bank to pay his house rent $8,000. Debtor - M Kennedy paid with a cheque for $2,000 after he deducted a $500 cash discount to which he was entitled. Cash sales immediately deposited to the bank account $31.110. Payment to creditor -C Barry by cheque $9,900 in full settlement of amounts owing to him of $10,500. Purchases paid by the business' debit card $12,000. Cash sales $6,840 Wages paid in cash $5,400. Paid creditor- B Goode $3,400 by cheque Received $3,000, cheque from J Jacobs settling amounts owed Required: a) Record the above transactions in the Three Column Cash Book of Kitty Wilkinson. Balance the cash book and bring down the balances. On June 3, 2023, Kitty Wilkinson received a bank statement from the bank for the month of May which showed an overdrawn balance of $700, it was also noted that there was a debit balance of $3,450 in the cash book. This did not agree with the balance as per her bank statement; therefore, you as the part time accountant was asked to assist with the preparation of Kitty's bank reconciliation statement. After careful examination, the following discrepancies and omissions were discovered: i. ii. iii. Bank charges amounted to $1,500 were not recorded in the cash book Cheque received from M Kennedy on May 10 had been dishonoured. Amount deposited on May 30 from J Jacobs have not been included in the bank statement. iv. Standing orders for the utility bills of $2,800 had been paid by the bank, this has not yet been recorded in the cash book, v. Three of Kitty's customers chose to deposit directly to her bank account, these amounted to $1,750. vi. The cheque which was drawn in the amount of $3,400 for B Goode on May 29 was not among the cheques returned with the bank statement. There was also no record of it on the bank statement. Required: b) Update Kitty Wilkinson's cash book, starting with the closing balance in her cash book from the required above. e) Prepare Kitty Wilkinson's bank reconciliation statement for the month of May 2023 using appropriate headings. Kitty Wilkinson records her weekly cash flow for her business. The below are her records for the month of May 2023 May 1 May 2 May 5 May 6 May 7 May 8 May 10 May 15 May 16 May 19 May 23 May 25 May 29 May 30 Opening balances, overdrawn bank balance at the bank $11,890, Cash balance $2,300 Cash sales amounted to $25,690. Deposited cash in the bank, $25,000 Paid Purchases by cheque $10,470 Cashier with draws $2,000 cash from bank for business use. Owner withdraws cash from bank to pay his house rent $8,000. Debtor - M Kennedy paid with a cheque for $2,000 after he deducted a $500 cash discount to which he was entitled. Cash sales immediately deposited to the bank account $31.110. Payment to creditor -C Barry by cheque $9,900 in full settlement of amounts owing to him of $10,500. Purchases paid by the business' debit card $12,000. Cash sales $6,840 Wages paid in cash $5,400. Paid creditor- B Goode $3,400 by cheque Received $3,000, cheque from J Jacobs settling amounts owed Required: a) Record the above transactions in the Three Column Cash Book of Kitty Wilkinson. Balance the cash book and bring down the balances. On June 3, 2023, Kitty Wilkinson received a bank statement from the bank for the month of May which showed an overdrawn balance of $700, it was also noted that there was a debit balance of $3,450 in the cash book. This did not agree with the balance as per her bank statement; therefore, you as the part time accountant was asked to assist with the preparation of Kitty's bank reconciliation statement. After careful examination, the following discrepancies and omissions were discovered: Kitty Wilkinson records her weekly cash flow for her business. The below are her records for the month of May 2023 May 1 May 2 May 5 May 6 May 7 May 8 May 10 May 15 May 16 May 19 May 23 May 25 May 29 May 30 Opening balances, overdrawn bank balance at the bank $11,890, Cash balance $2,300 Cash sales amounted to $25,690. Deposited cash in the bank, $25,000 Paid Purchases by cheque $10,470 Cashier with draws $2,000 cash from bank for business use. Owner withdraws cash from bank to pay his house rent $8,000. Debtor - M Kennedy paid with a cheque for $2,000 after he deducted a $500 cash discount to which he was entitled. Cash sales immediately deposited to the bank account $31.110. Payment to creditor -C Barry by cheque $9,900 in full settlement of amounts owing to him of $10,500. Purchases paid by the business' debit card $12,000. Cash sales $6,840 Wages paid in cash $5,400. Paid creditor- B Goode $3,400 by cheque Received $3,000, cheque from J Jacobs settling amounts owed Required: a) Record the above transactions in the Three Column Cash Book of Kitty Wilkinson. Balance the cash book and bring down the balances. On June 3, 2023, Kitty Wilkinson received a bank statement from the bank for the month of May which showed an overdrawn balance of $700, it was also noted that there was a debit balance of $3,450 in the cash book. This did not agree with the balance as per her bank statement; therefore, you as the part time accountant was asked to assist with the preparation of Kitty's bank reconciliation statement. After careful examination, the following discrepancies and omissions were discovered: i. ii. iii. Bank charges amounted to $1,500 were not recorded in the cash book Cheque received from M Kennedy on May 10 had been dishonoured. Amount deposited on May 30 from J Jacobs have not been included in the bank statement. iv. Standing orders for the utility bills of $2,800 had been paid by the bank, this has not yet been recorded in the cash book, v. Three of Kitty's customers chose to deposit directly to her bank account, these amounted to $1,750. vi. The cheque which was drawn in the amount of $3,400 for B Goode on May 29 was not among the cheques returned with the bank statement. There was also no record of it on the bank statement. Required: b) Update Kitty Wilkinson's cash book, starting with the closing balance in her cash book from the required above. e) Prepare Kitty Wilkinson's bank reconciliation statement for the month of May 2023 using appropriate headings. i. ii. iii. Bank charges amounted to $1,500 were not recorded in the cash book Cheque received from M Kennedy on May 10 had been dishonoured. Amount deposited on May 30 from J Jacobs have not been included in the bank statement. iv. Standing orders for the utility bills of $2,800 had been paid by the bank, this has not yet been recorded in the cash book, v. Three of Kitty's customers chose to deposit directly to her bank account, these amounted to $1,750. vi. The cheque which was drawn in the amount of $3,400 for B Goode on May 29 was not among the cheques returned with the bank statement. There was also no record of it on the bank statement. Required: b) Update Kitty Wilkinson's cash book, starting with the closing balance in her cash book from the required above. e) Prepare Kitty Wilkinson's bank reconciliation statement for the month of May 2023 using appropriate headings.
Expert Answer:
Answer rating: 100% (QA)
Kitty Wilkinsons Three Column Cash Book May 2023 Date Description Debit Credit Balance May 1 Opening ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Sun Co.'s monthly sales and cost data for its operating activities of the past year follow. Management wants to use these data to predict future fixed and variable costs. (Dollar amounts are in...
-
Matching graphs with descriptions of cost and revenue behavior. Given here are a number of graphs. The horizontal axis represents the units produced over the year and the vertical axis represents...
-
All materials are introduced at the beginning of the process in Department One. The following information is available for the month of January for Department One: WIP, January 1 (conversion 40%...
-
In Problems 1158, perform the indicated operation, and write each expression in the standard form a + bi. 1-9 1 + i
-
Which of the following functions satisfies f(x + y) = f(x) + f(y) for all real numbers x and y? (a) f(t) = 2t (b) f(1) = t2 (c) f(t) = 2t + 1 (d) f(t) = - 3t
-
7-1 Match the following terms with the definitions below. a. Current market value b. Current market value method C. d. e. Discounted cash flow method Historical cost Historical cost method f. Net...
-
At most movie theaters, one employee is usually responsible for issuing tickets and collecting cash while another person collects those tickets when patrons enter the theater. What is the reason for...
-
As investment manager of Pasco Electric Companys pension plan (which is exempt from income taxes), you must choose between IBM bonds and AT&T preferred stock. The bonds have a $1,000 par value,...
-
Operations Management , I want you to define and discuss the importance of the three of following concepts related to, and elements of, formal reports. Those include: Work plans Time management...
-
Calculate the value of CP at 298 K and 1 atm pressure predicted for CH4(g) and C2H4(g) by the classical equipartition theorem. Compare the predicted results with the experimental results and...
-
Ques 2: Look at the diagram given below and calculate the critical path. Initiate the project (3d) Plan the project (7d) Create sign graphics/ text (3d) Create SM strategy (2d) Develop video concept...
-
and Exponent... HW2: Exponent expression your answer. (6xy-3)-3 x-7 y completely, a
-
Calculate the total stored energy for the device shown in the figure. Give your result in units of mJ 200 V 4F 15 F 12 uF
-
Functional and Dysfunctional effects of organizational culture: It creates a distinction between one organization and others. It conveys a particular identification for organization members. ...
-
Chris had the following data for the year 2020: Interest on bank deposit, BPI 20,000 Interest on FCDS, BDO 15,000 Interest on bank deposit, USA Bank 25,000 Share in the commercial partnership 30,000...
-
Determine the amplitude A, period T and mean value of the following functions, and sketch one cycle of their graph. a) f(x) = sin(2x) b) f(x) = 3 sin(2x) c) f(x) = 2 sin(x) - 1 (-) (7) d) f(x) = cos...
-
How do you spool a file in SQL*plus using a text file . After you have successfully gotten these commands to work and they are in a script in NOTEPAD, --you can now create a "SPOOL" file, execute...
-
1-Stern observed all of the following results EXCEPT _______ in his experiment. A-one of the recombinant phenotypes was associated with an X chromosome of normal length B-the number of car, B+ male...
-
Quince Interests is a partnership with a tax year that ends September 30, 2012. During that year, Potter, a partner, received $3,000 per month as a guaranteed payment, and his share of partnership...
-
Ken (age 31) and Amy (age 28) Booth have brought you the following information regarding their income, expenses, and withholding for the year. They are unsure which of these items must be used to...
-
Yolanda is a cash basis taxpayer with the following transactions during the year: Cash received from sales of products........................................................................$65,000...
-
The Basel Accords have had a great impact on the banking industry. Describe these and explain their significance to the ordinary person.
-
The following balance sheet and income statement data were taken from the financial records of The Arcadia Company. Required Prepare an indirect method statement of cash flow for The Arcadia Company...
-
Use supply and demand curves to illustrate how a central bank conducts monetary policy using open market operations, a discount window and altering reserve levels.
Study smarter with the SolutionInn App