Bank Reconciliation Illustration for The Tackle Shop in July 20X3, Exercises of Accounting

A detailed example of a bank reconciliation process for the tackle shop in july 20x3. The bank statement, additional data, and the reconciliation process are presented, along with the corresponding journal entries. Bank reconciliation requires meticulous attention to detail, and even the smallest error can cause frustration. Various transactions, such as checks, electronic funds transfers, deposits, and adjustments, which need to be reconciled.

Typology: Exercises

2020/2021

Uploaded on 04/09/2021

honey-babe-guinocan
honey-babe-guinocan 🇵🇭

4.6

(5)

5 documents

1 / 3

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
COMPREHENSIVE ILLUSTRATION OF BANK RECONCILIATION:
The following illustration provides a detailed example of a bank statement, additional data, the reconciliation process, and the
corresponding journal entries. Conducting a bank reconciliation requires careful attention to the slightest of details. Even the
smallest error will lead to frustration in trying to bring closure to the reconciliation effort.
BANK STATEMENT
ADDITIONAL DATA
The above bank statement is for The Tackle Shop for July of 20X3. The following additional data is needed to reconcile the
account:
The first check listed above, #5454, was written in June but did not clear the bank until July 2.
There were no other outstanding checks, and no deposits in transit at the end of June.
The EFT (electronic funds transfer) on July 11 relates to the monthly utility bill; The Tackle Shop has authorized the
utility to draft their account directly each month.
The Tackle Shop is optimistic that they will recover the full amount, including the service charge, on the NSF check
("hot check") that was given to them by a customer during the month.
The bank collected a $5,000 note for The Tackle Shop, plus 9% interest ($5,450).
The Tackle Shop's credit card clearing company remitted funds on July 25; the Tackle Shop received an email
notification of this posting and simultaneously journalized this cash receipt in the accounting records.
The Tackle Shop made the 2 deposits listed above, and an additional deposit of $3,565.93 late in the afternoon on
July 31, 20X3.
The ending cash balance, per the company general ledger, was $47,535.30.
The following check register is maintained by The Tackle Shop, and it corresponds to the amounts within the Cash
account in the general ledger:
pf3

Partial preview of the text

Download Bank Reconciliation Illustration for The Tackle Shop in July 20X3 and more Exercises Accounting in PDF only on Docsity!

COMPREHENSIVE ILLUSTRATION OF BANK RECONCILIATION: The following illustration provides a detailed example of a bank statement, additional data, the reconciliation process, and the corresponding journal entries. Conducting a bank reconciliation requires careful attention to the slightest of details. Even the smallest error will lead to frustration in trying to bring closure to the reconciliation effort. BANK STATEMENT ADDITIONAL DATA The above bank statement is for The Tackle Shop for July of 20X3. The following additional data is needed to reconcile the account:

  • The first check listed above, #5454, was written in June but did not clear the bank until July 2.
  • There were no other outstanding checks, and no deposits in transit at the end of June.
  • The EFT (electronic funds transfer) on July 11 relates to the monthly utility bill; The Tackle Shop has authorized the utility to draft their account directly each month.
  • The Tackle Shop is optimistic that they will recover the full amount, including the service charge, on the NSF check ("hot check") that was given to them by a customer during the month.
  • The bank collected a $5,000 note for The Tackle Shop, plus 9% interest ($5,450).
  • The Tackle Shop's credit card clearing company remitted funds on July 25; the Tackle Shop received an email notification of this posting and simultaneously journalized this cash receipt in the accounting records.
  • The Tackle Shop made the 2 deposits listed above, and an additional deposit of $3,565.93 late in the afternoon on July 31, 20X3.
  • The ending cash balance, per the company general ledger, was $47,535.30.
  • The following check register is maintained by The Tackle Shop, and it corresponds to the amounts within the Cash account in the general ledger:

ANSWER: BANK RECONCILIATION The bank reconciliation for July is determined by reference to the above bank statement and other data. You must carefully study all of the above data to identify deposits in transit, outstanding checks, and so forth. Be advised that tracking down all of the reconciling items can be a rather tedious, sometimes frustrating, task. Modern bank statements facilitate this process by providing sorted lists with asterisks beside the check numbers that appear to have gaps in their sequence numbering. Below is the reconciliation of the balance per bank statement to the correct cash balance. You should try to identify each item in this reconciliation within the previously presented data.