Tracking Commission Sales?

[Theoldbrickstore]

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.

[turboguy]

This is far from my field of expertise but to me it would be easier to do it in Access. If I am right then you could just import all your data.

[Harold Mansfield]

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.


So what kind of POS ( Point of sale) system are you using now? Many have add ons for all kinds of sales and retail structure. I agree that it's too cumbersome to do by hand.
When you say you "search" for a vendor, what are you searching in? What program?

[Paul]

Quickbooks has quite a few options for sorting vendors, salespersons, categories etc. You could probably manipulate the reports to accomplish what you need.

[BrandonL]

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.

Is the main problem adding everything up in Excel for the vendors? If everything would add up automatically for you for the vendors in Excel, do you have a problem continuing to enter the information manually into Excel? If you PM me your Excel file and tell me exactly what you want to do, maybe I can help you out.

Brandon