Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

I just need help with my accounting exam, I have too many other finals to work.I just need it done by Wednesday evening 8:00PM Alaska time if possible, in excel format

1 answer below »
I just need help with my accounting exam, I have too many other finals to work.I just need it done by Wednesday evening 8:00PM Alaska time if possible, in excel format
Answered 1 days After Apr 25, 2021

Solution

Nitish Lath answered on Apr 27 2021
155 Votes
Trial Balance Work Sheet
            Unadjusted                Unadjusted                Adjusted                Post Closing
            11/30/18                2018                2018                2018
            Debit    Credit            Debit    Credit            Debit    Credit            Debit    Credit
    100    Wells Fargo Checking    35,818                13,492                3,492                3,492
    110    Accounts Receivable    9,233                15,118                15,118                15,118
    120    Prepaid Insurance    0                0                1,200                1,200
    150    Equipment    68,797                93,797                93,797                93,797
    155    Accumulated Depreciation        24,706                24,706                32,358                32,358
    160    Land    55,000                55,000                55,000                55,000
    200    Accounts Payable        1,601                3,249                3,249                3,249
    210    Wages Payable        0                0                1,348                1,348
    215    Payroll Taxes Payable        0                0                499                499
    220    Unearned Revenue        0                0                1,600                1,600
    250    Notes Payable        12,867                12,867                12,867                12,867
    300    Common Stock        10,000                10,000                10,000                10,000
    310    Additional Paid in Capital        80,000                80,000                80,000                80,000
    320    Retained Earnings        35,969                35,969                35,969                26,686
    350    Dividends    0                0                10,000
    400    Sales        213,734                223,484                221,884
    410    Discounts    3,274                3,467                3,467
    500    COGS - Materials    112,191                114,839                114,839
    600    Advertising    5,265                5,265                5,265
    615    Contract Labor    12,067                12,067                12,067
    620    Depreciation Expense    0                0                7,652
    625    Insurance    13,654                13,654                12,454
    630    Interest Expense    1,135                1,135                1,135
    635    Legal & Professional Fees    2,897                2,897                2,897
    640    Office Expense    2,976                2,976                2,976
    645    Rent    24,000                24,000                24,000
    650    Repairs & Maintenance    3,334                3,334                3,334
    655    Supplies    2,921                2,921                2,921
    660    Taxes & Licenses    1,250                1,250                1,250
    665    Meals & Entertainment    494                494                494
    670    Travel    1,159                1,159                1,159
    675    Utilities    10,216                10,216                10,216
    680    Wages    12,236                12,236                13,584
    685    Payroll taxes    996                996                1,495
    700    Interest Income        36                38                38
            378,913    378,913            390,313    390,313            399,812    399,812            168,606    168,606
Journal
    Journal Entries
    On 12/1/18 you complete a job for Fred and bill him $2,615
    terms 5/10 net 30
    12/1/18        Accounts receivable    2,615
            Sales        2,615
        to record sales on account
    On 12/2/18 you make a payment of $1,000 on an outstanding electric bill
    from the previous month. The bill was recorded as a payable last month.
    12/2/18        Accounts payable    1,000
            Cash        1,000
        to record sales on account
    On 12/4/18 you complete a job for Joe and bill him $1,615
    terms 5/10 net 30
    12/4/18        Accounts receivable    1,615
            Sales        1,615
        to record sales on account
    On 12/9/18 you receive...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here