Question
On July 31, 2022, Crane Company had a cash balance per books of $6,101.90. The statement from Dakota State Bank on that date showed a
On July 31, 2022, Crane Company had a cash balance per books of $6,101.90. The statement from Dakota State Bank on that date showed a balance of $7,734.70. A comparison of the bank statement with the Cash account revealed the following facts.
1. | The bank service charge for July was $25. | ||
2. | The bank collected $1,660.00 for Keeds Company through electronic funds transfer. | ||
3. | The July 31 receipts of $1,232.50 were not included in the bank deposits for July. These receipts were deposited by the company in a night deposit vault on July 31. | ||
4. | Company check No. 2480 issued to L. Taylor, a creditor, for $382 that cleared the bank in July was incorrectly entered as a cash payment on July 10 for $328. | ||
5. | Checks outstanding on July 31 totaled $1,863.30. | ||
6. | On July 31, the bank statement showed an NSF charge of $579.00 for a check received by the company from W. Krueger, a customer, on account. |
(a)
Prepare the bank reconciliation as of July 31. (List items that increase cash balance first. Round answers to 2 decimal places, e.g., 1,245.25.)
CRANE COMPANY Bank Reconciliation choose the accounting period For the Month Ended July 31, 2022For the Year Ended July 31, 2022July 31, 2022 | |||||
---|---|---|---|---|---|
select an opening name for section one Cash Balance Per Bank StatementDeposits in TransitOutstanding ChecksAdjusted Cash Balance Per BankElectronic Funds Transfer ReceivedNSF CheckBank Service ChargeError in Recording Check No.2480 | $enter a dollar amount | ||||
select between addition and deduction AddLess: | select a reconciling item Cash Balance Per Bank StatementDeposits in TransitOutstanding ChecksAdjusted Cash Balance Per BankElectronic Funds Transfer ReceivedNSF CheckBank Service ChargeError in Recording Check No.2480 | enter a dollar amount | |||
enter a subtotal of the two previous amounts | |||||
select between addition and deduction AddLess: | select a reconciling item Cash Balance Per Bank StatementDeposits in TransitOutstanding ChecksAdjusted Cash Balance Per BankElectronic Funds Transfer ReceivedNSF CheckBank Service ChargeError in Recording Check No.2480 | enter a dollar amount | |||
select a closing name for section one Cash Balance Per Bank StatementDeposits in TransitOutstanding ChecksAdjusted Cash Balance Per BankElectronic Funds Transfer ReceivedNSF CheckBank Service ChargeError in Recording Check No.2480 | $enter a total amount for section one | ||||
select an opening name for section two Cash Balance Per BooksDeposits in TransitOutstanding ChecksAdjusted Cash Balance Per BooksElectronic Funds Transfer ReceivedNSF CheckBank Service ChargeError in Recording Check No.2480 | $enter a dollar amount | ||||
select between addition and deduction AddLess: | select a reconciling item Cash Balance Per BooksDeposits in TransitOutstanding ChecksAdjusted Cash Balance Per BooksElectronic Funds Transfer ReceivedNSF CheckBank Service ChargeError in Recording Check No.2480 | enter a dollar amount | |||
enter a subtotal of the two previous amounts | |||||
select between addition and deduction AddLess: | |||||
select a reconciling item Cash Balance Per BooksDeposits in TransitOutstanding ChecksAdjusted Cash Balance Per BooksElectronic Funds Transfer ReceivedNSF CheckBank Service ChargeError in Recording Check No.2480 | enter a dollar amount | ||||
select a reconciling item Cash Balance Per BooksDeposits in TransitOutstanding ChecksAdjusted Cash Balance Per BooksElectronic Funds Transfer ReceivedNSF CheckBank Service ChargeError in Recording Check No.2480 | enter a dollar amount | ||||
select a reconciling item Cash Balance Per BooksDeposits in TransitOutstanding ChecksAdjusted Cash Balance Per BooksElectronic Funds Transfer ReceivedNSF CheckBank Service ChargeError in Recording Check No.2480 | enter a dollar amount | ||||
enter a subtotal of the three previous amounts | |||||
select a closing name for section two Cash Balance Per BooksDeposits in TransitOutstanding ChecksAdjusted Cash Balance Per BooksElectronic Funds Transfer ReceivedNSF CheckBank Service ChargeError in Recording Check No.2480 | $enter a total amount for section two |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started