Prepare the Trial Balance of Colorado Service Center at 30th April 2021 Template

User Generated

Gngvfnhevn

Business Finance

Question Description

I'm working on a accounting exercise and need support to help me learn.

Assignment Details:

Analyze and journalize 25 transactions, post to T accounts, and complete a trial balance. Complete the following spreadsheet: Recording Transactions.

Unformatted Attachment Preview

Recording Transactions – Solution NAME: _______________________________________________________________ The trial balance of Colorado Service Center on April 1, 2021, lists the entity’s assets, liabilities, and equity on that date. Requirements: 1. Open the following accounts, with the balances indicated, in the ledger of Colorado Services Center. Use the T-account format. Colorado Service Center Trial Balance April 1, 2021 Balance ACCOUNT DEBIT Cash $35,000 Equipment $17,500 Truck $29,000 Account Receivable $4,200 Account Payable $5,700 Harper, capital Total CREDIT $80,000 $85,700 $85,700 During March, the business engaged in the following transactions: a. Borrowed $49,000 from the bank and signed a notes payable in the name of the business b. Paid cash of $26,500 to acquire land c. Performed customer service and earned revenue on account, $5,560 d. Performed service for a customer and received cash of $5,800 e. Purchased supplies on account, $350 f. Paid $3,575 on accounts payable g. Paid cash expense for salaries ($4,500) and rent ($2,500); make a compound entry h. Received $3,300 on account i. Pays $900 in cash for a 3-month auto insurance j. Received a $255 utility bill that will be paid next week k. Harper withdrew cash of $5,575 l. Paid maintenance expense of $230 Page 1 of 7 2. Journalize each transaction. Key journal entries by transaction letter. Journal Entry ACCOUNT a. b. Cash Notes Payable Land Cash DEBIT 49,000 CREDIT 49,000 26,500 26,500 c. d. e. f. g. h. i. j. k. l. Page 2 of 7 3. Post the transaction to the ledger. Your general ledger cash balance uses a full ledger sheet; use the T Chart for all other accounts. Colorado Service Center General Ledger Account: Cash Account Number: 101 Balance Trans . 1 Description DEBIT Open Balance 35,000 49,000 2 a. Notes Payable 3 b. Land CREDIT DEBIT CREDIT 35,000 84,000 26,500 57,500 4 5 6 7 8 9 1 0 1 1 1 2 1 3 Equipment Bal Truck 17,500 Bal Bal . Bal. Accum. deprec. equipment Bal. Accum. deprec. truck 0 Bal . 0 Page 3 of 7 Accounts receivable Supplies Bal. Bal . Bal. Land b. Prepaid auto insurance 26,500 Bal . Bal. Accounts payable 900 Notes payable Bal. a. 49,000 Bal . Bal. Salary payable Bal. Utilities payable 0 Unearned service revenue Bal . Service revenue Page 4 of 7 Bal. 0 Bal . Harper, capital Harper, drawing Bal. Bal . Bal. Deprec. expense - equipment Bal. 0 Deprec. expense - truck Bal . Insurance expense 0 Rent expense . Bal. 0 Bal . Salary expense Supplies expense Bal . Bal. 0 Maintenance expense Bal. Utilities expense Bal . Page 5 of 7 4. Prepare the trial balance of Colorado Service Center at April 30, 2021. Trial Balance ACCOUNT DEBIT CREDIT Cash Equipment Truck Accum. deprec. equipment Accum. deprec. truck Accounts receivable Supplies Land Prepaid auto insurance Accounts payable Notes payable Salary payable Utilities payable Unearned Service Revenue Harper, capital Harper, drawing Service revenue Depreciation expense – Equip Depreciation expense – Truck Insurance expense Rent expense Salary expense Supplies expense Page 6 of 7 Maintenance expense Utilities expense Total Page 7 of 7 Recording Transactions – Solution NAME: _______________________________________________________________ The trial balance of Colorado Service Center on April 1, 2021, lists the entity’s assets, liabilities, and equity on that date. Requirements: 1. Open the following accounts, with the balances indicated, in the ledger of Colorado Services Center. Use the T-account format. Colorado Service Center Trial Balance April 1, 2021 Balance ACCOUNT DEBIT Cash $35,000 Equipment $17,500 Truck $29,000 Account Receivable $4,200 Account Payable $5,700 Harper, capital Total CREDIT $80,000 $85,700 $85,700 During March, the business engaged in the following transactions: a. Borrowed $49,000 from the bank and signed a notes payable in the name of the business b. Paid cash of $26,500 to acquire land c. Performed customer service and earned revenue on account, $5,560 d. Performed service for a customer and received cash of $5,800 e. Purchased supplies on account, $350 f. Paid $3,575 on accounts payable g. Paid cash expense for salaries ($4,500) and rent ($2,500); make a compound entry h. Received $3,300 on account i. Pays $900 in cash for a 3-month auto insurance j. Received a $255 utility bill that will be paid next week k. Harper withdrew cash of $5,575 l. Paid maintenance expense of $230 Page 1 of 7 2. Journalize each transaction. Key journal entries by transaction letter. Journal Entry ACCOUNT a. b. Cash Notes Payable Land Cash DEBIT 49,000 CREDIT 49,000 26,500 26,500 c. d. e. f. g. h. i. j. k. l. Page 2 of 7 3. Post the transaction to the ledger. Your general ledger cash balance uses a full ledger sheet; use the T Chart for all other accounts. Colorado Service Center General Ledger Account: Cash Account Number: 101 Balance Trans . 1 Description DEBIT Open Balance 35,000 49,000 2 a. Notes Payable 3 b. Land CREDIT DEBIT CREDIT 35,000 84,000 26,500 57,500 4 5 6 7 8 9 1 0 1 1 1 2 1 3 Equipment Bal Truck 17,500 Bal Bal . Bal. Accum. deprec. equipment Bal. Accum. deprec. truck 0 Bal . 0 Page 3 of 7 Accounts receivable Supplies Bal. Bal . Bal. Land b. Prepaid auto insurance 26,500 Bal . Bal. Accounts payable 900 Notes payable Bal. a. 49,000 Bal . Bal. Salary payable Bal. Utilities payable 0 Unearned service revenue Bal . Service revenue Page 4 of 7 Bal. 0 Bal . Harper, capital Harper, drawing Bal. Bal . Bal. Deprec. expense - equipment Bal. 0 Deprec. expense - truck Bal . Insurance expense 0 Rent expense . Bal. 0 Bal . Salary expense Supplies expense Bal . Bal. 0 Maintenance expense Bal. Utilities expense Bal . Page 5 of 7 4. Prepare the trial balance of Colorado Service Center at April 30, 2021. Trial Balance ACCOUNT DEBIT CREDIT Cash Equipment Truck Accum. deprec. equipment Accum. deprec. truck Accounts receivable Supplies Land Prepaid auto insurance Accounts payable Notes payable Salary payable Utilities payable Unearned Service Revenue Harper, capital Harper, drawing Service revenue Depreciation expense – Equip Depreciation expense – Truck Insurance expense Rent expense Salary expense Supplies expense Page 6 of 7 Maintenance expense Utilities expense Total Page 7 of 7 Recording Transactions – Solution NAME: ______________________________________________________ The trial balance of Colorado Service Center on April 1, 2021, lists the entity’s assets, liabilities, and equity on that date. Requirements: 1. Open the following accounts, with the balances indicated, in the ledger of Colorado Services Center. Use the T-account format. Colorado Service Center Trial Balance April 1, 2021 Balance ACCOUNT DEBIT Cash $35,000 Equipment $17,500 Truck $29,000 Account Receivable $4,200 Account Payable $5,700 Harper, capital Total CREDIT $80,000 $85,700 $85,700 During March, the business engaged in the following transactions: a. Borrowed $49,000 from the bank and signed a notes payable in the name of the business b. Paid cash of $26,500 to acquire land c. Performed customer service and earned revenue on account, $5,560 d. Performed service for a customer and received cash of $5,800 e. Purchased supplies on account, $350 f. Paid $3,575 on accounts payable g. Paid cash expense for salaries ($4,500) and rent ($2,500); make a compound entry h. Received $3,300 on account i. Pays $900 in cash for a 3-month auto insurance j. Received a $255 utility bill that will be paid next week k. Harper withdrew cash of $5,575 l. Paid maintenance expense of $230 Page 1 of 7 2. Journalize each transaction. Key journal entries by transaction letter. Journal Entry ACCOUNT a. b. Cash Notes Payable Land Cash DEBIT 49,000 CREDIT 49,000 26,500 26,500 c. d. e. f. g. h. i. j. k. l. Page 2 of 7 3. Post the transaction to the ledger. Your general ledger cash balance uses a full ledger sheet; use the T Chart for all other accounts. Colorado Service Center General Ledger Account: Cash Account Number: 101 Balance Trans . 1 Description DEBIT Open Balance 35,000 49,000 2 a. Notes Payable 3 b. Land CREDIT DEBIT CREDIT 35,000 84,000 26,500 57,500 4 5 6 7 8 9 1 0 1 1 1 2 1 3 Equipment Bal Truck 17,500 Bal Bal . Bal. Accum. deprec. equipment Bal. Accum. deprec. truck 0 Bal . 0 Page 3 of 7 Accounts receivable Supplies Bal. Bal . Bal. Land b. Prepaid auto insurance 26,500 Bal . Bal. Accounts payable 900 Notes payable Bal. a. 49,000 Bal . Bal. Salary payable Bal. Utilities payable 0 Unearned service revenue Bal . Service revenue Page 4 of 7 Bal. 0 Bal . Harper, capital Harper, drawing Bal. Bal . Bal. Deprec. expense - equipment Bal. 0 Deprec. expense - truck Bal . Insurance expense 0 Rent expense . Bal. 0 Bal . Salary expense Supplies expense Bal . Bal. 0 Maintenance expense Bal. Utilities expense Bal . Page 5 of 7 4. Prepare the trial balance of Colorado Service Center at April 30, 2021. Trial Balance ACCOUNT DEBIT CREDIT Cash Equipment Truck Accum. deprec. equipment Accum. deprec. truck Accounts receivable Supplies Land Prepaid auto insurance Accounts payable Notes payable Salary payable Utilities payable Unearned Service Revenue Harper, capital Harper, drawing Service revenue Depreciation expense – Equip Depreciation expense – Truck Insurance expense Rent expense Salary expense Supplies expense Page 6 of 7 Maintenance expense Utilities expense Total Page 7 of 7
Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Explanation & Answer

View attached explanation and answer. Let me know if you have any questions.

ACCT203 – IP2 – Recording Transactions – Solution

NAME: _______________________________________________________________
The trial balance of Colorado Service Center on April 1, 2021, lists the entity’s assets, liabilities, and
equity on that date.
Requirements:
1. Open the following accounts, with the balances indicated, in the ledger of Colorado
Services Center. Use the T-account format.
Colorado Service Center
Trial Balance
April 1, 2021
Balance

ACCOUNT

DEBIT

Cash

$35,000

Equipment

$17,500

Truck

$29,000

Account Receivable

$4,200

Account Payable

$5,700

Harper, capital
Total

CREDIT

$80,000
$85,700

$85,700

During March, the business engaged in the following transactions:
a. Borrowed $49,000 from the bank and signed a notes payable in the name of the business
b. Paid cash of $26,500 to acqu...

onorggnR (8702)
Cornell University

Anonymous
Just what I was looking for! Super helpful.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags