Question

In: Accounting

This information relates to the Cash account in the ledger of Oriole Company.           Balance September 1—$17,190;...

This information relates to the Cash account in the ledger of Oriole Company.

          Balance September 1—$17,190; Cash deposited—$64,000
          Balance September 30—$18,390; Checks written—$62,800

The September bank statement shows a balance of $17,290 at September 30 and the following memoranda.

Credits

Debits

Collection of electronic funds transfer $2,130 NSF check: H. Kane $860
Interest earned on checking account 60 Safety deposit box rent 75


At September 30, deposits in transit were $5,053 and outstanding checks totaled $2,698.

Prepare the bank reconciliation at September 30, 2017. (List items that increase balance as per bank & books first.)

ORIOLE COMPANY
Bank Reconciliation

                                                                      September 30, 2017For the Year Ended September 30, 2017For the Month Ended September 30, 2017

                                                                      NSF checkElectronic funds transfer receivedCash balance per bank statementSafety deposit box rentOutstanding checksInterest earnedDeposits in transitAdjusted cash balance per bank

$

                                                                      LessAdd:                                                                       Interest earnedOutstanding checksDeposits in transitElectronic funds transfer receivedAdjusted cash balance per bankCash balance per bank statementNSF checkSafety deposit box rent
                                                                      AddLess:                                                                       Electronic funds transfer receivedDeposits in transitOutstanding checksCash balance per bank statementAdjusted cash balance per bankNSF checkSafety deposit box rentInterest earned
                                                                      Interest earnedOutstanding checksElectronic funds transfer receivedAdjusted cash balance per bankSafety deposit box rentCash balance per bank statementDeposits in transitNSF check

$

                                                                      Electronic funds transfer receivedAdjusted cash balance per booksSafety deposit box rentOutstanding checksInterest earnedNSF checkDeposits in transitCash balance per books

$

                                                                      LessAdd:
                                                                      Safety deposit box rentNSF checkOutstanding checksCash balance per booksElectronic funds transfer receivedDeposits in transitAdjusted cash balance per booksInterest earned

$

                                                                      Deposits in transitOutstanding checksCash balance per booksSafety deposit box rentElectronic funds transfer receivedAdjusted cash balance per booksNSF checkInterest earned
                                                                      AddLess:
                                                                      Adjusted cash balance per booksDeposits in transitNSF checkElectronic funds transfer receivedSafety deposit box rentOutstanding checksInterest earnedCash balance per books
                                                                      Cash balance per booksOutstanding checksAdjusted cash balance per booksNSF checkInterest earnedDeposits in transitSafety deposit box rentElectronic funds transfer received
                                                                      Safety deposit box rentElectronic funds transfer receivedOutstanding checksNSF checkCash balance per booksAdjusted cash balance per booksDeposits in transitInterest earned

$

eTextbook and Media

List of Accounts

Prepare the adjusting entries at September 30, assuming the NSF check was from a customer on account. (Credit account titles are automatically indented when amount is entered. Do not indent manually.)

Date

Account Titles and Explanation

Debit

Credit

Sept. 30
(To record electronic funds transfer received by bank)
Sept. 30
(To record Interest earned on checking account)
Sept. 30
(To record NSF check)
Sept. 30

(To record charges for safety deposit box rent)

Solutions

Expert Solution

Bank Reconciliation

Cash balance, as per bank statement, September 30

17,290

Add: Deposit in transit

5,053

22,343

Less: Outstanding checks

- 2,698

Adjusted cash balance

$19,645

Balance as per Company's record, September 30

18,390

Add:

Electronic fund transfer

2,130
Interest earned 60 2,190
20,580
Less:

NSF check

- 860

Safety deposit box rent

- 75

- 935

Adjusted cash balance

$19,645

Journal

Date

Account Titles and Explanation

Debit

Credit

Sept. 30 Cash 2,130
Accounts receivable 2,130
(To record electronic funds transfer received by bank)
Sept. 30 Cash 60
Interest revenue 60
(To record Interest earned on checking account)
Sept. 30 Accounts receivable - H. Kane 860
Cash 860
(To record NSF check)
Sept. 30 Safety deposit box rent 75
Cash 75

(To record charges for safety deposit box rent)


Related Solutions

