Bank Reconciliation Project - 2 (September Bank Activity) Fall 2023 Record the following activity in the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Bank Reconciliation Project - 2 (September Bank Activity) Fall 2023 Record the following activity in the horizontal ledger BEGINNING INVENTORY 40 Pairs of Shoes @ $50/pair = $2,000 Inventory 1) Check # 359 for $5,500 was used to purchase additional shoe inventory for Shoes Inventory Co. Shoe Sales Co purchased 100 pairs @ $55 each. 2) On September 2, 2023 purchased 200 pairs of new shoes from Shoe Inventory Company for $12,000. Purchased on account. 3) On September 3, 2023 used check # 360 to pay company payroll of $1,200. 4) On September 5, paid Zippy's Repair for $700 in repairs with check # 361 5) September 6, 2023, check # 362 paid utilities due of $420. 6) September 16, purchased a new cash register for $9,000. The cash register has an estimated useful life of 4 years and salvage value of $1,000. 7) September 18, sold 275 pairs of shoes for $125 per pair. All of the sales were sold on account. 8) Calculate the Cost of Goods Sold in Item #7 using the FIFO Method of inventory cost flow. 9) September 19, check #364 paid delivery fees related to the sale of the shoes of $300 (FOB Destination Point). 10) September 20, purchased supplies from More Stuff Supplies. The total invoice was $1,200. Paid with check # 365 11) September 21 collected $20,000 of Accounts Receivable and deposited it into the bank. 12) Purchased 30 pairs of additional shoe inventory using check #366. The cost of the shoes was $62 per pair. 13) September 22, 2023 paid Big Rental Company $1,600 for rent for the month of September, Check # 367 14) September 24, used Check # 368 to pay other operating expenses of $290. 15) Deposited accounts $3,600 of accounts receivable. 16) Check # 369 paid $9,000 of the accounts payable balance. 17) Determined Supplies on hand at the end of September were only $2,500. 18) Calculate & Record the depreciation on the cash register purchased in item #6. Use straight-line depreciation for a full year. 19) Shoe Sales Co estimates their uncollectible accounts using the aging schedule: Current 1-60 60+ Accounts Receivable Aging 175 0% 1500 400 1% 2% ASSIGNMENT - Record the information above a the horizontal accounting ledger. Using this information reconcile your Bank account to determine TRUE CASH. RECORD the necessary adjustments to your BOOK CASH account to show the TRUE CASH BALANCE per BOOKS. Bank Reconciliation Project - 2 (September Bank Activity) Fall 2023 Record the following activity in the horizontal ledger BEGINNING INVENTORY 40 Pairs of Shoes @ $50/pair = $2,000 Inventory 1) Check # 359 for $5,500 was used to purchase additional shoe inventory for Shoes Inventory Co. Shoe Sales Co purchased 100 pairs @ $55 each. 2) On September 2, 2023 purchased 200 pairs of new shoes from Shoe Inventory Company for $12,000. Purchased on account. 3) On September 3, 2023 used check # 360 to pay company payroll of $1,200. 4) On September 5, paid Zippy's Repair for $700 in repairs with check # 361 5) September 6, 2023, check # 362 paid utilities due of $420. 6) September 16, purchased a new cash register for $9,000. The cash register has an estimated useful life of 4 years and salvage value of $1,000. 7) September 18, sold 275 pairs of shoes for $125 per pair. All of the sales were sold on account. 8) Calculate the Cost of Goods Sold in Item #7 using the FIFO Method of inventory cost flow. 9) September 19, check #364 paid delivery fees related to the sale of the shoes of $300 (FOB Destination Point). 10) September 20, purchased supplies from More Stuff Supplies. The total invoice was $1,200. Paid with check # 365 11) September 21 collected $20,000 of Accounts Receivable and deposited it into the bank. 12) Purchased 30 pairs of additional shoe inventory using check #366. The cost of the shoes was $62 per pair. 13) September 22, 2023 paid Big Rental Company $1,600 for rent for the month of September, Check # 367 14) September 24, used Check # 368 to pay other operating expenses of $290. 15) Deposited accounts $3,600 of accounts receivable. 16) Check # 369 paid $9,000 of the accounts payable balance. 17) Determined Supplies on hand at the end of September were only $2,500. 18) Calculate & Record the depreciation on the cash register purchased in item #6. Use straight-line depreciation for a full year. 19) Shoe Sales Co estimates their uncollectible accounts using the aging schedule: Current 1-60 60+ Accounts Receivable Aging 175 0% 1500 400 1% 2% ASSIGNMENT - Record the information above a the horizontal accounting ledger. Using this information reconcile your Bank account to determine TRUE CASH. RECORD the necessary adjustments to your BOOK CASH account to show the TRUE CASH BALANCE per BOOKS.
Expert Answer:
Answer rating: 100% (QA)
Horizontal Accounting Ledger Shoe Sales Co September 2023 Date Account Debit Credit Balance Descript... 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
-
Brookes Books is a retail book store. The company is owned by Brooke Riley, the only shareholder (to be). Brooke has asked you to keep the records for the store and to prepare its financial...
-
December 1: , a new investor, made an investment in Byte by purchasing 2,700 shares of its common stock paying $72,900.00 in cash. The par value of the common stock was $19.00 per share. December 3:...
-
A record company needs to produce 100 gold records at one or more of its three studios. the cost of producing x records at studio 1 is 10 x; the cost of producing y records at studio 2 is 2y 2 ; the...
-
Economist Richard Thaler of the University of Chicago notes that most economists consider arbitrage to be one way "that markets can do their magic." Briefly explain the role arbitrage can play in...
-
The table in Figure 2.1 shows how the terms of the growth function for our dishwashing example are related to one another as n grows. Write a program that will create such a table for any given...
-
Plaintiff contracted to install a boiler for defendant. After plaintiff had installed and tested the boiler, but before final payment to plaintiff had been made, defendant took custody of the boiler...
-
Yello Bus Lines uses the units-of-activity method in depreciating its buses. One bus was purchased on January 1, 2014, at a cost of $148,000. Over its 4-year useful life, the bus is expected to be...
-
Suppose you have 135 households in your neighborhood, can you use "=RAND()" function in Excel to randomly select 20 of them to send a survey? a) Write down the codes you would use. b) Show your work...
-
In this mini-case, you will complete the test of details on accounts receivable for the 2019 audit of EarthWear Clothiers, Inc. The principal test of detail involves sending "confirmations" or...
-
Activity (or Turnover) Ratios comprises of all except A B C D Fixed Assets Turnover Ratio Debtors Turnover Ratio Dividend Payout Ratio Investment Turnover Ratio
-
UTILITARIANISM IS APPLIED TO A REAL WORLD PROBLEM President Barack Obama's director of the National Economic Council, Lawrence Summers, wrote a memo in 1991 (while he was the World Bank's chief...
-
To establish workplace policies and procedures comply with relevant WHS laws, a full audit will be conducted by the WHS Manager. To assist in the audit process and in establishing WHS legislative...
-
QUESTIONS 1. Explore the following resources to understand how the computer works. 2. Explain how the input and output system works. 3. Discuss one practical example of using computer-based...
-
Eastern University Next, you are off to Halifax, Nova Scotia to work with a newly created university called Eastern University. This is a brand new university and it is scheduled to open in 2024. The...
-
BA has outsourced more of its operations than any other major world airline. All of its ticketing and Internet operations are designed and managed through Indian IT companies. BA now employs...
-
Perform the following operations: a. 36810 - 61057 in 9's complement. b. 100110000111BCD - A4516 in 15's complement. c. Add the two numbers in binary: 574.68 + 32E16
-
Determine two different Hamilton circuits in each of the following graphs. A B F G
-
Carl Conch and Mary Duval are married and file a joint return. They live at 1234 Mallory Sq. Apt. 64, Key West, FL 33040. Carl works for the Key Lime Pie Company and Mary is a homemaker after losing...
-
William sold Section 1245 property for $25,000 in 2012. The property cost $35,000 when it was purchased 5 years ago. The depreciation claimed on the property was $16,000. a. Calculate the adjusted...
-
Marty is a sales consultant. Marty incurs the following expenses related to entertainment of his clients in 2012: Dues to a country club......................................................$4,500...
-
Perhaps the most famous case illustrating the enormous cost of winning back lost customers is that of the Tylenol Murders. Seven people in the Chicago area died suddenly after taking Tylenol...
-
Describe the concept of MBWA.
-
Give a brief rationale for empowerment.
Study smarter with the SolutionInn App