a Chapter 4 Homework ayout References Mailings Review View Table Design Layout The cash records and bank statement for the month of May for Steal Magnolias Inc are shown below. Steal Magnolias Cash Account Records May 1, 2021, to May 31, 2021 Cash Balance Cash Balance May 1, 2021+Cash Receipts Cash Disbursements May 31, 2021 $5,370 $11,590 $11,680 $5,280 Cash Receipts Cash Disbursements Date Desc Amount Date Check# Desc. Amount 5/3 Sales $ 1,370 5/7 471 Legal fees $ 1,210 5/10 Sales 1,800 5/12 472 Property tax 1,580 5/17 Sales 2,430 5/15 473 Salaries 3,510 5/24 Sales 2,900 5/22 474 Advertising 1.410 5/31 Sales 3,090 5/30 475 Supplies 460 5/31 476 Salaries 3,510 $11,590 $ 11,680 Member FDIC 7772854360 May 31, 2021 Ending Balance May 31, 2021 $6,471 P.O. Box 162647 Wachovia Bank Safefore, AL 74830 We Watch Ova Ya (405) 369-CASH Account Holder: Steal Magnolias Account Number: 124 Laundering Way, Federal, PN 14834 Statement Date: Account Summary Beginning Balance Deposits and Credits Withdrawals and Debits May 1, 2021 NO Total NO. Total $6,170 7 $9.672 9 $9,371 Account Details Deposits and Credits Withdrawals and Debits Date Amount Desc Date No. Amount Desc 5/4 $ 1,370 DEP 5/1 469 $ 460 CHK 5/11 1,800 DEP 5/2 470 340 CHK 5/18 2.430 DEP 5/9 471 1,210 5/20 CHK 1,100 NOTE 5/11 310 NSF 5/20 INT 5/12 472 1,500 CHK 5/25 2,900 DEP 5/18 473 3,510 CHK 5/31 21 INT 5/20 510 EFT 5/25 474 1,410 CHK 5/31 41 SF $ 9,672 $9,371 51 Daily Balance Date Amount 5/1 $ 5,710 5/2 5,370 5/4 6,740 5/9 5,530 5/11 7,020 5/12 5,440 5/18 4,360 5/20 5,001 5/25 6,491 5/31 $ 6,471 ted States Focus Chapter 4 Homework out References Mailings Review View Table Design Layout Desc DEP Customer deposit INT Interest earned SF Service fees NOTE Note collected CHK Customer check NSF Nonsufficient funds EFT Electronic funds transfer Additional information: a. The difference in the beginning balances in the company's records and the bank statement relates to checks #469 and #470, which are outstanding as of April 30, 2021 (prior month). b. The bank made the EFT on May 20 in error. The bank accidentally charged Steal Magnolias for payment that should have been made on another account. Steal Magnolias Bank Reconciliation May 31, 2021 Company's Cash Balance Per general ledger Bank's Cash Balance Per bank statement Bank balance per reconciliation Company balance per reconciliation Caporal lournal Dahil ted States) Credit Focus Chapter 4 Homework Table Design Layout ayout References Mailings Review View Date General Journal Debit Credit Identify each of the following as to the type of cash flow and whether it is an inflow or outflow: Operating (O), Financing (F). Investing (1), or Not a cash flow Inflow (1), Outflow (O), or item (N) Neither (N) Cash paid to vendors/suppliers Cash received from obtaining a bank loan I Salaries paid Purchased supplies on account Cash collected from customers Purchase of computer paid for with a check Issued stock to investors for cash Sold inventory on account Monthly car payment ited States) Focus
