I need help with COLO Company excel!!!


Sweetness , Tuesday, 17th of August 2010 06:06:43 PM

COLO COMPANY
Inv. No.Check
DateDescriptionNameor 
Sweetness
DateNo.TermsAmount
May1Paid rent (80% selling space, 20% office 
Registered User
space)S&P Management Co.3410 $3,710
2Sold merchandise on credit 
Joined: Friday, 11th of June 2010, 11:06:58
(cost $4,100)Hensel Company87852/10, n/60 6,100
2Issued credit memo 
Posts: 842
on returned merch.Knox, Inc. Apr. 28175
Total selling price 
Viewed 15193 times
(gross)Knox, Inc. Apr. 284,725
3Received credit memo on returned 
merch.Peyton Products Apr. 29798
4Purchased merchandise on 
creditGear Supply Co. May 4 n/10 EOM 37,072
Purchased store supplies 
on creditGear Supply Co. May 4 n/10 EOM 574
Purchased office supplies 
on creditGear Supply Co. May 4 n/10 EOM 83
5Received payment less 
discount and returnKnox, Inc. Apr. 28?
8Paid inv. less 2 % discount 
and May 3 returnPeyton Products Apr. 29 3411 ?
9Sold store supplies 
for cash at cost 350
10Purchased office equipment on creditGear 
Supply Co. May 10 n/10 EOM 4,074
11Received payment less 
discountHensel Company May 2?
11Purchased merchandise on 
creditGarcia, Inc. May 10 2/10, n/60 8,800
12Received credit memo on 
returned merch.Gear Supply Co. May 10854
15Check issued for sales 
salariesPayroll3412 5,320
Check issued for office 
salariesPayroll3412 3,150
15Cash sales for first half of month (cost 
$38,200) 59,220
16Sold merchandise on credit (cost $1,890)Hensel 
Company87862/10, n/60 3,990
17Purchased merchandise on creditFink 
Corp. May 14 2/10, n/60 13,650
19Paid invoice less discountGarcia, 
Inc. May 10 3413
22Sold merchandise on credit (cost $4,990)Lee 
Services87872/10, n/60 6,850
23Paid invoice less discountFink Corp. 
May 14 3414 ?
24Purchased merchandise on creditGear Supply Co. May 
23 n/10 EOM 8,120
Purchased store supplies on creditGear Supply Co. 
May 23 n/10 EOM 630
Purchased office supplies on creditGear Supply 
Co. May 23 n/10 EOM 280
25Purchased merchandise on creditPeyton 
Products May 23 2/10, n/30 3,080
26Sold merchandise on credit (cost 
$8,230)Crane Corp.87882/10, n/60 14,210
26Paid April electric 
billPerennial Power3415 1,283
29Issued check to owner for personal 
useJenny Colo3416 7,000
30Received payment less discountLee Services 
May 22?
30Check issued for sales salariesPayroll3417 5,320 />Check issued for office salariesPayroll3417 3,150
31Cash sales for 
second half of month (cost $42,500) 66,052

Additional 
information:
a. Expired insurance$553
b. Ending store supplies 
inventory 2,632
c. Ending office supplies inventory 504
d. 
Estimated depreciation of store equipment 567
e. Estimated 
depreciation of office equipment 329


*Could you send me 
the finalized excel sheet???*
Thanks!
 
 
 
 
 

tweety bear , Wednesday, 18th of August 2010 08:53:32 PM

The notes at the link will be useful to you.  
tweety bear
 
Registered User
 
Joined: Sunday, 2nd of May 2010, 00:40:38
 
Posts: 1235
 
Viewed 12090 times
 



Who is online

Users browsing this forum: 4 guests