MetaLab #$6$

Due October $30,2023($submit to Brightspace dropbox$)$

Americauna Feathers Co$.$ opened an account at Empower FCU in June. The bank statement is dated June $30,2025$ and is seen below:

Empower Federal Credit Union

Company: Americauna Feathers Co$.$

Activity for June $2025$

Beginning Balance, June $1,2025$ $$-$

Deposits and other credits:

June $2$ $$40,000$

June $10600$

June $1820,000$

June $2030,000$

June $23$ EFT receipt from Ayam's Crafting Co$.750$

June $30$ Interest Revenue $75$

$91,425$

Checks and other debits:

June $2$ EFT Payment to Egg Co$.20$

June $5$ Check $2352,600$

June $9$ Check $237400$

June $9$ Check $2364,800$

June $26$ Check $2392,400$

June $28$ EFT Payment to Ceymani Co$.240$

June $29$ Check $240600$

June $30$ Bank service charge $60$

$(11,120)$

Ending Balance, June $30,2025$ $$80,305$

Important Notes for Later:

Ayam's Crafting Co$.$ is a customer that is making a payment on account.

Egg Co$.$ is a company that prints business checks $($which is a bank expense$)$ for Americauna.

Ceymani is a utility provider.

Ameriauna's cash account in the general ledger shows the following transactions for June:

Cash $-$ Empower FCU Checking

Balance $-$

June $2$ Deposit $40,0002,600$ June $2$ Check $235$

June $10$ Deposit $6004,800$ June $4$ Check $236$

June $18$ Deposit $20,000400$ June $5$ Check $237$

June $20$ Deposit $30,000100$ June $10$ Check $238$

June $30$ Deposit $1,9702,400$ June $21$ Check $239$

$600$ June $23$ Check $240$

$1,200$ June $29$ Check $241$

Balance June $3080,470$

Requirement: Prepare the bank reconciliation for June $30,2025.$ Include a proper heading and format. Use cell references and formulas whenever possible. Pages $819-821$ discuss how to create a bank reconciliation and include an example of how one may look.