Question

In: Accounting

Worksheet complete through the Trial Balance. March Journal Entries 1-Mar Accounts Receivable 3450 Sales Revenue                   &nbs

Worksheet complete through the Trial Balance.

March Journal Entries

1-Mar

Accounts Receivable

3450

Sales Revenue

                    3,450

Cost of Goods Sold

1450

Inventory

                    1,450

3-Mar

Inventory

2800

Accounts Payable

                    2,800

15-Mar

Accounts Receivable

3750

Sales Revenue

                    3,750

Cost of Goods Sold

1950

Inventory

                    1,950

20-Mar

Inventory

2000

Accounts Payable

                    2,000

24-Mar

Accounts Receivable

4900

Sales Revenue

                    4,900

Cost of Goods Sold

2600

Inventory

                    2,600

                                                                                      

#NAME?

PARTIALLY ADJUSTED TRIAL BALANCE

March 31 2018

Part Adj T/B

March Jes

Trial

Balance

DR

CR

DR

CR

DR

CR

Cash

$253,560

Accounts Receivable

146,800

12,100

Allowance for Uncollectible Accounts

$2,569

Supplies

85,650

Inventory

2,600

         3,000

Prepaid Insurance

16,800

Land

50,000

Building

125,500

Accumulated Depr – Building

5,670

Computer equipment

52,950

Accumulated Depr – Comp Equip

1,750

Office Furniture

       85,960

Accumulated Depr - Office Furniture

890

Accounts Payable

48,526

Interest Payable

         3,200

Utilities Payable

8,952

Wages Payable

98,505

Long term Note Payable

90,000

Mortgage Payable

60,000

Common Stock

400,000

Retained Earnings

106,468

Dividends

         4,000

Service Revenue

345,650

Tablet Sales Revenue

210,250

Cost of Goods Sold

165,850

6,000

Bad Debt Expense

Depreciation Expense – Building

1,350

Depreciation Expense - Computer Equip

890

Depreciation Expense - Office Furn

650

Interest Expense

3560

Insurance Expense

38,950

Supplies expense

72,860

Bank fee (expense)

Utilities Expense

75,900

Wage Expense

198,600

Solutions

Expert Solution

  • The incomplete Trial balance has been completed in entirely:

PARTIALLY ADJUSTED TRIAL BALANCE

March 31 2018

Part Adj T/B

March Jes

Final Adjusted Trial balance

DR

CR

DR

CR

DR

CR

Cash

$    2,53,560.00

$      2,53,560.00

Accounts Receivable

$    1,46,800.00

$     12,100.00

$      1,58,900.00

Allowance for Uncollectible Accounts

$                  2,569.00

$            2,569.00

Supplies

$        85,650.00

$         85,650.00

Inventory

$          2,600.00

$       4,800.00

$           6,000.00

$            1,400.00

Prepaid Insurance

$        16,800.00

$          16,800.00

Land

$        50,000.00

$          50,000.00

Building

$    1,25,500.00

$      1,25,500.00

Accumulated Depr – Building

$                  5,670.00

$            5,670.00

Computer equipment

$        52,950.00

$          52,950.00

Accumulated Depr – Comp Equip

$                  1,750.00

$            1,750.00

Office Furniture

$        85,960.00

$          85,960.00

Accumulated Depr - Office Furniture

$                      890.00

$               890.00

Accounts Payable

$                48,526.00

$           4,800.00

$         53,326.00

Interest Payable

$                  3,200.00

$            3,200.00

Utilities Payable

$                  8,952.00

$            8,952.00

Wages Payable

$                98,505.00

$         98,505.00

Long term Note Payable

$                90,000.00

$         90,000.00

Mortgage Payable

$                60,000.00

$         60,000.00

Common Stock

$            4,00,000.00

$      4,00,000.00

Retained Earnings

$            1,06,468.00

$      1,06,468.00

Dividends

$          4,000.00

$            4,000.00

Service Revenue

$            3,45,650.00

$      3,45,650.00

Tablet Sales Revenue

$            2,10,250.00

$         12,100.00

$      2,22,350.00

Cost of Goods Sold

$    1,65,850.00

$       6,000.00

$      1,71,850.00

Bad Debt Expense

$                         -  

Depreciation Expense – Building

$          1,350.00

$            1,350.00

Depreciation Expense - Computer Equip

$              890.00

$                890.00

Depreciation Expense - Office Furn

$              650.00

$                650.00

Interest Expense

$          3,560.00

$            3,560.00

Insurance Expense

$        38,950.00

$          38,950.00

Supplies expense

$        72,860.00

$          72,860.00

Bank fee (expense)

$                         -  

Utilities Expense

$        75,900.00

$          75,900.00

Wage Expense

$    1,98,600.00

$      1,98,600.00

TOTAL

$ 13,82,430.00

$          13,82,430.00

$     22,900.00

$         22,900.00

$    13,99,330.00

$   13,99,330.00


Related Solutions

