VitalSource QuickBooks Exercises 10

.docx

School

Penn Foster College *

*We aren’t endorsed by this school

Course

ACC215201

Subject

Accounting

Date

Apr 3, 2024

Type

docx

Pages

14

Uploaded by MagistratePencilMeerkat36

Report
Vi talSource QuickBooks Exercises 10 Exercises 10 E 10.1 Accounting Cycle Match the following accounting cycle steps with the appropriate description. Accounting Cycle Descriptions a. b. Prepared at the end of the accounting period before preparing financial statements to bring the accounts up to date. Prepared during the accounting period to record exchanges with customers, vendors, employees, and owners. A list of all accounts used to accumulate information about assets, liabilities, owners’ equity, revenues, and expenses. Prepared for external users and includes the Profit and Loss, Balance Sheet, and Statement of Cash Flows. Prepared after adjustments to verify that the accounting system still balances. Lists each account and the account balance at the end of the accounting period to verify that the accounting system is in balance—total debits should equal total credits. Accounting Cycle Steps Accounting Cycle Descriptions 1. Chart of Accounts 2. Transactions 3. Trial Balance 4_Adjustments 5. Adjusted Trial Balance 6. Financial Statements EM10.2 For the following accounts on Mookie The Beagle Concierge Trial Balance, identify Account Type and Financial Statement on which it appears. Account Types « Asset « Liability « Equity « Income « Expense Financial Statements « Balance Sheet « Profit and Loss
Account Sales Money Market Accounts Receivable (A/R) Rent & Lease Prepaid Expenses: Supplies Loan Payable Inventory Asset Opening Balance Equity Utilities Expense 10. Undeposited Funds 11, Accounts Payable (A/P) 12, VISA Credit Card 13, Prepaid Expenses: Insurance 14 Interest Payable 15 Sales of Product Income 16 Legal & Professional 17, Advertising & Marketing 18. Insurance: Renters Insurance Expense 19. Owner’s Investment 20. Checking 21, Unearned Revenue 22 Contractors 23. Cost of Goods Sold 24, Office Supplies & Software 25, Utilities Expense © P NO AW N Account Type
E10.3 Statement of Cash Flows For each of the following, identify the appropriate classification on the Statement of Cash Flows Statement of Cash Flows Classifications a. Cash Flows from Operating Activities b. Cash Flows from Investing Activities . Cash Flows from Financing Activities Statement of Cash Flows Activity Classification 1. Cash flows related to sales 2. Cash paid to repay a long-term loan 3. Cash flows related to purchasing inventory to resell 4. Cash flow from issuance of capital stock 5. Cash paid to purchase new equipment 6. Cash from sale of a warehouse EXCEL TEMPLATE (EM10.4 Through EM10.10) For your convenience to complete reports in Chapter 10 and Exercises 10, an Excel Template is provided with your text to organize your Excel reports. If you have not already downloaded the Excel Template, to access it, you have two options: 1. If you are using Connect with your text, the Excel Template can be downloaded from within Connect. 2. If you are not using Connect, go to www.my-quickbooksonline.com > select QBO 3e > QBO 3e Excel Templates > Download the Chapter 10 Excel Template. After downloading the Excel Template, select the Instructions sheet in the Excel Template to view the steps to copy your exported Excel reports to the Excel Template. EM10.4 Profit and Loss Statement Complete the following to prepare a Profit and Loss Statement for Mookie The Beagle Concierge using the custom report you saved in Chapter 10. 1. Create a Profit and Loss Statement. a. From the Navigation Bar, select Reports > Custom reports tab > Financial Statements > Profit and Loss b. Date Range: 01/01/2023 to 01/31/2023 2. What s the amount of Total Income (Revenue)?
3. What is amount of Total Expenses? 4. What is amount of Net Income? 5. Export the Profit and Loss Statement to PDF. 6. Export the Profit and Loss Statement to Excel a. With the Profit and Loss report displayed, select the Export icon b. Select Export to Excel . Complete the steps listed in the Instructions sheet of the Excel Template to copy your Profit and Loss Statement Excel export to the Excel Template. EM10.5 Balance Sheet Complete the following to prepare a Balance Sheet for Mookie The Beagle Concierge using the custom report you saved in Chapter 10. 1 2 3 Create a Balance Sheet. a. From the Navigation Bar, select Reports > Custom reports tab > Financial Statements > Balance Sheet b. Date Range: 01/31/2023 to 01/31/2023> page 531 On the Balance Sheet, what are Total Assets? On the Balance Sheet, what are Total Liabilities? 4. Export the Balance Sheet to PDF. 5. Export the Balance Sheet to Excel a. With the Balance Sheet report displayed, select the Export icon b. Select Export to Excel c. Complete the steps listed in the Instructions sheet of the Excel Template to copy your Balance Sheet Excel export to the Excel Template. EM10.6 Statement of Cash Flows Complete the following to prepare a Statement of Cash Flows for Mookie The Beagle Concierge using the custom report you saved in Chapter 10 1 LS Create a Statement of Cash Flows. a. From the Navigation Bar, select Reports > Custom reports tab > Financial Statements > Statement of Cash Flows b. Date Range: 01/01/2023 to 01/31/2023 On the Statement of Cash Flows, what is the Net Cash Provided by Operating Activities? On the Statement of Cash Flows, what is the Net Cash Provided by Investing Activities? On the Statement of Cash Flows, what is the Net Cash Provided by Financing Activities? What was Cash at the end of the period?
6. Export the Statement of Cash Flows to PDF. 7. Export the Statement of Cash Flows to Excel a. With the Statement of Cash Flows report displayed, select the Export icon b Select Export to Excel c. Complete the steps listed in the Instructions sheet of the Excel Template to copy your Statement of Cash Flows Excel export to the Excel Template. EM10.7 Accounts Receivable (A/R) Aging Complete the following to prepare an Accounts Receivable (A/R) Aging report for Mookie The Beagle Concierge using the custom report you saved in Chapter 10. 1. Create Accounts Receivable (A/R) Aging Report a. From the Navigation Bar, select Reports > Custom reports tab > Customer Reports > AR Aging Summary b. Date Range: 01/31/2023 2. On the Accounts Receivable (A/R) Aging Summary, what is the amount of A/R that is Current? 3. Onthe AR Aging Summary, what is the amount of AR that is 1-30 days pastdue? “page 532 4. Export the Accounts Receivable (A/R) Aging Summary to PDF. 5. Export the Accounts Receivable (A/R) Aging Summary to Excel. a. With the Accounts Receivable (A/R) Aging Summary report displayed, select the Export icon b. Select Export to Excel . Complete the steps listed in the Instructions sheet of the Excel Template to copy your Accounts Receivable (A/R) Aging Summary Excel export to the Excel Template. EM10.8 Accounts Payable (AP) Aging Complete the following to prepare an Accounts Payable (A/P) Aging report for Mookie The Beagle Concierge using the custom report you saved in Chapter 10. 1. Create Accounts Payable (A/P) Aging Report a. From the Navigation Bar, select Reports > Custom reports tab > Vendor Reports > A/P Aging Summary b. Date Range: 01/31/2023 On the Accounts Payable (A/P) Aging Summary Report, what is the amount of A/P that is Current? On the A/P Aging Summary, what is the amount of A/P that is 1-30 days past due? On the A/P Aging Summary, what is the amount of A/P that is 31-60 days past due? Export the Accounts Payable (A/P) Aging Summary to PDF. o o s W N Export the Accounts Payable (A/P) Aging Summary to Excel a. With the Accounts Payable (A/P) Aging Summary report displayed, select the Export icon b Select Export to Excel
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help