Answered step by step
Verified Expert Solution
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
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
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](https://s3.amazonaws.com/si.experts.images/answers/2024/07/66aa0884b8aa4_33266aa08845a3e1.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/66aa088550cb7_33266aa0884eb800.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/66aa0885f2a01_33366aa088592dcd.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
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](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started