The following is the six-column worksheet of the Drilon's Delivery Services prepared with errors. Analyze the given worksheet of the Drilon's Delivery Services for bril 2022. Answer the questions that follows Drilon's Delivery Services Worksheet For the month Ended April 30, 2021 Acct No. Particulars Trial Balance Balance Sheet Cr 101 Cash on Hand 105 Cash in Bank Accounts 110 Receivable-Sheila Ocampo Accounts 115 Receivable-Diether Mendoza 120 Office Equipment Delivery 125 Equipment Accounts Payable- 201 David Carreal Accounts Payable- 205 Ronald Amparo Cecille Drilon, 301 Capital Cecille Drilon, 302 Drawings 401 Delivery Revenue 501 Delivery Expense Maintenance 505 Expense 510 Rent Expense 515 Utilities Expense Total Net Income/Net Loss Total Dr 1112500 1200000 145500 42000 300050 20000 58000 7000 60450 70000 11500 3077200 Cr 14000 165000 2540000 308000 3077200 Income Statement Dr Cr 7000 60450 70000 11500 341000 341000 308000 308000 33000 341000 Dr 1112500 1200000 145500 42000 300050 20000 14000 165000 2540000 58000 3742500 3745800 3300 3745800 3745800

The following is the six-column worksheet of the Drilon's Delivery Services prepared with errors. Analyze the given worksheet of the Drilon's Delivery Services for bril 2022. Answer the questions that follows Drilon's Delivery Services Worksheet For the month Ended April 30, 2021 Acct No. Particulars Trial Balance Balance Sheet Cr 101 Cash on Hand 105 Cash in Bank Accounts 110 Receivable-Sheila Ocampo Accounts 115 Receivable-Diether Mendoza 120 Office Equipment Delivery 125 Equipment Accounts Payable- 201 David Carreal Accounts Payable- 205 Ronald Amparo Cecille Drilon, 301 Capital Cecille Drilon, 302 Drawings 401 Delivery Revenue 501 Delivery Expense Maintenance 505 Expense 510 Rent Expense 515 Utilities Expense Total Net Income/Net Loss Total Dr 1112500 1200000 145500 42000 300050 20000 58000 7000 60450 70000 11500 3077200 Cr 14000 165000 2540000 308000 3077200 Income Statement Dr Cr 7000 60450 70000 11500 341000 341000 308000 308000 33000 341000 Dr 1112500 1200000 145500 42000 300050 20000 14000 165000 2540000 58000 3742500 3745800 3300 3745800 3745800

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 1M: The general ledger of Jay Consulting shows the following balances at July 31: Jay has asked you to...

See similar textbooks

Similar questions

Using the ending balances shown in the Partial Adjusted Trial Balance listed below, what is the total dollar ($) balance for the accounts that have a normal credit balance? Fill in the blank with your calculated number. DO NOT include commas, $ signs, period, decimal points, etc., just enter the raw number. Webcourses will add commas to your answer automatically. For example, if you calculated the answer to be $24,123, you would only input: 24123 Partial Adjusted Trial Balance December 31, 20xx Accounts Normal Balance Cash 10,000 Accounts Receivable 5,000 Inventory 150,000 Sales Tax Payable 50,000 Accounts Payable 1,000 Deferred Revenue 10,000 Current Portion Long-term Debt 10,000 Long-term Debt Common Stock 50,000 25,000 Treasury Stock Retained Earnings 3,000 50,000 Dividends 5,000 20,000 Service Revenue Cost of Good Sold 5,000 Rent Expense 5.000 ASUS 13 f4 f5 f6 f7 E3 X f9 f10 f11 4. 5 6 9. C8 图 %24
The following is the six-column worksheet of the Drilon's Delivery Services prepared with errors. Analyze the given worksheet of the Drilon's Delivery Services for əril 2022. Answer the questions that follows Drilon's Delivery Services Worksheet For the month Ended April 30, 2021 Acct No. Particulars Trial Balance Balance Sheet 101 Cash on Hand 105 Cash in Bank Accounts 110 Receivable- Sheila Ocampo Accounts 115 Receivable- Diether Mendoza 120 Office Equipment Delivery 125 Equipment Accounts Payable- 201 David Carreal Accounts Payable- 205 Ronald Amparo Cecille Drilon, 301 Capital Cecille Drilon, 302 Drawings 401 Delivery Revenue 501 Delivery Expense Maintenance 505 Expense 510 Rent Expense 515 Utilities Expense Total Net Income/Net Loss Total Dr 1112500 1200000 145500 42000 300050 20000 58000 7000 60450 70000 11500 3077200 Cr Income Statement Dr Cr 14000 165000 2540000 308000 7000 60450 70000 11500 3077200 341000 341000 308000 308000 33000 341000 Dr 1112500 1200000 145500 42000 300050…
Select the letter of the item below that best matches the definitions that follow. a. Balance Sheet Standard report. b. To date c. Summary Balance Sheet report d. QuickZoom e. Transactions by Account report f. % of Column g. Memorizing a report h. Divided by 1000 1. ________ When selected in the Modify Report window, this check box requires QuickBooks Accountant to add a column representing the percentage of each item compared to total assets. 2. ________ When selected in the Modify Report window, this check box requires QuickBooks Accountant to round amounts to the nearest whole dollar. 3. ________ The start of the reporting period. 4. ________ A financial statement reporting in detail the assets, liabilities, and equities of a business as of a certain date. 5. ________ A process by which modified reports are saved for later use. 6. ________ When selected in the Modify Report window, this check box requires QuickBooks Accountant to report amounts in thousands. 7. ________ The end…
2) Use the information above to complete the Aging of Accounts Receivable Schedule below. Create a formula for cach age category, using the Excel IF and AND FUNCTIONS (fx) to determine wh customer amount belongs. The IF statement may include the following arguments: ,>=, <=, Excel AND FUNCTION (fx).
Requirement:a. Give all the necessary entries to correct the account on December 31, 2022. Write your entriesin a columnar paper.b. Using a T-Account, show the corrected balance of the delivery equipment by posting youradjusting entries.
help
Pls do the one that says “Enter the opening balances in the ledger accounts as at October 1, Write balance..” too with the send one using the templates Thank you!
Use T-Account to show and calculate: a) Balance for each account as WXY recorded at year end Dec. 31, 2020. b) Identify the incorrect JE c) Show Corrected Balance for each account, plus Gross Profit. d) Determine the overstatements and/or understatements that would result from the error, include Gross Profit.
complete the table by using 2 Data Tables. Given that the balance sheet is at May31,2020. There are options provided for the "Accounts" column in the second attachment , choose the most suitable 4 options among the 9 and write down its debit and credit.
What is the difference between a trial balance and a balance sheet?
Need asap
In the account below, calculate the balance for September 16, 20–. Then perform the forwarding procedures required to start a new account page. 3. Account: A/R – Manitoba Equipment Co. No. 211 Dater2021) PARTICULARS P.R. DEBIT CREDIT Dr/Cr BALANCE Aug 15 J22 1,600 00 Sep J26 825 00 16 J30 176 00 Ассount: No. Dater2021) PARTICULARS P.R. DEBIT CREDIT Dr/Cr BALANCE