**Bank Reconciliation**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, $23,680.2. **Cash balance** according to the bank statement at August 31, $24,660.3. **Checks outstanding**, $4,810.4. **Deposit in transit**, not recorded by bank, $3,860.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, $60. The image contains a bank reconciliation template for Creative Design Co. as of August 31, 20Y6. The reconciliation involves several steps to adjust the bank and company records to reach a final adjusted balance.**Bank Reconciliation Steps**1. **Balance According to Bank Statement** - Initial bank statement balance: $23,680 - Add: Deposit in transit on August 31: $3,860 - Deduct: Outstanding checks: $4,810 - Adjusted bank balance: $22,7302. **Balance According to Company’s Records** - Initial company records balance: (left blank) - Add: Error in recording check: (left blank) - Deduct: Bank service charge: (left blank) - Adjusted company balance: (left blank)**Additional Questions**b. The question asks what amount should be reported for cash on Creative Design Co.’s balance sheet as of August 31.c. It inquires whether a bank reconciliation must always reconcile.**Diagram/Template Explanation**The document uses a tabular format to display the bank reconciliation process. For both the bank statement and the company's records, the columns are structured to show the initial balance, adjustments (additions and deductions), and the final adjusted balance. The purpose is to ensure both the bank's records and the company's financial records are consistent and accurate. Several entries are marked with ticks and crosses, indicating important points to consider during reconciliation.

Answered: Image /qna-images/answer/55ec6fd2-a01c-4e41-82ad-f068c088b010.jpg

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, $23,680. 2. Cash balance according to the bank statement at August 31, $24,660. 3. Checks outstanding, $4,810. 4. Deposit in transit, not recorded by bank, $3,860. 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, $60.

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, $23,680. 2. Cash balance according to the bank statement at August 31, $24,660. 3. Checks outstanding, $4,810. 4. Deposit in transit, not recorded by bank, $3,860. 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, $60.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

