Using the following information to prepare a bank reconciliation for XYZ Co. for May 31: (a)...

Using the following information to prepare a bank reconciliation for XYZ Co. for May 31:

(a)	The bank statement balance is $3,936.
(b)	The cash account balance is $4,194.
(c)	Outstanding checks amounted to $465.
(d)	Deposits in transit are $655.
(e)	The bank service charge is $50.
(f)	A check for $97 for supplies was recorded as $79 in the ledger.

Expert Solution

XYZ Co Bank Reconciliation for the May 31

Cash Balance as per Bank $3936

ADD : Deposit in transit $655

Less : Outstanding Check ($465)

Adjusted cash balance as per Books $4126

Cash balance as per books $4194

Less : bank charge ($50)

Less : Adjustment for check ($18)

Balance as per books $4126

Please give upvote rating also

ekkarill92 answered 2 years ago

Complete the Bank Reconciliation (15pts) Prepare a bank reconciliation as of December 31, 2017 using the...

Complete the Bank Reconciliation (15pts) Prepare a bank reconciliation as of December 31, 2017 using the following format. I am not going to be particular about how you show your numbers as long as you have them in the right spot and can get to the correct adjusted balances. Bank Balance: Cash Balance: Add: Add: Deduct: Deduct: Adjusted Balance: Adjusted Balance: Journalize the necessary entries. After completing the bank reconciliation show any necessary journal entries. Pretend you have a general...

Prepare a bank reconciliation for Grace, Inc., as of January 31, from the following information: (a.)...

Prepare a bank reconciliation for Grace, Inc., as of January 31, from the following information: (a.) The January 31 cash balance in the general ledger is $5,088. (b.) The January 31 balance shown on the bank statement is $4,544. (c.) Checks issued but not returned with the bank statement were No. 435 for $452 and No. 448 for $182. (d.) A deposit made on January 31 for $1,280 was included in the general ledger balance but not in the bank...

Prepare a bank reconciliation dated December 31, 2020, for Nittany Inc. based on the following information....

Prepare a bank reconciliation dated December 31, 2020, for Nittany Inc. based on the following information. ∙ Balance per bank statement is $1,000. ∙ Balance per books is $900. ∙ The December bank statement indicated a service charge of $30. ∙ Cheque #1169 for $400 made out to a supplier was mailed, but not yet received by the bank. . Cheque #1183 for $270 to a supplier was incorrectly posted by Nittany as $720 in the books. ∙ The bank...

The information below was used to prepare a bank reconciliation for Lorena Company at October 31:...

The information below was used to prepare a bank reconciliation for Lorena Company at October 31: ∙ According to the bank statement, the bank balance as of October 31 was $8,765. According to the books, the cash balance as of October 31 is $9,557. ∙ Outstanding checks totaled $1,433. ∙ A customer's check for $999 was returned for NSF. ∙ October's service charge was $100. ∙ The bank collected $1,600 from a customer of Lorena Company in payment of a...

Shown below is the information needed to prepare bank reconciliation for Mandy Company on 31 October...

Shown below is the information needed to prepare bank reconciliation for Mandy Company on 31 October 2019: (1) The cash ledger account showed a balance of $8,510, while the bank statement indicated a cash balance of $12,390. (2) The bank statement showed $45 interest earned for the month of October. (3) ZYX company settled its notes payable by depositing $4,000 directly into Mandy’s bank account. (4) The company issued three checks totaling $1,000, which had not been shown in the...

Bank Reconciliation An accounting clerk for Chesner Co. prepared the following bank reconciliation: Chesner Co. Bank...

Bank Reconciliation An accounting clerk for Chesner Co. prepared the following bank reconciliation: Chesner Co. Bank Reconciliation July 31, 20Y4 Cash balance according to company's records $8,260 Adjustments: Outstanding checks $3,960 Error by Chesner Co. in recording Check No. 1056 as $820 instead of $280 540 Note for $13,000 collected by bank, including interest 13,520 Deposit in transit on July 31 (8,410) Bank service charges (30) Total adjustments 9,580 Cash balance according to bank statement $17,840 a. From the data...

Prepare a bank reconciliation using the above data given

The following data were accumulated for use in reconciling the bank account of creative Design co for August 20Y6 1.Cash Balance according to the company's records at August 31, $27,210 2.Cash Balance according to the bank statement at August 31,$28,330 3.Checks outstanding,$5,520 4.Deposit in transit, not recorded by bank $4,440 5. A check for $340 in payment of an account was erroneously recorded in the check register as $430 6.Bank debit memo for service charges , $50 Req (a). prepare...

National Surf Board Co. (NSB) gathered the following information for its August 31 bank reconciliation: Cash...

National Surf Board Co. (NSB) gathered the following information for its August 31 bank reconciliation: Cash balance per books, August 31 $3,872 Cash balance per bank, August 31 $ (332) (account is overdrawn; a negative balance) August 31st cash receipts of $8,000 were locked in NSB’s Treasurer’s office with a plan to deposit them at the bank the next day. Outstanding cheques issued by NSB at August 31st totalled $4,023 A check originally issued by a customer for $257 was...

Based on the following information, prepare a bank reconciliation to determine the adjusted corrected balance

Based on the following information, prepare a bank reconciliation to determine the adjusted corrected balance: (input each amount as a positive value) Bank balance$ 680Account fees $ 12Checkbook balance$ 642ATM withdrawals$ 80Outstanding checks$ 112Deposit in transit$ 60Direct deposits$ 70Interest earned$ 8

The following information should be used to prepare a bank reconciliation for KTZFIG Sales and Consulting...

The following information should be used to prepare a bank reconciliation for KTZFIG Sales and Consulting as of June 30. Prepare the reconciliation on the Bank Reconciliation tab. On June 30, 2018, KTZFIG Sales and Consulting Co. had a cash balance in the ledger of $241,768. The June statement from Michigan State Bank showed a balance of $244,573 on June 30, 2018. The following facts regarding banking and cash activities are available. The bank service charge for June was $70....

Question