The book balance of Macro, Inc.'s checking account on July 31, 2023 was $5,790. The bank...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The book balance of Macro, Inc.'s checking account on July 31, 2023 was $5,790. The bank statement balance on that date was $8,500. Not included on the bank statement was a deposit that Macro made on July 30, 2023 in the amount of $1,200. During July, Macro collected a check from an account receivable customer in the amount of $540, which was properly recorded by the bank. In recording the check, Macro mistakenly recorded the check as $450. The July 31, 2023 bank statement included a deposit for the collection of a note on behalf of Macro. The deposit included a payment for the principal balance of the note in the amount of $2,000, plus interest of $150. Also included on the bank statement was a bank charge of $50 which was automatically deducted from Macro's account. In July the bank recorded a deposit to Macro's account in the amount of $500 which should have been recorded in another bank customer's account. During July Macro wrote two checks (#1002 in the amount of $800, and # 1004 in the amount of $600) which were not included on the July 31, 2023 bank statement. Also in July, Macro wrote check # 999 in the amount of $800 for the purchase of equipment, which was correctly recorded and paid by the bank during July. However, Macro recorded the check incorrectly in the amount of $620. REQUIRED: Prepare a two column bank reconciliation for Macro as of July 31, 2023, using the proper format, including any adjusting journal entries that may be required for Macro as of that date. The book balance of Macro, Inc.'s checking account on July 31, 2023 was $5,790. The bank statement balance on that date was $8,500. Not included on the bank statement was a deposit that Macro made on July 30, 2023 in the amount of $1,200. During July, Macro collected a check from an account receivable customer in the amount of $540, which was properly recorded by the bank. In recording the check, Macro mistakenly recorded the check as $450. The July 31, 2023 bank statement included a deposit for the collection of a note on behalf of Macro. The deposit included a payment for the principal balance of the note in the amount of $2,000, plus interest of $150. Also included on the bank statement was a bank charge of $50 which was automatically deducted from Macro's account. In July the bank recorded a deposit to Macro's account in the amount of $500 which should have been recorded in another bank customer's account. During July Macro wrote two checks (#1002 in the amount of $800, and # 1004 in the amount of $600) which were not included on the July 31, 2023 bank statement. Also in July, Macro wrote check # 999 in the amount of $800 for the purchase of equipment, which was correctly recorded and paid by the bank during July. However, Macro recorded the check incorrectly in the amount of $620. REQUIRED: Prepare a two column bank reconciliation for Macro as of July 31, 2023, using the proper format, including any adjusting journal entries that may be required for Macro as of that date. The book balance of Macro, Inc.'s checking account on July 31, 2023 was $5,790. The bank statement balance on that date was $8,500. Not included on the bank statement was a deposit that Macro made on July 30, 2023 in the amount of $1,200. During July, Macro collected a check from an account receivable customer in the amount of $540, which was properly recorded by the bank. In recording the check, Macro mistakenly recorded the check as $450. The July 31, 2023 bank statement included a deposit for the collection of a note on behalf of Macro. The deposit included a payment for the principal balance of the note in the amount of $2,000, plus interest of $150. Also included on the bank statement was a bank charge of $50 which was automatically deducted from Macro's account. In July the bank recorded a deposit to Macro's account in the amount of $500 which should have been recorded in another bank customer's account. During July Macro wrote two checks (#1002 in the amount of $800, and # 1004 in the amount of $600) which were not included on the July 31, 2023 bank statement. Also in July, Macro wrote check # 999 in the amount of $800 for the purchase of equipment, which was correctly recorded and paid by the bank during July. However, Macro recorded the check incorrectly in the amount of $620. REQUIRED: Prepare a two column bank reconciliation for Macro as of July 31, 2023, using the proper format, including any adjusting journal entries that may be required for Macro as of that date. The book balance of Macro, Inc.'s checking account on July 31, 2023 was $5,790. The bank statement balance on that date was $8,500. Not included on the bank statement was a deposit that Macro made on July 30, 2023 in the amount of $1,200. During July, Macro collected a check from an account receivable customer in the amount of $540, which was properly recorded by the bank. In recording the check, Macro mistakenly recorded the check as $450. The July 31, 2023 bank statement included a deposit for the collection of a note on behalf of Macro. The deposit included a payment for the principal balance of the note in the amount of $2,000, plus interest of $150. Also included on the bank statement was a bank charge of $50 which was automatically deducted from Macro's account. In July the bank recorded a deposit to Macro's account in the amount of $500 which should have been recorded in another bank customer's account. During July Macro wrote two checks (#1002 in the amount of $800, and # 1004 in the amount of $600) which were not included on the July 31, 2023 bank statement. Also in July, Macro wrote check # 999 in the amount of $800 for the purchase of equipment, which was correctly recorded and paid by the bank during July. However, Macro recorded the check incorrectly in the amount of $620. REQUIRED: Prepare a two column bank reconciliation for Macro as of July 31, 2023, using the proper format, including any adjusting journal entries that may be required for Macro as of that date.
Expert Answer:
Answer rating: 100% (QA)
To prepare a bank reconciliation for Macro as of July 31 2023 we need to adjust the book balance and the bank balance based on the information provided to calculate the adjusted cash balance Heres a s... View the full answer
Related Book For
Financial Accounting
ISBN: 978-0078025549
3rd edition
Authors: J. David Spiceland, Wayne Thomas, Don Herrmann
Posted Date:
Students also viewed these accounting questions
-
The following accounts and totals, taken from Chef Cheryl's Bistro, display some of Chef Cheryl's Bistro's adjusted balances before closing: Cheryl Kind, Capital 50,000 Cheryl Kind, Withdrawals...
-
Formulate a plausible mechanism for the following reaction. The product is a precursor of mediquox (shown in the margin), an agent used to treat respiratory infections in chickens (no, we are not...
-
Draw the tetrahedral representation of the S enantiomer of the amino acid cysteine, HSCH2CH(NH2)CO2H.
-
On December 31, 2019, Robey Company accumulated the following information for 2019 in regard to its defined benefit pension plan: Service cost...
-
Indicate the specific accounting control objectives for each function in the execution of manufacturing transactions.
-
College Supply Company (CSC) makes three types of drinking glasses: short, medium, and tall. It presently applies overhead using a predetermined rate based on direct labor-hours. A group of company...
-
Imagina que eres socio de una compaa de construccin, la cual ha obtenido un contrato para fabricar una urbanizacin de 125 residencias a un costo de 12 millones de dlares. Eres el encargado del...
-
1. The average distance in kilometers from a school in Chicago to the closest fast food restaurant is 0.60 with a standard deviation of 0.45. Express each of the following distances as a z score: a....
-
A non-conventional highly interactive course designed to provide UOS students with a unique experience into identifying the concepts of innovation, entrepreneurship, growth and leadership. At a...
-
Jamie Wong is thinking of building an investment portfolio containing two exchange traded funds (ETFs). Jamie plans to invest $2,500 in Vanguard S&P 500 ETF (VOO) and $7,500 in Invesco QQQ Trust...
-
Why are the prices of put options with strike prices between $19 and $20.50 more expensive than the other put options on the list? If the investor sells 10 contracts of $18.50 call options, how much...
-
1 SOM Deposit 7 (1) 8 9 5 banks offer nominal rates of 6%, but differ in their compounding frequency. A-annually; B-semiannually; C- quarterly; D-monthly; and E-daily. (1) EAR 20 21 22 23 24 17 18 03...
-
Suppose a risk neutral agent has $100,000 today that he wants to save for one year. Compare the following three savings plans. Bank A offers a standard savings account with 4.2% p.a. (per annum)....
-
How much interest would Aleem save if he paid off his mortgage over 15 years instead of 30 years? His mortgage is $100 000 at six percent interest calculated semi-annually. 8. Julian is a student...
-
Give the names of default 16-bit segment and offset registers for 8086 microprocessor. 5
-
Suppose the market is semistrong form efficient. Can you expect to earn excess returns if you make trades based on? a. Your brokers information about record earnings for a stock? b. Rumors about a...
-
Describe the basic format used in preparing a statement of cash flows, including the heading, the three major categories, and what is included in the last three lines of the statement.
-
Green Wave Company plans to own and operate a storage rental facility. For the first month of operations, the company had the following transactions. 1. Issue 10,000 shares of common stock in...
-
What is a bank reconciliation? How can it help in determining whether proper control of cash has been maintained?
-
Determine whether each experiment is a binomial experiment. If it is, specify the values of n, p, and q, and list the possible values of the random variable x. If it is not, explain why. 1. A certain...
-
In a survey, U.S. adults were asked to identify which social media platforms they use. The results are shown in the figure. Six adults who participated in the survey are randomly selected and asked...
-
Rotator cuff surgery has a 90% chance of success. The surgery is performed on three patients. Find the probability of the surgery being successful on exactly two patients.
Study smarter with the SolutionInn App