Question

In: Accounting

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 statement balance.

(e.) Interest credited to the account during January but not recorded on the company's books amounted to $72.

(f.) A bank charge of $24 for printing new checks was made to the account during January. Although the company was expecting a charge, the amount was not Known until the bank statement arrived.

(g.) In the process of reviewing canceled checks, it was determined that a check issued to a supplier in payment of an account payable of $139 was recorded as a $193 cash disbursement.

Prepare the bank reconciliation for Grace, Inc., as of January 31.

21.   Prepare the appropriate entry(ies) for Grace, Inc., related to the bank reconciliation.

Debit                  Credit

Solutions

Expert Solution

Solution:

Grace Inc.
Bank Reconciliation - August 31
Bank's Cash balance Company's cash balance
Particulars Amount Particulars Amount
Ending balance as per Bank Statements $4,544.00 Ending Balance as per cash books $5,088.00
Additions: Additions:
Outstanding cash receipt $1,280.00 Interest earned $72.00
Incorrect recording of check ($193 - $139) $54.00
Deductions: Deductions:
Outstanding Checks ($452 + $182) $634.00 Service Charge $24.00
Up to date cash balance as per bank $5,190.00 Up to date cash balance as per books $5,190.00
Journal Entries - Grace Inc.
S. No. Particulars Debit Credit
1 Cash Dr $72.00
      To Interest revenue $72.00
(Being interest credited by bank)
2 Cash Dr $54.00
      To Accounts Payable $54.00
(Being incorred recording of check issued to creditor now corrected)
3 Service Charges Dr $50.00
       To Cash $50.00
(Being bank charges debited by bank)

Related Solutions

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...
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.
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...
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 Statement from the information provided and prepare adjusting Journal Entries.
Prepare a Bank Reconciliation Statement from the information provided and prepare  adjusting Journal Entries.The information below relates to the Cash account in the ledger of Bramble Company.Balance September 1—$17,010; Cash deposited—$64,500.Balance September 30—$17,664; Checks written—$63,846.The September bank statement shows a balance of $16,682 on September 30 and the following memoranda.Credits DebitsCollection of $1,621 note plus interest $39 $1,660 NSF check: Richard Nance $555Interest earned on checking account $54 Safety deposit box rent $74At September 30, deposits in transit were $4,580,...
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 The following information was extracted from the accounting record of ZONKE TRADING. Required: Prepare...
BANK RECONCILIATION The following information was extracted from the accounting record of ZONKE TRADING. Required: Prepare the following 4.1. The Cash Receipts Journal and the Cash Payments Journal of Zonke Trading for May 2017. [Details and Bank column only] 4.2. The Bank Account in the General Ledger and balance the account. 4.3. The Bank Reconciliation Statement on 31 May 2017. Format guide: Cash Receipts Journal : May Bank Cash Payments Journal : May Bank BANK Bank Reconciliation Statement as at...
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....
Use the Following Information to Answer the Questions Below to prepare the Bank Reconciliation 1) If...
Use the Following Information to Answer the Questions Below to prepare the Bank Reconciliation 1) If Any Differences or Errors are found, Assume that Our Business made the mistake and the BANK records are accurate. 2) The Following Items were Included on the Bank Statement from the Schwab Bank for the Month as Follows; Ending Bank Balance at January 31 was $69,000. Monthly Bank Fees of $1,500 NSF Check from Customer H.Clinton for $11,000 Interest Earned During the month was...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT