For this assignment, imagine you are the accountant for Floral Design Company and are assigned to prepare the monthly bank reconciliation. Complete this task, by using the data below:

1. Complete the bank reconciliation for the month of June.
2. Prepare the journal entries required by the reconciliation.
Floral Design Company’s bank statement for June shows the following data:
• Balance on June 1 $12,350.
• NSF check $175.
• Balance on June 30 $14,280.
• Collection of note receivable $505.
The cash balance per books at June 30, was $13,292. Your review of the data reveals the following:
1. The NSF check was from Bobble Co, a customer.
2. The note collected by the bank was a $500 note with $5 interest.
3. Outstanding checks at June 30 total $2410.
4. Deposits in transit at June 30 total $1752.

To complete the bank reconciliation for the month of June for Floral Design Company, follow these steps:

Step 1: Start with the bank statement information
- The bank statement balance on June 1 is $12,350.
- There was an NSF (non-sufficient funds) check from Bobble Co for $175.
- The bank statement balance on June 30 is $14,280.
- There was a collection of a note receivable for $505.

Step 2: Identify the cash balance per books
- The cash balance per books at June 30 is $13,292.

Step 3: Analyze the data and make adjustments

a) NSF check:
- The NSF check of $175 needs to be deducted from the cash balance per books since it was not honored by the bank.
- Deduct $175 from the cash balance per books.

b) Note collection:
- The collection of the note receivable was for $505, which includes both the principal amount ($500) and the interest ($5).
- Add $505 to the cash balance per books.

Step 4: Consider outstanding checks and deposits in transit

a) Outstanding checks:
- Outstanding checks are checks that have been issued by the company but have not yet cleared the bank.
- The outstanding checks at June 30 total $2,410.
- Deduct $2,410 from the cash balance per books.

b) Deposits in transit:
- Deposits in transit are cash receipts that have been recorded by the company but have not yet been deposited in the bank.
- The deposits in transit at June 30 total $1,752.
- Add $1,752 to the cash balance per books.

Step 5: Calculate the adjusted cash balance per books
- Start with the cash balance per books at June 30: $13,292.
- Deduct NSF check: -$175.
- Add note collection: +$505.
- Deduct outstanding checks: -$2,410.
- Add deposits in transit: +$1,752.
- Calculate the adjusted cash balance per books.

Adjusted cash balance per books = $13,292 - $175 + $505 - $2,410 + $1,752

Step 6: Compare the adjusted cash balance per books with the bank statement balance
- The adjusted cash balance per books should match the bank statement balance on June 30, which is $14,280.

Step 7: Prepare the journal entries required by the reconciliation
- The journal entries will depend on the specific adjustments made in Step 3 and Step 4.
- For example, the NSF check may require a journal entry to record the bad debt or adjustment to accounts receivable.
- The note collection may require a journal entry to record the increase in cash and reduction of a note receivable.
- The outstanding checks and deposits in transit may not require journal entries if they have already been recorded.

Please note that the specific journal entries required would need to be determined based on the individual transactions and the accounts affected in Floral Design Company's accounting system.