Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

HELPP PLEASEE!!!step 1: Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file Accounting Cycle Excel Template.xlsx.

HELPP PLEASEE!!!step 1: Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file "Accounting Cycle Excel Template.xlsx". Use the following accounts as appropriate: Dec 1: Dec 1: Dec 1: Dec 5: Dec 15: Dec 16: Dec 17: Dec 22: Dec 23: Dec 25: Cash Accounts Receivable Supplies Prepaid Insurance Equipment Land Accumulated Depreciation Accounts Payable Deferred Revenue Salaries Payable Notes Payable Common Stock Retained Earnings Dividends Service Revenue Issued common stock for $7,000 cash. Paid $960 in advance for a one-year insurance policy. Purchased equipment for $3,600 cash. Purchased supplies for $400 on account from XYZ Company. Provided services to customers for $7,800 cash. Provided services to customer ABC Inc. on account for $6,100. Depreciation Expense Salaries Expense Supplies Expense Rent Expense Insurance Expense Received cash of $2,000 in advance from customers for services to be provided in January. Paid $220 to XYZ company for the Dec 5 purchase on account. Received $2,700 cash from customer ABC Inc., on account related to the Dec 16 transaction. Daid $1 100 rent for the current month
image text in transcribed
image text in transcribed
image text in transcribed
tep 1: Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file "Accounting Cycle Excel Template.xlsx". Use the following accounts as appropriate: 5: Record the December adjusting entries on the 'General Journal" tab. Dec 31: One month insurance has been used. Dec 31: Supplies remaining at the end of the month total $90. Dec 31: The estimated depreciation on equipment is $60. Dec 31: Salaries incurred from December 29 to December 31 but not yet paid or recorded total $450 6: Post all of the adjusting entries to the T-accounts under the "T-Accounts/General Ledger" tab. Compute 1 for each T-account after all of the adjusting entries have been posted. 7: Prepare the adjusted trial balance under the "Adjusted Trial Balance" tab as of December 31 in the excel "Accounting Cycle Excel Template.xlsx". ck point 1: Adjusted trial balance total debit/credit =$31,590 ide the following amounts from the Adjusted Trial Balance: (Be sure to enter all numbers as positive and no an ik.) Zash Dec 25: Paid \$1,100 rent for the current month. Dec 28: Paid salaries to employees $4,200 for work performed from Dec 1 to Dec 28. Dec 29: Declared and paid cash dividends of $250 to stockholders. Dec 30: Purchased land by signing a long-term note for $8,000. Post all of the transactions from the "General Journal" tab to the T-accounts under the "T- Step 2: Accounts/General Ledger" tab in the excel template file "Accounting Cycle Excel Template.xlsx". Assume there are no beginning balances in any of the accounts. Step 3: Compute the unadjusted balance for each T-account after all of the December entries have been p Step 4: Prepare the unadjusted trial balance on the "Unadjusted Trial Balance" tab. 1. Provide the total of the credit column from the Unadjusted Trial Balance A Step 5: Record the December adjusting entries on the "General Journal" tab. Dec 31: One month insurance has been used. Dec 31: Supplies remaining at the end of the month total $90

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started