Bank Account Reconciliation and Financial ReportsIn this exercise, you will reconcile the July 31, 2026, bank statement from Los Angeles City Bank in QuickBooks Online

Bank Account Reconciliation and Financial ReportsIn this exercise, you will reconcile the July 31, 2026, bank statement from Los Angeles City Bank in QuickBooks Online.Navigate to your Chapter 05 folder and open the CH05 LA City Bank Statement.pdf file.Reconcile the Los Angeles City Bank account.Prepare the Balance Sheet and Profit and Loss reports for July 31, 2026.Export both reports to Excel, saving them in your Chapter 05 folder as: CH05 Balance Sheet and CH05 Profit and LossReturn to the Los Angeles City Bank Register by choosing Banking and then clicking Go to Bank Register.Export the register to Excel and save it in your Chapter 05 folder as: CH05 Los Angeles City Bank RegisterIf your course is using Quick Grader, open the file in Excel and use Save As to convert the file from Excel 97-2003 Workbook format (.xls) to Excel Workbook format (.xlsx). Note that when using Save As in the Online app, the .xlsx format is applied by default. Return to the Dashboard.
CHECK FIGURE  Your figures should match those shown here:ACCOUNT BALANCESAccountBalanceLos Angeles City Bank$46,955.73City Credit Union$499.45Savings LACB$10,000STATEMENT BALANCESStatementBalanceTotal assets on balance sheet 7/31/2026$71,096.23Net loss on profit and loss statement 7/31/2026$-4,632.52

Apply Your Skills 5-4 (Balance Sheet) v2 Apply Your Skills 5-4 (Los Angeles City Bank Register) Apply Your Skills 5-4 (Profit and Loss)