We recently took over an huge antique shop with thousands of items with tags saying who they belong too and the price. We get 30% commission for every item we sell. I was wondering how in the world we keep track of daily sales and then add up what each vendor made to send them their cut.
Right now our system is to write the vendor abbreviation (aka jk or pb) and item description and price on a piece of paper with the tag taped to it. Then we transfer that information to excel. Problem is, at the end of the month, we search one vendor to add it all up and it does show all that vendor sold. It also is not summing the total vendor sales. Does anyone have an easier suggestion for this kind of system? It is the end of the month and HOURS upon HOURS is being spent adding the tags, then double checking with Excel, then triple checking before finally coming up with the correct number for ONE vendor.
Right now our system is to write the vendor abbreviation (aka jk or pb) and item description and price on a piece of paper with the tag taped to it. Then we transfer that information to excel. Problem is, at the end of the month, we search one vendor to add it all up and it does show all that vendor sold. It also is not summing the total vendor sales. Does anyone have an easier suggestion for this kind of system? It is the end of the month and HOURS upon HOURS is being spent adding the tags, then double checking with Excel, then triple checking before finally coming up with the correct number for ONE vendor.
Aucun commentaire:
Enregistrer un commentaire