Question

Write the procedure documentation for the monthly bank reconciliation process in a professional manner. It will...

  • Write the procedure documentation for the monthly bank reconciliation process in a professional manner.
    • It will be the desktop guide used by others in the event of your absence to prepare the financial statements for The Gift Shop.
    • It may be in the form of a memorandum or as a numbered listing of items, depending on your individual preference.
  • Prepare the monthly bank reconciliation for The Gift Shop based on the information provided.

Additional information needed for bank reconciliation preparation follows:

  • Cash per the unadjusted trial balance is $12,675.
  • Cash balance per the bank statement is $12,780.
  • Check #115 has not cleared the bank. It was written for $645.
  • A deposit of $1,000 cleared the bank but was not recorded in the general ledger.
  • A check for $250 was found in the owner's desk drawer.
  • A deposit of $1,250 was taken to the bank after 2 p.m. on December 31, 2008 and was not posted by the bank until January 1, 2009.
  • Errors were noted in the following checks:
    • Check #121 was recorded for $325 but cleared the bank as $320.
    • Check #125 was recorded for $585 but cleared the bank as $600.
    • Bank service charge reported on the bank statement $30.00

Homework Answers

Answer #1

monthly bank reconciliation for The Gift Shop is as prepared below:

The Gift Shop
Bank Reconciliation
31-Dec-18
Particulars Amount ($) Amount ($)
Balance as per bank 12,780
Add: Deposit in transit 1,250 1250
Less: outstanding checks:
115 645 645
Adjusted cash balance per bank 13385
Cash balance as per books 12,675
Add: Deposit not recorded in ledger 1,000
Add: Error in recording check 121 5 1,005
Less:
Bank Service Charges 30
Error in recording check 125 15
Check not recorded by owner 250 295
Adjusted cash balance as per books 13,385
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Bank Reconciliation A bank reconciliation explains the causes for any differences between a company's cash balance...
Bank Reconciliation A bank reconciliation explains the causes for any differences between a company's cash balance on its bank statement and its cash balance on the books (that is, in the ledger. ) Allez Company's monthly bank statement shows an account balance of $6127.23. The cash balance in its ledger is $5301.05. A thorough bank reconciliation investigation yields the following information: The bank erroneously deducted $346.70 from the company's account when the actual amount of a check written by the...
Prepare a bank reconciliation for Party USA based on the following information and then prepare journal...
Prepare a bank reconciliation for Party USA based on the following information and then prepare journal entries to adjust the general ledger cash balance. Party USA           Bank Reconciliation Dec. 31, 2019 Bank Side Book side Bank Balance Dec 31     General Ledger Balance Dec. 31 Add: Add: Less: Less: Adjusted Bank Balance Adjusted Book Balance Bank Balance 10,450 General ledger cash balance 10,563 Total Deposits in December 64,300 total Checks written in December 12,767 Outstanding Checks as of...
Marin Inc.’s bank statement from Main Street Bank at August 31, 2022, gives the following information....
Marin Inc.’s bank statement from Main Street Bank at August 31, 2022, gives the following information. Balance, August 1 $18,620 Bank debit memorandum: August deposits 71,220 Safety deposit box fee $ 55 Checks cleared in August 65,648 Service charge 80 Bank credit memorandum: Balance, August 31 24,132   Interest earned 75 A summary of the Cash account in the ledger for August shows the following: balance, August 1, $18,920; receipts $74,220; disbursements $73,540; and balance, August 31, $19,600. Analysis reveals that...
Bank reconciliation Prepare a bank reconciliation as of October 31 from the following information: a. The...
Bank reconciliation Prepare a bank reconciliation as of October 31 from the following information: a. The October 31 cash balance in the general ledger is $1,688. b. The October 31 balance shown on the bank statement is $746. c. Checks issued but not returned with the bank statement were No. 462 for $26 and No. 483 for $100. d. A deposit made late on October 31 for $900 is included in the general ledger balance but not in the bank...
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers...
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: Cash balance according to the company's records at July 31 $28,850. Cash balance according to the bank statement at July 31, $30,060. Checks outstanding, $5,860. Deposit in transit, not recorded by bank, $4,700. A check for $340 in payment of an account was erroneously recorded in the check register as $430. Bank debit memo for service charges, $40. a. Prepare a...
Prepare Bank reconciliation report and journalize the necessary adjustments as of March 31st, 2017 for Company...
Prepare Bank reconciliation report and journalize the necessary adjustments as of March 31st, 2017 for Company “R”; its bank statement for March shows the following data:                                 Balance 3/1                              $15,650                            Balance 3/31                                $17,580 Debit memorandum:                                                         Credit memorandum:          NSF check                           $275                                    Collection of note receivable    $605 The cash balance per books at March 31st is $16,319. Other relevant data are given below: The NSF check was from a customer, The note collected by the bank was a $600, 3 month,...
The following information is provided for preparing bank reconciliation for Rush Company as of December 31....
The following information is provided for preparing bank reconciliation for Rush Company as of December 31. 1. The cash ledger account of Rush Company reveals an ending balance of $8,374.33 as of December 31. 2. Comparison of the company’s records and the bank statement for December indicates that, the following checks are issued and appear in the company’ records but are not listed among the paid checks by the bank: Ck.no.423 $125 Ck.no.424 $387 3. Comparison of the company’s records...
The following information is provided for preparing bank reconciliation for Rush Company as of December 31....
The following information is provided for preparing bank reconciliation for Rush Company as of December 31. 1. The cash ledger account of Rush Company reveals an ending balance of $8,374.33 as of December 31. 2. Comparison of the company’s records and the bank statement for December indicates that, the following checks are issued and appear in the company’ records but are not listed among the paid checks by the bank: Ck.no.423 $125 Ck.no.424 $387 3. Comparison of the company’s records...
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers...
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: Cash balance according to the company's records at July 31 $17,880. Cash balance according to the bank statement at July 31, $19,100. Checks outstanding, $3,630. Deposit in transit, not recorded by bank, $2,910. A check for $170 in payment of an account was erroneously recorded in the check register as $710. Bank debit memo for service charges, $40. a. Prepare a...
During the bank reconciliation process at A. Fontes Consultancy on May 2, 2019, the following two...
During the bank reconciliation process at A. Fontes Consultancy on May 2, 2019, the following two errors were discovered in the firm’s records. The checkbook and the general journal indicated that Check 2206 dated April 17 was issued for $711 to make a cash purchase of supplies. However, examination of the canceled check and the listing on the bank statement showed that the actual amount of the check was $22. The checkbook and the general journal indicated that Check 2247...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT