Home  >  Community  >  The eBay Outlook  >  Excel Spreadsheet


<< previous topic post new topic post reply next topic >>
 wendywins
 
posted on January 27, 2005 09:12:18 PM
I've seen the ole' tax time chatter about spreadsheets and have finally gotten down to creating one for myself. The category headers are as follows:

Date
Ebay ID
Email
Total Purchase
Shipping charged
actual shipping cost
sales tax collected

My question is about the cost of the items and the packing materials. Should I just subtract cost of inventory from total sales at the end of the year? Same with packing supplies~ Add those onto actual shipping and subtract from shipping charged?

I sell only store items and average 12 items per buyer if this makes a difference.

Also, can I search through an Excel spreadsheet by email or Ebay ID, for example or is that a completely different program I should be using?

Wendywins

 
 Gtootie
 
posted on January 28, 2005 07:39:50 AM
My advise is to see a tax professional. I worked for a CPA for years and the biggest problems resulted from people who listened to friends or took bad advise. Then when things were in a big mess, decided to find a CPA.

Every situation is different. Good advise is based on your whole financial picture. If you start out right you can go with an accountant or tax preparer. Once you get things in a mess, you have to shell out the big bucks to fix it.

Asking those questions here will get you a dozen different answers. And based on your questions, you need to sit down with someone face to face and let them explain some basics.






Be kind. Everyone is fighting their own secret battles.
...Author Unknown
 
 katiyana
 
posted on January 28, 2005 09:39:27 AM
I expense cost of goods sold at the time the item is sold all year long.

Mailing supplies I keep in inventory and bring them out in lots of 10-20 and expense them at that time.



 
 wendywins
 
posted on January 28, 2005 10:12:05 AM
Thanks guys!

I have an appt. with a bookkeeper but wanted to get things more organized than the binders I have everything in.

Kinda like cleaning the house before the maid comes.



 
 stonecold613
 
posted on January 28, 2005 09:39:44 PM
Keep the costs of shipping, supplies, listing fees and so on separate from our income. You adviser will explain why. Also be sure to keep accurate monthly records of them.
.
.
.
Alive in 2005
 
 
<< previous topic post new topic post reply next topic >>

Jump to

All content © 1998-2026  Vendio all rights reserved. Vendio Services, Inc.™, Simply Powerful eCommerce, Smart Services for Smart Sellers, Buy Anywhere. Sell Anywhere. Start Here.™ and The Complete Auction Management Solution™ are trademarks of Vendio. Auction slogans and artwork are copyrights © of their respective owners. Vendio accepts no liability for the views or information presented here.

The Vendio free online store builder is easy to use and includes a free shopping cart to help you can get started in minutes!