Question

In: Accounting

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 had not received a deposit in transit of $900 when the bank statement was generated.

∙           A bank debit memo indicated an NSF cheque written by Bill Broke to Nittany Inc. on December 11, 2020, for $150.

∙           A bank credit memo indicated a bank collection of $300 and interest revenue of $30 on December 15, 2020. Nittany has yet to record this receipt

Solutions

Expert Solution

Nittany Inc.
Bank Reconciliation
Dec 31,2020
Particulars Amount
Cash Balance per Company's Records                    900
Add: Cheq # 1169 not received by Bank                    400
Add: Cheq # 1183 incorrectly entered in Company Records                    450
Add: bank collection                    300
Add: Interest Revenue                       30
                2,080
Less: Deposit in Transit                   -900
Less: Bank Service Charges                     -30
Less: NSF cheque                   -150
Balance as per Bank Statement                 1,000

Related Solutions

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...
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...
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.
Prepare the necessary adjusting journal entries on December 31, 2020. Also prepare an adjusted trial balance dated December 31, 2020
                                                       GoodJob Inc.                                           Unadjusted Trial Balance                                               December 31,2020 Account                                                                                 Debit                             Credit Cash                                                                                       304,150 Accounts Receivable                                                            99,000 Office supplies                                                                            880 Prepaid rent.                                                                           3,960 Unexpired insurance                                                              1,650 Office equipment                                                                  79,200 Accumulated depreciation: office equipment                                                        26,400 Accounts payable                                                                                                           4,400 Notes payable (due 3/1/12)                                                                                       66,000 Interest payable                                                                                                                 660 Income taxes payable                                                                                                    9,900 Dividends payable                                                                                                          3,500 Unearned consulting fees                                                                                           24,200 Capital stock                                                                                                                  220,000 Retained earnings                                                                                                         44,000 Dividends                                                                              3,500 Consulting fees earned                                                                                               550,000 Rent expense                                                                      16,170 Insurance expense                                                               2,420 Office supplies expense                                                      4,950 Depreciation expense: office equipment                      ...
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
Instructions a. Prepare a bank reconciliation dated June 30, 2020, proceeding to a correct cash balance....
Instructions a. Prepare a bank reconciliation dated June 30, 2020, proceeding to a correct cash balance. b. Prepare any entries necessary to make the books correct and complete. *P7.14 (LO 6) (Bank Reconciliation and Adjusting Entries) Presented below is information related to Haselhof Inc. Balance per books at October 31, $41,847.85; receipts $173,523.91; disbursements $164,893.54. Balance per bank statement November 30, $56,274.20. The following checks were outstanding at November 30. 1224 $1,635.29 1230 2,468.30 1232 2,125.15 1233 482.17 Included with...
12. based on the following information, prepare a bank reconciliation to determine the adjusted (corrected) balance:...
12. based on the following information, prepare a bank reconciliation to determine the adjusted (corrected) balance: Bank balance $680 Checkbook balance $642 outstanding checks $112 direct deposits $70 Account fees $12 ATM withdrawals $60 interest earned $8
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...
The Scooter Warehouse provided the following information at December 31, 2013:   Bank Reconciliation   General ledger cash...
The Scooter Warehouse provided the following information at December 31, 2013:   Bank Reconciliation   General ledger cash        balance, 12/31/13 $ 17,566   Bank statement balance,        12/31/13 $ 16,306   Bank service charge (25 )   Deposits in transit 2,450   Returned customer checks        marked NSF (375 )   Outstanding checks (1,356 )   Error in recording of office      supplies 234   Adjusted cash balance,       12/31/13 $ 17,400   Adjusted cash balance,       12/31/13 $ 17,400 Investment in securities The company invested $26,000 in a portfolio of investment in securities on...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT