PDA

View Full Version : Jim Arnolds's Photography Studio 10 column worksheet


jfulton1
Sep 29, 2012, 08:52 AM
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

paraclete
Sep 29, 2012, 05:08 PM
! 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