a. The June 30 cash balance in the general ledger is $878. b. The June 30 balance shown on the bank statement is $402. c. Checks Issued but not returned with the bank statement were Number 712 for $24 and Number 723 for $55. d. A deposit made late on June 30 for $472 Is Included in the general ledger balance but not in the bank statement balance. e. Returned with the bank statement was a notice that a customer's check for $74 that was deposited on June 24 had been returned because the customer's account was overdrawn. 1. During a review of the checks that were returned with the bank statement, It was noted that the amount of Check Number 728 was $65 but that in the company's records supporting the general ledger balance, the check had been erroneously recorded as a payment of an account payable in the amount of $56. Required: Prepare a bank reconciliation as of June 30 from the above information. Note: Total the entries of the same account together when entering in the bank…
Using the following information, prepare the journal entries to reconcile the bank statement. Bank balance: $6,988 Book balance: $8,923 Deposits in transit: $1,875 Outstanding checks: $569 and $1,423 Bank service charges: $75 Bank incorrectly charged the account $75. The bank will correct the error next month. Check number 2456 correctly cleared the bank in the amount of $123 but posted in the accounting records as $213. This check was expensed to Utilities Expense. If an amount box does not require an entry, leave it blank.
The following data were gathered to use in reconciling the bank account of Reddan Company: $ 17,900 10,300 Balance per bank Balance per company records Bank service charges 40 Deposit in transit Note collected by bank with $170 interest Outstanding checks a. What is the adjusted balance on the bank reconciliation? 3,400 4,900 6,140 b. Journalize any necessary entries for Photo Op. Company based on the bank reconciliation. If an amount box does not require an entry, leave it blank.
Refer to the Information given below: a. The August 31 balance shown on the bank statement is $9,050. b. There is a deposit in transit of $1,300 at August 31. c. Outstanding checks at August 31 totaled $1,620. d. Interest credited to the account during August but not recorded on the company's books amounted to $68. e. A bank charge of $44 for checks was made to the account during August. Although the company was expecting a charge, the amount was not known until the bank statement arrived. f. In the process of reviewing the canceled checks, it was determined that a check issued to a supplier in payment of accounts payable of $142 had been recorded as a disbursement of $412 g. The August 31 balance in the general ledger Cash account, before reconciliation, is $8,436. Required: Prepare a bank reconciliation as of August 31 from the above Information. Balance per bank Add: Deduct: Reconciled balance Bank Reconciliation August 31 Balance per books Add: Deduct: Reconciled balance
The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 20Y6: Cash balance according to the company’s records at August 31, $42,920. Cash balance according to the bank statement at August 31, $56,300. Checks outstanding, $25,390. Deposit in transit not recorded by bank, $13,325. A check for $150 in payment of an account was erroneously recorded in the check register as $1,500. Bank debit memo for service charges, $35. Journalize the entries that should be made by the company that (a) increase cash and (b) decrease cash. If an amount box does not require an entry, leave it blank.
1. Cash balance according to the company's records at August 31, $25,520. 2. Cash balance according to the bank statement at August 31, $26,850. 3. Checks outstanding, $5,180. 4. Deposit in transit, not recorded by bank, $4,160. 5. A check for $480 in payment of an account was erroneously recorded in the check register as $840. 6. Bank debit memo for service charges, $50. Prepare Bank Reconciliation statement?
The cash account for Pala Medical Co. at June 30, 20Y1, indicated a balance of $93,115. The bank statement indicated a balance of $125,800 on June 30, 20Y1. Comparing the bank statement and the accompanying canceled checks and memos with the records revealed the following reconciling items: a. Checks outstanding totaled $30,080. b. A deposit of $19,240, representing receipts of June 30, had been made too late to appear on the bank statement. c. The bank collected $24,075 on a $2,500 note, including interest of $1,575. d. A check for $1,800 returned with the statement had been incorrectly recorded by Pala Medical Co. as $180. The check was for the payment of an obligation to Skyline Supply Co. for a purchase on account. e. A check drawn for $390 had been erroneously charged by the bank as $930. f. Bank service charges for June amounted to $50. Instructions 1. Prepare a bank reconciliation. Refer to the Amount Descriptions list provided for the exact wording of the answer choices for…
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 $14,720. Cash balance according to the bank statement at July 31, $15,730. Checks outstanding, $2,990. Deposit in transit, not recorded by bank, $2,400. A check for $270 in payment of an account was erroneously recorded in the check register as $720. Bank debit memo for service charges, $30. a. Prepare a bank reconciliation, using the format shown in
Using the following information: The bank statement balance is $5,289. The cash account balance is $5,764. Outstanding checks amounted to $751. Deposits in transit are $1,174. The bank service charge is $43. A check for $71 for supplies was recorded as $62 in the ledger. Prepare a bank reconciliation for Candace Co. for May 31. Candace Co.Bank ReconciliationMay 31 Cash balance according to bank statement $fill in the blank 1 Adjustments: $fill in the blank 3 fill in the blank 5 Total adjustments fill in the blank 6 Adjusted balance $fill in the blank 7 Cash balance according to company's records $fill in the blank 8 Adjustments: $fill in the blank 10 fill in the blank 12 Total adjustments fill in the blank 13 Adjusted balance $fill in the blank 14
The following data were accumulated for use in reconciling the bank account of Nakajima Co. for July: 1. Cash balance according to the company’s records at July 31, $49,910. 2. Cash balance according to the bank statement at July 31, $48,250. 3. Checks outstanding, $4,460. 4. Deposit in transit, not recorded by bank, $6,450. 5. A check for $590 issued in payment of an account was erroneously recorded in the check register as $950. 6. Bank debit memo for service charges, $30. Required: Journalize the entry or entries that should be made by the company. Refer to the chart of accounts for the exact wording of the account titles. CNOW journals do not use lines for journal explanations. Every line on a journal page is used for debit or credit entries. CNOW journals will automatically indent a credit entry when a credit amount is entered. CHART OF ACCOUNTSNakajima Co.General Ledger ASSETS 110 Cash 111 Petty Cash 120 Accounts Receivable 131 Notes…
Prepare a bank reconciliation from the following information:a. Balance per bank statement as of May 31, $17,755.44b. Balance per books as of May 31, $12,211.94c. Deposits in transit, $2,254.81d. Outstanding checks, $7,819.16e. Bank service charge, $20.85
The following information is available to reconcile Branch Company's book balance of cash with its bank statement cash balance as of July 31. a. On July 31, the company's Cash account has a $25,127 debit balance, but its July bank statement shows a $27,260 cash balance. b. Check Number 3031 for $1,420, Check Number 3065 for $486, and Check Number 3069 for $2,188 are outstanding checks as of July 31. c. Check Number 3056 for July rent expense was correctly written and drawn for $1,290 but was erroneously entered in the accounting records as $1,280. d. The July bank statement shows the bank collected $9,000 cash on a note for Branch. Branch had not recorded this event before receiving the statement. e. The bank statement shows an $805 NSF check. The check had been received from a customer, Evan Shaw. Branch has not yet recorded this check as NSF. f. The July statement shows a $14 bank service charge. It has not yet been recorded in miscellaneous expenses because no previous notification…