can you please help me provide a 10- column worksheet as at December 31 The following account balances appeared in the general ledger of Dr. Robin Rubio at the end ofDecember 2009, the second year of his private medical practice:CashP350,403205,0007,55011,500155,00015,500Accounts ReceivableAllowance for Bad DebtsPrepaid SuppliesLibraryAccumulated Depreciation-LibraryMedical EquipmentAccumulated Depreciation-Medical EquipmentLoans PayableAccounts PayableSS and EC Premiums PayableHDMF Premiums PayablePhilHealth Premiums PayableWithholding Taxes PayableRubio, Capital96,0002,000200,00018,00020010075427180,65042,000729,0001,100Rubio, PersonalMedical Fees EarnedHDMF Premium ExpensePhilHealth Premium ExpenseSalaries ExpenseRent ExpenseSS and EC Premium Expense82572,000110,0004,9749,00075,70020,000Taxes and LicensesUtilities ExpenseInterest ExpenseData for adjustments follows:

Worksheet is 10 column sheet being prepared in business in order to first review unadjusted general…

Answered: can you please help me provide a 10-…

Business

Accounting

can you please help me provide a 10- column worksheet as at December 31

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Prepare the journal entries for the following transactions, provided the chart accounts below: DATE:APRIL 2022TransactionsApril 01 -Completion of a denture worth 6,000 April 02 - Received 7,000 in total from appointed patients for the whole dayApril 03 -received 7,000 in total from appointed patients for the whole dayApril 04 -received 2,500 in total from appointed patientsApril 05- paid 36,000 for car loan for business/personal useApril 06- received 1,500 from one patient that dayApril 07 -received 3,000 from appointed patients that dayApril 08- purchased dental supplies, 4,500April 09- received 4,000 from appointed patients April 10-received 3,000 in total from appointed patients April 11-received 1,500 from one patient that dayApril 12-paid 10,000 for dental laboratory feeApril 13-received 20,000 from a prosthodontic caseApril 15-paid 13,000 for a lot for future investment/businessApril 15 -paid 7,500 for dental assistantApril 16-received 2500 in total from appointed patientsApril…
List and record each transaction (in 000s) for the Claymont Outpatient Clinic, under the accrual basis of accounting, at December 31, 20X1. You are creating a General Ledger using exhibit 3-6 on page 112 as a guide. Zelman( Workbook) a. The clinic received a $10,000,000 unrestricted cash contribution from the community. b. The clinic purchased $4,500,000 of equipment using cash. c. The clinic borrowed $2,000,000 from the bank on a long-term basis. d. The clinic purchased $550,000 of supplies on credit. e. The clinic provided $8,400,000 of services on credit. f. In the provision of these services, the clinic used $420,000 of supplies. g. The clinic received $800,000 in advance to care for capitated patients. h. The clinic incurred $4,500,000 in labor expenses and paid cash for them. i. The clinic incurred $2,230,000 in general expenses and paid cash for them. j. The clinic received $6,000,000 from patients and their 3rd party payers in payment of outstanding accounts. k.…
Below is the trial balance which was extracted from the books of the Ready Hospital Supplies on June 30, the end of the company’s financial year. You are required to collaborate and analyse the problem at hand then apply the accrual basis of accounting in the preparation of the company’s financial statements. Ready Hospital Supplies Trial Balance as at June 30, 2020 Dr $ Cr $ Cash 127,000.00 Accounts Receivable 151,000.00 Allowance for Bad-Debts 12,500.00 Merchandise Inventory 187,500.00 Store Supplies 58,000.00 Prepaid Insurance 72,000.00 Prepaid Rent 56,000.00 Furniture & Fixtures 800,000.00 Accumulated Depreciation: Furniture & Fixtures 256,000.00 Computer Equipment 450,000.00 Accumulated Depreciation: Computer Equipment Accounts Payable 133,500.00 Salaries Payable Interest Payable 27,000.00…
Create a balance sheet (in 000s) as of December 31, 20X1 for the Claymont Outpatient Clinic using the General Ledger transactions below. You will enter balances for total current assets a. The clinic received a $10,000,000 unrestricted cash contribution from the community. b. The clinic purchased $4,500,000 of equipment using cash. c. The clinic borrowed $2,000,000 from the bank on a long-term basis. d. The clinic purchased $550,000 of supplies on credit. e. The clinic provided $8,400,000 of services on credit. f. In the provision of these services, the clinic used $420,000 of supplies. g. The clinic received $800,000 in advance to care for capitated patients. h. The clinic incurred $4,500,000 in labor expenses and paid cash for them. i. The clinic incurred $2,230,000 in general expenses and paid cash for them. j. The clinic received $6,000,000 from patients and their 3rd party payers in payment of outstanding accounts. k. The clinic met $440,000 of its obligation to…
Susan Wilson, M.D., maintains the accounting records of Wilson Clinic on a cash basis. During 2020, Dr. Wilson collected $155,992 from her patients and paid $60,414 in expenses. At January 1, 2020, and December 31, 2020, she had accounts receivable, unearned service revenue, accrued expenses, and prepaid expenses as follows. (All long-lived assets are rented.) January 1, 2020 December 31, 2020 Accounts receivable $8,733 $17,087 Unearned service revenue 2,669 4,464 Accrued expenses 3,096 2,024 Prepaid expenses 2,035 2,924 Prepare a schedule that converts Dr. Wilson's "excess of cash collected over cash disbursed" for the year 2020 to net income on an accrual basis for the year 2020.
A provider of health insurance received payment of $24,000 cash from a customer for insurance coverage for the next two years. Recording the receipt of this cash will require which of the following? O a. A liabiity to be debited, an asset to be credited Ob An asset to be debited, capital to be credited Oc. An asset to be debited, a liability to be credited Od. Withdrawals to be debited. an asset to be credted Hel 10:06 AN 11/3/202 POCOPHONE SHOT ON POCOPHONE F1
Jill Accardo, M.D., maintains the accounting records of Accardo Clinic on a cash basis. During 2020, Dr. Accardo collected $142,600 from her patients and paid $55,470 in expenses. At January 1, 2020, and December 31, 2020, she had accounts receivable, unearned service revenue, accrued expenses, and prepaid expenses as follows. (All long-lived assets are rented.) January 1, 2020 December 31, 2020 Accounts receivable $9,250 $15,927 Unearned service revenue 2,840 4,111 Accrued expenses 3,435 2,108 Prepaid expenses 1,917 3,232 Instructions Prepare a schedule that converts Dr. Accardo’s “excess of cash collected over cash disbursed” for the year 2020 to net income on an accrual basis for the year 2020.
Lee Harris, MD, had the following balances in the ledger for his medical practice: Cash $8,830, Accounts Receivable$2,665, Supplies $565, Equiprment $15,650, Notes Payable $10,250, Accounts Payable $800. L. Harris, Capital $15,000, L. Harris,Drawings $5,180, Service Revenue $ 10.530, Rent Expense $1,220, and Salaries Expense $2,470. in July 31 and in august create a trial balance for august.
Lee Harris, MD, had the following balances in the ledger for his medical practice: Cash $8,830, Accounts Receivable$2,665, Supplies $565, Equiprment $15,650, Notes Payable $10,250, Accounts Payable $800. L. Harris, Capital $15,000, L. Harris,Drawings $5,180, Service Revenue $ 10.530, Rent Expense $1,220, and Salaries Expense $2,470. inJuly 31 and in augest the account is Date Account TitlesDebit Credit2024Aug.1 Rent Expense1,220Cash1,22010 Accounts Payable440Cash44012 Cash2,120Accounts Receivable2,12025 Salaries Expense2,470Cash2,47030 Notes Payable470Interest Expense35Cash50531 Cash 5,890Accounts Receivable2,750Service Revenue8,64031 L Harris, Drawings4,520Cash4,520 Post the transactions to the T accounts.
Francis Mayberry, M.D., maintains the accounting records of Mayberry Clinic on a cash basis. During 2020, Dr. Mayberry collected $134,269 from her patients and paid $50,926 in expenses. At January 1, 2020, and December 31, 2020, she had accounts receivable, unearned service revenue, accrued expenses, and prepaid expenses as follows. (All long-lived assets are rented.) January 1, 2020 December 31, 2020 Accounts receivable $8,768 $14,914 Unearned service revenue 2,908 3,733 Accrued expenses 3,444 2,049 Prepaid expenses 1,835 3,239 Prepare a schedule that converts Dr. Mayberry’s "excess of cash collected over cash disbursed" for the year 2020 to net income on an accrual basis for the year 2020.
The following needs to entered in the copied spreadshet. 2. The following transactions occurred during the year. Record these transactions.HHL took out a long-term loan for $3 million.HHL purchased $1 million in inventory with cash.HHL purchased equipment that cost $150,000 on account. The equipment is expected to last 15 years and has no salvage value.$540,865,000 (net of allowances and charity care) was billed for patient services. The hospital estimates that 5% of these bills will be bad debt.$875,000 of inventory was used.Donations of $400,000 were received in cash.HHL pays in cash for a 2-year malpractice insurance premium at a cost of $5 million. One-half of the premium is for next year, and the other is for the following year.HHL pays $12,560,000 in accounts payable.HHL workers earned $259 million in wages for the year. The hospital paid out $282 million in cash. It also paid out $60 million in benefits, all in cash.The equipment purchased in transaction c was paid for in…
Lisa Anderson, M.D., maintains the accounting records of Anderson Clinic on a cash basis. During 2020, Dr. Anderson collected $141,493 from her patients and paid $54,018 in expenses. At January 1, 2020, and December 31, 2020, she had accounts receivable, unearned service revenue, accrued expenses, and prepaid expenses as follows. (All long-lived assets are rented.) Accounts receivable Unearned service revenue Accrued expenses Prepaid expenses January 1, 2020 $9,027 2,836 3,139 1,927 December 31, 2020 $15,442 4,472 1,985 3,411 Prepare a schedule that converts Dr. Anderson's "excess of cash collected over cash disbursed" for the year 2020 to net income on an accrual basis for the year 2020. LISA ANDERSON, M.D. Conversion of Cash Basis to Accrual Basis