Mookie The Beagle Concierge has downloaded the following Checking account transactions in spreadsheet form $($csv file$).$ MTB needs to upload these bank transactions into QBO and then match them against QBO transactions previously entered.

CHECKING

Type Transactions Date Post Date Description Amount

Expense $01/16/202401/18/2024$ XAFRA CYBER $720\mathrm{.}00$

Expense $01/13/202401/14/2024$ BICHOTTE SUPPLIES $198\mathrm{.}00$

Deposit $01/12/202401/13/2024$ CY WALKER LOAN $2000\mathrm{.}00$

Expense $01/10/202401/11/2024$ EVAN HENRY $1840\mathrm{.}00$

Expense $01/05/202401/06/2024$ CAROLE DESIGN MEDIA $2000\mathrm{.}00$

Deposit $01/01/202401/02/2024$ CY WALKER $40000\mathrm{.}00$

Deposit $01/01/202401/02/2024$ CY WALKER $20000\mathrm{.}00$

QBO $4$E EM$4\mathrm{.}6$ Checking.csv

Required:

First, download the csv file containing the checking transaction information from the bank, and save the file to your computer. You will upload this file into QBO.

If you are using Connect, select the link for the data file: QBO $4$E EM$4\mathrm{.}6$ Checking.csv$.$

If you are not using Connect, go to www$.$my$-$quickbooksonline.com $>$ select QBO $4$e $>$ QBO $4$e Data Files $>$ select link to download QBO $4$E EM$4\mathrm{.}6$ Checking.csv$.$

Upload Checking Account Transactions to QBO.

From the Navigation Bar, select Banking $>$ Banking tab

Select the Link account drop$-$down arrow $>$ select Upload from file

Select Drag and drop or select files to select the file to upload $>$ select File: QBO $4$E EM$4\mathrm{.}6$ Checking.csv $>$ Continue

Select QuickBooks Account: $1001$ Checking $>$ Continue

Select Is the first row in your file a header? Yes

Select How many columns show amounts? One column

Select What$$s the date format used in your file? MM$/$dd$/$yyyy

Select Date: Column $2$: Transaction Date

Select Description: Column $4$ Description

Select Amount: Column $5$ Amount

Select Continue

Select The transactions to import: Select All $>$ Continue

When asked, Do you want to import now?, select Yes

When Import completed appears, select Done

How many transactions were imported?

Note: Answer this question in the table shown below. Round your answer to the nearest dollar amount.

Complete a Checking Account Bank Match.

From the Navigation Bar, select Banking

How many open items appear on the Checking card at the top of the screen?

Note: Answer this question in the table shown below. Round your answer to the nearest dollar amount.

Select Match for all Matching items

Now how many open items appear on the Checking card at the top of the screen?

Note: Answer this question in the table shown below. Round your answer to the nearest dollar amount.

What is the balance In QuickBooks displayed on your Checking card at the top of the screen?

Note: Answer this question in the table shown below. Round your answer $2$ decimal places.