Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=19)
-   -   Jim Arnolds's Photography Studio 10 column worksheet (https://www.askmehelpdesk.com/showthread.php?t=705716)

  • Sep 29, 2012, 08:52 AM
    jfulton1
    Jim Arnolds's Photography Studio 10 column worksheet
    Need to know in which columns the accounts should be in entered?

    My unadjusted trial balance is not adjusting. Below is what I need to post and I have attached my file please help.
    July
    1 Jim invested 40,000 cash and photography equipment valued at 20,000 in the business.

    1 Purchased office supplies for cash 1,300

    1 Purchased photography supplies on account 6,700
    1 Paid July rent 1,700

    1 Paid for newspaper ad 500

    2 Purchased Office equipment on account 6,750

    2 Paid property insurance for the upcoming year 3,600

    3 purchased a computer system and software, 3,200, notes payable
    5 Paid for promotional handouts 150
    6 Paid miscellaneous expenses 175

    7 Paid salaries of employees 1,400
    7 Recorded weeks cash receipts for photo work 1,350
    8 Paid for carpet cleaning Msc expense 75
    9 Recorded phot0 work done on account 855
    9 Purchased additional Photography supplies on account 3,200
    10 Purchased additional Photography Equipment for cash3,500
    10 Vending Machine Revenue 200
    11 Purchased Furniture for the lobby 1,700 in cash
    12 Paid cash for overhead lighting 900
    15 Recorded cash receipts 2,170
    15 Paid salaries 1,400
    17 Drawing for 800
    18 Paid for TV ad 710
    19 Paid for repair to equip 80
    19 Collected 500 on account for service
    22 Paid salaries 1,400
    22 Recorded cash receipts 2,045
    23 Photo session on credit 550
    28 Recorded cash receipts 1,995
    29 Paid salaries 1,400
    30 Paid water bill 75
    30 Paid electric bill 1,095
    31 Made a 500 payment on office equipment note on 3rd
    31 Made 2,000 payment on office equipment purchased
    31 Made a payment on photography supplies on account 1,000
    31 Drawing 310
    31 Vending machine revenue 80




    A) Office supplies on hand 850
    B) Photography supplies on hand 5,550
    C) Insurance expired, 300
    D) Salaries unpaid for 2 days 1400
    E) Depreciation of office equipment 190
    F) Depreciation of photography equip 275
    G) Depreciation of furniture and fixtures 75
  • Sep 29, 2012, 05:08 PM
    paraclete
    ! I see no attachments

    The worksheet you need will have columns for the original debit and credit balances, columns for adjustments, journal entries, etc and balance columns. In one column you will have the names of the accounts It is apparent what you have is a cash book and you will need to convert the entries in this to ledger balances before making the period end adjustments and drafting the financial statements

  • All times are GMT -7. The time now is 04:25 PM.