Using the adjusting journal entries,Complete the adjusted trial balance columns, Complete the income statement and balance...
Using the adjusting journal entries,Complete the adjusted trial balance columns, Complete the income statement and balance sheet columns in the worksheet as well using only formulas. Grizzlies, Inc. Worksheet For the Year Ended December 31, 2017 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Income Stmt Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr. Cash        36,000 Accounts Receivable      277,000 Inventory      242,500 Prepaid Insurance        11,200 Prepaid Rent          3,000 Store Supplies               ...
1. Prepare the journal entries, T accounts and Trial Balance 2. Prepare Income Statement and Balance...
1. Prepare the journal entries, T accounts and Trial Balance 2. Prepare Income Statement and Balance Sheet Johan Johari began professional practice as a system analyst on July 1, 2019. He plans to prepare a monthly financial statement. During the month of July, Johan Johari completed the transactions as follows: July 1. Johan invested RM500,000 cash along with computer equipment that had a market value of RM120,000 two years ago but was now worth RM 100,000 only. July 2. Paid...
Prepare journal entries for the following transactions that occurred during March​: 201X Mar. 1 Jemma Underwood...
Prepare journal entries for the following transactions that occurred during March​: 201X Mar. 1 Jemma Underwood invested $70,000 cash and $9,000 of equipment into her new business. 3 Purchased building for $80,000 on account. 12 Purchased a truck from Littleton Co. for $11,000 cash. 18 Bought supplies from McNeil Co. on​ account, $900. Journalize the transactions in the general journal. ​
Prepare Journal Entries, Ledger, T- Accounts, Trial Balance, Income Statement, and Balance Sheet The following are...
Prepare Journal Entries, Ledger, T- Accounts, Trial Balance, Income Statement, and Balance Sheet The following are transactions of Samantha Payapag Advertising Company for the month of July 2013 July 3 Samantha Payapag invested 500,000 in the business. July 5 Bought for cash, advertising supplies costing 80,000. Paid rental of the office, 7,300 July 9 Bought delivery truck from MJ Idos Trading, 350,000 on credit July 12 Received 43,000 cash as advertising income July 13 Bought furniture & fixtures, 32,000 in...
A list of nine accounts receivable balance-related audit objectives: 1. Accounts receivable in the aged trial...
A list of nine accounts receivable balance-related audit objectives: 1. Accounts receivable in the aged trial balance agree with related master file amounts, and the total is correctly added and agrees with the general ledger. 2. Recorded accounts receivable exist. 3. Existing accounts receivable are included. 4. Accounts receivable are accurate. 5. Accounts receivable are properly classified. 6. Cutoff for accounts receivable is correct. 7. Accounts receivable is stated at realizable value. 8. The client has rights to accounts receivable....
Prepare each item: Journal Entries T-Accounts Trial Balance Adjusted Trial Balance Income Statement Retained Earnings Statement...
Prepare each item: Journal Entries T-Accounts Trial Balance Adjusted Trial Balance Income Statement Retained Earnings Statement Balance Sheet Dinah Soars, Biff Wellington and Duane Pipe are the stockholders of Sharpe Incorporated. The charter of the corporation authorized 500,000 shares of $2 par common stock, and 100,000 shares of $30 par, 4%, preferred stock. As of January 1, 2020, there were 24,000 shares of common stock issued and outstanding and 5,000 shares of preferred stock issued and outstanding. Selected transactions completed...
Option #1: Preparing Adjusting Entries in a Worksheet Following is the unadjusted trial balance of Skylar...
Option #1: Preparing Adjusting Entries in a Worksheet Following is the unadjusted trial balance of Skylar Gaming, Inc. at the end of its first year of operations, December 31, 20x7: Account Name DR. CR. Cash $71,550 Accounts Receivable $25,200 Supplies $550 Prepaid Insurance $12,000 Equipment $31,750 Accumulated Depreciation-Equipment $4,050 Accounts Payable $6,700 Salaries Payable $0 Unearned Revenue $2,200 Common Stock $45,700 Retained Earnings $23,850 Dividends $3,500 Revenue $80,750 Depreciation Expense-Equipment $2,000 Salaries Expense $4,750 Insurance Expense $3,100 Rent Expense $4,200...
Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and...
Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and balance sheet included with the data below. Also, create a pivot table. Create a general ledger, worksheet, income statement, changes in retained earnings, and balance sheet with the data below. June 1: Hudson Bloom invested $105,273.00 cash and computer equipment with a fair market value of $32,970.00 in his new business, Byte of Accounting. June 1:   Check # 5000 was used to purchased office...
The trial balance columns of the worksheet for Bramble Roofing at March 31, 2022, are as...
The trial balance columns of the worksheet for Bramble Roofing at March 31, 2022, are as follows. Bramble Roofing Worksheet For the Month Ended March 31, 2022 Trial Balance Account Titles Dr. Cr. Cash 4,800 Accounts Receivable 3,300 Supplies 2,000 Equipment 11,264 Accumulated Depreciation—Equipment 1,280 Accounts Payable 2,300 Unearned Service Revenue 400 Common Stock 10,584 Retained Earnings 3,000 Dividends 1,200 Service Revenue 6,500 Salaries and Wages Expense 1,200 Miscellaneous Expense 300    24,064 24,064 Other data: 1. A physical count...
​(Pro forma accounts receivable balance calculation​) The accounts receivable for Pastors Brewing Company on March ​...
​(Pro forma accounts receivable balance calculation​) The accounts receivable for Pastors Brewing Company on March ​ 31, 2016 was ​$23,000. Firm sales are roughly evenly split between credit and cash​ sales, with 40 percent of the credit sales collected in the month after the sale and the remainder 2 months after the sale. Historical and projected sales for the brewing company are given​ here: MONTH SALES MONTH SALES         January ​$19,000 March ​$31,000       February ​$25,000 April​ (projected) ​$35,000       . a. Under...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT