VitalSource QuickBooks Exercises 10
.docx
keyboard_arrow_up
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
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
Related Questions
Question 3
Specify what data you think should be collected on each of the following four documents: sales invoice, purchase order, receiving report, employee time card
arrow_forward
42
arrow_forward
Question 11
A statement listing customers, account balances, and total amount due from all
customers is a/an:
Accounts payable ledger.
Accounts receivable ledger.
Schedule of accounts payable.
O Schedule of accounts receivable.
arrow_forward
Multiple choice
arrow_forward
PDE IM-MODULE-3-Account X
file:///C:/Users/user/Documents/QUIJANO,%20JAN%20CLEO%20C/ACCOUNTING/IM-MODULE-3-Accounting-Fundamentals-P1-M.Chan%20(1).pdf
M3 - Exercises 2
For each of the following accounts, state in column A the classification of the
account (Whether the account is an asset, liability, capital, revenue, or
expense), in Column B if debit or credit for increase in the account and in
column C if debit or credit for decrease, and in column D, the normal balance
of the account.
Column
D.
Coluinn
Column
Column
C
A
Normal
Classification
Increase
Decrease
balance
Example: Utilities Expense
Еxpense
Debit
Credit
Debit
1. Accounts Payable
2. Accounts Receivable
3. Cash
4. Carlo Calma, Capital
| 5. Carlo Calma, Drawing
6. Commission Income
7. Equipment
8. Interest Receivable
9. Insurance Expense
10. Notes Payable
11. Notes Receivable
12. Prepaid Rent
13. Prepaid Insurance
14. Rent Expense
15. Rent Revenue
16. Salaries Expense
17. Salaries Payable
18. Service Revenue
19. Supplies
20.…
arrow_forward
Identify Transactions in Accounts Receivable Subsidiary Ledger
The debits and credits from three related transactions are presented in the following customer's account taken from the accounts receivable subsidiary ledger:
Mission Design
NAME
1319 Elm Street
ADDRESS
Post. Ref.
Date
Item
Debit
Credit
Balance
20Υ7
Apr. 3
R44
740
740
Apr. 6
J11
60
680
Apr. 24
CR81
680
Describe each transaction and identify the source of each posting.
Describe each transaction
Identify the source
Apr. 3
Apr. 6
Apr. 24
arrow_forward
In Chapter 11, the first step of the computer accounting cycle is to:
Question 26 options:
Post entries to the general ledger
Set up a business and select a chart of accounts
Journalize entries
Change accounting periods
Print the general ledger trial balance
arrow_forward
Multiple choice
arrow_forward
Activity 1:
Journalize the following transactions and then post them to the General Ledger.
Below are the transactions of Juan Manuell Enterprises for the month of May 2018.
Maу 3
Mr. Manuell invested P500,000 cash.
May 5
Purchases from Big Dipper Merchants P50,000 merchandise. Terms: 3/10, n/20.
May 6
Sold merchandise to Gemini Enterprises, P32,000. Terms: 2/10, n/30.
59
63 / 164
Мay 9
Purchased office supplies from Galaxy Co. for cash, P3,000 through Check No.
0031.
May 11
Gemini Enterprises settled its account in full. Issued OR#10241
Purchased merchandise from Polaris Trading, P55,000. Terms: P25,000 down
payment, balance on account. Terms: 2/10, n/30. Check No. 0032.
May 16
Purchased merchandise from Aurora Borealis Systems, P201,600. Terms: 2/10,
n/30.
May 25
May 26
Sold to Virgo Enterprises P150,000 worth of merchandise. Terms: 2/10, n/30.
Мay 30
Purchases from Meteor Trading P80,000. Terms: 2/15, n/30.
Procedures:
1. Analyze the given transactions.
2. Journalize each…
arrow_forward
Indicate the sequential order of the following steps in the
accounting information processing cycle:
Analyzing transactions
Preparing financial statements
Developing a trial balance
Collecting original data
Posting to the accounts
Journalizing transactions
16.
17.
18.
19.
20.
21.
arrow_forward
Activity 5. My Own Accountin Equation
Applying the accounting equation to your daily ife as a student and consumer, write
your transactions made on a day to day basis and analyse the offects of each
vansaction to the different accounting accounts
TRANSACTION
ASSETS
LIABILITIES
OWNER'S
EQUITY
arrow_forward
Create a schedule of accounts receivable using the accounts receivable subsidiary ledger‘s.
arrow_forward
Multiple choice
arrow_forward
Make a general ledger for each account title from the general journal below.
arrow_forward
Top-Value Corporation has 242,000 shares of $30 par common stock outstanding. On September 2, Top-Value Corporation declared a 2% stock dividend to be issued
November 30 to stockholders of record on October 3. The market price of the stock was $55 per share on September 2.
Required:
Journalize the entries required on September 2, October 3, and November 30. If no entry is required, simply skip to the next transaction. Refer to
the chart of accounts for the exact wording of the account titles. CNOW journals do not use lines for journal explanations. Every line on a journal
page is used for debit or credit entries. CNOW journals will automatically indent a credit entry when a credit amount is entered.
arrow_forward
Question 6 of 20:
Select the best answer for the question.
6. To determine the effects of an entire accounting transaction, you would consult the accounting record called the
A. journal
O B. register.
C. T-account
O D. ledger
Mark for review (Will be highlighted on the review page)
<< Previous Question
Next Question
arrow_forward
Greg Thomas purchased one-half of lan Hamilton's interest in the Freidman and Hamilton partnership for $35,250. Prior to the investment, land was revalued to a market
value of $146,000 from a book value of $88,000. Adam Freidman and lan Hamilton share net income equally. Hamilton had a capital balance of $27,800 prior to these
transactions.
Required:
a. On December 31, provide the journal entry for the revaluation of land.*
b. On December 31, provide the journal entry to admit Thomas.*
arrow_forward
Question is attached in the screenshot thanks
grealty appreciated
420ti2492i409y490idf9ib0fi90i
arrow_forward
finalacial accounting
please give me the answer of this question thanks
arrow_forward
The
arrow_forward
Subject - account
Please help me.
Thankyou.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
College Accounting, Chapters 1-27 (New in Account...
Accounting
ISBN:9781305666160
Author:James A. Heintz, Robert W. Parry
Publisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Related Questions
- Question 3 Specify what data you think should be collected on each of the following four documents: sales invoice, purchase order, receiving report, employee time cardarrow_forward42arrow_forwardQuestion 11 A statement listing customers, account balances, and total amount due from all customers is a/an: Accounts payable ledger. Accounts receivable ledger. Schedule of accounts payable. O Schedule of accounts receivable.arrow_forward
- Multiple choicearrow_forwardPDE IM-MODULE-3-Account X file:///C:/Users/user/Documents/QUIJANO,%20JAN%20CLEO%20C/ACCOUNTING/IM-MODULE-3-Accounting-Fundamentals-P1-M.Chan%20(1).pdf M3 - Exercises 2 For each of the following accounts, state in column A the classification of the account (Whether the account is an asset, liability, capital, revenue, or expense), in Column B if debit or credit for increase in the account and in column C if debit or credit for decrease, and in column D, the normal balance of the account. Column D. Coluinn Column Column C A Normal Classification Increase Decrease balance Example: Utilities Expense Еxpense Debit Credit Debit 1. Accounts Payable 2. Accounts Receivable 3. Cash 4. Carlo Calma, Capital | 5. Carlo Calma, Drawing 6. Commission Income 7. Equipment 8. Interest Receivable 9. Insurance Expense 10. Notes Payable 11. Notes Receivable 12. Prepaid Rent 13. Prepaid Insurance 14. Rent Expense 15. Rent Revenue 16. Salaries Expense 17. Salaries Payable 18. Service Revenue 19. Supplies 20.…arrow_forwardIdentify Transactions in Accounts Receivable Subsidiary Ledger The debits and credits from three related transactions are presented in the following customer's account taken from the accounts receivable subsidiary ledger: Mission Design NAME 1319 Elm Street ADDRESS Post. Ref. Date Item Debit Credit Balance 20Υ7 Apr. 3 R44 740 740 Apr. 6 J11 60 680 Apr. 24 CR81 680 Describe each transaction and identify the source of each posting. Describe each transaction Identify the source Apr. 3 Apr. 6 Apr. 24arrow_forward
- In Chapter 11, the first step of the computer accounting cycle is to: Question 26 options: Post entries to the general ledger Set up a business and select a chart of accounts Journalize entries Change accounting periods Print the general ledger trial balancearrow_forwardMultiple choicearrow_forwardActivity 1: Journalize the following transactions and then post them to the General Ledger. Below are the transactions of Juan Manuell Enterprises for the month of May 2018. Maу 3 Mr. Manuell invested P500,000 cash. May 5 Purchases from Big Dipper Merchants P50,000 merchandise. Terms: 3/10, n/20. May 6 Sold merchandise to Gemini Enterprises, P32,000. Terms: 2/10, n/30. 59 63 / 164 Мay 9 Purchased office supplies from Galaxy Co. for cash, P3,000 through Check No. 0031. May 11 Gemini Enterprises settled its account in full. Issued OR#10241 Purchased merchandise from Polaris Trading, P55,000. Terms: P25,000 down payment, balance on account. Terms: 2/10, n/30. Check No. 0032. May 16 Purchased merchandise from Aurora Borealis Systems, P201,600. Terms: 2/10, n/30. May 25 May 26 Sold to Virgo Enterprises P150,000 worth of merchandise. Terms: 2/10, n/30. Мay 30 Purchases from Meteor Trading P80,000. Terms: 2/15, n/30. Procedures: 1. Analyze the given transactions. 2. Journalize each…arrow_forward
- Indicate the sequential order of the following steps in the accounting information processing cycle: Analyzing transactions Preparing financial statements Developing a trial balance Collecting original data Posting to the accounts Journalizing transactions 16. 17. 18. 19. 20. 21.arrow_forwardActivity 5. My Own Accountin Equation Applying the accounting equation to your daily ife as a student and consumer, write your transactions made on a day to day basis and analyse the offects of each vansaction to the different accounting accounts TRANSACTION ASSETS LIABILITIES OWNER'S EQUITYarrow_forwardCreate a schedule of accounts receivable using the accounts receivable subsidiary ledger‘s.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,College Accounting, Chapters 1-27 (New in Account...AccountingISBN:9781305666160Author:James A. Heintz, Robert W. ParryPublisher:Cengage LearningAccounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
College Accounting, Chapters 1-27 (New in Account...
Accounting
ISBN:9781305666160
Author:James A. Heintz, Robert W. Parry
Publisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning