APPLY YOUR SKILLS 5-3

Work with Bank Feeds and Bank Rules

In this exercise, you will match all the green Match transactions, add a transaction, and set up a bank rule.

1. The bank feeds indicate that nine matching transactions are already in QuickBooks Online. Match all of them.
2. Set up a money out bank rule for the Sammy Gas; Automobile Expense account.
3. Add the Sammy Gas transaction to QuickBooks Online.

APPLY YOUR SKILLS 5-4 QG

Bank Account Reconciliation and Financial Reports

In this exercise, you will reconcile the July 31, 2026, bank statement from Los Angeles City Bank in QuickBooks Online.

1. Navigate to your Chapter 05 folder and open the CH05 LA City Bank Statement.pdf file.
2. Reconcile the Los Angeles City Bank account.
3. Prepare the Balance Sheet and Profit and Loss reports for July 31, 2026.
4. Export both reports to Excel, saving them in your Chapter 05 folder as:

CH05 Balance Sheet and CH05 Profit and Loss

1. Return to the Los Angeles City Bank Register by choosing Banking and then clicking Go to Bank Register.
2. Export the register to Excel and save it in your Chapter 05 folder as:

CH05 Los Angeles City Bank Register

If 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.

1. Return to the Dashboard.

CHECK FIGURE Your figures should match those shown here:

ACCOUNT BALANCES
Account	Balance
Los Angeles City Bank	$46,955.73
City Credit Union	$499.45
Savings LACB	$10,000

STATEMENT BALANCES
Statement	Balance
Total assets on balance sheet 7/31/2026	$71,096.23
Net loss on profit and loss statement 7/31/2026