Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I can't figure out how to balance the credits and debits in my trial balance. I've made an error someplace, but I'm unable to identify

I can't figure out how to balance the credits and debits in my trial balance. I've made an error someplace, but I'm unable to identify it and then properly balance my trial balance. Below is everything I have up to my trial balance, with my trial balance being the last in the series of pages.

Company Information

Indiana Accounting Service Inc. is a public corporation that has been in business for 1 year. The IPO for the company authorized 100,000 shares of common stock at $1 par value. The company provides accounting services and sells accounting software.

To date the company has issued 20,000 shares of common stock, which are still outstanding. The issued shares were sold at $10 per share. A Building and Furnishings were purchased at the start of the year. The cost of the building was $150,000 and the cost of the furnishings was $30,000. The depreciation will be recorded annually. The estimated useful life of the building is 20 years with a residual value of $10,000 and uses the Straight line method. The estimated useful life of the furnishings is 5 years with a residual value of $2,500 and uses the DDB method. The current inventory consists of 30 units of software at a cost of $140.00 each. Inventory is cost using LIFO and the perpetual inventory system. The company uses an allowance method to account for uncollectible accounts. It is estimated that 1% of net credit revenue will be uncollectible, adjusted monthly. Employees are paid $2,500 salary twice a month, on the 16th for the first half of the month and on the 2nd of the following month for the last half of the month. Use the Calculations worksheet for calculations of Inventory record, Depreciation, and Uncollectible Accounts Expense. Ignore income tax calculations.

Project Requirements

Opening balances- The opening balances for select accounts are provided in the appropriate ledger accounts. All required ledger accounts are provided.

Record the following transactions in the journal. The journal is provided. Record explanation on the last line for each journal entry:

12/02/14- Purchased 10 Units of Software on Account for $1,300

12/02/14- Paid employees Salaries owed from November 16th-30th

12/02/14- Provided Accounting Service on Account, $3,200

12/05/14- Purchased Computer Equipment on Account, $4,800

Note: The equipment has an estimated useful life of 4 years, residual value of $50 and uses the DDB method.

12/08/14- Purchased Supplies for $950 cash

12/10/14- Received $3,000 payment on account

12/11/14- Sold 15 units of Inventory on Account, $4,500

12/11/14- Made payment on Account, $1,200

12/12/14- Purchased 20 units of Inventory on Account, $2,400

12/14/14- Paid for Advertising, $375

12/15/14- Provided Accounting service for Cash, $8,000

12/16/14- Paid employees salary for December 1st -15th

12/17/14- Provided Accounting Service on Account, $6,000

12/19/14- Sold 10 units of Inventory on Account, $3,000

12/22/14- Received $2,500 payment on Account

12/23/14- Made payment on Account, $2,800

12/24/14- Paid monthly Utility bills, $850

12/27/14- Received $2,000 cash in advance for Accounting service

12/29/43- Provided Accounting Service for Cash, $5,000

12/30/14- Issued 1,000 shares of Common Stock at $15 per share

12/31/14- Declared and paid dividends of $1.50 to outstanding shareholders as of 12/31/14.

Post to the ledger for each of the recorded journal entries. Reference each entry from the journal. Create formula for each ledger to calculate the appropriate balance.

Prepare a trial balance, using the worksheet, to verify that total debits equal total credits. Reference account balances from the ledger. Create formula to calculate all balances in the worksheet (requirement 4, 5, and 6).

Record the necessary adjustments in the worksheet, journal and post to the ledger for the following items:

12/31/14- Accrued employees salary for December 16th -31st

12/31/14- Depreciation on Building, use SL method (calculate for entire year)

12/31/14- Depreciation on Furnishings, use DDB method (calculate for entire year)

12/31/14- Depreciation on Computer Equipment, use DDB method (calculate for one month)

12/31/14- Supplies on hand equal $1,625

12/31/14- Inventory count shows 33 units, some damaged units were disposed of during the month

12/31/14- $500 of advance payment was earned in December

12/31/14- Uncollectible Account expense for December

Prepare an Adjusted trial balance, using the worksheet, to verify debits equal credits.

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribedimage text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribedimage text in transcribed

image text in transcribed

image text in transcribed

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

Students also viewed these Accounting questions