EM4.7 Match Bank Transactions Checking Mookie The Beagle Concierge has downloaded the following Checking account transactions in spreadsheet form (csv file). MTE needs to upload these bank transactions into QBO and then match them against QBO transactions previously entered. QEO 3E E47 Checking csx Required: 1. First, download the csv file containing the checking transaction information from the bank. 1. First, download the csv file containing the checking transaction information from the bank. - If you are using Connect, select the link for the data file: QBO 3E E4.7 Checking.csv. - If you are not using Connect, go to www.my-quickbooksonline.com > select QBO 3 e link > scroll down to QAO Data Files > select link to downioad QBO 3 E E4.7 Checking.csv. 2. Uplond Checking Account Transactions to QBO. a. From the Navigation Bor, select Banking > Banking tab b. Select the Link account drop-down arrow > select Upload from file c. Select Drag and drop or select files to select the file to upload > select File: OBO 3E E4.7 Checking.csv > Continue d. Select QuickBooks Account: 1001 Checking > Continue e. Select is the first row in your file a header? Yes t. Select How many columns show amounts? One column 9. Select What's the date format used in your file? MM/dd/yyy h. Select Date: Column 2: Transaction Date 1. Select Description: Column 4 Description 1. Select Amount. Column 5 Amount k. Select Continue 1. Select The transactions to Importi Select All > Continue 1. select Amount: Lorumn D amount k. Select Continue 1. Select The transactions to import: Select All > Continue m. When asked, Do you want to import now?, select Yes n. When import completed appears, select Done o. How many transactions were imported? Note: Answer this question in the table shown below. Round your answer to the nearest dollar amount. 3. Complete a Checking Account Bank Match. a. From the Navigation Bar, select Banking b. 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. c. Select Match for all Matching items d. Now how mariv oben items appear on the Checkina card at the top of the screen? 3. Complete a Checking Account Bank Match. a. From the Navigation Bar, select Banking b. 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. c. Select Match for all Matching items d. 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. EM4.7 Match Bank Transactions Checking Mookie The Beagle Concierge has downloaded the following Checking account transactions in spreadsheet form (csv file). MTE needs to upload these bank transactions into QBO and then match them against QBO transactions previously entered. QEO 3E E47 Checking csx Required: 1. First, download the csv file containing the checking transaction information from the bank. 1. First, download the csv file containing the checking transaction information from the bank. - If you are using Connect, select the link for the data file: QBO 3E E4.7 Checking.csv. - If you are not using Connect, go to www.my-quickbooksonline.com > select QBO 3 e link > scroll down to QAO Data Files > select link to downioad QBO 3 E E4.7 Checking.csv. 2. Uplond Checking Account Transactions to QBO. a. From the Navigation Bor, select Banking > Banking tab b. Select the Link account drop-down arrow > select Upload from file c. Select Drag and drop or select files to select the file to upload > select File: OBO 3E E4.7 Checking.csv > Continue d. Select QuickBooks Account: 1001 Checking > Continue e. Select is the first row in your file a header? Yes t. Select How many columns show amounts? One column 9. Select What's the date format used in your file? MM/dd/yyy h. Select Date: Column 2: Transaction Date 1. Select Description: Column 4 Description 1. Select Amount. Column 5 Amount k. Select Continue 1. Select The transactions to Importi Select All > Continue 1. select Amount: Lorumn D amount k. Select Continue 1. Select The transactions to import: Select All > Continue m. When asked, Do you want to import now?, select Yes n. When import completed appears, select Done o. How many transactions were imported? Note: Answer this question in the table shown below. Round your answer to the nearest dollar amount. 3. Complete a Checking Account Bank Match. a. From the Navigation Bar, select Banking b. 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. c. Select Match for all Matching items d. Now how mariv oben items appear on the Checkina card at the top of the screen? 3. Complete a Checking Account Bank Match. a. From the Navigation Bar, select Banking b. 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. c. Select Match for all Matching items d. 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