Complete the Week $4$ Quickbooks Starting on Page $158$ using the attached Excel Template. Please submit this assignment in Canvas once complete. Week $4$ QBO Project $(2)$

$125\backslash \%$

View

Zoom

Add Category

Pivot Table

Insert

Table

Chart

Text

Shape

Media

Comment

Export Summary

INSTRUCTIONS

Chapter $2$ Reports List

LIST

Table $1$

Computer Accounting with QuickBooks Online, $4$e Donna Kay

Chapter $2$ Excel Template Instructions for Use with QBO $4$e Reports

Download Excel Template. From www$.$my$-$quickbooksonline.com $>$ QBO $4$e $\backslash (>\backslash )$ QBO $4$e Excel Templates, download the Chapter $2$ Excel Template. If you are using Connect, you can download the Chapter $2$ Excel Template from within Connect.

Rename the Excel Template File. Rename the Excel Template file: QBO $4$e Chapter $2$ Reports Your Name.xls $($or $.$xlsx$).$

Export QBO Report. Export your QBO reports to Excel following instructions in your text.

Copy Sheet to Excel Template and Update Name. From the open exported QBO Excel file, right$-$click on the sheet name $($Example: Trial Balance$)>$ Select Move or Copy $>$ Select to Book: QBO $4$e Chapter $2$ Reports Your Name.xls $>$ select Before Sheet $($or Move to End$)$ as needed so the sheet appears in the appropriate order $>$ Select Create a Copy $>$ Select OK$.$

Rename sheet to add the Item No$,$ such as P$2\mathrm{.}9$ Account List.

Verify Sheet Appears in Excel Template. Verify that the sheet has successfully been copied to the Excel Template.

Select Status as Done. On the Excel Template Reports List Sheet, from the drop$-$down Status menu, select Done for the sheet you added to the Excel Template.

Save Excel Template. To save the Excel Template after copying the new sheet, select Save icon or File $>$ Save.

Repeat. Repeat Steps $3$ through $7$ until all exported Excel Reports have been imported as Excel sheets into the Excel Template.

Upload to MHE Connect. If you are using MHE Connect, you can upload only $1$ file per chapter. If you are using MHE Connect for your QBO course, then you can upload to Connect your completed Chapter $2$ Excel Template that contains all your Chapter $2$ Excel reports. View

Zoom

Add Category

Pivot Table

Insert

Table

Chart

Text

Shape

Media

Comment

Export Summary

INSTRUCTIONS

Chapter $2$ Reports List

LIST