This information relates to the Cash account in the ledger of Cullumber Company.           Balance September 1—$20,340;...
This information relates to the Cash account in the ledger of Cullumber Company.           Balance September 1—$20,340; Cash deposited—$64,000           Balance September 30—$21,540; Checks written—$62,800 The September bank statement shows a balance of $20,440 at September 30 and the following memoranda. Credits Debits Collection from customer of electronic funds transfer $2,460 NSF check: H. Kane $1,190 Interest earned on checking account 65 Safety deposit box rent 80 At September 30, deposits in transit were $5,388 and outstanding checks totaled $3,033. 1. Prepare...
The information relates to the Cash Account in the ledger of Covid Company : Balance June...
The information relates to the Cash Account in the ledger of Covid Company : Balance June 1 $7,150 ; cash deposited $64,000; Balance June 30 $17,404 ; checks written $63,746. The June bank statement shows a balance of $16,122 on June 30. The following are memoranda from bank : Collection of $1,500 note plus interest $30; Interest earned on checking account $45; NSF check from Violet Jones $725; Safety deposit box rent $65. At June 30, deposits in transit were...
On September 1, the balance of the Accounts Receivable control account in the general ledger of...
On September 1, the balance of the Accounts Receivable control account in the general ledger of Montgomery Company was $10,600. The beginning balances are posted to each subsidiary account below From the sales journal, transactions are: Sales to Sogard $740, to Hurley $1,160, to Giambi $1,350, and to Fowler $1,240. From the cash receipts journal, transactions are: Cash received from Fowler $1,290, from Sogard $2,320, from Giambi $280, from Andino $1,630, and from Hurley $1,100 From the general journal, transactions...
On September 1, the balance of the Accounts Receivable control account in the general ledger of...
On September 1, the balance of the Accounts Receivable control account in the general ledger of Montgomery Company was $10,960. The customers’ subsidiary ledger contained account balances as follows: Hurley $1,440, Andino $2,640, Fowler $2,060, and Sogard $4,820. At the end of September, the various journals contained the following information. Sales journal: Sales to Sogard $800, to Hurley $1,260, to Giambi $1,330, and to Fowler $1,600. Cash receipts journal: Cash received from Fowler $1,310, from Sogard $3,300, from Giambi $380,...
On September 1, the balance of the Accounts Receivable control account in the general ledger of...
On September 1, the balance of the Accounts Receivable control account in the general ledger of Montgomery Company was $10,520. The customers’ subsidiary ledger contained account balances as follows: Hurley $1,450, Andino $2,290, Fowler $2,080, and Sogard $4,700. At the end of September, the various journals contained the following information. Sales journal: Sales to Sogard $750, to Hurley $1,100, to Giambi $1,360, and to Fowler $1,120. Cash receipts journal: Cash received from Fowler $1,370, from Sogard $2,130, from Giambi $330,...
On 1 September the balance of the Accounts Receivable control account in the general ledger of...
On 1 September the balance of the Accounts Receivable control account in the general ledger of Whelan Company was $11 960. The customer's subsidiary ledger contained account balances as follows: Jana $2 440, Kingston $2 640, Johnson $2 060, Phillips $4 820. At the end of September the various journals contained the following information. Sales journal: Sales to Phillips $800; to Jana $1 260; to Simons $1 030; to Johnson $1 100. Cash receipts journal: Cash received from Johnson $1...
The Cash account in the general ledger of Lyco Corporation showed a balance of $21,749 at...
The Cash account in the general ledger of Lyco Corporation showed a balance of $21,749 at December 31 (but prior to performing a bank reconciliation). The company's bank statement showed a balance of $22,000 at the same date. The only reconciling items consisted of: (1) a $5,000 deposit in transit, (2) a bank service charge of $200, (3) outstanding checks totaling $9,000, (4) a $3,000 check marked "NSF" from Susque Company, one of Lyco's customers, and (5) a check written...
Marin Company’s general ledger indicates a cash balance of $22,840 as of September 30, 2021. Early...
Marin Company’s general ledger indicates a cash balance of $22,840 as of September 30, 2021. Early in October Marin received a bank statement indicating that during September Marin had an NSF check of $2,000 returned to a customer and incurred service charges of $70. Marin also learned it had incorrectly recorded a check received from a customer on September 15 as $900 when in fact the check was for $990. Calculate Marin’s correct September 30, 2021, cash balance.Marin Company’s general...
Following information relates to Acco Co. Beginning cash balance on July 1: $45,000. Cash receipts from...
Following information relates to Acco Co. Beginning cash balance on July 1: $45,000. Cash receipts from sales: 21% is collected in the month of sale, 50% in the next month, and 29% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual), $1,548,000; June (actual), $1,080,000; and July (budgeted), $1,260,000. Payments on merchandise purchases: 42% in the month of purchase and 58% in the month following purchase. Purchases amounts are: June...
Following information relates to Acco Co. Beginning cash balance on July 1: $35,000. Cash receipts from...
Following information relates to Acco Co. Beginning cash balance on July 1: $35,000. Cash receipts from sales: 30% is collected in the month of sale, 50% in the next month, and 20% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual), $1,204,000; June (actual), $840,000; and July (budgeted), $980,000. Payments on merchandise purchases: 60% in the month of purchase and 40% in the month following purchase. Purchases amounts are: June...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT